CREATE TABLE ADDRESS_GROUP (
    ADDRESS_GROUP_ID            VARCHAR(35),
    ADDRESS_GROUP_DESC          VARCHAR(80) NOT NULL,
    
    CONSTRAINT ADDRESS_GROUP_PK PRIMARY KEY (ADDRESS_GROUP_ID)
);

CREATE TABLE ADDRESS_CLIENT (
    ADDRESS_CLIENT_ID           VARCHAR(35),
    ADDRESS_GROUP_ID		VARCHAR(35),
    CUSTOMER_CLIENT_ID          VARCHAR(30),
    CONTACT_NME                 VARCHAR(44),
    COMPANY_NME                 VARCHAR(44),
    ADDITIONAL_ADDR             VARCHAR(44),
    ADDR_LINE_1                 VARCHAR(44),
    ADDR_LINE_2                 VARCHAR(44),
    CITY                        VARCHAR(40),
    PROVINCE_NAME_OR_CD         VARCHAR(20),
    COUNTRY_CD                  VARCHAR(3),
    POSTAL_ZIP_CD               VARCHAR(14),
    CONTACT_PHONE_NBR           VARCHAR(25),
    RECEIVER_VAT_NBR            VARCHAR(18),
    PRIMARY_EMAIL_ADDRESS       VARCHAR(70),
    SECONDARY_EMAIL_ADDRESS     VARCHAR(70)
);