bloodbank - Laravel Schema Designer

clients

id increments
timestamps timestamps
name string (50)
email string (100)
birth_date date
blood_type_id integer
phone string (14)
password string (150)
code string (10)
api_token string (60)
city_id integer
government_id integer
remember_token string (100)

posts

id increments
timestamps timestamps
title string (100)
body text
img string (255)
category_id integer

orders

id increments
timestamps timestamps
name string (100)
age string (10)
blood_type_id integer
bags_num integer
hospital_name string (100)
hospital_address text
longitud decimal (10,8)
latitude decimal (10,8)
city_id integer
phone string (14)
client_id integer
description text

governments

id increments
timestamps timestamps
name string (100)

cities

id increments
timestamps timestamps
name string (100)
government_id integer
order_id integer

notifications

id increments
timestamps timestamps
body string (255)
title string
order_id integer

contacts

id increments
timestamps timestamps
name string (100)
email string (100)
phone string (14)
title string (100)
body text
is_read tinyInteger
deleted_at tinyInteger

client_notification

id increments
timestamps timestamps
client_id integer
notification_id integer
is_read tinyInteger

categories

id increments
timestamps timestamps
name string (100)

blood_types

id increments
timestamps timestamps
name string (100)

blood_type_client

id increments
timestamps timestamps
blood_type_id integer
client_id integer

client_post

id increments
timestamps timestamps
client_id integer
post_id integer

settings

id increments
timestamps timestamps
email string (100)
phone string (14)
facebook text
about_us text
terms_conditions text
twitter text
youtube text
whatsapp text
google_plus text
instagram text

tokens

id increments
client_id integer
token string
type enum
timestamps timestamps

client_government

id increments
timestamps timestamps
government_id integer
client_id integer

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