SSS

Tables (5)

price (Untitled4)

  • stockId (Key) — int — Foreign key → stock.stockId — NOT NULL
  • price (Field) — int
  • time (Field2) — Date

stock (Untitled3)

  • stockId (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • type (Field2) — varchar
  • category (Field3) — varchar

stock_user (Untitled2)

  • stockId (Key2) — int — Foreign key → stock.stockId — NOT NULL
  • user_index (Key) — int — Foreign key → users.user_index — NOT NULL
  • perchaseDate (Field) — Date
  • perchaseType (Field2) — tinyInt

users (Untitled)

  • user_index (Key) — int — Primary key — NOT NULL
  • email (Field) — varchar
  • password (Field2) — varchar
  • name (Field3) — varchar
  • registDate (Field4) — Date
  • lastLogin (Field5) — Date

wishList (Untitled5)

  • user_index (Key) — int — Foreign key → users.user_index — NOT NULL
  • stockId (Key2) — int — Foreign key → stock.stockId — NOT NULL
  • time (Field) — Date