Subject Area : 101 - Data Access System |
# | Name | Definition | ER Diagram | Entity/Table | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | ||||||||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | Details.. |
# | Name | Physical Display Level | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | Logical | Column | ||||||||||||||||||||||||||||||||||||||||||||||||
. | Physical | Column |
# | Physical Name | Name | Logical Only | Do Not Generate | Definition | Attribute/Column | ||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 9 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | dyn_col_cstr_spec | Dynamic Column Constraint Specification | false | A database constraint associated with a column. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | dyn_table_index_col | Dynamic Table Index Column | false | false | The collection of index column specifications for an index. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | index_type | Index Type | false | false | The type of index. Values include: Primary, Unique, Full-Text, Regular, Reverse Key, Computed Reverse Key | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | 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. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | target_dbms | Target DBMS | false | A lookup table for the Target Database Management System types. Values include: SQLServer, PostgreSQL, MySQL, Oracle. | Details.. |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 10 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 3 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 6 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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) |