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)