Table HLPDTEST.STATEGPS.T_PROJECT_DETAILS 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
T_OPEN_ISSUES_PER_PRIORITY_V.PROJECT_ID Implied Constraint R
T_PROJECT_CURRENT_PLAN_TAG_V.PROJECT_ID Implied Constraint R
T_PROJECT_CURRENT_PLAN_TASKS_V.PROJECT_ID Implied Constraint R
T_PROJECT_CURRENT_PLAN_V.PROJECT_ID Implied Constraint R
T_PROJECT_DETAILS_HISTORY.PROJECT_ID SYS_C0019803 R
T_PROJECT_ISSUE_TYPES.PROJECT_ID Implied Constraint R
T_PROJECT_NATIVE_TASK_V.PROJECT_ID Implied Constraint R
T_PROJECT_PLAN_REMOVED_TASKS_V.PROJECT_ID Implied Constraint R
T_PROJECT_PLAN_TAGS_V.PROJECT_ID Implied Constraint R
T_PROJECT_PLAN_TASKS_V.PROJECT_ID Implied Constraint R
T_PROJECT_RESOURCE_RATES.PROJECT_ID Implied Constraint R
T_PROJECTPLAN_CONFIG.PROJECT_ID Implied Constraint R
T_SUPPORT_INVOICE_SCHEDULES.PROJECT_ID SYS_C0019804 R
T_SUPPORT_TYPE.PROJECT_ID Implied Constraint R
T_TIME_TRACKING_V.PROJECT_ID Implied Constraint R
TAG_BASED_PLAN_CONFIG_V.PROJECT_ID Implied Constraint R
TEST_TIME_TRACKING_V_7292.PROJECT_ID Implied Constraint R
V_CURRENT_MONTH_TIMESHEET.PROJECT_ID Implied Constraint R
V_CURRENT_WEEK_TIMESHEET.PROJECT_ID Implied Constraint R
TRADING_PARTY_PROJECT_ID number 22  √  null
T_TRADING_PARTY_PROJECTS.TRADING_PARTY_PROJECT_ID Implied Constraint R
EMSQB_ID number 22  √  null
UPDATED_BY varchar2 255  √  null
UPDATED_DATE timestamp(6) 11,6  √  null
MANAGER varchar2 255  √  null
START_DATE timestamp(6) 11,6  √  null
END_DATE timestamp(6) 11,6  √  null
PROJECT_TYPE varchar2 100  √  null
DURATION number 22  √  null
INVOICE_ON varchar2 20  √  null
SOW_NAME varchar2 1000  √  null
AMOUNT number 22  √  null
BALANCE number 22  √  null
RESOURCE_NAME varchar2 4000  √  null
PO_NUMBER varchar2 255  √  null
SOW_NUMBER varchar2 255  √  null
APPLICATION_ID number 22  √  null
T_GPS_APPLICATIONS.APPLICATION_ID FK_T_GPS_APPLICATIONS C
MANAGER_ID number 22  √  null
VALIDATE_TASK_ACTIVITY_FLAG varchar2 5  √  null
RT_EXECUTION_TYPE varchar2 50  √  null
PROBABLE_INVOICE_DATE date 7  √  null
NET_TERMS varchar2 50  √  null
PDF_NAME_STRING varchar2 255  √  null
PROCESS_ID number 22  √  null

Table contained 1,064 rows at Mon Apr 12 01:05 IST 2021

Indexes:
Column(s) Type Sort Constraint Name Anomalies
PROJECT_ID Primary key Asc SYS_C0019798  
TRADING_PARTY_PROJECT_ID Must be unique Asc SYS_C0019799 This unique column is also nullable
EMSQB_ID Must be unique Asc SYS_C0019800 This unique column is also nullable
APPLICATION_ID Must be unique Asc UK_T_PROJECT_DETAILS This unique column is also nullable

Close relationships  within of separation: