erd1

Tables (3)

member

  • member_number — NUMBER(10) — Primary key — NOT NULL
  • name — VARCHAR2(50)
  • id — VARCHAR2(50)
  • password — VARCHAR2(50)
  • mnum — NUMBER(10) — Foreign key → movies.mnum — NOT NULL
  • member_number (member_number2) — NUMBER(10) — Foreign key → reservation.member_number — NOT NULL
  • mnum (mnum2) — NUMBER(10) — Foreign key → reservation.mnum — NOT NULL

movies

  • mnum — NUMBER(10) — Primary key — NOT NULL
  • movie — VARCHAR2(100)
  • director — VARCHAR2(50)
  • count — NUMBER(5)
  • price — NUMBER(10, 2)

reservation

  • member_number — NUMBER(10) — Primary key — NOT NULL
  • mnum — NUMBER(10) — Foreign key → movies.mnum — NOT NULL
  • reservation_date — DATE
  • seats — NUMBER(3)