Entity 'APPACTION' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | RULEID | Number | YES | NO | ||
PK | ACTIONSEQ | Number | YES | NO | ||
PFK | USERGROUPID | Number | YES | NO | ||
RULEFAMILY | Number | YES | NO | |||
ACTIONATTRID | Number | NO | NO | |||
ACTIONTYPE | Varchar2 | NO | NO | |||
ACTIONVALUE | Varchar2 | NO | NO | |||
ACTIONSTATUS | Varchar2 | NO | NO | |||
LASTUPDATED | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003942 | Identifying | GROUPS | APPACTION | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'APPRULE' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | RULEID | Number | YES | NO | ||
PK | RULESEQ | Number | YES | NO | ||
PFK | USERGROUPID | Number | YES | NO | ||
RULEFAMILY | Number | YES | NO | |||
RULEPRECEDENCE | Number | NO | NO | |||
RULETYPE | Varchar2 | YES | NO | |||
RULEINTERRULEOPER | Varchar2 | YES | NO | |||
RULEATTRID | Number | NO | NO | |||
RULEATTRRELATIVE | Varchar2 | NO | NO | |||
RULEOPERATOR | Varchar2 | YES | NO | |||
RULEVALUE | Varchar2 | NO | NO | |||
RULESTATUS | Varchar2 | NO | NO | |||
LASTUPDATED | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003943 | Identifying | GROUPS | APPRULE | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'ATTR_CODE' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | CODECAT | Number | YES | NO | ||
PK | CODEVALUE | Varchar2 | YES | NO | ||
PFK | USERGROUPID | Number | YES | NO | ||
PARENTCODEVALUE | Varchar2 | YES | NO | |||
DECODEVALUE | Varchar2 | NO | NO | |||
CODESTATUS | Varchar2 | NO | NO | |||
LASTUPDATED | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003948 | Identifying | CODECATEGORY | ATTR_CODE | 1:N |
SYS_C003949 | Identifying | GROUPS | ATTR_CODE | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'ATTRCODEXREF' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | ATTRID | Number | YES | NO | ||
PFK | USERGROUPID | Number | YES | NO | ||
FK | CODECAT | Number | NO | NO | ||
MAXCODERESPONSES | Number | NO | NO | |||
RESPONSEORDER | Varchar2 | NO | NO | |||
XREFSTATUS | Varchar2 | NO | NO | |||
LASTUPDATED | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003945 | Identifying | ATTRIBUTE | ATTRCODEXREF | 1:N |
SYS_C003944 | Non-identifying | CODECATEGORY | ATTRCODEXREF | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'ATTRDBXREF' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | ATTRID | Number | YES | NO | ||
TABLE_NAME | Varchar2 | YES | NO | |||
FIELD | Varchar2 | YES | NO | |||
MOVE | Varchar2 | YES | NO | |||
VISIBLE | Varchar2 | YES | NO | |||
FTYPE | Varchar2 | NO | NO | |||
ATTR_DATATYPE | Number | NO | NO |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'ATTRIBUTE' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | ATTRID | Number | YES | NO | ||
PFK | USERGROUPID | Number | YES | NO | ||
ATTR_DESC | Varchar2 | NO | NO | |||
WINDOWID | Number | NO | NO | |||
ATTR_TYPE | Varchar2 | NO | NO | |||
ATTR_LENGTH | Number | NO | NO | |||
ATTR_APPLDEFAULTSEC | Number | YES | NO | |||
ATTR_APPLDEFAULTRQMT | Number | YES | NO | |||
ATTR_LOSTFOCUSMASK | Varchar2 | NO | NO | |||
ATTR_STATUS | Varchar2 | NO | NO | |||
LASTUPDATED | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003945 | Identifying | ATTRIBUTE | ATTRCODEXREF | 1:N |
SYS_C003947 | Identifying | ATTRIBUTE | ATTRIBUTE_VISIBILITY | 1:N |
SYS_C003965 | Identifying | ATTRIBUTE | USERCOMPSECXREF | 1:N |
SYS_C003946 | Identifying | GROUPS | ATTRIBUTE | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'ATTRIBUTE_VISIBILITY' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | ATTRID | Number | YES | NO | ||
PFK | USERGROUPID | Number | YES | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003947 | Identifying | ATTRIBUTE | ATTRIBUTE_VISIBILITY | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'BI_FILE' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | PREFIX | Varchar2 | YES | NO | ||
PK | FILESEQNUM | Number(x,y) | YES | NO | ||
FILENAME | Varchar2 | NO | NO | |||
FILESIZE | Number(x,y) | NO | NO | |||
DATAVERSION | Varchar2 | NO | NO | |||
NUMFD | Number(x,y) | NO | NO | |||
NUMINC | Number(x,y) | NO | NO | |||
BEGIN_TIME | Date | NO | NO | |||
END_TIME | Date | NO | NO | |||
TYPE_OK | Varchar2 | NO | NO | |||
RESUME_VALID | Number(x,y) | NO | NO | |||
RESUME_INVALID | Number(x,y) | NO | NO | |||
RESUME_DELETED | Number(x,y) | NO | NO | |||
RESUME_FAILED | Number(x,y) | NO | NO | |||
WAS_INTERRUPTED | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003951 | Identifying | BI_FILE | BI_FIREDEPT | 1:N |
SYS_C003937 | Identifying | BI_FILE | BI_INCIDENT | 1:N |
SYS_C003950 | Identifying | BI_IMPORT | BI_FILE | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'BI_FIREDEPT' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | PREFIX | Varchar2 | YES | NO | ||
PFK | FILESEQNUM | Number(x,y) | YES | NO | ||
PK | RECSEQNUM | Number(x,y) | YES | NO | ||
FDID | Varchar2 | NO | NO | |||
WAS_IMPORTED | Varchar2 | NO | NO | |||
STATUS | Varchar2 | NO | NO | |||
ACTION_TYPE | Number(x,y) | NO | NO | |||
VALID | Varchar2 | NO | NO | |||
MARKER | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003951 | Identifying | BI_FILE | BI_FIREDEPT | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'BI_IMPORT' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | PREFIX | Varchar2 | YES | NO | ||
USERNAME | Varchar2 | NO | NO | |||
USERSTATE | Varchar2 | NO | NO | |||
USEREMAIL | Varchar2 | NO | NO | |||
ACCEPT_INVALID | Varchar2 | NO | NO | |||
OVERWRITE_EXISTING | Varchar2 | NO | NO | |||
NUMFILES | Number(x,y) | NO | NO | |||
BEGIN_TIME | Date | NO | NO | |||
END_TIME | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003950 | Identifying | BI_IMPORT | BI_FILE | 1:N |
SYS_C003936 | Identifying | BI_IMPORT | BI_IMPORT_FILELIST | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'BI_IMPORT_FILELIST' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | PREFIX | Varchar2 | YES | NO | ||
PK | FILENAME | Varchar2 | YES | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003936 | Identifying | BI_IMPORT | BI_IMPORT_FILELIST | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'BI_INCIDENT' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | PREFIX | Varchar2 | YES | NO | ||
PFK | FILESEQNUM | Number(x,y) | YES | NO | ||
PK | RECSEQNUM | Number(x,y) | YES | NO | ||
INCIDENTID | Varchar2 | NO | NO | |||
FDID | Varchar2 | NO | NO | |||
INCDATE | Date | NO | NO | |||
WAS_IMPORTED | Varchar2 | NO | NO | |||
STATUS | Varchar2 | NO | NO | |||
ACTION_TYPE | Number(x,y) | NO | NO | |||
VALID | Varchar2 | NO | NO | |||
MARKER | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003937 | Identifying | BI_FILE | BI_INCIDENT | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'BP_BATCH_JOB' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | BATCH_JOB_ID | Number | YES | NO | ||
BATCH_JOB_TYPE | Varchar2 | NO | NO | |||
BATCH_JOB_NAME | Varchar2 | NO | NO | |||
USERSTATE | Varchar2 | NO | NO | |||
USERNAME | Varchar2 | NO | NO | |||
USEREMAIL | Varchar2 | NO | NO | |||
STATUS | Varchar2 | NO | NO | |||
SUBMITTED_AT | Date | NO | NO | |||
ENTERED_QUEUE_AT | Date | NO | NO | |||
PROCESSING_STARTED_AT | Date | NO | NO | |||
PROCESSING_COMPLETED_AT | Date | NO | NO | |||
CANCELLED_AT | Date | NO | NO | |||
NUM_ITEMS_MATCHING | Number | NO | NO | |||
NUM_ITEMS_VISITED | Number | NO | NO |
![]() |
Name | Value |
Owner | BATCH_PROCESSOR |
Tablespace for Primary key | INDX |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'BP_EXPORT_FIRE_DEPTS_TASK' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
BATCH_JOB_ID | Number | NO | NO | |||
SCOPE_USERGROUPID | Number | NO | NO | |||
NUMBER_OF_EXPORT_FILES | Number | NO | NO | |||
EXPORT_FILES_PREFIX | Varchar2 | NO | NO |
![]() |
Name | Value |
Owner | BATCH_PROCESSOR |
Tablespace for Primary key | |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'BP_EXPORT_INCIDENTS_TASK' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
BATCH_JOB_ID | Number | NO | NO | |||
SCOPE_EXPOSURE | Number | NO | NO | |||
SCOPE_USERGROUPID | Number | NO | NO | |||
SCOPE_FROM_DATE | Date | NO | NO | |||
SCOPE_TO_DATE | Date | NO | NO | |||
SCOPE_IN_NFIRSLOADVERSION | Varchar2 | NO | NO | |||
SCOPE_IN_NUM | Varchar2 | NO | NO | |||
SCOPE_IN_STATUS | Varchar2 | NO | NO | |||
SCOPE_IS_RELEASED | Varchar2 | NO | NO | |||
SCOPE_MODIFIED_SINCE | Date | NO | NO | |||
SCOPE_FROM_IN_TYPE | Varchar2 | NO | NO | |||
SCOPE_TO_IN_TYPE | Varchar2 | NO | NO | |||
SCOPE_FROM_IN_PROPERTYUSE | Varchar2 | NO | NO | |||
SCOPE_TO_IN_PROPERTYUSE | Varchar2 | NO | NO | |||
INCIDENT_SET_ID | Number | NO | NO | |||
NUMBER_OF_EXPORT_FILES | Number | NO | NO | |||
EXPORT_FILES_PREFIX | Varchar2 | NO | NO |
![]() |
Name | Value |
Owner | BATCH_PROCESSOR |
Tablespace for Primary key | |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'BP_INCIDENT_SET' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
INCIDENT_SET_ID | Number | NO | NO | |||
INCIDENTID | Number | NO | NO |
![]() |
Name | Value |
Owner | BATCH_PROCESSOR |
Tablespace for Primary key | |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'CAS_CIVILIAN' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
PK | CASUALTYNUM | Number | YES | NO | ||
CC_FNAME | Varchar2 | NO | NO | |||
CC_MI | Varchar2 | NO | NO | |||
CC_LNAME | Varchar2 | NO | NO | |||
CC_SUFFIX | Varchar2 | NO | NO | |||
CC_GENDER | Varchar2 | NO | NO | |||
CC_AGE | Number(x,y) | NO | NO | |||
CC_RACE | Varchar2 | NO | NO | |||
CC_ETHNICITY | Varchar2 | NO | NO | |||
CC_AFFILIATION | Varchar2 | NO | NO | |||
CC_INJURYDATE | Date | NO | NO | |||
CC_SEVERITY | Varchar2 | NO | NO | |||
CC_CAUSEOFINJURY | Varchar2 | NO | NO | |||
CC_ACTIVITYWHENINJURED | Varchar2 | NO | NO | |||
CC_LOCATIONATINCIDENT | Varchar2 | NO | NO | |||
CC_LOCATIONWHENINJURED | Varchar2 | NO | NO | |||
CC_FLOORATSTART | Number | NO | NO | |||
CC_FLOORATSTARTBELOWGRADE | Varchar2 | NO | NO | |||
CC_FLOORATINJURED | Number | NO | NO | |||
CC_FLOORATINJUREDBELOWGRADE | Varchar2 | NO | NO | |||
CC_SPECIFICLOCATION | Varchar2 | NO | NO | |||
CC_PRIMARYSYMPTOM | Varchar2 | NO | NO | |||
CC_PRIMARYBODYPART | Varchar2 | NO | NO | |||
CC_DISPOSITION | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003938 | Identifying | INCIDENTKEY | CAS_CIVILIAN | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'CAS_EMS' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
PK | CASUALTYNUM | Number | YES | NO | ||
EMS_ARRPATIENTDATE | Date | NO | NO | |||
EMS_PATIENTTRANDATE | Date | NO | NO | |||
EMS_PROVIDERASSESS | Varchar2 | NO | NO | |||
EMS_AGE | Number(x,y) | NO | NO | |||
EMS_GENDER | Varchar2 | NO | NO | |||
EMS_RACE | Varchar2 | NO | NO | |||
EMS_ETHNICITY | Varchar2 | NO | NO | |||
EMS_OTHERFACTORS | Varchar2 | NO | NO | |||
EMS_CAUSEOFILLNESS | Varchar2 | NO | NO | |||
EMS_INITARRESTRYTHM | Varchar2 | NO | NO | |||
EMS_INITIALCARELEVEL | Varchar2 | NO | NO | |||
EMS_HIGHESTCARELEVEL | Varchar2 | NO | NO | |||
EMS_PATIENTSTATUS | Varchar2 | NO | NO | |||
EMS_TRANSFERSTATUS | Varchar2 | NO | NO | |||
EMS_DISPOSITION | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003939 | Identifying | INCIDENTKEY | CAS_EMS | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'CAS_EQUIP_FAIL' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
PFK | CASUALTYNUM | Number | YES | NO | ||
PK | EQUIP_SEQ | Number | YES | NO | ||
FS_EQUIPITEM | Varchar2 | NO | NO | |||
FS_EQUIPPROB | Varchar2 | NO | NO | |||
FS_MANUFACTURER | Varchar2 | NO | NO | |||
FS_MODEL | Varchar2 | NO | NO | |||
FS_SERIALNUM | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003972 | Identifying | CAS_FIRESERVICE | CAS_EQUIP_FAIL | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'CAS_FIRESERVICE' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
PK | CASUALTYNUM | Number | YES | NO | ||
FS_ID | Varchar2 | NO | NO | |||
FS_LNAME | Varchar2 | NO | NO | |||
FS_FNAME | Varchar2 | NO | NO | |||
FS_MI | Varchar2 | NO | NO | |||
FS_SUFFIX | Varchar2 | NO | NO | |||
FS_GENDER | Varchar2 | NO | NO | |||
FS_CAREER | Varchar2 | NO | NO | |||
FS_AGE | Number | NO | NO | |||
FS_INJURYDATE | Date | NO | NO | |||
FS_RESPONSES | Number | NO | NO | |||
FS_USUALASSIGNMENT | Varchar2 | NO | NO | |||
FS_CONDITIONPRIOR | Varchar2 | NO | NO | |||
FS_SEVERITY | Varchar2 | NO | NO | |||
FS_TAKENTO | Varchar2 | NO | NO | |||
FS_ACTIVITYATINJURY | Varchar2 | NO | NO | |||
FS_PRIMARYSYMPTOM | Varchar2 | NO | NO | |||
FS_PRIMARYBODYPART | Varchar2 | NO | NO | |||
FS_CAUSEOFINJURY | Varchar2 | NO | NO | |||
FS_CONTRIBUTINGFACTOR | Varchar2 | NO | NO | |||
FS_OBJECTINVOLVED | Varchar2 | NO | NO | |||
FS_WHEREOCCUR | Varchar2 | NO | NO | |||
FS_RELATIONTOSTRUCTURE | Varchar2 | NO | NO | |||
FS_STORIESFROMGRADE | Number | NO | NO | |||
FS_STORIESBELOWGRADE | Varchar2 | NO | NO | |||
FS_SPECIFICLOCATION | Varchar2 | NO | NO | |||
FS_VEHICLETYPE | Varchar2 | NO | NO | |||
FS_PROTEQUIPFACTOR | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003972 | Identifying | CAS_FIRESERVICE | CAS_EQUIP_FAIL | 1:N |
SYS_C003940 | Identifying | INCIDENTKEY | CAS_FIRESERVICE | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'CHANGE_LOG' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | LOGID | Number | YES | NO | ||
LOGDATE | Date | NO | NO | |||
USERNAME | Varchar2 | NO | NO | |||
FDIDSTATE | Varchar2 | NO | NO | |||
FK | ENTITYTYPE | Number | NO | NO | ||
FK | CHANGETYPE/LOGENTRYTYPE | Number | NO | NO | ||
SOURCEGROUPID | Number | NO | NO | |||
TARGETGROUPID | Number | NO | NO | |||
FROMDATE | Date | NO | NO | |||
TODATE | Date | NO | NO | |||
STATUS | Varchar2 | NO | NO | |||
DATAVERSION | Varchar2 | NO | NO | |||
INCIDENTNUMBER | Varchar2 | NO | NO | |||
EXPOSURENUMBER | Number | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
FK_CHANGELOGGROUP | Non-identifying | CHANGE_LOG | CHANGE_LOG_GROUP | 1:N |
FK_CHANGELOGINCIDENT | Non-identifying | CHANGE_LOG | CHANGE_LOG_INCIDENT | 1:N |
FK_CHANGELOGLOGENTRYTYPE | Non-identifying | CHANGE_LOG_CHANGE_TYPE | CHANGE_LOG | 1:N |
FK_CHANGELOGENTITYTYPE | Non-identifying | CHANGE_LOG_ENTITY_TYPE | CHANGE_LOG | 1:N |
![]() |
Name | Value |
Owner | NFIRS_LOGGING |
Tablespace for Primary key | INDX |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'CHANGE_LOG_CHANGE_TYPE' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | CHANGETYPE | Number | YES | NO | ||
DESCRIPTION | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
FK_CHANGELOGLOGENTRYTYPE | Non-identifying | CHANGE_LOG_CHANGE_TYPE | CHANGE_LOG | 1:N |
![]() |
Name | Value |
Owner | NFIRS_LOGGING |
Tablespace for Primary key | INDX |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'CHANGE_LOG_ENTITY_TYPE' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | ENTITYTYPE | Number | YES | NO | ||
DESCRIPTION | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
FK_CHANGELOGENTITYTYPE | Non-identifying | CHANGE_LOG_ENTITY_TYPE | CHANGE_LOG | 1:N |
FK_CHANGELOGGROUPENTITYTYPE | Non-identifying | CHANGE_LOG_ENTITY_TYPE | CHANGE_LOG_GROUP | 1:N |
![]() |
Name | Value |
Owner | NFIRS_LOGGING |
Tablespace for Primary key | INDX |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'CHANGE_LOG_GROUP' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
FK | LOGID | Number | NO | NO | ||
FK | ENTITYTYPE | Number | NO | NO | ||
GROUPID | Number | NO | NO | |||
GROUPORFDIDNAME | Varchar2 | NO | NO | |||
FDID | Varchar2 | NO | NO | |||
OLDPARENTGROUPID | Number | NO | NO | |||
OLDPARENTGROUPDESC | Varchar2 | NO | NO | |||
NEWPARENTGROUPID | Number | NO | NO | |||
NEWPARENTGROUPDESC | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
FK_CHANGELOGGROUP | Non-identifying | CHANGE_LOG | CHANGE_LOG_GROUP | 1:N |
FK_CHANGELOGGROUPENTITYTYPE | Non-identifying | CHANGE_LOG_ENTITY_TYPE | CHANGE_LOG_GROUP | 1:N |
![]() |
Name | Value |
Owner | NFIRS_LOGGING |
Tablespace for Primary key | |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'CHANGE_LOG_INCIDENT' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
FK | LOGID | Number | NO | NO | ||
FDID | Varchar2 | NO | NO | |||
INCIDENTNUMBER | Varchar2 | NO | NO | |||
EXPOSURENUMBER | Number | NO | NO | |||
INCIDENTALARMDATE | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
FK_CHANGELOGINCIDENT | Non-identifying | CHANGE_LOG | CHANGE_LOG_INCIDENT | 1:N |
![]() |
Name | Value |
Owner | NFIRS_LOGGING |
Tablespace for Primary key | |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'CHEMICAL' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | CHEMICALID | Varchar2 | YES | NO | ||
PFK | USERGROUPID | Number | YES | NO | ||
CHEMICALNAME | Varchar2 | NO | NO | |||
UN_NUMBER | Varchar2 | NO | NO | |||
CAS_NUMBER | Varchar2 | NO | NO | |||
CHEMICALSTATUS | Varchar2 | NO | NO | |||
LASTUPDATED | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003941 | Identifying | GROUPS | CHEMICAL | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'CODECATEGORY' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | CODECAT | Number | YES | NO | ||
FK | USERGROUPID | Number | NO | NO | ||
CODECATDESC | Varchar2 | NO | NO | |||
CODEGENERICLENGTH | Number | NO | NO | |||
CODECATSTATUS | Varchar2 | NO | NO | |||
LASTUPDATED | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003944 | Non-identifying | CODECATEGORY | ATTRCODEXREF | 1:N |
SYS_C003948 | Identifying | CODECATEGORY | ATTR_CODE | 1:N |
SYS_C003929 | Non-identifying | GROUPS | CODECATEGORY | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'EQUIP_INVOLVED' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
PK | EQ_RECTYPE | Varchar2 | YES | NO | ||
EQ_BRAND | Varchar2 | NO | NO | |||
EQ_MODEL | Varchar2 | NO | NO | |||
EQ_SERIALNUM | Varchar2 | NO | NO | |||
EQ_YEAR | Number(x,y) | NO | NO | |||
EQ_POWER | Varchar2 | NO | NO | |||
EQ_PORTABILITY | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003930 | Identifying | INCIDENTKEY | EQUIP_INVOLVED | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'EVENTMESSAGE' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | EVENTNUM | Number | YES | NO | ||
PFK | USERGROUPID | Number | YES | NO | ||
EVENTCLASS | Varchar2 | NO | NO | |||
EVENTCRIT | Number | NO | NO | |||
EVENTMSG | Varchar2 | NO | NO | |||
EVENTSTATUS | Varchar2 | NO | NO | |||
LASTUPDATED | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003931 | Identifying | GROUPS | EVENTMESSAGE | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'FD_APPARATUS' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | FDID | Varchar2 | YES | NO | ||
PFK | FDIDSTATE | Varchar2 | YES | NO | ||
PK | FD_APSEQ | Number | YES | NO | ||
FD_APID | Varchar2 | NO | NO | |||
FD_APTYPE | Varchar2 | NO | NO | |||
FD_APNAME | Varchar2 | NO | NO | |||
FD_APINSERVICEDATE | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003932 | Identifying | FD_HEADER | FD_APPARATUS | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'FD_APPARATUS_1025' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
FDID | Varchar2 | YES | NO | |||
FDIDSTATE | Varchar2 | YES | NO | |||
FD_APSEQ | Number | YES | NO | |||
FD_APID | Varchar2 | NO | NO | |||
FD_APTYPE | Varchar2 | NO | NO | |||
FD_APNAME | Varchar2 | NO | NO | |||
FD_APINSERVICEDATE | Date | NO | NO |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'FD_HEADER' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | FDID | Varchar2 | YES | NO | ||
PK | FDIDSTATE | Varchar2 | YES | NO | ||
FD_NAME | Varchar2 | NO | NO | |||
FD_STREETNUM | Varchar2 | NO | NO | |||
FD_STREETPREFIX | Varchar2 | NO | NO | |||
FD_STREETHIGHWAY | Varchar2 | NO | NO | |||
FD_STREETTYPE | Varchar2 | NO | NO | |||
FD_STREETSUFFIX | Varchar2 | NO | NO | |||
FD_CITY | Varchar2 | NO | NO | |||
FD_ZIP | Varchar2 | NO | NO | |||
FD_PHONE | Varchar2 | NO | NO | |||
FD_FAX | Varchar2 | NO | NO | |||
FD_EMAIL | Varchar2 | NO | NO | |||
FD_FIPSCOUNTYCODE | Varchar2 | NO | NO | |||
FD_NUMSTATIONS | Number | NO | NO | |||
FD_POPPROTECT | Float | NO | NO | |||
FD_POPDENSITY | Varchar2 | NO | NO | |||
FD_NUMPAIDFF | Number | NO | NO | |||
FD_NUMVOLFFPPC | Number | NO | NO | |||
FD_NUMVOLFF | Number | NO | NO | |||
FD_SQUAREMILES | Number | NO | NO | |||
FD_CURRENTINCIDENTSDATE | Date | NO | NO | |||
FD_VENDORID | Varchar2 | NO | NO | |||
FD_SOFTWAREID | Varchar2 | NO | NO | |||
FD_LASTUPDATED | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003932 | Identifying | FD_HEADER | FD_APPARATUS | 1:N |
SYS_C003933 | Identifying | FD_HEADER | FD_PERSONNEL | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'FD_HEADER_1025' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
FDID | Varchar2 | YES | NO | |||
FDIDSTATE | Varchar2 | YES | NO | |||
FD_NAME | Varchar2 | NO | NO | |||
FD_STREETNUM | Varchar2 | NO | NO | |||
FD_STREETPREFIX | Varchar2 | NO | NO | |||
FD_STREETHIGHWAY | Varchar2 | NO | NO | |||
FD_STREETTYPE | Varchar2 | NO | NO | |||
FD_STREETSUFFIX | Varchar2 | NO | NO | |||
FD_CITY | Varchar2 | NO | NO | |||
FD_ZIP | Varchar2 | NO | NO | |||
FD_PHONE | Varchar2 | NO | NO | |||
FD_FAX | Varchar2 | NO | NO | |||
FD_EMAIL | Varchar2 | NO | NO | |||
FD_FIPSCOUNTYCODE | Varchar2 | NO | NO | |||
FD_NUMSTATIONS | Number | NO | NO | |||
FD_POPPROTECT | Float | NO | NO | |||
FD_POPDENSITY | Varchar2 | NO | NO | |||
FD_NUMPAIDFF | Number | NO | NO | |||
FD_NUMVOLFFPPC | Number | NO | NO | |||
FD_NUMVOLFF | Number | NO | NO | |||
FD_SQUAREMILES | Number | NO | NO | |||
FD_CURRENTINCIDENTSDATE | Date | NO | NO | |||
FD_VENDORID | Varchar2 | NO | NO | |||
FD_SOFTWAREID | Varchar2 | NO | NO | |||
FD_LASTUPDATED | Date | NO | NO |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'FD_PERSONNEL' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | FDID | Varchar2 | YES | NO | ||
PFK | FDIDSTATE | Varchar2 | YES | NO | ||
PK | FD_PERSSEQ | Number | YES | NO | ||
FD_PERSID | Varchar2 | NO | NO | |||
FD_LNAME | Varchar2 | NO | NO | |||
FD_FNAME | Varchar2 | NO | NO | |||
FD_MI | Varchar2 | NO | NO | |||
FD_SUFFIX | Varchar2 | NO | NO | |||
FD_RANK | Varchar2 | NO | NO | |||
FD_PERSPHONE1 | Varchar2 | NO | NO | |||
FD_PERSPHONE2 | Varchar2 | NO | NO | |||
FD_PERSEMAIL | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003933 | Identifying | FD_HEADER | FD_PERSONNEL | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'FD_PERSONNEL_1025' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
FDID | Varchar2 | YES | NO | |||
FDIDSTATE | Varchar2 | YES | NO | |||
FD_PERSSEQ | Number | YES | NO | |||
FD_PERSID | Varchar2 | NO | NO | |||
FD_LNAME | Varchar2 | NO | NO | |||
FD_FNAME | Varchar2 | NO | NO | |||
FD_MI | Varchar2 | NO | NO | |||
FD_SUFFIX | Varchar2 | NO | NO | |||
FD_RANK | Varchar2 | NO | NO | |||
FD_PERSPHONE1 | Varchar2 | NO | NO | |||
FD_PERSPHONE2 | Varchar2 | NO | NO | |||
FD_PERSEMAIL | Varchar2 | NO | NO |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'FD_SOFTWARE' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | FDID | Varchar2 | YES | NO | ||
PK | FDID_STATE | Varchar2 | YES | NO | ||
PFK | VENDID | Varchar2 | YES | NO | ||
PFK | SOFTID | Varchar2 | YES | NO | ||
EFFECTDATE | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003934 | Identifying | VENDOR_SOFTWARE | FD_SOFTWARE | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'FIELDPERMS' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | FDID | Varchar2 | YES | NO | ||
PK | FDIDSTATE | Varchar2 | YES | NO | ||
PK | ATTRID | Number | YES | NO | ||
NATIONAL_VIS | Varchar2 | NO | NO | |||
STATE_VIS | Varchar2 | NO | NO | |||
FD_VIS | Varchar2 | NO | NO |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'FIRE_ALTADDR' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
FRW_TOWNSHIP | Number(x,y) | NO | NO | |||
FRW_TOWNSHIPDIR | Varchar2 | NO | NO | |||
FRW_RANGE | Number | NO | NO | |||
FRW_RANGEDIR | Varchar2 | NO | NO | |||
FRW_SECTION | Varchar2 | NO | NO | |||
FRW_SUBSECTION | Varchar2 | NO | NO | |||
FRW_MERIDIAN | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003935 | Identifying | FIRE_WILDLAND | FIRE_ALTADDR | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'FIRE_BEHAVIOR' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
FRW_ELEVATION | Number | NO | NO | |||
FRW_RELATIVEPOSITION | Varchar2 | NO | NO | |||
FRW_ASPECT | Varchar2 | NO | NO | |||
FRW_FLAMELENGTH | Number | NO | NO | |||
FRW_RATEOFSPREAD | Number | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003924 | Identifying | FIRE_WILDLAND | FIRE_BEHAVIOR | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'FIRE_LATLONG' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
FRW_LATITUDE | Number(x,y) | NO | NO | |||
FRW_LONGITUDE | Number(x,y) | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003925 | Identifying | FIRE_WILDLAND | FIRE_LATLONG | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'FIRE_PROPERTYMGMT' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
FRW_OWNERSHIP | Varchar2 | NO | NO | |||
FRW_UNDETERMINED | Number | NO | NO | |||
FRW_TAXPAYING | Number | NO | NO | |||
FRW_NONTAXPAYING | Number | NO | NO | |||
FRW_CITY | Number | NO | NO | |||
FRW_COUNTY | Number | NO | NO | |||
FRW_STATE | Number | NO | NO | |||
FRW_FEDERAL | Number | NO | NO | |||
FRW_FOREIGN | Number | NO | NO | |||
FRW_MILITARY | Number | NO | NO | |||
FRW_OTHER | Number | NO | NO | |||
FRW_FEDAGENCYCODE | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003971 | Identifying | INCIDENTKEY | FIRE_PROPERTYMGMT | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'FIRE_STRUCTURE' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
STR_TYPE | Varchar2 | NO | NO | |||
STR_STATUS | Varchar2 | NO | NO | |||
STR_FLOORSABOVE | Number | NO | NO | |||
STR_FLOORSBELOW | Number | NO | NO | |||
STR_BUILDINGLENGTH | Number | NO | NO | |||
STR_BUILDINGWIDTH | Number | NO | NO | |||
STR_TOTALSQFT | Float | NO | NO | |||
STR_FIREORIGIN | Number | NO | NO | |||
STR_FOBELOWGRADE | Varchar2 | NO | NO | |||
STR_FIRESPREAD | Varchar2 | NO | NO | |||
STR_MINORDAMAGE | Number | NO | NO | |||
STR_SIGDAMAGE | Number | NO | NO | |||
STR_HEAVYDAMAGE | Number | NO | NO | |||
STR_EXTREMEDAMAGE | Number | NO | NO | |||
STR_NOSPREAD | Varchar2 | NO | NO | |||
STR_ITEMTOSPREAD | Varchar2 | NO | NO | |||
STR_TYPETOSPREAD | Varchar2 | NO | NO | |||
STR_DETECTPRESENCE | Varchar2 | NO | NO | |||
STR_DETECTTYPE | Varchar2 | NO | NO | |||
STR_DETECTPOWER | Varchar2 | NO | NO | |||
STR_DETECTOPER | Varchar2 | NO | NO | |||
STR_DETECTEFFECT | Varchar2 | NO | NO | |||
STR_DETECTFAILURE | Varchar2 | NO | NO | |||
STR_AESPRESENCE | Varchar2 | NO | NO | |||
STR_AESTYPE | Varchar2 | NO | NO | |||
STR_NUMSPRINKLERS | Number | NO | NO | |||
STR_AESOPERATION | Varchar2 | NO | NO | |||
STR_AESFAILURE | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003926 | Identifying | INCIDENTKEY | FIRE_STRUCTURE | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'FIRE_WEATHER' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
FRW_WEATHERTYPE | Varchar2 | NO | NO | |||
FRW_WINDDIRECTION | Varchar2 | NO | NO | |||
FRW_WINDSPEED | Number | NO | NO | |||
FRW_AIRTEMP | Number | NO | NO | |||
FRW_RELATIVEHUMIDITY | Number | NO | NO | |||
FRW_FUELMOISTURE | Number | NO | NO | |||
FRW_DANGERRATING | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003927 | Identifying | FIRE_WILDLAND | FIRE_WEATHER | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'FIRE_WILDLAND' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
FRW_AREATYPE | Varchar2 | NO | NO | |||
FRW_FIRECAUSE | Varchar2 | NO | NO | |||
FRW_HEATSOURCE | Varchar2 | NO | NO | |||
FRW_MOBILEPROPTYPE | Varchar2 | NO | NO | |||
FRW_EQUIPMENTINV | Varchar2 | NO | NO | |||
FRW_NFDRSSTATION | Varchar2 | NO | NO | |||
FRW_NUMBUILDINGS | Number | NO | NO | |||
FRW_NUMTHREATENED | Number | NO | NO | |||
FRW_TOTALACRES | Float | NO | NO | |||
FRW_PRIMARYCROP1 | Varchar2 | NO | NO | |||
FRW_PRIMARYCROP2 | Varchar2 | NO | NO | |||
FRW_PRIMARYCROP3 | Varchar2 | NO | NO | |||
FRW_FUELMODEL | Varchar2 | NO | NO | |||
FRW_PERSONRESPONSIBLE | Varchar2 | NO | NO | |||
FRW_GENDER | Varchar2 | NO | NO | |||
FRW_AGE | Number | NO | NO | |||
FRW_ACTIVITY | Varchar2 | NO | NO | |||
FRW_ROWFEET | Number | NO | NO | |||
FRW_ROWTYPE | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003935 | Identifying | FIRE_WILDLAND | FIRE_ALTADDR | 1:N |
SYS_C003924 | Identifying | FIRE_WILDLAND | FIRE_BEHAVIOR | 1:N |
SYS_C003925 | Identifying | FIRE_WILDLAND | FIRE_LATLONG | 1:N |
SYS_C003927 | Identifying | FIRE_WILDLAND | FIRE_WEATHER | 1:N |
SYS_C003928 | Identifying | INCIDENTKEY | FIRE_WILDLAND | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'FIX_41' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
INCIDENTID | Number | NO | NO |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'GROUP_FLATFILE' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | USERGROUPID | Number | YES | NO | ||
PATH | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003968 | Identifying | GROUPS | GROUP_FLATFILE | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'GROUP_VERSIONS' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
USERGROUPID | Number | NO | NO | |||
VERSION | Varchar2 | NO | NO | |||
PATH | Varchar2 | NO | NO |
![]() |
Name | Value |
Owner | NFIRS50V3 |
Tablespace for Primary key | |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'GROUPS' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | USERGROUPID | Number | YES | NO | ||
USERSTATE | Varchar2 | NO | NO | |||
USERFDID | Varchar2 | NO | NO | |||
USERGROUPPARENTID | Number | YES | NO | |||
USERGROUPDESC | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003942 | Identifying | GROUPS | APPACTION | 1:N |
SYS_C003943 | Identifying | GROUPS | APPRULE | 1:N |
SYS_C003946 | Identifying | GROUPS | ATTRIBUTE | 1:N |
SYS_C003949 | Identifying | GROUPS | ATTR_CODE | 1:N |
SYS_C003941 | Identifying | GROUPS | CHEMICAL | 1:N |
SYS_C003929 | Non-identifying | GROUPS | CODECATEGORY | 1:N |
SYS_C003931 | Identifying | GROUPS | EVENTMESSAGE | 1:N |
SYS_C003968 | Identifying | GROUPS | GROUP_FLATFILE | 1:N |
SYS_C003955 | Identifying | GROUPS | IN_TEMPLATEHEADER | 1:N |
SYS_C003957 | Identifying | GROUPS | NFIRSTRANSACTION | 1:N |
SYS_C003958 | Non-identifying | GROUPS | NFIRSUSER | 1:N |
SYS_C003959 | Identifying | GROUPS | SPECIAL_STUDY | 1:N |
SYS_C003964 | Identifying | GROUPS | USERCOMPRQMTXREF | 1:N |
SYS_C003967 | Identifying | GROUPS | WINDOW | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'IN_ADDRESS' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
IN_CENSUSTRACT | Varchar2 | NO | NO | |||
IN_LOCATIONTYPE | Varchar2 | NO | NO | |||
IN_NUMORMILE | Varchar2 | NO | NO | |||
IN_PREFIX | Varchar2 | NO | NO | |||
IN_STREETHIGHWAY | Varchar2 | NO | NO | |||
IN_STREETTYPE | Varchar2 | NO | NO | |||
IN_SUFFIX | Varchar2 | NO | NO | |||
IN_APT | Varchar2 | NO | NO | |||
IN_CITY | Varchar2 | NO | NO | |||
IN_STATE | Varchar2 | NO | NO | |||
IN_ZIP | Varchar2 | NO | NO | |||
IN_DIRECTIONS | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003918 | Identifying | IN_BASIC | IN_ADDRESS | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'IN_APPARATUS' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
PK | AP_SEQ | Number | YES | NO | ||
APID | Varchar2 | NO | NO | |||
AP_TYPE | Varchar2 | NO | NO | |||
AP_DISPATCHDATE | Date | NO | NO | |||
AP_ARRIVALDATE | Date | NO | NO | |||
AP_CLEARDATE | Date | NO | NO | |||
AP_NUMPEOPLE | Number | NO | NO | |||
AP_USE | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003970 | Identifying | INCIDENTKEY | IN_APPARATUS | 1:N |
SYS_C003952 | Identifying | IN_APPARATUS | IN_PERSONNEL | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'IN_ARSON' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
AR_CASESTATUS | Varchar2 | NO | NO | |||
AR_IGNITIONAVAIL | Varchar2 | NO | NO | |||
AR_ENTRYMETHOD | Varchar2 | NO | NO | |||
AR_EXTENTOFFIREINV | Varchar2 | NO | NO | |||
AR_CONTAINER | Varchar2 | NO | NO | |||
AR_DELAYDEVICE | Varchar2 | NO | NO | |||
AR_FUEL | Varchar2 | NO | NO | |||
AR_PROPERTYOWNERSHIP | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003919 | Identifying | INCIDENTKEY | IN_ARSON | 1:N |
SYS_C003920 | Identifying | IN_ARSON | IN_ARSONAGENCYXREF | 1:N |
SYS_C003921 | Identifying | IN_ARSON | IN_ARSONJUVENILE | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'IN_ARSONAGENCYXREF' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
AR_AGENCYNAME | Varchar2 | NO | NO | |||
AR_STREETNUMBER | Varchar2 | NO | NO | |||
AR_STREETPREFIX | Varchar2 | NO | NO | |||
AR_STREET | Varchar2 | NO | NO | |||
AR_STREETTYPE | Varchar2 | NO | NO | |||
AR_APT | Varchar2 | NO | NO | |||
AR_STREETSUFFIX | Varchar2 | NO | NO | |||
AR_CITY | Varchar2 | NO | NO | |||
AR_STATE | Varchar2 | NO | NO | |||
AR_ZIP | Varchar2 | NO | NO | |||
AR_PHONE | Varchar2 | NO | NO | |||
AR_CASENUMBER | Varchar2 | NO | NO | |||
AR_ORI | Varchar2 | NO | NO | |||
AR_FID | Varchar2 | NO | NO | |||
AR_FDID | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003920 | Identifying | IN_ARSON | IN_ARSONAGENCYXREF | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'IN_ARSONJUVENILE' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
PK | AR_SUBJECT | Number | YES | NO | ||
AR_AGE | Number | NO | NO | |||
AR_GENDER | Varchar2 | NO | NO | |||
AR_RACE | Varchar2 | NO | NO | |||
AR_ETHNICITY | Varchar2 | NO | NO | |||
AR_FAMILYTYPE | Varchar2 | NO | NO | |||
AR_DISPOSITION | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003921 | Identifying | IN_ARSON | IN_ARSONJUVENILE | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'IN_AUTHORITY' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
PK | AUTHTYPE | Varchar2 | YES | NO | ||
IN_AUTHPERSONNELID | Varchar2 | NO | NO | |||
IN_AUTHLNAME | Varchar2 | NO | NO | |||
IN_AUTHFNAME | Varchar2 | NO | NO | |||
IN_AUTHMI | Varchar2 | NO | NO | |||
IN_AUTHRANK | Varchar2 | NO | NO | |||
IN_AUTHASSIGNMENT | Varchar2 | NO | NO | |||
IN_AUTHDATE | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003922 | Identifying | IN_BASIC | IN_AUTHORITY | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'IN_BASIC' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
IN_TYPE | Varchar2 | NO | NO | |||
IN_ADDRONWILDLAND | Varchar2 | NO | NO | |||
IN_MUTUALAIDFLAG | Varchar2 | NO | NO | |||
IN_ALARMDATE | Date | NO | NO | |||
IN_ARRIVALDATE | Date | NO | NO | |||
IN_CONTROLLEDDATE | Date | NO | NO | |||
IN_LASTUNITCLEAREDDATE | Date | NO | NO | |||
IN_SHIFT | Varchar2 | NO | NO | |||
IN_ALARMS | Varchar2 | NO | NO | |||
IN_DISTRICT | Varchar2 | NO | NO | |||
IN_RESOURCEFORMUSED | Varchar2 | NO | NO | |||
IN_APPARSUPP | Number | NO | NO | |||
IN_APPAREMS | Number | NO | NO | |||
IN_APPAROTHER | Number | NO | NO | |||
IN_PERSSUPP | Number | NO | NO | |||
IN_PERSEMS | Number | NO | NO | |||
IN_PERSOTHER | Number | NO | NO | |||
IN_INCMUTAID | Varchar2 | NO | NO | |||
IN_LOSSPROPERTY | Number | NO | NO | |||
IN_LOSSOTHER | Number | NO | NO | |||
IN_LOSSTOTAL | Number | NO | NO | |||
IN_VALUEPROPERTY | Number | NO | NO | |||
IN_VALUEOTHER | Number | NO | NO | |||
IN_FATALFS | Number | NO | NO | |||
IN_FATALOTHER | Number | NO | NO | |||
IN_NONFATALFS | Number | NO | NO | |||
IN_NONFATALOTHER | Number | NO | NO | |||
IN_DETECTOR | Varchar2 | NO | NO | |||
IN_HAZMATRELEASED | Varchar2 | NO | NO | |||
IN_MIXEDUSE | Varchar2 | NO | NO | |||
IN_PROPERTYUSE | Varchar2 | NO | NO | |||
IN_FIRECAUSE | Varchar2 | NO | NO | |||
IN_FATALEMS | Number | NO | NO | |||
IN_NONFATALEMS | Number | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003923 | Identifying | INCIDENTKEY | IN_BASIC | 1:N |
SYS_C003918 | Identifying | IN_BASIC | IN_ADDRESS | 1:N |
SYS_C003922 | Identifying | IN_BASIC | IN_AUTHORITY | 1:N |
SYS_C003916 | Identifying | IN_BASIC | IN_MUTUALAID | 1:N |
SYS_C003917 | Identifying | IN_BASIC | IN_OWNERPERSON | 1:N |
SYS_C003953 | Identifying | IN_BASIC | IN_SPECIALSTUDY | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'IN_BASIC41' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
IN_METHODOFALARM | Varchar2 | NO | NO | |||
IN_METHODOFEXTINGUISH | Varchar2 | NO | NO | |||
IN_CONSTRUCTIONTYPE | Varchar2 | NO | NO | |||
IN_EXTENTSMOKEDAMAGE | Varchar2 | NO | NO | |||
IN_TYPEMATERIALGENSMOKE | Varchar2 | NO | NO | |||
IN_FORMMATERIALGENSMOKE | Varchar2 | NO | NO | |||
IN_AVENUEOFSMOKE | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003912 | Identifying | INCIDENTKEY | IN_BASIC41 | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'IN_FIRE' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
FR_NUMBUILDINGS | Number | NO | NO | |||
FR_NUMRESIDENTIAL | Number | NO | NO | |||
FR_NOTRESIDENTIAL | Varchar2 | NO | NO | |||
FR_ACRESBURNED | Number | NO | NO | |||
FR_LESSTHANONEACRE | Varchar2 | NO | NO | |||
FR_AREAOFORIGIN | Varchar2 | NO | NO | |||
FR_HEATSOURCE | Varchar2 | NO | NO | |||
FR_ITEMFIRSTIGNITED | Varchar2 | NO | NO | |||
FR_CONFINEDTOORIGIN | Varchar2 | NO | NO | |||
FR_TYPEOFMATERIAL | Varchar2 | NO | NO | |||
FR_CAUSEOFIGNITION | Varchar2 | NO | NO | |||
FR_AGEOFPERSON | Number | NO | NO | |||
FR_SEXOFPERSON | Varchar2 | NO | NO | |||
FR_EQUIPMENTINV | Varchar2 | NO | NO | |||
FR_MOBILEPROPINV | Varchar2 | NO | NO | |||
FR_PREFIREPLAN | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003913 | Identifying | INCIDENTKEY | IN_FIRE | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'IN_FIRECAUSE' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | INCIDENTID | Number | YES | NO | ||
IN_PCCCODE | Varchar2 | NO | NO | |||
IN_CAUSECODE | Varchar2 | NO | NO | |||
IN_ARSONCODE | Varchar2 | NO | NO |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'IN_FIRECAUSE_RECODE' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | INCIDENTID | Number | YES | NO | ||
IN_PCCCODE | Varchar2 | NO | NO | |||
IN_CAUSECODE | Varchar2 | NO | NO | |||
IN_ARSONCODE | Varchar2 | NO | NO |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'IN_HAZMAT' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
HM_RELATIONTOSTRUCTURE | Varchar2 | NO | NO | |||
HM_FLOOROFRELEASE | Number | NO | NO | |||
HM_FLOORBELOWGRADE | Varchar2 | NO | NO | |||
HM_POPULATIONDENSITY | Varchar2 | NO | NO | |||
HM_AREAAFFECTED | Number | NO | NO | |||
HM_AREAAFFECTEDUNITS | Varchar2 | NO | NO | |||
HM_AREAEVACUATED | Number | NO | NO | |||
HM_AREAEVACUATEDUNITS | Varchar2 | NO | NO | |||
HM_PEOPLEEVACUATED | Number | NO | NO | |||
HM_BUILDINGSEVACUATED | Number | NO | NO | |||
HM_RELEASEFIRST | Varchar2 | NO | NO | |||
HM_CAUSEOFRELEASE | Varchar2 | NO | NO | |||
HM_EQUIPINV | Varchar2 | NO | NO | |||
HM_DISPOSITION | Varchar2 | NO | NO | |||
HM_CIVILIANDEATHS | Number | NO | NO | |||
HM_CIVILIANINJURIES | Number | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003914 | Identifying | INCIDENTKEY | IN_HAZMAT | 1:N |
SYS_C003915 | Identifying | IN_HAZMAT | IN_HMCHEMICAL | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'IN_HMCHEMICAL' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
PK | HM_NUM | Number | YES | NO | ||
HM_DOTID | Varchar2 | NO | NO | |||
HM_HAZARDCLASS | Varchar2 | NO | NO | |||
HM_CAS_REGISTRATION | Varchar2 | NO | NO | |||
HM_CHEMICALNAME | Varchar2 | NO | NO | |||
HM_CHEMICALID | Varchar2 | NO | NO | |||
HM_CONTAINERTYPE | Varchar2 | NO | NO | |||
HM_CONTAINERCAPACITY | Float | NO | NO | |||
HM_CONTAINERUNITS | Varchar2 | NO | NO | |||
HM_RELEASED | Float | NO | NO | |||
HM_RELEASEDUNITS | Varchar2 | NO | NO | |||
HM_STATEWHENRELEASED | Varchar2 | NO | NO | |||
HM_RELINTO | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003915 | Identifying | IN_HAZMAT | IN_HMCHEMICAL | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'IN_MULTIPLECODE' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
PK | ATTRID | Number | YES | NO | ||
PK | ATTRMAININDEX | Number | YES | NO | ||
PK | ATTRSUBINDEX | Number | YES | NO | ||
PK | ATTRSEQ | Number | YES | NO | ||
CODEVALUE | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003969 | Identifying | INCIDENTKEY | IN_MULTIPLECODE | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'IN_MUTUALAID' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
IN_ASSISTFDID | Varchar2 | NO | NO | |||
IN_ASSISTFDIDSTATE | Varchar2 | NO | NO | |||
IN_ASSISTINCIDENT | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003916 | Identifying | IN_BASIC | IN_MUTUALAID | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'IN_OWNERPERSON' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
PK | ADDRTYPE | Varchar2 | YES | NO | ||
PK | ADDRSEQ | Number | YES | NO | ||
OP_NAMEPREFIX | Varchar2 | NO | NO | |||
OP_FNAME | Varchar2 | NO | NO | |||
OP_MI | Varchar2 | NO | NO | |||
OP_LNAME | Varchar2 | NO | NO | |||
OP_NAMESUFFIX | Varchar2 | NO | NO | |||
OP_BUSINESSNAME | Varchar2 | NO | NO | |||
OP_PHONE | Varchar2 | NO | NO | |||
OP_NUMORMILE | Varchar2 | NO | NO | |||
OP_PREFIX | Varchar2 | NO | NO | |||
OP_STREETHIGHWAY | Varchar2 | NO | NO | |||
OP_STREETTYPE | Varchar2 | NO | NO | |||
OP_SUFFIX | Varchar2 | NO | NO | |||
OP_POBOX | Varchar2 | NO | NO | |||
OP_APT | Varchar2 | NO | NO | |||
OP_CITY | Varchar2 | NO | NO | |||
OP_STATE | Varchar2 | NO | NO | |||
OP_ZIP | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003917 | Identifying | IN_BASIC | IN_OWNERPERSON | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'IN_PERSONNEL' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
PFK | AP_SEQ | Number | YES | NO | ||
PK | PR_SEQ | Number | YES | NO | ||
PR_PERSID | Varchar2 | NO | NO | |||
PR_LNAME | Varchar2 | NO | NO | |||
PR_FNAME | Varchar2 | NO | NO | |||
PR_MI | Varchar2 | NO | NO | |||
PR_RANK | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003952 | Identifying | IN_APPARATUS | IN_PERSONNEL | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'IN_SPECIALSTUDY' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
PK | SS_SEQ | Number | YES | NO | ||
PK | SPECIALSTUDYID | Number | YES | NO | ||
SS_CODEVALUE | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003953 | Identifying | IN_BASIC | IN_SPECIALSTUDY | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'IN_TEMPLATEDETAIL' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | TEMPLATEID | Number | YES | NO | ||
PFK | USERGROUPID | Number | YES | NO | ||
PK | TEMPLATESEQ | Number | YES | NO | ||
TEMPLATETRANSID | Number | NO | NO | |||
TEMPLATEDETAIL | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003954 | Identifying | IN_TEMPLATEHEADER | IN_TEMPLATEDETAIL | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'IN_TEMPLATEHEADER' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | TEMPLATEID | Number | YES | NO | ||
PFK | USERGROUPID | Number | YES | NO | ||
TEMPLATENAME | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003955 | Identifying | GROUPS | IN_TEMPLATEHEADER | 1:N |
SYS_C003954 | Identifying | IN_TEMPLATEHEADER | IN_TEMPLATEDETAIL | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'INC_ACTION' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | INCIDENTID | Number | YES | NO |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'INCIDENTKEY' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | INCIDENTID | Number | YES | NO | ||
IN_RELEASE | Varchar2 | NO | NO | |||
IN_STATUS | Varchar2 | NO | NO | |||
FDID | Varchar2 | NO | NO | |||
FDIDSTATE | Varchar2 | NO | NO | |||
IN_DATE | Date | NO | NO | |||
IN_NUM | Varchar2 | NO | NO | |||
IN_EXPOSURE | Number | NO | NO | |||
IN_STATION | Varchar2 | NO | NO | |||
IN_NFIRSVERSION | Varchar2 | NO | NO | |||
IN_VENDORID | Varchar2 | NO | NO | |||
IN_SOFTWAREID | Varchar2 | NO | NO | |||
IN_LASTUPDATED | Date | NO | NO | |||
IN_LASTUPDATEDBY | Varchar2 | NO | NO | |||
IN_CREATED | Date | NO | NO | |||
IN_CREATEDBY | Varchar2 | NO | NO | |||
IN_NFIRSLOADVERSION | Varchar2 | NO | NO | |||
IN_LASTEXPORTED | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003938 | Identifying | INCIDENTKEY | CAS_CIVILIAN | 1:N |
SYS_C003939 | Identifying | INCIDENTKEY | CAS_EMS | 1:N |
SYS_C003940 | Identifying | INCIDENTKEY | CAS_FIRESERVICE | 1:N |
SYS_C003930 | Identifying | INCIDENTKEY | EQUIP_INVOLVED | 1:N |
SYS_C003971 | Identifying | INCIDENTKEY | FIRE_PROPERTYMGMT | 1:N |
SYS_C003926 | Identifying | INCIDENTKEY | FIRE_STRUCTURE | 1:N |
SYS_C003928 | Identifying | INCIDENTKEY | FIRE_WILDLAND | 1:N |
SYS_C003970 | Identifying | INCIDENTKEY | IN_APPARATUS | 1:N |
SYS_C003919 | Identifying | INCIDENTKEY | IN_ARSON | 1:N |
SYS_C003923 | Identifying | INCIDENTKEY | IN_BASIC | 1:N |
SYS_C003912 | Identifying | INCIDENTKEY | IN_BASIC41 | 1:N |
SYS_C003913 | Identifying | INCIDENTKEY | IN_FIRE | 1:N |
SYS_C003914 | Identifying | INCIDENTKEY | IN_HAZMAT | 1:N |
SYS_C003969 | Identifying | INCIDENTKEY | IN_MULTIPLECODE | 1:N |
SYS_C003956 | Identifying | INCIDENTKEY | MOBILE_PROP | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'INSTANCE' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
INSTANCEID | Number | NO | NO | |||
REPORT_SHELL | Number | NO | NO | |||
DESCRIPTION | Varchar2 | NO | NO | |||
QUEUE_TIME | Float | NO | NO | |||
START_TIME | Float | NO | NO | |||
END_TIME | Float | NO | NO | |||
STATUS | Varchar2 | NO | NO | |||
USERGROUPID_CREATOR | Number | NO | NO | |||
USERNAME_CREATOR | Varchar2 | NO | NO | |||
USERSTATE_CREATOR | Varchar2 | NO | NO | |||
SAVE | Varchar2 | NO | NO | |||
VISABILITY_CODE | Varchar2 | NO | NO | |||
REMARKS | Varchar2 | NO | NO | |||
OUTPUT_TYPE | Varchar2 | NO | NO |
![]() |
Name | Value |
Owner | NFIRS50V3 |
Tablespace for Primary key | |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'INSTANCE_DETAIL' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
INSTANCEID | Number | NO | NO | |||
SEQUENCE | Number(x,y) | NO | NO | |||
LOGICAL_OPERATOR | Varchar2 | NO | NO | |||
ATTRID | Number | NO | NO | |||
RELATIONAL_OPERATOR | Varchar2 | NO | NO | |||
VALUE | Varchar2 | NO | NO |
![]() |
Name | Value |
Owner | NFIRS50V3 |
Tablespace for Primary key | |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'LOOKUP_NEXT_PK' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | TABLENAME | Varchar2 | YES | NO | ||
PK | USERGROUPID | Number | YES | NO | ||
NEXTPRIMARYKEY | Number | NO | NO | |||
MAXKEYVALUE | Number | NO | NO |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'MOBILE_PROP' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | INCIDENTID | Number | YES | NO | ||
PK | MP_RECTYPE | Varchar2 | YES | NO | ||
MP_TYPE | Varchar2 | NO | NO | |||
MP_MAKE | Varchar2 | NO | NO | |||
MP_MODEL | Varchar2 | NO | NO | |||
MP_YEAR | Number(x,y) | NO | NO | |||
MP_VIN | Varchar2 | NO | NO | |||
MP_LICENSEPLATE | Varchar2 | NO | NO | |||
MP_STATE | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003956 | Identifying | INCIDENTKEY | MOBILE_PROP | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'NFIC_REGION' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | REGIONSTATE | Varchar2 | YES | NO | ||
REGIONID | Varchar2 | YES | NO |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'NFIRSTRANSACTION' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | TRANSID | Number | YES | NO | ||
PFK | USERGROUPID | Number | YES | NO | ||
TRANSTYPE | Number | YES | NO | |||
EXTERNALTRANSID | Number | NO | NO | |||
TRANSDESC | Varchar2 | NO | NO | |||
PARENTTRANS | Number | NO | NO | |||
TRANSINDEX | Varchar2 | NO | NO | |||
EMPTYASBLANK | Varchar2 | NO | NO | |||
TRANSACTIONSTATUS | Varchar2 | NO | NO | |||
LASTUPDATED | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003957 | Identifying | GROUPS | NFIRSTRANSACTION | 1:N |
SYS_C003961 | Identifying | NFIRSTRANSACTION | TRANSCONVERT | 1:N |
SYS_C003962 | Identifying | NFIRSTRANSACTION | TRANSDELIMATTR | 1:N |
SYS_C003963 | Identifying | NFIRSTRANSACTION | TRANSFIXEDATTR | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'NFIRSUSER' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | USERNAME | Varchar2 | YES | NO | ||
PK | USERSTATE | Varchar2 | YES | NO | ||
USERPASSWORD | Varchar2 | NO | NO | |||
USERSTATUS | Varchar2 | NO | NO | |||
FK | USERGROUPID | Number | NO | NO | ||
USERLNAME | Varchar2 | NO | NO | |||
USERFNAME | Varchar2 | NO | NO | |||
USERMI | Varchar2 | NO | NO | |||
USEREMAIL | Varchar2 | NO | NO | |||
USERPHONE | Varchar2 | NO | NO | |||
USERNUMBADLOGIN | Number | NO | NO | |||
USERLASTLOGINDATE | Date | NO | NO | |||
USERLASTPWDATE | Date | NO | NO | |||
USERMUSTCHANGEPW | Varchar2 | YES | NO | |||
USERPERMISSIONS | Varchar2 | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003958 | Non-identifying | GROUPS | NFIRSUSER | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'RESULT_STAGE' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
INSTANCEID | Number | NO | NO | |||
ROW_NUM | Number | NO | NO | |||
DELIMITED_STRING | Varchar2 | NO | NO | |||
ROW_TYPE | Number | NO | NO |
![]() |
Name | Value |
Owner | NFIRS50V3 |
Tablespace for Primary key | |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'RESULTS' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
INSTANCEID | Number(x,y) | NO | NO | |||
ROW_NUM | Number(x,y) | NO | NO | |||
ROW_TYPE | Varchar2 | NO | NO | |||
DELIMITED_STRING | Varchar2 | NO | NO | |||
DELIMETER | Varchar2 | NO | NO |
![]() |
Name | Value |
Owner | NFIRS50V3 |
Tablespace for Primary key | |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'SPECIAL_STUDY' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | SS_ID | Number | YES | NO | ||
PFK | USERGROUPID | Number | YES | NO | ||
SS_DESCRIPTION | Varchar2 | NO | NO | |||
SS_STARTDATE | Date | NO | NO | |||
SS_STOPDATE | Date | NO | NO | |||
SS_CODEGENERICLENGTH | Number | NO | NO | |||
SS_STATUS | Varchar2 | NO | NO | |||
LASTUPDATED | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003959 | Identifying | GROUPS | SPECIAL_STUDY | 1:N |
SYS_C003960 | Identifying | SPECIAL_STUDY | SS_CODE | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'SS_CODE' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | SS_ID | Number | YES | NO | ||
PK | SS_CODE | Varchar2 | YES | NO | ||
PFK | USERGROUPID | Number | YES | NO | ||
SS_PARENTCODEVALUE | Varchar2 | NO | NO | |||
SS_DECODE | Varchar2 | NO | NO | |||
SS_CODESTATUS | Varchar2 | NO | NO | |||
LASTUPDATED | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003960 | Identifying | SPECIAL_STUDY | SS_CODE | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'STAGINGAREA' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | INCIDENTID | Number | YES | NO | ||
PK | RPTID | Number | YES | NO |
![]() |
Name | Value |
Owner | NFIRS50V3 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'TEMPLATE' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
TEMPLATEID | Number(x,y) | NO | NO | |||
DESCRIPTION | Varchar2 | NO | NO | |||
USERGROUPID_CREATOR | Number | NO | NO | |||
LAST_UPDATE | Date | NO | NO | |||
STATIC | Varchar2 | NO | NO | |||
USERNAME_CREATOR | Varchar2 | NO | NO | |||
USERSTATE_CREATOR | Varchar2 | NO | NO | |||
VISABILITY_CODE | Varchar2 | NO | NO |
![]() |
Name | Value |
Owner | NFIRS50V3 |
Tablespace for Primary key | |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'TEMPLATE_DETAIL' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
TEMPLATEID | Number | NO | NO | |||
SEQUENCE | Number(x,y) | NO | NO | |||
STATIC | Varchar2 | NO | NO | |||
LOGICAL_OPERATOR | Varchar2 | NO | NO | |||
ATTRID | Number(x,y) | NO | NO | |||
RELATIONAL_OPERATOR | Varchar2 | NO | NO | |||
VALUE | Varchar2 | NO | NO |
![]() |
Name | Value |
Owner | NFIRS50V3 |
Tablespace for Primary key | |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'TRANSCONVERT' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | TRANSID/TRANSIDOLD | Number | YES | NO | ||
PFK | USERGROUPID | Number | YES | NO | ||
TRANSIDNEW | Number | NO | NO | |||
STATUS | Varchar2 | NO | NO | |||
LASTUPDATED | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003961 | Identifying | NFIRSTRANSACTION | TRANSCONVERT | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'TRANSDELIMATTR' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | TRANSID | Number | YES | NO | ||
PFK | USERGROUPID | Number | YES | NO | ||
PK | TRANSSEQ | Number | YES | NO | ||
PK | SUBTRANSEQ | Number | YES | NO | ||
ATTRID | Number | YES | NO | |||
KEYATTR | Varchar2 | NO | NO | |||
SUBTRANSSTATUS | Varchar2 | NO | NO | |||
LASTUPDATED | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003962 | Identifying | NFIRSTRANSACTION | TRANSDELIMATTR | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'TRANSFIXEDATTR' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | TRANSID | Number | YES | NO | ||
PFK | USERGROUPID | Number | YES | NO | ||
PK | TRANSSEQ | Number | YES | NO | ||
ATTRID | Number | NO | NO | |||
KEYATTR | Varchar2 | NO | NO | |||
STARTPOS | Number | NO | NO | |||
STOPPOS | Number | NO | NO | |||
SUBTRANSSTATUS | Varchar2 | NO | NO | |||
LASTUPDATED | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003963 | Identifying | NFIRSTRANSACTION | TRANSFIXEDATTR | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'USERCOMPRQMTXREF' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | ATTRID | Number | YES | NO | ||
PFK | USERGROUPID | Number | YES | NO | ||
REQUIREMENTID | Number | NO | NO | |||
COMPREQSTATUS | Varchar2 | NO | NO | |||
LASTUPDATED | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003964 | Identifying | GROUPS | USERCOMPRQMTXREF | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'USERCOMPSECXREF' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | ATTRID | Number | YES | NO | ||
PFK | USERGROUPID | Number | YES | NO | ||
SECURITYID | Number | NO | NO | |||
COMPSECSTATUS | Varchar2 | NO | NO | |||
LASTUPDATED | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003965 | Identifying | ATTRIBUTE | USERCOMPSECXREF | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'VENDOR' |
![]() |
Entity type: | independent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | VENDID | Varchar2 | YES | NO | ||
VENDNAME | Varchar2 | NO | NO | |||
VENDPASSWORD | Varchar2 | YES | NO | |||
VENDADDR1 | Varchar2 | NO | NO | |||
VENDADDR2 | Varchar2 | NO | NO | |||
VENDCITY | Varchar2 | NO | NO | |||
VENDST | Varchar2 | NO | NO | |||
VENDZIP | Varchar2 | NO | NO | |||
VENDPHONE | Varchar2 | NO | NO | |||
VENDFAX | Varchar2 | NO | NO | |||
VENDWWW | Varchar2 | NO | NO | |||
VENDEMAIL | Varchar2 | NO | NO | |||
VENDADDRVERDATE | Date | NO | NO | |||
VENDSTATUS | Varchar2 | NO | NO | |||
VENDLASTUPDATED | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003966 | Identifying | VENDOR | VENDOR_SOFTWARE | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'VENDOR_SOFTWARE' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PFK | VENDID | Varchar2 | YES | NO | ||
PK | SOFTID | Varchar2 | YES | NO | ||
SOFTWARE_NAME | Varchar2 | NO | NO | |||
SOFTWARE_VERSION | Varchar2 | NO | NO | |||
NFIRSVERSION | Varchar2 | NO | NO | |||
CERTIFICATIONDATE | Date | NO | NO | |||
COMMENTS | Varchar2 | NO | NO | |||
STATUS | Varchar2 | NO | NO | |||
LASTUPDATED | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003966 | Identifying | VENDOR | VENDOR_SOFTWARE | 1:N |
SYS_C003934 | Identifying | VENDOR_SOFTWARE | FD_SOFTWARE | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |
Entity 'WINDOW' |
![]() |
Entity type: | dependent |
![]() |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | WINDOWID | Number | YES | NO | ||
PFK | USERGROUPID | Number | YES | NO | ||
WINDOWDESC | Varchar2 | NO | NO | |||
WINDOWSTATUS | Varchar2 | NO | NO | |||
LASTUPDATED | Date | NO | NO |
![]() |
Relationship name | Type | Parent entity | Child entity | Card. |
SYS_C003967 | Identifying | GROUPS | WINDOW | 1:N |
![]() |
Name | Value |
Owner | NFIRS50 |
Tablespace for Primary key | NFIRS_DATA |
Primary Key Deferrable | No |
Primary Key Initially Deferred | No |
Tablespace for Table |