정석코딩e조
테이블 (19)
Admin
- authorityKey — VARCHAR(255) — 기본 키 — NOT NULL
- Id — VARCHAR(255) — NOT NULL
- passwd — VARCHAR(255) — NOT NULL
- theatorId — VARCHAR(50) — NOT NULL
- adminstatus — INT — NOT NULL
FT1
- r_id — int — 기본 키 — NOT NULL
- t_id — int — 외래 키 → Theater.t_id — NOT NULL
- f_id — int — 외래 키 → Facilities.f_id — NOT NULL
FT2
- r_id — int — 기본 키 — NOT NULL
- t_d_id — int — 외래 키 → TheaterDetail.t_d_id — NOT NULL
- f_g_id — int — 외래 키 → FloorGuide.f_g_id — NOT NULL
Facilities
- f_id — int — 기본 키 — NOT NULL
- t_d_id — int
- f_name — VARCHAR(200)
- f_info — VARCHAR(200)
FloorGuide
- f_g_id — int — 기본 키 — NOT NULL
- t_d_id — int
- f_g — text
Region
- r_id — int — 기본 키 — NOT NULL
- r_name — VARCHAR(20)
Theater
- t_id — int — 기본 키 — NOT NULL
- t_name — varchar(20) — NOT NULL
- r_id — int — 외래 키 → Region.r_id — NOT NULL
- t_info — text
- a_map — text
- p_info — text
- tr_info — text
TheaterDetail
- t_d_id — int — 기본 키 — NOT NULL
- t_id — int — 외래 키 → Theater.t_id — NOT NULL
- t_d_name — VARCHAR(20)
ask
- ask_num — VARCHAR — 기본 키 — NOT NULL
- ask_title — VARCHAR — NOT NULL
- ask_content — VARCHAR — NOT NULL
- ask_answer — VARCHAR
- ask_status — VARCHAR — NOT NULL
- ask_date — DATE — NOT NULL
code_dictionary
- c_type — varchar — 기본 키 — NOT NULL
- c_category — varchar
- c_type_name — varchar — NOT NULL
- c_code — int — NOT NULL
- c_name — varchar — NOT NULL
- c_order — int
- c_used — varchar
- Field — VARCHAR(255)
m_evaluation
- me_no — int — 기본 키 — NOT NULL
- me_grade — int — NOT NULL
- me_post — varchar — NOT NULL
- m_no — int — 외래 키 → movie.m_no
movie
- m_no — int — 외래 키 → movie.m_no — NOT NULL
- m_name — varchar — NOT NULL
- m_actor — varchar — NOT NULL
- m_director — varchar — NOT NULL
- m_release_date — date — NOT NULL
- m_deadline — date
- m_status — int — NOT NULL
- m_showtime — int — NOT NULL
- m_detailedplot — varchar — NOT NULL
- m_plot — varchar — NOT NULL
- m_numberlikes — int — NOT NULL
- m_viewers — int — NOT NULL
movie_code
- m_no — int — 외래 키 → movie.m_no — NOT NULL
- c_type — varchar — 외래 키 → code_dictionary.c_type — NOT NULL
movie_image
- m_no — int — NOT NULL
- m_image — varchar — NOT NULL
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` — 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
user
- u_id — int — 기본 키 — NOT NULL
- u_name — varchar(255) — NOT NULL
- u_pwd — varchar(255) — NOT NULL
- u_email — varchar(255)t — NOT NULL
- u_birth — varchar(255) — NOT NULL
- r_date — VARCHAR(255)
- is_Admin — VARCHAR(255)
- point — int
- u_phone — varchar(255) — NOT NULL
- char(1) — VARCHAR(255)