dbo.QBMLoginAudit
Login protocol
TableType TUsage HISTORYRows 15501SizeMB 18.496
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_QBMLoginAudit | varchar(38) | no | Login | PKUID |
UID_DialogAuthentifier | varchar(38) | yes | Authentication module | FKUID |
LogonUser | nvarchar(512) | yes | Logged in system user | |
Type | int(4) | yes | Type | limited |
SessionID | varchar(38) | yes | Session ID | UID |
ApplicationName | nvarchar(2048) | yes | Program | |
HostName | nvarchar(2048) | yes | Host | |
FailureMessage | nvarchar(2048) | yes | Message | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XObjectKey | varchar(138) | no | Object key | |
UID_Person | varchar(38) | yes | Identity | FKUID |
PersonDisplay | nvarchar(512) | yes | Identity display name |
Relations
| FK | From | To |
|---|---|---|
| QBM_RFRL720 | QBMLoginAudit.UID_DialogAuthentifier | DialogAuthentifier.UID_DialogAuthentifier |
| QER_RFRL4600 | QBMLoginAudit.UID_Person | Person.UID_Person |
Triggers
GEN_T22ED76D4AA887277F08A7A136 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.QBM_VDialogJournalLoginAudit | SQL expression dependency | OBJECT_OR_COLUMN |
| DialogAuthentifier | referenced by foreign key from table | QBM_RFRL720: QBMLoginAudit.UID_DialogAuthentifier -> DialogAuthentifier.UID_DialogAuthentifier |
| Person | referenced by foreign key from table | QER_RFRL4600: QBMLoginAudit.UID_Person -> Person.UID_Person |