신민기
테이블 (5)
MEMBER
- MEMBER_ID — NUMBER(38) — 기본 키
- CUST_ID — VARCHAR2(100) — NOT NULL
- CUST_PASSWORD — VARCHAR2(100) — NOT NULL
- CUST_NAME — VARCHAR2(100) — NOT NULL
- CUST_EMAIL — VARCHAR2(300)
- CUST_PHONE — VARCHAR2(50) — NOT NULL
- CUST_POINT — NUMBER(38)
MOVIE
- MOV_ID — NUMBER(38) — 기본 키
- MOV_NAME — VARCHAR2(300) — NOT NULL
- MOV_GENRE — VARCHAR2(100) — NOT NULL
- MOV_ACTOR — VARCHAR2(100) — NOT NULL
- MOV_GRADE — NUMBER(38)
- MOV_SCORE — NUMBER(1,1) — NOT NULL
PAYMENT
- PAYMENT_ID — NUMBER(38) — 기본 키
- MEMBER_ID — NUMBER(38) — 외래 키 → MEMBER.MEMBER_ID
- RE_ID — NUMBER(38)CONSTRAINT — 외래 키 → RESERVATION.RE_ID
- PAYMENT_AMOUNT — NUMBER(10, 2) — NOT NULL
- PAYMENT_TICKETCOUNT — NUMBER(38) — NOT NULL
RESERVATION
- RE_ID — NUMBER(38)CONSTRAINT — 기본 키
- MEMBER_ID — NUMBER(38) — 외래 키 → MEMBER.MEMBER_ID
- MOV_ID — NUMBER(38) — 외래 키 → MOVIE.MOV_ID
- RE_SCTIME — VARCHAR2(100) — 외래 키 → SCREENING.SC_TIME — NOT NULL
- RE_SCSEAT — NUMBER(38) — 외래 키 → SCREENING.SC_SEAT — NOT NULL
SCREENING
- SC_TIME — VARCHAR2(100) — 기본 키 — NOT NULL
- SC_SEAT — NUMBER(38) — 기본 키 — NOT NULL
- MOV_ID — NUMBER(38) — 외래 키 → MOVIE.MOV_ID
- SC_PRICE — NUMBER(38) — NOT NULL