| Table: dbo.Staff_Shortcut | |||
| Columns | |||
| Name | Type | Constraints | Description |
| staff_shortcut_KEY | int (4) | NOT NULL | Database assigned primary key for this table |
| staff_KEY | int (4) | NOT NULL | Key to a Staff row |
| target | nvarchar (2000) | NOT NULL | Target to execute. File name or url. |
| portlet_type_KEY | int (4) | NOT NULL | portlet type |
| Primary key | |||
| Name | Columns | Description | |
| PK_Staff_Shortcut | staff_shortcut_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Staff_Shortcut__Portlet_Type__portlet_type_KEY | portlet_type_KEY | Portlet_Type (portlet_type_KEY) | |
| FK_Staff_Shortcut__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) | |