blood_bank - Laravel Schema Designer

clients

id increments
name string
email string
phone string
password string
code string
b_o_d date
last_donation_date date
blood_type_id ^FK bigInteger
city_id bigInteger
timestamps timestamps

blood_types

id increments
name string
timestamps timestamps

cities

id increments
name string
governorate_id ^FK bigInteger
timestamps timestamps

governorates

id increments
name string
timestamps timestamps

posts

id increments
title string
description longText
image string
category_id ^FK bigInteger
timestamps timestamps

donation_requests

id increments
patient_name string
patient_phone string
patient_age string
blood_type_id ^FK bigInteger
bags_num string
hospital_name string
hospital_address string
latitude decimal (10,2)
longitude decimal (10,2)
city_id ^FK bigInteger
notes longText
client_id ^FK bigInteger
timestamps timestamps

settings

id increments
key string
value string
timestamps timestamps

categories

id increments
name string
timestamps timestamps

contacts

id increments
message_title string
message_content longText
client_id ^FK bigInteger
timestamps timestamps

notifications

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

clientables

client_id ^FK bigInteger
clientable_id bigInteger
clientable_type string

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