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 |