PEOPLE - Projects database

Projects database documentation

- Projects database

Documentation	Projects database
Name	PEOPLE
Module	Organization and HR

People table holds all peopple involved in projects - organization employees, contractors and customer employees.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		PERSON_ID	NUMBER
	2		FIRST_NAME	VARCHAR2(100 BYTE)
	3		MIDDLE_NAMES	VARCHAR2(100 BYTE)
	4		LAST_NAME	VARCHAR2(100 BYTE)
	5		AKA	VARCHAR2(50 BYTE)
	6		LANGUAGE	VARCHAR2(10 BYTE)
	7		NATIONALITY	VARCHAR2(10 BYTE)
	8		DATE_OF_BIRTH	DATE
	9		SEX	CHAR(1 BYTE)
	10		PHONE	VARCHAR2(80 BYTE)
	11		MOBILE	VARCHAR2(80 BYTE)
	12		EMAIL	VARCHAR2(100 BYTE)
	13		DEPARTMENT_ID	NUMBER			DEPARTMENTS
References: DEPARTMENTS
	14		COST_RATE	VARCHAR2(10 CHAR)
	15		CREATED_DATE	DATE		Default: SYSDATE
Default: SYSDATE
	16		CREATED_BY	NUMBER
	17		MODIFIED_DATE	DATE		Default: SYSDATE
Default: SYSDATE
	18		MODIFIED_BY	NUMBER

Relations

Foreign table		Primary table	Join	Title / Name / Description
PEOPLE		DEPARTMENTS	PEOPLE.DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID	FK_PEOPLE_DEPARTMENT
PEOPLE.DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID Name: FK_PEOPLE_DEPARTMENT
ACTIVITIES		PEOPLE	ACTIVITIES.ASSIGNED_TO_PERSON_ID = PEOPLE.PERSON_ID	FK_ACTIVITIES_PERSON
ACTIVITIES.ASSIGNED_TO_PERSON_ID = PEOPLE.PERSON_ID Name: FK_ACTIVITIES_PERSON
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
DEPARTMENTS		PEOPLE	DEPARTMENTS.MANAGER_ID = PEOPLE.PERSON_ID	FK_DEPARTMENTS_MANAGER
DEPARTMENTS.MANAGER_ID = PEOPLE.PERSON_ID Name: FK_DEPARTMENTS_MANAGER
PROGRAMS		PEOPLE	PROGRAMS.MANAGER_ID = PEOPLE.PERSON_ID	FK_PROGRAMS_MANAGER
PROGRAMS.MANAGER_ID = PEOPLE.PERSON_ID Name: FK_PROGRAMS_MANAGER
PROJECT_ROLES		PEOPLE	PROJECT_ROLES.PERSON_ID = PEOPLE.PERSON_ID	FK_PROJECT_ROLES_PERSON
PROJECT_ROLES.PERSON_ID = PEOPLE.PERSON_ID Name: FK_PROJECT_ROLES_PERSON
PROJECTS		PEOPLE	PROJECTS.CUST_MNGR_ID = PEOPLE.PERSON_ID	FK_PROJECTS_CUST_MGR
PROJECTS.CUST_MNGR_ID = PEOPLE.PERSON_ID Name: FK_PROJECTS_CUST_MGR
PROJECTS		PEOPLE	PROJECTS.MNGR_ID = PEOPLE.PERSON_ID	FK_PROJECTS_MANAGER
PROJECTS.MNGR_ID = PEOPLE.PERSON_ID Name: FK_PROJECTS_MANAGER

Unique keys

	Key name	Columns	Description
	PEOPLE_PK	PERSON_ID
	PEOPLE_UK1	PHONE
	PEOPLE_UK2	AKA
	UK_PEOPLE_NAME	FIRST_NAME, LAST_NAME
	UK_PEOPLE_NAME_DOB	DATE_OF_BIRTH, LAST_NAME

Uses

Name
PEOPLE
DEPARTMENTS

Used by

Name
PEOPLE
V_PEOPLE_ROLES
ACTIVITIES
CST_PROJECT_TIME_LOG
DEPARTMENTS
PROGRAMS
PROJECT_ROLES
PROJECTS
PROJECTS

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