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