Car rental

CREATE TABLE `categories`(
`id` INT AUTO_INCREMENT PRIMARY KEY,
`category` VARCHAR(50),
`daily_rate` DOUBLE(4, 2),
`weekly_rate` DOUBLE(4, 2),
`monthly_rate` DOUBLE (4, 2),
`weekend_rate` DOUBLE (4, 2)
);

CREATE TABLE `cars`(
`id` INT AUTO_INCREMENT PRIMARY KEY,
`plate_number` VARCHAR(20) UNIQUE,
`make` VARCHAR(50),
`model` VARCHAR(50),
`car_year` YEAR,
`category_id` INT,
`doors` INT,
`picture` BLOB,
`car_condition` VARCHAR(300),
`available` BOOLEAN
);



CREATE TABLE `employees`(
`id` INT AUTO_INCREMENT PRIMARY KEY,
`first_name` VARCHAR(30),
`last_name` VARCHAR(30),
`title` VARCHAR(50),
`notes` TEXT(400)
);

CREATE TABLE `customers`(
`id` INT AUTO_INCREMENT PRIMARY KEY,
`driver_licence_number` INT,
`full_name` VARCHAR(100),
`address` VARCHAR(100),
`city` VARCHAR(30),
`zip_code` INT,
`notes` TEXT(400)
);

CREATE TABLE `rental_orders`(
`id` INT AUTO_INCREMENT PRIMARY KEY,
`employee_id` INT,
`customer_id` INT,
`car_id` INT,
`car_condition` VARCHAR(300),
`tank_level` INT,
`kilometrage_start` INT,
`kilometrage_end` INT,
`total_kilometrage` INT,
`start_date` DATE,
`end_date` DATE,
`total_days` INT,
`rate_applied` DOUBLE(4, 2),
`tax_rate` DOUBLE(4, 2),
`order_status` VARCHAR(100),
`notes` TEXT(400)
);

INSERT INTO `categories`
VALUES
(1, 'van', 2.0, 14.0, 56.0, 25.0),
(2, 'coupe', 2.0, 14.0, 56.0, 25.0),
(3, 'sedan', 2.0, 14.0, 56.0, 25.0);

INSERT INTO `cars`
VALUES
(1, 654005, 'Kia', 'DeNiro', 2019, 3, 5, NULL, 'used', TRUE),
(2, 684752, 'Honda', 'Civic', 2018, 3, 5, NULL, 'used', TRUE),
(3, 741852, 'Opel', 'Astra', 1992, 4, 3, NULL, 'scrab', FALSE);

INSERT INTO `employees`
VALUES
(1, 'Pesho', 'Peshovski', 'Manager', NULL),
(2, 'Gosho', 'Handsome', 'Cleaner', 'I\'m Gosho, the Handsome one, the eternal bachelor'),
(3, 'Al', 'Bundy', 'Door opener', NULL);

INSERT INTO `customers`
VALUES
(1, 741852, 'Pesho Peshovski', 'Center', 'Sofia', 1000, NULL),
(2, 852963, 'Gosho Handsome', 'Downtown', 'Bourgas', 1200, NULL),
(3, 963852, 'Al Bundy', 'Center', 'Varna', 1300, NULL);

INSERT INTO `rental_orders`
VALUES
(1, 1, 1, 1, 'used', 50, 0, 8, 8, '2019-12-25', '2019-12-31', 6, 4.2, 65.45, 'passed', NULL),
(2, 1, 1, 1, 'used', 50, 0, 8, 8, '2019-12-25', '2019-12-31', 6, 4.2, 65.45, 'in progress', NULL),
(3, 1, 1, 1, 'used', 50, 0, 8, 8, '2019-12-25', '2019-12-31', 6, 4.2, 65.45, 'passed', NULL);