sprockit.uvw_Batch
[ v1.5 ] [ Back to Sprockit home page ]
This view augments information available in sprockit.Batch.
Columns
| 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
Relationships with integrity enforced by a foreign key constraint have identifiers prefixed with FK; others are prefixed RL.
References to other tables
| Attributes (in this table) | Referenced table | Referenced attributes (in referenced table) |
|
|---|---|---|---|
| RL1 | BatchId | sprockit.Batch | BatchId |
References to this table from others
| Relationship | Attributes (in referencing table) | Referenced attributes (in this table) |
|---|---|---|
| (None). | ||
Page generated from database metadata by DbScout.
1)
Columns with names in bold are non-nullable; columns with underlined names are participants in the table's primary key.