erd
Tables (24)
admins
- admin_id — INT
- admin_acc — VARCHAR(50) — NOT NULL
- admin_role — VARCHAR(20) — NOT NULL
- th_id — INT
auditoriums
- audit_id — INT
- th_id — INT — NOT NULL
- audit_name — VARCHAR(50) — NOT NULL
- audit_type — VARCHAR(20) — NOT NULL
- total_seats — INT — NOT NULL
booking_tickets
- tkt_id — BIGINT
- bk_id — BIGINT — NOT NULL
- st_id — BIGINT — NOT NULL
- tkt_type — VARCHAR(20) — NOT NULL
- tkt_price — INT — NOT NULL
bookings
- bk_id — BIGINT
- user_id — BIGINT
- show_id — BIGINT — NOT NULL
- guest_name — VARCHAR(50)
- guest_phone — VARCHAR(20)
- guest_pw — VARCHAR(255)
- bk_total_price — INT — NOT NULL
- bk_state — VARCHAR(20) — NOT NULL
- bk_reg_dt — DATETIME
distributors
- dist_id — INT
- dist_name — VARCHAR(100) — NOT NULL
- biz_no — VARCHAR(20) — NOT NULL
- contact_info — VARCHAR(100)
inquiries
- inquiry_id — BIGINT
- user_id — BIGINT — NOT NULL
- inq_title — VARCHAR(100) — NOT NULL
- inq_content — TEXT — NOT NULL
- inq_file_url — VARCHAR(255)
- inq_status — VARCHAR(20)
- admin_reply — TEXT
- replied_at — DATETIME
- reg_dt — DATETIME
log_anomalies
- log_id — BIGINT
- error_type — VARCHAR(50) — NOT NULL
- error_msg — TEXT — NOT NULL
- detected_at — DATETIME
login_logs
- log_id — BIGINT
- user_id — BIGINT
- log_ip — VARCHAR(45) — NOT NULL
- log_status — VARCHAR(10) — NOT NULL
- log_dt — DATETIME
movies
- mv_id — BIGINT
- dist_id — INT — NOT NULL
- mv_title — VARCHAR(100) — NOT NULL
- mv_age_limit — VARCHAR(10) — NOT NULL
- genre — VARCHAR(50)
- mv_release_date — DATE — NOT NULL
- mv_runtime — INT — NOT NULL
- mv_poster — VARCHAR(255)
- mv_state — VARCHAR(20) — NOT NULL
notices
- notice_id — BIGINT
- admin_id — INT — NOT NULL
- notice_title — VARCHAR(100) — NOT NULL
- notice_content — TEXT — NOT NULL
- is_fixed — BOOLEAN
- view_count — INT
- start_date — DATETIME
- end_date — DATETIME
- reg_dt — DATETIME
payments
- pay_id — BIGINT
- bk_id — BIGINT
- pay_type — VARCHAR(20) — NOT NULL
- pay_amount — INT — NOT NULL
- pay_method — VARCHAR(20) — NOT NULL
- pay_dt — DATETIME
pg_logs
- log_id — BIGINT
- pay_id — BIGINT — NOT NULL
- req_json — TEXT
- res_json — TEXT
- res_code — VARCHAR(10)
point_logs
- pl_id — BIGINT
- user_id — BIGINT — NOT NULL
- pl_type — VARCHAR(10) — NOT NULL
- pl_amt — INT — NOT NULL
- pl_reason — VARCHAR(100) — NOT NULL
- ref_id — BIGINT
- pl_dt — DATETIME
price_policies
- pp_id — INT
- pp_day — VARCHAR(20) — NOT NULL
- pp_time — VARCHAR(20) — NOT NULL
- pp_target — VARCHAR(20) — NOT NULL
- pp_price — INT — NOT NULL
reviews
- review_id — BIGINT
- mv_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- bk_id — BIGINT — NOT NULL
- review_rate — TINYINT — NOT NULL
- review_content — TEXT — NOT NULL
- report_cnt — INT
- is_blinded — BOOLEAN
- reg_dt — DATETIME
seats
- st_id — BIGINT
- audit_id — INT — NOT NULL
- st_row — VARCHAR(5) — NOT NULL
- st_col — INT — NOT NULL
- st_type — VARCHAR(20) — NOT NULL
- st_zone — VARCHAR(20) — NOT NULL
- is_active — BOOLEAN
settlements
- settle_id — BIGINT
- mv_id — BIGINT — NOT NULL
- dist_id — INT — NOT NULL
- settle_ym — VARCHAR(6) — NOT NULL
- total_revenue — DECIMAL(15,2) — NOT NULL
- dist_share — DECIMAL(15,2) — NOT NULL
show_seat_status
- ss_id — BIGINT
- show_id — BIGINT — NOT NULL
- st_id — BIGINT — NOT NULL
- ss_status — VARCHAR(20)
- hold_expire_dt — DATETIME
showtimes
- show_id — BIGINT
- mv_id — BIGINT — NOT NULL
- audit_id — INT — NOT NULL
- start_dt — DATETIME — NOT NULL
- end_dt — DATETIME — NOT NULL
- time_segment — VARCHAR(20) — NOT NULL
social_accounts
- social_id — BIGINT
- user_id — BIGINT — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_uid — VARCHAR(255) — NOT NULL
- connected_at — DATETIME
stats_sales_daily
- stats_date — DATE — Primary key — NOT NULL
- th_id — INT — Primary key — NOT NULL
- total_rev — DECIMAL(15,2)
- ticket_cnt — INT
- refund_amt — DECIMAL(15,2)
system_configs
- cfg_key — VARCHAR(50)
- cfg_val — VARCHAR(100) — NOT NULL
- description — VARCHAR(255)
theaters
- th_id — INT
- th_name — VARCHAR(50) — NOT NULL
- th_region — VARCHAR(20) — NOT NULL
- th_manager_name — VARCHAR(50) — NOT NULL
- th_manager_phone — VARCHAR(20) — NOT NULL
users
- user_id — BIGINT
- user_email — VARCHAR(100)
- user_pw — VARCHAR(255)
- user_name — VARCHAR(50) — NOT NULL
- user_phone — VARCHAR(20) — NOT NULL
- user_birth — DATE — NOT NULL
- user_grade — VARCHAR(20)
- user_point — INT
- user_status — CHAR(1)
- user_last_dt — DATETIME
- user_reg_dt — DATETIME
- user_withdrawn_at — DATETIME