ㅁㄴㅇㄻ

Tables (6)

CINEMA

  • C_ID — number — Primary key — NOT NULL
  • C_NAME — varchar2
  • C_TIME — varchar2
  • C_ADD — varchar2
  • C_TEL — varchar2
  • C_SEAT — varchar2

MOVIE

  • M_ID — number — Primary key — NOT NULL
  • M_NAME — varchar2 — NOT NULL
  • M_INPO — varchar2
  • M_IMG — varchar2

SHOW_INPO

  • S_TIME_ID — number — Primary key — NOT NULL
  • S_TIME — varchar2
  • M_ID — number — NOT NULL
  • C_ID — number — NOT NULL

USER

  • USER_ID — varchar2 — Primary key — NOT NULL
  • USER_NAME — varchar2
  • USER_PW — varchar2
  • USER_TEL — varchar2

cinema_movie

  • C_ID — number — Foreign key → CINEMA.C_ID — NOT NULL
  • M_ID — number — Foreign key → MOVIE.M_ID — NOT NULL

reservation

  • 예매_ID — varchar2 — Primary key — NOT NULL
  • EA — varchar2
  • S_TIME_ID — number — NOT NULL
  • USER_ID — varchar2 — NOT NULL
  • C_ID — number — NOT NULL
  • M_ID — number — NOT NULL