DBCnu

Tables (4)

MEMBER (회원)

  • SSN (회원번호) — NUMBER — Primary key — NOT NULL
  • PASSWORD (비밀번호) — VARCHAR2(20)
  • AGE (만나이) — NUMBER
  • NAME (이름) — VARCHAR2(100)
  • SEX (성별) — VARCHAR2(10)
  • EMAIL (이메일) — VARCHAR2(20)

MOVIE (영화)

  • MOVIE_NUM (영화고유번호) — NUMBER — Primary key — NOT NULL
  • MOVIE_NAME (영화이름) — VARCHAR2(20)
  • OPENING_DATE (개봉일시) — DATE
  • DIRECTOR (감독) — VARCHAR2(10)
  • VIEWING_AGE (제한연령) — NUMBER
  • PWEFORMER (출연배우) — VARCHAR2(100)
  • SHOWTIME (상영시간(분)) — NUMBER
  • Field

RESERVATION (예약)

  • Key — Primary key — NOT NULL
  • SSN (회원번호) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

THEATERS (상영관)

  • TEATER_NUM (상영관번호) — NUMBER — Primary key — NOT NULL
  • THEATER_NAME (상영관이름) — VARCHAR2(10)
  • SEATS (좌석수) — NUMBER
  • Field