Footprints Data Model

Table
Name dyn_table_script
Comment 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.

Column
Name Datatype Comment Is PK Is FK
dyn_table_script_id bigint The automatically generated primary key of the dyn_table_script table. Yes No
target_dbms_id bigint 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. No Yes
dyn_table_script_name varchar(255) The name of the Dynamic Table Script. No No
script_type_id bigint A Foreign Key to the Dynamic Table Script Type table. No Yes
sql_script varchar(max) The value of a Dynamic Table Script, stored as a long text object. No No
is_active bit 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. No No
script_sort_order int A sort number used to order a list of Dynamic Table Script. No No
defn_subtype_id int A Foreign Key to the Definition Subtype table. No Yes
run_as_proxy bit Used for Oracle, indicating if a proxy connection to impersonate the schema account is needed. No No