08.27작업테이블

테이블 (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

MOVIE

  • MOV_ID — NUMBER(38)
  • MOV_NAME — VARCHAR2(300) — NOT NULL
  • MOV_GENRE — VARCHAR2(100) — NOT NULL
  • MOV_ACTOR — VARCHAR2(4000) — NOT NULL
  • MOV_GRADE — NUMBER(38)
  • MOV_SCORE — NUMBER(2, 1) — NOT NULL

PAYMENT

  • PAYMENT_ID — NUMBER(38)
  • PAYMENT_MEMID — NUMBER(38) — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
  • PAYMENT_REID — NUMBER(38) — 외래 키 → RESERVATION.RE_ID — NOT NULL
  • PAYMENT_PRICE — NUMBER(38) — NOT NULL
  • PAYMENT_TICKETCOUNT — NUMBER(38) — NOT NULL
  • PAY_SCTIME — VARCHAR2(100) — 외래 키 → SCREENING.SC_TIME — NOT NULL
  • PAY_SCSEAT — NUMBER(38) — 외래 키 → SCREENING.SC_SEAT — NOT NULL

RESERVATION

  • RE_ID — NUMBER(38)
  • RE_MEMID — NUMBER(38) — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
  • RE_MOVID — NUMBER(38) — 외래 키 → MOVIE.MOV_ID — NOT NULL
  • 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
  • SC_MOVID — NUMBER(38) — 외래 키 → MOVIE.MOV_ID — NOT NULL