1
Tables (10)
Attendance
- work_id — INT — 근무ID
- employee_id — INT — NOT NULL — 직원ID(FK)
- work_date — DATE — NOT NULL — 근무일자
- start_time — TIME — 출근시간
- end_time — TIME — 퇴근시간
- break_start — TIME — 휴게시작시간
- break_end — TIME — 휴게끝시간
Bookings
- booking_id — INT — 예매ID
- schedule_id — INT — NOT NULL — 스케줄ID(FK)
- seat_id — INT — NOT NULL — 좌석ID(FK)
- booking_time — DATETIME — 예매시간
- payment_method — ENUM('카드', '현금') — 결제수단
Employees
- employee_id — INT — 직원ID
- name — VARCHAR(50) — NOT NULL — 직원이름
- password — VARCHAR(255) — NOT NULL — 비밀번호(P.W)
- position — ENUM('매니저', '직원') — NOT NULL — 직급
- age — INT — 나이
- gender — ENUM('남성', '여성') — 성별
- address — TEXT — 주소
- contact — VARCHAR(20) — NOT NULL — 연락처
- salary — INT — 급여
- join_date — DATETIME — 입사일
Movies
- movie_id — INT — 영화ID
- title — VARCHAR(100) — NOT NULL — 제목
- genre — VARCHAR(50) — NOT NULL — 장르
- running_time — TIME — NOT NULL — 상영시간
- rating — INT — NOT NULL — 연령등급
Products
- product_id — INT — 상품ID
- product_name — VARCHAR(20) — NOT NULL — 상품명
- stock_quantity — INT — NOT NULL — 재고수량
- price — DECIMAL(10, 2) — NOT NULL — 상품금액
- category — VARCHAR(100) — 카테고리
Schedules
- schedule_id — INT — 스케줄ID
- movie_id — INT — NOT NULL — 영화ID(FK)
- theater_id — INT — NOT NULL — 상영관ID(FK)
- start_time — DATETIME — NOT NULL — 시작시간
- end_time — DATETIME — NOT NULL — 종료시간
Seats
- seat_id — INT — 좌석ID
- theater_id — INT — NOT NULL — 상영관ID(FK)
- seat_row — CHAR(1) — NOT NULL — 좌석열
- seat_number — INT — NOT NULL — 좌석번호
StockAdjustments
- adjustment_id — INT — 재고변경ID
- product_id — INT — NOT NULL — 상품ID(FK)
- change_quantity — INT — NOT NULL — 변경수량
- reason — VARCHAR(255) — 변경사유
- adjustment_date — DATETIME — 변경일시
Theaters
- theater_id — INT — 상영관ID
- total_seats — INT — NOT NULL — 총좌석수
WorkRecords
- record_id — INT — 근태기록ID
- employee_id — INT — NOT NULL — 직원ID(FK)
- work_date — DATE — NOT NULL — 근무일자
- work_start — TIME — NOT NULL — 근무시작
- work_end — TIME — NOT NULL — 근무종료
- overtime — TIME — 연장근무시간
- latetime — TIME — 지각시간