Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

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.

License

NotificationsYou must be signed in to change notification settings

BaseMax/CruiseLaravelGraphQL

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.

Features

  • 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.

Installation

Clone the repository from GitHub.

git clone https://github.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 artisantest

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

GraphQL API

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 {idmakemodelyear...  }}

Create a booking:

mutation {createBooking(input: {userId:1,carId:3,pickupDate:"2023-08-20",returnDate:"2023-08-25"  }) {iduser {name    }car {makemodel    }...  }}

GraphQL

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: "john@example.com" ... }) { 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: "john@example.com" 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) }
userDashboardFetch a user's dashboard statistics.query { userDashboard(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 } ... } }
carDetailsWithBookingsGet car details along with their associated bookings.query { carDetailsWithBookings(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: "jane@example.com") { 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 ... } }

Examples

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

Database Schema

Users Table

  • id: INTEGER (Primary Key)
  • name: STRING
  • email: STRING
  • password: STRING
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP

Cars Table

  • 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

Car Categories Table

  • id: INTEGER (Primary Key)
  • name: STRING
  • description: TEXT
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP

Bookings Table

  • 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

Reviews Table

  • 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

Car Images Table

  • id: INTEGER (Primary Key)
  • car_id: INTEGER (Foreign Key to Cars)
  • url: STRING
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP

Payments Table

  • id: INTEGER (Primary Key)
  • booking_id: INTEGER (Foreign Key to Bookings)
  • amount: DECIMAL
  • payment_date: DATE
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP

Promotions Table

  • id: INTEGER (Primary Key)
  • code: STRING
  • discount_percentage: INTEGER
  • expiry_date: DATE
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP

Addresses Table

  • 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

RentalHistories Table

  • 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

CarFeatures Table

  • id: INTEGER (Primary Key)
  • car_id: INTEGER (Foreign Key to Cars)
  • feature: STRING
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP

MaintenanceLogs Table

  • id: INTEGER (Primary Key)
  • car_id: INTEGER (Foreign Key to Cars)
  • log_date: DATE
  • description: TEXT
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP

Notifications Table

  • id: INTEGER (Primary Key)
  • user_id: INTEGER (Foreign Key to Users)
  • message: TEXT
  • is_read: BOOLEAN
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP

Wishlist Table

  • id: INTEGER (Primary Key)
  • user_id: INTEGER (Foreign Key to Users)
  • car_id: INTEGER (Foreign Key to Cars)
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP

CarAvailability Table

  • id: INTEGER (Primary Key)
  • car_id: INTEGER (Foreign Key to Cars)
  • availability_date: DATE
  • is_available: BOOLEAN
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP

CarRentals Table

  • 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

Ratings Table

  • 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

Locations Table

  • id: INTEGER (Primary Key)
  • name: STRING
  • address: TEXT
  • latitude: DECIMAL
  • longitude: DECIMAL
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP

RentalRequests Table

  • 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

Feedback Table

  • id: INTEGER (Primary Key)
  • user_id: INTEGER (Foreign Key to Users)
  • subject: STRING
  • message: TEXT
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP

InsurancePolicies Table

  • id: INTEGER (Primary Key)
  • name: STRING
  • description: TEXT
  • coverage_amount: DECIMAL
  • premium_amount: DECIMAL
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP

CarIssues Table

  • 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

Coupons Table

  • id: INTEGER (Primary Key)
  • code: STRING
  • discount_amount: DECIMAL
  • valid_from: DATE
  • valid_until: DATE
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP

SubscriptionPlans Table

  • id: INTEGER (Primary Key)
  • name: STRING
  • description: TEXT
  • price: DECIMAL
  • features: TEXT
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP

UserSubscriptions Table

  • 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

CarAccessories Table

  • id: INTEGER (Primary Key)
  • car_id: INTEGER (Foreign Key to Cars)
  • name: STRING
  • description: TEXT
  • price: DECIMAL
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP

MaintenanceServices Table

  • id: INTEGER (Primary Key)
  • name: STRING
  • description: TEXT
  • cost: DECIMAL
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP

ServiceRequests Table

  • 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

UserPreferences Table

  • 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

TripLogs Table

  • 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

FuelLogs Table

  • 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

TrafficViolations Table

  • 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

Documents Table

  • 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

Transactions Table

  • 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

LoyaltyPoints Table

  • id: INTEGER (Primary Key)
  • user_id: INTEGER (Foreign Key to Users)
  • points_balance: INTEGER
  • created_at: TIMESTAMP
  • updated_at: TIMESTAMP

Laravel Tables

Users Table Migration (create_users_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateUsersTableextends Migration{publicfunctionup()    {        Schema::create('users',function (Blueprint$table) {$table->id();$table->string('name');$table->string('email')->unique();$table->string('password');$table->timestamps();        });    }publicfunctiondown()    {        Schema::dropIfExists('users');    }}

Cars Table Migration (create_cars_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateCarsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('cars');    }}

