dbo.people - Sample GDPR Database Documentation

Sample GDPR Database Documentation

- Sample GDPR Database Documentation
  - Tables

Documentation	Sample GDPR Database Documentation
Schema	dbo
Name	people
Personal Data Level	Sensitive Personal Data

Company people.

Columns

		Name	Data type	Description	Personal Data Level	Personal Data Type
	1	person_id	int	Row ID	No Personal Data
Row ID Personal Data Level: No Personal Data
	2	first_name	nvarchar(50)	Person first name	Personal Data	Name
Person first name Personal Data Level: Personal Data Personal Data Type: Name
	3	last_mame	nvarchar(50)	Person last name	Personal Data	Name
Person last name Personal Data Level: Personal Data Personal Data Type: Name
	4	email	nvarchar(50)	Person company email	Personal Data	Contact info
Person company email Personal Data Level: Personal Data Personal Data Type: Contact info
	5	phone	nvarchar(15)	Person business mobile phone number	Personal Data	Contact info
Person business mobile phone number Personal Data Level: Personal Data Personal Data Type: Contact info
	6	dob	date	Date of birth	Personal Data	Date of birth
Date of birth Personal Data Level: Personal Data Personal Data Type: Date of birth
	7	ssn	varchar(50)	SSN	Personal Data	SSN
SSN Personal Data Level: Personal Data Personal Data Type: SSN
	8	education_level	nvarchar(50)	Education level: primary, college, univeristy	No Personal Data
Education level: primary, college, univeristy Personal Data Level: No Personal Data
	9	photo	binary(1000)	Person photo	Personal Data
Person photo Personal Data Level: Personal Data
	10	fingerprint	binary(1000)	Person fingerprints	Sensitive Personal Data
Person fingerprints Personal Data Level: Sensitive Personal Data
	11	ethnicity	nvarchar(50)	Ethnicity	Sensitive Personal Data
Ethnicity Personal Data Level: Sensitive Personal Data
	12	health_data	ntext	Employee health notes	Sensitive Personal Data
Employee health notes Personal Data Level: Sensitive Personal Data

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