Metadata File connected to the OYUP database (original) (raw)
Published April 25, 2025 | Version 1
Dataset Open
Authors/Creators
Description
This dataset is part of the database compiled as an outcome of Work Area 1 in project OrganicYieldsUP. This Excel file describes the content of the OYUP relational database for each table and column.
The main sheet "table_schema_oyup" contains:
| ORDINAL_POSITION_per_table | Unique row number for each table. Can be used for sorting. |
|---|---|
| TABLE_NAME | Name of Table being part of the relational database. |
| COLUMN_NAME | Name of Column in the respective table. |
| COLUMN DESCRIPTION | Description of the Column content. |
| DATA_TYPE | SQlite data type of the Column. |
| TABLE_COLUMN_ID | Letter-based ID for the Column that was used during data upload into the database. Can be used to link gap filling information to the gap filled indicator. |
The additional sheet "quality_indicator_description" contains:
| PARAMETER | Quality indicator (unit) reported |
|---|---|
| CROP | Crop that the quality indicator refers to |
| DESCRIPTION | Description of the quality indicator (unit) |
Files
Files (239.5 kB)