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