student-club

Database Diagram for Student Club Data

Income Income.income_id Income.date_received Income.amount Income.source Income.notes Income.link_to_member Member Member.member_id Member.first_name Member.last_name Member.email Member.position Member.t_shirt_size Member.phone Member.zip Member.link_to_major Attendance Attendance.link_to_event Attendance.link_to_member Event Event.event_id Event.event_name Event.event_date Event.type Event.notes Event.location Event.status Zip_Code Zip_Code.zip_code Zip_Code.type Zip_Code.city Zip_Code.county Zip_Code.state Zip_Code.short_state Major Major.major_id Major.major_name Major.department Major.college Expense Expense.expense_id Expense.expense_description Expense.expense_date Expense.cost Expense.approved Expense.link_to_member Expense.link_to_budget Budget Budget.budget_id Budget.category Budget.spent Budget.remaining Budget.amount Budget.event_status Budget.link_to_event Member JOIN Income ON Member.member_id = Income.link_to_member Member JOIN Zip_Code ON Member.zip = Zip_Code.zip_code Member JOIN Expense ON Member.member_id = Expense.link_to_member Member JOIN Major ON Major.major_id = Member.link_to_major Member JOIN Attendance ON Member.member_id = Attendance.link_to_member Event JOIN Attendance ON Event.event_id = Attendance.link_to_event Budget JOIN Event ON Budget.link_to_event = Event.event_id Budget JOIN Expense ON Budget.budget_id = Expense.link_to_budget