Database fields in table datadxny

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.