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 (승급점수)