YeoBaek

Tables (23)

avatar_equipments

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key — NOT NULL
  • item_id — BIGINT — Foreign key → user_inventory_items.item_id — NOT NULL
  • slot — VARCHAR(20) — Foreign key → game_items.slot — NOT NULL
  • slot_position — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

diaries

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • visit_id — BIGINT
  • diary_date — DATE — NOT NULL
  • place_name — VARCHAR(255)
  • region — VARCHAR(255)
  • emotion — VARCHAR(50)
  • content — VARCHAR(2000)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

diary_medias

  • id — BIGSERIAL — Primary key — NOT NULL
  • diary_id — BIGINT — Foreign key → diaries.id — NOT NULL
  • media_type — VARCHAR(10) — NOT NULL
  • object_key — VARCHAR(500) — NOT NULL
  • duration_sec — INT
  • sort_order — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

favorites

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key — NOT NULL
  • place_id — BIGINT — Foreign key → places.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

game_item_regions

  • game_item_id — BIGINT — Foreign key → game_items.id — NOT NULL
  • region_code — VARCHAR(40) — Foreign key — NOT NULL

game_items

  • id — BIGSERIAL — Primary key — NOT NULL
  • code — VARCHAR(100) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(1000) — NOT NULL
  • slot — VARCHAR(20) — NOT NULL
  • rarity — VARCHAR(20) — NOT NULL
  • image_url — VARCHAR(1000) — NOT NULL
  • silhouette_url — VARCHAR(1000) — NOT NULL
  • preview_image_url — VARCHAR(1000) — NOT NULL
  • acquisition_hint — VARCHAR(500) — NOT NULL
  • visit_reward — BOOLEAN — NOT NULL
  • recurring_reward — BOOLEAN — NOT NULL
  • duplicate_stamp_amount — INTEGER — NOT NULL
  • active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

missions

  • id — BIGSERIAL — Primary key — NOT NULL
  • code — VARCHAR(100) — NOT NULL
  • title — VARCHAR(150) — NOT NULL
  • description — VARCHAR(1000) — NOT NULL
  • mission_type — VARCHAR(20) — NOT NULL
  • condition_type — VARCHAR(40) — NOT NULL
  • target_count — INTEGER — NOT NULL
  • reward_item_id — BIGINT — Foreign key → game_items.id
  • reward_stamp_amount — INTEGER — NOT NULL
  • active — BOOLEAN — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

places

  • id — BIGSERIAL — Primary key — NOT NULL
  • content_id — VARCHAR(100) — NOT NULL
  • content_type_id — VARCHAR(20)
  • title — VARCHAR(255) — NOT NULL
  • category — VARCHAR(100) — NOT NULL
  • address — VARCHAR(500) — NOT NULL
  • latitude — DOUBLE PRECISION — NOT NULL
  • longitude — DOUBLE PRECISION — NOT NULL
  • thumbnail — VARCHAR(1000)
  • image — VARCHAR(1000)
  • seoul_area_key — VARCHAR(100)
  • geofence_radius_m — INTEGER — NOT NULL
  • region_code — VARCHAR(40) — Foreign key → regions.code — NOT NULL
  • is_indoor — BOOLEAN
  • mapping_status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

postcards

  • id — BIGSERIAL — Primary key — NOT NULL
  • diary_id — BIGINT — Foreign key → diaries.id — NOT NULL
  • object_key — VARCHAR(500) — NOT NULL
  • format — VARCHAR(10) — NOT NULL
  • template_id — VARCHAR(100)
  • avatar_applied — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

regions

  • code — VARCHAR(40) — Primary key — NOT NULL
  • sigungu_code — VARCHAR(5)
  • display_name — VARCHAR(60) — NOT NULL

reward_grants

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key — NOT NULL
  • source_type — VARCHAR(20) — NOT NULL
  • source_id — BIGINT — NOT NULL
  • item_id — BIGINT — Foreign key → game_items.id
  • stamp_amount — INTEGER — NOT NULL
  • outcome — VARCHAR(30) — NOT NULL
  • granted_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • acknowledged_at — TIMESTAMP WITH TIME ZONE
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

