dbo.customers - Sample GDPR Database Documentation

Sample GDPR Database Documentation

- Sample GDPR Database Documentation
  - Tables

Documentation	Sample GDPR Database Documentation
Schema	dbo
Name	customers
Personal Data Level	Personal Data

Table holds all potential, current and past customers.

Columns

		Key	Name	Data type	Null	Attributes	References	Description	Personal Data Level	Personal Data Type
	1		customer_id	int		Identity		Row ID	No Personal Data
Row ID Identity Personal Data Level: No Personal Data
	2		cust_no	nvarchar(50)				Number of customer	No Personal Data
Number of customer Personal Data Level: No Personal Data
	3		title	nvarchar(50)				Person title	No Personal Data
Person title Personal Data Level: No Personal Data
	4		first_name	nvarchar(50)				Customer first name	Personal Data	Name
Customer first name Personal Data Level: Personal Data Personal Data Type: Name
	5		last_name	nvarchar(50)				Customer last name	Personal Data	Name
Customer last name Personal Data Level: Personal Data Personal Data Type: Name
	6		email	varchar(50)				Customer e-mai	Personal Data	Contact info
Customer e-mai Personal Data Level: Personal Data Personal Data Type: Contact info
	7		gender	varchar(15)				Gender	No Personal Data
Gender Personal Data Level: No Personal Data
	8		date_of_birth	date				Customer date of birth	Personal Data	Date of birth
Customer date of birth Personal Data Level: Personal Data Personal Data Type: Date of birth
	9		marital_status	varchar(50)				Marital status	No Personal Data
Marital status Personal Data Level: No Personal Data

Exported: 2018-12-04 20:05, Last imported: 2018-12-03 17:00