dbo.UNSAccountBHasUNSItemB
User accounts: permissions control assignments
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_UNSAccountB | varchar(38) | no | User account | PKFKUID |
UID_UNSItemB | varchar(38) | no | Permissions control | PKFKUID |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
XOrigin | int(4) | yes | Origin | bitmask |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XIsInEffect | bit(1) | yes | Assignment in effect |
Relations
| FK | From | To |
|---|---|---|
| No FK rows in snapshot. | ||
Triggers
GEN_T14791D23927D2CA414E652221 SQL_TRIGGER
GEN_T2E7FE5BED11612DFB41192D37 SQL_TRIGGER
GEN_T447F16230B97C9A4AB9580E9F SQL_TRIGGER
GEN_T56F3B6D6D79DDA47EF70C2DB2 SQL_TRIGGER
GEN_T6D115B844F9BE3B3AF36F9243 SQL_TRIGGER
TSB_TIUNSAccountBHasUNSItemB SQL_TRIGGER
TSB_TUUNSAccountBHasUNSItemB 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.TSB_ZUNSAccountBHasUNSItemB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T371F0FB4B613E6EFC97664261 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3F8828A4048A2827422119072 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T56F3B6D6D79DDA47EF70C2DB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUDPRNameSpace | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSAccountBHasUNSItemB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_VElementAndRoot | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_VElementAndRoot | SQL expression dependency | dbo · UID_UNSAccountB · OBJECT_OR_COLUMN |
| dbo.TSB_VElementAndRoot | SQL expression dependency | dbo · XObjectKey · OBJECT_OR_COLUMN |
| dbo.UNSAccountHasUNSItem | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_ZUNSAccountBHasUNSItemB | source text reference | has TRY/CATCH error handling |
| dbo.TSB_TUDPRNameSpace | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSAccountBHasUNSItemB | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |