Footprints Data Model |
Table |
Name | val_type_cd |
Comment |
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 |
Column |
Name | Datatype | Comment | Is PK | Is FK |
val_type_cd | char(1) |
The data type for a Value Type Code. The choices are 'S' string, 'D' date, 'T' text, 'I' integer. |
Yes | No |
val_type_name | varchar(255) | The name of the Value Type Code. | No | No |