== Incident Command System ==
Required in the U.S. for disaster response.
This is a bit of brainstorming on what is needed to fit into ICS for use by Citizen Corps programs (CERT, Neighborhood Watch, etc.)
Initial version not quite done... still thinking about best way to organize people, roles, incidents, schedules... NDA

== Components ==
* Location: address, coordinate, postal info
* Person: individual
* Role: hierarchy of structure and command
* Organization: companies, teams, agencies, etc., with inter-relationships
* Membership: relationship of people to organizations
* Incident: deployment, training, exercise, debriefing, etc.
* Credential: training, skill, certification, vaccinations, etc.
* Prerequisite: what credentials needed before a person can participate in an incident
* Event: what happened at a particular time and place; logging
* Equipment: personal and organizational gear
* Resource: supplier of equipment, skills, etc.
* Project: workflow for planning and management
* Email: contact info
* Phone: contact info
* Web page: associated with people, organizations, resources


== Functions ==
* Add, modify, remove each kind of component
* Generate lists of each kind of component
* Print identification cards/badges
* Select individuals by various criteria, then send notifications
* Interface to calendar, recurring automatic emails for meeting notifications
* Issue training certificate
* Alerting - instant messaging, SMS, printed phone tree generation
* Export KML data for mapping, with symbols
* Dashboards for incidents, teams, resources, projects
* Training reports - who needs which courses, what expires soon?
* ICS/NIMS forms
* Access control
* Automatic data dump to forms suitable for laptops, mobile - cache critical data for when network is down.
* Data import
* MORE TBD

== Table structures ==

'''PERSON'''
||person_id||PK||
||person_login||CHAR||
||person_password|| ||
||person_title||CHAR||
||first_name||CHAR||
||person_nickname||CHAR||
||last_name||CHAR||
||photo||BLOB||
||web_page||FK page_id||
||twitter||FK page_id||
||facebook||FK page_id||
||physical_limitations||TEXT||
||comments||TEXT||
||gender||ENUM(m, f)||
||birthdate||DATE||
||status||ENUM(interested, pending, active, related) # related is for people who are in the database but not part of a team||
||emergency_contact||FK person_id||

'''ROLE'''
||role_id||PK||
||ICS_level||ENUM(Command, Section, Division, Individual)||
||ICS_role||ENUM(PIO, Safety, Operations, Planning, Logistics, Intelligence, Finance/Admin)||
||manager||ENUM(camp, shelter, etc.)??||
||subordinate||ENUM(assistant, deputy)||
||team_role||ENUM(division leader, block leader...)||
||reports_to||FK person_id||
||citizen_corps_role||ENUM(board member, working group, donor)||

'''LIAISON'''
# perhaps part of logging?
||liaison_id||PK||
||person_id||FK||
||organization_id1||FK||
||organization_id2||FK||
||when_assigned||DATETIME||
||when_unassigned||DATETIME||

'''ACCESS_CONTROL'''
TBD

'''PERSON_ROLE'''
||person_id||FK||
||role_id||FK||
||role_assigned||DATETIME||

'''EQUIPMENT'''
||equipment_id||PK||
||equipment_name||CHAR||
||equipment_type||ENUM (HT, mobile radio, antenna, first aid kit, boots, backpack...)||
||equipment_category||ENUM (communications, PPE, medical, SAR...)||

'''PERSON_EQUIPMENT'''
# Equipment that volunteers have or should have.
||person_id||PK||
||equipment_id||FK||
||quantity||INT||

'''LOCATION'''
||location_id||PK||
||location_type||ENUM (home, work, incident, organization, company, division)||
||street_address||CHAR||
||street_address2||CHAR||
||city|CHAR|||
||county||CHAR||
||state/province||CHAR||
||country||CHAR||
||postal_code||CHAR||
||longitude||||
||latitude||||
||last_updated||(DATE)||

'''PERSON_ADDRESS'''
||person_id||FK||
||address_id||FK||
||organization_id||FK||
||address_type||ENUM(home, work, organization)||

'''PERSON_ORGANIZATION'''
||person_id||FK||
||organization_id||FK||
||active||BOOLEAN
||leader||BOOLEAN
||title||CHAR||
||membership_started||DATE||
||membership_expires||DATE||

'''EMAIL'''
||email_id||PK||
||email_address||CHAR||
||email_type||ENUM(normal, pager)||
||last_updated||DATE||

'''PERSON_EMAIL'''
||person_id||FK||
||email_id||FK||

'''PHONE'''
# Can belong to person, organization, resource
||phone_id||PK||
||phone_type||ENUM(home, work, mobile, other)||
||area_code||INT||
||number||INT||
||extension||INT||
||service_provider||CHAR||
||confidential||BOOLEAN||
||primary||BOOLEAN||
||24_7||BOOLEAN||
||last_updated||DATE||
||organization_id||FK||
||resource_id||FK||
||time_of_day||ENUM(any, day, night)||
||comments||TEXT||

'''PERSON_PHONE'''
||person_id||FK||
||phone_id||FK||

'''CREDENTIAL'''
# Any kind of certificate, training, other prerequisite associated with a person
||credential_id||PK||
||credential_name||CHAR||
||credential_description||TEXT||
||credential_type||ENUM(communications, ICS, EMS, SAR, CERT, vaccination...)||

