ㅁㄴㅇㄻ
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