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