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