Q8
Tables (7)
address
- Key (address) — char(40) — Primary key — NOT NULL
- Key (c_id) — char(10) — Foreign key → customer.Key — NOT NULL
customer
- Key (id) — char(10) — Primary key — NOT NULL
- Field (name) — varchar(20)
- Field (mail) — varchar(20)
- Field — varchar(15)
order
- Key (order_id) — int(10) — Primary key — NOT NULL
- Key (c_id) — char(10) — Foreign key → customer.Key — NOT NULL
- Field (date) — datetime
- Field2 (deliv_status) — varchar(10)
order list
- Key (order_id) — int(10) — Foreign key → order.Key — NOT NULL
- Key (p_code) — int(10) — Foreign key → product.Key — NOT NULL
- Field (p_num) — int(10)
payment info
- Key (pay_code) — int(10) — Primary key — NOT NULL
- Key (order_id) — int(10) — Foreign key → order.Key — NOT NULL
- Key (c_id) — char(10) — Foreign key → order.Key — NOT NULL
- Field (amount) — int(10)
- Field (method) — char(20)
- Field (status) — varchar(10)
product
- Key (product_code) — int(10) — Primary key — NOT NULL
- Field (price) — int(10)
- Field (category) — char(20)
- Field (stock) — int(10)
review
- Key (rev_id) — int(10) — Primary key — NOT NULL
- Key (product_code) — int(10) — Foreign key → product.Key — NOT NULL
- Key (id2) — char(10) — Foreign key → customer.Key — NOT NULL
- Field (content) — varchar(300)
- Field (rating) — int(5)
- Field (created_date) — datetime(8)