1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
CREATE TABLE stock (
stockId serial PRIMARY KEY,
ticker varchar(10),
yahooTicker varchar (10),
name varchar(50)
);
CREATE TABLE history (
date date DEFAULT CURRENT_DATE NOT NULL,
stockId integer NOT NULL REFERENCES stock ON DELETE CASCADE ON UPDATE CASCADE,
open double precision DEFAULT NULL,
high double precision DEFAULT NULL,
low double precision DEFAULT NULL,
close double precision DEFAULT NULL,
adjClose double precision DEFAULT NULL,
volume double precision DEFAULT NULL,
div real DEFAULT NULL,
adjDiv real DEFAULT NULL,
split real DEFAULT NULL,
PRIMARY KEY (date, stockid)
);
|
