create table gr6Sales (
        ID      INT NOT NULL ,

        SALE_PRICE DECIMAL(19, 4) NOT NULL ,

        PRODUCT_ID INT NOT NULL ,
        DATE_ID INT     NOT NULL ,
        ADDRESS_ID      INT NOT NULL ,

        FOREIGN KEY (PRODUCT_ID) REFERENCES gr6Product(PRODUCT_ID) ,
        FOREIGN KEY (DATE_ID) REFERENCES gr6DateTime(DT_ID),
        FOREIGN KEY (ADDRESS_ID) REFERENCES gr6DeliveryAddress(DA_ID) ,

        PRIMARY KEY (ID)
);

create table gr6Product(
        NAME    VARCHAR(255)    NOT NULL ,
        PRODUCT_ID      INT     NOT NULL ,
        TYPE    VARCHAR(127)    NOT NULL ,
        PRICE   DECIMAL(19, 4)  NOT NULL,
        STOCK   INT     NOT NULL ,

        PRIMARY KEY (PRODUCT_ID)
);

create table gr6DateTime(
        DT_ID   INT     NOT NULL ,
        SEASON  VARCHAR(23) ,
        SELL_DATE DATE NOT NULL ,
        SELL_TIME TIME ,

        PRIMARY KEY (DT_ID)
);

create table gr6DeliveryAddress(
        DA_ID   INT     NOT NULL ,
        CITY    VARCHAR(255)    NOT NULL ,
        COUNTRY VARCHAR(255)    NOT NULL ,
        ADDRESS VARCHAR(255)    NOT NULL ,
        POSTAL_CODE INT NOT NULL ,

        PRIMARY KEY (DA_ID)
);