Table slot9.WORLD.TSTA.CASE_TYPE_CODES
This table is not currently used
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
CODE varchar2 2
CASE_TYPE_CODES.CASE_GEN_CODE CTC3_CTC3_FK R
CITATION_TYPE_CODES.CASE_TYPE_CODE CITAT_CD_CTC3_FK R
ENROLLMENT_STATUS_CODES.CODE Implied Constraint R
The code for a type of case.
CASE_TYPE_DESC varchar2 40  √  null The description of a type of case.
CC1_CODE varchar2 30  √  null
EJS_CODES.CODE CTC3_CC1_CODE_EJS_CODE_FK R
The code for a type of case.
ACTIVE_DATE date 7  √  null
ACTIVE varchar2 1  √  null
CASE_GEN_CODE varchar2 2  √  null
CASE_TYPE_CODES.CODE CTC3_CTC3_FK R
The code for a type of case.
CIVIL varchar2 1 'N'
CAPTION_HEADER varchar2 255  √  null
CC1_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE CTC3_CC1_CODE_EJS_CODE_FK R
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
CIVIL IN ('N', 'Y') CK_CTC3_CIVIL
"CIVIL" IS NOT NULL CTC3_CIVIL_NN
"CODE" IS NOT NULL CTC3_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
CODE Primary key Asc CTC3_PK
CC1_CODE_TYPE + CC1_CODE Performance Asc/Asc CTC3_CC1_CODE_EJS_CODE_I
CC1_CODE Performance Asc CTC3_CC4_FK_I
CASE_GEN_CODE Performance Asc CTC3_CTC3_FK_I

Close relationships  within of separation: