Table of Contents

sprockit.Reservation

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

Rows in this table record processes that 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 by this table's primary key.

Columns

Column name1) Column type Description Notes
PK, RL1 ProcessId INT Identifies the reserved process. IDENTITY
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.

Relationships

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.

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).

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.