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 (착석했는지 취소했는지 처리여부)