# SFAS Bridge Data Expansion

## DB Migration
- [x] Added new table `sims.sfas_application_dependents` to import
Dependents data of SFAS applications.
- [x] Added new table `sims.sfas_application_disbursements` to import
Disbursements data of SFAS applications.
- [x] Added new columns `sims.sfas_individuals` to expand the existing
data.
- [x] Added new columns `sims.sfas_applications` to expand the existing
data.

## Following existing SFAS Tables
- [x] No foreign key constraints are enforced on the new tables
following existing SFAS tables.
- [x] Audit columns for new tables follow the same pattern as existing
SFAS tables.
- [x] In the new tables, except the primary key and `application_id` all
other fields are kept as nullable for the import to be more permissive
following the existing SFAS tables. This has been shared with business
as well.

## Rollback Evidence
- [x] SFAS Applications revert

![image](https://github.com/user-attachments/assets/3209831b-7a75-4408-a16d-00724b001b89)

- [x] SFAS Individuals Revert

![image](https://github.com/user-attachments/assets/04005e97-6983-4e5c-9d10-b501dfa46558)

- [x] SFAS Application disbursements Revert

![image](https://github.com/user-attachments/assets/f4f0c269-544b-42ab-bd17-84d7358b091a)

- [x] SFAS Application dependents Revert

![image](https://github.com/user-attachments/assets/dce566ea-ab9d-4a75-8615-9c4420c00a9a)