annoncements - Laravel Schema Designer

announcements

id increments
timestamps timestamps
softDeletes softDeletes
company_id integer
title string
content longText
start_date date
start_time time
urgency_level enum
schedule_option enum

announcement_brands

id increments
timestamps timestamps
softDeletes softDeletes
announcement_id ^FK integer
brand_id string

announcement_branches

id increments
timestamps timestamps
softDeletes softDeletes
announcement_id integer
branch_id string

announcement_members

id increments
timestamps timestamps
softDeletes softDeletes
announcement_id integer
member_id string

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