Footprints Data Model

Table
Name dyn_table_spec
Comment
The table specifications for a physical database table associated with a
dynamic item.  A table will be created or altered to match this specification.

Column
Name Datatype Comment Is PK Is FK
dyn_table_spec_id bigint The automatically generated primary key of the dyn_table_spec table. Yes No
table_name varchar(30) The name of the Dynamic Table Specification. No No
schema_name varchar(30) The name of the Dynamic Table Specification. No No
reference_id bigint A Foreign Key to the Dynamic Table Specification table. No No
batch_id bigint Publishing batch id, indicates things that are DDL generated together. No No
status varchar(255)
The publishing status of the column.  Helps indicate how to treat changes to
information.
No No