planeamiento - Laravel Schema Designer

distribuidoras

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
description string (255)
pais_id ^FK integer
code string (255)
tipo_distribuidora_id ^FK integer

peliculas

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
production_year integer
us_release date
us_release_observation text
genre text
director string (255)
cast text

solicitudes

id increments
timestamps timestamps
pelicula_id ^FK integer
pais_id ^FK integer
distribuidoras_id ^FK integer
tipo_solicitud_id ^FK integer

tipo_solicitudes

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
code string (255)
modulos_id ^FK integer

detalle_solicitudes

id increments
timestamps timestamps
softDeletes softDeletes
campo_solicitud_id ^FK integer
valor_detalle text
solicitud_id ^FK integer
is_null boolean
observations text

campos_solicitud

id increments
timestamps timestamps
softDeletes softDeletes
tipo_solicitud_id ^FK integer
tipo_campo_solicitud_id ^FK integer
nombre string (255)
parent_campo_solicitud_id integer
agrupador_campo_solicitud_id integer

tipo_campos_solicitudes

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)

estados_solicitudes

id increments
timestamps timestamps
solicitud_id ^FK integer
tipo_estado_solicitud_id ^FK integer
fecha date
softDeletes softDeletes
created_by integer
observations text

tipo_estados_solicitudes

id increments
timestamps timestamps
softDeletes softDeletes
code string (255)
name string (255)
final_state boolean
previous_state_id ^FK integer

notificaciones_solicitud

id increments
timestamps timestamps
softDeletes softDeletes
notificacion_id ^FK integer
solicitud_id ^FK integer
fecha date

notificaciones

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
tipo_estado_solicitud_id ^FK integer
description text
description_br text
description_es text
active boolean

destinatarios_notificaciones

id increments
timestamps timestamps
softDeletes softDeletes
notificacion_id ^FK integer
user_id integer
name string (255)
email string (255)

reportes

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
date date

tipo_reportes

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
code string (255)
route string (255)

destinatarios_reportes

id increments
timestamps timestamps
softDeletes softDeletes
reporte_id ^FK integer
user_id integer
name string (255)
email string (255)

modulos

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
route string (255)

lineup

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
year string (255)

bloques

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
active boolean

lineup_peliculas

id increments
timestamps timestamps
softDeletes softDeletes
pelicula_id ^FK integer
lineup_id integer
active boolean

bloques_peliculas

id increments
timestamps timestamps
softDeletes softDeletes
bloques_id ^FK integer
pelicula_id ^FK integer

tipo_distribuidoras

id increments
timestamps timestamps
softDeletes softDeletes
code string (255)
name string (255)

paises

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
code string (255)

liquidaciones

id increments
timestamps timestamps
softDeletes softDeletes
pelicula_id ^FK integer
tipo_liquidacion_id ^FK integer
name string (255)
description text

tipo_liquidaciones

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)

estado_liquidaciones

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)

detalle_liquidaciones

id increments
timestamps timestamps
softDeletes softDeletes
liquidaciones_id integer
valor text
label string (255)
distribuidora_id integer

taxes

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
percentage float (8,3)
pais_id ^FK integer

estado_liquidaciones_liquidaciones

id increments
timestamps timestamps
softDeletes softDeletes
liquidacion_id ^FK integer
estado_liquidacion_id integer

agrupador_campos_solicitudes

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
description text