SchemaSpy - Table slot9.WORLD.TSTA.ROLE

This table defines the valid roles codes to be used for people and organizations on an INCIDENT 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

ROLE_TYPE

varchar2

ARREST_PERSON_ROLES.ROLE_CODE	ARRPR_ROLE_FK R
FIELD_INT_SEARCH_PERSON_VW.ROLE_TYPE	Implied Constraint R
FLDINT_PEOPLE.ROLE_TYPE	FLDIP_ROLE_FK R
INCIDENT_BOLO_PEOPLE_VW.ROLE_TYPE	Implied Constraint R
INCIDENT_CASE_SEARCH_VW.ROLE_TYPE	Implied Constraint R
INCIDENT_PERSON_ROLES.ROLE_TYPE	IPR_RT_FK R
INCIDENT_VICTIM_NAME_VW.ROLE_TYPE	Implied Constraint R

ROLE_DESC

varchar2

ACTIVE

varchar2

'Y'

Yes or No Fields

NOTIFY

varchar2

'N'

Yes or No Fields

REC_ID

number

√

null

INC_SECTION_CODE_TYPE

varchar2

√

null

EJS_CODES.CODE_TYPE

ROLE_INCSEC_EJS_CODES_FK R

INC_SECTION_CODE

varchar2

√

null

EJS_CODES.CODE

ROLE_INCSEC_EJS_CODES_FK R

DEFAULT_FLG

varchar2

'N'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
ACTIVE IN ('N', 'Y')	CK_ROLE_ACTIVE
ACTIVE IN ('N', 'Y')	CK_ROLE_DEFAULT_FLG
NOTIFY IN ('N', 'Y')	CK_ROLE_NOTIFY
"ACTIVE" IS NOT NULL	ROLE_ACTIVE_NN
"DEFAULT_FLG" IS NOT NULL	ROLE_DEFAULT_FLG_NN
"NOTIFY" IS NOT NULL	ROLE_NOTIFY_NN
"ROLE_DESC" IS NOT NULL	ROLE_ROLE_DESC_NN
"ROLE_TYPE" IS NOT NULL	ROLE_ROLE_TYPE_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
ROLE_TYPE	Primary key	Asc	ROLE_PK
INC_SECTION_CODE_TYPE + INC_SECTION_CODE	Performance	Asc/Asc	ROLE_INCSEC_EJS_CODES_FK_I