BaseMax/CruiseLaravelGraphQL

BranchesTags

Repository files navigation

Welcome to CruiseGraphQL, an innovative car rental platform that harnesses the power of GraphQL. This project is developed using Laravel 10 and PHP 8.2, offering a streamlined approach to car reservations, real-time vehicle availability tracking, and optimized performance through Redis caching.

CruiseGraphQL is an innovative car rental platform leveraging GraphQL. Engineered using Laravel 10 and PHP 8.2, it streamlines car reservations, monitors vehicle availability, and employs Redis caching for enhanced performance.

  • Car Rental Simplified: CruiseGraphQL provides a user-friendly experience for browsing and renting cars.
  • Effortless Booking Management: Users can easily create, modify, and manage their car rental bookings.
  • Real-time Vehicle Availability: The system ensures up-to-date information on car availability.
  • GraphQL API: CruiseGraphQL exposes a GraphQL API for flexible queries and mutations.
  • Enhanced Performance: Redis caching is implemented to optimize data retrieval and reduce database load.
  • Laravel 10 and PHP 8.2: Built on the latest technologies to ensure a modern and robust foundation.

Clone the repository from .

git clone https://.com/BaseMax/CruiseLaravelGraphQL.git

Navigate to the project directory.

cd CruiseLaravelGraphQL

Install project dependencies using Composer.

composer install

Duplicate .env.example and rename the copy to .env.

cp .env.example .env

Configure .env with your database and Redis settings.

Run database migrations and seeders to set up the initial database structure and sample data.

php artisan migrate

Start the development server.

php artisan serve

Run unit tests:

php artisan test

Access the GraphQL Playground at http://localhost:8000/graphiql in your web browser.

Explore and interact with the CruiseGraphQL API using the integrated GraphQL Playground. Test various queries and mutations to experience the platform's capabilities firsthand.

Here are some examples:

Query available cars:

query {
  availableCars {
    id
    make
    model
    year
    ...
  }
}

Create a booking:

