e조

테이블 (4)

movie_time

  • mt_id — INT — 기본 키 — NOT NULL
  • mt_m_name — VARCHAR — NOT NULL
  • mt_theater_name — VARCHAR — NOT NULL
  • mt_room_name — VARCHAR — NOT NULL
  • mt_date — DATE — NOT NULL
  • mt_starttime — TIME — NOT NULL
  • mt_endtime — TIME — NOT NULL

refund

  • rf_no — INT — 기본 키 — NOT NULL
  • rf_money — INT — NOT NULL
  • rf_point — INT — NOT NULL
  • rf_date — DATETIME — NOT NULL
  • tk_id — int — 외래 키 → ticketing.tk_id — NOT NULL

seat

  • s_id — INT — 기본 키 — NOT NULL
  • s_no — INT — NOT NULL
  • s_use — char(1) — NOT NULL — 환불 시 'N'
  • mt_id — INT — 외래 키 → movie_time.mt_id — NOT NULL
  • tk_id — int — 외래 키 → ticketing.tk_id — NOT NULL

ticketing

  • tk_id — int — 기본 키 — NOT NULL
  • tk_mt_date — DATE — NOT NULL
  • tk_mt_starttime — time — NOT NULL
  • tk_total_cust — INT — NOT NULL
  • tk_adult — INT — NOT NULL
  • tk_youth — INT — NOT NULL
  • tk_payment — INT — NOT NULL — 따로 테이블 있어야 하나
  • tk_total_amount — INT — NOT NULL
  • tk_used_point — INT — NOT NULL
  • tk_pay_money — INT — NOT NULL
  • tk_refund — char(1) — NOT NULL — 환불 시 'Y'로 변경
  • tk_date — DATETIME — NOT NULL