sherpa_frontend - Laravel Schema Designer

campaign

id increments
timestamps timestamps
node_id ^FK integer
name string (255)

campaign_scheduled_item

id increments
timestamps timestamps
campaign_id ^FK integer
component_playlist_id ^FK integer
context enum
ordering integer
mode enum
date_from date
date_to date
time_from time
time_to time
dow tinyInteger
period smallInteger
size tinyInteger
priority tinyInteger
shuffle tinyInteger
immediate tinyInteger
music_spot_offset double (8,4)

component_playlist

id increments
timestamps timestamps
node_id ^FK integer
name string (255)
has_audio tinyInteger
has_video tinyInteger
has_stream tinyInteger

component_playlist_item

id increments
timestamps timestamps
component_playlist_id ^FK integer
library_file_id ^FK integer
ordering integer

component_program

id increments
timestamps timestamps
node_id ^FK integer
name string (255)
usage enum
shuffle tinyInteger

component_program_item

id increments
timestamps timestamps
component_program_id ^FK integer
component_playlist_id ^FK integer
multiplier tinyInteger
ordering integer

content

id increments
timestamps timestamps
node_id ^FK integer
mode enum
name string (255)

content_scheduled_item

id increments
timestamps timestamps
content_id ^FK integer
component_program_id ^FK integer
ordering integer
def tinyInteger
date_from date
date_to date
time_from time
time_to time
shuffle tinyInteger
dow tinyInteger

content_simple_item

id increments
timestamps timestamps
content_id ^FK integer
library_file_id ^FK integer

content_update

id increments
timestamps timestamps
node_id ^FK integer
name string (255)
audio_content_action enum
audio_content_id ^FK integer
audio_campaign_action enum
audio_campaign_id ^FK integer
video_content_action enum
video_content_id ^FK integer
video_campaign_action enum
video_campaign_id ^FK integer
stream_id ^FK integer
stream_action enum

library_category

id increments
timestamps timestamps
parent_id ^FK integer
node_id ^FK integer
ordering integer
name string (255)

library_file

id increments
timestamps timestamps
node_id ^FK integer
source enum
library_storage_file_id ^FK integer
url string (255)
content text
name string (255)
ext string (255)
size integer
md5 string (32)
mime string (50)
usage enum
albumart_id ^FK integer

library_file_category

id increments
timestamps timestamps
library_file_id ^FK integer
library_category_id ^FK integer

library_file_meta

id increments
timestamps timestamps
library_file_id ^FK integer
library_meta_id ^FK integer
value longText

library_meta

id increments
timestamps timestamps
name string

library_storage

id increments
timestamps timestamps
provider string (255)
config text
enabled tinyInteger

library_storage_file

id increments
timestamps timestamps
original_id ^FK integer
library_storage_file_variant_id ^FK integer
library_storage_id ^FK integer
name string (255)
ext string (255)
size integer
md5 string (32)
mime string (50)
usage enum
status enum
albumart_id ^FK integer

library_storage_file_meta

id increments
timestamps timestamps
library_storage_file_id ^FK integer
library_meta_id ^FK integer
value string

library_storage_file_variant

id increments
timestamps timestamps
audio_trim tinyInteger
audio_normalize tinyInteger
audio_bitrate smallInteger

node

id increments
timestamps timestamps
core_id string (255)
library_storage_id ^FK integer

stream

id increments
timestamps timestamps
node_id ^FK integer
name string (255)

stream_scheduled_item

id increments
timestamps timestamps
stream_id ^FK integer
component_playlist_id ^FK integer
ordering integer
def tinyInteger
date_from date
date_to string
time_from time
time_to time
dow tinyInteger
shuffle tinyInteger

albumart

id increments
timestamps timestamps
data binary
size integer
md5 string
mime string
ext string

menu

id increments
timestamps timestamps
parent_id ^FK integer
name string
icons string
routing string
ordering integer

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