From St. Louis Hackerspace Wiki

Arch Reactor OS

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_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