bloodbank - Laravel Schema Designer

clients

id increments
timestamps timestamps
name string (50)
email string (50)
phone string
password string (50)
date_of_birth date
last_donation_date date
pin_code string
blood_type_id ^FK integer
city_id ^FK integer

blood_types

id increments
timestamps timestamps
name string (10)

governorates

id increments
timestamps timestamps
name string (50)

cities

id increments
timestamps timestamps
name string (50)
governorate_id ^FK integer

blood_type_client

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

posts

id increments
timestamps timestamps
title string (50)
content text
image string (255)
category_id ^FK integer

categories

id increments
timestamps timestamps
name string (50)

client_post

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

notifications

id increments
timestamps timestamps
title string (50)
content text
donation_request_id ^FK integer

client_notification

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

donation_requests

id increments
timestamps timestamps
name string (20)
hospital_name string (20)
city_id ^FK integer
phone integer
age integer
blood_type_id ^FK integer
bags_num integer
hospital_address string (50)
details text
latitude decimal (10,8)
longitude decimal (10,8)

settings

id increments
timestamps timestamps
notification_massage string (50)
about_app string (40)
phone integer
email string (50)
fb_link string (100)
tw_link string (100)
insta_link string (100)
play_store_url string (100)
app_store_url string (100)

contacts

id increments
timestamps timestamps
name string (50)
phone integer
email string (60)
subject string (40)
message text

client_governorate

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

tokens

id increments
timestamps timestamps
name string (255)
client_id ^FK integer

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