'''PERSON_CREDENTIAL'''
||person_id||FK||
||credential_id||FK||
||issuing_organization_id||FK||
||completion_date||DATE||
||verified_by||FK person_id||
||verified_date||DATE||
||credential_expires||DATE||
||credential_certificate_id||CHAR||

'''INCIDENT'''
||incident_id||PK||
||incident_name||TEXT||
||planned||BOOLEAN||
||incident_description||TEXT||
||incident_comments||TEXT||
||activation_code||CHAR||
||incident_contact||FK person_id||
||incident_type_id||FK||
||location_id||FK||
||address_id||FK||
||incident_page||FK page_id||
||twitter_hashtag||||

'''INCIDENT_TYPES'''
||incident_type_id||PK||
||incident_category||ENUM (preparedness, response)||
||incident_type||ENUM(fire, flood, earthquake, medical, evacuation, terrorism, other emergency, critical incident debrief, operational debrief, class, seminar, workshop, game, training, table-top exercise, functional exercise, full-scale exercise)||
||incident_geography||ENUM(neighborhood, city, county, region, state, national, global)||

'''PAGE'''
# web pages
||page_id||PK||
||URL||CHAR||
||title||CHAR||
||description||TEXT||
||last_reviewed||DATE||

'''PERSON_INCIDENT'''
||person_id||FK||
||incident_id||FK||
||notified||DATETIME||
||committed||DATETIME||
||committed_by||FK person_id ||
||arrived||DATETIME||
||departed||DATETIME||
||met_requirements||BOOLEAN||
||verified_by||FK person_id||

'''INCIDENT_ROLE'''
# Volunteer slots to be filled
||incident_id||FK||
||role_id||FK||
||shift_id||
||starting||DATETIME||
||ending||DATETIME||
||people_needed||INT||


'''INCIDENT_EVENT'''
# Logging - most of this will probably happen on paper, then transcribed
||event_id||PK||
||event_type||ENUM(person, resource, objective, assessment, situation report, status_report, strategy, intelligence, incident location, incident command, incident base, joint information center)||
||incident_id||FK||
||person_id||FK||
||person_event||ENUM (notified, en-route, checked_in, assigned, rehab, demobilized, available)||
||role_id||FK||
||address_id||FK||
||resource_id||FK||
||authority||FK person_id||
||incident_timestamp||DATETIME||
||public||BOOLEAN||
||incident_communications_primary||CHAR||
||incident_communications_secondary||CHAR||
||comment||TEXT||

'''ROLE_PREREQUISITE'''
# qualifications, training, etc.
||incident_id||FK||
||role_id||FK||
||prerequisite_id||FK||
||required||ENUM(True, recommended)||

'''CURRICULUM'''
# Series of classes that typically would be taken together
# Curriculum itself becomes a prerequisite
||curriculum_id||PK||
||curriculum_name||CHAR||
||incident_id||FK||
||recommended_sequence||INT||
||required||ENUM(Yes, Recommended||

'''ASSIGNMENT'''
||assignment_id||PK||
||incident_id||FK||
||assignment_description||TEXT||

'''ASSIGNMENT_PERSON'''
||assignment_id||FK||
||person_id||FK||
||assigned_when||DATETIME||
||removed_when||DATETIME||

'''ORGANIZATION'''
# Companies, government agencies, etc. - association or group of people with like objectives
||organization_id||PK||
||organization_name||CHAR||
||organization_phone||FK||
||organization_page||FK||
||organization_type||ENUM(company, foundation, government agency, NGO, responder)||
||organization_purpose||ENUM(medical, supplies, elder care, child care, church, shelter, school, public works, communications, transportation, firefighting, emergency management, mass care/emergency assistance/housing/human services, logistics, public health, SAR, hazardous materials, agriculture/natural resources, energy, law enforcement, long-term recovery)||
||vulnerable_population||ENUM (children, elderly, disabled)||
||donor||BOOLEAN||
||parent_organization||FK organization_id||
||organization_scope||ENUM(neighborhood, city, county, state, national, global)||

'''ORGANIZATION_SERVICE_AREA'''
# Geographic description of areas that an organization serves: TBD

'''RESOURCE'''
||resource_id||PK||
||resource_name||CHAR||
||resource_page||FK page_id||
||resource_type||ENUM(web site, park, storage, fire station, gas station, atm, water)||
||resource_scope||ENUM(neighborhood, city, county, state, national, global)||
||category||ENUM(training, operations, discussion, communications)||

'''RESOURCE_ADDRESS'''
||resource_id||FK||
||address_id||FK||

'''RESOURCE_PERSON'''
||resource_id||FK||
||person_id||FK||
||primary_contact||BOOLEAN

'''RESOURCE_ORGANIZATION'''
||resource_id||FK||
||organization_id||FK||

'''PROJECT'''
||project_id||PK||
||project_name||CHAR||
||project_category||ENUM(planning, supplies, finance, logistics...)||

'''PROJECT_PERSON'''
||project_id||FK||
||project_name||TEXT||

'''DIVISION'''
||division_id||PK||
||division_number||||
||division_name||CHAR||
||division_command_address_id||FK||
||primary_frs_channel||||
||primary_frs_pl||||
||tactical_frs_channel||||
||tactical_frs_pl||||