Footprints Data Model

Table
Name dyn_table_script_type
Comment
The type of Dynamic Table script, which is important for locating and
re-running the script if need be.  Examples include: Activity Data Mart
Creation, Status Change Data Mart Creation.  Generally, the scripts can be run
post level (container, Item) creation using the Type Order and then the Script
Order.

Column
Name Datatype Comment Is PK Is FK
dyn_table_script_type_id bigint The automatically generated primary key of the dyn_table_script_type table. Yes No
dyn_table_script_type_name varchar(255) The name of the Dynamic Table Script Type. No No
dyn_table_script_type_descr varchar(512)
A descriptive name of the Dynamic Table Script Type.  This descriptive name may
be localized.
No No
type_sort_order int A sort number used to order a list of Dynamic Table Script Type. No No