celebinfluencer - Laravel Schema Designer

campaigns

id increments
advertiser_id ^FK integer
name string
profile_photo_url string
description text
timestamps timestamps
softDeletes softDeletes

users

id increments
role string
username string
password string
escrow_balance float
name string
profile_photo_url string
email string
timestamps timestamps
softDeletes softDeletes

posts

id increments
influencer_id ^FK integer
campaign_id ^FK integer
content text
image_content_url string
likes integer
shares integer
favorites string
status string
comments integer
social_media_type_id ^FK integer
time_post timestamp
timestamps timestamps
softDeletes softDeletes

influencers

id increments
user_id ^FK integer
timestamps timestamps
softDeletes softDeletes

advertisers

id increments
user_id ^FK integer
company_address string
company_phone string
timestamps timestamps
softDeletes softDeletes

social_media

id increments
influencer_id ^FK integer
social_media_type_id ^FK integer
username string
c_key string
c_secret string
post_price float
followers integer
access_token string
access_token_s string
timestamps timestamps
softDeletes softDeletes

categories

id increments
name string
description string
timestamps timestamps
softDeletes softDeletes

post_history

id increments
post_id ^FK integer
description string
comment string
timestamps timestamps
softDeletes softDeletes

escrow_history

id increments
user_id ^FK integer
timestamps timestamps
softDeletes softDeletes

social_media_types

id increments
name string
url string
app_id string
timestamps timestamps
softDeletes softDeletes

notifications

id increments
user_id ^FK integer
post_id ^FK integer
timestamps timestamps
message string
status string

bank_accounts

id increments
user_id ^FK integer
bank_name string
account_number string
softDeletes softDeletes
timestamps timestamps

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