Subject Area : 101 - Data Access System
Subject Area(s) of Model "Renoir Domain Model Detail"
# 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..
ER Diagram(s) of Subject Area "101 - Data Access System"
# Name Physical Display Level
Total 2
. Logical Column
. Physical Column
Entity/Table(s) of Subject Area "101 - Data Access System"
# 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..
Attribute/Column(s) of Entity/Table "Database Data Type"
# 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
Attribute/Column(s) of Entity/Table "Dynamic Column Constraint Specification"
# 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
Attribute/Column(s) of Entity/Table "Dynamic Column Specification"
# 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
Attribute/Column(s) of Entity/Table "Dynamic Table Index"
# 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
Attribute/Column(s) of Entity/Table "Dynamic Table Index Column"
# 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
Attribute/Column(s) of Entity/Table "Dynamic Table Specification"
# 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)
Attribute/Column(s) of Entity/Table "Index Type"
# 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)
Attribute/Column(s) of Entity/Table "Logical Data Type"
# 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
Attribute/Column(s) of Entity/Table "Target DBMS"
# 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)