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