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