staging_metadata
- Last UpdatedNov 27, 2024
- 1 minute read
The staging_metadata table contains the metadata structure associated with different data types for CONNECT data services.
The information in this table is used to configure the event system of CONNECT data services to store AVEVA MES data.
|
Field |
Data type |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
metadata_type |
string80 |
Y |
N |
Identifies the type of metadata. It will be AuthorizationTags, Enumerations, EventTypes, or ReferenceDataTypes. |
|
type_description |
notes |
N |
N |
Contains a description summary of all types associated to the meta data type. For example, EventTypes will have MESEquipmentUtilizationHistory, MESJobHourlyResponse, etc. ReferenceDataTypes will have MESEquipmentUtilizationState, MESEquipmentUtilizationReason, etc. |
|
type_definition |
notes |
N |
N |
Contains the actual metadata information in JSON format related to CONNECT data services. |
|
last_edit_by |
string80 |
N |
Y |
Identifies the user who last created this data. |
|
last_edit_at |
tdatetime |
N |
N |
Identifies the date and time the record was last changed. |
|
row_id |
int32 |
N |
N |
The unique row identifier. This field is maintained for audit purposes. |