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)