bs360v2 - Laravel Schema Designer

users

id increments
name string
email string
photo string
email_verified_at datetime
password string
remember_token string
customer_id ^FK integer
timestamps timestamps
softDeletes softDeletes

customers

id increments
name string
slug string
email string
logo string
sponsorship_branding string
preview_logo string
prestream_display string
offline_image string
primary_colour string
secondary_colour string
override_actors_label string
override_places_label string
override_acts_label string
timestamps timestamps
softDeletes softDeletes

locations

id increments
name string
city string
country string
latitude string
longitude string
customer_id ^FK integer
timestamps timestamps
softDeletes softDeletes

events

id increments
name string
timezone string
start_date date
end_date date
media_base_url string
location_id ^FK integer
customer_id ^FK integer
timestamps timestamps
softDeletes softDeletes

places

id increments
name string
event_id ^FK integer
customer_id ^FK integer
timestamps timestamps
softDeletes softDeletes

acts

id increments
name string
status tinyInteger
date date
start_datetime datetime
end_datetime datetime
place_id ^FK integer
customer_id ^FK integer
timestamps timestamps
softDeletes softDeletes

teams

id increments
name string
colour string
logo string
customer_id ^FK integer
timestamps timestamps
softDeletes softDeletes

actors

id increments
name string
display_name string
number smallInteger
photo string
team_id ^FK integer
customer_id ^FK integer
timestamps timestamps
softDeletes softDeletes

camera_locations

id increments
name string
is_pip tinyInteger
customer_id ^FK integer
timestamps timestamps
softDeletes softDeletes

transmission_boxes

id increments
subdomain string
type string
stream_url string
customer_id ^FK integer
timestamps timestamps
softDeletes softDeletes

stream_url_endpoints

id increments
name string
url string
type string
customer_id ^FK integer
timestamps timestamps
softDeletes softDeletes

act_assigned_actors

id increments
act_assigned_data_id integer
team_id ^FK integer
customer_id ^FK integer
timestamps timestamps
softDeletes softDeletes

act_assigned_data

id increments
act_id ^FK integer
streamable_type string
streamable_id integer
assignable_type string
assignable_id integer
sort_order smallInteger
vod_url string
aws_medialive_channel_id text
customer_id ^FK integer
timestamps timestamps
softDeletes softDeletes

admins

id increments
name string
email string
photo string
timezone string
email_verified_at datetime
password string
remember_token string
timestamps timestamps
softDeletes softDeletes

act_configurations

id increments
debug boolean
debug_hls_in_console boolean
hide_console_output boolean
page_title string
use_cdn boolean
use_cdn_map_from string
use_cdn_map_to string
hide_pip_at_start boolean
pip_muted boolean
current_video_muted boolean
hide_main_audio boolean
hide_pip_audio boolean
hide_pip_video boolean
stretch_to_fit_hd_video boolean
stream_capacity_full boolean
show_spinner boolean
spin_horizontal smallInteger
spin_vertical smallInteger
password_required boolean
encoded_password string
secure_ref_url string
back_button_for_url json
buffer_debug boolean
resync_total_count_warning smallInteger
resync_check_freq smallInteger
resync_diff_allowance double (4,2)
max_loading_delay smallInteger
max_max_buffer_length smallInteger
placeholder_360_video string
placeholder string
brand_logo string
brand_color string
call_to_action_color string
favicon string
brand_name string
logo_max_height_mobile smallInteger
enable_camera_blankout boolean
network_error_placeholder string
fov_desktop smallInteger
fov_mobile_portrait smallInteger
fov_mobile_landscape smallInteger
zoom_mobile_portrait smallInteger
show_ads boolean
act_id ^FK bigInteger
customer_id ^FK bigInteger
timestamps timestamps
config_event_id ^FK bigInteger
config_customer_id ^FK bigInteger

player_ads

id increments
timestamps timestamps
title string
start_time smallInteger
stream_url string
show_brand_logo boolean
play_once boolean
allow_video_scrub boolean
hide_skip_ad_button boolean
show_ad_skip_seconds smallInteger
notice_text string
stretch_to_fit_hd_video boolean
act_id ^FK bigInteger
customer_id ^FK bigInteger

incidents

id increments
timestamps timestamps
type string
stream_enabled boolean
act_assigned_data_id ^FK bigInteger