test

Tables (19)

p_artist_aliases

  • id — UUID — Primary key — NOT NULL
  • artist_id — UUID — Foreign key → p_artists.id — NOT NULL
  • alias — VARCHAR(150) — NOT NULL
  • language_code — VARCHAR(10)
  • alias_type — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — UUID
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — UUID
  • deleted_at — TIMESTAMPTZ
  • deleted_by — UUID

p_artist_fan_places

  • id — UUID — Primary key — NOT NULL
  • artist_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • place_id — UUID — NOT NULL
  • vote_count — BIGINT — NOT NULL
  • first_voted_at — TIMESTAMPTZ — NOT NULL
  • last_voted_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — UUID
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — UUID
  • deleted_at — TIMESTAMPTZ
  • deleted_by — UUID

p_artist_fan_rankings

  • id — UUID — Primary key — NOT NULL
  • artist_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • total_vote_count — BIGINT — NOT NULL
  • unique_place_count — BIGINT — NOT NULL
  • contribution_score — NUMERIC(20, 4) — NOT NULL
  • rank_position — INTEGER
  • first_contributed_at — TIMESTAMPTZ
  • last_contributed_at — TIMESTAMPTZ
  • calculated_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — UUID
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — UUID
  • deleted_at — TIMESTAMPTZ
  • deleted_by — UUID

p_artist_relations

  • id — UUID — Primary key — NOT NULL
  • parent_artist_id — UUID — Foreign key → p_artists.id — NOT NULL
  • child_artist_id — UUID — Foreign key → p_artists.id — NOT NULL
  • relation_type — VARCHAR(30) — NOT NULL
  • joined_at — DATE
  • left_at — DATE
  • display_order — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — UUID
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — UUID
  • deleted_at — TIMESTAMPTZ
  • deleted_by — UUID

p_artists

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(150) — NOT NULL
  • original_name — VARCHAR(150)
  • artist_type — VARCHAR(30) — NOT NULL
  • profile_image_url — VARCHAR(1000)
  • agency — VARCHAR(150)
  • description — TEXT
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — UUID
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — UUID
  • deleted_at — TIMESTAMPTZ
  • deleted_by — UUID

p_auth_users

  • id — UUID — Primary key — NOT NULL
  • keycloak_user_id — UUID — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image_url — VARCHAR(1000)
  • role — VARCHAR(30) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • preferred_language — VARCHAR(10) — NOT NULL
  • ranking_visibility — VARCHAR(20) — NOT NULL
  • last_login_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — UUID
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — UUID
  • deleted_at — TIMESTAMPTZ
  • deleted_by — UUID

p_content_artists

  • id — UUID — Primary key — NOT NULL
  • content_id — UUID — Foreign key → p_contents.id — NOT NULL
  • artist_id — UUID — Foreign key → p_artists.id — NOT NULL
  • participation_type — VARCHAR(30) — NOT NULL
  • character_name — VARCHAR(150)
  • display_order — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — UUID
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — UUID
  • deleted_at — TIMESTAMPTZ
  • deleted_by — UUID

p_content_evidences

  • id — UUID — Primary key — NOT NULL
  • content_id — UUID — Foreign key → p_contents.id — NOT NULL
  • evidence_type — VARCHAR(30) — NOT NULL
  • source_url — VARCHAR(1000) — NOT NULL
  • description — VARCHAR(1000)
  • verification_status — VARCHAR(20) — NOT NULL
  • verified_by — UUID
  • verified_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — UUID
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — UUID
  • deleted_at — TIMESTAMPTZ
  • deleted_by — UUID

p_contents

  • id — UUID — Primary key — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • original_title — VARCHAR(200)
  • content_type — VARCHAR(30) — NOT NULL
  • description — TEXT
  • thumbnail_url — VARCHAR(1000)
  • release_date — DATE
  • source_url — VARCHAR(1000)
  • publication_status — VARCHAR(20) — NOT NULL
  • verification_status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — UUID
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — UUID
  • deleted_at — TIMESTAMPTZ
  • deleted_by — UUID

p_place_artist_rankings

  • id — UUID — Primary key — NOT NULL
  • place_id — UUID — NOT NULL
  • artist_id — UUID — NOT NULL
  • vote_count — BIGINT — NOT NULL
  • unique_voter_count — BIGINT — NOT NULL
  • score — NUMERIC(20, 4) — NOT NULL
  • rank_position — INTEGER
  • is_main_artist — BOOLEAN — NOT NULL
  • first_voted_at — TIMESTAMPTZ
  • last_voted_at — TIMESTAMPTZ
  • calculated_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — UUID
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — UUID
  • deleted_at — TIMESTAMPTZ
  • deleted_by — UUID

p_place_content_rankings

  • id — UUID — Primary key — NOT NULL
  • place_id — UUID — NOT NULL
  • content_id — UUID — NOT NULL
  • vote_count — BIGINT — NOT NULL
  • unique_voter_count — BIGINT — NOT NULL
  • score — NUMERIC(20, 4) — NOT NULL
  • rank_position — INTEGER
  • is_main_content — BOOLEAN — NOT NULL
  • first_voted_at — TIMESTAMPTZ
  • last_voted_at — TIMESTAMPTZ
  • calculated_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — UUID
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — UUID
  • deleted_at — TIMESTAMPTZ
  • deleted_by — UUID

