Subject Area : 101 - Data Access System
Subject Area Name Definition
101 - Data Access System These tables define the physical database structure of the dynamic items for all types of containers. The data access layer uses these tables for SQL generation.
ER Diagram Name Physical Display Level
Logical Column
Physical Column
Physical Name Entity/Table Name Logical Only Do Not Generate Definition
db_data_type Database Data Type false The physical database types associated with a logical database type, used in DDL generation and also database DML access.
Physical Name Attribute/Column Name Definition Physical Data Type
target_dbms_id 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. int
db_data_type_name Database Data Type Name The name of the Database Data Type. varchar(255)
logical_data_type_id Logical Data Type Id A Foreign Key to the Logical Data Type table. int
db_data_type_id Database Data Type Id The automatically generated primary key of the db_data_type table. int
dyn_col_cstr_spec Dynamic Column Constraint Specification false A database constraint associated with a column.
Physical Name Attribute/Column Name Definition Physical Data Type
dyn_col_cstr_spec_id Dynamic Column Constraint Specification Id The automatically generated primary key of the dyn_col_cstr_spec table. bigint
dyn_col_spec_id Dynamic Column Specification Id A Foreign Key to the Dynamic Column Specification table. bigint
cstr_val Constraint Value The value of a Dynamic Column Constraint Specification stored as boolean. int
field_cstr_type Field Constraint Type A Foreign Key to the Dynamic Column Constraint Specification table. int
dyn_col_spec Dynamic Column Specification false The list of column specifications for the Dynamic Table Specification. A column will be added or modified to align with the column specification.
Physical Name Attribute/Column Name Definition Physical Data Type
dyn_col_spec_id Dynamic Column Specification Id The automatically generated primary key of the dyn_col_spec table. bigint
dflt_string_val Default String Value The value of a database default. Not used. varchar(255)
dflt_int_val Default Int Value The value of a database default. Not used. int
dflt_date_val Default Date Value The value of a database default. Not used. datetime
dyn_table_spec_id Dynamic Table Specification Id A Foreign Key to the Dynamic Table Specification table. bigint
col_name Column Name The name of the Dynamic Column Specification. varchar(255)
logical_data_type_id Logical Data Type Id A Foreign Key to the Logical Data Type table. int
dflt_long_val Default Long Value The value of a database default. Not used. bigint
reference_id Reference Id The value of a Dynamic Column Specification stored as Long. bigint
is_journal Is Journal Indicates if this column supports the journaling storage feature. bit
dyn_table_index Dynamic Table Index false false A physical database index associated with a dynamically generated table. Different DBMS can have different number and types of these indexes. An index specification will be generated to the database.
Physical Name Attribute/Column Name Definition Physical Data Type
dyn_table_spec_id Dynamic Table Specification Id A Foreign Key to the Dynamic Table Specification table. bigint
index_name Index Name The name of the DBMS_Object_Name. It is a database object name, limited to 30 characters in length. varchar(30)
dyn_table_index_id Dynamic Table Index Id The automatically generated primary key of the dyn_table_index table. bigint
index_type_id Index Type Id The unique identifier for an instance of Index Type. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. int
dyn_table_index_col Dynamic Table Index Column false false The collection of index column specifications for an index.
Physical Name Attribute/Column Name Definition Physical Data Type
dyn_col_spec_id Dynamic Column Specification Id A Foreign Key to the Dynamic Column Specification table. bigint
dyn_table_index_id Dynamic Table Index Id A Foreign Key to the Dynamic Table Index table. bigint
dyn_col_pos Dynamic Column Position The value of a Dynamic Table Index Column stored as boolean. int
dyn_table_spec Dynamic Table Specification false The table specifications for a physical database table associated with a dynamic item. A table will be created or altered to match this specification.
Physical Name Attribute/Column Name Definition Physical Data Type
dyn_table_spec_id Dynamic Table Specification Id The automatically generated primary key of the dyn_table_spec table. bigint
table_name Table Name The name of the Database Table Name. It is a database object name, limited to 30 characters in length. varchar(30)
schema_name Schema Name The name of the database schema. It is a database object name, limited to 30 characters in length. varchar(30)
reference_id Reference Id A Foreign Key to the Dynamic Table Specification table. bigint
batch_id Batch Id Publishing batch id, indicates things that are DDL generated together. bigint
status Status The publishing status of the column. Helps indicate how to treat changes to information. varchar(255)
index_type Index Type false false The type of index. Values include: Primary, Unique, Full-Text, Regular, Reverse Key, Computed Reverse Key
Physical Name Attribute/Column Name Definition Physical Data Type
index_type_id Index Type Id The unique identifier for an instance of Index Type. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. int
index_type_name Index Type Name The unique string identifier for an instance of Index Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. varchar(255)
logical_data_type Logical Data Type false A reference table for logical data type. The logical type maps to the database type in DDL generation.
Physical Name Attribute/Column Name Definition Physical Data Type
logical_data_type_name Logical Data Type Name The name of the Logical Data Type. varchar(255)
logical_data_type_id Logical Data Type Id The automatically generated primary key of the logical_data_type table. int
target_dbms Target DBMS false A lookup table for the Target Database Management System types. Values include: SQLServer, PostgreSQL, MySQL, Oracle.
Physical Name Attribute/Column Name Definition Physical Data Type
target_dbms_id 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. int
target_dbms_name Target DBMS Name The name of the Target DBMS. varchar(255)