Appointment-System - Laravel Schema Designer

branches

id increments
timestamps timestamps
name string

clinics

id increments
branch_id ^FK bigInteger
name string
timestamps timestamps

doctors

id increments
name string
timestamps timestamps

clinic_doctor

id increments
clinic_id ^FK bigInteger
doctor_id ^FK bigInteger
timestamps timestamps

otp

id increments
phone string
code string
expires_at timestamp
timestamps timestamps

appointments

id increments
clinic_id ^FK bigInteger
doctor_id ^FK bigInteger
client_name string
phone string
payment_type string
national_number string
gender enum
status string
phone_verified boolean
birthdate date
start_date time
end_date time
date date
timestamps timestamps

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