SchemaSpy - Table slot9.WORLD.TSTA.VISIBILITY_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

CITATION_VISIBILITIES.VISIBILITY_CODE

CIT_VIS_VISIBIL_CD_FK R

ENROLLMENT_STATUS_CODES.CODE

Implied Constraint R

VISIBILITY_DESC

varchar2

40

√

null

ACTIVE

varchar2

1

√

'N'

ACTIVE_DATE

date

7

√

null

REC_ID

number

0

√

null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
ACTIVE IN ('Y', 'N')	CK_VISIBIL_CD_ACTIVE
"CODE" IS NOT NULL	VISIBIL_CD_CODE_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
CODE	Primary key	Asc	VISIBIL_CD_PK