Joseph sent me an update on the tenant union database:
Here is the database schema.
- Owners and Managers tables connect Parties to Properties and keep track of historical ownership/management over time.
- The Leases table keeps track of the properties that tenants rent and the length of their lease.
- Complaints are tied to Tenants, Leases, Properties, and Parties, and Resolutions are linked to Complaints.
- Evictions are similar to Complaints, but keeps track of how many evictions a tenant has had.
- Union activities can be tracked by the Members, Meetings, Attendance, Agendas, Votes, and Dues tables.
