| authority_id | name | contact_info |
|---|---|---|
| 1 | Authority A | contact@authoritya.com |
| 2 | Authority B | contact@authorityb.com |
| 3 | Authority C | contact@authorityc.com |
| 4 | Authority D | contact@authorityd.com |
| 5 | Authority E | contact@authoritye.com |
| program_id | program_name | description |
|---|---|---|
| 1 | Public_Housing | A government-subsidized housing program. |
| 2 | Affordable_Housing | Low-cost housing options for low-income families. |
| 3 | Rental_Assistance | Financial assistance for rent payments. |
| 4 | Homeownership_Incentives | Grants and loans for first-time home buyers. |
| 5 | Emergency_Housing | Temporary housing solutions for those facing homelessness. |
| id | authority_id | program_id |
|---|---|---|
| (→ Authorities.authority_id) | (→ Programs.program_id) | |
| 1 | 1 | 1 |
| 2 | 2 | 1 |
| 3 | 3 | 1 |
| 4 | 4 | 1 |
| 5 | 5 | 1 |
| 6 | 5 | 5 |