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)