blood-bank-9-2020 - Laravel Schema Designer

clients

id increments
timestamps timestamps
name string
email string
phone string
password string
d_o_b date
pin_code integer
last_donation_date date
city_id ^FK integer
blood_type_id ^FK integer

blood_types

id increments
timestamps timestamps
name string

cities

id increments
timestamps timestamps
name string
governorate_id ^FK integer

posts

id increments
timestamps timestamps
titile string
img string
content text
category_id ^FK integer

categories

id increments
timestamps timestamps
name string

client_post

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

donation_requests

id increments
timestamps timestamps
name string
age integer
blood_type_id ^FK integer
bags integer
hospital_address text
city_id ^FK integer
phone integer
details text
latitude decimal
longitude decimal
client_id ^FK integer

contacts

id increments
timestamps timestamps
subject string
massage text
client_id ^FK integer

settings

id increments
timestamps timestamps
notification_setting_post text
about_app text
phone string
email string
fs_link string
ins_link string
tw_link string
yt_link string

notifications

id increments
timestamps timestamps
titile string
content text
donation_requests_id ^FK integer

client_notification

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

governorates

id increments
timestamps timestamps
name string

client_governorate

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

tokens

id increments
timestamps timestamps
client_id ^FK integer

blood_type_client

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

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