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