test
Tables (9)
Agencies
- agency_id — INT
- name — VARCHAR(100) — NOT NULL
- type — VARCHAR(20)
Benefit_History
- history_id — INT — Primary key
- user_id — INT — Foreign key → Users.user_id
- program_id — INT — Foreign key → Welfare_Programs.program_id
- status — VARCHAR(20)
- start_date — DATE
- end_date — DATE
- benefit_amount — DECIMAL(15, 2)
- program_id (program_id2) — INT — Foreign key → Welfare_Programs.program_id
Eligibility_Check_Logs
- log_id — INT — Primary key
- user_id — INT — Foreign key → Users.user_id
- program_id — INT — Foreign key → Welfare_Programs.program_id
- is_eligible — BOOLEAN
- reason_code — VARCHAR(20) — Foreign key → Ineligibility_Codes.reason_code
- check_date — TIMESTAMP
- program_id (program_id2) — INT — Foreign key → Welfare_Programs.program_id
Eligibility_Criteria (자격_기준)
- criteria_id — INT
- program_id — INT — Foreign key → Welfare_Programs.program_id
- min_age — INT
- max_age — INT
- income_ratio_limit — INT
- asset_limit — DECIMAL(15, 2)
- car_limit_value — DECIMAL(15, 2)
- required_housing_type — VARCHAR(50)
- program_id (program_id2) — INT — Foreign key → Welfare_Programs.program_id
Households
- household_id — INT
- address — VARCHAR(255)
- household_type — VARCHAR(50)
Ineligibility_Codes
- reason_code — VARCHAR(20)
- category — VARCHAR(50)
- message_template — TEXT
Program_Relations
- relation_id — INT — Primary key
- source_program_id — INT — Foreign key → Welfare_Programs.program_id
- target_program_id — INT — Foreign key → Welfare_Programs.program_id
- relation_type — VARCHAR(30)
- program_id (program_id2) — INT — Foreign key → Welfare_Programs.program_id
Users
- user_id — INT
- household_id — INT — Foreign key → Households.household_id
- name — VARCHAR(50)
- birth_date — DATE
- individual_income — DECIMAL(15, 2)
- financial_assets — DECIMAL(15, 2)
- real_estate_assets — DECIMAL(15, 2)
- car_cc — INT
- car_value — DECIMAL(15, 2)
- housing_type — VARCHAR(20)
- is_disabled — BOOLEAN
- is_veteran — BOOLEAN
Welfare_Programs
- program_id — INT — Primary key
- agency_id — INT — Foreign key → Agencies.agency_id
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- category — VARCHAR(50)