bloodbank - Laravel Schema Designer

clients

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

blood_types

id increments
name string

governorates

id increments
name string

cities

id increments
name string
governorate_id bigInteger

posts

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

donation_requests

id increments
timestamps timestamps
name string
age bigInteger
blood_type_id integer
bags_count integer
hospital_name string
hospital_address string
latitude decimal (10,8)
longitude decimal (11,8)
city_id bigInteger
phone_number string
notes longText

notifications

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

categories

id increments
name string

app_settings

id increments
android_app_url string
phone_number string
email string
facebook_url longText
twitter_url longText
youtube_url longText
instagram_url longText
whatsapp_url longText
googleplus_url longText

contact_us

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

clientables

id increments
clientable_id integer
clientable_type string
seen boolean

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