Genco V4_0_1
Tables (14)
Hoga (hoga)
- stockcode — varchar(30) — Primary key — NOT NULL
- price — float(3)
- qty — int
Untitled (Storage)
- Key (id) — Primary key — NOT NULL
- Field (stockcode)
- Field2 (price)
- Field3 (qty)
- Field (date)
- userid — varchar(255) — Foreign key → user.userid — NOT NULL
Untitled (chartdata)
- Key (chartid) — Primary key — NOT NULL
- Field (date)
- Field (open)
- Field (high)
- Field (low)
- Field (close)
- Field (volume)
- Field (change)
- stockcode — varchar(30) — Foreign key → stocklist.stockcode — NOT NULL
Untitled (verification)
- userid — varchar(255) — Foreign key → user.userid — NOT NULL
- Field (verification) — varchar(255)
- Field (level) — number(3)
Untitled (tradelog)
- Key (buyid) — Foreign key → buy.Key — NOT NULL
- Key (sellid) — Foreign key → sell.Key — NOT NULL
account
- accountid — varchar(30) — Primary key — NOT NULL
- balance — int
- userid — varchar(255) — Foreign key → user.userid — NOT NULL
accountDetail
- stockcode — varchar(30)
- qty — int
- buyprice — float(3)
- sellprice — float(3)
buy
- Key (id) — Primary key — NOT NULL
- stockcode — varchar(30)
- buyprice — float(3)
- qty — int
- Field (buyerid)
sell
- Key (id) — Primary key — NOT NULL
- stockcode — varchar(30)
- sellprice — float(3)
- qty — int
- Field (sellerid)
stocklist (stocks)
- 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
- buyqty — int
tradebook (tradedone)
- Key (tradeid) — Primary key — NOT NULL
- stockcode — varchar(30)
- sellprice — float(3)
- buyprice — float(3)
- sellqty — int
- buyqty — int
- avgprice — float(3)
user (users)
- userid — varchar(255) — Primary key — NOT NULL
- email — varchar(255)
- name — varchar(100)
- age — int
- nick — varchar(100)
- password — varchar(255)
- provider — varchar(30)
- Field (phone) — varchar(30)