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