Car Categories Table Migration (create_car_categories_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateCarCategoriesTableextends Migration{publicfunctionup()    {        Schema::create('car_categories',function (Blueprint$table) {$table->id();$table->string('name');$table->text('description')->nullable();$table->timestamps();        });    }publicfunctiondown()    {        Schema::dropIfExists('car_categories');    }}

Bookings Table Migration (create_bookings_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateBookingsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('bookings');    }}

Reviews Table Migration (create_reviews_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateReviewsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('reviews');    }}

Car Images Table Migration (create_car_images_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateCarImagesTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('car_images');    }}

Payments Table Migration (create_payments_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreatePaymentsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('payments');    }}

Promotions Table Migration (create_promotions_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreatePromotionsTableextends Migration{publicfunctionup()    {        Schema::create('promotions',function (Blueprint$table) {$table->id();$table->string('code');$table->integer('discount_percentage');$table->date('expiry_date');$table->timestamps();        });    }publicfunctiondown()    {        Schema::dropIfExists('promotions');    }}

Addresses Table Migration (create_addresses_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateAddressesTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('addresses');    }}

RentalHistories Table Migration (create_rental_histories_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateRentalHistoriesTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('rental_histories');    }}

CarFeatures Table Migration (create_car_features_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateCarFeaturesTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('car_features');    }}

MaintenanceLogs Table Migration (create_maintenance_logs_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateMaintenanceLogsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('maintenance_logs');    }}

Notifications Table Migration (create_notifications_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateNotificationsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('notifications');    }}

Wishlist Table Migration (create_wishlist_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateWishlistTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('wishlist');    }}

CarAvailability Table Migration (create_car_availability_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateCarAvailabilityTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('car_availability');    }}

CarRentals Table Migration (create_car_rentals_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateCarRentalsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('car_rentals');    }}

Ratings Table Migration (create_ratings_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateRatingsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('ratings');    }}

Locations Table Migration (create_locations_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateLocationsTableextends Migration{publicfunctionup()    {        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();        });    }publicfunctiondown()    {        Schema::dropIfExists('locations');    }}

RentalRequests Table Migration (create_rental_requests_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateRentalRequestsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('rental_requests');    }}

Feedback Table Migration (create_feedback_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateFeedbackTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('feedback');    }}

InsurancePolicies Table Migration (create_insurance_policies_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateInsurancePoliciesTableextends Migration{publicfunctionup()    {        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();        });    }publicfunctiondown()    {        Schema::dropIfExists('insurance_policies');    }}

CarIssues Table Migration (create_car_issues_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateCarIssuesTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('car_issues');    }}

Coupons Table Migration (create_coupons_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateCouponsTableextends Migration{publicfunctionup()    {        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();        });    }publicfunctiondown()    {        Schema::dropIfExists('coupons');    }}

SubscriptionPlans Table Migration (create_subscription_plans_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateSubscriptionPlansTableextends Migration{publicfunctionup()    {        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();        });    }publicfunctiondown()    {        Schema::dropIfExists('subscription_plans');    }}

UserSubscriptions Table Migration (create_user_subscriptions_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateUserSubscriptionsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('user_subscriptions');    }}

CarAccessories Table Migration (create_car_accessories_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateCarAccessoriesTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('car_accessories');    }}

MaintenanceServices Table Migration (create_maintenance_services_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateMaintenanceServicesTableextends Migration{publicfunctionup()    {        Schema::create('maintenance_services',function (Blueprint$table) {$table->id();$table->string('name');$table->text('description');$table->decimal('cost',10,2);$table->timestamps();        });    }publicfunctiondown()    {        Schema::dropIfExists('maintenance_services');    }}

ServiceRequests Table Migration (create_service_requests_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateServiceRequestsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('service_requests');    }}

UserPreferences Table Migration (create_user_preferences_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateUserPreferencesTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('user_preferences');    }}

TripLogs Table Migration (create_trip_logs_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateTripLogsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('trip_logs');    }}

FuelLogs Table Migration (create_fuel_logs_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateFuelLogsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('fuel_logs');    }}

TrafficViolations Table Migration (create_traffic_violations_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateTrafficViolationsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('traffic_violations');    }}

Documents Table Migration (create_documents_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateDocumentsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('documents');    }}

Transactions Table Migration (create_transactions_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateTransactionsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('transactions');    }}

LoyaltyPoints Table Migration (create_loyalty_points_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateLoyaltyPointsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('loyalty_points');    }}

CarAccessories Table Migration (create_car_accessories_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateCarAccessoriesTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('car_accessories');    }}

MaintenanceLogs Table Migration (create_maintenance_logs_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateMaintenanceLogsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('maintenance_logs');    }}

CarIssues Table Migration (create_car_issues_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateCarIssuesTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('car_issues');    }}

Coupons Table Migration (create_coupons_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateCouponsTableextends Migration{publicfunctionup()    {        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();        });    }publicfunctiondown()    {        Schema::dropIfExists('coupons');    }}

