Tr7mbQE4

1DROP TABLE IF EXISTS documents_generated CASCADE;
2
3-- Will want indexes on this table one day
4CREATE TABLE documents_generated (
5       docgen_id INTEGER NOT NULL,
6       user_id INTEGER NOT NULL,
7       user_address VARCHAR NOT NULL,
8       created TIMESTAMP NOT NULL,
9       document_size INTEGER NULL,
10       name VARCHAR NULL,
11       format VARCHAR NULL,       
12       CONSTRAINT docgen_pk PRIMARY KEY(docgen_id),
13       CONSTRAINT user_organisations_users_fk FOREIGN KEY(user_id) REFERENCES users(user_id)
14);
15
16--CREATE INDEX documents_generated_user_id_created_idx ON documents_generated(user_id, created);
17CREATE INDEX documents_generated_created_idx ON documents_generated(created);
18
19DROP TABLE IF EXISTS dg_pibs (
20	docgen_id INTEGER NOT NULL,
21    isin VARCHAR NULL,
22	product_type VARCHAR NULL,
23	cap boolean NULL,
24	underlying VARCHAR NULL,
25	language VARCHAR NULL,
26	CONSTRAINT dg_pibs_pk PRIMARY KEY(docgen_id),
27    CONSTRAINT dg_pibs_docgen_fk FOREIGN KEY(user_id) REFERENCES documents_generated(docgen_id)
28);