Resv
Environment Reservation.
|
Name |
Type (MS SQL) |
Type (Oracle) |
Type (PostgreSQL) |
Nullable |
Description |
|---|---|---|---|---|---|
|
Id |
BIGINT |
NUMBER(20,0) |
int8 |
not null unique |
Reference to RlmObject |
|
PlannedFrom |
DATETIME |
TIMESTAMP(4) |
timestamp |
|
Start of reservation |
|
PlannedTo |
DATETIME |
TIMESTAMP(4) |
timestamp |
|
End of reservation |
|
OwnerId |
BIGINT |
NUMBER(20,0) |
int8 |
not null |
Reference to Member |
|
EnvId |
BIGINT |
NUMBER(20,0) |
int8 |
not null |
Reference to Environment |
|
TypeId |
BIGINT |
NUMBER(20,0) |
int8 |
not null |
Reference to ResvType |
|
TypeVerId |
BIGINT |
NUMBER(20,0) |
int8 |
not null |
Reference to ResvTypeVer |
|
FolderId |
BIGINT |
NUMBER(20,0) |
int8 |
not null |
Reference to Folder |
|
PlanningMode |
INT |
NUMBER(10,0) |
int4 |
not null |
Planning mode: 0: Shared, 1: Exclusive |
|
ValidationMode |
INT |
NUMBER(10,0) |
int4 |
not null |
Validation Mode: 0: Approval, 1: Warning |
Foreign Keys
|
Name |
Local References |
Foreign References |
|---|---|---|
|
FK_Resv |
Id |
RlmObject |
|
FK_Resv_Owner |
OwnerId |
Member |
|
FK_Resv_Env |
EnvId |
Environment |
|
FK_Resv_Type |
TypeId |
ResvType |
|
FK_Resv_TypeVer |
TypeVerId |
ResvTypeVer |
|
FK_Reservation_Folder |
FolderId |
Folder |