12
Tables (5)
docs_list
- docs_id — INT — Primary key — NOT NULL — 내부 관리용 숫자 ID
- doc_code — VARCHAR(20) — NOT NULL — 시스템 식별 코드 (예: DOC_001)
- docs_name — VARCHAR(50) — NOT NULL — 서류 이름 (표준명)
- docs_issuer — VARCHAR(50) — 서류 발급처
policies
- policy_id — VARCHAR(50) — Primary key — NOT NULL — API: plcyNo
- title — VARCHAR(255) — NOT NULL — API: plcyNm
- introduction — TEXT — API: plcyExplnCn
- category_name — VARCHAR(50) — NOT NULL — API: lclsfNm
- apply_period — VARCHAR(255) — API: aplyYmd
- start_date — DATETIME — API: bizPrdBgngYmd
- end_date — DATETIME — API: bizPrdEndYmd
- host_inst — VARCHAR(100) — API: sprvsnInstCdNm
- site_link — VARCHAR(1000)NULL — API: aplyUrlAddr
- region_code — TEXT — NOT NULL — API: zipCd
- view_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- application_name — VARCHAR(50)
- code (code2) — VARCHAR(5) — Foreign key → region_codes.code — NOT NULL — 행정동 코드
policy_benefits
- id — INT — Primary key — NOT NULL
- policy_id — VARCHAR(50) — Foreign key → policies.policy_id — NOT NULL
- benefit_desc — TEXT
- max_amount — INT
- support_scale — VARCHAR(100)
- min_age — INT
- max_age — INT
- age_info — VARCHAR(255)
- emp_status_code — VARCHAR(50)
- edu_req_code — VARCHAR(50)
- major_req_code — VARCHAR(50)
- splz_field_code — VARCHAR(50)
- income_range_txt — TEXT
- is_cash_benefit — BOOLEAN — NOT NULL
policy_required_docs
- req_id — INT — Primary key — NOT NULL
- policy_id — VARCHAR(50) — Foreign key → policies.policy_id — NOT NULL
- doc_name — VARCHAR(100) — NOT NULL — AI가 추출한 서류명 (원본)
- doc_type_code — VARCHAR(20) — Foreign key → docs_list.doc_code — 매핑된 코드 (예: DOC_001)
region_codes
- code — VARCHAR(5) — Primary key — NOT NULL — 행정동 코드
- name — VARCHAR(50) — NOT NULL — 행정동 이름