2026_SKTHON

Tables (22)

ai_report_sections

  • id — BIGSERIAL — Primary key — NOT NULL
  • report_id — BIGINT — Foreign key → ai_reports.id — NOT NULL
  • section_type — VARCHAR(50) — NOT NULL
  • heading — VARCHAR(200) — NOT NULL
  • body — TEXT — NOT NULL
  • sort_order — INTEGER — NOT NULL

ai_reports

  • id — BIGSERIAL — Primary key — NOT NULL
  • request_id — BIGINT — Foreign key → recommendation_requests.id — NOT NULL
  • selected_candidate_id — BIGINT — Foreign key → recommendation_candidates.id
  • title — VARCHAR(255) — NOT NULL
  • conclusion — TEXT
  • data_limitations — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

business_categories

  • id — BIGSERIAL — Primary key — NOT NULL
  • parent_id — BIGINT — Foreign key → business_categories.id
  • code — VARCHAR(40) — NOT NULL
  • name — VARCHAR(120) — NOT NULL
  • description — TEXT
  • is_active — BOOLEAN — NOT NULL

favorites

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • listing_id — BIGINT — Foreign key → vacancy_listings.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

inquiries

  • id — BIGSERIAL — Primary key — NOT NULL
  • listing_id — BIGINT — Foreign key → vacancy_listings.id — NOT NULL
  • requester_id — BIGINT — Foreign key → users.id — NOT NULL
  • message — TEXT
  • status — inquiry_status — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • answered_at — TIMESTAMPTZ

listing_desired_categories

  • listing_id — BIGINT — Foreign key → vacancy_listings.id — NOT NULL
  • category_id — BIGINT — Foreign key → business_categories.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

listing_images

  • id — BIGSERIAL — Primary key — NOT NULL
  • listing_id — BIGINT — Foreign key → vacancy_listings.id — NOT NULL
  • image_url — TEXT — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

market_category_stats

  • snapshot_id — BIGINT — Foreign key → market_snapshots.id — NOT NULL
  • category_id — BIGINT — Foreign key → business_categories.id — NOT NULL
  • store_count — INTEGER
  • competition_index — NUMERIC(10,3)
  • demand_index — NUMERIC(10,3)
  • deficiency_index — NUMERIC(10,3)

market_snapshots

  • id — BIGSERIAL — Primary key — NOT NULL
  • region_id — BIGINT — Foreign key → regions.id — NOT NULL
  • observed_on — DATE — NOT NULL
  • radius_m — INTEGER
  • source_name — VARCHAR(120) — NOT NULL
  • source_reference — VARCHAR(255)
  • avg_deposit_amount — BIGINT
  • avg_monthly_rent_amount — BIGINT
  • foot_traffic_index — NUMERIC(10,3)
  • office_demand_index — NUMERIC(10,3)
  • residential_demand_index — NUMERIC(10,3)
  • raw_payload — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

oauth_accounts

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • provider — oauth_provider — NOT NULL
  • provider_subject — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

properties

  • id — BIGSERIAL — Primary key — NOT NULL
  • region_id — BIGINT — Foreign key → regions.id
  • road_address — VARCHAR(500) — NOT NULL
  • jibun_address — VARCHAR(500)
  • address_detail — VARCHAR(255)
  • postal_code — VARCHAR(10)
  • latitude — NUMERIC(10,7) — NOT NULL
  • longitude — NUMERIC(10,7) — NOT NULL
  • floor_label — VARCHAR(30)
  • area_sqm — NUMERIC(10,2) — NOT NULL
  • frontage_note — VARCHAR(255)
  • parking — parking_type — NOT NULL
  • parking_note — VARCHAR(255)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

recommendation_candidates

  • id — BIGSERIAL — Primary key — NOT NULL
  • request_id — BIGINT — Foreign key → recommendation_requests.id — NOT NULL
  • candidate_type — candidate_type — NOT NULL
  • category_id — BIGINT — Foreign key → business_categories.id
  • region_id — BIGINT — Foreign key → regions.id
  • listing_id — BIGINT — Foreign key → vacancy_listings.id
  • rank — INTEGER — NOT NULL
  • score — NUMERIC(6,3)
  • summary — VARCHAR(500)
  • score_breakdown — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