trip_interest_tags

  • sort_order — INT — Primary key — NOT NULL
  • trip_setting_id — BIGINT — Foreign key → trip_settings.trip_setting_id — NOT NULL
  • interest_tag — VARCHAR(20) — NOT NULL

trip_settings

  • trip_setting_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • trip_name — VARCHAR(100)
  • region — VARCHAR(100) — NOT NULL
  • trip_date — DATE
  • trip_end_date — DATE
  • start_time — TIME
  • available_minutes — INT
  • transport — VARCHAR(20)
  • companion_type — VARCHAR(20)
  • travel_style — VARCHAR(20)
  • indoor_outdoor_preference — VARCHAR(20)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user_category_preferences

  • preference_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • category_code — VARCHAR(30) — NOT NULL
  • explicit_score — DOUBLE PRECISION — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user_game_profiles

  • user_id — BIGINT — Foreign key — NOT NULL
  • stamp_balance — INTEGER — NOT NULL
  • representative_image_url — VARCHAR(1000)
  • avatar_revision — BIGINT — NOT NULL
  • avatar_updated_at — TIMESTAMP WITH TIME ZONE
  • version — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user_interest_tags

  • sort_order — INT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • interest_tag — VARCHAR(20) — NOT NULL

user_inventory_items

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key — NOT NULL
  • item_id — BIGINT — Foreign key → game_items.id — NOT NULL
  • is_new — BOOLEAN — NOT NULL
  • acquired_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user_mission_progress

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key — NOT NULL
  • mission_id — BIGINT — Foreign key → missions.id — NOT NULL
  • cycle_key — VARCHAR(30) — NOT NULL
  • period_start_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • period_end_at — TIMESTAMP WITH TIME ZONE
  • progress_count — INTEGER — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • achieved_at — TIMESTAMP WITH TIME ZONE
  • claimed_at — TIMESTAMP WITH TIME ZONE
  • expired_at — TIMESTAMP WITH TIME ZONE
  • resolved_reward_item_id — BIGINT — Foreign key → game_items.id
  • reward_resolved — BOOLEAN — NOT NULL
  • version — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user_place_interactions

  • interaction_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key — NOT NULL
  • place_id — BIGINT — Foreign key → places.id — NOT NULL
  • category_code — VARCHAR(30) — NOT NULL
  • interaction_type — VARCHAR(30) — NOT NULL
  • occurred_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user_preferred_regions

  • sort_order — INT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • preferred_region — VARCHAR(20) — NOT NULL

users

  • id — BIGSERIAL — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_id — VARCHAR(255) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • onboarding_completed — BOOLEAN — NOT NULL
  • language — VARCHAR(2) — NOT NULL
  • nationality — VARCHAR(20)
  • age_group — VARCHAR(20)
  • companion_type — VARCHAR(20)
  • preferred_transport — VARCHAR(20)
  • preferred_wait_time — VARCHAR(20)
  • preferred_atmosphere — VARCHAR(20)
  • home_type — VARCHAR(20)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

visit_reward_rules

  • id — BIGSERIAL — Primary key — NOT NULL
  • place_id — BIGINT — Foreign key
  • region_code — VARCHAR(40) — Foreign key
  • item_id — BIGINT — Foreign key → game_items.id — NOT NULL
  • priority — INTEGER — NOT NULL
  • active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

visits

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • place_id — BIGINT — Foreign key → places.id
  • place_name_snapshot — VARCHAR(255) — NOT NULL
  • region_snapshot — VARCHAR(255) — NOT NULL
  • visited_at — TIMESTAMP — NOT NULL
  • verification_status — VARCHAR(20) — NOT NULL
  • reported_latitude — DOUBLE PRECISION
  • reported_longitude — DOUBLE PRECISION
  • distance_meters — DOUBLE PRECISION
  • geofence_radius_m_snapshot — INTEGER
  • region_code_snapshot — VARCHAR(40) — Foreign key → regions.code
  • congestion_level_snapshot — VARCHAR(30)
  • verified_at — TIMESTAMP WITH TIME ZONE
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL