> ## Documentation Index
> Fetch the complete documentation index at: https://docs.nexalis.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Table Schema

This page describes the current shared schema format for:

* `nexalis_<org_name>_analog_Xminavg`
* `nexalis_<org_name>_discrete`

## Common Columns (Both Tables)

These columns are present in both shared tables:

* **siteName** — site where the signal originates
* **deviceModel** — source device model/family
* **deviceID** — source device identifier
* **subDeviceID** — sub-asset or nested device identifier
* **dataPoint** — original source tag/path
* **description** — source tag description
* **dtConnector** — timestamp in ISO-8601 UTC format
* **value** — signal value
* **assetType** — standardized asset class
* **logicalNode** — standardized logical node
* **dataObject** — standardized data object
* **subDataObject** — optional standardized sub-object (can be empty)

## Table-Specific Columns

### `nexalis_<org_name>_analog_Xminavg`

Additional columns in the average standardized table:

* **engUnits** — engineering unit (example: `kW`)
* **multiplier** — scaling factor
* **adder** — scaling offset

### `nexalis_<org_name>_discrete`

No additional columns beyond the common set in the current shared format.

***

## Notes

* **`nexalis_<org_name>_analog_Xminavg`** is used for standardized analog values at fixed intervals (for example 5-minute intervals).
* **`nexalis_<org_name>_discrete`** carries high-frequency/discrete/event-oriented values.
* In `hf_std`, **`value`** may be numeric, boolean-like text, or enum-like text.
* **subDataObject** is optional and may be empty.