영화예매

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