CGV
테이블 (4)
상영관 (room)
- ro_num (PRIMARY KEY) — INT AUTO_INCREMENT NOT NULL — 기본 키 — NOT NULL
- ro_name (Field) — VARCHAR(10) NOT NULL
- ro_seat (Field2) — VARCHAR(5) NOT NULL
영화 (movie)
- mo_num (PRIMARY KEY) — INT AUTO_INCREMENT NOT NULL — 기본 키 — NOT NULL
- mo_title (Field) — VARCHAR(50) NOT NULL
- mo_contents (Field2) — LONGTEST NOT NULL
- mo_price (Field3) — INT(10) NOT NULL
- mo_ro_num (FOREIGN KEY(mo_ro_num) REFERENCES room(ro_num)) — INT NOT NULL
예매 (ticket)
- ti_num (PRIMARY KEY) — INT AUTO_INCREMENT NOT NULL — 기본 키 — NOT NULL
- ti_mo_num (FOREIGN KEY(ti_mo_num) REFERENCES movie(mo_num)) — INT NOT NULL
- ti_amount (Field2) — INT(5) NOT NULL
- ti_price (Field) — INT(10) NOT NULL
- ti_ro_num (FOREIGN KEY(ti_ro_num) REFERENCES room(ro_num)) — INT NOT NULL
- ti_ro_seat (FOREIGN KEY(ti_ro_seat) REFERENCES room(ro_seat)) — INT NOT NULL
회원 (member)
- me_id (PRIMARY KEY) — VARCHAR(15) — 기본 키 — NOT NULL
- me_pw (Field) — VARCHAR(20)
- me_RRNum (Field2) — VARCHAR(14)