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