SchemaSpy - Table HLPDTEST.STATEGPS.T_INSTANCE

Generated by
SchemaSpy

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

INSTANCE_ID

number

Implied Constraint R

DOCUMENT_ID

number

MYVIEW.DOCUMENT_ID	Implied Constraint R
T_INSTANCE_CHILD_DOCS.DOCUMENT_ID	SYS_C0032681 R
T_ISSUES_CREATED_BY_ME_V.DOCUMENT_ID	Implied Constraint R
T_PROJECT_TASK_V.DOCUMENT_ID	Implied Constraint R
T_STARTED_TASKS_V.DOCUMENT_ID	Implied Constraint R

DOCUMENT

varchar2

200

Table contained 14,604 rows at Sun Oct 18 01:05 IST 2020

Indexes:

Column(s)	Type	Sort	Constraint Name
DOCUMENT_ID	Primary key	Asc	DOC_ID_PK
INSTANCE_ID	Performance	Asc	T_INSTANCE_DOCUMENTS_INDEX1