CREATE TABLE [dbo].[address_main] (
    [address_key]     INT              IDENTITY (1, 1) NOT NULL,
	[geo_key]         INT              NULL,     
    [address_line1]   NVARCHAR (70)    NULL,
    [address_line2]   NVARCHAR (70)    NULL,
    [address_line3]   NVARCHAR (70)    NULL,
    [address_line4]   NVARCHAR (70)    NULL,
    [suburb_key]      INT              NULL,
    [suburb_desc]     NVARCHAR (45)    NULL,
    [city_key]        INT              NULL,
    [city_desc]       NVARCHAR (45)    NULL,
    [province_key]    INT              NULL,
    [province_desc]   NVARCHAR (25)    NULL,
    [country_cd]      VARCHAR (3)      NULL,
    [post_cd]         NVARCHAR (10)    NULL,
    [address_comment] NVARCHAR (255)   NULL,
    [modified_dt]     DATETIME         NULL,
    [modified_by_key] UNIQUEIDENTIFIER NULL,
    CONSTRAINT [address_main_PK] PRIMARY KEY CLUSTERED ([address_key] ASC)
);

