raya_clinic - Laravel Schema Designer

patient

id increments
user_id ^FK bigInteger
has_requested_vaccine boolean
qr_code_link longText

vaccination_date_slot

id increments
vaccine_id ^FK bigInteger
vaccination_location_id ^FK bigInteger
name string (100)
slot_date date
dose_no integer

vaccinication_center

id increments
name string (100)
address longText
city string
postal_code string (6)

vaccine

id increments
name string (100)
details text
max_cooling_period_days integer
min_cooling_period_days integer
batch_no bigInteger
vaccine_manufacturer string (200)

document

id increments
doc_type enum
patient_id ^FK bigInteger
link string (256)
name string (255)

assigned_vaccination_slot

id increments
patient_id ^FK bigInteger
vaccination_time_slot_id ^FK bigInteger
is_assgined boolean
is_reschedule boolean
step1_verification boolean
step2_verification boolean

medical_history

id increments
medical_data json
remarks text
is_verified boolean
is_saved boolean
is_submitted boolean
verified_by bigInteger
patient_id ^FK bigInteger

ceir_detail

id increments
priority_group enum
sub_priority_group string
firstname string (100)
lastname string (100)
middlename string (100)
suffix string (100)
contact_no string (50)
email string (100)
region string (100)
province string (100)
city string (100)
barangay string (100)
gender string (100)
date_of_birth date
occupation string (100)
has_allergy boolean
has_commorbidity boolean
patient_id ^FK bigInteger
verified_by bigInteger
is_verified boolean
upload_by string (50)

users

id increments
firstname string (255)
lastname string (255)
email string (255)
mobile string (31)
password string (255)
reset_token string (512)
token_date date
is_active boolean
gender string (15)
user_type enum
date_of_birth date

questions

id increments
name longText
is_active boolean
question_tags json
type string (255)

vaccination_time_slot

id increments
from_time time
to_time time
vaccination_slotdate_id bigInteger
patient_ids bigInteger
max_allowed_patients integer

patient_vaccination_detail

id increments
patient_id ^FK bigInteger
injected_arm enum
vaccinator_signature_link longText
patient_signature_link longText
vaccination_time_slot ^FK bigInteger

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