edward_fleet_mgnr - Laravel Schema Designer

gas_prices

id increments
gas_type string (255)
gas_price float
gas_unit string (255)
dealer_id ^FK integer
timestamps timestamps
softDeletes softDeletes

city

id increments
city_name string (100)
state_id ^FK integer
country_id ^FK integer
dealer_id ^FK integer
timestamps timestamps
status tinyInteger
softDeletes softDeletes

state

id increments
state_abbr char (4)
state_name string
country_id integer
dealer_id ^FK integer
timestamps timestamps
softDeletes softDeletes

country

id increments
country_name string (255)
timestamps timestamps
softDeletes softDeletes
dealer_id ^FK integer

customer

id increments
first_name string (255)
middle_name string (255)
last_name string (255)
timestamps timestamps
softDeletes softDeletes
dob date

customer_address

id increments
customer_id ^FK integer
address mediumText
city_id ^FK integer
state_id ^FK integer
country_id ^FK integer
softDeletes softDeletes
timestamps timestamps

contact_type

id increments
contact_type string (255)
timestamps timestamps
softDeletes softDeletes
dealer_id ^FK integer

customer_contact_details

id increments
customer_id ^FK integer
contact_type_id ^FK integer
contact_value string (255)
timestamps timestamps
softDeletes softDeletes

customer_license_info

id increments
customer_id ^FK integer
license_number string (255)
license_issuing_state ^FK integer
license_expiry_date date
timestamps timestamps
softDeletes softDeletes

customer_cc_info

id increments
timestamps timestamps
softDeletes softDeletes
customer_id ^FK integer
cc_type string (255)
cc_name string (255)
cc_number string (255)
cc_cvc char (5)
cc_expiry date
vault_id string
cc_encrypt_value string

insurance_companies

id increments
insurance_company string (255)
timestamps timestamps
softDeletes softDeletes
dealer_id ^FK integer

vehicle_insurance_info

id increments
customer_id ^FK integer
insurance_company_id ^FK integer
state_id ^FK integer
policy_number string (255)
policy_expiry_date datetime
timestamps timestamps
softDeletes softDeletes

transmission_type

id increments
transmission_name string (255)
transmission_desc mediumText
dealer_id ^FK integer
timestamps timestamps
softDeletes softDeletes

vehicle_body_type

id increments
body_type string (255)
timestamps timestamps
softDeletes softDeletes
dealer_id ^FK integer

user_roles

id increments
role_name string (255)
timestamps timestamps
softDeletes softDeletes

users

id increments
first_name string (255)
last_name string (255)
role_id ^FK integer
password string (255)
user_image string (255)
created_by ^FK integer
created_date datetime
modified_by ^FK integer
modified_date datetime
timestamps timestamps
softDeletes softDeletes

user_contact_details

id increments
user_id ^FK integer
contact_value string (255)
created_by ^FK integer
created_date datetime
contact_type_id ^FK integer
modified_by ^FK integer
modified_date datetime
timestamps timestamps
softDeletes softDeletes

loaner_vehicle_info

id increments
car_name string (255)
car_series string (255)
make_year char (4)
body_type ^FK integer
license_number string (255)
transmission_type string (255)
car_description text
softDeletes softDeletes
timestamps timestamps

grounded_reason

id increments
reason string (255)
created_by ^FK integer
created_date datetime
timestamps timestamps
softDeletes softDeletes
dealer_id ^FK integer

vehicle_features

id increments
timestamps timestamps
softDeletes softDeletes
feature string (255)
dealer_id ^FK integer

loaner_threshold_criteria

id increments
loaner_vehicle_id ^FK integer
mileage integer
number_yrs_from_manufacturing smallInteger
manufacture_year date
softDeletes softDeletes
timestamps timestamps

users_break_timings

id increments
user_id ^FK integer
break_timing_1 time
break_timing_2 time
break_timing_3 time
break_timing_4 time
timestamps timestamps
softDeletes softDeletes
created_by ^FK integer
created_date datetime
modified_by ^FK integer
modified_date datetime

users_holiday_log

id increments
user_id ^FK integer
start_date datetime
end_date datetime
user_comments text
created_by ^FK integer
created_date datetime
modified_by ^FK integer
approved_by ^FK integer
softDeletes softDeletes
timestamps timestamps

loaner_vehicle_inventory

id increments
loaner_vehicle_id ^FK integer
vin string (255)
exterior_color string (255)
interior_color string (255)
license_plate_number string (255)
license_plate_state string (255)
plate_expiry_date string (255)
odometer_reading integer
tank_size float
transmission_type_id ^FK integer
loaner_vehicle_images text
current_status ^FK integer
car_images text
created_by ^FK integer
created_date datetime
modified_by ^FK integer
modified_date datetime
timestamps timestamps
softDeletes softDeletes

loaner_vehicle_status

id increments
timestamps timestamps
softDeletes softDeletes
status_name string (255)
dealer_id ^FK integer

loaner_vehicle_inventory_log

id increments
loaner_vehicle_inventory_id ^FK integer
loaner_vehicle_id integer
vin string (255)
exterior_color string (255)
interior_color string (255)
license_plate_number string (255)
license_plate_state string (255)
plate_expiry_date string (255)
odometer_reading integer
tank_size float
transmission_type_id integer
loaner_vehicle_images text
current_status integer
car_images text
created_by integer
created_date datetime
modified_by integer
modified_date datetime
timestamps timestamps
softDeletes softDeletes

loaner_vehicle_parking_details

id increments
loaner_vehicle_id ^FK integer
parking_number smallInteger
parking_location string
timestamps timestamps
softDeletes softDeletes
parked_by ^FK integer
parking_time datetime

loaner_vehicle_parking_details_log

id increments
loaner_vehicle_parking_details_id ^FK integer
loaner_vehicle_id integer
parking_number smallInteger
parking_location string
timestamps timestamps
softDeletes softDeletes
parked_by integer
parking_time datetime

loaner_agreement

id increments
agreement_id string (255)
customer_id ^FK integer
loaner_vehicle_id ^FK integer
checkout_date datetime
checkout_advisor_id ^FK integer
checkin_date datetime
checkin_advisor_id ^FK integer
softDeletes softDeletes
timestamps timestamps