Relationship 'FK_CHANGELOGENTITYTYPE'

 General info
Relationship type non-identifying Cardinality 1:N
Parent entity CHANGE_LOG_ENTITY_TYPE
Child entity CHANGE_LOG

 Parciality
Parent mandatory
Child optional

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
ENTITYTYPE ENTITYTYPE

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'FK_CHANGELOGGROUP'

 General info
Relationship type non-identifying Cardinality 1:N
Parent entity CHANGE_LOG
Child entity CHANGE_LOG_GROUP

 Parciality
Parent mandatory
Child optional

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
LOGID LOGID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'FK_CHANGELOGGROUPENTITYTYPE'

 General info
Relationship type non-identifying Cardinality 1:N
Parent entity CHANGE_LOG_ENTITY_TYPE
Child entity CHANGE_LOG_GROUP

 Parciality
Parent mandatory
Child optional

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
ENTITYTYPE ENTITYTYPE

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'FK_CHANGELOGINCIDENT'

 General info
Relationship type non-identifying Cardinality 1:N
Parent entity CHANGE_LOG
Child entity CHANGE_LOG_INCIDENT

 Parciality
Parent mandatory
Child optional

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
LOGID LOGID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'FK_CHANGELOGLOGENTRYTYPE'

 General info
Relationship type non-identifying Cardinality 1:N
Parent entity CHANGE_LOG_CHANGE_TYPE
Child entity CHANGE_LOG

 Parciality
Parent mandatory
Child optional

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
CHANGETYPE LOGENTRYTYPE

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003912'

 General info
Relationship type identifying Cardinality 1:N
Parent entity INCIDENTKEY
Child entity IN_BASIC41

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003913'

 General info
Relationship type identifying Cardinality 1:N
Parent entity INCIDENTKEY
Child entity IN_FIRE

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003914'

 General info
Relationship type identifying Cardinality 1:N
Parent entity INCIDENTKEY
Child entity IN_HAZMAT

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003915'

 General info
Relationship type identifying Cardinality 1:N
Parent entity IN_HAZMAT
Child entity IN_HMCHEMICAL

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003916'

 General info
Relationship type identifying Cardinality 1:N
Parent entity IN_BASIC
Child entity IN_MUTUALAID

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003917'

 General info
Relationship type identifying Cardinality 1:N
Parent entity IN_BASIC
Child entity IN_OWNERPERSON

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003918'

 General info
Relationship type identifying Cardinality 1:N
Parent entity IN_BASIC
Child entity IN_ADDRESS

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003919'

 General info
Relationship type identifying Cardinality 1:N
Parent entity INCIDENTKEY
Child entity IN_ARSON

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003920'

 General info
Relationship type identifying Cardinality 1:N
Parent entity IN_ARSON
Child entity IN_ARSONAGENCYXREF

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003921'

 General info
Relationship type identifying Cardinality 1:N
Parent entity IN_ARSON
Child entity IN_ARSONJUVENILE

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003922'

 General info
Relationship type identifying Cardinality 1:N
Parent entity IN_BASIC
Child entity IN_AUTHORITY

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003923'

 General info
Relationship type identifying Cardinality 1:N
Parent entity INCIDENTKEY
Child entity IN_BASIC

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003924'

 General info
Relationship type identifying Cardinality 1:N
Parent entity FIRE_WILDLAND
Child entity FIRE_BEHAVIOR

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003925'

 General info
Relationship type identifying Cardinality 1:N
Parent entity FIRE_WILDLAND
Child entity FIRE_LATLONG

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003926'

 General info
Relationship type identifying Cardinality 1:N
Parent entity INCIDENTKEY
Child entity FIRE_STRUCTURE

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003927'

 General info
Relationship type identifying Cardinality 1:N
Parent entity FIRE_WILDLAND
Child entity FIRE_WEATHER

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003928'

 General info
Relationship type identifying Cardinality 1:N
Parent entity INCIDENTKEY
Child entity FIRE_WILDLAND

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003929'

 General info
Relationship type non-identifying Cardinality 1:N
Parent entity GROUPS
Child entity CODECATEGORY

 Parciality
Parent mandatory
Child optional

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
USERGROUPID USERGROUPID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003930'

 General info
