This topic describes the columns in the mf_object_events table.
Column Name | Data Type | Primary Key | Is Nullable | Column ID | Comment | Reference Count | Reference To |
---|---|---|---|---|---|---|---|
event_guid | uniqueidentifier | 1 | 0 | 1 | 0 | ||
company_guid | uniqueidentifier | 0 | 0 | 2 | 0 | mf_companies.company_guid | |
batch_guid | uniqueidentifier | 0 | 1 | 3 | 0 | ||
object_guid | uniqueidentifier | 0 | 0 | 4 | 0 | ||
object_type_id | int | 0 | 0 | 5 | 0 | mf_object_types.object_type_id | |
event_type_id | int | 0 | 0 | 6 | 0 | ||
event_id | int | 0 | 1 | 7 | 0 | ||
event_source | varchar (50) | 0 | 1 | 8 | 0 | ||
event_description | varchar (1000) | 0 | 1 | 9 | 0 | ||
event_system | tinyint | 0 | 1 | 10 | 0 | ||
event_closed | bit | 0 | 1 | 11 | 0 | ||
event_closed_user_guid | uniqueidentifier | 0 | 1 | 12 | 0 | ||
event_closed_user | varchar (50) | 0 | 1 | 13 | 0 | ||
lu_dt | datetime | 0 | 0 | 14 | 0 | ||
cr_dt | datetime | 0 | 0 | 15 | 0 | ||
lu_guid | uniqueidentifier | 0 | 1 | 16 | 0 | ||
cr_guid | uniqueidentifier | 0 | 1 | 17 | 0 | ||
lu_user | varchar (50) | 0 | 1 | 18 | 0 | ||
cr_user | varchar (50) | 0 | 1 | 19 | 0 |