Dataset

-- Clients
INSERT INTO Client(clientID, FirstName, LastName, Email, clientAddress, Phone, postcode)
VALUES('0', 'Eric', 'Johnson', 'eric@gmail.com', '32 Eric St', '0442698556', '5042')

INSERT INTO Client(clientID, FirstName, LastName, Email, clientAddress, Phone, postcode)
VALUES('1', 'Benny', 'Harrison', 'benny@gmail.com', '4 Benny St', '0442698556', '2314')

INSERT INTO Client(clientID, FirstName, LastName, Email, clientAddress, Phone, postcode)
VALUES('2', 'Karl', 'Sherman', 'karl@gmail.com', '7 Karl St', '0442698556', '2345')

-- Venues
INSERT INTO Venue(VenueID, VenueLocation, VenueName, Phone, VenueAddress, Postcode)
VALUES('0', 'Sydney', 'Football Arena Sydney', '130098572', '8 Sydney St', '2000' )

INSERT INTO Venue(VenueID, VenueLocation, VenueName, Phone, VenueAddress, Postcode)
VALUES('1', 'Sydney', 'Ashfield Swimming Pool', '130096467', '8 Ashfield St', '2136' )

INSERT INTO Venue(VenueID, VenueLocation, VenueName, Phone, VenueAddress, Postcode)
VALUES('2', 'Sydney', 'Sydney Ice Skating Arena', '1300954352', '8 Ice Skating St', '2984' )

INSERT INTO Venue(VenueID, VenueLocation, VenueName, Phone, VenueAddress, Postcode)
VALUES('3', 'Sydney', 'Five Dock Leisure Centre', '1300954252', '8 King St', '2136' )

-- Coaches
INSERT INTO Coach(CoachID, FirstName, LastName, coachAddress, Email, Phone, postcode, VenueID)
VALUES('0', 'Billy', 'Frederick', '9 Billy St', 'billy@gmail.com', '0432958239', '2134', '0' )

INSERT INTO Coach(CoachID, FirstName, LastName, coachAddress, Email, Phone, postcode, VenueID)
VALUES('1', 'Morgan', 'Cooper', '3 Morgan St', 'Morgan@gmail.com', '0434532239', '2167', '1' )

INSERT INTO Coach(CoachID, FirstName, LastName, coachAddress, Email, Phone, postcode, VenueID)
VALUES('2', 'Kenny', 'Larson', '92 Kenny St', 'kenny@gmail.com', '0432958239', '3452', '2' )

INSERT INTO Coach(CoachID, FirstName, LastName, coachAddress, Email, Phone, postcode, VenueID)
VALUES('3', 'Morgan', 'Freeman', '94 Freeman St', 'morgan@gmail.com', '0432953239', '2138', '3' )

INSERT INTO Coach(CoachID, FirstName, LastName, coachAddress, Email, Phone, postcode, VenueID)
VALUES('4', 'Connor', 'Smith', '95 Connor St', 'connor@gmail.com', '0432558239', '3142', '3' )

-- Training Items
INSERT INTO TrainingItem(ItemID, ItemName)
VALUES('0', 'Football')

INSERT INTO TrainingItem(ItemID, ItemName)
VALUES('1', 'Swimming')

INSERT INTO TrainingItem(ItemID, ItemName)
VALUES('2', 'Skating')

INSERT INTO TrainingItem(ItemID, ItemName)
VALUES('3', 'Dancing')

INSERT INTO TrainingItem(ItemID, ItemName)
VALUES('4', 'Athletics')


-- Coach Rates
INSERT INTO CoachRates(CoachRatesID, CoachID, ItemID, HourlyRates)
VALUES('0', '0', '0', '$45')

INSERT INTO CoachRates(CoachRatesID, CoachID, ItemID, HourlyRates)
VALUES('1', '1', '1', '$25')

INSERT INTO CoachRates(CoachRatesID, CoachID, ItemID, HourlyRates)
VALUES('2', '2', '2', '$30')

INSERT INTO CoachRates(CoachRatesID, CoachID, ItemID, HourlyRates)
VALUES('3', '3', '3', '$20')

INSERT INTO CoachRates(CoachRatesID, CoachID, ItemID, HourlyRates)
VALUES('4', '4', '4', '$15')

-- Achievements
INSERT INTO Achievements(AchievementID, CoachID, AchievementName, AchievementDate)
VALUES('0', '0', 'Executed 10 successful passes of the ball in a row.', '5/5/18')

INSERT INTO Achievements(AchievementID, CoachID, AchievementName, AchievementDate)
VALUES('1', '1', 'Swam 2 laps without stopping.', '18/5/18')

INSERT INTO Achievements(AchievementID, CoachID, AchievementName, AchievementDate)
VALUES('2', '2', 'Stood up on skates.', '21/5/18')

-- Booking
INSERT INTO Booking(BookingID, CoachID, ClientID, VenueID, ItemID, CoachRatesID, BookingDate, BookingStartTime, BookingNumberofHours, BookingTravelFee, BookingTravelTime, BookingAmountDue, BookingAmountPaid, Paid, BookingPaymentStatus, BookingCompletionStatus)
VALUES('0', '0', '0', '0', '0', '0', '5/5/18', '5PM', '1','$5', '20', '$40', '$5', 'N', 'Waiting for full payment.', 'Payment not completed.')

INSERT INTO Booking(BookingID, CoachID, ClientID, VenueID, ItemID, CoachRatesID, BookingDate, BookingStartTime, BookingNumberofHours, BookingTravelFee, BookingTravelTime, BookingAmountDue, BookingAmountPaid, Paid, BookingPaymentStatus, BookingCompletionStatus)
VALUES('1', '1', '1', '1', '1', '1', '18/5/18', '7PM', '2','$2', '15', '$0', '$50', 'Y', 'Payment processed', 'Payment Complete!')

INSERT INTO Booking(BookingID, CoachID, ClientID, VenueID, ItemID, CoachRatesID, BookingDate, BookingStartTime, BookingNumberofHours, BookingTravelFee, BookingTravelTime, BookingAmountDue, BookingAmountPaid, Paid, BookingPaymentStatus, BookingCompletionStatus)
VALUES('2', '2', '2', '2', '2', '2', '18/5/18', '3PM', '1','$15', '20', '$0', '$30', 'Y', 'Payment processed', 'Payment Complete!')