secondproject

Tables (11)

Area (지역)

  • area_id (지역_id) — VARCHAR2(2) — Primary key
  • area_name (지역명) — VARCHAR2(20)

Book (예약)

  • book_id (예약_id) — VARCHAR2(12) — Primary key — NOT NULL
  • customer_id (고객_계정) — VARCHAR2(40) — Foreign key → Customer.customer_id

Customer (로그인)

  • customer_id (고객_계정) — VARCHAR2(40) — Primary key
  • customer_pw (고객_암호) — VARCHAR2(256)
  • customer_salt (고객_솔트) — VARCHAR2(32)

Customer_ad (광고수신)

  • customer_id (고객_계정) — VARCHAR2(40) — Foreign key → Customer.customer_id
  • ad_email (광고수신_확인_이메일) — NUMBER(1)
  • ad_sns (광고수신_확인_sns) — NUMBER(1)
  • ad_tel (광고수신_확인_연락처) — NUMBER(1)

Customer_info (유저 정보)

  • customer_id (고객_계정) — VARCHAR2(40) — Foreign key → Customer.customer_id
  • customer_name (고객_이름) — VARCHAR2(21)
  • customer_tel (고객_연락처) — VARCHAR2(30)
  • customer_birth (고객_생일) — DATE
  • customer_email (고객_이메일) — VARCHAR2(100)
  • customer_point (고객_포인트) — NUMBER(7)

Movie (영화_정보)

  • movie_id (영화_id) — VARCHAR2(6) — Primary key
  • movie_title (영화_제목) — VARCHAR2(100)
  • movie_time (영화_상영시간) — NUMBER(3)
  • movie_age (영화_제한상영가) — NUMBER(2)
  • movie_genre (영화_장르) — VARCHAR2(30)

Movie_rating (영화 순위)

  • movie_id (영화_id) — VARCHAR2(6) — Foreign key → Movie.movie_id
  • movie_ cumulative (영화_누적관객) — NUMBER(9)
  • movie_grade (영화_평점) — NUMBER(2,1)

Movie_show (상영_정보)

  • movie_show_id (상영_id) — VARCHAR2(9) — Primary key — NOT NULL
  • movie_id (영화_id) — VARCHAR2(6) — Foreign key → Movie.movie_id
  • room_id (상영관_id) — VARCHAR2(6) — Foreign key → Room.room_id — NOT NULL
  • show_start (상영_시작_시간) — DATE

Room (상영관)

  • room_id (상영관_id) — VARCHAR2(6) — Primary key — NOT NULL
  • room_name (상영관_이름) — VARCHAR2(40)
  • room_seat (좌석_수) — NUMBER(3)

Theater (극장)

  • theater_id (극장_id) — VARCHAR2(4) — Primary key
  • theater_name (극장_이름) — VARCHAR2(50)

customer_term (고객_약관)

  • customer_id (고객_계정) — VARCHAR2(40) — Foreign key → Customer.customer_id
  • term_1 (선택약관_1) — NUMBER(1)
  • term_2 (선택약관_2) — NUMBER(1)
  • term_3 (선택약관_3) — NUMBER(1)