withfestival

Tables (5)

booth (Untitled)

  • id (pk) — Primary key — NOT NULL
  • booth_name (이름)
  • account_number (계좌번호)
  • notice (공지사항)
  • event (이벤트)
  • number (로그인을 위한 인증번호)

menu (Untitled2)

  • id (pk) — Primary key — NOT NULL
  • menu (메뉴명)
  • price (가격)
  • description (메뉴 설명)
  • image (메뉴 이미지 URL)
  • storeID (pk2) — Foreign key → booth.id — NOT NULL

order (Untitled5)

  • id (pk) — Primary key — NOT NULL
  • Field
  • 주문 id (pk2) — Foreign key → orderMenu.id — NOT NULL
  • cnt (주문 갯수)
  • menuId (메뉴 id) — Foreign key → menu.id — NOT NULL

orderMenu (Untitled4)

  • id (pk) — Primary key — NOT NULL
  • sum (주문 총액)
  • send_processed (송금 완료여부 t/f)
  • created_at (년원시분초까지)
  • sendName (송금자 이름)
  • id (pk2) — Foreign key → booth.id — NOT NULL

waiting (Untitled3)

  • id (pk) — Primary key — NOT NULL
  • waitingf_name (웨이팅 네임)
  • count (인원)
  • phone_number (전화번호)
  • created_at (시분까지만)
  • id (pk2) — Foreign key → booth.id — NOT NULL
  • processed (착석했는지 취소했는지 처리여부)