Footprints Data Model

Table
Table Name Dynamic Table Script
Table Definition A DDL script with substitution parameters that is executed by Data Access during the publish process. It contains data structures that must be created along with the tables that are generated for the dynamic item. Parameters may include: a) schema name b) item name prefix (derived from the item name, possibly exactly equal to it) c) container id d) item definition Id Generally, the scripts can be run post level (container, Item) creation using the Type Order and then the Script Order. If the script is changed in the directory then it is reloaded and gets a new identifier. This will cause it to re-run. Scripts must be fundamentally re-runnable.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Dynamic Table Script Id The automatically generated primary key of the dyn_table_script table. LONG Yes
Dynamic Table Script Name The name of the Dynamic Table Script. VARCHAR(255) Yes
Script Type Id A Foreign Key to the Dynamic Table Script Type table. LONG Yes
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. LONG Yes
SQL Script The value of a Dynamic Table Script, stored as a long text object. TEXT Yes
Is Active Indicates if the script is the active version, or if it is a superceded version. When deployment loads the script, the SQL text of the script is compared with any existing active row. If it is equal, the script is not loaded. If unequal, the existing script is marked inactive, and a new active script is loaded. BOOLEAN Yes
Script Sort Order A sort number used to order a list of Dynamic Table Script. INTEGER Yes
Definition Subtype Id A Foreign Key to the Definition Subtype table. INTEGER Yes
Run As Proxy Used for Oracle, indicating if a proxy connection to impersonate the schema account is needed. BOOLEAN No