POS

Tables (3)

pos_order (Untitled2)

  • idx (Key) — Primary key — NOT NULL
  • pos_table_idx (Key2) — Foreign key → pos_table.idx — NOT NULL
  • goods_idx (Field3)
  • amount (Field)
  • discount_code (Field2) — 할인코드
  • order_time (Field5) — 주문시간
  • settlement_yn (Field4) — 정산 상태
  • Field6

pos_table (Untitled)

  • idx (Key) — Primary key — NOT NULL
  • club_idx (Field)
  • store_idx (Field2)
  • visitor_idx (Field9) — 내장 idx
  • table_no (Field3)
  • business_date (Field4) — 영업일자
  • payment_status (Field5)
  • person (Field6) — 인원수
  • invoice_no (Field7) — 전표번호
  • join_status (Field8)

table_setting (Untitled3)

  • idx (Key) — Primary key — NOT NULL
  • club_idx (Field)
  • store_idx (Field2)
  • table_no (Field3)