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...

Components

• Location: address, coordinate, postal info
• Person: individual
• Role: hierarchy of structure and command
• Organization: companies, agencies, etc., with inter-relationships
• Membership: relationship of people to organizations
• Incident: deployment, training, exercise, debriefing, etc.
• Credential: training, 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
• Alerting - instant messaging, SMS, printed phone tree generation
• Export KML data to maps
• Calendar
• Dashboards for incidents, teams, resources, projects
• ICS/NIMS forms
• Access control
• 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...)
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
function	ENUM (Command, Operations, Planning, Logistics, Finance/Admin, Intelligence/Investigation)
role_assigned	DATETIME
reports_to	FK person_id

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

ADDRESS

address_id	PK
address_type	ENUM (home, work, incident, organization, company, division)
address	CHAR
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_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

INCIDENT_PREREQUISITE # qualifications, training, etc.

incident_id	FK
prerequisite_id	FK
required	ENUM(True, 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