mutation {
  createBooking(input: {
    userId: 1,
    carId: 3,
    pickupDate: "2023-08-20",
    returnDate: "2023-08-25"
  }) {
    id
    user {
      name
    }
    car {
      make
      model
    }
    ...
  }
}
Query/MutationDescriptionExample
availableCarsFetch a list of available cars.query { availableCars { id make model year ... } }
carGet details of a specific car by ID.query { car(id: 1) { id make model year ... } }
userRetrieve details of a user by ID.query { user(id: 2) { id name email ... } }
bookingFetch details of a booking by ID.query { booking(id: 5) { id user { name } car { make model } ... } }
userBookingsGet a list of bookings made by a specific user.query { userBookings(userId: 3) { id car { make model } ... } }
createBookingCreate a new booking.mutation { createBooking(input: { userId: 4 carId: 7 pickupDate: "2023-08-20" returnDate: "2023-08-25" }) { id user { name } car { make model } ... } }
updateBookingUpdate an existing booking.mutation { updateBooking(id: 8 input: { pickupDate: "2023-09-01" }) { id pickupDate returnDate ... } }
cancelBookingCancel a booking.mutation { cancelBooking(id: 10) }
carCategoriesRetrieve a list of available car categories.query { carCategories { id name description ... } }
carCategoryGet details of a specific car category by ID.query { carCategory(id: 3) { id name description ... } }
addCarAdd a new car to the system.mutation { addCar(input: { make: "Toyota" model: "Corolla" year: 2023 ... }) { id make model ... } }
updateCarUpdate car details.mutation { updateCar(id: 5 input: { year: 2022 }) { id make model ... } }
deleteCarRemove a car from the system.mutation { deleteCar(id: 7) }
addUserRegister a new user.mutation { addUser(input: { name: "John Doe" email: "[email protected]" ... }) { id name email ... } }
updateUserUpdate user details.mutation { updateUser(id: 9 input: { name: "Jane Smith" }) { id name email ... } }
deleteUserRemove a user from the system.mutation { deleteUser(id: 11) }
addCarCategoryAdd a new car category.mutation { addCarCategory(input: { name: "SUV" description: "Sport Utility Vehicle" ... }) { id name description ... } }
updateCarCategoryUpdate car category details.mutation { updateCarCategory(id: 13 input: { description: "All-terrain vehicles" }) { id name description ... } }
deleteCarCategoryRemove a car category from the system.mutation { deleteCarCategory(id: 15) }
userLoginAuthenticate a user.mutation { userLogin(email: "[email protected]" password: "securepassword") { token user { name } ... } }
userLogoutLog out a user.mutation { userLogout }
allBookingsFetch a paginated list of all bookings.query { allBookings(page: 2, perPage: 10) { totalPerPage currentPage lastPage data { id user { name } car { make model } ... } } }
searchCarsSearch for cars based on specific criteria.query { searchCars(keyword: "SUV", year: 2022) { id make model year ... } }
bookingsByStatusRetrieve bookings based on their status.query { bookingsByStatus(status: "pending") { id user { name } car { make model } ... } }
totalRevenueCalculate the total revenue generated from bookings.query { totalRevenue }
cancelBookingCancel a booking.mutation { cancelBooking(id: 17) }
userDasardFetch a user's dasard statistics.query { userDasard(userId: 6) { totalBookings upcomingBookings revenue ... } }
carAvailabilityCheck the availability of a specific car for a given time period.query { carAvailability(carId: 9 startDate: "2023-09-01" endDate: "2023-09-10") }
extendBookingExtend the return date of a booking.mutation { extendBooking(id: 19 newReturnDate: "2023-09-15") { id returnDate ... } }
mostPopularCarsGet a list of the most popular cars based on booking frequency.query { mostPopularCars(limit: 5) { id make model bookingCount ... } }
topUsersRetrieve the top users with the highest number of bookings.query { topUsers(limit: 3) { id name totalBookings ... } }
bookingsByCarFetch all bookings for a specific car.query { bookingsByCar(carId: 12) { id user { name } pickupDate returnDate ... } }
carsByCategoryGet a list of cars belonging to a specific category.query { carsByCategory(categoryId: 4) { id make model ... } }
totalBookingsByUserCount the total number of bookings made by a specific user.query { totalBookingsByUser(userId: 8) }
userLastBookingRetrieve the last booking made by a user.query { userLastBooking(userId: 10) { id car { make model } ... } }
carDetailsWitokingsGet car details along with their associated bookings.query { carDetailsWitokings(carId: 15) { id make model bookings { id pickupDate returnDate ... } } }
bookingsBetweenDatesFetch bookings that fall within a specific date range.query { bookingsBetweenDates(startDate: "2023-09-01" endDate: "2023-09-15") { id user { name } pickupDate returnDate ... } }
deleteBookingDelete a booking by ID.mutation { deleteBooking(id: 21) }
addReviewAdd a review for a booked car.mutation { addReview(input: { userId: 12 carId: 18 rating: 4 reviewText: "Great experience!" }) { id rating reviewText ... } }
userReviewsRetrieve reviews submitted by a user.query { userReviews(userId: 14) { id car { make model } rating reviewText ... } }
averageRatingForCarCalculate the average rating for a specific car.query { averageRatingForCar(carId: 20) }
highestRevenueCarsGet a list of cars with the highest revenue generated.query { highestRevenueCars(limit: 3) { id make model revenue ... } }
upcomingBookingsFetch upcoming bookings for a specific user.query { upcomingBookings(userId: 16) { id car { make model } pickupDate returnDate ... } }
recentlyAddedCarsRetrieve a list of recently added cars.query { recentlyAddedCars(limit: 5) { id make model year ... } }
bookingByUserAndCarFetch a specific booking made by a user for a particular car.query { bookingByUserAndCar(userId: 18 carId: 25) { id user { name } car { make model } ... } }
mostActiveUsersGet a list of the most active users based on booking count.query { mostActiveUsers(limit: 10) { id name totalBookings ... } }
carsWithReviewsRetrieve cars along with their associated reviews.query { carsWithReviews(limit: 10) { id make model reviews { id user { name } rating ... } } }
availableCarCategoriesFetch a list of currently available car categories.query { availableCarCategories { id name description ... } }
carCategoryCarsGet a list of cars belonging to a specific car category.query { carCategoryCars(categoryId: 7) { id make model ... } }
userTotalSpentCalculate the total amount spent by a specific user on bookings.query { userTotalSpent(userId: 20) }
userReviewsWithCarsRetrieve user reviews along with the corresponding car details.query { userReviewsWithCars(userId: 22) { id rating reviewText car { make model ... } } }
bookingsWithReviewsGet bookings along with their associated reviews.query { bookingsWithReviews(limit: 5) { id user { name } car { make model } reviews { rating reviewText ... } } }
highestRatedCarsFetch cars with the highest average ratings.query { highestRatedCars(limit: 3) { id make model averageRating ... } }
carsByMakeAndModelSearch for cars based on make and model.query { carsByMakeAndModel(make: "Honda", model: "Civic") { id year ... } }
bookingsByDateRetrieve bookings made on a specific date.query { bookingsByDate(date: "2023-09-15") { id user { name } car { make model } ... } }
earliestBookingFetch the earliest booking made by a user.query { earliestBooking(userId: 24) { id car { make model } pickupDate returnDate ... } }
bookingsWithUserAndCarGet bookings along with their associated user and car details.query { bookingsWithUserAndCar(limit: 5) { id user { name email } car { make model } ... } }
carsByYearRetrieve cars based on a specific manufacturing year.query { carsByYear(year: 2022) { id make model ... } }
bookingDetailsFetch detailed information about a specific booking.query { bookingDetails(id: 27) { id user { name email } car { make model } pickupDate returnDate ... } }
userByEmailRetrieve user details using their email address.query { userByEmail(email: "[email protected]") { id name ... } }
mostBookedCarGet the car that has been booked the most.query { mostBookedCar { id make model bookingCount ... } }
carsByPriceRangeSearch for cars within a specific price range.query { carsByPriceRange(minPrice: 500, maxPrice: 1000) { id make model price ... } }
bookingsInMonthRetrieve bookings made within a specific month.query { bookingsInMonth(year: 2023, month: 8) { id user { name } car { make model } ... } }
userBookedCarsFetch a list of cars that a user has booked.query { userBookedCars(userId: 26) { id make model ... } }
carCategoryDetailsGet detailed information about a specific car category.query { carCategoryDetails(categoryId: 9) { id name description ... } }
bookingRevenueCalculate the total revenue generated from a booking.query { bookingRevenue(id: 29) }
averageRatingsGet the average ratings for all cars.query { averageRatings { carId averageRating } }
upcomingBookingsByCarFetch upcoming bookings for a specific car.query { upcomingBookingsByCar(carId: 31) { id user { name } pickupDate returnDate ... } }
recentlyBookedUsersRetrieve a list of users who made recent bookings.query { recentlyBookedUsers(limit: 5) { id name ... } }

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

