From St. Louis Hackerspace Wiki

Revision as of 19:49, 12 November 2009

New hackerspace os project

Database Schema

/* general member information */
members
member_id username first_name last_name household_id membership_level_id

households
household_id address city state zip

/* membership level information */
membership_levels (there is an 'inactive' membership level)
membership_level_id title dues

membership_history (stores history of membership level changes)
membership_history_id member_id membership_level_id time_stamp

payment_history
payment_id member_id time_stamp amount_paid

fines (paid fines are set to zero, not deleted, and then a payment_history item is made)
fine_id recipient_member_id issuing_member_id equipment_workorder_id cost paid

/* equipment and such */
equipment
equiment_id maintenance_schedule_id

equipment_loans
equipment_loan_id member_id time_stamp_checked_out time_stamp_returned

equipment_maintenance_schedules
maintenance_schedule_id title time_interval

equipment_maintenance_history
maintenance_item_id equipment_id member_id time_stamp cost

equipment_repair_history
repair_id requipment_id member_id time_stamp cost

equipment_workorders
equipment_wordorder_id equipment_id member_id description