MSP_PROJECTS |
Default Table Name | MSP_PROJECTS |
Definition |
MSP_PROJECTS Columns |
ColumnName | Domain | Datatype | NULL | Definition |
UPLOAD_ID | VARCHAR2(36) | YES | ||
NAME | VARCHAR2(255) | YES | ||
TITLE | VARCHAR2(255) | YES | ||
COMPANY | VARCHAR2(255) | YES | ||
AUTHOR | VARCHAR2(255) | YES | ||
CREATIONDATE | VARCHAR2(255) | YES | ||
LASTSAVED | VARCHAR2(255) | YES | ||
SCHEDULEFROMSTART | VARCHAR2(255) | YES | ||
STARTDATE | VARCHAR2(255) | YES | ||
FINISHDATE | VARCHAR2(255) | YES | ||
FYSTARTDATE | VARCHAR2(255) | YES | ||
CRITICALSLACKLIMIT | VARCHAR2(255) | YES | ||
CURRENCYDIGITS | VARCHAR2(255) | YES | ||
CURRENCYSYMBOL | VARCHAR2(255) | YES | ||
CURRENCYSYMBOLPOSITION | VARCHAR2(255) | YES | ||
CALENDARUID | VARCHAR2(255) | YES | ||
DEFAULTSTARTTIME | VARCHAR2(255) | YES | ||
DEFAULTFINISHTIME | VARCHAR2(255) | YES | ||
MINUTESPERDAY | VARCHAR2(255) | YES | ||
MINUTESPERWEEK | VARCHAR2(255) | YES | ||
DAYSPERMONTH | VARCHAR2(255) | YES | ||
DEFAULTTASKTYPE | VARCHAR2(255) | YES | ||
DEFAULTFIXEDCOSTACCRUAL | VARCHAR2(255) | YES | ||
DEFAULTSTANDARDRATE | VARCHAR2(255) | YES | ||
DEFAULTOVERTIMERATE | VARCHAR2(255) | YES | ||
DURATIONFORMAT | VARCHAR2(255) | YES | ||
WORKFORMAT | VARCHAR2(255) | YES | ||
EDITABLEACTUALCOSTS | VARCHAR2(255) | YES | ||
HONORCONSTRAINTS | VARCHAR2(255) | YES | ||
INSERTEDPROJECTSLIKESUMMARY | VARCHAR2(255) | YES | ||
MULTIPLECRITICALPATHS | VARCHAR2(255) | YES | ||
NEWTASKSEFFORTDRIVEN | VARCHAR2(255) | YES | ||
NEWTASKSESTIMATED | VARCHAR2(255) | YES | ||
SPLITSINPROGRESSTASKS | VARCHAR2(255) | YES | ||
SPREADACTUALCOST | VARCHAR2(255) | YES | ||
SPREADPERCENTCOMPLETE | VARCHAR2(255) | YES | ||
TASKUPDATESRESOURCE | VARCHAR2(255) | YES | ||
FISCALYEARSTART | VARCHAR2(255) | YES | ||
WEEKSTARTDAY | VARCHAR2(255) | YES | ||
MOVECOMPLETEDENDSBACK | VARCHAR2(255) | YES | ||
MOVEREMAININGSTARTSBACK | VARCHAR2(255) | YES | ||
MOVEREMAININGSTARTSFORWARD | VARCHAR2(255) | YES | ||
MOVECOMPLETEDENDSFORWARD | VARCHAR2(255) | YES | ||
BASELINEFOREARNEDVALUE | VARCHAR2(255) | YES | ||
AUTOADDNEWRESOURCESANDTASKS | VARCHAR2(255) | YES | ||
CURRENTDATE | VARCHAR2(255) | YES | ||
MICROSOFTPROJECTSERVERURL | VARCHAR2(255) | YES | ||
AUTOLINK | VARCHAR2(255) | YES | ||
NEWTASKSTARTDATE | VARCHAR2(255) | YES | ||
DEFAULTTASKEVMETHOD | VARCHAR2(255) | YES | ||
PROJECTEXTERNALLYEDITED | VARCHAR2(255) | YES |
MSP_PROJECTS Primary and Unique Keys |
Key Name | Key Type | Keys |
MSP_PROJECTS Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |