BloodBank_2022 - Laravel Schema Designer

clients

id increments
name string
timestamps timestamps
phone string
email string
blood_type_id ^FK integer
d_o_b date
last_donation_date date
city_id ^FK integer
pin_code integer
api_toke string (60)
password string
blood_types enum

blood_types

id increments
timestamps timestamps
name string

cities

id increments
timestamps timestamps
name string
governorate_id ^FK integer

governorates

id increments
timestamps timestamps
name string

posts

id increments
timestamps timestamps
title string
content text
image string
category_id integer

client_post

id increments
timestamps timestamps
client_id ^FK integer
post_id ^FK integer

donation_requests

id increments
timestamps timestamps
patient_name string
patient_phone string
city_id integer
hospital_name string
blood_type_id ^FK integer
patient_age integer
bags_num integer
hospital_address string
details string
latitude decimal (10.8)
longitude decimal (10,8)

notifications

id increments
timestamps timestamps
title string
content text
donation_request_id integer
is_read boolean

client_notification

id increments
timestamps timestamps
is_read boolean
client_id ^FK integer
notification_id ^FK integer

settings

id increments
timestamps timestamps
notification_settings_text string
about_app string
phone string
email string
fb_link string
tw_link string
insta_link string

blood_type_client

id increments
timestamps timestamps
blood_type_id ^FK integer
client_id ^FK integer

client_governorate

id increments
timestamps timestamps
client_id ^FK integer
governorate_id ^FK integer

contacts

id increments
timestamps timestamps
name string
email string
phone string
subject string
message string

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