dalia - Laravel Schema Designer

blood_types

id increments
timestamps timestamps
name string

clients

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

governorates

id increments
timestamps timestamps
name string

cities

id increments
timestamps timestamps
name string
governorate_id ^FK integer

posts

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

categories

id increments
timestamps timestamps
name string

client_post

timestamps timestamps
post_id ^FK integer
client_id ^FK integer

donation_requests

id increments
timestamps timestamps
patient_name string
patient_age string
blood_type_id ^FK integer
hospital_name string
hospital_address string
phone string
city_id ^FK integer
client_id ^FK integer
notes text
latitude string
longitude string
bags_num string

contacts

id increments
timestamps timestamps
subject string
message text
client_id ^FK integer

settings

id increments
timestamps timestamps
phone string
email string
facebook string
twitter string
insta string
youtube string
about_application text
play_store_url string
app_store_url string
notifications_text text

notifications

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

client_notification

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

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