Table: dbo.Client_Shortcut
Columns
NameTypeConstraintsDescription
client_shortcut_KEYint (4)NOT NULLDatabase assigned primary key for this table
update__staff_KEYint (4)NOT NULLKey of the Staff who last modified this row.
update_datedatetime (8, 3)NOT NULLThe date and time this row was last modified.
client_KEYint (4)NOT NULLKey to a Client row
targetnvarchar (2000)NOT NULLTarget to execute. File name or url.
create_datedatetime (8, 3)NOT NULL
portlet_type_KEYint (4)NOT NULLportlet type
Primary key
NameColumnsDescription
PK_Client_Shortcutclient_shortcut_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Shortcut__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_Shortcut__Portlet_Type__portlet_type_KEYportlet_type_KEYPortlet_Type (portlet_type_KEY)

Schema diagram