delivery

Tables (5)

Delivery (Untitled3)

  • id (pk) — int — Primary key — NOT NULL
  • city (도시) — char
  • street (도로명) — char
  • zipcode (우편번호) — char

Food (Untitled5)

  • id (pk) — int — Primary key — NOT NULL
  • name (이름) — char
  • price (가격) — int
  • amount (수량) — int
  • category (분류) — char

Member (Untitled)

  • id (pk) — int — Primary key — NOT NULL
  • name (이름) — char
  • city (도시) — char
  • street (도로명) — char
  • zipcode (우편번호) — char

Order_Food (Untitled4)

  • id (pk) — int — Primary key — NOT NULL
  • order_id (fk) — int — Foreign key → Orders.id — NOT NULL
  • food_id (fk2) — int — Foreign key → Food.id — NOT NULL
  • order_pice (주문금액) — int
  • count (주문수량) — int
  • Field

Orders (Untitled2)

  • id (pk) — int — Primary key — NOT NULL
  • member_id (fk) — int — Foreign key → Member.id — NOT NULL
  • delivery_id (fk2) — int — Foreign key → Delivery.id — NOT NULL
  • order_date (주문날짜) — date
  • status (주문상태) — char