CREATE TABLE product_product ( id serial NOT NULL, create_uid integer, create_date timestamp without time zone, write_date timestamp without time zone, write_uid integer, ean13 character varying(13), -- EAN13 color integer, -- Color Index price_extra numeric, -- Variant Price Extra default_code character varying(64), -- Reference active boolean, -- Active variants character varying(64), -- Variants product_tmpl_id integer NOT NULL, -- Product Template product_image bytea, -- Image price_margin numeric, -- Variant Price Margin track_production boolean, -- Track Manufacturing Lots valuation character varying NOT NULL, -- Inventory Valuation track_outgoing boolean, -- Track Outgoing Lots track_incoming boolean, -- Track Incoming Lots removal_time integer, -- Product Removal Time use_time integer, -- Product Use Time alert_time integer, -- Product Alert Time life_time integer, -- Product Life Time advertencia_edad_minima numeric, -- Edad mínima cadena_frio boolean, -- Cadena de frio es_vacuna boolean, -- Es una vacuna atc_id integer, -- ATC reacciones_adversas text, -- Reacciones adversas via_administracion_id integer, -- Vía de administración primaría nivel_atencion_3 boolean, -- Nivel atención III advertencia_edad_maxima numeric, -- Edad máxima nivel_atencion_2 boolean, -- Nivel atención II nivel_atencion_1 boolean, -- Nivel atención I nivel_prescripcion_moved0 character varying, -- Nivel prescripción concentracion_id integer, -- Concentración advertencia_embarazo boolean, -- Contraindicado en el embarazo advertencia_edad boolean, -- Existen advertencias de riesgo en edades es_medicamento boolean, -- Es un medicamento notas text, -- Información extra forma_farmaceutica_id integer, -- Forma farmaceutica estupefaciente_sicotropico boolean, -- Estupefaciente presentacion_id integer, -- Envase/Presentación condiciones_almacenamiento text, -- Condiciones de almacenamiento categoria_embarazo integer, -- Categoría de riesgo embarazo uom_dispensacion integer, -- UdM dispensación price_promedio numeric, -- Precio Promedio es_dispositivo boolean, -- Es dispositivo ecri integer, -- Código UMDNS especialidad integer, -- Especialidad riesgo integer, -- Nivel de riesgo empaque_primario boolean, -- Empaque primario empaque_secundario boolean, -- Empaque secundario sinonimo character varying(128), -- Sinónimo envase_dispositivo_id integer, -- Presentación/Envase psicotropico boolean, -- Psicotrópico nivel_prescripcion integer, -- Nivel de prescripción estupefaciente boolean, -- Estupefaciente criterio_tecnico boolean, -- Criterio técnico aplicacion text, -- Aplicación name_template character varying(256), alerta_lactancia integer, -- Alerta lactancia nivel_atencion_1c boolean, -- Nivel atención I tipo C nivel_atencion_1b boolean, -- Nivel atención I tipo B contiene_mercurio boolean, -- Contiene Mercurio nivel_mercurio integer, -- Nivel de mercurio default_cnmb_code character varying(16), -- Referencia CNMB forma_farmac_cnmb_id integer, -- Forma Farmaceútica CNMB externalizacion boolean, -- Externalización tipo_ayuda_tecnica_id integer, -- Tipo Ayuda Técnica es_ay_tecnica boolean, -- Es ayuda técnica precio numeric, -- Precio Externalización CONSTRAINT product_product_pkey PRIMARY KEY (id), CONSTRAINT product_product_alerta_lactancia_fkey FOREIGN KEY (alerta_lactancia) REFERENCES sgi_alerta_lactancia (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE SET NULL, CONSTRAINT product_product_atc_id_fkey FOREIGN KEY (atc_id) REFERENCES sgi_atc (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE SET NULL, CONSTRAINT product_product_categoria_embarazo_fkey FOREIGN KEY (categoria_embarazo) REFERENCES sgi_categoria_embarazo (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE SET NULL, CONSTRAINT product_product_concentracion_id_fkey FOREIGN KEY (concentracion_id) REFERENCES sgi_concentracion (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE SET NULL, CONSTRAINT product_product_create_uid_fkey FOREIGN KEY (create_uid) REFERENCES res_users (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE SET NULL, CONSTRAINT product_product_ecri_fkey FOREIGN KEY (ecri) REFERENCES sgi_ecri (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE SET NULL, CONSTRAINT product_product_envase_dispositivo_id_fkey FOREIGN KEY (envase_dispositivo_id) REFERENCES sgi_envase_dispositivo (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE SET NULL, CONSTRAINT product_product_especialidad_fkey FOREIGN KEY (especialidad) REFERENCES sgi_servicio (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE SET NULL, CONSTRAINT product_product_forma_farmac_cnmb_id_fkey FOREIGN KEY (forma_farmac_cnmb_id) REFERENCES sgi_forma_farmac_cnmb (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE SET NULL, CONSTRAINT product_product_forma_farmaceutica_id_fkey FOREIGN KEY (forma_farmaceutica_id) REFERENCES sgi_forma_farmaceutica (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE SET NULL, CONSTRAINT product_product_presentacion_id_fkey FOREIGN KEY (presentacion_id) REFERENCES sgi_envase (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE SET NULL, CONSTRAINT product_product_product_tmpl_id_fkey FOREIGN KEY (product_tmpl_id) REFERENCES product_template (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE, CONSTRAINT product_product_riesgo_fkey FOREIGN KEY (riesgo) REFERENCES sgi_riesgo_dispositivo (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE SET NULL, CONSTRAINT product_product_tipo_ayuda_tecnica_id_fkey FOREIGN KEY (tipo_ayuda_tecnica_id) REFERENCES sgi_tipo_ayuda_tecnica (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE SET NULL, CONSTRAINT product_product_uom_dispensacion_fkey FOREIGN KEY (uom_dispensacion) REFERENCES product_uom (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE SET NULL, CONSTRAINT product_product_via_administracion_id_fkey FOREIGN KEY (via_administracion_id) REFERENCES sgi_via_administracion (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE SET NULL, CONSTRAINT product_product_write_uid_fkey FOREIGN KEY (write_uid) REFERENCES res_users (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE SET NULL, CONSTRAINT product_product_default_code_unique UNIQUE (default_code) ) WITH ( OIDS=FALSE ); ALTER TABLE product_product OWNER TO openerp; GRANT ALL ON TABLE product_product TO openerp; GRANT SELECT ON TABLE product_product TO lectura; GRANT SELECT ON TABLE product_product TO esb_msp; GRANT SELECT ON TABLE product_product TO consulta; GRANT ALL ON TABLE product_product TO inven_lectu; GRANT SELECT ON TABLE product_product TO "wladimir.quijije"; GRANT SELECT ON TABLE product_product TO "diego.molina"; GRANT SELECT ON TABLE product_product TO "fausto.suarez"; COMMENT ON TABLE product_product IS 'Product'; COMMENT ON COLUMN product_product.ean13 IS 'EAN13'; COMMENT ON COLUMN product_product.color IS 'Color Index'; COMMENT ON COLUMN product_product.price_extra IS 'Variant Price Extra'; COMMENT ON COLUMN product_product.default_code IS 'Reference'; COMMENT ON COLUMN product_product.active IS 'Active'; COMMENT ON COLUMN product_product.variants IS 'Variants'; COMMENT ON COLUMN product_product.product_tmpl_id IS 'Product Template'; COMMENT ON COLUMN product_product.product_image IS 'Image'; COMMENT ON COLUMN product_product.price_margin IS 'Variant Price Margin'; COMMENT ON COLUMN product_product.track_production IS 'Track Manufacturing Lots'; COMMENT ON COLUMN product_product.valuation IS 'Inventory Valuation'; COMMENT ON COLUMN product_product.track_outgoing IS 'Track Outgoing Lots'; COMMENT ON COLUMN product_product.track_incoming IS 'Track Incoming Lots'; COMMENT ON COLUMN product_product.removal_time IS 'Product Removal Time'; COMMENT ON COLUMN product_product.use_time IS 'Product Use Time'; COMMENT ON COLUMN product_product.alert_time IS 'Product Alert Time'; COMMENT ON COLUMN product_product.life_time IS 'Product Life Time'; COMMENT ON COLUMN product_product.advertencia_edad_minima IS 'Edad mínima'; COMMENT ON COLUMN product_product.cadena_frio IS 'Cadena de frio'; COMMENT ON COLUMN product_product.es_vacuna IS 'Es una vacuna'; COMMENT ON COLUMN product_product.atc_id IS 'ATC'; COMMENT ON COLUMN product_product.reacciones_adversas IS 'Reacciones adversas'; COMMENT ON COLUMN product_product.via_administracion_id IS 'Vía de administración primaría'; COMMENT ON COLUMN product_product.nivel_atencion_3 IS 'Nivel atención III'; COMMENT ON COLUMN product_product.advertencia_edad_maxima IS 'Edad máxima'; COMMENT ON COLUMN product_product.nivel_atencion_2 IS 'Nivel atención II'; COMMENT ON COLUMN product_product.nivel_atencion_1 IS 'Nivel atención I'; COMMENT ON COLUMN product_product.nivel_prescripcion_moved0 IS 'Nivel prescripción'; COMMENT ON COLUMN product_product.concentracion_id IS 'Concentración'; COMMENT ON COLUMN product_product.advertencia_embarazo IS 'Contraindicado en el embarazo'; COMMENT ON COLUMN product_product.advertencia_edad IS 'Existen advertencias de riesgo en edades'; COMMENT ON COLUMN product_product.es_medicamento IS 'Es un medicamento'; COMMENT ON COLUMN product_product.notas IS 'Información extra'; COMMENT ON COLUMN product_product.forma_farmaceutica_id IS 'Forma farmaceutica'; COMMENT ON COLUMN product_product.estupefaciente_sicotropico IS 'Estupefaciente'; COMMENT ON COLUMN product_product.presentacion_id IS 'Envase/Presentación'; COMMENT ON COLUMN product_product.condiciones_almacenamiento IS 'Condiciones de almacenamiento'; COMMENT ON COLUMN product_product.categoria_embarazo IS 'Categoría de riesgo embarazo'; COMMENT ON COLUMN product_product.uom_dispensacion IS 'UdM dispensación'; COMMENT ON COLUMN product_product.price_promedio IS 'Precio Promedio'; COMMENT ON COLUMN product_product.es_dispositivo IS 'Es dispositivo'; COMMENT ON COLUMN product_product.ecri IS 'Código UMDNS'; COMMENT ON COLUMN product_product.especialidad IS 'Especialidad'; COMMENT ON COLUMN product_product.riesgo IS 'Nivel de riesgo'; COMMENT ON COLUMN product_product.empaque_primario IS 'Empaque primario'; COMMENT ON COLUMN product_product.empaque_secundario IS 'Empaque secundario'; COMMENT ON COLUMN product_product.sinonimo IS 'Sinónimo'; COMMENT ON COLUMN product_product.envase_dispositivo_id IS 'Presentación/Envase'; COMMENT ON COLUMN product_product.psicotropico IS 'Psicotrópico'; COMMENT ON COLUMN product_product.nivel_prescripcion IS 'Nivel de prescripción'; COMMENT ON COLUMN product_product.estupefaciente IS 'Estupefaciente'; COMMENT ON COLUMN product_product.criterio_tecnico IS 'Criterio técnico'; COMMENT ON COLUMN product_product.aplicacion IS 'Aplicación'; COMMENT ON COLUMN product_product.alerta_lactancia IS 'Alerta lactancia'; COMMENT ON COLUMN product_product.nivel_atencion_1c IS 'Nivel atención I tipo C'; COMMENT ON COLUMN product_product.nivel_atencion_1b IS 'Nivel atención I tipo B'; COMMENT ON COLUMN product_product.contiene_mercurio IS 'Contiene Mercurio'; COMMENT ON COLUMN product_product.nivel_mercurio IS 'Nivel de mercurio'; COMMENT ON COLUMN product_product.default_cnmb_code IS 'Referencia CNMB'; COMMENT ON COLUMN product_product.forma_farmac_cnmb_id IS 'Forma Farmaceútica CNMB'; COMMENT ON COLUMN product_product.externalizacion IS 'Externalización'; COMMENT ON COLUMN product_product.tipo_ayuda_tecnica_id IS 'Tipo Ayuda Técnica'; COMMENT ON COLUMN product_product.es_ay_tecnica IS 'Es ayuda técnica'; COMMENT ON COLUMN product_product.precio IS 'Precio Externalización'; -- Index: product_product_default_code_idx -- DROP INDEX product_product_default_code_idx; CREATE INDEX product_product_default_code_idx ON product_product USING gin (default_code COLLATE pg_catalog."default" gin_trgm_ops); -- Index: product_product_name_template_idx -- DROP INDEX product_product_name_template_idx; CREATE INDEX product_product_name_template_idx ON product_product USING gin (name_template COLLATE pg_catalog."default" gin_trgm_ops); -- Index: product_product_name_template_index -- DROP INDEX product_product_name_template_index; CREATE INDEX product_product_name_template_index ON product_product USING btree (name_template COLLATE pg_catalog."default"); -- Index: product_product_sinonimo_idx -- DROP INDEX product_product_sinonimo_idx; CREATE INDEX product_product_sinonimo_idx ON product_product USING gin (sinonimo COLLATE pg_catalog."default" gin_trgm_ops); -- Index: sgi_name_template -- DROP INDEX sgi_name_template; CREATE INDEX sgi_name_template ON product_product USING btree (name_template COLLATE pg_catalog."default"); -- Index: sgi_sinonimo -- DROP INDEX sgi_sinonimo; CREATE INDEX sgi_sinonimo ON product_product USING btree (sinonimo COLLATE pg_catalog."default");