Trips CHECK

CREATE TABLE Trips
(
    Id INT PRIMARY KEY IDENTITY,
    RoomId INT NOT NULL
        CONSTRAINT FK_Trips_Rooms FOREIGN KEY (RoomId) REFERENCES Rooms(Id),
    BookDate DATETIME NOT NULL,
    ArrivalDate DATETIME NOT NULL,
    ReturnDate DATETIME NOT NULL,
    CancelDate DATETIME,

    CONSTRAINT CHK_IfBeforeArrivalDate CHECK(BookDate < ArrivalDate),
    CONSTRAINT CHK_IfBeforeReturnDate CHECK(ArrivalDate < ReturnDate),
)