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)