gistfile1.txt

CREATE TABLE user
(
	email varchar(100) NOT NULL,
	password varchar(50) NOT NULL,
	PRIMARY KEY (email)
);

CREATE TABLE stocks
(
	symbol varchar(10) NOT NULL,
	last NUMBER NULL,
	first NUMBER NOT NULL,
	count NUMBER NOT NULL,
	PRIMARY KEY (symbol)
);


CREATE TABLE stocksdaily
(
	symbol varchar(10) NOT NULL,
	open NUMBER NOT NULL,
	high NUMBER NOT NULL,
	low NUMBER NOT NULL,
	close NUMBER NOT NULL,
	volume NUMBER NOT NULL,
	PRIMARY KEY (symbol)
);

CREATE TABLE transaction
(
	ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	symbol varchar(10) NOT NULL,
	price NUMBER NOT NULL,
	quantity NUMBER NOT NULL,
	type varchar(10) NOT NULL,
	cashholding NUMBER NOT NULL,
	portfolio_id NUMBER NOT NULL,
	user_id NUMBER NOT NULL,
	PRIMARY KEY (symbol)
);


CREATE TABLE hastransaction
(
	email varchar(100) NOT NULL,
	ts TIMESTAMP,
	symbol varchar(10) NOT NULL
);

CREATE TABLE hasstock
(
	email varchar(100) NOT NULL,
	amount NUMBER,
	symbol varchar(10) NOT NULL
);