vads
Tables (6)
docs_list
- docs_id — INT — Primary key — NOT NULL
- doc_code — VARCHAR(20) — NOT NULL
- docs_name — VARCHAR(50) — NOT NULL
- docs_issuer — VARCHAR(50)
policies
- policy_id — VARCHAR(50) — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- introduction — TEXT
- category_name — VARCHAR(50) — NOT NULL
- apply_period — VARCHAR(255)
- start_date — DATETIME
- end_date — DATETIME
- host_inst — VARCHAR(100)
- site_link — VARCHAR(1000)
- view_count — INT — NOT NULL
- created_at — DATETIME — 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_regions
- map_id — INT — Primary key — NOT NULL
- policy_id — VARCHAR(50) — Foreign key → policies.policy_id — NOT NULL
- region_code — VARCHAR(50) — Foreign key → region_codes.region_code — 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
- doc_type_code — VARCHAR(20) — Foreign key → docs_list.doc_code
region_codes
- region_code — VARCHAR(50) — Primary key — NOT NULL
- region_name — VARCHAR(100) — NOT NULL