dbo.employee - Sample GDPR Database Documentation

Sample GDPR Database Documentation

- Sample GDPR Database Documentation
  - Tables

Documentation	Sample GDPR Database Documentation
Schema	dbo
Name	employee
Personal Data Level	No Personal Data

Company employees.

Columns

		Key	Name	Data type	Null	Attributes	References	Description	Personal Data Level
	1		emp_id	int				Row ID	No Personal Data
Row ID Personal Data Level: No Personal Data
	2		emp_no	int				Employee number	No Personal Data
Employee number Personal Data Level: No Personal Data
	3		person_id	int			dbo.people	Person	No Personal Data
Person References: dbo.people Personal Data Level: No Personal Data
	4		department_id	int			dbo.departments	Department person is employed in	No Personal Data
Department person is employed in References: dbo.departments Personal Data Level: No Personal Data
	5		position_title	nvarchar(20)				Employee position title	No Personal Data
Employee position title Personal Data Level: No Personal Data
	6		emp_from	date				Beginning of employment	No Personal Data
Beginning of employment Personal Data Level: No Personal Data
	7		emp_to	date				End of employment	No Personal Data
End of employment Personal Data Level: No Personal Data
	8		salary	numeric(18, 0)				Current salary	No Personal Data
Current salary Personal Data Level: No Personal Data

Exported: 2018-12-04 20:05, Last imported: 2018-12-04 15:26