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 (dailyinform)

    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)