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