p_processed_events

  • id — UUID — Primary key — NOT NULL
  • event_id — UUID — NOT NULL
  • event_type — VARCHAR(50) — NOT NULL
  • aggregate_id — UUID — NOT NULL
  • processed_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — UUID
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — UUID
  • deleted_at — TIMESTAMPTZ
  • deleted_by — UUID

p_ranking_snapshots

  • id — UUID — Primary key — NOT NULL
  • ranking_type — VARCHAR(30) — NOT NULL
  • reference_id — UUID — NOT NULL
  • target_id — UUID — NOT NULL
  • period_type — VARCHAR(20) — NOT NULL
  • period_start — DATE — NOT NULL
  • period_end — DATE — NOT NULL
  • score — NUMERIC(20, 4) — NOT NULL
  • vote_count — BIGINT — NOT NULL
  • rank_position — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — UUID
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — UUID
  • deleted_at — TIMESTAMPTZ
  • deleted_by — UUID

p_social_accounts

  • id — UUID — Primary key — NOT NULL
  • auth_user_id — UUID — Foreign key → p_auth_users.id — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • provider_email — VARCHAR(320)
  • connected_at — TIMESTAMPTZ — NOT NULL
  • last_authenticated_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — UUID
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — UUID
  • deleted_at — TIMESTAMPTZ
  • deleted_by — UUID

p_visit_location_logs

  • id — UUID — Primary key — NOT NULL
  • visit_session_id — UUID — Foreign key → p_visit_sessions.id — NOT NULL
  • latitude — NUMERIC(10, 7) — NOT NULL
  • longitude — NUMERIC(10, 7) — NOT NULL
  • accuracy_m — NUMERIC(8, 2)
  • distance_from_place_m — NUMERIC(8, 2) — NOT NULL
  • is_mocked — BOOLEAN — NOT NULL
  • is_within_radius — BOOLEAN — NOT NULL
  • is_valid_sample — BOOLEAN — NOT NULL
  • measured_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — UUID
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — UUID
  • deleted_at — TIMESTAMPTZ
  • deleted_by — UUID

p_visit_sessions

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • place_id — UUID — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • failure_reason — VARCHAR(50)
  • place_latitude — NUMERIC(10, 7) — NOT NULL
  • place_longitude — NUMERIC(10, 7) — NOT NULL
  • verification_radius_m — NUMERIC(8, 2) — NOT NULL
  • required_stay_seconds — INTEGER — NOT NULL
  • started_at — TIMESTAMPTZ — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL
  • verified_at — TIMESTAMPTZ
  • start_latitude — NUMERIC(10, 7) — NOT NULL
  • start_longitude — NUMERIC(10, 7) — NOT NULL
  • start_accuracy_m — NUMERIC(8, 2)
  • last_latitude — NUMERIC(10, 7)
  • last_longitude — NUMERIC(10, 7)
  • minimum_distance_m — NUMERIC(8, 2)
  • maximum_distance_m — NUMERIC(8, 2)
  • valid_sample_count — INTEGER — NOT NULL
  • invalid_sample_count — INTEGER — NOT NULL
  • verified_duration_sec — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — UUID
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — UUID
  • deleted_at — TIMESTAMPTZ
  • deleted_by — UUID

p_vote_outbox_events

  • id — UUID — Primary key — NOT NULL
  • aggregate_type — VARCHAR(50) — NOT NULL
  • aggregate_id — UUID — NOT NULL
  • event_type — VARCHAR(50) — NOT NULL
  • payload — JSONB — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • retry_count — INTEGER — NOT NULL
  • next_retry_at — TIMESTAMPTZ
  • published_at — TIMESTAMPTZ
  • failure_message — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — UUID
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — UUID
  • deleted_at — TIMESTAMPTZ
  • deleted_by — UUID

p_vote_targets

  • id — UUID — Primary key — NOT NULL
  • vote_id — UUID — Foreign key → p_votes.id — NOT NULL
  • target_type — VARCHAR(20) — NOT NULL
  • target_id — UUID — NOT NULL
  • contribution_weight — NUMERIC(8, 4) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — UUID
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — UUID
  • deleted_at — TIMESTAMPTZ
  • deleted_by — UUID

p_votes

  • id — UUID — Primary key — NOT NULL
  • visit_session_id — UUID — Foreign key → p_visit_sessions.id — NOT NULL
  • user_id — UUID — NOT NULL
  • place_id — UUID — NOT NULL
  • vote_type — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • voted_at — TIMESTAMPTZ — NOT NULL
  • voted_on — DATE — NOT NULL
  • invalidated_reason — VARCHAR(1000)
  • invalidated_at — TIMESTAMPTZ
  • invalidated_by — UUID
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — UUID
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — UUID
  • deleted_at — TIMESTAMPTZ
  • deleted_by — UUID