BackOffice

Tables (5)

Menu (메뉴)

  • PK (id) — Primary key — NOT NULL
  • content (내용)
  • stats (상태)
  • price (가격)
  • FK (store_id) — Foreign key → store.PK — NOT NULL

User (멤버)

  • PK (id) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

cart (장바구니)

  • PK (id) — Primary key — NOT NULL
  • count (갯수)
  • price (가격)
  • FK (orderhistor_id) — Foreign key → orderHistory.PK — NOT NULL
  • FK (menu_id) — Foreign key → Menu.PK — NOT NULL

orderHistory (주문하기및주문내역)

  • PK (id) — Primary key — NOT NULL
  • price (가격)
  • ordeer_At (주문시간)
  • FK (user_id) — Foreign key → User.PK — NOT NULL
  • status (주문상태)

store (Untitled)

  • PK (id) — Primary key — NOT NULL
  • Field
  • Field2
  • FK (user_id) — Foreign key → User.PK — NOT NULL