bloodApp - Laravel Schema Designer

clients

id increments
timestamps timestamps
name string (255)
email string (255)
bdate date
blood_type_id ^FK integer
last_donate_date date
city_id ^FK integer
phone string (255)
password string (255)

blood_types

id increments
timestamps timestamps
type string (255)

governorates

id increments
timestamps timestamps
name string (255)

cities

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

posts

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

donation_orders

id increments
timestamps timestamps
name string (255)
age integer
blood_count integer
hospital_address string (255)
phone string (255)
notes text
city_id ^FK integer
blood_type_id ^FK integer
client_id ^FK integer

settings

id increments
timestamps timestamps
phone string (255)
fb_link string (255)
insta_link string (255)
ytb_link string (255)
email string (255)
twitter_link string (255)
about_us_content mediumText
notification_settings_text text

contact_us_messages

id increments
timestamps timestamps
title string (255)
message text
client_id ^FK integer

client_post

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

notifications

id increments
timestamps timestamps
donation_order_id ^FK integer
title string
content text

categories

id increments
timestamps timestamps
name string

client_notification

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

blood_type_clinet

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

client_governorat

id increments
timestamps timestamps
client_id ^FK integer
Governorat_id ^FK integer

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