Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
|||||
| created_by | int8 | 19 | null |
|
|
||||||
| created_time | timestamptz | 35,6 | null |
|
|
||||||
| event_class | text | 2147483647 | null |
|
|
Fully-qualified class name of the event whose payload is stored in the payload column. May be a newer version of the event class than was originally written at the time of the operation. |
|||||
| payload | jsonb | 2147483647 | null |
|
|
JSON-serialized contents of the event object of the class specified by event_class. |
|||||
| original_event_class | text | 2147483647 | √ | null |
|
|
If the event has been migrated to a newer version, the fully-qualified class name of the event as it was originally stored. |
||||
| original_payload | jsonb | 2147483647 | √ | null |
|
|
If the event has been migrated to a newer version, the JSON-serialized contents of the event as it was originally stored. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| event_log_pkey | Primary key | Asc | id |
| event_log_accessionid_idx | Performance | Asc | event_class |
| event_log_activityid_idx | Performance | Asc | event_class |
| event_log_batchid_idx | Performance | Asc | event_class |
| event_log_created_by_idx | Performance | Asc | created_by |
| event_log_created_time_idx | Performance | Asc | created_time |
| event_log_event_class_idx | Performance | Asc | event_class |
| event_log_facilityid_idx | Performance | Asc | event_class |
| event_log_fileid_idx | Performance | Asc | event_class |
| event_log_monitoringplotid_idx | Performance | Asc | event_class |
| event_log_observationid_idx | Performance | Asc | event_class |
| event_log_organizationid_idx | Performance | Asc | event_class |
| event_log_plantingsiteid_idx | Performance | Asc | event_class |
| event_log_projectid_idx | Performance | Asc | event_class |
| event_log_recordedtreeid_idx | Performance | Asc | event_class |
| event_log_withdrawalid_idx | Performance | Asc | event_class |