Footprints Data Model

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

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Dynamic Table Specification Id The automatically generated primary key of the dyn_table_spec table. LONG Yes
Table Name The name of the Database Table Name. It is a database object name, limited to 30 characters in length. VARCHAR(30) No
Schema Name The name of the database schema. It is a database object name, limited to 30 characters in length. VARCHAR(30) No
Reference Id A Foreign Key to the Dynamic Table Specification table. LONG No
Batch Id Publishing batch id, indicates things that are DDL generated together. LONG No
Status The publishing status of the column. Helps indicate how to treat changes to information. VARCHAR(255) No