dbo.departments
Documentation | Sample GDPR Database Documentation |
Schema | dbo |
Name | departments |
Personal Data Level | No Personal Data |
Company departments.
Columns
Key | Name | Data type | Null | Attributes | References | Description | Personal Data Level | ||
---|---|---|---|---|---|---|---|---|---|
1 | department_id | int | Row ID | No Personal Data | |||||
Row ID Personal Data Level: No Personal Data |
|||||||||
2 | code | varchar(5) | Department 3 letter code | No Personal Data | |||||
Department 3 letter code Personal Data Level: No Personal Data |
|||||||||
3 | name | nvarchar(50) | Department name | No Personal Data | |||||
Department name Personal Data Level: No Personal Data |
|||||||||
4 | manager_id | int | dbo.people | Department manager | No Personal Data | ||||
Department manager References: dbo.people Personal Data Level: No Personal Data |
|||||||||
5 | parent_department_id | int | dbo.departments | Parent department ID | No Personal Data | ||||
Parent department ID References: dbo.departments Personal Data Level: No Personal Data |
Exported: 2018-12-04 20:05, Last imported: 2018-12-04 15:26