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)