movie
Tables (12)
Auditorium
- AuditoriumID — varchar(255) — Primary key — NOT NULL
- locationID — varchar(255)
- AuditoriumName — varchar(255)
- AuditoriumSeats — varchar(255)
- AvailableSeats — varchar(255)
- UsedSeats — varchar(255)
- th_ID — INT — NOT NULL
Theator
- th_ID — INT — Primary key — NOT NULL
- th_Name — varchar(255)
- th_Address — varchar(255)
- re_name — varchar(255) — NOT NULL
Untitled
- ScreenID — varchar(255) — Primary key — NOT NULL
- ScreenDirector — varchar(255)
- ScreenActor — varchar(255)
- ScreenTime — INT
- ScreenNation — varchar(255)
- ScreenDate — varchar(255)
- ScreenStatus — Boolean
- ScreenImg — VARCHAR(255)
- Field — VARCHAR(255)
- m_no — int — NOT NULL
ask
- ask_no — int — Primary key — NOT NULL
- ask_adress — varchar(255)
- ask_title — varchar(255)
- ask_content — varchar(255)
- ask_answer — varchar(255)
- ask_status — varchar(255)
- ask_date — varchar(255)
- ask_name — varchar(255)
- ask_phone — varchar(255)
- ask_email — varchar(255)
moive
- m_no — int — Primary key — NOT NULL
- m-name — varchar(255)
- m_actor — varchar(255)
- m_directior — varchar(255)
- m_release_date — date
- m_deadline — date
- m_Screeningstatus — int
- m_Showtime — int
- m_genre — varchar(255)
- m_plot — varchar(255)
- m_Detailed_plot — varchar(255)
- Field — int
- Field2 — VARCHAR(255)
receipt
- re_num — int — Primary key — NOT NULL
- re_seats_num — int
- re_price — int
- re_tk_num — int — NOT NULL
- seats_num2 — int — NOT NULL
refund
- refundID — varchar(255) — Primary key — NOT NULL
- refund_amount — int
- refund_date — datetime
- tk_num — int — NOT NULL
region
- re_name — varchar(255) — Primary key — NOT NULL
screen
- sc_num — int — Primary key — NOT NULL
- sc_m_num — int
- sc_ci_num — int
- sc_start_time — datetime
- sc_pos_seat — int
- sc_end_time — datetime
- m_no — int — NOT NULL
- AuditoriumID — varchar(255) — NOT NULL
seat
- seats_num — int — Primary key — NOT NULL
- seats_th_num — int
- seats_name — varchar(255)
- seats_use — char(1)
- AuditoriumID — varchar(255) — NOT NULL
ticketing
- tk_num — int — Primary key — NOT NULL
- tk_user_id — varchar(255)
- tk_date — datetime
- tk_state — char(1)
- tk_amount — int
- tk_price — int
- tk_sc_num — int — NOT NULL
user
- u_id — INT — Primary key — NOT NULL
- u_name — varchar(255)
- u_pwd — varchar(255)
- u_email — varchar(255)
- u_birth — varchar(255)
- r_date — VARCHAR(255)
- isAdmin — VARCHAR(255)
- u_phone — varchar(255)
- point — int
- char(1) — VARCHAR(255)