Relationship type identifying Cardinality 1:N
Parent entity INCIDENTKEY
Child entity EQUIP_INVOLVED

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003931'

 General info
Relationship type identifying Cardinality 1:N
Parent entity GROUPS
Child entity EVENTMESSAGE

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
USERGROUPID USERGROUPID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003932'

 General info
Relationship type identifying Cardinality 1:N
Parent entity FD_HEADER
Child entity FD_APPARATUS

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
FDID FDID
FDIDSTATE FDIDSTATE

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003933'

 General info
Relationship type identifying Cardinality 1:N
Parent entity FD_HEADER
Child entity FD_PERSONNEL

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
FDID FDID
FDIDSTATE FDIDSTATE

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003934'

 General info
Relationship type identifying Cardinality 1:N
Parent entity VENDOR_SOFTWARE
Child entity FD_SOFTWARE

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
VENDID VENDID
SOFTID SOFTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003935'

 General info
Relationship type identifying Cardinality 1:N
Parent entity FIRE_WILDLAND
Child entity FIRE_ALTADDR

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003936'

 General info
Relationship type identifying Cardinality 1:N
Parent entity BI_IMPORT
Child entity BI_IMPORT_FILELIST

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
PREFIX PREFIX

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003937'

 General info
Relationship type identifying Cardinality 1:N
Parent entity BI_FILE
Child entity BI_INCIDENT

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
PREFIX PREFIX
FILESEQNUM FILESEQNUM

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003938'

 General info
Relationship type identifying Cardinality 1:N
Parent entity INCIDENTKEY
Child entity CAS_CIVILIAN

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003939'

 General info
Relationship type identifying Cardinality 1:N
Parent entity INCIDENTKEY
Child entity CAS_EMS

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003940'

 General info
Relationship type identifying Cardinality 1:N
Parent entity INCIDENTKEY
Child entity CAS_FIRESERVICE

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003941'

 General info
Relationship type identifying Cardinality 1:N
Parent entity GROUPS
Child entity CHEMICAL

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
USERGROUPID USERGROUPID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003942'

 General info
Relationship type identifying Cardinality 1:N
Parent entity GROUPS
Child entity APPACTION

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
USERGROUPID USERGROUPID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003943'

 General info
Relationship type identifying Cardinality 1:N
Parent entity GROUPS
Child entity APPRULE

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
USERGROUPID USERGROUPID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003944'

 General info
Relationship type non-identifying Cardinality 1:N
Parent entity CODECATEGORY
Child entity ATTRCODEXREF

 Parciality
Parent mandatory
Child optional

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
CODECAT CODECAT

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003945'

 General info
Relationship type identifying Cardinality 1:N
Parent entity ATTRIBUTE
Child entity ATTRCODEXREF

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
ATTRID ATTRID
USERGROUPID USERGROUPID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003946'

 General info
Relationship type identifying Cardinality 1:N
Parent entity GROUPS
Child entity ATTRIBUTE

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
USERGROUPID USERGROUPID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003947'

 General info
Relationship type identifying Cardinality 1:N
Parent entity ATTRIBUTE
Child entity ATTRIBUTE_VISIBILITY

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
ATTRID ATTRID
USERGROUPID USERGROUPID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003948'

 General info
Relationship type identifying Cardinality 1:N
Parent entity CODECATEGORY
Child entity ATTR_CODE

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
CODECAT CODECAT

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003949'

 General info
Relationship type identifying Cardinality 1:N
Parent entity GROUPS
Child entity ATTR_CODE

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
USERGROUPID USERGROUPID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003950'

 General info
Relationship type identifying Cardinality 1:N
Parent entity BI_IMPORT
Child entity BI_FILE

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
PREFIX PREFIX

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003951'

 General info
Relationship type identifying Cardinality 1:N
Parent entity BI_FILE
Child entity BI_FIREDEPT

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
PREFIX PREFIX
FILESEQNUM FILESEQNUM

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003952'

 General info
Relationship type identifying Cardinality 1:N
Parent entity IN_APPARATUS
Child entity IN_PERSONNEL

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID
AP_SEQ AP_SEQ

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003953'

 General info
