Table HLPDTEST.STATEGPS.T_PROJECT_SLAS 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
PROJECT_ID number 22  √  null
T_GPS_APPLICATIONS.APPLICATION_ID PROJECT_ID_FOKEY C
SLA_ID number 22
T_PROCESS_SLAS.SLA_ID Implied Constraint R
T_PROJECT_SLAS_ESCALATIONS.SLA_ID SLA_ID_FK R
T_SLA_ESCALATION_V.SLA_ID Implied Constraint R
T_SLA_RESOLUTION_VIOLATION_V.SLA_ID Implied Constraint R
T_SLA_VIOLATION_V.SLA_ID Implied Constraint R
T_TASK_SLAS.SLA_ID Implied Constraint R
KEY_DEFFINITIONS varchar2 1000  √  null
DESCRIPTION varchar2 2000  √  null
RESONSE_TIME number 22  √  null
RESOLUTION_TIME number 22  √  null
FROM_PRIORITY number 22  √  null
TO_PRIORITY number 22  √  null
PRIORITY varchar2 255  √  null
T_PROJECT_CUSTOM_PRIORITY.PRIORITY Implied Constraint R
ENABLED varchar2 5  √  null

Table contained 1 rows at Sun Jan 17 01:06 IST 2021

Indexes:
Column(s) Type Sort Constraint Name
SLA_ID Primary key Asc SLA_ID_PRIKEY

Close relationships  within of separation: