Changes between Version 4 and Version 5 of Domain/EmergencyManagement/IncidentManagementSystems/IncidentCommandSystem(UnitedStates)
- Timestamp:
- 03/14/11 04:51:18 (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Domain/EmergencyManagement/IncidentManagementSystems/IncidentCommandSystem(UnitedStates)
v4 v5 44 44 45 45 '''PERSON''' 46 ||person_id||PK|| 47 ||person_login||CHAR|| 48 ||person_password|| || 46 ||person_id||PK||| 49 47 ||person_title||CHAR|| 50 48 ||first_name||CHAR|| 51 || person_nickname||CHAR||49 ||nickname||CHAR|| 52 50 ||last_name||CHAR|| 53 51 ||photo||BLOB|| … … 63 61 ||ICS_level||ENUM(Command, Section, Division, Individual)|| 64 62 ||ICS_role||ENUM(PIO, Safety, Operations, Planning, Logistics, Intelligence, Finance/Admin)|| 65 ||manager||ENUM(camp, shelter, etc.)??||66 ||subordinate||ENUM(assistant, deputy)||67 ||team_role||ENUM(division leader, block leader...)||68 ||reports_to||FK person_id||69 ||citizen_corps_role||ENUM(board member, working group, donor)||70 63 71 64 '''LIAISON''' 72 # perhaps part of logging? 65 66 # Could belong in incident_event, but it is a persistent relationship sometimes. 73 67 ||liaison_id||PK, FK|| 74 68 ||person_id||PK, FK|| … … 80 74 '''ACCESS_CONTROL''' 81 75 TBD 82 83 '''PERSON_ROLE'''84 ||person_id||FK||85 ||role_id||FK||86 ||role_assigned||DATETIME||87 76 88 77 '''EQUIPMENT''' … … 93 82 94 83 '''PERSON_EQUIPMENT''' 84 95 85 # Equipment that volunteers have or should have. 96 86 ||person_id||PK, FK|| 97 87 ||equipment_id||PK, FK|| 98 || quantity_needed||INT||99 || quantity_on_hand||INT||88 ||needs||INT|| 89 ||has||INT|| 100 90 101 91 '''LOCATION''' … … 113 103 ||last_updated||(DATE)|| 114 104 115 '''PERSON_ADDRESS''' 116 ||person_id||PK, FK|| 117 ||address_id||PK, FK|| 118 ||address_type||ENUM(home, work, organization)|| 105 '''PERSON_LOCATION''' 106 ||person_id||PK, FK|| 107 ||location_id||PK, FK|| 108 ||location_type||ENUM(home, work, organization)|| 109 ||comments||TEXT|| 119 110 120 111 '''PERSON_ORGANIZATION''' … … 125 116 ||active||BOOLEAN 126 117 ||leader||BOOLEAN 127 || title||CHAR||118 ||role_id||FK|| 128 119 ||membership_started||DATE|| 129 120 ||membership_expires||DATE|| … … 143 134 ||phone_id||PK|| 144 135 ||phone_type||ENUM(home, work, mobile, other)|| 136 ||country_code||INT|| 145 137 ||area_code||INT|| 146 || number||INT||138 ||phone_number||INT|| 147 139 ||extension||INT|| 148 140 ||service_provider||CHAR||
