Entity list


Entity name Entity type Primary key # attributes
APPACTION dependent RULEID, ACTIONSEQ, USERGROUPID 9
APPRULE dependent RULEID, RULESEQ, USERGROUPID 13
ATTR_CODE dependent CODECAT, CODEVALUE, USERGROUPID 7
ATTRCODEXREF dependent ATTRID, USERGROUPID 7
ATTRDBXREF independent ATTRID 7
ATTRIBUTE dependent ATTRID, USERGROUPID 11
ATTRIBUTE_VISIBILITY dependent ATTRID, USERGROUPID 2
BI_FILE dependent PREFIX, FILESEQNUM 15
BI_FIREDEPT dependent PREFIX, FILESEQNUM, RECSEQNUM 9
BI_IMPORT independent PREFIX 9
BI_IMPORT_FILELIST dependent PREFIX, FILENAME 2
BI_INCIDENT dependent PREFIX, FILESEQNUM, RECSEQNUM 11
BP_BATCH_JOB independent BATCH_JOB_ID 14
BP_EXPORT_FIRE_DEPTS_TASK independent 4
BP_EXPORT_INCIDENTS_TASK independent 17
BP_INCIDENT_SET independent 2
CAS_CIVILIAN dependent INCIDENTID, CASUALTYNUM 25
CAS_EMS dependent INCIDENTID, CASUALTYNUM 17
CAS_EQUIP_FAIL dependent INCIDENTID, CASUALTYNUM, EQUIP_SEQ 8
CAS_FIRESERVICE dependent INCIDENTID, CASUALTYNUM 29
CHANGE_LOG independent LOGID 14
CHANGE_LOG_CHANGE_TYPE independent CHANGETYPE 2
CHANGE_LOG_ENTITY_TYPE independent ENTITYTYPE 2
CHANGE_LOG_GROUP independent 9
CHANGE_LOG_INCIDENT independent 5
CHEMICAL dependent CHEMICALID, USERGROUPID 7
CODECATEGORY independent CODECAT 6
EQUIP_INVOLVED dependent INCIDENTID, EQ_RECTYPE 8
EVENTMESSAGE dependent EVENTNUM, USERGROUPID 7
FD_APPARATUS dependent FDID, FDIDSTATE, FD_APSEQ 7
FD_APPARATUS_1025 independent 7
FD_HEADER independent FDID, FDIDSTATE 25
FD_HEADER_1025 independent 25
FD_PERSONNEL dependent FDID, FDIDSTATE, FD_PERSSEQ 12
FD_PERSONNEL_1025 independent 12
FD_SOFTWARE dependent FDID, FDID_STATE, VENDID, SOFTID 5
FIELDPERMS independent FDID, FDIDSTATE, ATTRID 6
FIRE_ALTADDR dependent INCIDENTID 8
FIRE_BEHAVIOR dependent INCIDENTID 6
FIRE_LATLONG dependent INCIDENTID 3
FIRE_PROPERTYMGMT dependent INCIDENTID 13
FIRE_STRUCTURE dependent INCIDENTID 29
FIRE_WEATHER dependent INCIDENTID 8
FIRE_WILDLAND dependent INCIDENTID 20
FIX_41 independent 1
GROUP_FLATFILE dependent USERGROUPID 2
GROUP_VERSIONS independent 3
GROUPS independent USERGROUPID 5
IN_ADDRESS dependent INCIDENTID 13
IN_APPARATUS dependent INCIDENTID, AP_SEQ 9
IN_ARSON dependent INCIDENTID 9
IN_ARSONAGENCYXREF dependent INCIDENTID 16
IN_ARSONJUVENILE dependent INCIDENTID, AR_SUBJECT 8
IN_AUTHORITY dependent INCIDENTID, AUTHTYPE 9
IN_BASIC dependent INCIDENTID 35
IN_BASIC41 dependent INCIDENTID 8
IN_FIRE dependent INCIDENTID 17
IN_FIRECAUSE independent INCIDENTID 4
IN_FIRECAUSE_RECODE independent INCIDENTID 4
IN_HAZMAT dependent INCIDENTID 17
IN_HMCHEMICAL dependent INCIDENTID, HM_NUM 14
IN_MULTIPLECODE dependent INCIDENTID, ATTRID, ATTRMAININDEX, ATTRSUBINDEX, ATTRSEQ 6
IN_MUTUALAID dependent INCIDENTID 4
IN_OWNERPERSON dependent INCIDENTID, ADDRTYPE, ADDRSEQ 20
IN_PERSONNEL dependent INCIDENTID, AP_SEQ, PR_SEQ 8
IN_SPECIALSTUDY dependent INCIDENTID, SS_SEQ, SPECIALSTUDYID 4
IN_TEMPLATEDETAIL dependent TEMPLATEID, USERGROUPID, TEMPLATESEQ 5
IN_TEMPLATEHEADER dependent TEMPLATEID, USERGROUPID 3
INC_ACTION independent INCIDENTID 1
INCIDENTKEY independent INCIDENTID 18
INSTANCE independent 14
INSTANCE_DETAIL independent 6
LOOKUP_NEXT_PK independent TABLENAME, USERGROUPID 4
MOBILE_PROP dependent INCIDENTID, MP_RECTYPE 9
NFIC_REGION independent REGIONSTATE 2
NFIRSTRANSACTION dependent TRANSID, USERGROUPID 10
NFIRSUSER independent USERNAME, USERSTATE 15
RESULT_STAGE independent 4
RESULTS independent 5
SPECIAL_STUDY dependent SS_ID, USERGROUPID 8
SS_CODE dependent SS_ID, SS_CODE, USERGROUPID 7
STAGINGAREA independent INCIDENTID, RPTID 2
TEMPLATE independent 8
TEMPLATE_DETAIL independent 7
TRANSCONVERT dependent TRANSID, USERGROUPID 5
TRANSDELIMATTR dependent TRANSID, USERGROUPID, TRANSSEQ, SUBTRANSEQ 8
TRANSFIXEDATTR dependent TRANSID, USERGROUPID, TRANSSEQ 9
USERCOMPRQMTXREF dependent ATTRID, USERGROUPID 5
USERCOMPSECXREF dependent ATTRID, USERGROUPID 5
VENDOR independent VENDID 15
VENDOR_SOFTWARE dependent VENDID, SOFTID 9
WINDOW dependent WINDOWID, USERGROUPID 5