Example

  • id: INTEGER (Primary Key)
  • name: STRING
  • email: STRING
  • password: STRING
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • make: STRING
  • model: STRING
  • year: INTEGER
  • price: DECIMAL
  • category_id: INTEGER (Foreign Key to Car Categories)
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • name: STRING
  • description: TEXT
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • user_id: INTEGER (Foreign Key to Users)
  • car_id: INTEGER (Foreign Key to Cars)
  • pickup_date: DATE
  • return_date: DATE
  • status: STRING (e.g., "pending", "confirmed", "canceled")
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • user_id: INTEGER (Foreign Key to Users)
  • car_id: INTEGER (Foreign Key to Cars)
  • rating: INTEGER
  • review_text: TEXT
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • car_id: INTEGER (Foreign Key to Cars)
  • url: STRING
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • booking_id: INTEGER (Foreign Key to Bookings)
  • amount: DECIMAL
  • payment_date: DATE
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • code: STRING
  • discount_percentage: INTEGER
  • expiry_date: DATE
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • user_id: INTEGER (Foreign Key to Users)
  • street: STRING
  • city: STRING
  • state: STRING
  • country: STRING
  • postal_code: STRING
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • user_id: INTEGER (Foreign Key to Users)
  • car_id: INTEGER (Foreign Key to Cars)
  • pickup_date: DATE
  • return_date: DATE
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • car_id: INTEGER (Foreign Key to Cars)
  • feature: STRING
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • car_id: INTEGER (Foreign Key to Cars)
  • log_date: DATE
  • description: TEXT
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • user_id: INTEGER (Foreign Key to Users)
  • message: TEXT
  • is_read: BOOLEAN
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • user_id: INTEGER (Foreign Key to Users)
  • car_id: INTEGER (Foreign Key to Cars)
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • car_id: INTEGER (Foreign Key to Cars)
  • availability_date: DATE
  • is_available: BOOLEAN
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • user_id: INTEGER (Foreign Key to Users)
  • car_id: INTEGER (Foreign Key to Cars)
  • pickup_date: DATE
  • return_date: DATE
  • total_amount: DECIMAL
  • status: STRING (e.g., "active", "completed", "canceled")
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • user_id: INTEGER (Foreign Key to Users)
  • car_id: INTEGER (Foreign Key to Cars)
  • rating: INTEGER
  • review: TEXT
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • name: STRING
  • address: TEXT
  • latitude: DECIMAL
  • longitude: DECIMAL
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • user_id: INTEGER (Foreign Key to Users)
  • car_category_id: INTEGER (Foreign Key to Car Categories)
  • pickup_date: DATE
  • return_date: DATE
  • status: STRING (e.g., "pending", "approved", "rejected")
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • user_id: INTEGER (Foreign Key to Users)
  • subject: STRING
  • message: TEXT
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • name: STRING
  • description: TEXT
  • coverage_amount: DECIMAL
  • premium_amount: DECIMAL
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • car_id: INTEGER (Foreign Key to Cars)
  • reported_by: INTEGER (Foreign Key to Users)
  • description: TEXT
  • status: STRING (e.g., "reported", "in_progress", "resolved")
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • code: STRING
  • discount_amount: DECIMAL
  • valid_from: DATE
  • valid_until: DATE
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • name: STRING
  • description: TEXT
  • price: DECIMAL
  • features: TEXT
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • user_id: INTEGER (Foreign Key to Users)
  • plan_id: INTEGER (Foreign Key to SubscriptionPlans)
  • start_date: DATE
  • end_date: DATE
  • status: STRING (e.g., "active", "canceled", "expired")
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • car_id: INTEGER (Foreign Key to Cars)
  • name: STRING
  • description: TEXT
  • price: DECIMAL
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • name: STRING
  • description: TEXT
  • cost: DECIMAL
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • user_id: INTEGER (Foreign Key to Users)
  • service_id: INTEGER (Foreign Key to MaintenanceServices)
  • request_date: DATE
  • status: STRING (e.g., "requested", "in_progress", "completed")
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • user_id: INTEGER (Foreign Key to Users)
  • notification_enabled: BOOLEAN
  • newsletter_subscribed: BOOLEAN
  • theme: STRING
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • user_id: INTEGER (Foreign Key to Users)
  • car_id: INTEGER (Foreign Key to Cars)
  • start_date: DATE
  • end_date: DATE
  • distance_traveled: DECIMAL
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • car_id: INTEGER (Foreign Key to Cars)
  • log_date: DATE
  • fuel_amount: DECIMAL
  • fuel_price_per_unit: DECIMAL
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • user_id: INTEGER (Foreign Key to Users)
  • car_id: INTEGER (Foreign Key to Cars)
  • violation_date: DATE
  • description: TEXT
  • fine_amount: DECIMAL
  • status: STRING (e.g., "unpaid", "paid")
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • user_id: INTEGER (Foreign Key to Users)
  • document_type: STRING
  • file_url: STRING
  • uploaded_at: TIMESTAMP
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • user_id: INTEGER (Foreign Key to Users)
  • amount: DECIMAL
  • transaction_date: DATE
  • transaction_type: STRING (e.g., "payment", "refund")
  • status: STRING (e.g., "completed", "pending")
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
  • id: INTEGER (Primary Key)
  • user_id: INTEGER (Foreign Key to Users)
  • points_balance: INTEGER
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateUsersTable extends Migration
{
    public function up()
    {
        Schema::create('users', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->string('email')->unique();
            $table->string('password');
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('users');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateCarsTable extends Migration
{
    public function up()
    {
        Schema::create('cars', function (Blueprint $table) {
            $table->id();
            $table->string('make');
            $table->string('model');
            $table->integer('year');
            $table->decimal('price', 10, 2);
            $table->unsignedBigInteger('category_id');
            $table->timestamps();

            $table->foreign('category_id')->references('id')->on('car_categories');
        });
    }

    public function down()
    {
        Schema::dropIfExists('cars');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateCarCategoriesTable extends Migration
{
    public function up()
    {
        Schema::create('car_categories', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->text('description')->nullable();
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('car_categories');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateBookingsTable extends Migration
{
    public function up()
    {
        Schema::create('bookings', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->unsignedBigInteger('car_id');
            $table->date('pickup_date');
            $table->date('return_date');
            $table->string('status');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
            $table->foreign('car_id')->references('id')->on('cars');
        });
    }

    public function down()
    {
        Schema::dropIfExists('bookings');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateReviewsTable extends Migration
{
    public function up()
    {
        Schema::create('reviews', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->unsignedBigInteger('car_id');
            $table->integer('rating');
            $table->text('review_text');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
            $table->foreign('car_id')->references('id')->on('cars');
        });
    }

    public function down()
    {
        Schema::dropIfExists('reviews');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateCarImagesTable extends Migration
{
    public function up()
    {
        Schema::create('car_images', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('car_id');
            $table->string('url');
            $table->timestamps();

            $table->foreign('car_id')->references('id')->on('cars');
        });
    }

    public function down()
    {
        Schema::dropIfExists('car_images');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreatePaymentsTable extends Migration
{
    public function up()
    {
        Schema::create('payments', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('booking_id');
            $table->decimal('amount', 10, 2);
            $table->date('payment_date');
            $table->timestamps();

            $table->foreign('booking_id')->references('id')->on('bookings');
        });
    }

    public function down()
    {
        Schema::dropIfExists('payments');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreatePromotionsTable extends Migration
{
    public function up()
    {
        Schema::create('promotions', function (Blueprint $table) {
            $table->id();
            $table->string('code');
            $table->integer('discount_percentage');
            $table->date('expiry_date');
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('promotions');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateAddressesTable extends Migration
{
    public function up()
    {
        Schema::create('addresses', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->string('street');
            $table->string('city');
            $table->string('state');
            $table->string('country');
            $table->string('postal_code');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
        });
    }

    public function down()
    {
        Schema::dropIfExists('addresses');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateRentalHistoriesTable extends Migration
{
    public function up()
    {
        Schema::create('rental_histories', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->unsignedBigInteger('car_id');
            $table->date('pickup_date');
            $table->date('return_date');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
            $table->foreign('car_id')->references('id')->on('cars');
        });
    }

    public function down()
    {
        Schema::dropIfExists('rental_histories');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateCarFeaturesTable extends Migration
{
    public function up()
    {
        Schema::create('car_features', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('car_id');
            $table->string('feature');
            $table->timestamps();

            $table->foreign('car_id')->references('id')->on('cars');
        });
    }

    public function down()
    {
        Schema::dropIfExists('car_features');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateMaintenanceLogsTable extends Migration
{
    public function up()
    {
        Schema::create('maintenance_logs', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('car_id');
            $table->date('log_date');
            $table->text('description');
            $table->timestamps();

            $table->foreign('car_id')->references('id')->on('cars');
        });
    }

    public function down()
    {
        Schema::dropIfExists('maintenance_logs');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateNotificationsTable extends Migration
{
    public function up()
    {
        Schema::create('notifications', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->text('message');
            $table->boolean('is_read')->default(false);
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
        });
    }

    public function down()
    {
        Schema::dropIfExists('notifications');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateWishlistTable extends Migration
{
    public function up()
    {
        Schema::create('wishlist', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->unsignedBigInteger('car_id');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
            $table->foreign('car_id')->references('id')->on('cars');
        });
    }

    public function down()
    {
        Schema::dropIfExists('wishlist');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateCarAvailabilityTable extends Migration
{
    public function up()
    {
        Schema::create('car_availability', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('car_id');
            $table->date('availability_date');
            $table->boolean('is_available')->default(true);
            $table->timestamps();

            $table->foreign('car_id')->references('id')->on('cars');
        });
    }

    public function down()
    {
        Schema::dropIfExists('car_availability');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateCarRentalsTable extends Migration
{
    public function up()
    {
        Schema::create('car_rentals', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->unsignedBigInteger('car_id');
            $table->date('pickup_date');
            $table->date('return_date');
            $table->decimal('total_amount', 10, 2);
            $table->string('status');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
            $table->foreign('car_id')->references('id')->on('cars');
        });
    }

    public function down()
    {
        Schema::dropIfExists('car_rentals');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateRatingsTable extends Migration
{
    public function up()
    {
        Schema::create('ratings', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->unsignedBigInteger('car_id');
            $table->integer('rating');
            $table->text('review');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
            $table->foreign('car_id')->references('id')->on('cars');
        });
    }

    public function down()
    {
        Schema::dropIfExists('ratings');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateLocationsTable extends Migration
{
    public function up()
    {
        Schema::create('locations', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->text('address');
            $table->decimal('latitude', 10, 8);
            $table->decimal('longitude', 11, 8);
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('locations');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateRentalRequestsTable extends Migration
{
    public function up()
    {
        Schema::create('rental_requests', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->unsignedBigInteger('car_category_id');
            $table->date('pickup_date');
            $table->date('return_date');
            $table->string('status');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
            $table->foreign('car_category_id')->references('id')->on('car_categories');
        });
    }

    public function down()
    {
        Schema::dropIfExists('rental_requests');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateFeedbackTable extends Migration
{
    public function up()
    {
        Schema::create('feedback', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->string('subject');
            $table->text('message');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
        });
    }

    public function down()
    {
        Schema::dropIfExists('feedback');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateInsurancePoliciesTable extends Migration
{
    public function up()
    {
        Schema::create('insurance_policies', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->text('description');
            $table->decimal('coverage_amount', 10, 2);
            $table->decimal('premium_amount', 10, 2);
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('insurance_policies');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateCarIssuesTable extends Migration
{
    public function up()
    {
        Schema::create('car_issues', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('car_id');
            $table->unsignedBigInteger('reported_by');
            $table->text('description');
            $table->string('status');
            $table->timestamps();

            $table->foreign('car_id')->references('id')->on('cars');
            $table->foreign('reported_by')->references('id')->on('users');
        });
    }

    public function down()
    {
        Schema::dropIfExists('car_issues');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateCouponsTable extends Migration
{
    public function up()
    {
        Schema::create('coupons', function (Blueprint $table) {
            $table->id();
            $table->string('code')->unique();
            $table->decimal('discount_amount', 10, 2);
            $table->date('valid_from');
            $table->date('valid_until');
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('coupons');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateSubscriptionPlansTable extends Migration
{
    public function up()
    {
        Schema::create('subscription_plans', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->text('description');
            $table->decimal('price', 10, 2);
            $table->text('features');
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('subscription_plans');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateUserSubscriptionsTable extends Migration
{
    public function up()
    {
        Schema::create('user_subscriptions', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->unsignedBigInteger('plan_id');
            $table->date('start_date');
            $table->date('end_date');
            $table->string('status');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
            $table->foreign('plan_id')->references('id')->on('subscription_plans');
        });
    }

    public function down()
    {
        Schema::dropIfExists('user_subscriptions');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateCarAccessoriesTable extends Migration
{
    public function up()
    {
        Schema::create('car_accessories', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('car_id');
            $table->string('name');
            $table->text('description');
            $table->decimal('price', 10, 2);
            $table->timestamps();

            $table->foreign('car_id')->references('id')->on('cars');
        });
    }

    public function down()
    {
        Schema::dropIfExists('car_accessories');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateMaintenanceServicesTable extends Migration
{
    public function up()
    {
        Schema::create('maintenance_services', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->text('description');
            $table->decimal('cost', 10, 2);
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('maintenance_services');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateServiceRequestsTable extends Migration
{
    public function up()
    {
        Schema::create('service_requests', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->unsignedBigInteger('service_id');
            $table->date('request_date');
            $table->string('status');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
            $table->foreign('service_id')->references('id')->on('maintenance_services');
        });
    }

    public function down()
    {
        Schema::dropIfExists('service_requests');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateUserPreferencesTable extends Migration
{
    public function up()
    {
        Schema::create('user_preferences', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->boolean('notification_enabled')->default(true);
            $table->boolean('newsletter_subscribed')->default(false);
            $table->string('theme')->default('light');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
        });
    }

    public function down()
    {
        Schema::dropIfExists('user_preferences');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateTripLogsTable extends Migration
{
    public function up()
    {
        Schema::create('trip_logs', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->unsignedBigInteger('car_id');
            $table->date('start_date');
            $table->date('end_date');
            $table->decimal('distance_traveled', 10, 2);
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
            $table->foreign('car_id')->references('id')->on('cars');
        });
    }

    public function down()
    {
        Schema::dropIfExists('trip_logs');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateFuelLogsTable extends Migration
{
    public function up()
    {
        Schema::create('fuel_logs', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('car_id');
            $table->date('log_date');
            $table->decimal('fuel_amount', 10, 2);
            $table->decimal('fuel_price_per_unit', 10, 2);
            $table->timestamps();

            $table->foreign('car_id')->references('id')->on('cars');
        });
    }

    public function down()
    {
        Schema::dropIfExists('fuel_logs');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateTrafficViolationsTable extends Migration
{
    public function up()
    {
        Schema::create('traffic_violations', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->unsignedBigInteger('car_id');
            $table->date('violation_date');
            $table->text('description');
            $table->decimal('fine_amount', 10, 2);
            $table->string('status');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
            $table->foreign('car_id')->references('id')->on('cars');
        });
    }

    public function down()
    {
        Schema::dropIfExists('traffic_violations');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateDocumentsTable extends Migration
{
    public function up()
    {
        Schema::create('documents', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->string('document_type');
            $table->string('file_url');
            $table->timestamp('uploaded_at');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
        });
    }

    public function down()
    {
        Schema::dropIfExists('documents');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateTransactionsTable extends Migration
{
    public function up()
    {
        Schema::create('transactions', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->decimal('amount', 10, 2);
            $table->date('transaction_date');
            $table->string('transaction_type');
            $table->string('status');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
        });
    }

    public function down()
    {
        Schema::dropIfExists('transactions');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateLoyaltyPointsTable extends Migration
{
    public function up()
    {
        Schema::create('loyalty_points', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->integer('points_balance');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
        });
    }

    public function down()
    {
        Schema::dropIfExists('loyalty_points');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateCarAccessoriesTable extends Migration
{
    public function up()
    {
        Schema::create('car_accessories', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('car_id');
            $table->string('name');
            $table->text('description');
            $table->decimal('price', 10, 2);
            $table->timestamps();

            $table->foreign('car_id')->references('id')->on('cars');
        });
    }

    public function down()
    {
        Schema::dropIfExists('car_accessories');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateMaintenanceLogsTable extends Migration
{
    public function up()
    {
        Schema::create('maintenance_logs', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('car_id');
            $table->date('log_date');
            $table->text('description');
            $table->timestamps();

            $table->foreign('car_id')->references('id')->on('cars');
        });
    }

    public function down()
    {
        Schema::dropIfExists('maintenance_logs');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateCarIssuesTable extends Migration
{
    public function up()
    {
        Schema::create('car_issues', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('car_id');
            $table->unsignedBigInteger('reported_by');
            $table->text('description');
            $table->string('status');
            $table->timestamps();

            $table->foreign('car_id')->references('id')->on('cars');
            $table->foreign('reported_by')->references('id')->on('users');
        });
    }

    public function down()
    {
        Schema::dropIfExists('car_issues');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateCouponsTable extends Migration
{
    public function up()
    {
        Schema::create('coupons', function (Blueprint $table) {
            $table->id();
            $table->string('code');
            $table->decimal('discount_amount', 10, 2);
            $table->date('valid_from');
            $table->date('valid_until');
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('coupons');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateSubscriptionPlansTable extends Migration
{
    public function up()
    {
        Schema::create('subscription_plans', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->text('description');
            $table->decimal('price', 10, 2);
            $table->text('features');
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('subscription_plans');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateUserSubscriptionsTable extends Migration
{
    public function up()
    {
        Schema::create('user_subscriptions', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->unsignedBigInteger('plan_id');
            $table->date('start_date');
            $table->date('end_date');
            $table->string('status');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
            $table->foreign('plan_id')->references('id')->on('subscription_plans');
        });
    }

    public function down()
    {
        Schema::dropIfExists('user_subscriptions');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateMaintenanceServicesTable extends Migration
{
    public function up()
    {
        Schema::create('maintenance_services', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->text('description');
            $table->decimal('cost', 10, 2);
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('maintenance_services');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateServiceRequestsTable extends Migration
{
    public function up()
    {
        Schema::create('service_requests', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->unsignedBigInteger('service_id');
            $table->date('request_date');
            $table->string('status');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
            $table->foreign('service_id')->references('id')->on('maintenance_services');
        });
    }

    public function down()
    {
        Schema::dropIfExists('service_requests');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateUserPreferencesTable extends Migration
{
    public function up()
    {
        Schema::create('user_preferences', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->boolean('notification_enabled');
            $table->boolean('newsletter_subscribed');
            $table->string('theme');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
        });
    }

    public function down()
    {
        Schema::dropIfExists('user_preferences');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateTripLogsTable extends Migration
{
    public function up()
    {
        Schema::create('trip_logs', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->unsignedBigInteger('car_id');
            $table->date('start_date');
            $table->date('end_date');
            $table->decimal('distance_traveled', 10, 2);
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
            $table->foreign('car_id')->references('id')->on('cars');
        });
    }

    public function down()
    {
        Schema::dropIfExists('trip_logs');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateFuelLogsTable extends Migration
{
    public function up()
    {
        Schema::create('fuel_logs', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('car_id');
            $table->date('log_date');
            $table->decimal('fuel_amount', 10, 2);
            $table->decimal('fuel_price_per_unit', 10, 2);
            $table->timestamps();

            $table->foreign('car_id')->references('id')->on('cars');
        });
    }

    public function down()
    {
        Schema::dropIfExists('fuel_logs');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateTrafficViolationsTable extends Migration
{
    public function up()
    {
        Schema::create('traffic_violations', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->unsignedBigInteger('car_id');
            $table->date('violation_date');
            $table->text('description');
            $table->decimal('fine_amount', 10, 2);
            $table->string('status');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
            $table->foreign('car_id')->references('id')->on('cars');
        });
    }

    public function down()
    {
        Schema::dropIfExists('traffic_violations');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateDocumentsTable extends Migration
{
    public function up()
    {
        Schema::create('documents', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->string('document_type');
            $table->string('file_url');
            $table->timestamp('uploaded_at');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
        });
    }

    public function down()
    {
        Schema::dropIfExists('documents');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateTransactionsTable extends Migration
{
    public function up()
    {
        Schema::create('transactions', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->decimal('amount', 10, 2);
            $table->date('transaction_date');
            $table->string('transaction_type');
            $table->string('status');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
        });
    }

    public function down()
    {
        Schema::dropIfExists('transactions');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateLoyaltyPointsTable extends Migration
{
    public function up()
    {
        Schema::create('loyalty_points', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->integer('points_balance');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
        });
    }

    public function down()
    {
        Schema::dropIfExists('loyalty_points');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateEmployeesTable extends Migration
{
    public function up()
    {
        Schema::create('employees', function (Blueprint $table) {
            $table->id();
            $table->string('first_name');
            $table->string('last_name');
            $table->string('email')->unique();
            $table->string('phone')->nullable();
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('employees');
    }
}
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateEmployeeRolesTable extends Migration
{
    public function up()
    {
        Schema::create('employee_roles', function (Blueprint $table) {
            $table->id();
            $table->string('role_name');
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('employee_roles');
    }
}

Adjust the files according to your project's needs, relationships, and any additional columns you might require. After creating the migrations, run php artisan migrate to apply them to your database.

type User {
  id: Int!
  name: String!
  email: String!
  password: String!
  created_at: DateTime!
  updated_at: DateTime!
}

type Car {
  id: Int!
  make: String!
  model: String!
  year: Int!
  price: Float!
  category: CarCategory!
  created_at: DateTime!
  updated_at: DateTime!
}

type CarCategory {
  id: Int!
  name: String!
  description: String!
  created_at: DateTime!
  updated_at: DateTime!
}

type Booking {
  id: Int!
  user: User!
  car: Car!
  pickup_date: Date!
  return_date: Date!
  status: String!
  created_at: DateTime!
  updated_at: DateTime!
}

type Review {
  id: Int!
  user: User!
  car: Car!
  rating: Int!
  review_text: String!
  created_at: DateTime!
  updated_at: DateTime!
}

type CarImage {
  id: Int!
  car: Car!
  url: String!
  created_at: DateTime!
  updated_at: DateTime!
}

type Payment {
  id: Int!
  booking: Booking!
  amount: Float!
  payment_date: Date!
  created_at: DateTime!
  updated_at: DateTime!
}

type Promotion {
  id: Int!
  code: String!
  discount_percentage: Int!
  expiry_date: Date!
  created_at: DateTime!
  updated_at: DateTime!
}

type Address {
  id: Int!
  user: User!
  street: String!
  city: String!
  state: String!
  country: String!
  postal_code: String!
  created_at: DateTime!
  updated_at: DateTime!
}

type RentalHistory {
  id: Int!
  user: User!
  car: Car!
  pickup_date: Date!
  return_date: Date!
  created_at: DateTime!
  updated_at: DateTime!
}

type CarFeature {
  id: Int!
  car: Car!
  feature: String!
  created_at: DateTime!
  updated_at: DateTime!
}

type MaintenanceLog {
  id: Int!
  car: Car!
  log_date: Date!
  description: String!
  created_at: DateTime!
  updated_at: DateTime!
}

type Notification {
  id: Int!
  user: User!
  message: String!
  is_read: Boolean!
  created_at: DateTime!
  updated_at: DateTime!
}

type Wishlist {
  id: Int!
  user: User!
  car: Car!
  created_at: DateTime!
  updated_at: DateTime!
}

type CarAvailability {
  id: Int!
  car: Car!
  availability_date: Date!
  is_available: Boolean!
  created_at: DateTime!
  updated_at: DateTime!
}

type CarRental {
  id: Int!
  user: User!
  car: Car!
  pickup_date: Date!
  return_date: Date!
  total_amount: Float!
  status: String!
  created_at: DateTime!
  updated_at: DateTime!
}

type Rating {
  id: Int!
  user: User!
  car: Car!
  rating: Int!
  review: String!
  created_at: DateTime!
  updated_at: DateTime!
}

type Location {
  id: Int!
  name: String!
  address: String!
  latitude: Float!
  longitude: Float!
  created_at: DateTime!
  updated_at: DateTime!
}

# Define the remaining types for the rest of the tables similarly...

type Query {
  # Add your query fields here...
}

type Mutation {
  # Add your mutation fields here...
}

Redis caching is implemented to enhance the performance of CruiseGraphQL. Frequently accessed data, such as car details and availability status, are cached to minimize database queries and improve response times.

CruiseGraphQL is open-source software licensed under the GPL-3.0 License.

We extend our gratitude to the Laravel community for providing an exceptional framework for web application development.

Copyright 2023, Max Base

About

CruiseGraphQL is an innovative car rental platform leveraging GraphQL. Engineered using Laravel 10 and PHP 8.2, it streamlines car reservations, monitors vehicle availability, and employs Redis caching for enhanced performance.

Topics

api graphql php laravel php-laravel graphql-server graphql-schema graphql-api laravel-graphql php8 php-graphql laravel10

Resources

Readme

License

GPL-3.0 license
Activity

Stars

4 stars

Watchers

2 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published

Contributors 3

  •  
  •  
  •  

Languages