SchemaSpy - View HLPDTEST.STATEGPS.T_CATEGORIES

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

CATEGORY_ID

number

T_CATEGORIES.CATEGORY_ID

Implied Constraint R

CATEGORY_NAME

varchar2

255

√

null

CHILD_CATEGORY_ID

number

Analyzed at Mon May 23 01:05 IST 2022

View Definition:

SELECT T_CATEGORIES.CATEGORY_ID, CATEGORY_NAME, CHILD_CATEGORY_ID FROM T_CATEGORIES, T_CHILD_CATEGORIES WHERE T_CATEGORIES.CATEGORY_ID = T_CHILD_CATEGORIES.CATEGORY_ID

Possibly Referenced Tables/Views:

T_CATEGORIES T_CHILD_CATEGORIES