Footprints Data Model

Table
Table Name Database Data Type
Table Definition The physical database types associated with a logical database type, used in DDL generation and also database DML access.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Database Data Type Id The automatically generated primary key of the db_data_type table. INTEGER Yes
Target DBMS Id The unique identifier for an instance of Target DBMS. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. LONG No
Database Data Type Name The name of the Database Data Type. VARCHAR(255) No
Logical Data Type Id A Foreign Key to the Logical Data Type table. INTEGER No