Genco_v3.2
Tables (9)
Hoga (hoga)
- stockcode — varchar(30) — Primary key — NOT NULL
- price — float(3)
- qty — int
- sellerid — varchar(255) — Foreign key → sell.userid — NOT NULL
- buyerid — varchar(255) — Foreign key → buy.userid — NOT NULL
account
- accountid — varchar(30) — Primary key — NOT NULL
- userid — varchar(255) — Foreign key → user.userid — NOT NULL
- balance — int
accountDetail
- accountid — varchar(30) — Foreign key → account.accountid — NOT NULL
- userid — varchar(255) — Foreign key → account.userid — NOT NULL
- stockcode — varchar(30)
- qty — int
- buyprice — float(3)
- sellprice — float(3)
buy
- accountid — varchar(30) — Foreign key → accountDetail.accountid — NOT NULL
- userid — varchar(255) — Foreign key → accountDetail.userid — NOT NULL
- stockcode — varchar(30)
- buyprice — float(3)
- qty — int
sell
- accountid — varchar(30) — Foreign key → accountDetail.accountid — NOT NULL
- userid — varchar(255) — Foreign key → accountDetail.userid — NOT NULL
- stockcode — varchar(30)
- sellprice — float(3)
- qty — int
stocklist
- stockcode — varchar(30) — Primary key — NOT NULL
- companyName — varchar(100)
- sangjangDay — date
- market — varchar(20)
- category — varchar(255)
- mainProduct — varchar(255)
- gyulsanMonth — varchar(100)
- president — varchar(255)
- homePage — varchar(255)
- localArea — varchar(255)
trade
- transactionid — int — Primary key — NOT NULL
- accountid — varchar(30) — Foreign key → sell.accountid — NOT NULL
- userid — varchar(255) — Foreign key → sell.userid — NOT NULL
- buyqty — int
- accountid (accountid2) — varchar(30) — Foreign key → buy.accountid — NOT NULL
- userid (userid2) — varchar(255) — Foreign key → buy.userid — NOT NULL
tradebook
- transactionid — int — Foreign key → trade.transactionid — NOT NULL
- userid — varchar(255) — Foreign key → trade.userid — NOT NULL
- stockcode — varchar(30)
- sellprice — float(3)
- buyprice — float(3)
- sellqty — int
- buyqty — int
- avgprice — float(3)
user
- userid — varchar(255) — Primary key — NOT NULL
- email — varchar(255)
- name — varchar(100)
- age — int
- phone — varchar(20)
- verification — varchar(30)
- nick — varchar(100)
- password — varchar(255)
- provider — varchar(30)
- accountid — varchar(30)