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