[ v1.5 ] [ Back to Sprockit home page ]

This view augments information available in sprockit.Batch.

Column name1) Column type Description Notes
PK, RL1 BatchId INT From sprockit.Batch
BatchRecency INT Relative sequence number allocated to the batch in reverse order of [StartDateTime] The most recent batch has [BatchRecency] = 1, the batch before that has [BatchRecency] = 2 etc.
StartDateTime DATETIME From sprockit.Batch
Sprockit Configuration XML From sprockit.Batch

Relationships with integrity enforced by a foreign key constraint have identifiers prefixed with FK; others are prefixed RL.

Click here to view the data model diagram.

(in this table)
Referenced table Referenced attributes
(in referenced table)
RL1 BatchId sprockit.Batch BatchId
Relationship Attributes
(in referencing table)
Referenced attributes
(in this table)

Page generated from database metadata by DbScout.

Columns with names in bold are non-nullable; columns with underlined names are participants in the table's primary key.