CST_PROJECT_TIME_LOG - Projects database

Projects database documentation

- Projects database

Documentation	Projects database
Name	CST_PROJECT_TIME_LOG
Module	Costs

Table holds time spent on projects by company employees. Together with CST_PROJECT_COSTS this is a base for cost analysis.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		TIME_ENTRY_ID	NUMBER
	2		ENTRY_DATE	DATE
	3		PERSON_ID	NUMBER			PEOPLE
References: PEOPLE
	4		DEPARTMENT_ID	NUMBER			DEPARTMENTS
References: DEPARTMENTS
	5		PROJECT_ID	NUMBER
	6		ACTIVITY_ID	NUMBER			ACTIVITIES
References: ACTIVITIES
	7		WBS_ID	NUMBER			WBS
References: WBS
	8		HOURS	NUMBER
	9		COST_RATE_CODE	VARCHAR2(10 CHAR)
	10		COST_RATE	NUMBER
	11		COST	NUMBER
	12		STATUS	VARCHAR2(5 CHAR)
	13		CREATED_DATE	DATE		Default: SYSDATE
Default: SYSDATE
	14		CREATED_BY	NUMBER
	15		MODIFIED_DATE	DATE		Default: SYSDATE
Default: SYSDATE
	16		MODIFIED_BY	NUMBER

Relations

Foreign table		Primary table	Join	Title / Name / Description
CST_PROJECT_TIME_LOG		ACTIVITIES	CST_PROJECT_TIME_LOG.ACTIVITY_ID = ACTIVITIES.ACTIVITY_ID	FK_CST_PROJECT_TIME_ACT
CST_PROJECT_TIME_LOG.ACTIVITY_ID = ACTIVITIES.ACTIVITY_ID Name: FK_CST_PROJECT_TIME_ACT
CST_PROJECT_TIME_LOG		DEPARTMENTS	CST_PROJECT_TIME_LOG.DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID	FK_CST_PROJECT_TIME_DEPT
CST_PROJECT_TIME_LOG.DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID Name: FK_CST_PROJECT_TIME_DEPT
CST_PROJECT_TIME_LOG		PEOPLE	CST_PROJECT_TIME_LOG.PERSON_ID = PEOPLE.PERSON_ID	FK_CST_PROJECT_TIME_PER
CST_PROJECT_TIME_LOG.PERSON_ID = PEOPLE.PERSON_ID Name: FK_CST_PROJECT_TIME_PER
CST_PROJECT_TIME_LOG		WBS	CST_PROJECT_TIME_LOG.WBS_ID = WBS.WBS_ID	FK_CST_PROJECT_TIME_WBS
CST_PROJECT_TIME_LOG.WBS_ID = WBS.WBS_ID Name: FK_CST_PROJECT_TIME_WBS

Unique keys

	Key name	Columns	Description
	PK_CST_PROJECT_TIME_LOG	TIME_ENTRY_ID

Uses

Name
CST_PROJECT_TIME_LOG
ACTIVITIES
DEPARTMENTS
PEOPLE
WBS

Exported: 2019-02-04 22:52, Last imported: 2019-02-03 01:50