reach - Laravel Schema Designer

offers

id increments
business_id ^FK integer
type string (64)
value string (64)
description text
campaign_id ^FK integer
influencer_id ^FK integer
data json
timestamps timestamps

posts

id increments
campaign_id integer
influencer_id integer
status string
type string (64)
name string (256)
description text
scheduled_at datetime
platform_provider string
platform_provider_id string (255)
timestamps timestamps
post_link text
data json

subscriptions

id increments
is_active tinyInteger
object_id integer
object_type string (64)
plan_id smallInteger
business_id ^FK integer
merchant_subscription_id string (500)
auto_expire tinyInteger
expires_on datetime
timestamps timestamps

businesses

id increments
business_name string (128)
email string (64)
phone_number string (64)
address_1 string (128)
address_2 string (64)
city string (64)
postal_code string (26)
owner_name string (64)
owner_email string (64)
owner_phone string (64)
poc_name string (64)
poc_email string (64)
poc_phone string (64)
website string
status string (64)
country_id ^FK integer
state_id ^FK integer
subscription_id ^FK integer
user_id ^FK integer
request_message text
merchant_customer_id string (128)
merchant_descriptor string (64)
softDeletes softDeletes
timestamps timestamps
data json

business_influencers_pivot

id increments
business_id ^FK integer
influencer_id integer

campaigns

id increments
name string (256)
description text
start_date datetime
end_date datetime
status string (28)
business_id ^FK integer
user_id ^FK integer
subscription string
post_count bigInteger
timestamps timestamps
data json

campaign_influencer_pivot

id increments
campaign_id ^FK integer
influencer_id integer

campaign_requests

id increments
business_id ^FK integer
campaign_id ^FK integer
influencer_id integer
requested_type string
payment_details string (256)
payment_status string
timestamps timestamps

connection_requests

id increments
business_id ^FK integer
influencer_id ^FK integer
requested_type string
requested_by_user_id ^FK integer
status string
request_message text
timestamps timestamps

influencers

id increments
timestamps timestamps
first_name string
last_name string
email string
phone_number string
address_1 string
address_2 string
city string
postal_code string (25)
status string
country_id ^FK integer
state_id ^FK integer
gender string
age integer
instagram_profile string
rating integer
user_id ^FK integer
data json

reviews

id increments
rating integer
comment text
object_type string
object_type_id integer
rated_on datetime
rated_by_user_id ^FK integer
data json
timestamps timestamps

keywords

id increments
name string
status string
created_by_user_id integer
updated_by_user_id integer
requested_by_user_id integer
requested_on datetime
requested_type string
timestamps timestamps

users

id increments
timestamps timestamps
email string

states

id increments
timestamps timestamps

countries

id increments
timestamps timestamps

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