From St. Louis Hackerspace Wiki

Revision as of 19:13, 12 November 2009 (view source) 198.150.95.254 (Talk) (→Arch Reactor OS) ← Older edit		Revision as of 19:49, 12 November 2009 (view source) 198.150.95.254 (Talk) (→added equipment_loans, probably needs to manage state better) Newer edit →
Line 28:		Line 28:
	equipment<br>		equipment<br>
	equiment_id maintenance_schedule_id<br>		equiment_id maintenance_schedule_id<br>
		+
		+	equipment_loans
		+	equipment_loan_id member_id time_stamp_checked_out time_stamp_returned
	equipment_maintenance_schedules<br>		equipment_maintenance_schedules<br>

---

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