Footprints Data Model

Table
Name publ_log
Comment
A log of container and item publish actions.  The definitions are used to
create schema, table, view, stored procedure, and index objects in the
relational database in order to store dynamically defined information.

Column
Name Datatype Comment Is PK Is FK
publ_log_id bigint The automatically generated primary key of the publ_log table. Yes No
cntnr_defn_id bigint A Foreign Key to the Definition table. Container being published. No Yes
publ_date datetime Log date. No No
author_name varchar(255) Publish admin user. No No
status bit Published status. No No
error_ct smallint Count of errors. No No
warn_ct smallint Count of warnings. No No
user_id bigint
A Foreign Key to the Application User table.  Identifies the user that
performed the publish.
No Yes