Relationship 'FK_CHANGELOGENTITYTYPE' |
![]() |
Relationship type | non-identifying | Cardinality | 1:N |
Parent entity | CHANGE_LOG_ENTITY_TYPE | ||
Child entity | CHANGE_LOG |
![]() |
Parent | mandatory |
Child | optional |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
ENTITYTYPE | ENTITYTYPE |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'FK_CHANGELOGGROUP' |
![]() |
Relationship type | non-identifying | Cardinality | 1:N |
Parent entity | CHANGE_LOG | ||
Child entity | CHANGE_LOG_GROUP |
![]() |
Parent | mandatory |
Child | optional |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
LOGID | LOGID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'FK_CHANGELOGGROUPENTITYTYPE' |
![]() |
Relationship type | non-identifying | Cardinality | 1:N |
Parent entity | CHANGE_LOG_ENTITY_TYPE | ||
Child entity | CHANGE_LOG_GROUP |
![]() |
Parent | mandatory |
Child | optional |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
ENTITYTYPE | ENTITYTYPE |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'FK_CHANGELOGINCIDENT' |
![]() |
Relationship type | non-identifying | Cardinality | 1:N |
Parent entity | CHANGE_LOG | ||
Child entity | CHANGE_LOG_INCIDENT |
![]() |
Parent | mandatory |
Child | optional |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
LOGID | LOGID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'FK_CHANGELOGLOGENTRYTYPE' |
![]() |
Relationship type | non-identifying | Cardinality | 1:N |
Parent entity | CHANGE_LOG_CHANGE_TYPE | ||
Child entity | CHANGE_LOG |
![]() |
Parent | mandatory |
Child | optional |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
CHANGETYPE | LOGENTRYTYPE |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003912' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | INCIDENTKEY | ||
Child entity | IN_BASIC41 |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003913' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | INCIDENTKEY | ||
Child entity | IN_FIRE |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003914' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | INCIDENTKEY | ||
Child entity | IN_HAZMAT |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003915' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | IN_HAZMAT | ||
Child entity | IN_HMCHEMICAL |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003916' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | IN_BASIC | ||
Child entity | IN_MUTUALAID |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003917' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | IN_BASIC | ||
Child entity | IN_OWNERPERSON |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003918' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | IN_BASIC | ||
Child entity | IN_ADDRESS |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003919' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | INCIDENTKEY | ||
Child entity | IN_ARSON |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003920' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | IN_ARSON | ||
Child entity | IN_ARSONAGENCYXREF |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003921' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | IN_ARSON | ||
Child entity | IN_ARSONJUVENILE |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003922' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | IN_BASIC | ||
Child entity | IN_AUTHORITY |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003923' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | INCIDENTKEY | ||
Child entity | IN_BASIC |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003924' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | FIRE_WILDLAND | ||
Child entity | FIRE_BEHAVIOR |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003925' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | FIRE_WILDLAND | ||
Child entity | FIRE_LATLONG |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003926' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | INCIDENTKEY | ||
Child entity | FIRE_STRUCTURE |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003927' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | FIRE_WILDLAND | ||
Child entity | FIRE_WEATHER |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003928' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | INCIDENTKEY | ||
Child entity | FIRE_WILDLAND |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003929' |
![]() |
Relationship type | non-identifying | Cardinality | 1:N |
Parent entity | GROUPS | ||
Child entity | CODECATEGORY |
![]() |
Parent | mandatory |
Child | optional |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
USERGROUPID | USERGROUPID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003930' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | INCIDENTKEY | ||
Child entity | EQUIP_INVOLVED |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003931' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | GROUPS | ||
Child entity | EVENTMESSAGE |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
USERGROUPID | USERGROUPID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003932' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | FD_HEADER | ||
Child entity | FD_APPARATUS |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
FDID | FDID |
FDIDSTATE | FDIDSTATE |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003933' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | FD_HEADER | ||
Child entity | FD_PERSONNEL |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
FDID | FDID |
FDIDSTATE | FDIDSTATE |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003934' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | VENDOR_SOFTWARE | ||
Child entity | FD_SOFTWARE |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
VENDID | VENDID |
SOFTID | SOFTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003935' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | FIRE_WILDLAND | ||
Child entity | FIRE_ALTADDR |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003936' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | BI_IMPORT | ||
Child entity | BI_IMPORT_FILELIST |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
PREFIX | PREFIX |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003937' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | BI_FILE | ||
Child entity | BI_INCIDENT |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
PREFIX | PREFIX |
FILESEQNUM | FILESEQNUM |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003938' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | INCIDENTKEY | ||
Child entity | CAS_CIVILIAN |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003939' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | INCIDENTKEY | ||
Child entity | CAS_EMS |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003940' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | INCIDENTKEY | ||
Child entity | CAS_FIRESERVICE |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003941' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | GROUPS | ||
Child entity | CHEMICAL |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
USERGROUPID | USERGROUPID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003942' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | GROUPS | ||
Child entity | APPACTION |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
USERGROUPID | USERGROUPID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003943' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | GROUPS | ||
Child entity | APPRULE |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
USERGROUPID | USERGROUPID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003944' |
![]() |
Relationship type | non-identifying | Cardinality | 1:N |
Parent entity | CODECATEGORY | ||
Child entity | ATTRCODEXREF |
![]() |
Parent | mandatory |
Child | optional |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
CODECAT | CODECAT |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003945' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | ATTRIBUTE | ||
Child entity | ATTRCODEXREF |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
ATTRID | ATTRID |
USERGROUPID | USERGROUPID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003946' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | GROUPS | ||
Child entity | ATTRIBUTE |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
USERGROUPID | USERGROUPID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003947' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | ATTRIBUTE | ||
Child entity | ATTRIBUTE_VISIBILITY |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
ATTRID | ATTRID |
USERGROUPID | USERGROUPID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003948' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | CODECATEGORY | ||
Child entity | ATTR_CODE |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
CODECAT | CODECAT |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003949' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | GROUPS | ||
Child entity | ATTR_CODE |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
USERGROUPID | USERGROUPID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003950' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | BI_IMPORT | ||
Child entity | BI_FILE |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
PREFIX | PREFIX |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003951' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | BI_FILE | ||
Child entity | BI_FIREDEPT |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
PREFIX | PREFIX |
FILESEQNUM | FILESEQNUM |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003952' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | IN_APPARATUS | ||
Child entity | IN_PERSONNEL |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
AP_SEQ | AP_SEQ |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003953' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | IN_BASIC | ||
Child entity | IN_SPECIALSTUDY |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003954' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | IN_TEMPLATEHEADER | ||
Child entity | IN_TEMPLATEDETAIL |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
TEMPLATEID | TEMPLATEID |
USERGROUPID | USERGROUPID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003955' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | GROUPS | ||
Child entity | IN_TEMPLATEHEADER |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
USERGROUPID | USERGROUPID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003956' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | INCIDENTKEY | ||
Child entity | MOBILE_PROP |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003957' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | GROUPS | ||
Child entity | NFIRSTRANSACTION |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
USERGROUPID | USERGROUPID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003958' |
![]() |
Relationship type | non-identifying | Cardinality | 1:N |
Parent entity | GROUPS | ||
Child entity | NFIRSUSER |
![]() |
Parent | mandatory |
Child | optional |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
USERGROUPID | USERGROUPID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003959' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | GROUPS | ||
Child entity | SPECIAL_STUDY |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
USERGROUPID | USERGROUPID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003960' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | SPECIAL_STUDY | ||
Child entity | SS_CODE |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
SS_ID | SS_ID |
USERGROUPID | USERGROUPID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003961' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | NFIRSTRANSACTION | ||
Child entity | TRANSCONVERT |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
TRANSID | TRANSIDOLD |
USERGROUPID | USERGROUPID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003962' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | NFIRSTRANSACTION | ||
Child entity | TRANSDELIMATTR |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
TRANSID | TRANSID |
USERGROUPID | USERGROUPID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003963' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | NFIRSTRANSACTION | ||
Child entity | TRANSFIXEDATTR |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
TRANSID | TRANSID |
USERGROUPID | USERGROUPID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003964' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | GROUPS | ||
Child entity | USERCOMPRQMTXREF |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
USERGROUPID | USERGROUPID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003965' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | ATTRIBUTE | ||
Child entity | USERCOMPSECXREF |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | RESTRICT |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
ATTRID | ATTRID |
USERGROUPID | USERGROUPID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003966' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | VENDOR | ||
Child entity | VENDOR_SOFTWARE |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
VENDID | VENDID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003967' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | GROUPS | ||
Child entity | WINDOW |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
USERGROUPID | USERGROUPID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003968' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | GROUPS | ||
Child entity | GROUP_FLATFILE |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
USERGROUPID | USERGROUPID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003969' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | INCIDENTKEY | ||
Child entity | IN_MULTIPLECODE |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003970' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | INCIDENTKEY | ||
Child entity | IN_APPARATUS |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003971' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | INCIDENTKEY | ||
Child entity | FIRE_PROPERTYMGMT |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |
Relationship 'SYS_C003972' |
![]() |
Relationship type | identifying | Cardinality | 1:N |
Parent entity | CAS_FIRESERVICE | ||
Child entity | CAS_EQUIP_FAIL |
![]() |
Parent | mandatory |
Child | mandatory |
![]() |
Insert | Update | Delete | |
Parent | ---- | RESTRICT | CASCADE |
Child | NONE | NONE | ---- |
![]() |
Parent key | Child key |
INCIDENTID | INCIDENTID |
CASUALTYNUM | CASUALTYNUM |
![]() |
Name | Value |
Referential Integrity Deferrable | No |
Referential Integrity Initially Deferred | No |