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
NameTypeConstraintsDescription
workpaper_list_column_KEYint (4)NOT NULLPrimary key to retrieve the column information, column information provided by the logged in staff.
workpaper_list_column_type_KEYtinyint (1)NOT NULLForeign key to store the type of the column.
sequence_numbertinyint (1)NOT NULLThe sequence number to store the staff specific order information of columns.
staff_KEYint (4)NOT NULLLogged in staff id, to whom we assign the ordered column information.
Primary key
NameColumnsDescription
PK_Workpaper_List_Columnworkpaper_list_column_KEY
Unique constraints
NameColumnsDescription
UK_Workpaper_List_Column$staff_KEY$workpaper_list_column_type_KEYstaff_KEY, workpaper_list_column_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Workpaper_List_Column__Workpaper_List_Column_Type__workpaper_list_column_type_KEYworkpaper_list_column_type_KEYWorkpaper_List_Column_Type (workpaper_list_column_type_KEY)
FK_Workpaper_List_Column__Staff__staff_KEYstaff_KEYStaff (staff_KEY)

Schema diagram