Changes between Version 4 and Version 5 of Domain/EmergencyManagement/IncidentManagementSystems/IncidentCommandSystem(UnitedStates)


Ignore:
Timestamp:
03/14/11 04:51:18 (11 years ago)
Author:
Nick Arnett
Comment:

--

Legend:

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

    v4 v5  
    4444
    4545'''PERSON'''
    46 ||person_id||PK||
    47 ||person_login||CHAR||
    48 ||person_password|| ||
     46||person_id||PK|||
    4947||person_title||CHAR||
    5048||first_name||CHAR||
    51 ||person_nickname||CHAR||
     49||nickname||CHAR||
    5250||last_name||CHAR||
    5351||photo||BLOB||
     
    6361||ICS_level||ENUM(Command, Section, Division, Individual)||
    6462||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)||
    7063
    7164'''LIAISON'''
    72 # perhaps part of logging?
     65
     66# Could belong in incident_event, but it is a persistent relationship sometimes.
    7367||liaison_id||PK, FK||
    7468||person_id||PK, FK||
     
    8074'''ACCESS_CONTROL'''
    8175TBD
    82 
    83 '''PERSON_ROLE'''
    84 ||person_id||FK||
    85 ||role_id||FK||
    86 ||role_assigned||DATETIME||
    8776
    8877'''EQUIPMENT'''
     
    9382
    9483'''PERSON_EQUIPMENT'''
     84
    9585# Equipment that volunteers have or should have.
    9686||person_id||PK, FK||
    9787||equipment_id||PK, FK||
    98 ||quantity_needed||INT||
    99 ||quantity_on_hand||INT||
     88||needs||INT||
     89||has||INT||
    10090
    10191'''LOCATION'''
     
    113103||last_updated||(DATE)||
    114104
    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||
    119110
    120111'''PERSON_ORGANIZATION'''
     
    125116||active||BOOLEAN
    126117||leader||BOOLEAN
    127 ||title||CHAR||
     118||role_id||FK||
    128119||membership_started||DATE||
    129120||membership_expires||DATE||
     
    143134||phone_id||PK||
    144135||phone_type||ENUM(home, work, mobile, other)||
     136||country_code||INT||
    145137||area_code||INT||
    146 ||number||INT||
     138||phone_number||INT||
    147139||extension||INT||
    148140||service_provider||CHAR||