## Authorities

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

## Programs

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.

## Authorities_Programs

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