| Table: dbo.Payroll_Department | |||
| Columns | |||
| Name | Type | Constraints | Description |
| payroll_department_KEY | int (4) | NOT NULL | Key of payroll department record |
| client_KEY | int (4) | NOT NULL | Key of associated client. |
| description | nvarchar (60) | NOT NULL | Description of Payroll_Department record. |
| payroll_department_guid | uniqueidentifier (16) | NOT NULL | A unique GUID key for this row |
| is_active | bit (1) | NOT NULL | If the is active set to true, then the payroll department description is active; if false, then the department description is inactive. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Payroll_Department | payroll_department_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Payroll_Department$client_KEY$description | client_KEY, description | ||
| UK_Payroll_Department$payroll_department_guid | payroll_department_guid | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Payroll_Department__Client__client_KEY | client_KEY | Client (client_KEY) | |