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 |