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)