willo - Laravel Schema Designer

doctor

id increments
timestamps timestamps
firstName string (30)
lastName string (30)
email string (50)
phone string (20)
password string (50)
birthDate date
country string (50)
state string (50)
city string (50)
verifyAccount boolean
workingHoursSetting string (50)
gender boolean
professionalTitle string
fullProfessionalTitle string

consultation

id increments
timestamps timestamps
bookingId integer
patientDescription text
doctorDescription text
doctorRecommendation text
prescriptionImage string (100)
prescriptionRenewal boolean
prescriptionRenewalDate date

doctorBankAccounts

id increments
timestamps timestamps
doctorId integer
bankName string
AccountNumber string
beneficiaryName string

doctorWorkingHours

id increments
doctorId integer
timestamps timestamps
day string (30)
shiftStart time
shiftEnd time
examinationTime string

doctorCertificates

id increments
timestamps timestamps
doctorId integer
name string (50)
file text

doctorPlaceOfWork

id increments
timestamps timestamps
doctorId integer
name string
phone string
location text

specialty

id increments
timestamps timestamps
name string

doctorSpecialty

id increments
timestamps timestamps
doctorId integer
specialtyId integer

booking

id increments
timestamps timestamps
consultationId ^FK integer
patientId integer
doctorId ^FK integer
status string (50)
paymentMethod string
comment text

prescription

id increments
bookingId integer
timestamps timestamps
type string
name string
dosage string
validation string
note text

medicalRequest

id increments
timestamps timestamps
bookingId integer
name string
type string
reason text
note text
file string

doctorInsuranceCompany

id increments
timestamps timestamps
doctorId integer
name string

doctorConsultationInfo

id increments
timestamps timestamps
type string
cost string
duration string
doctorId integer

doctorAssistantInfo

id increments
timestamps timestamps
doctorId integer
name string
phone string

doctorPlaceOfWorkImages

id increments
timestamps timestamps
placeOfWorkId integer
image string

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