Blood_Bank_project - Laravel Schema Designer

clients

id increments
timestamps timestamps
phone string
email string
name string
blood_type_id ^FK integer
password string
reset_code string (6)
last_donation_date date
d_o_b date
city_id ^FK integer
api_token string (60)

blood_types

id increments
timestamps timestamps
name string

governorates

id increments
name string
timestamps timestamps

cities

id increments
timestamps timestamps
name string
governorate_id ^FK integer

posts

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

categories

id increments
timestamps timestamps
name string

contacts

id increments
timestamps timestamps
email string
name string
phone string
subject string
message text

donation_requests

id increments
timestamps timestamps
patient_name string
patient_phone string
city_id ^FK integer
hospital_name string
Hospital_address string
blood_type_id ^FK integer
patient_age integer
details text
bags_num integer
latitude decimal (10,8)
longitude decimal (10,8)
client_id ^FK integer

notifications

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

settings

id increments
timestamps timestamps
notification_setting_text text
about_app text
phone string
email string
fb_link string
tw_link string
insta_link string
watts_link string
youtube_link string

clientables

id increments
client_id ^FK integer
clientable morphs
timestamps timestamps

tokens

client_id ^FK integer
platform string
token string
timestamps timestamps
id increments

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