take-out food

Tables (5)

customer

  • customer_no — char(30) — Primary key — NOT NULL
  • customer_name — char(30)
  • customer_phone — char(11)
  • customer_address — char(30)
  • customer_gendert — char(5)
  • customer_age — int

goods

  • goods_id — char(30) — Primary key — NOT NULL
  • goods_name — char(30)
  • goods_price — float
  • store_no — char(30) — Foreign key → store.store_no — NOT NULL

store

  • store_no — char(30) — Primary key — NOT NULL
  • store_address — char(30)
  • store_phone — char(11)

sys_order

  • order_id — char(30) — Primary key — NOT NULL
  • takeaway_boy_id — char(30) — Foreign key → takeaway_boy.takeaway_boy_id — NOT NULL
  • customer_no — char(30) — Foreign key → customer.customer_no — NOT NULL
  • goods_id — char(30) — Foreign key → goods.goods_id — NOT NULL
  • order_price — float
  • order_time — datetime
  • estimated_delivery_time — datetime
  • distance — float
  • address — char(30)
  • quantity — int
  • discount — float

takeaway_boy

  • takeaway_boy_id — char(30) — Primary key — NOT NULL
  • boy_name
  • boy_phone
  • boy_age
  • boy_gender