aceituna_roulette - Laravel Schema Designer

prizes

id increments
timestamps timestamps
name string
description string
winner_moment_start datetime
winner_moment_end datetime
active boolean
delivered boolean
category_id ^FK integer

campaign

id increments
timestamps timestamps
name string
description text
date_start datetime
date_end datetime
participation_type tinyInteger
active boolean
only_facebook boolean
no_prize boolean
background string
url string
email_sender string
logo string
left_banner string
right_banner string
corporate_color string
background_roulette string
legal_text string
legal_color string
meta_title string
facebook_url string
meta_description string
company_id ^FK integer

participations

id increments
timestamps timestamps
participant_id ^FK integer
campaign_id ^FK integer
prize_id ^FK integer

participants

id increments
timestamps timestamps
email string
name string
postal_code string
city string
newsletter boolean

company

id increments
timestamps timestamps
name string

prize_category

id increments
timestamps timestamps
name string
no_prize boolean
img_url string
coupon boolean
order tinyInteger
campaign_id ^FK integer

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