Q8

Tables (8)

Account

  • Key (account_id) — int — Primary key — NOT NULL
  • Key (customer_id) — int — Foreign key → Customer.Key — NOT NULL

Address

  • Key (address_id) — int — Primary key — NOT NULL
  • Key (customer_id) — int — Foreign key → Customer.Key — NOT NULL
  • Field (address) — varchar(10)

Customer

  • Key (customer_id) — int — Primary key — NOT NULL
  • Field (name) — varchar(10) — NOT NULL
  • Field2 (email) — varchar(10) — NOT NULL
  • Field3 (phone) — varchar(10) — NOT NULL

Order

  • Key (order_id) — int — Primary key — NOT NULL
  • Key (customer_id) — int — Foreign key → Customer.Key — NOT NULL
  • Field (order_date) — datetime — NOT NULL
  • Field2 (status) — varchar(10) — NOT NULL

OrderItem

  • Key (order_id) — int — Foreign key → Order.Key — NOT NULL
  • Key (product_id) — int — Foreign key → Product.Key — NOT NULL
  • Field (quantity) — int — NOT NULL

Payment

  • Key (payment_id) — int — Primary key — NOT NULL
  • Key (order_id) — int — Foreign key → Order.Key — NOT NULL
  • Field (amount) — int
  • Field2 (method) — varchar(10)
  • Field3 (status) — varchar(10)

Product

  • Key (product_id) — int — Primary key — NOT NULL
  • Field (product_code) — varchar(10) — NOT NULL
  • Field2 (name) — varchar(10) — NOT NULL
  • Field3 (category) — varchar(10) — NOT NULL
  • Field4 (price) — int — NOT NULL
  • Field5 (stock) — int — NOT NULL
  • Field6 (status) — varchar(10) — NOT NULL

Review

  • Key (review_id) — int — Primary key — NOT NULL
  • Key (customer_id) — int — Foreign key → Customer.Key — NOT NULL
  • Key (product_id) — int — Foreign key → Product.Key — NOT NULL
  • Field (content) — varchar(10)
  • Field2 (rating) — int
  • Field3 (date_written) — datetime