Car Rental System

Overview

This is a simple database schema for a car rental system. It is designed to manage various aspects of the car rental process, including vehicle categories, rental locations, payments, reservations, vehicles, credit card information, and customer details.

Database Structure

Tables

1. kategória

   • Manages vehicle categories with information like category ID, vehicle type, and daily rental price.

2. miesto

   • Handles rental locations, including location ID, city, address, postal code, telephone number, and email.

3. platba

   • Tracks payments with details such as payment ID, payment creation date, description, payment type, and total amount.

4. rezervácia

   • Manages reservations, capturing reservation ID, creation date, start and end dates, reservation status, rental location ID, and payment ID.

5. vozidlo

   • Contains information about vehicles, including vehicle ID, license plate, name, description, color, seating capacity, image URL, category ID, and reservation ID.

6. kartové_údaje

   • Stores credit card details, including card details ID, cardholder name, card number, expiration date, CVV, and associated payment ID.

7. zákazník

   • Manages customer details, including customer ID, driver's license number, title, first name, last name, email, telephone number, city, address, postal code, and associated credit card details.

Usage

To use this database schema, you can create the tables using the provided SQL statements. Ensure proper relationships between tables using foreign key constraints.

Feel free to customize and extend the schema based on your specific requirements.