postgresql view

CREATE OR REPLACE VIEW articulo_view AS

SELECT --modelo
       mo.modelo_id AS id_modelo,
       mo.referencia,
       mo.codigo_proveedor,
       mo.nombre,
       mo.color,
       mo.tallaje,
       mo.observaciones,
       mo.id_usuario AS modelo_id_usuario,

       mo.pvp_recomendado,
       mo.precio_mayor,
       mo.dto_programacion,
       mo.dto_franquicia,
       mo.rappel,
       mo.precio_costo,
       mo.tipo_iva,

       mo.virtual,
       mo.talla_revisada,
       mo.tiene_stock,
       mo.unidades_bulto,
       mo.reponible_franquicias,
       mo.aviso_stock_minimo,
       mo.ignorar_reposicion_ventas,
       mo.importe_no_devuelto_tpv,
       mo.ocultar_en_web,
       mo.tarifas_revisadas,

       --seccion
       mo.id_seccion AS id_seccion,
       sec.nombre AS seccion,
       sec.time_stamp_modificacion AS seccion_ts_modi,
       sec.aviso_venta AS seccion_aviso_venta,

       --lineal
       mo.id_lineal AS id_lineal,
       lineal.nombre AS lineal,
       lineal.descripcion AS lineal_desc,
       lineal.time_stamp_modificacion AS lineal_ts_modi,

       --tipo de repo
       mo.id_tipo_reposicion,
       rep.nombre AS tipo_reposicion_int,
       rep.nombre_mostrar AS tipo_reposicion,
       rep.inicio_repo AS tipo_reposicion_inicio,
       rep.fin_repo AS tipo_reposicion_fin,

       --marca
       mo.id_marca,
       ma.nombre AS marca,
       ma.creacion_franquicia AS marca_creacion_franquicia,
       ma.cbr_prefijo AS marca_cbr_prefijo,
       ma.codigo AS marca_codigo,

       --familia
       fam.familia_id AS id_familia,
       fam.nombre AS familia,
       fam.codigo AS familia_codigo,
       fam.id_seccion AS familia_id_seccion,
       fam.time_stamp_modificacion AS familia_ts_modi,
       fam.descripcion AS familia_desc,

       --subfamilia
       mo.id_subfamilia,
       subfam.nombre AS subfam,
       subfam.hasta AS subfam_hasta,
       subfam.id_seccion AS subfam_id_seccion,
       subfam.time_stamp_modificacion AS subfam_ts_modi,
       subfam.descripcion AS subfam_desc,
       subfam.aviso_venta AS subfam_aviso_venta,

       --genero
       subfam.id_genero,
       gen.nombre AS genero_nombre,
       gen.time_stamp_modificacion AS gen_ts_modi,

       --actividad
       subfam.id_actividad,
       act.nombre AS actividad,
       act.time_stamp_modificacion AS actividad_ts_modi,
       act.descripcion AS actividad_desc,

       --temporada
       mo.id_temporada,
       temp.nombre AS temporada,
       temp.fecha_inicio AS temporada_fecha_inicio,
       temp.fecha_final AS temporada_fecha_final,
       temp.tipo_temporada AS temporada_tipo,
       temp.time_stamp_modificacion AS temporada_ts_modi,
       temp.creacion_franquicia AS temporada_creacion_franquicia,
       temp.descripcion AS temporada_desc,
       temp.id_empresa_matriz_intragrupo AS temporada_id_empresa_matriz_intragrupo,

       --articulo
       art.articulo_id AS id_articulo,
       art.talla AS talla,
       art.time_stamp_creacion AS articulo_ts_crea,
       art.id_usuario AS articulo_id_usuario,
       art.codigo_barras,
       art.codigo_barras_proveedor,
       art.talla_aprobada,
       art.time_stamp_modificacion AS articulo_ts_modi,

       --talla
       tal.descripcion AS talla_desc,
       tal.time_stamp_modificacion AS talla_ts_modi,
       tal.orden_talla

FROM modelo AS mo
  JOIN modelo_seccion AS sec ON sec.seccion_id = mo.id_seccion
  JOIN modelo_marca AS ma ON ma.marca_id = mo.id_marca
  JOIN modelo_temporada AS temp ON temp.temporada_id = mo.id_temporada
  JOIN modelo_lineal AS lineal ON lineal.lineal_id = mo.id_lineal
  JOIN modelo_tipo_reposicion AS rep ON rep.tipo_id = mo.id_tipo_reposicion

  JOIN modelo_subfamilia AS subfam ON subfam.subfamilia_id = mo.id_subfamilia
  JOIN modelo_familia AS fam ON fam.familia_id = subfam.id_familia
  JOIN modelo_genero AS gen ON gen.genero_id = subfam.id_genero
  JOIN modelo_actividad AS act ON act.actividad_id = subfam.id_actividad

  JOIN articulo AS art ON art.id_modelo = mo.modelo_id
  JOIN articulo_talla AS tal ON tal.nombre = art.talla;