Movie theater

Tables (12)

Pay (결제)

  • ID (아이디) — varchar — Primary key — NOT NULL
  • membership_rating (멤버십등급) — varchar — Foreign key → client.membership_rating — NOT NULL
  • payment (결제수단) — varchar
  • pay_time (결제시간) — time
  • cost (가격) — integer
  • Reserve_code (예매코드) — integer — Foreign key → refund_info.Reserve_code — NOT NULL

branch (지점)

  • branch_name (지점명) — varchar — Primary key — NOT NULL
  • staff_code (사번) — integer — Foreign key → staff.staff_code — NOT NULL
  • staff_name (사원이름) — varchar

client (고객)

  • ID (아이디) — varchar — Primary key — NOT NULL
  • membership_rating (멤버십등급) — varchar — Foreign key → membership_info.membership_rating — NOT NULL
  • Client_phone (고객연락처) — varchar
  • Client_name (고객이름) — varchar
  • birth_date (생년월일) — date
  • email_address (이메일주소) — varchar
  • points (보유포인트) — integer
  • coupons (보유쿠폰) — varchar
  • history (관람/결제 내역) — varchar

facility (시설)

  • facility_name (시설명) — varchar — Primary key — NOT NULL
  • staff_code (사번) — integer — Foreign key → branch.staff_code — NOT NULL
  • department (담당부서) — varchar

facility_info (시설정보)

  • facility_name (시설명) — varchar — Foreign key — NOT NULL
  • stock (재고) — integer
  • hours (운영시간) — varchar
  • facility_report (시설보고) — varchar500

membership_info (멤버쉽정보)

  • membership_rating (멤버쉽등급) — varchar — Primary key — NOT NULL
  • coupon_type (쿠폰종류) — varchar
  • point_rate (포인트적립률) — integer

movies (영화)

  • Title (제목) — varchar — Primary key — NOT NULL
  • Actors (배우) — varchar
  • Rating (관람등급) — int
  • Grade (평점) — integer

refund_info (환불정보)

  • Reserve_code (예매코드) — integer — Foreign key → reservation_info.Reserve_code — NOT NULL
  • payment (결제수단) — varchar
  • ID (아이디) — varchar

reservation_info (예매정보)

  • Reserve_code (예매코드) — integer — Primary key — NOT NULL
  • Title (제목) — varchar — Foreign key → movies.Title — NOT NULL
  • branch_name (지점명) — varchar — Foreign key → branch.branch_name — NOT NULL
  • ID (아이디) — varchar — Foreign key → Pay.ID — NOT NULL
  • movie_date (상영시간) — date
  • Seat (좌석) — varchar
  • Number (인원수) — number
  • Screen (상영관) — varchar

review (리뷰)

  • review_index (리뷰번호) — integer — Primary key — NOT NULL
  • ID (아이디) — varchar — Foreign key → client.ID — NOT NULL
  • grade (평점) — integer
  • review_time (작성시간) — time
  • review_contents (리뷰내용) — varchar

showing_info (상영정보)

  • Movie_date (상영시간) — date — Primary key — NOT NULL
  • Title (제목) — varchar — Foreign key → movies.Title — NOT NULL
  • branch_name (지점명) — varchar — Foreign key → branch.branch_name — NOT NULL
  • Screen (상영관) — varchar

staff (직원)

  • staff_code (사번) — integer — Primary key — NOT NULL
  • staff_rank (직급) — varchar
  • department (담당부서) — varchar
  • staff_name (사원이름) — varchar
  • salary (급여) — integer
  • staff_phone (연락처) — varchar20
  • work_log (근무일지) — varchar500