bloodbank-training - Laravel Schema Designer

clients

id increments
timestamps timestamps
name string (50)
phone string (11)
email string (50)
password string
date_of_birth date
blood_type_id ^FK integer
last_donation_date date
city_id ^FK integer
pin_code string (5)

blood_types

id increments
timestamps timestamps
name string (20)

cities

id increments
timestamps timestamps
name string (150)
governorate_id ^FK integer

governorates

id increments
timestamps timestamps
name string (100)

posts

id increments
timestamps timestamps
title string
image string
content mediumText
category_id integer

categories

id increments
timestamps timestamps
name string

client_post

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

donation_requests

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

notifications

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

client_notification

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

settings

id increments
timestamps timestamps
notification_settings_text text
about_app mediumText
phone string
email string (50)
fb_link string
tw_link string
insta_link string
youtube_link string

blood_type_client

id increments
timestamps timestamps
client_id ^FK integer
blood_typy_id ^FK integer

client_governorate

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

contacts

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

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