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

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

Figure 1. Database Schema for Corticon ADC Write Service Callouts


Note: When the primary key of an inserted record is generated by the connected database, Corticon retrieves this generated value and adds it to working memory for that Entity. This will allow follow-up database updates on that Entity to occur, and also allows associated Entities that are dependent on that primary key value to be stored as a foreign key value in the associated Entity. See the next topic for some examples.
Note: The schema notes in the following tables are brief. For more details about a column name, see Configuration details
Table 1. CORTICON_ADC_WRITE Table
Column Name : DataType Note
ID : Integer The Primary Key for the Table which then gets propagated down to each CORTICON_ADC_WRITE_DEFS record.
NAME : String The logical name to associate with this CORTICON_ADC_WRITE. This is the name that will be specified in a Ruleflow Service Call-out's Runtime Properties tab as the Query Name.
Table 2. CORTICON_ADC_WRITE_DEFS Table The CORTICON_ADC_READ_DEFS and CORTICON_ADC_WRITE_DEFS Tables are the key Tables for ADC. These Tables contain the most pertinent information for the ADC to perform its duties.
Column Name : DataType Note
ID : Integer The Primary Key for the Table
WRITE_ID : Integer Foreign Key back to CORTICON_ADC_WRITE.ID column. There can be many CORTICON_ADC_WRITE_DEFS associated with a CORTICON_ADC_WRITE record.
SEQUENCE : Integer The integer value that specifies the order of execution of each CORTICON_ADC_WRITE_DEFS within a given CORTICON_ADC_WRITE_ID when several CORTICON_ADC_WRITE_DEFS are associated with a CORTICON_ADC_WRITE record.
SQL : String SQL Statement used as a template for this CORTICON_ADC_WRITE_DEFS operation.
PRIMARY_ENTITY : String The Entity name that will be used to look up all instances of this Entity type from working memory in which variable substitution will be applied to the SQL statement to create one INSERT or UPDATE statement per Entity instance.
ENABLE : String (true or false) Suppresses or allows the CORTICON_ADC_WRITE_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.