fbcampaigns - Laravel Schema Designer

campaigns

id increments
title string (255)
current boolean
start_datetime datetime
end_datetime datetime
background_desktop string (255)
background_mobile string (255)
share_img string (255)
share_title string (255)
share_content text
like_content text
like_page_id integer
timestamps timestamps
softDeletes softDeletes

campaign_stages

id increments
stage tinyInteger
content text
timestamps timestamps
softDeletes softDeletes

campaign_codes

id increments
campaign_id ^FK integer
campaign_code_parent_id integer
code string (255)
start_datetime datetime
end_datetime datetime
timestamps timestamps

participants

id increments
campaign_id integer
campaign_code_id integer
fb_user_id integer
fullname string (255)
email string (255)
phone string (255)
sky_optin boolean
partner_optin boolean
likes_pages string (255)
softDeletes softDeletes
timestamps timestamps

campaign_participants

id increments
campaign_id integer
participant_id integer
softDeletes softDeletes

campaign_stage_meta

id increments
campaign_stage_id integer
meta_key string (255)
meta_value string (255)

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