CREATE TABLE client (
bookingID INTEGER NOT NULL UNIQUE ,
clientID INTEGER NOT NULL UNIQUE,
clientTitle TEXT NOT NULL ,
clientFirstName TEXT NOT NULL ,
clientSurname TEXT NOT NULL ,
address TEXT NOT NULL ,
city TEXT NOT NULL ,
postCode TEXT NOT NULL ,
telNo INTEGER NOT NULL ,
CONSTRAINT Client_Pri_Key PRIMARY KEY (clientID)
);
CREATE TABLE guest (
bookingID INTEGER NOT NULL,
guestID INTEGER NOT NULL UNIQUE,
guestTitle TEXT NOT NULL ,
guestFirstName TEXT NOT NULL ,
guestSurname TEXT NOT NULL ,
CONSTRAINT Guests_Pri_Key PRIMARY KEY (guestID)
);
CREATE TABLE booking (
bookingID INTEGER NOT NULL UNIQUE ,
clientID INTEGER NOT NULL UNIQUE ,
checkIn INTEGER NOT NULL ,
checkOut INTEGER NOT NULL ,
totalPrice INTEGER NOT NULL,
room INTEGER NOT NULL,
CONSTRAINT Booking_Pri_Key PRIMARY KEY (bookingID)
);