project
Tables (9)
BRANCH (지점)
- BRANCH_ID (지점ID) — VARCHAR2(20) — Primary key
- BRANCH_NAME (지점 이름) — VARCHAR2(50)
- BRANCH_CITY (지점 도시) — VARCHAR2(20)
MOVIE (영화 정보)
- MOVIE_ID (영화ID) — VARCHAR2(30) — Primary key — NOT NULL
- AGE_LIMIT (나이 제한) — NUMBER
- MOVIE_NAME (영화 제목) — VARCHAR2(60)
- MOVIE_GENRE (영화 장르) — VARCHAR2(30)
- MOVIE_SUMMARY_TITLE (영화 줄거리 제목) — VARCHAR(200)
- MOVIE_SUMMARY_CONTENT (영화 줄거리 내용) — VARCHAR(2000)
- SCREEN_TIME (상영 시간) — NUMBER
- MOVIE_CAST (출연진) — VARCHAR2(100)
- AUDCOUNT (관객수) — NUMBER
- MOVIE_ENG_TITLE (영화 영어 제목) — VARCHAR(100) — NOT NULL
- RELEASE_DATE (개봉일) — DATE
PRICE (가격)
- PRICE_ID (가격ID) — VARCHAR2(20) — Primary key — NOT NULL
- PRICE_TICKET (영화 가격) — NUMBER
RESERVE (예매 정보)
- RESERVE_ID (예매ID) — NUMBER — Primary key — NOT NULL
- MOVIE_ID (영화ID) — VARCHAR2(30) — Foreign key → MOVIE.MOVIE_ID — NOT NULL
- USER_ID (유저ID) — VARCHAR2(20) — Foreign key → USER_INFO.USER_ID — NOT NULL
- PRICE_ID (가격ID) — VARCHAR2(20) — Foreign key → PRICE.PRICE_ID — NOT NULL
- SEAT_ID (좌석ID) — VARCHAR2(20)
- RESERVE_TOT_PRICE (총 예매 가격) — NUMBER
- RESERVE_VIEW_DAY (관람일) — DATE
- RESERVE_BUY_DAY (예매일) — DATE
- RESERVE_YNC (예매/취소/변경) — CHAR(1)
REVIEW (관람평)
- REVIEW_ID (관람평ID) — VARCHAR2(20) — Primary key — NOT NULL
- USER_ID (유저ID) — VARCHAR2(20) — Foreign key → USER_INFO.USER_ID — NOT NULL
- MOVIE_ID (영화ID) — VARCHAR2(30) — Foreign key → MOVIE.MOVIE_ID — NOT NULL
- REVIEW_CONTENT (관람평 내용) — VARCHAR2(1000)
- REVIEW_DATE (작성 일자) — TIMESTAMP
SCREEN_DATE (상영시간표)
- THEATER_ID (상영관ID) — VARCHAR(20) — Foreign key → THEATER.THEATER_ID — NOT NULL
- MOVIE_ID (영화ID) — VARCHAR2(30) — Foreign key → MOVIE.MOVIE_ID — NOT NULL
- BRANCH_ID (지점ID2) — VARCHAR2(20) — Foreign key → THEATER.BRANCH_ID
- START_TIME (시작시간) — DATE
- END_TIME (상영종료시간) — DATE
SEAT (좌석)
- SEAT_ID (좌석ID) — VARCHAR2(20) — Primary key — NOT NULL
- RESERVE_ID (예매ID) — NUMBER — Foreign key → RESERVE.RESERVE_ID — NOT NULL
- THEATER_ID (상영관ID) — VARCHAR(20) — Foreign key → THEATER.THEATER_ID — NOT NULL
- SEAT_NUM (좌석 번호) — NUMBER
- SEAT_RESERVE_YN (예약 가능 YN) — CHAR(1)
THEATER (상영관)
- THEATER_ID (상영관ID) — VARCHAR(20) — Primary key — NOT NULL
- BRANCH_ID (지점ID) — VARCHAR2(20) — Foreign key → BRANCH.BRANCH_ID
- SCREEN_IN (수용인원) — NUMBER
USER_INFO (유저정보)
- USER_ID (유저ID) — VARCHAR2(20) — Primary key — NOT NULL
- USER_NAME (유저 이름) — VARCHAR2(20)
- USER_PW (유저 비밀번호) — VARCHAR2(20)
- USER_PHONE (핸드폰번호) — VARCHAR2(20)
- USER_EMAIL (이메일) — VARCHAR(20)
- BIRTH (생년월일) — DATE
- USER_JOIN (가입 날짜) — DATE