ㅅㄷㄴㅅ
Tables (19)
booking_links
- id — BIGINT — Primary key — NOT NULL
- performance_id — VARCHAR(20) — Foreign key → performances.performance_id — NOT NULL
- site_name — VARCHAR(100) — NOT NULL
- url — VARCHAR(1000) — NOT NULL
community_comments
- id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → community_posts.id — NOT NULL
- author_id — BIGINT — Foreign key → users.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
community_post_images
- id — BIGINT — Primary key — NOT NULL
- uploader_id — BIGINT — Foreign key → users.id — NOT NULL
- image — VARCHAR(100) — NOT NULL
- original_name — VARCHAR(255) — NOT NULL
- size — INT — NOT NULL
- content_type — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
community_posts
- id — BIGINT — Primary key — NOT NULL
- author_id — BIGINT — Foreign key → users.id — NOT NULL
- category — VARCHAR(40) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- content_format — VARCHAR(20) — NOT NULL
- thumbnail_url — VARCHAR(1000) — NOT NULL
- view_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
performance_images
- id — BIGINT — Primary key — NOT NULL
- performance_id — VARCHAR(20) — Foreign key → performances.performance_id — NOT NULL
- image_url — VARCHAR(1000) — NOT NULL
- sort_order — SMALLINT — NOT NULL
performance_prices
- id — BIGINT — Primary key — NOT NULL
- performance_id — VARCHAR(20) — Foreign key → performances.performance_id — NOT NULL
- label — VARCHAR(100) — NOT NULL
- price — INT — NOT NULL
- currency — VARCHAR(10) — NOT NULL
- raw_text — VARCHAR(255) — NOT NULL
- sort_order — SMALLINT — NOT NULL
performances
- performance_id — VARCHAR(20) — Primary key — NOT NULL
- title — VARCHAR(500) — NOT NULL
- genre — VARCHAR(100) — NOT NULL
- genre_code — VARCHAR(10) — NOT NULL
- start_date — DATE
- end_date — DATE
- status — VARCHAR(20) — NOT NULL
- status_code — VARCHAR(10) — NOT NULL
- stage_id — VARCHAR(20) — NOT NULL
- facility_name — VARCHAR(255) — NOT NULL
- first_registered_at — DATETIME
- kopis_updated_at — DATETIME
- cast — TEXT — NOT NULL
- crew — TEXT — NOT NULL
- runtime — VARCHAR(100) — NOT NULL
- age_rating — VARCHAR(50) — NOT NULL
- synopsis — TEXT — NOT NULL
- price_info — TEXT — NOT NULL
- min_price — INT
- max_price — INT
- is_free — BOOLEAN — NOT NULL
- price_parse_status — VARCHAR(20) — NOT NULL
- schedule_info — TEXT — NOT NULL
- openrun — BOOLEAN — NOT NULL
- is_visit — BOOLEAN — NOT NULL
- is_child — BOOLEAN — NOT NULL
- is_daehakro — BOOLEAN — NOT NULL
- is_festival — BOOLEAN — NOT NULL
- is_musical_license — BOOLEAN — NOT NULL
- is_musical_create — BOOLEAN — NOT NULL
- production_company — VARCHAR(255) — NOT NULL
- agency — VARCHAR(255) — NOT NULL
- host — VARCHAR(255) — NOT NULL
- organizer — VARCHAR(255) — NOT NULL
- poster_url — VARCHAR(1000) — NOT NULL
- venue_id — VARCHAR(20) — Foreign key → venues.venue_id
- view_count — INT — NOT NULL
- zzim_count — INT — NOT NULL
- synced_at — DATETIME — NOT NULL
qna_logs
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id
- question — TEXT — NOT NULL
- answer — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
recommendation_feedback
- id — BIGINT — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → recommendation_sessions.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id
- performance_id — VARCHAR(20) — Foreign key → performances.performance_id
- feedback_type — VARCHAR(30) — NOT NULL
- metadata — JSON — NOT NULL
- created_at — DATETIME — NOT NULL
recommendation_items
- id — BIGINT — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → recommendation_sessions.id — NOT NULL
- performance_id — VARCHAR(20) — Foreign key → performances.performance_id — NOT NULL
- rank — INT — NOT NULL
- score — DOUBLE — NOT NULL
- reason — TEXT — NOT NULL
- source — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
recommendation_performance_vectors
- id — BIGINT — Primary key — NOT NULL
- performance_id — VARCHAR(20) — Foreign key → performances.performance_id — NOT NULL
- vector_data — JSON — NOT NULL
- source_summary — JSON — NOT NULL
- version — INT — NOT NULL
- updated_at — DATETIME — NOT NULL
recommendation_sessions
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id
- request_text — TEXT — NOT NULL
- provider — VARCHAR(50) — NOT NULL
- model_name — VARCHAR(100) — NOT NULL
- prompt_version — VARCHAR(50) — NOT NULL
- user_profile_snapshot — JSON — NOT NULL
- candidate_snapshot — JSON — NOT NULL
- raw_response — JSON — NOT NULL
- parsed_response — JSON — NOT NULL
- validation_status — VARCHAR(20) — NOT NULL
- fallback_used — BOOLEAN — NOT NULL
- quality_score — DOUBLE
- created_at — DATETIME — NOT NULL
recommendation_training_candidates
- id — BIGINT — Primary key — NOT NULL
- source_session_id — BIGINT — Foreign key → recommendation_sessions.id — NOT NULL
- status — VARCHAR(30) — NOT NULL
- training_task — VARCHAR(50) — NOT NULL
- input_payload — JSON — NOT NULL
- output_payload — JSON — NOT NULL
- chosen_output — JSON — NOT NULL
- rejected_output — JSON — NOT NULL
- quality_score — DOUBLE — NOT NULL
- rejection_reasons — JSON — NOT NULL
- approved_for_training — BOOLEAN — NOT NULL
- reviewed_by_id — BIGINT — Foreign key → users.id
- reviewed_at — DATETIME
- exported_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
recommendation_user_profiles
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- vector_data — JSON — NOT NULL
- source_summary — JSON — NOT NULL
- last_built_at — DATETIME
- is_stale — BOOLEAN — NOT NULL
- version — INT — NOT NULL
- updated_at — DATETIME — NOT NULL
search_logs
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id
- keyword — VARCHAR(255) — NOT NULL
- filter_region — VARCHAR(100) — NOT NULL
- filter_genre — VARCHAR(100) — NOT NULL
- filter_status — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- password — VARCHAR(128) — NOT NULL
- last_login — DATETIME
- email — VARCHAR(254) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- provider — VARCHAR(10) — NOT NULL
- provider_id — VARCHAR(255) — NOT NULL
- refresh_token — VARCHAR(512) — NOT NULL
- refresh_token_expires_at — DATETIME
- status — INT — NOT NULL
- is_admin — BOOLEAN — NOT NULL
- is_staff — BOOLEAN — NOT NULL
- is_superuser — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users_performance_actions
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- performance_id — VARCHAR(20) — Foreign key → performances.performance_id — NOT NULL
- action_type — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
venues
- venue_id — VARCHAR(20) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- facility_characteristic — VARCHAR(100) — NOT NULL
- sido — VARCHAR(50) — NOT NULL
- gugun — VARCHAR(50) — NOT NULL
- address — VARCHAR(500) — NOT NULL
- homepage_url — VARCHAR(1000) — NOT NULL
- has_parking_lot — BOOLEAN — NOT NULL
- latitude — DECIMAL(10, 7)
- longitude — DECIMAL(10, 7)
- seat_scale — INT
- synced_at — DATETIME — NOT NULL
view_logs
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id
- performance_id — VARCHAR(20) — NOT NULL
- log_type — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL