shopping

Tables (7)

Cart

  • Cid — varchar — Foreign key → Client.Cid — NOT NULL
  • Field

Client

  • Cid — varchar — Primary key — NOT NULL
  • Cname — varchar
  • Cage — int

Delivery

  • Cid — varchar — Foreign key → Order.Cid — NOT NULL
  • Pid — int — Foreign key → Order.Pid — NOT NULL
  • Ddate — date

Order

  • Cid — varchar — Foreign key → Client.Cid — NOT NULL
  • Pid — int — Foreign key → Product.Pid — NOT NULL
  • Odate — date

Product

  • Pid — int — Primary key — NOT NULL
  • Sid — varchar — Foreign key → Seller.Sid — NOT NULL
  • Pname — varchar

Product_option

  • Pid — int — Foreign key → Product.Pid — NOT NULL
  • Poption — varchar

Seller

  • Sid — varchar — Primary key — NOT NULL
  • Sname — varchar
  • Sage — int