blood_bank - Laravel Schema Designer

clients

id increments
name string (25)
email string (45)
birth_of_date date
phone string (15)
password string (45)
blood_type_id integer
city_id integer
pin_code string (8)
timestamps timestamps
api_token string (255)

blood_types

id increments
name string (5)
timestamps timestamps

posts

id increments
title string (25)
body text
image text
category_id integer
timestamps timestamps

client_post

id increments
client_id integer
post_id integer
timestamps timestamps

governorates

id increments
name string (15)
timestamps timestamps

cities

id increments
name string (15)
governorate_id integer
timestamps timestamps

categories

id increments
name string (15)
timestamps timestamps

orders

id increments
patient_name string (15)
age integer
phone string (255)
blood_type_id integer
number_of_bags integer
hospital_name string (15)
latitude decimal (10,8)
longitude decimal (10,8)
governorate_id integer
city_id integer
notice text
timestamps timestamps

notifications

id increments
title string (255)
content text
order_id integer
timestamps timestamps

client_notification

id increments
client_id integer
notification_id integer
is_read tinyInteger
timestamps timestamps

blood_type_client

id increments
client_id integer
blood_type_id integer
timestamps timestamps

client_governorate

id increments
timestamps timestamps
client_id integer
governorate_id integer

settings

id increments
phone string (15)
email string (45)
about_app text
facebook_link string (100)
twitter_link string (100)
youtube_link string (100)
instagram_link string (100)
whatsapp_link string (100)
google_link string (100)
timestamps timestamps

contacts

id increments
name string (25)
email string (45)
phone string (11)
subject string (25)
message text
timestamps timestamps

tokens

id increments
client_id integer
token string (255)
type enum
timestamps timestamps

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