This database contains information about a student club, including members, events, finances, and attendance records.
Below are the tables in the database with their schema definitions and sample data.
Academic majors of club members
Club member profile information
Geographic information for member locations
Club events and activities
Event attendance records
Budget allocations for events
Club income and funding sources
Expense records for club activities
| Column | Type |
|---|---|
| major_id | text |
| major_name | text |
| department | text |
| college | text |
| Column | Type |
|---|---|
| member_id | text |
| first_name | text |
| last_name | text |
text |
|
| position | text |
| t_shirt_size | text |
| phone | text |
| zip | integer |
| link_to_major | text |
| Column | Type |
|---|---|
| zip_code | integer |
| type | text |
| city | text |
| county | text |
| state | text |
| short_state | text |
| Column | Type |
|---|---|
| event_id | text |
| event_name | text |
| event_date | text |
| type | text |
| notes | text |
| location | text |
| status | text |
| Column | Type |
|---|---|
| link_to_event | text |
| link_to_member | text |
| Column | Type |
|---|---|
| budget_id | text |
| category | text |
| amount | real |
| link_to_event | text |
| Column | Type |
|---|---|
| income_id | text |
| date_received | text |
| amount | integer |
| source | text |
| notes | text |
| link_to_member | text |
| Column | Type |
|---|---|
| expense_id | text |
| expense_description | text |
| expense_date | text |
| cost | real |
| approved | text |
| link_to_member | text |
| link_to_budget | text |
ER diagram showing relationships between tables:
link_to_majorziplink_to_memberlink_to_eventlink_to_memberlink_to_eventlink_to_memberlink_to_budget