33 lines
886 B
MySQL
33 lines
886 B
MySQL
|
CREATE TABLE campaign_spends (
|
||
|
|
id VARCHAR(64) PRIMARY KEY NOT NULL DEFAULT uuid_generate_v4(),
|
||
|
|
campaign VARCHAR NOT NULL,
|
||
|
|
spend NUMERIC(8,2) NOT NULL,
|
||
|
|
month INTEGER NOT NULL,
|
||
|
|
year INTEGER NOT NULL,
|
||
|
|
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
||
|
|
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE jam_class_reports (
|
||
|
|
cohort DATE,
|
||
|
|
campaign VARCHAR,
|
||
|
|
spend NUMERIC (8,2),
|
||
|
|
registrations INTEGER,
|
||
|
|
td_customers INTEGER,
|
||
|
|
jamclass_rev NUMERIC (8,2),
|
||
|
|
td4 INTEGER,
|
||
|
|
td2 INTEGER,
|
||
|
|
td1 INTEGER,
|
||
|
|
spend_td NUMERIC (8,2),
|
||
|
|
purchases0 NUMERIC (8,2),
|
||
|
|
purchases1 NUMERIC (8,2),
|
||
|
|
purchases2 NUMERIC (8,2),
|
||
|
|
purchases3 NUMERIC (8,2),
|
||
|
|
purchases_rest NUMERIC (8,2),
|
||
|
|
purchases0_count INTEGER,
|
||
|
|
purchases1_count INTEGER,
|
||
|
|
purchases2_count INTEGER,
|
||
|
|
purchases3_count INTEGER,
|
||
|
|
purchases_rest_count INTEGER,
|
||
|
|
purchases_count INTEGER
|
||
|
|
);
|