water - Laravel Schema Designer

waterCustomer

id increments
title enum
firstName string (45)
lastName string (50)
email string (100)
mobileNumber string (20)
mainNumber string (20)
referanceCompanyId string (50)
numberName string (50)
addressOne string (250)
addressTwo string (250)
town string (50)
postcode string (10)
Archived boolean
insertOrigin enum
waterProviderId smallInteger
currentReading string (10)
currentReadDate date
previousRead string (20)
previousReadDate date
over16AndBillPayer boolean
marketing enum
security_password string (250)
timestamps timestamps

Users

id increments
uFirstName string (50)
uLastName string (100)
email string (100)
password string (255)
superAdmin boolean
active enum
remember_token rememberToken
Type enum
timestamps timestamps

Orders

id increments
customerId ^FK integer
productId ^FK integer
timestamps timestamps

bookings

id increments
waterCustId ^FK bigInteger
appointmentDate date
appointmentSlot smallInteger
appointment_number smallInteger
installerId ^FK integer
status enum
contactPreference enum
callReminderRequired enum
DoorKnockerId ^FK bigInteger
surveyId integer
channel enum
timestamps timestamps

Doorknocker

doorKnockerId ^FK integer
workPostId bigInteger
csvUploadDate date
customerId ^FK bigInteger
timestamps timestamps

answers

id integer
predefined_ans enum
sliderStart integer
sliderLength integer
Answer text
nextQuestionToShow integer
productsToShowFrom integer
productsToShowTo integer
weaStatus enum
surveyId ^FK bigInteger
timestamps timestamps

questions

id increments
questionText text
questionCategory enum
isDependent enum
weaStatus enum
weqDisplayOrder bigInteger
questionAreaId integer
timestamps timestamps

products

id increments
name string (255)
description text
waterSavingAmount bigInteger
moneySaved bigInteger
availability enum
timestamps timestamps

Installers

id increments
installerId ^FK bigInteger
installerWorkPostId ^FK bigInteger
timestamps timestamps
dateAvailability date
dateTimeSlot integer

workPostCodes

id increments
postcode string (10)
town string (255)

answerPivot

id increments
questionId ^FK integer
sliderVaildity boolean
feedbackQuestions boolean
waterQuestions boolean
timestamps timestamps

questionRoom

id increments
room string (250)
timestamps timestamps

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