From St. Louis Hackerspace Wiki

Revision as of 19:12, 12 November 2009 (view source) 198.150.95.254 (Talk) (→Database Schema) ← Older edit		Revision as of 19:13, 12 November 2009 (view source) 198.150.95.254 (Talk) (→Arch Reactor OS) Newer edit →
Line 1:		Line 1:
-	=Arch Reactor OS=	+	=New hackerspace os project=
	==Database Schema==		==Database Schema==

---

Revision as of 19:13, 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_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