Database Schema - ChrisPHong/Sea Wiki

Sea_DB

users

column name data type details
id integer not null, primary key
first_name string not null
last_name string not null
email string not null, unique
hashedPassword string not null, BINARY
balance float not null

watchlists

column name data type details
id integer not null, primary key
name string not null, unique
userId integer not null, fk
  • userId references users table

watchlist_company_join

column name data type details
watchlistId integer not null, fk
companyId integer not null, fk
  • watchlistId references watchlists table
  • companyId references company table

company

column name data type details
id integer not null, primary key
name string not null
ticker string not null
description text not null
ceo string not null
employees integer not null
headquarters string not null
founded integer not null
base_price float not null
watchlistId integer not null, fk
  • watchlistId references watchlists table

transactions

column name data type details
id integer not null, primary key
price float not null
shares float not null
type string not null
date date not null
userId integer not null, fk
companyId integer not null, fk
  • userId references users table
  • companyId references company table