megabox

Tables (4)

business (영업점)

  • busName (영업점이름) — VARCHAR(10) — Primary key — NOT NULL
  • cityName (도시이름) — VARCHAR(10) — NOT NULL
  • localName (지역이름) — VARCHAR(50) — NOT NULL

member

  • id (아이디) — VARCHAR(10) — Primary key — NOT NULL
  • pwd (비밀번호) — VARCHAR(20)
  • name (이름) — VARCHAR(20)
  • phone (전화번호) — VARCHAR(15)
  • addr (주소) — VARCHAR(50)
  • birthd (생년월일) — VARCHAR(30)

movie (영화)

  • movieNo (영화번호) — VARCHAR(10) — Primary key — NOT NULL
  • title (영화제목) — VARCHAR(20)
  • director (감독) — VARCHAR(10)
  • actor (주연) — VARCHAR(50)
  • genre (장르) — VARCHAR(10)
  • runningtime (상영시간) — VARCHAR(10)
  • openDate (개봉일) — VARCHAR(20)
  • num-seat (좌석수) — integer
  • price (가격) — integer

reservation (예약)

  • id (아이디2) — VARCHAR(10) — Foreign key → member.id — NOT NULL
  • movieNo (영화번호2) — VARCHAR(10) — Foreign key → movie.movieNo — NOT NULL
  • busName (영업점이름2) — VARCHAR(10) — Foreign key → business.busName — NOT NULL
  • cityName (도시이름) — VARCHAR(10)
  • localName (지역이름) — VARCHAR(10)
  • seatNo (좌석번호) — VARCHAR(20)
  • startTime (시작시간) — VARCHAR(40)