bloodbank - Laravel Schema Designer

clients

id increments
name string
phone integer
email text
password text
d_o_b date
last_donation_date date
blood_type enum
pin_code integer
timestamps timestamps

posts

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

governorates

id increments
name string
timestamps timestamps

blood_types

id increments
name string (20)
timestamps timestamps

notifications

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

clientables

id increments
client_id integer
clientable_id integer
clientable_type string
is_read boolean
timestamps timestamps

cities

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

donation_requests

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

settings

id increments
notification_settings_text text
about_app text
phone string
email text
fb_link text
tw_link text
inst_link text
timestamps timestamps

contacts

id increments
phone integer
email text
msg-title string
msg_content string
timestamps timestamps

categories

id increments
name string
timestamps timestamps

tokens

id increments
timestamps timestamps
client_id ^FK integer
token text
type enum

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