closing
Tables (4)
daily (일마감)
- idx (Key) — Primary key — NOT NULL
- club_idx (Field)
- close_date (Field2)
- close_store (Field3)
- close_type (Field4)
- site (Field5)
- reason (Field6)
green_fee_sales (그린티 판매 내역)
- idx (Key) — Primary key — NOT NULL
- daily_idx (Key2) — Foreign key → daily.idx — NOT NULL
- club_idx (Field)
- sales_date (Field6)
- fee_code (Field2)
- total_amt (Field3)
- net_amt (Field4)
- vat (Field5)
sales (매출현황)
- idx (Key) — Primary key — NOT NULL
- daily_idx (Key2) — Foreign key → daily.idx — NOT NULL
- club_idx (Field)
- sales_date (Field4)
- store_code (Field2)
- total_amt (Field3)
settlement (Untitled)
- idx (Key) — Primary key — NOT NULL
- daily_idx (Key2) — Foreign key → daily.idx — NOT NULL
- club_idx (Field)
- sales_date (Field4)
- pay_code (Field2)
- total_amt (Field3)