Table HLPDTEST.STATEGPS.T_WORKING_TIME 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
WT_ID number 22
PROJECT_ID number 22  √  null
T_GPS_APPLICATIONS.APPLICATION_ID PROJECT_ID_FK R
RESOURCE_ID number 22  √  null
FROM_DATE date 7
TO_DATE date 7  √  null
FROM_TO_TIME1 varchar2 255  √  null
FROM_TO_TIME2 varchar2 255  √  null
NOTES varchar2 255  √  null
WORKING_TYPE varchar2 255  √  'Non-Working Time'
OFFICE_NAME varchar2 50  √  null

Table contained 47 rows at Fri Oct 30 01:06 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
WT_ID Primary key Asc WT_ID_PK

Close relationships  within of separation: