bloodbanktask - Laravel Schema Designer

clients

id increments
name string (255)
phone string (20)
password string (255)
email string (255)
city_id ^FK integer
date_of_birth date
donation_date date
blood_type_id ^FK integer
timestamps timestamps

blood_types

id increments
blood_type string (255)

governorates

id increments
name string (255)

cityies

id increments
name string (255)
governorate_id ^FK integer

donation_requests

id increments
name string (255)
phone string (20)
age integer
blood_type_id ^FK integer
number_of_bags integer
message text
hospital_address_id ^FK integer
client_id ^FK integer
city_id ^FK integer

hospital_address

id increments
latitude decimal (10,8)
longitude decimal (10,8)

articles

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

categories

id increments
name string (255)
timestamps timestamps

article_client

id increments
client_id ^FK integer
article_id ^FK integer

notifications

id increments
title string (255)
message text
donation_request_id ^FK integer
timestamp timestamp

client_notification

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

settings

phone string (20)
email string (255)
facebook string (255)
instegram string (255)
twitter string (255)
youtube string (255)
about_as text

blood_type_client

id integer
client_id ^FK integer
blood_type_id ^FK integer

client_governorate

id increments
client_id ^FK integer
governorate_id ^FK integer

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