Blood Bank - Laravel Schema Designer

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
cotent text
image string
post_category_id ^FK 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 ^FK integer
age integer
blood_type_id ^FK integer
hospital_address text
bags_num integer
latitude decimal (10,8)
longitude decimal (10,8)
client_id ^FK integer

post_categories

id increments
timestamps timestamps
name string

notifications

id increments
timestamps timestamps
title string
content string
donation_request_id ^FK integer

client_notification

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

settings

id increments
timestamps timestamps
notification_settings_text text
about text
phone string
email string
fb_link string
insta_link string
tw_link string
youtube_link string
message_title string
message text

clients

id increments
timestamps timestamps
name string
email string
password string
phone string (11)
last_donation_date date
d_o_b date
blood_type_id ^FK integer
city_id ^FK integer
pin_code string
allowed_blood_types_ids string
allowed_cities_ids string
api_token string (60)

contacts

id increments
timestamps timestamps
email string
phone string
message_title string
message text

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