Footprints Data Model

Table
Name db_data_type
Comment The physical database types associated with a logical database type, used in DDL generation and also database DML access.

Column
Name Datatype Comment Is PK Is FK
db_data_type_id int The automatically generated primary key of the db_data_type table. Yes No
target_dbms_id bigint 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. No Yes
db_data_type_name varchar(255) The name of the Database Data Type. No No
logical_data_type_id int A Foreign Key to the Logical Data Type table. No Yes