asdasdasd

Tables (6)

gov24_service_details

  • service_id — VARCHAR(50) — Primary key — NOT NULL
  • required_docs_by_official — TEXT
  • required_docs — TEXT
  • contact — TEXT
  • laws — TEXT
  • identity_required_docs — TEXT
  • service_name — VARCHAR(500) — NOT NULL
  • service_purpose — TEXT
  • selection_criteria — TEXT
  • organization_name — VARCHAR(300)
  • modified_date — VARCHAR(30)
  • application_deadline — TEXT
  • application_method — TEXT
  • online_application_url — VARCHAR(1000)
  • local_laws — TEXT
  • reception_institution_name — TEXT
  • support_content — TEXT
  • support_target — TEXT
  • support_type — VARCHAR(500)
  • administrative_rules — TEXT
  • raw_json — JSON
  • content_hash — VARCHAR(64) — NOT NULL
  • first_seen_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • last_seen_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • is_active — BOOLEAN — NOT NULL

gov24_service_lists

  • service_id — VARCHAR(50) — Primary key — NOT NULL
  • registration_datetime — VARCHAR(30)
  • department_name — VARCHAR(300)
  • user_type — VARCHAR(500)
  • detail_url — VARCHAR(1000)
  • service_name — VARCHAR(500) — NOT NULL
  • service_purpose_summary — TEXT
  • service_field — VARCHAR(200)
  • selection_criteria — TEXT
  • organization_name — VARCHAR(300)
  • organization_type — VARCHAR(100)
  • organization_code — VARCHAR(50)
  • modified_datetime — VARCHAR(30)
  • application_deadline — TEXT
  • application_method — TEXT
  • contact_phone — TEXT
  • reception_institution — TEXT
  • view_count — INTEGER
  • support_content — TEXT
  • support_target — TEXT
  • support_type — VARCHAR(500)
  • raw_json — JSON
  • content_hash — VARCHAR(64) — NOT NULL
  • first_seen_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • last_seen_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • is_active — BOOLEAN — NOT NULL

gov24_support_conditions

  • service_id — VARCHAR(50) — Primary key — NOT NULL
  • service_name — VARCHAR(500) — NOT NULL
  • ja0101_male — VARCHAR(30)
  • ja0102_female — VARCHAR(30)
  • ja0110_age_start — VARCHAR(30)
  • ja0111_age_end — VARCHAR(30)
  • ja0201_income_0_50 — VARCHAR(30)
  • ja0202_income_51_75 — VARCHAR(30)
  • ja0203_income_76_100 — VARCHAR(30)
  • ja0204_income_101_200 — VARCHAR(30)
  • ja0205_income_over_200 — VARCHAR(30)
  • ja0301_pre_parent_infertility — VARCHAR(30)
  • ja0302_pregnant — VARCHAR(30)
  • ja0303_childbirth_adoption — VARCHAR(30)
  • ja0313_farmer — VARCHAR(30)
  • ja0314_fisher — VARCHAR(30)
  • ja0315_livestock_farmer — VARCHAR(30)
  • ja0316_forester — VARCHAR(30)
  • ja0326_worker — VARCHAR(30)
  • ja0327_job_seeker — VARCHAR(30)
  • ja0328_disabled — VARCHAR(30)
  • ja0329_veteran — VARCHAR(30)
  • ja0330_disease_patient — VARCHAR(30)
  • ja0401_multicultural_family — VARCHAR(30)
  • ja0402_north_korean_defector — VARCHAR(30)
  • ja0403_single_parent_grandparent_family — VARCHAR(30)
  • ja0404_single_person_household — VARCHAR(30)
  • ja0411_multi_child_family — VARCHAR(30)
  • ja1101_pre_founder — VARCHAR(30)
  • ja1102_operating_business — VARCHAR(30)
  • ja1103_closing_business — VARCHAR(30)
  • ja1201_restaurant_business — VARCHAR(30)
  • ja1202_manufacturing_business — VARCHAR(30)
  • ja1299_other_business — VARCHAR(30)
  • ja2101_small_medium_business — VARCHAR(30)
  • ja2102_social_welfare_facility — VARCHAR(30)
  • ja2103_institution_group — VARCHAR(30)
  • raw_json — JSON
  • content_hash — VARCHAR(64) — NOT NULL
  • first_seen_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • last_seen_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • is_active — BOOLEAN — NOT NULL

policy_announcements

  • pbanc_sn — INTEGER — Primary key — NOT NULL
  • source — VARCHAR(50) — NOT NULL
  • title — VARCHAR(500) — NOT NULL
  • target — VARCHAR(200)
  • category — VARCHAR(200)
  • organization — VARCHAR(300)
  • apply_start — VARCHAR(50)
  • apply_end — VARCHAR(50)
  • status — VARCHAR(100)
  • detail_url — VARCHAR(500) — NOT NULL
  • content_html — TEXT
  • content_text — TEXT
  • raw_list_json — JSON
  • raw_detail_json — JSON
  • content_hash — VARCHAR(64) — NOT NULL
  • first_seen_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • last_seen_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • is_active — BOOLEAN — NOT NULL

policy_attachments

  • file_id — VARCHAR(100) — Primary key — NOT NULL
  • pbanc_sn — INTEGER — Foreign key → policy_announcements.pbanc_sn — NOT NULL
  • file_name — VARCHAR(500) — NOT NULL
  • file_size — INTEGER
  • saved_path — VARCHAR(1000)
  • file_hash — VARCHAR(64)
  • raw_file_json — JSON
  • created_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • downloaded_at — TIMESTAMP WITH TIME ZONE — NOT NULL

policy_program_pages

  • id — INTEGER — Primary key — NOT NULL
  • source — VARCHAR(50) — NOT NULL
  • source_url — VARCHAR(1000) — NOT NULL
  • category — VARCHAR(300)
  • program_name — VARCHAR(500) — NOT NULL
  • content_html — TEXT
  • content_text — TEXT
  • sections_json — JSON
  • raw_breadcrumbs_json — JSON
  • content_hash — VARCHAR(64) — NOT NULL
  • first_seen_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • last_seen_at — TIMESTAMP WITH TIME ZONE — NOT NULL
  • is_active — BOOLEAN — NOT NULL