recommendation_reasons

  • id — BIGSERIAL — Primary key — NOT NULL
  • candidate_id — BIGINT — Foreign key → recommendation_candidates.id — NOT NULL
  • reason_type — VARCHAR(50) — NOT NULL
  • title — VARCHAR(200)
  • description — TEXT — NOT NULL
  • impact_score — NUMERIC(6,3)
  • sort_order — INTEGER — NOT NULL

recommendation_requests

  • id — BIGSERIAL — Primary key — NOT NULL
  • requested_by — BIGINT — Foreign key → users.id
  • type — recommendation_type — NOT NULL
  • listing_id — BIGINT — Foreign key → vacancy_listings.id
  • property_id — BIGINT — Foreign key → properties.id
  • startup_profile_id — BIGINT — Foreign key → startup_profiles.id
  • status — job_status — NOT NULL
  • input_snapshot — JSONB — NOT NULL
  • model_name — VARCHAR(100)
  • prompt_version — VARCHAR(50)
  • started_at — TIMESTAMPTZ
  • completed_at — TIMESTAMPTZ
  • error_message — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

regions

  • id — BIGSERIAL — Primary key — NOT NULL
  • parent_id — BIGINT — Foreign key → regions.id
  • administrative_code — VARCHAR(20)
  • name — VARCHAR(120) — NOT NULL
  • level — VARCHAR(30) — NOT NULL
  • center_lat — NUMERIC(10,7)
  • center_lng — NUMERIC(10,7)
  • boundary_geojson — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

startup_profile_regions

  • startup_profile_id — BIGINT — Foreign key → startup_profiles.id — NOT NULL
  • region_id — BIGINT — Foreign key → regions.id — NOT NULL
  • priority — INTEGER — NOT NULL

startup_profiles

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • category_id — BIGINT — Foreign key → business_categories.id — NOT NULL
  • title — VARCHAR(150)
  • deposit_budget_max — BIGINT
  • monthly_rent_budget_max — BIGINT
  • area_sqm_min — NUMERIC(10,2)
  • area_sqm_max — NUMERIC(10,2)
  • target_customer_note — VARCHAR(500)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

user_roles

  • role — user_role_type — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

users

  • id — BIGSERIAL — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • name — VARCHAR(80) — NOT NULL
  • phone — VARCHAR(30)
  • status — user_status — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ

vacancy_listings

  • id — BIGSERIAL — Primary key — NOT NULL
  • property_id — BIGINT — Foreign key → properties.id — NOT NULL
  • owner_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • deposit_amount — BIGINT
  • monthly_rent_amount — BIGINT
  • maintenance_fee_amount — BIGINT
  • desired_tenant_note — VARCHAR(500)
  • contact_phone — VARCHAR(30)
  • status — listing_status — NOT NULL
  • view_count — INTEGER — NOT NULL
  • published_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ

vacancy_matches

  • id — BIGSERIAL — Primary key — NOT NULL
  • listing_id — BIGINT — Foreign key → vacancy_listings.id — NOT NULL
  • entrepreneur_id — BIGINT — Foreign key → users.id — NOT NULL
  • startup_profile_id — BIGINT — Foreign key → startup_profiles.id
  • recommendation_candidate_id — BIGINT — Foreign key → recommendation_candidates.id
  • score — NUMERIC(6,3)
  • status — match_status — NOT NULL
  • proposed_by — BIGINT — Foreign key → users.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

vacancy_rate_observations

  • id — BIGSERIAL — Primary key — NOT NULL
  • region_id — BIGINT — Foreign key → regions.id — NOT NULL
  • observed_on — DATE — NOT NULL
  • rate_percent — NUMERIC(5,2) — NOT NULL
  • level — vacancy_level — NOT NULL
  • source_name — VARCHAR(120) — NOT NULL
  • source_reference — VARCHAR(255)
  • created_at — TIMESTAMPTZ — NOT NULL