| Table: dbo.Workpaper_List_Column | |||
| This table contains the order (and presence) of the columns in the workpaper list portlet, chosen by the logged in staff. | |||
| Columns | |||
| Name | Type | Constraints | Description |
| workpaper_list_column_KEY | int (4) | NOT NULL | Primary key to retrieve the column information, column information provided by the logged in staff. |
| workpaper_list_column_type_KEY | tinyint (1) | NOT NULL | Foreign key to store the type of the column. |
| sequence_number | tinyint (1) | NOT NULL | The sequence number to store the staff specific order information of columns. |
| staff_KEY | int (4) | NOT NULL | Logged in staff id, to whom we assign the ordered column information. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Workpaper_List_Column | workpaper_list_column_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Workpaper_List_Column$staff_KEY$workpaper_list_column_type_KEY | staff_KEY, workpaper_list_column_type_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Workpaper_List_Column__Workpaper_List_Column_Type__workpaper_list_column_type_KEY | workpaper_list_column_type_KEY | Workpaper_List_Column_Type (workpaper_list_column_type_KEY) | |
| FK_Workpaper_List_Column__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) | |