blood_bank - Laravel Schema Designer

clients

id increments
timestamps timestamps
name string
email string
password string
phone string
last_donation timestamp
blood_type string
date_of_birth date
token string

governorates

id increments
timestamps timestamps
name string

posts

id increments
timestamps timestamps
title string
image string
category_id ^FK integer

client_post

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

categories

id increments
timestamps timestamps
category_post string

donation_requests

id increments
timestamps timestamps
name string
age integer
blood_type string
quantity integer
hospital_name string
hospital_address string
latitude decimal (10,8)
longitude decimal (10,8)

notifications

id increments
timestamps timestamps
title string
body text

settings

id increments
timestamps timestamps
android_app_url string
phone string
email string
links string
about longText

blood_type_client

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

blood_types

id increments
timestamps timestamps
name string

client_governorate

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

contact_us

id increments
timestamps timestamps
name string
email string
phone string
subject string
content text

cities

id increments
timestamps timestamps
name string
governorate_id ^FK integer

client_notification

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

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