SchemaSpy - Table slot9.WORLD.TSTA.TAG_CASES

Stores Tagged Cases

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

ID

number

0

COURT_CASE_DELETE.ID

Implied Constraint R

CASE_ID

number

0

INCIDENT_CASES.INC_CASE_ID

TAGCS_IC_FK R

TAG_ID

number

0

TAGS.ID

TAGCS_TAGS_FK R

CREATOR_ID

varchar2

100

√

null

CREATOR_DATE

date

7

√

null

UPDATOR_ID

varchar2

100

√

null

UPDATOR_DATE

date

7

√

null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
"CASE_ID" IS NOT NULL	TAGCS_CASE_ID_NN
"ID" IS NOT NULL	TAGCS_ID_NN
"TAG_ID" IS NOT NULL	TAGCS_TG_ID_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
ID	Primary key	Asc	TAGCS_PK
CASE_ID + TAG_ID	Must be unique	Asc/Asc	TAGCS_CASETAGID_UK
CASE_ID	Performance	Asc	TAGCS_IC_FK_I
TAG_ID	Performance	Asc	TAGCS_TAGS_FK_I