easi_ground - Laravel Schema Designer

users

id increments
firstname string (50)
rememberToken rememberToken
lastname string (50)
email string (50)
password string (100)
phone string
phoneVerify enum
verificationCode string (10)
status enum
user_organization_id integer
primaryRole string (20)
softDeletes softDeletes
timestamps timestamps

user_profiles

id increments
user_id ^FK integer
profileImage string (50)
dob date
licenceNo string (50)
city string (50)
state string (50)
zipcode integer
homePhone string (20)
emgContactName string (50)
emgContactNo string (20)
timestamps timestamps
softDeletes softDeletes

user_organizations

id increments
user_id ^FK integer
organization_id integer
status enum
isprimary enum
role enum
timestamps timestamps
softDeletes softDeletes

organizations

id increments
organizationName string (50)
city string (50)
state string (50)
zipcode integer
officePhone string (20)
lat string (20)
long string (20)
timestamps timestamps
softDeletes softDeletes

customers

id increments
organization_id ^FK integer
mainContact string (50)
street string (50)
city string (50)
state string (50)
zipcode integer
email string (50)
website string (100)
m_f_start date
m_f_end date
sat_start date
sat_end date
sun_start date
sun_end date
accountType enum
accountStanding enum
status enum
timestamps timestamps
softDeletes softDeletes

organization_details

id increments
organization_id ^FK integer
account_id integer
paymentType enum
orgLink text
serviceType enum
serviceLevel enum
remainingDelivery integer
pricing_id integer
rebate_id integer
freeDeliveryAmount double
freeDeliveryMiles integer
invoiceDays integer
brand string (50)
timestamps timestamps
softDeletes softDeletes

orders

id increments
user_id ^FK integer
organization_id ^FK integer
customer_id ^FK integer
driver_id ^FK integer
type enum
lineItems integer
isOversize enum
comments text
status enum
overallCapacity integer
invoiceAmount double
pickupETA datetime
DeliveryETA datetime
rating enum
timestamps timestamps
softDeletes softDeletes

oversizes

id increments
itemName string (50)
capacity integer
timestamps timestamps

pricings

id increments
timestamps timestamps
invoiceRange string (20)
percentage integer

rebates

id increments
timestamps timestamps
monthly_rate string (20)
percentage integer

invoices

id increments
organization_id ^FK integer
invoiceNo string (50)
invoiceTo datetime
invoiceFrom datetime
tax float
amount double
status enum
timestamps timestamps
softDeletes softDeletes

vehicles

id increments
organization_id integer
plateNo string (15)
city string (50)
year smallInteger
make string (30)
model string (30)
type string (50)
color string (20)
vin string (50)
mileage integer
fuel integer
mgp integer
capacity integer
stationed string (100)
owner string (50)
image text
lat string (20)
long string (20)
softDeletes softDeletes
timestamps timestamps

easiSettings

id increments
state_id integer
fuelCost double
handlingTime time
potentialDelivery integer
mileagePerDay integer
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer

drivers

id increments
user_id integer
vehicle_id integer
shiftStatus enum
lat string (20)
long string (20)
orderLists text
timestamps timestamps
softDeletes softDeletes

order_items

id increments
order_id ^FK integer
oversize_id ^FK integer

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