Likelion

Tables (6)

menu (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • img_url (Field2) — varchar
  • store_id (Key2) — int — Foreign key → store.id — NOT NULL

order

  • id (Key) — long — Primary key — NOT NULL
  • total_price (Field3) — int
  • order_at (Field) — Timestamp
  • ready (Field2) — bit
  • total_menu (Field4) — varchar
  • user_id (Key2) — varchar — Foreign key → user.id — NOT NULL
  • owner_id (Key3) — int — Foreign key → owner.id — NOT NULL
  • store_id (Key4) — int — Foreign key → store.id — NOT NULL

owner

  • id (Key) — int — Primary key — NOT NULL
  • 사업자번호 (Field) — varchar

rider (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • done (Field2) — bit
  • order_id (Key2) — long — Foreign key → order.id — NOT NULL

store (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • location (Field2) — varchar
  • open_time (Field3) — varchart
  • tel (Field4) — varchar
  • owner_id (Key2) — int — Foreign key → owner.id — NOT NULL

user

  • id (Key) — varchar — Primary key — NOT NULL
  • pw (Field) — varchar
  • name (Field2) — varchar
  • email (Field4) — varchar
  • phoneNum (Field3) — varchar