The Cars table shows the inventory for the entire dealership. It defines the brand and model of a car together with other relevant characteristics. Cars can be purchased through the web application where customer can make an offer - using a financing option - to a certain car. These offers are stored in a separate table and taking under consideration of a sales man.

A car is only sold once the offer is accepted and the customer is asked to write a review that can be published in the web application as a reference for future customers. The web application also has a contact page. All submissions from this page are stored in the Prospects table and followed up by a sales man.

The web application has two parts:

1. The open pages that do not require a login. This can be used to browse the catalog of cars and fill in the contact form.
2. The protected pages that require a login. These can be used to make an offer to a car or check ongoing offers through the profile page of the customer

Database: Car Dealership Inventory

Brands

Fields

• Name (Text)

• Models (Link to table)

• Count models (Count)

Views

• All brands (grid)

Models

Fields

• Model and variant (Text)

• Photo (File)

• Type (Single select)

• Engine size (L) (Number)

• Transmission (Single select)

• Fuel type (Single select)

• Seat count (Number)

• Body length (Number)

• Body width (Number)

• Body height (Number)

• In stock count (Formula)

• History count (Count)

• Related cars (Link to table)

• Year model (Number)

• Brand (Link to table)

Views

• All models (grid)

• All models grouped by brand (grid)

• All models grouped by type (grid)

• All models grouped by transmission (grid)

• All models grouped by fuel type (grid)

• Models with 1 car in stock (grid)

• Models with multiple cars in stock (grid)

• Models with no cars in stock (grid)

• All models (gallery)

Cars

Fields

• ID (Formula)

• Photo (File)

• Model (Link to table)

• Brand (Lookup)

• Year (Lookup)

• Condition (Single select)

• Mileage (Number)

• Color (Text)

• Breakeven cost (Number)

• Status (Formula)

• Offers (Link to table)

• Profit margin (Number)

• Suggested price (Formula)

• Accessories (Long text)

• Plate number (Text)

• VIN (Text)

• Certificate of title (File)

• Date acquired (Date)

• Acquired by (Link to table)

• Branch (Link to table)

• Remarks (Long text)

• Actual profit (Formula)

• Engine number (Text)

• Accepted offer (Formula)

• Offers considered (Formula)

• Type (Lookup)

• Dimensions (Formula)

• Reviews (Link to table)

• Today (Formula)

Views

• All vehicles (grid)

• Available vehicles without considered offer(s) (grid)

• Available vehicles with considered offer(s) (grid)

• Available vehicles (grid)

• Sold vehicles (grid)

• All vehicles grouped by model (grid)

• All vehicles grouped by branch (grid)

• All vehicles grouped by status (grid)

• All vehicles grouped by branch and status (grid)

• All vehicles grouped by condition (grid)

• All vehicles gallery (gallery)

• All vehicles stacked by condition (kanban)

• Add vehicle (form)

Offers

Fields

• ID (Formula)

• Car (Link to table)

• Year (Lookup)

• Brand (Lookup)

• Model (Rollup)

• Color (Lookup)

• Date sold (Date)

• Date offer (Date)

• Price offer (Number)

• Customer (Link to table)

• Sold by (Link to table)

• Transaction docs (File)

• Reviews (Link to table)

• Financing (Link to table)

• Status (Single select)

• Price suggested (Lookup)

• Price difference (Formula)

• Branch (Rollup)

• Staff email (Rollup)

• Customer email (Rollup)

Views

• All offers (grid)

• All offers grouped by branch (grid)

• All offers grouped by car (grid)

• All offers grouped by car model (grid)

• Accepted offers (grid)

• Not accepted (yet) offers (grid)

• Offers under consideration (grid)

• Offers under consideration with offer > suggested (grid)

• Offers under consideration with offer < suggested (grid)

• Rejected offers (grid)

• All offers stacked by status (kanban)

Branches

Fields

• Name (Text)

• Photo (File)

• Address (Text)

• City (Text)

• Zip code (Text)

• Phone number (Phone number)

• Count staff (Count)

• Cars in stock (Formula)

• Related cars (Link to table)

• Related staff (Link to table)

• History count (Count)

• Email (Email)

Views

• All branches (grid)

• Branches (gallery)

Staff

Fields

• Name (Text)

• Photo (File)

• Role (Single select)

• Branch (Link to table)

• Related acquired cars (Link to table)

• Local extension number (Text)

• Phone number (Phone number)

• Email address (Email)

• Remarks (Long text)

• Related sales (Link to table)

• Count sales (Count)

• Count acquisitions (Count)

• Prospects (Link to table)

Views

• All staff (grid)

• All staff grouped by role (grid)

• All staff grouped by branch (grid)

• Staff members (gallery)

• Add staff member (form)

Customers

Fields

• Name (Text)

• Address (Text)

• City (Text)

• State (Text)

• Zip code (Text)

• Phone number (Phone number)

• Email address (Email)

• Remarks (Long text)

• Related offers (Link to table)

• Offers count (Count)

• Password (Password)

• Accepted offers (Formula)

• Considered offers (Formula)

• Rejected offers (Formula)

Views

• All customers (grid)

• All customers grouped by city (grid)

• Customers with considered offers (grid)

• Add customer (form)

Reviews

Fields

• Title (Text)

• Description (Long text)

• Stars (Single select)

• Score (Formula)

• Sale (Link to table)

• Customer name (Rollup)

• Created on (Created on)

• Created on (format) (Formula)

• Customer email (Rollup)

• Car (Link to table)

Views

• All reviews (grid)

• All reviews grouped by score (grid)

• All reviews grouped by customer (grid)

• Top reviews (grid)

Financing options

Fields

• Name (Text)

• Offers (Link to table)

• Count offers (Count)

• Count sales (Formula)

Views

• All financing options (grid)

Prospects

Fields

• Name (Text)

• Email (Email)

• Phone (Phone number)

• Message (Long text)

• Staff member (Link to table)

• Follow up (Single select)

• Created on (Created on)

Views

• All prospects (grid)

• All prospects grouped by email (grid)

• All prospects grouped by staff member (grid)

• All prospects stacked by Follow up (kanban)

Application: Car Dealership Web Application

shared

Data sources

• Maximum price

• Maximum milage

Homepage

Data sources

• All branches

• All financing

• Top reviews

• Our staff

Login

Data sources

Actions (event)

• open_page (after_login)

Profile

Data sources

• Customer details

• My accepted offers

• Not accepted (yet) offers

• My reviews

Actions (event)

• update_row (submit)

• update_row (submit)

• logout (click)

• open_page (click)

• notification (submit)

• notification (submit)

Contact

Data sources

Actions (event)

• create_row (submit)

• open_page (submit)

Contact confirmation

Data sources

• Get contact information

Cars

Data sources

• Our cars

• All models

Actions (event)

• open_page (submit)

Car details

Data sources

• Car details

Car offer

Data sources

• Car details

• Financing options

• Current offers

Actions (event)

• create_row (submit)

• open_page (submit)

Car offer confirmation

Data sources

• Car details

• Offer details

Car details without offer

Data sources

• Car details

Car details sold

Data sources

• Car details

• Offer details

Add review

Data sources

• Reviews

• Get sale details

Actions (event)

• create_row (submit)

• open_page (submit)