bloodbank - Laravel Schema Designer

clients

id increments
timestamps timestamps
phone string (12)
name string (50)
email string (50)
password string (32)
pin_code integer
date_of_birth string (12)
city_id ^FK integer
client_post_id ^FK integer

governorates

id increments
timestamps timestamps
name string (32)

cities

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

posts

id increments
timestamps timestamps
title string (32)
body string
category_id ^FK integer
client_post_id ^FK integer

categories

id increments
timestamps timestamps
name string (32)

donation_requests

id increments
timestamps timestamps
quantity double
patient_name string (32)
blood_type_id ^FK integer
latitude decimal (10)
longitude decimal (8)

settings

id increments
fb_url string
notification_setting string
insta_url string
phone string
app_store_url string
play_store_url string
about_app text

contacts

id increments
timestamps timestamps
title string (50)
message text
phone string
name string

notifications

id increments
timestamps timestamps
title string (32)
body string
donation_request_id ^FK integer

client_notifications

id increments
timestamps timestamps
client_id integer
notification_id integer

blood_types

id increments
timestamps timestamps
name string

client_post

id increments
timestamps timestamps
client_id integer
post_id integer

blood_type_client

id increments
timestamps timestamps

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