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