dbo.RelatedApplication
Table can be used to add, modify, or delete external web applications that are displayed in the Web Portals menu bar under the Applications menu.
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_RelatedApplication | varchar(38) | no | Related application | PKUID |
Ident_RelatedApplication | nvarchar(128) | yes | Related application | |
DisplayName | nvarchar(128) | yes | Display name | |
Description | nvarchar(-1) | yes | Description | |
JPegPhoto | varbinary(-1) | yes | Picture | |
URL | nvarchar(2048) | yes | URL | |
DisplayType | nvarchar(4) | yes | Display type | limited |
IsInActive | bit(1) | yes | Disabled | |
UID_RelatedApplicationParent | varchar(38) | yes | Parent related application | FKUID |
WhereClause | nvarchar(-1) | yes | Condition | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
Relations
| FK | From | To |
|---|---|---|
| No FK rows in snapshot. | ||
Triggers
GEN_T17961E88FBBC5C6CF44C89105 SQL_TRIGGER
GEN_T2F1D4651AA1FEB3340E30384F SQL_TRIGGER
GEN_T3A3DF4B0A1CB81CBF8E37BCDC SQL_TRIGGER
Referenced by / reverse relations
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
| Referencing object | Relation | Evidence |
|---|---|---|
| dbo.GEN_T17961E88FBBC5C6CF44C89105 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2F1D4651AA1FEB3340E30384F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3A3DF4B0A1CB81CBF8E37BCDC | SQL expression dependency | OBJECT_OR_COLUMN |