Blood_App - Laravel Schema Designer

clients

id increments
timestamps timestamps
is_admin tinyInteger
password string
phone string
city_id ^FK bigInteger
blood_type_id ^FK bigInteger

posts

id increments
timestamps timestamps
title string
excerpt string
body string
image longText
client_id ^FK bigInteger
category_id ^FK bigInteger

categories

id increments
timestamps timestamps
title string
slug string

user_meta

id increments
timestamps timestamps
birth_date date
pin_code string
donation_finish_date date
client_id ^FK bigInteger

notifications

id increments
timestamps timestamps
title string
content string
date datetime
donation_id ^FK integer

donations

id increments
timestamps timestamps
name string
age string
blood_bags_num integer
phone string
notes string
hospital_longtitude decimal
hospital_latitude decimal
city_id ^FK bigInteger
blood_type_id ^FK bigInteger
client_id ^FK integer

governorates

id increments
timestamps timestamps
name string

cities

id increments
name string
timestamps timestamps
governorate_id ^FK bigInteger

contacts

id increments
timestamps timestamps
site_name string
user_phone string
user_mail string
subject string
from string

settings

id increments
timestamps timestamps
notification_text string
about_app string
app_phone string
app_email string
fb_link string
twitter_link string
insta_link string

blood_types

id increments
timestamps timestamps
title string

client_governate

id increments
timestamps timestamps
client_id ^FK bigInteger
governorate_id ^FK bigInteger

client_notification

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

client_post

id increments
timestamps timestamps
client_id ^FK bigInteger
post_id ^FK bigInteger

blood_type_client

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

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