pockets-api - Laravel Schema Designer

users

id increments
email string (50)
password string (50)
name string (300)
social boolean
timestamps timestamps

notifications

id increments
pocket_id integer
payload string (50)
sender_id string (50)
receiver_id string (50)
pockets_name string (300)
isSharePocket boolean
isArchived boolean
isFriendRequest boolean
timestamps timestamps

pockets

id increments
user_id integer
name string (50)
currency string (50)
isShared boolean
isHistory boolean
timestamps timestamps

transactions

id increments
user_id integer
pocket_id integer
currency string (50)
value integer
isExpense boolean
date string (100)
timestamps timestamps
description string (300)

users_friend

id increments
user_id integer
user_friend_id integer
timestamps timestamps
accepted boolean

pockets_shared

id increments
user_id integer
pocket_id integer
friend_user_id integer
name string (50)
isHistory boolean
timestamps timestamps
softDeletes softDeletes

uploads

id increments
user_id integer
name string (50)
path string (100)
extension string (10)
timestamps timestamps
softDeletes softDeletes

user_devices

id increments
user_id integer
device_id string (150)
user_name string (150)
os string (50)
photo_url string (300)
timestamps timestamps

pocket_uploads

id increments
user_id integer
pocket_id integer
name string (200)
path string (300)
extension string (50)
timestamps timestamps
transaction_id integer

subtransactions

id increments
user_id integer
transaction_id integer
description string (300)
value string (200)
currency string (200)
isExpense boolean
date string (100)
timestamps timestamps

subtransaction_uploads

id increments
subtransaction_id integer
name string (300)
path string (300)
extension string (100)
timestamps timestamps

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