CREATE TABLE [dbo].[geo] (
    [geo_key]       INT            NOT NULL,
    [suburb_key]    INT            NULL,
    [suburb_name]   NVARCHAR (100) NULL,
    [city_key]      INT            NOT NULL,
    [city_name]     NVARCHAR (100) NOT NULL,
    [province_key]  INT            NULL,
    [province_name] NVARCHAR (100) NULL,
    [post_code]     CHAR (4)       NOT NULL,
    [postal_ind]    VARCHAR (10)   NULL,
    [country_cd]    VARCHAR (3)    NULL,
    [active]        BIT            NOT NULL, 
    CONSTRAINT [PK_geo] PRIMARY KEY ([geo_key])
);


GO
CREATE NONCLUSTERED INDEX [city_key_idx]
    ON [dbo].[geo]([city_key] ASC);


GO
CREATE NONCLUSTERED INDEX [suburb_key_idx]
    ON [dbo].[geo]([suburb_key] ASC);