Relationship type identifying Cardinality 1:N
Parent entity IN_BASIC
Child entity IN_SPECIALSTUDY

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003954'

 General info
Relationship type identifying Cardinality 1:N
Parent entity IN_TEMPLATEHEADER
Child entity IN_TEMPLATEDETAIL

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
TEMPLATEID TEMPLATEID
USERGROUPID USERGROUPID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003955'

 General info
Relationship type identifying Cardinality 1:N
Parent entity GROUPS
Child entity IN_TEMPLATEHEADER

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
USERGROUPID USERGROUPID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003956'

 General info
Relationship type identifying Cardinality 1:N
Parent entity INCIDENTKEY
Child entity MOBILE_PROP

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003957'

 General info
Relationship type identifying Cardinality 1:N
Parent entity GROUPS
Child entity NFIRSTRANSACTION

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
USERGROUPID USERGROUPID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003958'

 General info
Relationship type non-identifying Cardinality 1:N
Parent entity GROUPS
Child entity NFIRSUSER

 Parciality
Parent mandatory
Child optional

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
USERGROUPID USERGROUPID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003959'

 General info
Relationship type identifying Cardinality 1:N
Parent entity GROUPS
Child entity SPECIAL_STUDY

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
USERGROUPID USERGROUPID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003960'

 General info
Relationship type identifying Cardinality 1:N
Parent entity SPECIAL_STUDY
Child entity SS_CODE

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
SS_ID SS_ID
USERGROUPID USERGROUPID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003961'

 General info
Relationship type identifying Cardinality 1:N
Parent entity NFIRSTRANSACTION
Child entity TRANSCONVERT

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
TRANSID TRANSIDOLD
USERGROUPID USERGROUPID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003962'

 General info
Relationship type identifying Cardinality 1:N
Parent entity NFIRSTRANSACTION
Child entity TRANSDELIMATTR

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
TRANSID TRANSID
USERGROUPID USERGROUPID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003963'

 General info
Relationship type identifying Cardinality 1:N
Parent entity NFIRSTRANSACTION
Child entity TRANSFIXEDATTR

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
TRANSID TRANSID
USERGROUPID USERGROUPID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003964'

 General info
Relationship type identifying Cardinality 1:N
Parent entity GROUPS
Child entity USERCOMPRQMTXREF

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
USERGROUPID USERGROUPID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003965'

 General info
Relationship type identifying Cardinality 1:N
Parent entity ATTRIBUTE
Child entity USERCOMPSECXREF

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT RESTRICT
Child NONE NONE ----

 Keys
Parent key Child key
ATTRID ATTRID
USERGROUPID USERGROUPID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003966'

 General info
Relationship type identifying Cardinality 1:N
Parent entity VENDOR
Child entity VENDOR_SOFTWARE

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
VENDID VENDID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003967'

 General info
Relationship type identifying Cardinality 1:N
Parent entity GROUPS
Child entity WINDOW

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
USERGROUPID USERGROUPID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003968'

 General info
Relationship type identifying Cardinality 1:N
Parent entity GROUPS
Child entity GROUP_FLATFILE

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
USERGROUPID USERGROUPID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003969'

 General info
Relationship type identifying Cardinality 1:N
Parent entity INCIDENTKEY
Child entity IN_MULTIPLECODE

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003970'

 General info
Relationship type identifying Cardinality 1:N
Parent entity INCIDENTKEY
Child entity IN_APPARATUS

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003971'

 General info
Relationship type identifying Cardinality 1:N
Parent entity INCIDENTKEY
Child entity FIRE_PROPERTYMGMT

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No


Relationship 'SYS_C003972'

 General info
Relationship type identifying Cardinality 1:N
Parent entity CAS_FIRESERVICE
Child entity CAS_EQUIP_FAIL

 Parciality
Parent mandatory
Child mandatory

 Referential integrity
Insert Update Delete
Parent ---- RESTRICT CASCADE
Child NONE NONE ----

 Keys
Parent key Child key
INCIDENTID INCIDENTID
CASUALTYNUM CASUALTYNUM

 User-defined variables
Name Value
Referential Integrity Deferrable No
Referential Integrity Initially Deferred No