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