CREATE TABLE Demog
(
    GEOID         INTEGER
        constraint Demog_pk
            primary key,
    INHABITANTS_K REAL,
    INCOME_K      REAL,
    A_VAR1        REAL,
    A_VAR2        REAL,
    A_VAR3        REAL,
    A_VAR4        REAL,
    A_VAR5        REAL,
    A_VAR6        REAL,
    A_VAR7        REAL,
    A_VAR8        REAL,
    A_VAR9        REAL,
    A_VAR10       REAL,
    A_VAR11       REAL,
    A_VAR12       REAL,
    A_VAR13       REAL,
    A_VAR14       REAL,
    A_VAR15       REAL,
    A_VAR16       REAL,
    A_VAR17       REAL,
    A_VAR18       REAL
);
Demog
CREATE TABLE mailings3
(
    REFID    INTEGER
        constraint mailings3_pk
            primary key,
    REF_DATE DATETIME,
    RESPONSE TEXT
);
mailings3
CREATE TABLE "Customers"
(
    ID             INTEGER
        constraint Customers_pk
            primary key,
    SEX            TEXT,
    MARITAL_STATUS TEXT,
    GEOID          INTEGER
        constraint Customers_Demog_GEOID_fk
            references Demog,
    EDUCATIONNUM   INTEGER,
    OCCUPATION     TEXT,
    age            INTEGER
);
Customers
CREATE TABLE "Mailings1_2"
(
    REFID    INTEGER
        constraint Mailings1_2_pk
            primary key
        constraint Mailings1_2_Customers_ID_fk
            references Customers,
    REF_DATE DATETIME,
    RESPONSE TEXT
);
Mailings1_2
CREATE TABLE "Sales"
(
    EVENTID    INTEGER
        constraint Sales_pk
            primary key,
    REFID      INTEGER
        references Customers,
    EVENT_DATE DATETIME,
    AMOUNT     REAL
);
Sales
original_column_name,column_name,column_description,data_format,value_description
REFID,REFERENCE ID,unique id number identifying the customer,integer,
REF_DATE,REFERENCE DATE,indicating the date when the mailing was sent,datetime,
RESPONSE,,Actual response to the marketing incentive email ,text,"• True
• False 
commonsense evidence: 
1. any person who has not responded to a mailing within two months is considered to have responded negatively.
2. true respond to the mailing, otherwise, no"
mailings3
original_column_name,column_name,column_description,data_format,value_description
GEOID,GEOGRAPHIC ID,unique geographic identifier,integer,
INHABITANTS_K,INHABITANTS (THOUSANDS),number of inhabitants,real,the unit is K (thousands)
INCOME_K,INCOME (THOUSANDS),average income per inhabitant per month,real,"the unit is dollar, it indicates the average income per inhabitant per month.
commonsense evidence:
some computation like: total income per year = INHABITANTS_K x INCOME_K x 12"
A_VAR1,,,,
A_VAR2,,,,
A_VAR3,,,,
A_VAR4,,,,
A_VAR5,,,,
A_VAR6,,,,
A_VAR7,,,,
A_VAR8,,,,
A_VAR9,,,,
A_VAR10,,,,
A_VAR11,,,,
A_VAR12,,,,
A_VAR13,,,,
A_VAR14,,,,
A_VAR15,,,,
A_VAR16,,,,
A_VAR17,,,,
A_VAR18,,,,
Demog
original_column_name,column_name,column_description,data_format,value_description
EVENTID,EVENT ID,unique id of event (sales),integer,
REFID,REFERENCE ID,Reference to customer ID,integer,
EVENT_DATE,EVENT DATE,date of sales,datetime,
AMOUNT,AMOUNT,amount of sales,real,
Sales
original_column_name,column_name,column_description,data_format,value_description
ID,,the unique number identifying the customer,integer,
SEX,,the sex of the customer,text,
MARITAL_STATUS,MARITAL STATUS,,text,"� Never-married
� Married-civ-spouse
� Divorced
� Widowed
� Other
commonsense evidence: ""Married-civ-spouse"", ""Divorced"", ""Widowed"" mean customer has been married.
"
GEOID,GEOGRAPHIC ID,geographic identifier,integer,
EDUCATIONNUM,EDUCATION NUMBER,the level of education,integer,commonsense evidence: higher education number refers to higher education
OCCUPATION,,occupation of customers,text,
age,,age of customers,integer,"commonsense evidence: � teenager: 13-19 years old.
� elder: people aged over 65"
Customers
original_column_name,column_name,column_description,data_format,value_description
REFID,REFERENCE ID,unique id number identifying the customer,integer,
REF_DATE,REFERENCE DATE,indicating the date when the mailing was sent,datetime,
RESPONSE,,Response to the incentive mailing that marketing department sent,text,"• True
• False 
commonsense evidence: 
1. any person who has not responded to a mailing within two months is considered to have responded negatively.
2. true respond to the mailing, otherwise, no"
Mailings1_2