bloodBank2 - Laravel Schema Designer

clients

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

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
category_id ^FK integer
title string
image string
content longText

categories

id increments
timestamps timestamps
name string

client_post

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

donation_request

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

notifications

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

client_notification

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

settings

id increments
timestamps timestamps
about_app longText
notification_setting_text text
phone string
email string
fb_link string
fw_link string
insta_link string

contacts

id increments
timestamps timestamps
name string
email string
phone integer
message longText
subject text

client_governorate

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

blood_type_client

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

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