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 |