blood_system_design2 - Laravel Schema Designer

clients

id increments
timestamps timestamps
name string
phone string
email string
pin_code string
d_o_b date
blood_type_id ^FK integer
last_donation_data date
city_id ^FK integer
password string
access_token string (60)

blood_types

id increments
timestamps timestamps
name string

cities

id increments
timestamps timestamps
name string
governorate_id ^FK integer

posts

id increments
timestamps timestamps
title string
image string
content string
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

donations_requests

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

notifications

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

client_notification

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

settings

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

blood_types_clients

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

timestamps timestamps
phone string
email string
subject string
massage string
id increments

governorates

id increments
timestamps timestamps
name string

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