Shoppingmall
Tables (6)
BILL (bill)
- CODE (Foreign Key) — number(5) — Foreign key → CART.CCODE — NOT NULL
- TOTAL (sum) — number(5)
- dayt (date) — timestamp
- IP (address) — varchar2(20)
- SID (id) — varchar2(20)
CART (cart)
- CCODE (Primary Key) — number(5) — Primary key — NOT NULL
- CODE (Foreign Key) — number(5) — Foreign key → SHOP.SCODE — NOT NULL
- SID (id) — varchar2(20)
- CNT (sum) — number(5)
- DAY (date) — date
- BUY (buy) — number(5)
COMMENTS (comment)
- FCODE (Foreign Key) — number(5) — Foreign key → SHOP.SCODE — NOT NULL
- CCODE (code) — number(5)
- STAR (star rate) — number(1,0)
- DAY (date) — timestamp
- ID (id) — varchar2(10)
- COMMENTS (comment) — varchar2(30)
HUMAN (human)
- MID (Primarykey) — varchar2(20) — Primary key — NOT NULL
- MPW (password) — varchar2(20)
- EMAIL (email) — varchar2(20)
- POINT (point) — number(5,0)
- SNAME (name) — varchar2(10)
- SPHONE (phone number) — varchar2(15)
- SREGIT (registry) — number(10)
- DAY (date) — date
- HORDER (order type) — number(3)
- ADMIN (administry) — varchar2(3)
SHOP (shop)
- SCODE (Primary key) — number(5) — Primary key — NOT NULL
- SID (Foreign Key) — varchar2(20) — Foreign key → HUMAN.MID — NOT NULL
- SNAME (Name) — varchar2(20)
- STYPE (Type) — varchar2(10)
- PATH (Path) — varchar2(30)
- DAY (date) — date
- SPRICE (price) — number(5,0)
- CNT (Product count) — number(5,0)
- DISCOUNT (discount) — number(3,0)
WISH (wish)
- CODE (Foreign Key) — number(5) — Foreign key → SHOP.SID — NOT NULL
- SID (id) — varchar2(20)
- DAY (date) — date
- STYPE (TYPE) — varchar2(10)