movie
Tables (7)
movie (영화정보)
- movie_id (영화코드) — PK — Primary key — NOT NULL
- movie_grade_id (영화등급코드) — FK — Foreign key → movie_grade.movie_grade_id — NOT NULL
- movie_name (영화명)
- movie_desc (영화개요)
- movie_actor (주연배우)
- movie_genre (영화장르)
- movie_time (상영시간)
- movie_start_date (상영시작일)
- movie_end_date (상영종료일)
- movie_fee (입장료)
- movie_rank (순위)
movie_grade (영화등급)
- movie_grade_id (영화등급코드) — PK — Primary key — NOT NULL
- movie_grade_name (영화등급명)
screen (영화상영)
- screen_id (상영코드) — PK — Primary key — NOT NULL
- movie_id (영화코드) — FK — Foreign key → movie.movie_id — NOT NULL
- theater_id (상영관번호) — FK — Foreign key → theater.theater_id — NOT NULL
- screen_time (필요시간)
- screen_start_time (상영시작시간)
- screen_end_time (상영종료시간)
theater (상영관)
- theater_id (상영관번호) — PK — Primary key — NOT NULL
- theater_name (상영관명)
- theater_seat_row (좌석 행)
- theater_seat_col (좌석 열)
- theater_seat_cnt (좌석 수)
- theater_clean (청소시간)
- theater_useYN (사용가능여부)
ticket (예매정보)
- ticket_id (예매번호) — PK — Primary key — NOT NULL
- screen_id (상영코드) — FK — Foreign key → screen.screen_id — NOT NULL
- user_id (회원번호) — FK — Foreign key → user.user_id — NOT NULL
- ticket_seat_row (좌석 행)
- ticket_seat_col (좌석 열)
- ticket_date (예매일)
user (회원정보)
- user_id (회원번호) — PK — Primary key — NOT NULL
- user_grade_id (회원등급코드) — FK — Foreign key → user_grade.user_grade_id — NOT NULL
- user_pw (비밀번호)
- user_name (성명)
- user_birth (생년월일)
- user_gender (성별)
- user_call (전화번호)
- user_email (이메일)
- user_genre (선호장르)
- user_point (적립금)
- user_mileage (마일리지)
- user_save_mileage (누적 마일리지)
- user_coupon (영화쿠폰)
user_grade (회원등급)
- user_grade_id (회원등급코드) — PK — Primary key — NOT NULL
- user_grade_name (회원등급명)
- user_grade_save_percent (적립마일리지)
- user_grade_advance (승급점수)