영화예매
테이블 (4)
MEMBERS
- USERID — VARCHAR2(15) — 기본 키 — NOT NULL
- USERPW — VARCHAR2(20) — NOT NULL
- USERNAME — VARCHAR2(8) — NOT NULL
- USEBIRTH — DATE
- USERGENDER — VARCHAR2(1)
- USERPHONE — VARCHAR2(13)
- USERADDRESS — VARCHAR2(60)
MOVIES
- 영화코드 (MOVIEID) — VARCHAR2(4) — 기본 키 — NOT NULL
- 영화이름 (MOVIENAME) — VARCHAR2(30) — NOT NULL
- 영화감독 (MOVIEPD) — VARCHAR2(20)
- 영화배우 (MOVIEACTOR) — VARCHAR2(50)
- MOVIEGENRE — VARCHAR2(20)
- MOVIEAGE — NUMBER
- MOVIETIME — NUMBER
- MOVIEOPEN — DATE
SCHEDULES
- SCROOM — VARCHAR2(10)
- SCDATE — DATE
- SCTHCODE — NVARCHAR2(4)
- SCMVCODE — NVARCHAR2(4)
THEATERS
- THID — VARCHAR2(4) — 기본 키 — NOT NULL
- THNAME — VARCHAR2(20)
- THADDRESS — VARCHAR2(60)
- THTEL — VARCHAR2(15)