bloodbank - Laravel Schema Designer

clients

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

blood_types

id increments
timestamps timestamps
name string

cities

id increments
timestamps timestamps
name string
governorate_id ^FK integer

governorates

id increments
timestamps timestamps
name string

categories

id increments
timestamps timestamps
name string
image string
body string
category_id increments

donation_requests

id increments
timestamps timestamps
patient_name string
patient_phone string
hospital_name string
hospital_address string
patient_age integer
bages_num integer
notes string
latitude decimal (10,8)
longitude decimal (10,8)
city_id ^FK integer
blood_type_id ^FK integer
client_id ^FK integer

notifications

id increments
timestamps timestamps
tittle string
contant text
donation_request_id ^FK integer

settings

id increments
timestamps timestamps
notification_text text
about_app text
phone string
email string
fb_link string
tw_link string
instgram_link string
youtube_link string

contacts

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

posts

id increments
timestamps timestamps
name string
category_id string
body string

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