dbo.customers
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 | 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