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)
|