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 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 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/Mutation | Description | Example |
---|---|---|
availableCars |
Fetch a list of available cars. | query { availableCars { id make model year ... } } |
car |
Get details of a specific car by ID. | query { car(id: 1) { id make model year ... } } |
user |
Retrieve details of a user by ID. | query { user(id: 2) { id name email ... } } |
booking |
Fetch details of a booking by ID. | query { booking(id: 5) { id user { name } car { make model } ... } } |
userBookings |
Get a list of bookings made by a specific user. | query { userBookings(userId: 3) { id car { make model } ... } } |
createBooking |
Create a new booking. | mutation { createBooking(input: { userId: 4 carId: 7 pickupDate: "2023-08-20" returnDate: "2023-08-25" }) { id user { name } car { make model } ... } } |
updateBooking |
Update an existing booking. | mutation { updateBooking(id: 8 input: { pickupDate: "2023-09-01" }) { id pickupDate returnDate ... } } |
cancelBooking |
Cancel a booking. | mutation { cancelBooking(id: 10) } |
carCategories |
Retrieve a list of available car categories. | query { carCategories { id name description ... } } |
carCategory |
Get details of a specific car category by ID. | query { carCategory(id: 3) { id name description ... } } |
addCar |
Add a new car to the system. | mutation { addCar(input: { make: "Toyota" model: "Corolla" year: 2023 ... }) { id make model ... } } |
updateCar |
Update car details. | mutation { updateCar(id: 5 input: { year: 2022 }) { id make model ... } } |
deleteCar |
Remove a car from the system. | mutation { deleteCar(id: 7) } |
addUser |
Register a new user. | mutation { addUser(input: { name: "John Doe" email: "john@example.com" ... }) { id name email ... } } |
updateUser |
Update user details. | mutation { updateUser(id: 9 input: { name: "Jane Smith" }) { id name email ... } } |
deleteUser |
Remove a user from the system. | mutation { deleteUser(id: 11) } |
addCarCategory |
Add a new car category. | mutation { addCarCategory(input: { name: "SUV" description: "Sport Utility Vehicle" ... }) { id name description ... } } |
updateCarCategory |
Update car category details. | mutation { updateCarCategory(id: 13 input: { description: "All-terrain vehicles" }) { id name description ... } } |
deleteCarCategory |
Remove a car category from the system. | mutation { deleteCarCategory(id: 15) } |
userLogin |
Authenticate a user. | mutation { userLogin(email: "john@example.com" password: "securepassword") { token user { name } ... } } |
userLogout |
Log out a user. | mutation { userLogout } |
allBookings |
Fetch a paginated list of all bookings. | query { allBookings(page: 2, perPage: 10) { totalPerPage currentPage lastPage data { id user { name } car { make model } ... } } } |
searchCars |
Search for cars based on specific criteria. | query { searchCars(keyword: "SUV", year: 2022) { id make model year ... } } |
bookingsByStatus |
Retrieve bookings based on their status. | query { bookingsByStatus(status: "pending") { id user { name } car { make model } ... } } |
totalRevenue |
Calculate the total revenue generated from bookings. | query { totalRevenue } |
cancelBooking |
Cancel a booking. | mutation { cancelBooking(id: 17) } |
userDashboard |
Fetch a user's dashboard statistics. | query { userDashboard(userId: 6) { totalBookings upcomingBookings revenue ... } } |
carAvailability |
Check the availability of a specific car for a given time period. | query { carAvailability(carId: 9 startDate: "2023-09-01" endDate: "2023-09-10") } |
extendBooking |
Extend the return date of a booking. | mutation { extendBooking(id: 19 newReturnDate: "2023-09-15") { id returnDate ... } } |
mostPopularCars |
Get a list of the most popular cars based on booking frequency. | query { mostPopularCars(limit: 5) { id make model bookingCount ... } } |
topUsers |
Retrieve the top users with the highest number of bookings. | query { topUsers(limit: 3) { id name totalBookings ... } } |
bookingsByCar |
Fetch all bookings for a specific car. | query { bookingsByCar(carId: 12) { id user { name } pickupDate returnDate ... } } |
carsByCategory |
Get a list of cars belonging to a specific category. | query { carsByCategory(categoryId: 4) { id make model ... } } |
totalBookingsByUser |
Count the total number of bookings made by a specific user. | query { totalBookingsByUser(userId: 8) } |
userLastBooking |
Retrieve the last booking made by a user. | query { userLastBooking(userId: 10) { id car { make model } ... } } |
carDetailsWithBookings |
Get car details along with their associated bookings. | query { carDetailsWithBookings(carId: 15) { id make model bookings { id pickupDate returnDate ... } } } |
bookingsBetweenDates |
Fetch bookings that fall within a specific date range. | query { bookingsBetweenDates(startDate: "2023-09-01" endDate: "2023-09-15") { id user { name } pickupDate returnDate ... } } |
deleteBooking |
Delete a booking by ID. | mutation { deleteBooking(id: 21) } |
addReview |
Add a review for a booked car. | mutation { addReview(input: { userId: 12 carId: 18 rating: 4 reviewText: "Great experience!" }) { id rating reviewText ... } } |
userReviews |
Retrieve reviews submitted by a user. | query { userReviews(userId: 14) { id car { make model } rating reviewText ... } } |
averageRatingForCar |
Calculate the average rating for a specific car. | query { averageRatingForCar(carId: 20) } |
highestRevenueCars |
Get a list of cars with the highest revenue generated. | query { highestRevenueCars(limit: 3) { id make model revenue ... } } |
upcomingBookings |
Fetch upcoming bookings for a specific user. | query { upcomingBookings(userId: 16) { id car { make model } pickupDate returnDate ... } } |
recentlyAddedCars |
Retrieve a list of recently added cars. | query { recentlyAddedCars(limit: 5) { id make model year ... } } |
bookingByUserAndCar |
Fetch a specific booking made by a user for a particular car. | query { bookingByUserAndCar(userId: 18 carId: 25) { id user { name } car { make model } ... } } |
mostActiveUsers |
Get a list of the most active users based on booking count. | query { mostActiveUsers(limit: 10) { id name totalBookings ... } } |
carsWithReviews |
Retrieve cars along with their associated reviews. | query { carsWithReviews(limit: 10) { id make model reviews { id user { name } rating ... } } } |
availableCarCategories |
Fetch a list of currently available car categories. | query { availableCarCategories { id name description ... } } |
carCategoryCars |
Get a list of cars belonging to a specific car category. | query { carCategoryCars(categoryId: 7) { id make model ... } } |
userTotalSpent |
Calculate the total amount spent by a specific user on bookings. | query { userTotalSpent(userId: 20) } |
userReviewsWithCars |
Retrieve user reviews along with the corresponding car details. | query { userReviewsWithCars(userId: 22) { id rating reviewText car { make model ... } } } |
bookingsWithReviews |
Get bookings along with their associated reviews. | query { bookingsWithReviews(limit: 5) { id user { name } car { make model } reviews { rating reviewText ... } } } |
highestRatedCars |
Fetch cars with the highest average ratings. | query { highestRatedCars(limit: 3) { id make model averageRating ... } } |
carsByMakeAndModel |
Search for cars based on make and model. | query { carsByMakeAndModel(make: "Honda", model: "Civic") { id year ... } } |
bookingsByDate |
Retrieve bookings made on a specific date. | query { bookingsByDate(date: "2023-09-15") { id user { name } car { make model } ... } } |
earliestBooking |
Fetch the earliest booking made by a user. | query { earliestBooking(userId: 24) { id car { make model } pickupDate returnDate ... } } |
bookingsWithUserAndCar |
Get bookings along with their associated user and car details. | query { bookingsWithUserAndCar(limit: 5) { id user { name email } car { make model } ... } } |
carsByYear |
Retrieve cars based on a specific manufacturing year. | query { carsByYear(year: 2022) { id make model ... } } |
bookingDetails |
Fetch detailed information about a specific booking. | query { bookingDetails(id: 27) { id user { name email } car { make model } pickupDate returnDate ... } } |
userByEmail |
Retrieve user details using their email address. | query { userByEmail(email: "jane@example.com") { id name ... } } |
mostBookedCar |
Get the car that has been booked the most. | query { mostBookedCar { id make model bookingCount ... } } |
carsByPriceRange |
Search for cars within a specific price range. | query { carsByPriceRange(minPrice: 500, maxPrice: 1000) { id make model price ... } } |
bookingsInMonth |
Retrieve bookings made within a specific month. | query { bookingsInMonth(year: 2023, month: 8) { id user { name } car { make model } ... } } |
userBookedCars |
Fetch a list of cars that a user has booked. | query { userBookedCars(userId: 26) { id make model ... } } |
carCategoryDetails |
Get detailed information about a specific car category. | query { carCategoryDetails(categoryId: 9) { id name description ... } } |
bookingRevenue |
Calculate the total revenue generated from a booking. | query { bookingRevenue(id: 29) } |
averageRatings |
Get the average ratings for all cars. | query { averageRatings { carId averageRating } } |
upcomingBookingsByCar |
Fetch upcoming bookings for a specific car. | query { upcomingBookingsByCar(carId: 31) { id user { name } pickupDate returnDate ... } } |
recentlyBookedUsers |
Retrieve a list of users who made recent bookings. | query { recentlyBookedUsers(limit: 5) { id name ... } } |
- 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