Data dictionary, explaining tables and fields.
id
Record ID(Metadata) |
Row identifier within datadxny table. |
tblorder
Table order(Metadata) |
Order in which this table should appear in some presentations. |
tblname
Table name(Metadata) |
Name of the table. |
number
Ordinal position(Metadata) |
Order in which this field occurs in the RDBMS. |
label
Field label(Metadata) |
Label of the field in the RDBMS. |
category
Category(Metadata) |
General category of information provided by the contents of the field. |
short_desc
Short description(Metadata) |
Descriptive name of the field used in some presentations, not constrained by rules affecting the label. |
description
Description(Metadata) |
Longer description of the purpose and contents of the field. |
link
Link(Metadata) |
URL providing more information about the field. |
origin
Origin of field(Metadata) |
Abbreviation of an organization, data set, or other entity responsible for defining the field. |
sqltype
SQL type(Metadata) |
Data type of the field as used in the RDBMS. |
dbftype
DBF field type(Metadata) |
Data type of the field when expressed in DBF. |
width
Field width(Metadata) |
Field width when expressed in DBF. |
prec
Precision(Metadata) |
Precision of the field (places to right of decimal) when expressed in DBF, only for numeric fields. |
units
Units of measure(Metadata) |
Units of measure of the field values. |
nodata
No data value(Metadata) |
Special value indicating no data available. |