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