Table HLPDTEST.STATEGPS.T_SUPPORT_INVOICE_SCHEDULES 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
PROCESS_ID number 22  √  null
T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID PROCESS_ID_FK C
SUPPORT_TYPE_ID number 22
T_SUPPORT_TYPE.SUPPORT_TYPE_ID Implied Constraint R
SUPPORT_TYPE varchar2 255
INVOICE_AMOUNT number 22  √  null
SCHEDULE_ID varchar2 255  √  null
T_GPS_VIEWER_SCHEDULE.SCHEDULE_ID Implied Constraint R
TICKET_TEMPLATE varchar2 4000  √  null
SUPPORT_DESCRIPTION varchar2 4000  √  null
PROJECT_ID number 22  √  null
T_PROJECT_DETAILS.PROJECT_ID SYS_C0019804 R
INVOICE_DATE timestamp(6) 11,6  √  null
MAIL_DATE timestamp(6) 11,6  √  null
PROJECT_END_DATE timestamp(6) 11,6  √  null
STATUS varchar2 50  √  null
SCHEDULE_START_DATE timestamp(6) 11,6  √  null
SCHEDULE_NAME varchar2 50  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
SUPPORT_TYPE_ID Primary key Asc SUPPORT_TYPE_ID_PK

Close relationships  within of separation: