Table: dbo.User_Interface_Grid_Column
This table holds the description of the columns and whether it is required and the link to the grid it belongs to.
Columns
NameTypeConstraintsDescription
user_interface_grid_column_KEYint (4)NOT NULLPrimary key.
user_interface_grid_KEYint (4)NOT NULLA link to the grid this column belongs to.
descriptionnvarchar (100)NOT NULLThe name of the column.
is_requiredbit (1)NOT NULL
Primary key
NameColumnsDescription
PK_User_Interface_Grid_Columnuser_interface_grid_column_KEY
Unique constraints
NameColumnsDescription
UK_User_Interface_Grid_Column$user_interface_grid_column_KEY$descriptionuser_interface_grid_column_KEY, description
Foreign keys
NameColumnsReferenced tableDescription
FK_User_Interface_Grid_Column__User_Interface_Grid__user_interface_grid_KEYuser_interface_grid_KEYUser_Interface_Grid (user_interface_grid_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payroll_Tracking_Portlet_Column_Screen_Option__User_Interface_Grid_Column__user_interface_grid_column_KEYuser_interface_grid_column_KEYPayroll_Tracking_Portlet_Column_Screen_Option
FK_User_Preference_Grid_Column_Screen_Option__User_Interface_Grid_Column__user_interface_grid_column_KEYuser_interface_grid_column_KEYUser_Preference_Grid_Column_Screen_Option
FK_User_Client_Preference_Grid_Column_Screen_Option__User_Interface_Grid_Column__user_interface_grid_column_KEYuser_interface_grid_column_KEYUser_Client_Preference_Grid_Column_Screen_Option

Schema diagram