View HLPDTEST.STATEGPS.T_CATEGORIES_V Generated by
SchemaSpy
Legend: SourceForge.net
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 22
T_CATEGORIES.CATEGORY_ID Implied Constraint R
CATEGORY_NAME varchar2 255  √  null
CHILD_CATEGORY_ID number 22

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:


Close relationships: