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)