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