Table slot9.WORLD.TSTA.USER_SCREEN_INSTANCES
This table stores instances of a custom form created by a user in the application
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
INSTANCE_ID number 38
USER_FIELD_INSTANCES.SCREEN_INSTANCE_ID USRSCRN_FINST_USRSCRNINS_FK R
USER_FIELD_SUB_INST_VALUES.SUB_INSTANCE_ID UFSIV_USRSCRN_INST_FK R
USER_SCREEN_AUDIT_LOG.INSTANCE_ID USAL_USRSCRN_INST_FK R
USER_SCREEN_COMMENTS.SCREEN_INSTANCE_ID USRSCRN_COM_USRSCRN_INST_FK R
USER_SCREEN_INST_ROUTES.SCREEN_INSTANCE_ID USRSCRTI_USRSCRN_INST_FK R
USI_ATTACHMENTS.INSTANCE_ID USIATT_USRSCRN_INST_FK C
USI_CASE_ACTIVITIES.INSTANCE_ID USI_CACT_USRSCRN_INST_FK R
USI_CASE_ACTIVITY_FIELDS.INSTANCE_ID USICASACTFLD_USRSCRN_INST_FK R
USI_CASE_FIELDS.INSTANCE_ID USI_CAF_USRSCRN_INST_FK R
USI_CASES.INSTANCE_ID USI_CA_USRSCRN_INST_FK R
USI_CITATIONS.INSTANCE_ID USI_CI_USRSCRN_INST_FK R
USI_COURT_PAPER_FIELDS.INSTANCE_ID USI_CPF_USRSCRN_INST_FK R
USI_COURT_PAPERS.INSTANCE_ID USI_CP_USRSCRN_INST_FK R
USI_CRIMINAL_COMPLAINT_FIELDS.INSTANCE_ID USI_CCF_USRSCRN_INST_FK R
USI_CRIMINAL_COMPLAINT_FORMS.INSTANCE_ID USI_CC_USRSCRN_INST_FK R
USI_DISPATCH_FIELDS.INSTANCE_ID USI_DISPF_USRSCRN_INST_FK R
USI_DV_ASSIGNMENTS.INSTANCE_ID USI_DVA_USRSCRN_INST_FK R
USI_FI_FIELDS.INSTANCE_ID USI_FIF_USRSCRN_INST_FK R
USI_FIELD_ARREST_FIELDS.INSTANCE_ID USI_FAF_USRSCRN_INST_FK R
USI_FIELD_ARREST_VEH_FIELDS.INSTANCE_ID USI_FAVF_USRSCRN_INST_FK R
USI_FIELD_ARRESTS.INSTANCE_ID USI_FA_USRSCRN_INST_FK R
USI_FIELD_INTERVIEWS.INSTANCE_ID USI_FI_USRSCRN_INST_FK R
USI_FLEET_VEHICLE_FORMS.INSTANCE_ID USI_FVF_USRSCRN_INST_FK R
USI_FLEET_VEHICLES.INSTANCE_ID USI_FV_USRSCRN_INST_FK R
USI_IMAGES.INSTANCE_ID USIIMA_USRSCRN_INST_FK C
USI_IMPOUND_FIELDS.INSTANCE_ID USI_IMPF_USRSCRN_INST_FK R
USI_INCIDENT_FIELDS.INSTANCE_ID USI_INCF_USRSCRN_INST_FK R
USI_INCIDENT_PEOPLE.INSTANCE_ID USI_IP_USRSCRN_INST_FK R
USI_INCIDENT_PROPERTIES.INSTANCE_ID USI_INCPROP_USRSCRN_INST_FK R
USI_INCIDENTS.INSTANCE_ID USI_INC_USRSCRN_INST_FK R
USI_OFFENSES.INSTANCE_ID USI_OFF_USRSCRN_INST_FK R
USI_PEOPLE.INSTANCE_ID USI_PER_USRSCRN_INST_FK R
USI_VEHICLES.INSTANCE_ID USI_VEH_USRSCRN_INST_FK R
USI_WARRANT_FIELDS.INSTANCE_ID USI_WAF_USRSCRN_INST_FK R
USI_WARRANTS.INSTANCE_ID USI_WA_USRSCRN_INST_FK R
INC_REVIEW_ROUTE_INSTANCES.INSTANCE_ID Implied Constraint R
SCREEN_ID number 38
USER_SCREENS.SCREEN_ID USRSCRN_INST_USRSCRN_FK R
SCREEN_TYPE_CODE varchar2 30
USER_SCREEN_TYPES.SCREEN_TYPE_CODE USRSCRN_INST_USRSCRN_TYP_FK R
OFFICER_ID number 38  √  null
OFFICERS.OFFICER_ID USRSCRN_INST_OFF1_FK R
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE USRSCRN_INST_AGNCY_CD_FK R
CREATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
UPDATOR_DATE date 7  √  null
SECURITY_LEVEL number 38  √  null
INCIDENT_SECURITY_LEVEL_CODES.INC_SEC_LEVEL_CODE USRSCRN_INST_INC_SEC_LVL_FK R
STATUS_CODE varchar2 30  √  null
EJS_CODES.CODE USRSCRN_INST_STS_CD_FK R
STATUS_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE USRSCRN_INST_STS_CD_FK R
ROUTE_TEMPLATE_ID number 38  √  null
ROUTE_TEMPLATES.TEMPLATE_ID USRSCRN_INST_ROUTEM_FK R
HEADER_ID number 38  √  null
USER_SCREEN_HEADERS.HEADER_ID USRSCRN_INST_USH_FK R
INSTANCE_NUMBER varchar2 30  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"AGENCY_CODE" IS NOT NULL USRSCRN_INST_AGNCY_CD_NN
"INSTANCE_ID" IS NOT NULL USRSCRN_INST_INSTANCE_ID_NN
"SCREEN_ID" IS NOT NULL USRSCRN_INST_SCREEN_ID_NN
"SCREEN_TYPE_CODE" IS NOT NULL USRSCRN_INST_SCRNTYPCD_NN

Indexes:
Column(s) Type Sort Constraint Name
INSTANCE_ID Primary key Asc USRSCRN_INST_PK
AGENCY_CODE Performance Asc USRSCRN_INST_AGNCY_CD_FK_I
SECURITY_LEVEL Performance Asc USRSCRN_INST_INC_SEC_LVL_FK_I
OFFICER_ID Performance Asc USRSCRN_INST_OFF1_FK_I
ROUTE_TEMPLATE_ID Performance Asc USRSCRN_INST_ROUTEM_FK_I
STATUS_CODE_TYPE + STATUS_CODE Performance Asc/Asc USRSCRN_INST_STS_CD_FK_I
HEADER_ID Performance Asc USRSCRN_INST_USH_FK_I
SCREEN_ID Performance Asc USRSCRN_INST_USRSCRN_FK_I
SCREEN_TYPE_CODE Performance Asc USRSCRN_INST_USRSCRN_TYP_FK_I

Close relationships  within of separation: