cgv

Tables (9)

Attendance

  • attendance_id — INT — Primary key — NOT NULL
  • work_date — DATE — NOT NULL
  • clock_in_time — TIME
  • clock_out_time — TIME
  • break_start_time — TIME
  • break_end_time — TIME
  • overtime_hours — DECIMAL(4, 2)
  • late_minutes — INT
  • employee_id — INT — Foreign key → Employee.employee_id — NOT NULL

ConcessionItem

  • item_id — INT — Primary key — NOT NULL
  • item_name — VARCHAR(100) — NOT NULL
  • stock_quantity — INT — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL

ConcessionSales

  • sale_id — INT — Primary key — NOT NULL
  • quantity_sold — INT — NOT NULL
  • sale_amount — DECIMAL(10, 2) — NOT NULL
  • sale_date — DATETIME — NOT NULL
  • item_id — INT — Foreign key → ConcessionItem.item_id — NOT NULL

Employee

  • employee_id — INT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • position — VARCHAR(50)
  • contact_info — VARCHAR(100)
  • address — VARCHAR(255)

Movie

  • movie_id — INT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • genre — VARCHAR(100)
  • duration — INT

Screening

  • screening_id — INT — Primary key — NOT NULL
  • screening_time — DATETIME — NOT NULL
  • theater_id — INT — Foreign key → Theater.theater_id — NOT NULL
  • movie_id — INT — Foreign key → Movie.movie_id — NOT NULL

Seat

  • seat_id — INT — Primary key — NOT NULL
  • seat_number — VARCHAR(10) — NOT NULL
  • status — ENUM('예약됨', '빈좌석') — NOT NULL
  • theater_id — INT — Foreign key → Theater.theater_id — NOT NULL

SeatReservation

  • reservation_id — INT — Primary key — NOT NULL
  • reservation_status — ENUM('확정', '취소') — NOT NULL
  • seat_id — INT — Foreign key → Seat.seat_id — NOT NULL
  • screening_id — INT — Foreign key → Screening.screening_id — NOT NULL

Theater

  • theater_id — INT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • total_seats — INT — NOT NULL