Footprints Data Model

Table
Table Name Value Type Code
Table Definition A lookup table for the data value type discriminator. Many tables share this discriminator for name value pair datatypes. Values include: B Boolean D Timestamp - Date + Time I Integer L Long R Real Number S String T Text - long string

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Value Type Code The data type for a Value Type Code. The choices are 'S' string, 'D' date, 'T' text, 'I' integer. CHAR(1) Yes
Value Type Name The name of the Value Type Code. VARCHAR(255) No