EbRsTMGz

1CREATE TABLE fund_identifier
2(
3    id BIGSERIAL PRIMARY KEY NOT NULL,
4    identifier TEXT NOT NULL
5);
6CREATE UNIQUE INDEX IF NOT EXISTS fund_identifier_pkey ON fund_identifier (id);
7CREATE UNIQUE INDEX IF NOT EXISTS fund_identifier_identifier_uindex ON fund_identifier (identifier)
8	
9CREATE TABLE security_papers (
10      id                                        BIGSERIAL,
11      fund_identifier                           TEXT,
12      as_of_date                                DATE,
13          ...
14      CONSTRAINT security_papers_fund_identifier_fk FOREIGN KEY (fund_identifier) REFERENCES fund_identifier (identifier)
15    }
16	
17CREATE TABLE security_papers (
18      id                                        BIGSERIAL,
19      fund_identifier_id                        BIGSERIAL,
20      as_of_date                                DATE,
21          ...
22      CONSTRAINT security_papers_fund_identifier_fk FOREIGN KEY (fund_identifier) REFERENCES fund_identifier (identifier)
23    }
24	
25-- it'll guess primary key
26fund_identifier  type  REFERENCES table;
27	
28fund_identifier  bigint  REFERENCES table;