SubscriptionPlans Table Migration (create_subscription_plans_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateSubscriptionPlansTableextends Migration{publicfunctionup()    {        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();        });    }publicfunctiondown()    {        Schema::dropIfExists('subscription_plans');    }}

UserSubscriptions Table Migration (create_user_subscriptions_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateUserSubscriptionsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('user_subscriptions');    }}

MaintenanceServices Table Migration (create_maintenance_services_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateMaintenanceServicesTableextends Migration{publicfunctionup()    {        Schema::create('maintenance_services',function (Blueprint$table) {$table->id();$table->string('name');$table->text('description');$table->decimal('cost',10,2);$table->timestamps();        });    }publicfunctiondown()    {        Schema::dropIfExists('maintenance_services');    }}

ServiceRequests Table Migration (create_service_requests_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateServiceRequestsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('service_requests');    }}

UserPreferences Table Migration (create_user_preferences_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateUserPreferencesTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('user_preferences');    }}

TripLogs Table Migration (create_trip_logs_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateTripLogsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('trip_logs');    }}

FuelLogs Table Migration (create_fuel_logs_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateFuelLogsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('fuel_logs');    }}

TrafficViolations Table Migration (create_traffic_violations_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateTrafficViolationsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('traffic_violations');    }}

Documents Table Migration (create_documents_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateDocumentsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('documents');    }}

Transactions Table Migration (create_transactions_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateTransactionsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('transactions');    }}

LoyaltyPoints Table Migration (create_loyalty_points_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateLoyaltyPointsTableextends Migration{publicfunctionup()    {        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');        });    }publicfunctiondown()    {        Schema::dropIfExists('loyalty_points');    }}

Employee Table Migration (create_employees_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateEmployeesTableextends Migration{publicfunctionup()    {        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();        });    }publicfunctiondown()    {        Schema::dropIfExists('employees');    }}

EmployeeRoles Table Migration (create_employee_roles_table.php):

useIlluminate\Database\Migrations\Migration;useIlluminate\Database\Schema\Blueprint;useIlluminate\Support\Facades\Schema;class CreateEmployeeRolesTableextends Migration{publicfunctionup()    {        Schema::create('employee_roles',function (Blueprint$table) {$table->id();$table->string('role_name');$table->timestamps();        });    }publicfunctiondown()    {        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, runphp artisan migrate to apply them to your database.

GraphQL Structure

typeUser {id:Int!name:String!email:String!password:String!created_at:DateTime!updated_at:DateTime!}typeCar {id:Int!make:String!model:String!year:Int!price:Float!category:CarCategory!created_at:DateTime!updated_at:DateTime!}typeCarCategory {id:Int!name:String!description:String!created_at:DateTime!updated_at:DateTime!}typeBooking {id:Int!user:User!car:Car!pickup_date:Date!return_date:Date!status:String!created_at:DateTime!updated_at:DateTime!}typeReview {id:Int!user:User!car:Car!rating:Int!review_text:String!created_at:DateTime!updated_at:DateTime!}typeCarImage {id:Int!car:Car!url:String!created_at:DateTime!updated_at:DateTime!}typePayment {id:Int!booking:Booking!amount:Float!payment_date:Date!created_at:DateTime!updated_at:DateTime!}typePromotion {id:Int!code:String!discount_percentage:Int!expiry_date:Date!created_at:DateTime!updated_at:DateTime!}typeAddress {id:Int!user:User!street:String!city:String!state:String!country:String!postal_code:String!created_at:DateTime!updated_at:DateTime!}typeRentalHistory {id:Int!user:User!car:Car!pickup_date:Date!return_date:Date!created_at:DateTime!updated_at:DateTime!}typeCarFeature {id:Int!car:Car!feature:String!created_at:DateTime!updated_at:DateTime!}typeMaintenanceLog {id:Int!car:Car!log_date:Date!description:String!created_at:DateTime!updated_at:DateTime!}typeNotification {id:Int!user:User!message:String!is_read:Boolean!created_at:DateTime!updated_at:DateTime!}typeWishlist {id:Int!user:User!car:Car!created_at:DateTime!updated_at:DateTime!}typeCarAvailability {id:Int!car:Car!availability_date:Date!is_available:Boolean!created_at:DateTime!updated_at:DateTime!}typeCarRental {id:Int!user:User!car:Car!pickup_date:Date!return_date:Date!total_amount:Float!status:String!created_at:DateTime!updated_at:DateTime!}typeRating {id:Int!user:User!car:Car!rating:Int!review:String!created_at:DateTime!updated_at:DateTime!}typeLocation {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...typeQuery {  # Add your query fields here...}typeMutation {  # Add your mutation fields here...}

Caching with Redis

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.

License

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

Acknowledgments

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

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors3

  •  
  •  
  •  
[8]ページ先頭
©2009-2025 Movatter.jp