Changes between Version 2 and Version 3 of Domain/EmergencyManagement/IncidentManagementSystems/IncidentCommandSystem(UnitedStates)


Ignore:
Timestamp:
03/13/11 19:56:36 (11 years ago)
Author:
Nick Arnett
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Domain/EmergencyManagement/IncidentManagementSystems/IncidentCommandSystem(UnitedStates)

    v2 v3  
    5050||last_name||CHAR||
    5151||photo||BLOB||
    52 ||web_page||FK page_id||
    53 ||twitter||FK page_id||
    54 ||facebook||FK page_id||
    5552||physical_limitations||TEXT||
    5653||comments||TEXT||
     
    7269'''LIAISON'''
    7370# 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||
    7875||when_assigned||DATETIME||
    7976||when_unassigned||DATETIME||
     
    9592'''PERSON_EQUIPMENT'''
    9693# 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||
    10098
    10199'''LOCATION'''
     
    114112
    115113'''PERSON_ADDRESS'''
    116 ||person_id||FK||
    117 ||address_id||FK||
    118 ||organization_id||FK||
     114||person_id||PK, FK||
     115||address_id||PK, FK||
    119116||address_type||ENUM(home, work, organization)||
    120117
    121118'''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||
    124123||active||BOOLEAN
    125124||leader||BOOLEAN
     
    135134
    136135'''PERSON_EMAIL'''
    137 ||person_id||FK||
    138 ||email_id||FK||
     136||person_id||PK, FK||
     137||email_id||PK, FK||
    139138
    140139'''PHONE'''
     
    156155
    157156'''PERSON_PHONE'''
    158 ||person_id||FK||
    159 ||phone_id||FK||
     157||person_id||PK, FK||
     158||phone_id||PK, FK||
    160159
    161160'''CREDENTIAL'''
     161
    162162# Any kind of certificate, training, other prerequisite associated with a person
    163163||credential_id||PK||
     
    167167
    168168'''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||
    172172||completion_date||DATE||
    173173||verified_by||FK person_id||
     
    204204||last_reviewed||DATE||
    205205
     206'''PERSON_PAGE'''
     207||person_id||PK, FK||
     208||page_id||PK, FK||
     209||page_type||ENUM(Personal, Twitter, Facebook, YouTube, other||
     210
    206211'''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||
    209216||notified||DATETIME||
    210217||committed||DATETIME||
     
    216223
    217224'''INCIDENT_ROLE'''
     225
    218226# 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||
    222230||starting||DATETIME||
    223231||ending||DATETIME||
    224232||people_needed||INT||
    225233
    226 
    227234'''INCIDENT_EVENT'''
     235
    228236# Logging - most of this will probably happen on paper, then transcribed
    229237||event_id||PK||
     
    243251
    244252'''ROLE_PREREQUISITE'''
     253
    245254# qualifications, training, etc.
    246 ||incident_id||FK||
    247 ||role_id||FK||
     255||incident_id||PK, FK||
     256||role_id||PK, FK||
    248257||prerequisite_id||FK||
    249258||required||ENUM(True, recommended)||
    250259
    251260'''CURRICULUM'''
     261
    252262# Series of classes that typically would be taken together
    253263# Curriculum itself becomes a prerequisite
     
    260270'''ASSIGNMENT'''
    261271||assignment_id||PK||
    262 ||incident_id||FK||
     272||incident_id||PK, FK||
    263273||assignment_description||TEXT||
    264274
    265275'''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||
    268280||assigned_when||DATETIME||
    269281||removed_when||DATETIME||
    270282
    271283'''ORGANIZATION'''
     284
    272285# Companies, government agencies, etc. - association or group of people with like objectives
    273286||organization_id||PK||
     
    283296
    284297'''ORGANIZATION_SERVICE_AREA'''
     298
    285299# 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||
    286305
    287306'''RESOURCE'''
     
    293312||category||ENUM(training, operations, discussion, communications)||
    294313
    295 '''RESOURCE_ADDRESS'''
    296 ||resource_id||FK||
    297 ||address_id||FK||
     314'''RESOURCE_LOCATION'''
     315||resource_id||PK, FK||
     316||location_id||PK, FK||
    298317
    299318'''RESOURCE_PERSON'''
    300 ||resource_id||FK||
    301 ||person_id||FK||
     319||resource_id||PK, FK||
     320||person_id||PK, FK||
    302321||primary_contact||BOOLEAN
    303322
    304323'''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||
    316326
    317327'''DIVISION'''
     328
     329# this needs to be generalized to include neighborhood teams?
    318330||division_id||PK||
    319331||division_number||||