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