Table HLPDTEST.STATEGPS.T_ISSUE_TYPES 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
ISSUE_TYPE_ID number 22
T_PROJECT_ISSUE_TYPES.ISSUE_TYPE_ID FK_T_PROJECT_ISSUE_TYPES C
ISSUE_TYPE varchar2 200  √  null

Table contained 8 rows at Tue Aug 11 01:05 IST 2020

Indexes:
Column(s) Type Sort Constraint Name Anomalies
ISSUE_TYPE_ID Primary key Asc T_ISSUE_TYPES_PK  
ISSUE_TYPE Must be unique Asc UN_CONS_ISSUE_TYPE This unique column is also nullable

Close relationships: