The database schema that ADC reads use is illustrated in the following diagram.

A core operation that ADC performs is retrieving data using the CORTICON_ADC_READ table. Each CORTICON_ADC_READ row instance can use a different Datasource.

Figure 1. Database Schema for Corticon ADC Read Service Callouts


Note: The schema notes in the following tables are brief. For more details about a column name, see Configuration details
Table 1. CORTICON_ADC_READ Table
Column Name : DataType Note
ID : Integer The Primary Key for the Table which then gets propagated down to each CORTICON_ADC_READ_DEFS record.
NAME : String A logical name that you want to associate with this CORTICON_ADC_READ. This is the name that will be specified inside of each Service Call-out's Runtime Properties tab for the appropriate Query Name.
ADDTOPAYLOAD : String (true or false) Controls whether all data retrieved from the read will be added to the response payload. If this value is null or any value other than true, the default value is false.
Table 2. CORTICON_ADC_READ_DEFS Table The CORTICON_ADC_READ_DEFS and CORTICON_ADC_WRITE_DEFS Tables are the key Tables for ADC. They contain the most pertinent information that ADC needs to perform its duties.
Column Name : DataType Note
ID : Integer The Primary Key for the Table.
READ_ID : Integer (required) Foreign Key back to CORTICON_ADC_READ.ID column. There can be many CORTICON_ADC_READ_DEFS associated with a CORTICON_ADC_READ record.
SEQUENCE : Integer (required) The integer value that specifies the order of execution of each CORTICON_ADC_READ_DEFS within a given CORTICON_ADC_READ_ID.
SQL : String (required) An SQL Statement, a template to be used for the current CORTICON_ADC_READ_DEFS operation.
PRIMARY_ENTITY : String (required) The Corticon Entity to which the SQL statement will map.
PARENT_ENTITY : String and PARENT_ROLENAME : String (optional) The values needed to create an Association between the Parent Entity (PARENT_ENTITY) to the Target Entity (PRIMARY_ENTITY) through Association Role Name (PARENT_ROLENAME).
ENABLE : String (true or false) Suppresses or allows the CORTICON_ADC_READ_DEFS to execute. If this value is null or any value other than false, the default value is true.
Note: For more about the format of Corticon's queries, see How Corticon is expressed in SQL.