dbo.people
Documentation | Sample GDPR Database Documentation |
Schema | dbo |
Name | people |
Personal Data Level | Sensitive Personal Data |
Company people.
Columns
Key | Name | Data type | Null | Attributes | References | 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 | 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