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