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)