CulturePick
Tables (9)
Booking_Links
- link_id — BIGINT
- performance_id — VARCHAR(255) — Foreign key → Performances.performance_id
- site_name — VARCHAR(100) — 예매처명
- url — VARCHAR(500) — 예매 URL
Performance_Images
- image_id — BIGINT
- performance_id — VARCHAR(255) — Foreign key → Performances.performance_id
- image_url — VARCHAR(500) — 소개이미지 URL
- sort_order — INT — 정렬순서
Performances
- performance_id — VARCHAR(255) — KOPIS mt20id
- title — VARCHAR(255) — 공연명
- genre — VARCHAR(50) — 장르
- start_date — DATE — 공연시작일
- end_date — DATE — 공연종료일
- status — VARCHAR(50) — 공연중/예정/완료
- cast — TEXT — 출연진
- crew — TEXT — 스태프
- runtime — VARCHAR(50) — 공연런타임
- price_info — TEXT — 티켓가격
- poster_url — VARCHAR(255) — 포스터 URL
- venue_id — VARCHAR(255) — Foreign key → Venues.venue_id
- view_count — INT — 조회수
- zzim_count — INT — 관심저장수
- synced_at — DATETIME — KOPIS 동기화
QnA_Logs
- qna_id — BIGINT
- user_id — BIGINT — Foreign key → Users.user_id
- question — TEXT — 사용자 질문
- answer — TEXT — AI 답변
- created_at — DATETIME
Search_Logs
- log_id — BIGINT
- user_id — BIGINT — Foreign key → Users.user_id — nullable
- keyword — VARCHAR(255) — 검색어
- filter_region — VARCHAR(100) — 지역 필터
- filter_genre — VARCHAR(100) — 장르 필터
- filter_status — VARCHAR(50) — 공연상태 필터
- created_at — DATETIME
Users
- user_id — BIGINT
- email — VARCHAR(255)
- password — VARCHAR(255) — nullable-소셜
- provider — VARCHAR(50) — local/google/kakao/naver
- provider_id — VARCHAR(255) — 소셜 고유ID
- refresh_token — VARCHAR(255)
- refresh_token_expires_at — DATETIME
- nickname — VARCHAR(100)
- phone — VARCHAR(50)
- created_at — DATETIME
- status — TINYINT — 유저 상태
- is_admin — TINYINT — 관리자 여부
Users_Performance_Actions
- action_id — BIGINT
- user_id — BIGINT — Foreign key → Users.user_id
- performance_id — VARCHAR(255) — Foreign key → Performances.performance_id
- action_type — VARCHAR(50) — watchlist/interest
- created_at — DATETIME
Venues
- venue_id — VARCHAR(255) — KOPIS mt10id
- name — VARCHAR(255) — 공연시설명
- sido — VARCHAR(50) — 시도
- gugun — VARCHAR(50) — 구군
- address — VARCHAR(255) — 주소
- latitude — DECIMAL(10, 8) — 위도
- longitude — DECIMAL(11, 8) — 경도
- seat_scale — INT — 좌석규모
- synced_at — DATETIME — KOPIS 동기화
View_Logs
- log_id — BIGINT
- user_id — BIGINT — Foreign key → Users.user_id — nullable
- performance_id — VARCHAR(255) — Foreign key → Performances.performance_id
- log_type — VARCHAR(50) — 상호작용 종류
- created_at — DATETIME