blood_bank - Laravel Schema Designer

users

id increments
name string
email string
birth_date date
last_donation_date date
phone string
password string
blood_type_id ^FK bigInteger
city_id ^FK bigInteger
timestamps timestamps

governorates

id increments
name string
timestamps timestamps

cities

id increments
name string
governorate_id ^FK bigInteger
timestamps timestamps

blood_types

id increments
name string
timestamps timestamps

posts

id increments
title string
content text
photo string
category_id bigInteger
timestamps timestamps

categories

id increments
name string
timestamps timestamps

post_user

id increments
user_id ^FK bigInteger
post_id ^FK bigInteger
timestamps timestamps

donation_requests

id increments
name string
age string
blood_type_id ^FK bigInteger
longitude decimal (10,8)
latitude decimal (10,8)
city_id ^FK bigInteger
phone string
notes text
hospital_name string
user_id ^FK bigInteger
timestamps timestamps

settings

id increments
phone string
email string
fb_url string
x_url string
app_store_url string
youtube_url string
about_app text
timestamps timestamps

contact_us

id increments
subject string
massage text
user_id ^FK bigInteger
timestamps timestamps

notifications

id increments
title string
massage text
timestamps timestamps
donation_request_id ^FK bigInteger

notification_user

id increments
user_id ^FK bigInteger
notification_id ^FK bigInteger
is_read boolean
timestamps timestamps

blood_type_user

id increments
user_id ^FK bigInteger
blood_type_id ^FK bigInteger
timestamps timestamps

governorate_user

id increments
user_id ^FK bigInteger
governorate_id ^FK bigInteger
timestamps timestamps

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