mg_db - Laravel Schema Designer

Vehicles

id increments
timestamps timestamps
softDeletes softDeletes
Vid integer
Vin string (150)
CommissionNumber integer
ColourGroup string (150)
Colour string (150)
Model string (150)
ModelId integer
BodyStyle string (150)
VehicleClass string (150)
Description string (150)
ShortDescription string (150)
FuelType string (150)
Transmission string (150)
TransmissionType string (150)
EngineId ^FK integer
MonthlyPrice string (150)
UpholsteryId ^FK integer
EquipmentAdditional mediumText
RetailerId ^FK integer
MediaId ^FK integer
ConsumptionUrbanId ^FK integer
ConsumptionExtraUrbanId ^FK integer
ConsumptionCombinedId ^FK integer
EmissionUrban integer
EmissionExtraUrban integer
EmissionCombined integer
EnergyEfficiencyClassId ^FK integer
EmissionDirective string (150)
ProductRange string (150)
VehicleType string (150)
ChassisNumber string (150)
Line string (150)
ModelYear string (150)
SalesDescription string (150)
HasError boolean
IsAvailableOnline boolean
IsAvailableForReservationAtRetailer boolean
IsVehicleReserved boolean
IsAvailableForReservation boolean
IsOfferAvailable boolean
RetailPriceExVAT string (150)
ModelYearCode string (150)
OTR integer
Mileage integer
RetailPrice_IncVAT string (150)
IsVehicleReservationPending boolean

Model

id increments
timestamps timestamps
softDeletes softDeletes
name string (150)
description mediumText
image string (150)

Engines

id increments
timestamps timestamps
softDeletes softDeletes
Badge string (150)
CubicCapacity integer
Cyclinders integer
Kw integer
HorsePower float
Selected boolean

Retailer

id increments
timestamps timestamps
softDeletes softDeletes
description mediumText
city string (100)
distance integer
email string (150)
fax string (150)
googlemappostcode string (150)
gssnId string (150)
IsNewCarRetailer enum
isonline enum
IsUsedCarRetailer enum
Latitude double
Longitude double
PaymentServiceGuid string (150)
Phone string (150)
Postcode string (60)
ReservationsEnabled enum
RetailerGroupId string (150)
RetailerGroupName string (150)
Street string (150)
Website string (150)

Equipments

id increments
timestamps timestamps
softDeletes softDeletes
Code string (150)
Description string (150)

VehicleData

id increments
timestamps timestamps
softDeletes softDeletes
Description string (150)
Value string (150)

VehicleEquipment

id increments
timestamps timestamps
VehicleId ^FK integer
EquipmentId ^FK integer

VehicleVehicleData

id increments
timestamps timestamps
VehicleId ^FK integer
VehicleDataId ^FK integer

Medias

id increments
timestamps timestamps
softDeletes softDeletes
NoImage boolean
MainImageUrl string (150)
ImageCount integer

ThreeSixtyDegreeImageUrls

id increments
timestamps timestamps
MediaId ^FK integer
Url string (150)

VehicleImageUrls

id increments
timestamps timestamps
MediaId ^FK integer
Url string (150)

ThreeSixtyDegreeMobileImageUrls

id increments
timestamps timestamps
MediaId ^FK integer
Url string (150)

EnergyEfficiency

id increments
timestamps timestamps
softDeletes softDeletes
Color string (100)
Rating string (10)

ConsumptionUrban

id increments
timestamps timestamps
softDeletes softDeletes
Lkm integer
Mpg integer

ConsumptionExtraUrban

id increments
timestamps timestamps
softDeletes softDeletes
Lkm integer
Mpg integer

ConsumptionCombined

id increments
timestamps timestamps
Lkm integer
Mpg integer

Upholstery

id increments
timestamps timestamps
UpholsteryType string (150)
UpholsteryDescription string (150)

CustomerRequests

id increments
timestamps timestamps
softDeletes softDeletes
VehicleId ^FK integer
RetailerId ^FK integer
email string (150)
phone string (150)
FirstName string (150)
LastName string (150)
Title string (150)
Description text
ContactPreference string (150)
Address text
RequestType string (150)

Users

id increments
timestamps timestamps
softDeletes softDeletes
username string (150)
password string (150)
role string (150)
RetailerId ^FK integer

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01