Appearance
dbo.makesafeEventLog
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.makesafeEventLog.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | ID | int | no | identity | Primary key, identity. |
| 2 | DateModified | datetime | no | Timestamp the event log entry was created. | |
| 3 | UserID | int | yes | FK to makesafeUser.ID identifying the user associated with the event, if any. | |
| 4 | PhoneCallID | int | yes | FK to makesafePhoneCall.ID identifying the make-safe call this event relates to, if any. | |
| 5 | ActionID | int | no | FK to makesafeEventLogAction.ID identifying the type of action logged. | |
| 6 | Description | nvarchar(512) | yes | Free-text detail describing the logged event. |
Relationships (inferred)
| From | To | Confidence |
|---|---|---|
| dbo.makesafeEventLog.ActionID | dbo.makesafeEventLogAction.ID | medium |
| dbo.makesafeEventLog.UserID | dbo.makesafeUser.ID | medium |
Referenced by
Procedures: dbo.spMakesafeGetAllEventLogs, dbo.spMakesafeInsertEventLog

