> For the complete documentation index, see [llms.txt](https://docs.videc.de/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.videc.de/june5-3.7/en/datenquellenunterstuetzung-und-einbindung/microsoft-ole-db/sql-tabelle-messgroessen.md).

# SQL Table Measured Variables

The measurement variables table contains all measurement variables of a data source. This table must have at least one column that contains a unique identifier for each measurement variable. The identifier can be a numeric value or a string. This identifier is used to determine the variable whose data is to be imported. The following table shows a possible structure of an SQL table with measurement variables.

| SolarTagID | SolarShortName | SolarName | SolarDescription | SolarUnit | SolarMin | SolarMax |
| ---------- | -------------- | --------- | ---------------- | --------- | -------- | -------- |
| 1          | P01            | Panel01   | Solar Panel 01   | kW        | 0        | 110      |
| 2          | P02            | Panel02   | Solar Panel 02   | kW        | 0        | 120      |
| 3          | P02            | Panel03   | Solar Panel 03   | kW        | 0        | 130      |

A single table with the variable list can be assigned to a JUNE5 data source. The following table shows the mapping of the columns of an SQL table to those of JUNE5.

| Fixed Column Name | Unique Identifier in JUNE5 | Possible Name in an SQL Table | Description                                                       |
| ----------------- | -------------------------- | ----------------------------- | ----------------------------------------------------------------- |
| TagID             | DataSourceID               | SolarTagID                    | Field used to uniquely identify the measurement variable in JUNE5 |
| TagShortName      | ShortName                  | SolarShortName                | Short name of the measurement variable                            |
| TagName           | Name                       | SolarName                     | Name of the measurement variable                                  |
| TagDescription    | Description                | SolarDescription              | Description of the measurement variable                           |
| TagUnit           | ProcessUnit                | SolarUnit                     | Unit of the measurement variable                                  |
| TagMin            | ProcessLimitFrom           | SolarMin                      | Minimum value of the measurement variable                         |
| TagMax            | ProcessLimitTo             | SolarMax                      | Maximum value of the measurement variable                         |


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.videc.de/june5-3.7/en/datenquellenunterstuetzung-und-einbindung/microsoft-ole-db/sql-tabelle-messgroessen.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.