blood bank - Laravel Schema Designer

clients

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

categories

id increments
timestamps timestamps
name string

governorates

id increments
timestamps timestamps
name string

cities

id increments
timestamps timestamps
name string
governorate_id ^FK integer

blood_types

id increments
timestamps timestamps
name string

posts

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

donation_requests

id increments
timestamps timestamps
name string
phone bigInteger
age integer
bags integer
blood_type_id ^FK integer
hospital_name string
hospital_address string
latitude decimal (10,8)
longitude decimal (10,8)
city_id ^FK integer
details longText
client_id ^FK integer

notifications

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

client_notification

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

settings

id increments
timestamps timestamps
key string
value longText
type enum

contacts

id increments
timestamps timestamps
title string
content longText
client_id ^FK integer

blood_type_client

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

client_governorate

id increments
timestamps timestamps
client_id ^FK integer
governorate_id ^FK integer

client_post

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

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