/* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-start */
====== sprockit.Reservation ======
~~PAGESWITCHER~~ [ [[..:..:sprockit|Back to Sprockit home page]] ]

Rows in this table record [[sprockit.Process|processes]] that [[sprockit.Handler|handlers]] have reserved for execution. 

Handlers are required to reserve processes prior to executing them to ensure that a process cannot be executed by more than one handler. Exclusivity of reservations is enforced using this table's primary key.

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Columns-start */
===== Columns =====
^ ^Column name((Columns with names in **bold** are non-nullable; columns with __underlined__ names are participants in the table's primary key.))  ^Column type  ^Description   ^Notes   ^
|PK, [[sprockit.Process|RL1]]  |__**ProcessId**__  |INT  |Identifies the reserved process.  |IDENTITY  |
|[[sprockit.Handler|RL2]]  |**HandlerId**  |INT  |Identifies the handler that has reserved the process indicated by [ProcessId].  |  |
|  |**ReservationTime**  |DATETIME  |The date and time at which the reservation was made.  |  |

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Columns-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Relationships-start */
===== Relationships =====
Relationships with integrity enforced by a foreign key constraint have identifiers
prefixed with //FK//; others are prefixed //RL//.

[[sprockit:v1.5:Sprockit tables:Sprockit tables|Click here to view the data model diagram.]]
==== References to other tables ====

^  ^Attributes \\ (in this table)  ^Referenced table  ^Referenced attributes \\  (in referenced table)   ^
|RL2  |HandlerId  |[[sprockit.Handler]]  |HandlerId  |
|RL1  |ProcessId  |[[sprockit.Process]]  |ProcessId  |

==== References to this table from others ====

^Relationship  ^Attributes \\ (in referencing table)  ^Referenced attributes \\ (in this table)   ^
|(None).   |||


/* Net.FireFive.ERModel.Dokuwiki.TablePage.Relationships-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Notes-start */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Notes-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Footer-start */
----
Page generated from database metadata by [[https://richardswinbank.net/DbScout|DbScout]].

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Footer-end */