Changes between Version 2 and Version 3 of Domain/EmergencyManagement/IncidentManagementSystems/IncidentCommandSystem(UnitedStates)
- Timestamp:
- 03/13/11 19:56:36 (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Domain/EmergencyManagement/IncidentManagementSystems/IncidentCommandSystem(UnitedStates)
v2 v3 50 50 ||last_name||CHAR|| 51 51 ||photo||BLOB|| 52 ||web_page||FK page_id||53 ||twitter||FK page_id||54 ||facebook||FK page_id||55 52 ||physical_limitations||TEXT|| 56 53 ||comments||TEXT|| … … 72 69 '''LIAISON''' 73 70 # perhaps part of logging? 74 ||liaison_id||PK ||75 ||person_id|| FK||76 ||organization_id1|| FK||77 ||organization_id2|| FK||71 ||liaison_id||PK, FK|| 72 ||person_id||PK, FK|| 73 ||organization_id1||PK, FK|| 74 ||organization_id2||PK, FK|| 78 75 ||when_assigned||DATETIME|| 79 76 ||when_unassigned||DATETIME|| … … 95 92 '''PERSON_EQUIPMENT''' 96 93 # Equipment that volunteers have or should have. 97 ||person_id||PK|| 98 ||equipment_id||FK|| 99 ||quantity||INT|| 94 ||person_id||PK, FK|| 95 ||equipment_id||PK, FK|| 96 ||quantity_needed||INT|| 97 ||quantity_on_hand||INT|| 100 98 101 99 '''LOCATION''' … … 114 112 115 113 '''PERSON_ADDRESS''' 116 ||person_id||FK|| 117 ||address_id||FK|| 118 ||organization_id||FK|| 114 ||person_id||PK, FK|| 115 ||address_id||PK, FK|| 119 116 ||address_type||ENUM(home, work, organization)|| 120 117 121 118 '''PERSON_ORGANIZATION''' 122 ||person_id||FK|| 123 ||organization_id||FK|| 119 120 # Tracks people's membership in an organization 121 ||person_id||PK, FK|| 122 ||organization_id||PK, FK|| 124 123 ||active||BOOLEAN 125 124 ||leader||BOOLEAN … … 135 134 136 135 '''PERSON_EMAIL''' 137 ||person_id|| FK||138 ||email_id|| FK||136 ||person_id||PK, FK|| 137 ||email_id||PK, FK|| 139 138 140 139 '''PHONE''' … … 156 155 157 156 '''PERSON_PHONE''' 158 ||person_id|| FK||159 ||phone_id|| FK||157 ||person_id||PK, FK|| 158 ||phone_id||PK, FK|| 160 159 161 160 '''CREDENTIAL''' 161 162 162 # Any kind of certificate, training, other prerequisite associated with a person 163 163 ||credential_id||PK|| … … 167 167 168 168 '''PERSON_CREDENTIAL''' 169 ||person_id|| FK||170 ||credential_id|| FK||171 ||issuing_organization_id|| FK||169 ||person_id||PK, FK|| 170 ||credential_id||PK, FK|| 171 ||issuing_organization_id||PK, FK|| 172 172 ||completion_date||DATE|| 173 173 ||verified_by||FK person_id|| … … 204 204 ||last_reviewed||DATE|| 205 205 206 '''PERSON_PAGE''' 207 ||person_id||PK, FK|| 208 ||page_id||PK, FK|| 209 ||page_type||ENUM(Personal, Twitter, Facebook, YouTube, other|| 210 206 211 '''PERSON_INCIDENT''' 207 ||person_id||FK|| 208 ||incident_id||FK|| 212 213 # This belongs with logging... 214 ||person_id||PK, FK|| 215 ||incident_id||PK, FK|| 209 216 ||notified||DATETIME|| 210 217 ||committed||DATETIME|| … … 216 223 217 224 '''INCIDENT_ROLE''' 225 218 226 # Volunteer slots to be filled 219 ||incident_id|| FK||220 ||role_id|| FK||221 ||shift_id|| 227 ||incident_id||PK, FK|| 228 ||role_id||PK, FK|| 229 ||shift_id||PK, INT|| 222 230 ||starting||DATETIME|| 223 231 ||ending||DATETIME|| 224 232 ||people_needed||INT|| 225 233 226 227 234 '''INCIDENT_EVENT''' 235 228 236 # Logging - most of this will probably happen on paper, then transcribed 229 237 ||event_id||PK|| … … 243 251 244 252 '''ROLE_PREREQUISITE''' 253 245 254 # qualifications, training, etc. 246 ||incident_id|| FK||247 ||role_id|| FK||255 ||incident_id||PK, FK|| 256 ||role_id||PK, FK|| 248 257 ||prerequisite_id||FK|| 249 258 ||required||ENUM(True, recommended)|| 250 259 251 260 '''CURRICULUM''' 261 252 262 # Series of classes that typically would be taken together 253 263 # Curriculum itself becomes a prerequisite … … 260 270 '''ASSIGNMENT''' 261 271 ||assignment_id||PK|| 262 ||incident_id|| FK||272 ||incident_id||PK, FK|| 263 273 ||assignment_description||TEXT|| 264 274 265 275 '''ASSIGNMENT_PERSON''' 266 ||assignment_id||FK|| 267 ||person_id||FK|| 276 277 # Move into logging... 278 ||assignment_id||PK, FK|| 279 ||person_id||PK, FK|| 268 280 ||assigned_when||DATETIME|| 269 281 ||removed_when||DATETIME|| 270 282 271 283 '''ORGANIZATION''' 284 272 285 # Companies, government agencies, etc. - association or group of people with like objectives 273 286 ||organization_id||PK|| … … 283 296 284 297 '''ORGANIZATION_SERVICE_AREA''' 298 285 299 # Geographic description of areas that an organization serves: TBD 300 301 '''ORGANIZATION_PAGE''' 302 ||organization_id||PK, FK|| 303 ||page_id||PK, FK|| 304 ||description||TEXT|| 286 305 287 306 '''RESOURCE''' … … 293 312 ||category||ENUM(training, operations, discussion, communications)|| 294 313 295 '''RESOURCE_ ADDRESS'''296 ||resource_id|| FK||297 || address_id||FK||314 '''RESOURCE_LOCATION''' 315 ||resource_id||PK, FK|| 316 ||location_id||PK, FK|| 298 317 299 318 '''RESOURCE_PERSON''' 300 ||resource_id|| FK||301 ||person_id|| FK||319 ||resource_id||PK, FK|| 320 ||person_id||PK, FK|| 302 321 ||primary_contact||BOOLEAN 303 322 304 323 '''RESOURCE_ORGANIZATION''' 305 ||resource_id||FK|| 306 ||organization_id||FK|| 307 308 '''PROJECT''' 309 ||project_id||PK|| 310 ||project_name||CHAR|| 311 ||project_category||ENUM(planning, supplies, finance, logistics...)|| 312 313 '''PROJECT_PERSON''' 314 ||project_id||FK|| 315 ||project_name||TEXT|| 324 ||resource_id||PK, FK|| 325 ||organization_id||PK, FK|| 316 326 317 327 '''DIVISION''' 328 329 # this needs to be generalized to include neighborhood teams? 318 330 ||division_id||PK|| 319 331 ||division_number||||
