의진
테이블 (4)
MEMBER_DB
- MEMBER_ID — NUMBER(38) — 기본 키
- USER_ID — VARCHAR2(20) — NOT NULL
- USER_PW — VARCHAR2(20) — NOT NULL
- USER_NAME — VARCHAR2(300) — NOT NULL
- USER_EMAIL — VARCHAR2(300) — NOT NULL
- USER_PHONE — VARCHAR2(20) — NOT NULL
- USER_PIN — VARCHAR2(20) — NOT NULL
MOVIE_DB
- MOVIE_CODE — NUMBER(38) — 기본 키
- TITLE — VARCHAR2(300) — NOT NULL
- GENRE — VARCHAR2 — NOT NULL
- SCORE — NUMBER — NOT NULL
- PRIVIEW — VARCHAR(4000) — NOT NULL
RESERVATION_DB
- ORDER_ID — NUMBER(38) — 기본 키
- MOVIE_CODE — NUMBER(38)
- THEATER_CODE — NUMBER(38)
- RB_DATE — DATE
- RB_TIME — VARCHAR2(50)
- SEAT — VARCHAR2(38)
- THEATER_ID — NUMBER(38) — NOT NULL
THEATER_DB
- THEATER_CODE — NUMBER(38)
- THEATER_NAME — VARCHAR2(100) — NOT NULL
- THEATER_ID — NUMBER(38) — NOT NULL