Lines 1223-1230
CREATE TABLE `bookings` (
Link Here
|
1223 |
`pickup_library_id` varchar(10) NOT NULL COMMENT 'Identifier for booking pickup library', |
1223 |
`pickup_library_id` varchar(10) NOT NULL COMMENT 'Identifier for booking pickup library', |
1224 |
`start_date` datetime DEFAULT NULL COMMENT 'the start date of the booking', |
1224 |
`start_date` datetime DEFAULT NULL COMMENT 'the start date of the booking', |
1225 |
`end_date` datetime DEFAULT NULL COMMENT 'the end date of the booking', |
1225 |
`end_date` datetime DEFAULT NULL COMMENT 'the end date of the booking', |
1226 |
`creation_date` timestamp DEFAULT current_timestamp() COMMENT 'the timestamp for when a booking was created', |
1226 |
`creation_date` timestamp DEFAULT current_timestamp() NOT NULL COMMENT 'the timestamp for when a booking was created', |
1227 |
`modification_date` timestamp DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the timestamp for when a booking has been updated', |
1227 |
`modification_date` timestamp DEFAULT current_timestamp() NOT NULL ON UPDATE current_timestamp() COMMENT 'the timestamp for when a booking has been updated', |
1228 |
`status` enum('new', 'cancelled', 'completed') NOT NULL DEFAULT 'new' COMMENT 'current status of the booking', |
1228 |
`status` enum('new', 'cancelled', 'completed') NOT NULL DEFAULT 'new' COMMENT 'current status of the booking', |
1229 |
`cancellation_reason` varchar(80) DEFAULT NULL COMMENT 'optional authorised value BOOKING_CANCELLATION', |
1229 |
`cancellation_reason` varchar(80) DEFAULT NULL COMMENT 'optional authorised value BOOKING_CANCELLATION', |
1230 |
PRIMARY KEY (`booking_id`), |
1230 |
PRIMARY KEY (`booking_id`), |
1231 |
- |
|
|