Pre-Order
Tables (17)
AutoTableMapping (자동테이블매핑)
- 매핑id (mapping_id) — Int — Primary key — NOT NULL
- 평면도id (plan_id) — Int — Foreign key → FloorPlan.평면도id — NOT NULL
- 테이블id (table_id) — Int
- X좌표 (coord_x) — Int
- Y좌표 (coord_y) — Int
CustomerSession (고객세션)
- 세션id (session_id) — String — Primary key — NOT NULL
- 테이블id (table_id) — Int — Foreign key → Table.테이블id — NOT NULL
- 세션시작일시 (started_at) — Datetime
FloorPlan (매장 평면도)
- 평면도id (plan_id) — Int — Primary key — NOT NULL
- 가게id (store_id) — int — Foreign key → Store.가게id — NOT NULL
- 평면도_url (plan_image_url) — String
- 처리일시 (processed_at) — Datetime
InventoryHistory (재고이력)
- 재고로그id (inventory_id) — Int — Primary key — NOT NULL
- 메뉴id (menu_id) — Int — Foreign key → MenuItem.메뉴id — NOT NULL
- 변동유형 (change_type) — Enum('out_of_stock','Restock')
- 변경자 (changed_by) — String
- 변경일시 (changed_at) — Datetime
ManualOrder (수동주문)
- 수동주문id (manual_order_id) — Int — Primary key — NOT NULL
- 주문id (order_id) — Int — Foreign key → Order.주문id — NOT NULL
- 직원id (staff_id) — Int
- 메모 (note) — Text
MenuItem (메뉴항목)
- 메뉴id (Key) — Int — Primary key — NOT NULL
- 가게id (store_id) — int — Foreign key → Store.가게id — NOT NULL
- 메뉴명 (name) — String
- 가격 (price) — String
- 설명 (description) — String
- 사진url (photo_url) — String
- 판매가능여부 (is_available) — Boolean
Order (주문)
- 주문id (order_id) — Int — Primary key — NOT NULL
- 고객세션id (session_id) — String — Foreign key → CustomerSession.세션id — NOT NULL
- 가게id (store_id) — int — Foreign key → Store.가게id — NOT NULL
- 테이블id (table_id) — Int — Foreign key → Table.테이블id — NOT NULL
- 총금액 (total_amount) — Float
- 주문일시 (ordered_at) — Datetime
OrderItem (주문항목)
- 주문항목id (order_item_id) — Int — Primary key — NOT NULL
- 주문id (order_id) — Int — Foreign key → Order.주문id — NOT NULL
- 메뉴id (menu_id) — Int — Foreign key → MenuItem.메뉴id — NOT NULL
- 수량 (quantity) — Int
- 단가 (unit_price) — Float
OrderStatusLog (주문상태이력)
- 상태로그id (status_log_id) — Int — Primary key — NOT NULL
- 주문id (order_id) — Int — Foreign key → Order.주문id — NOT NULL
- 상태 (status) — Enum('Received','Preparing','Done')
- 변경일시 (changed_at) — Datetime
Payment (결제)
- 결제id (payment_id) — Int — Primary key — NOT NULL
- 주문id (order_id) — Int — Foreign key → Order.주문id — NOT NULL
- 결제수단 (payment_method) — Enum('PostPay','KakaoPay','NaverPay')
- 결제금액 (paid_amount) — Floate
- 결제일시 (paid_at) — Datetime
Qr code (QR 코드)
- qr_id — Int — Primary key — NOT NULL
- 테이블id (table_id) — Int — Foreign key → Table.테이블id — NOT NULL
- qr데이터 (qr_date) — Text
- 출력일시 (printed_at) — Datetime
SalesRecord (매출기록)
- 매출id (sales_id) — Int — Primary key — NOT NULL
- 가게id (store_id) — int — Foreign key → Store.가게id — NOT NULL
- 기간구분 (period_type) — Enum('Day','Week')
- 기간시작 (period_start) — Datetime
- 총매출 (total_sales) — Float
- 최다판매메뉴id (top_menu_id) — Int
ServiceRequest (직원 호출)
- 호출id (request_id) — Int — Primary key — NOT NULL
- 주문id (order_id) — Int — Foreign key → Order.주문id — NOT NULL
- 호출유형 (request_type) — Enum('Water','Refill','Other')
- 요청일시 (requested_at) — Datetime
- 해결일시 (resolved_at) — Datetime
Store (가게)
- 가게id (store_id) — int — Primary key — NOT NULL
- 가게명 (name) — string
- 주소 (address) — String
- 전화번호 (phone) — String
- 등록일시 (created_at) — Date
- 수정일시 (updated_at) — Date
Table (테이블)
- 테이블id (table_id) — Int — Primary key — NOT NULL
- 가게id (store_id) — int — Foreign key → Store.가게id — NOT NULL
- 테이블번호 (table_number) — Int
- 상태 (status) — Enum('Empty'.,'Occupied','Paying')
TableLayout (테이블 배치도)
- 배치도id (layout_id) — Int — Primary key — NOT NULL
- 가게id (store_id) — int — Foreign key → Store.가게id — NOT NULL
- 배치도url (layout_image_url) — String
- 등록일시 (created_at) — Datetime
Translation (메뉴번역)
- 번역id (trans_id) — Int — Primary key — NOT NULL
- 메뉴id (menu_id) — Int — Foreign key → MenuItem.메뉴id — NOT NULL
- 언어코드 (language) — String
- 번역된_메뉴명 (translated_name) — String
- 번역된_설명 (translated_description) — Text