CREATE TABLE customers
(
    CustomerID INTEGER UNIQUE     not null
        primary key,
    Segment    TEXT null,
    Currency   TEXT null
);
customers
CREATE TABLE gasstations
(
    GasStationID INTEGER    UNIQUE   not null
        primary key,
    ChainID      INTEGER          null,
    Country      TEXT null,
    Segment      TEXT null
);
gasstations
CREATE TABLE products
(
    ProductID   INTEGER   UNIQUE      not null
        primary key,
    Description TEXT null
);
products
CREATE TABLE "transactions_1k"
(
    TransactionID INTEGER
        primary key autoincrement,
    Date          DATE,
    Time          TEXT,
    CustomerID    INTEGER,
    CardID        INTEGER,
    GasStationID  INTEGER,
    ProductID     INTEGER,
    Amount        INTEGER,
    Price         REAL
);
transactions_1k
CREATE TABLE "yearmonth"
(
    CustomerID  INTEGER not null
        references customers
            on update cascade on delete cascade
        references customers,
    Date        TEXT    not null,
    Consumption REAL,
    primary key (Date, CustomerID)
);
yearmonth
original_column_name,column_name,column_description,data_format,value_description
GasStationID,Gas Station ID,Gas Station ID,integer,
ChainID,Chain ID,Chain ID,integer,
Country,,,text,
Segment,chain segment,chain segment,text,
gasstations
original_column_name,column_name,column_description,data_format,value_description
CustomerID,Customer ID,Customer ID,integer,
Date,,Date,text,
Consumption,,consumption,real,
yearmonth
original_column_name,column_name,column_description,data_format,value_description
ProductID,Product ID,Product ID,integer,
Description,,Description,text,
products
original_column_name,column_name,column_description,data_format,value_description
TransactionID,Transaction ID,Transaction ID,integer,
Date,,Date,date,
Time,,Time,text,
CustomerID,Customer ID,Customer ID,integer,
CardID,Card ID,Card ID,integer,
GasStationID,Gas Station ID,Gas Station ID,integer,
ProductID,Product ID,Product ID,integer,
Amount,,Amount,integer,
Price,,Price,real,"commonsense evidence:

total price = Amount x Price"
transactions_1k
original_column_name,column_name,column_description,data_format,value_description
CustomerID,,identification of the customer,integer,
Segment,client segment,client segment,text,
Currency,,Currency,text,
customers