Table slot9.WORLD.TSTA.USER_FIELDS
This table defines custom fields for an agency used throughout 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
FIELD_ID number 38
DS_IBR_FIELD_SYSTEMS.FIELD_ID DSIBRFLDSY_USRSCRN_F_FK R
MAP_USER_SCREENS.ADDRESS_FIELD_ID MUS_USRSCRN_F_6_FK R
MAP_USER_SCREENS.DATE_FIELD_ID MUS_USRSCRN_F_5_FK R
MAP_USER_SCREENS.FIELD_DISPLAY_1 MUS_USRSCRN_F_1_FK R
MAP_USER_SCREENS.FIELD_DISPLAY_2 MUS_USRSCRN_F_2_FK R
MAP_USER_SCREENS.FIELD_DISPLAY_3 MUS_USRSCRN_F_3_FK R
MAP_USER_SCREENS.FIELD_DISPLAY_4 MUS_USRSCRN_F_4_FK R
RV_CONDITION_FACTORS.FIELD_ID RVCF_USRSCRN_F_FK C
RV_CONDITION_PROPERTIES.FIELD_ID RVCOPR_USRSCRN_F_FK C
SCREEN_TYPE_SCREEN_PDF_FIELDS.FIELD_ID STSPF_USRSCRN_F_FK R
UF_QUERY_CHARGE_VW.FIELD_ID Implied Constraint R
UF_QUERY_DATE_VW.FIELD_ID Implied Constraint R
UF_QUERY_LOCATION_VW.FIELD_ID Implied Constraint R
UF_QUERY_NUMBER_VW.FIELD_ID Implied Constraint R
UF_QUERY_OFFENSE_VW.FIELD_ID Implied Constraint R
UF_QUERY_OFFICER_VW.FIELD_ID Implied Constraint R
UF_QUERY_ORGANIZATION_VW.FIELD_ID Implied Constraint R
UF_QUERY_PERSON_VW.FIELD_ID Implied Constraint R
UF_QUERY_PROPERTY_VW.FIELD_ID Implied Constraint R
UF_QUERY_TEXT_VW.FIELD_ID Implied Constraint R
UF_QUERY_VEHICLE_VW.FIELD_ID Implied Constraint R
USER_FIELD_INSTANCES.FIELD_ID USRSCRN_FINST_USRSCRN_F_FK R
SCREEN_ID number 38
USER_SCREENS.SCREEN_ID USRSCRN_F_USRSCRN_FK R
LABEL varchar2 100
ROW_ID number 38  √  null
USER_FIELD_ROWS.ROW_ID USRSCRN_F_USRSCRN_UFR_FK R
TYPE_CODE varchar2 30
EJS_CODES.CODE USRSCRN_F_EJS_CODE_TYPE_FK R
TYPE_CODE_TYPE varchar2 30
EJS_CODES.CODE_TYPE USRSCRN_F_EJS_CODE_TYPE_FK R
USER_CODE varchar2 30  √  null
EJS_CODES.CODE USRSCRN_F_EJS_CODE_USER_FK R
USER_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE USRSCRN_F_EJS_CODE_USER_FK R
PARENT_FIELD_ID number 38  √  null
REQUIRED_FLAG varchar2 1  √  'N'
SPELLING_FLAG varchar2 1  √  'N'
DISPLAY_FLAG varchar2 1  √  'N'
DISPLAY_INDEX number 38  √  null
MAX_LENGTH number 38  √  null
FIELD_WIDTH number 38  √  null
LABEL_WIDTH number 38  √  null
DATA_TYPE varchar2 30  √  null
EJS_CODES.CODE USRSCRN_F_EJS_CODE_DATA_FK R
DATA_TYPE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE USRSCRN_F_EJS_CODE_DATA_FK R
HELP varchar2 1000  √  null
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
REC_ID number 0  √  null
FIELD_NUMBER varchar2 100
PUBLISHED_FLAG varchar2 1  √  'N'
COMMENT_CODE varchar2 30  √  'N'
EJS_CODES.CODE USRSCRN_F_EJS_CODE_CMT_FK R
COMMENT_CODE_TYPE varchar2 30  √  'FIELD_COMMENT_CODES'
EJS_CODES.CODE_TYPE USRSCRN_F_EJS_CODE_CMT_FK R
PRINT_DETAIL_CODE varchar2 30  √  null
EJS_CODES.CODE USRSCRN_F_EJS_CODE_PRDTL_FK R
PRINT_DETAIL_CODE_TYPE varchar2 30  √  'FIELD_PRINT_DETAIL_CODES'
EJS_CODES.CODE_TYPE USRSCRN_F_EJS_CODE_PRDTL_FK R
GRID_WIDTH number 38  √  null
GRID_INDEX number 38  √  null
SUB_SCREEN_ID number 38  √  null
USER_SCREENS.SCREEN_ID USRSCRN_F_USRSCRN2_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
DISPLAY_FLAG IN ('Y', 'N') CK_USRSCRN_F_DISPLAY_FLAG
PUBLISHED_FLAG IN ('Y', 'N') CK_USRSCRN_F_PUBLISHED_FLAG
REQUIRED_FLAG IN ('Y', 'N') CK_USRSCRN_F_REQUIRED_FLAG
SPELLING_FLAG IN ('Y', 'N') CK_USRSCRN_F_SPELLING_FLAG
"FIELD_ID" IS NOT NULL USRSCRN_F_FIELD_ID_NN
"FIELD_NUMBER" IS NOT NULL USRSCRN_F_FIELD_NUMBER_NN
"LABEL" IS NOT NULL USRSCRN_F_LABEL_NN
"SCREEN_ID" IS NOT NULL USRSCRN_F_SCREEN_ID_NN
"TYPE_CODE" IS NOT NULL USRSCRN_F_TYPE_CD_NN
"TYPE_CODE_TYPE" IS NOT NULL USRSCRN_F_TYPE_CDTYPE_NN

Indexes:
Column(s) Type Sort Constraint Name
FIELD_ID Primary key Asc USRSCRN_F_PK
COMMENT_CODE_TYPE + COMMENT_CODE Performance Asc/Asc USRSCRN_F_EJS_CODE_CMT_FK_I
DATA_TYPE_TYPE + DATA_TYPE Performance Asc/Asc USRSCRN_F_EJS_CODE_DATA_FK_I
PRINT_DETAIL_CODE_TYPE + PRINT_DETAIL_CODE Performance Asc/Asc USRSCRN_F_EJS_CODE_PRDTL_FK_I
TYPE_CODE_TYPE + TYPE_CODE Performance Asc/Asc USRSCRN_F_EJS_CODE_TYPE_FK_I
USER_CODE_TYPE + USER_CODE Performance Asc/Asc USRSCRN_F_EJS_CODE_USER_FK_I
FIELD_NUMBER Must be unique Asc USRSCRN_F_FIELD_NUM_UK
SUB_SCREEN_ID Performance Asc USRSCRN_F_USRSCRN2_FK_I
SCREEN_ID Performance Asc USRSCRN_F_USRSCRN_FK_I
ROW_ID Performance Asc USRSCRN_F_USRSCRN_UFR_FK_I

Close relationships  within of separation: