The variables_data Data Model
The variables_data data model creates a relationship between site ID and variable ID. The variable ID is associated with details of the event, product, and sampling. It uses the following primary key and rest APIs:
- Primary key: ((tenant_id, enterprise_id, site_id), var_id)
- REST APIs: variables, variables/{varId}
- tenant_id
- enterprise_id
- site_id
- var_id
- as_id
- datasource
- datatype
- deviation_from
- effectivedate
- engineeringunits
- entrydatatime
- eventdimension
- eventsubtype
- eventtype
- expirationdate
- extended_test_freq
- external_link
- firstexception
- input_tag
- input_tag2
- ins_ts
- is_defined
- is_deviation
- is_l_rejectable
- is_overridable
- is_overriden
- is_u_rejectable
- isactive
- isactiveproduct
- isconformancevariable
- islocked
- isunitspecific
- isuserdefineddatatype
- l_control
- l_entry
- l_reject
- l_user
- l_warning
- lel_tag
- linkedtag
- lrl_tag
- lul_tag
- lwl_tag
- max_rpm
- output_ds_id
- output_tag
- prod_id
- productcode
- productdescription
- productfamily
- productionunit
- productproperty
- pvar_id
- rank
- repeating
- resultdatetime
- sa_desc
- sampling_interval
- sampling_offset
- sampling_reference_var_id
- sampling_window
- shouldarchive
- spc_calculation_type_desc
- spc_group_variable_type_desc
- specdescription
- st_desc
- t_control
- tag
- target
- target_tag
- test_freq
- test_id
- test_name
- tf_reset
- tot_factor
- u_control
- u_entry
- u_reject
- u_user
- u_warning
- uel_tag
- unit_reject
- unit_summarize
- upd_ts
- uul_tag
- uwl_tag
- var_precision
- var_reject
- varaiblegroup
- variabledescription
- variablevalue
- vs_id