Hoa_Boards
board_id | address | president_name |
1 | 123 Main St | John Doe |
2 | 456 Elm St | Jane Smith |
3 | 789 Oak St | Michael Johnson |
4 | 001 Pine St | Emily Davis |
5 | 002 Fir St | David Brown |
Meetings
meeting_id | meeting_type |
1 | Annual_Meeting |
2 | Special_Meeting |
3 | Budget_Meeting |
4 | Maintenance_Meeting |
5 | Election_Meeting |
Members
member_id | name | email |
1 | Alice Green | alice@example.com |
2 | Bob White | bob@example.com |
3 | Carol Black | carol@example.com |
4 | Dave Blue | dave@example.com |
5 | Elizabeth Red | elizabeth@example.com |
Hoa_Board_Members
hoa_board_id | member_id |
(→ Hoa_Boards.board_id) | (→ Members.member_id) |
1 | 1 |
1 | 2 |
2 | 3 |
2 | 4 |
3 | 5 |
Meeting_Attendees
meeting_id | attendee_id |
(→ Meetings.meeting_id) | (→ Members.member_id) |
1 | 1 |
1 | 2 |
2 | 3 |
3 | 4 |
4 | 5 |
Hoa_Boards_Meetings
hoa_board_id | meeting_id |
(→ Hoa_Boards.board_id) | (→ Meetings.meeting_id) |
1 | 1 |
1 | 2 |
2 | 3 |
2 | 4 |
3 | 5 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |