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 — 지각시간