Database fields in table datadxny

Data dictionary, explaining tables and fields

id
Row 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
Field order
(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
(Metadata)
Abbreviation of an organization, data set, or other entity responsible for defining the field
sqltype
SQL data 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
DBF field width
(Metadata)
Field width when expressed in DBF
prec
DBF field precision
(Metadata)
Precision of the field (places to right of decimal) when expressed in DBF, only for numeric fields
units
Units
(Metadata)
Units of measure of the field values
nodata
No data value
(Metadata)
Special value, if any, used to indicate that no data is available for a field. Generally used only for numeric fields where the value zero would have scientific significance.