Open csrocha opened 11 years ago
Tabla «public.tb_prod_tecn»
id_prod_tecn | integer | nm_conc_nomi | character varying(30) | nm_limi_mini | character varying(20) | nm_limi_maxi | character varying(20) | id_ingr_ativ | integer |
Tabla «public.sgr_cqq»
id | integer | not null valor por omisión nextval('sgr_cqq_id_seq'::regclass) create_uid | integer | create_date | timestamp without time zone | write_date | timestamp without time zone | write_uid | integer | technical_product_registry_id | integer | ingredient_function_id | integer | not null uom_id | integer | ingredient_id | integer | not null component_registry_detail_id | integer | formulated_product_registry_id | integer | declared_concentration | numeric | max_concentration | numeric | max_uom_id | integer | min_concentration | numeric | min_uom_id | integer | Índices: "sgr_cqq_pkey" PRIMARY KEY, btree (id) Restricciones de llave foránea: "sgr_cqq_component_registry_detail_id_fkey" FOREIGN KEY (component_registry_detail_id) REFERENCES sgr_component_registry_detail(id) ON DELETE SET NULL "sgr_cqq_formulated_product_registry_id_fkey" FOREIGN KEY (formulated_product_registry_id) REFERENCES sgr_formulated_product_registry(id) ON DELETE SET NULL "sgr_cqq_ingredient_function_id_fkey" FOREIGN KEY (ingredient_function_id) REFERENCES sgr_ingredient_function(id) ON DELETE SET NULL "sgr_cqq_ingredient_id_fkey" FOREIGN KEY (ingredient_id) REFERENCES sgr_ingredient(id) ON DELETE CASCADE "sgr_cqq_max_uom_id_fkey" FOREIGN KEY (max_uom_id) REFERENCES product_uom(id) ON DELETE SET NULL "sgr_cqq_min_uom_id_fkey" FOREIGN KEY (min_uom_id) REFERENCES product_uom(id) ON DELETE SET NULL "sgr_cqq_technical_product_registry_id_fkey" FOREIGN KEY (technical_product_registry_id) REFERENCES sgr_technical_product_registry(id) ON DELETE SET NULL "sgr_cqq_uom_id_fkey" FOREIGN KEY (uom_id) REFERENCES product_uom(id) ON DELETE SET NULL Referenciada por: TABLE "sgr_scientific_namerel" CONSTRAINT "sgrscientific_name_rel_cqq_id_fkey" FOREIGN KEY (cqq_id) REFERENCES sgr_cqq(id) ON DELETE CASCADE
id_prod_tecn | integer | nm_conc_nomi | character varying(30) | nm_limi_mini | character varying(20) | nm_limi_maxi | character varying(20) | id_ingr_ativ | integer |
id | integer | not null valor por omisión nextval('sgr_cqq_id_seq'::regclass) create_uid | integer | create_date | timestamp without time zone | write_date | timestamp without time zone | write_uid | integer | technical_product_registry_id | integer | ingredient_function_id | integer | not null uom_id | integer | ingredient_id | integer | not null component_registry_detail_id | integer | formulated_product_registry_id | integer | declared_concentration | numeric | max_concentration | numeric | max_uom_id | integer | min_concentration | numeric | min_uom_id | integer | Índices: "sgr_cqq_pkey" PRIMARY KEY, btree (id) Restricciones de llave foránea: "sgr_cqq_component_registry_detail_id_fkey" FOREIGN KEY (component_registry_detail_id) REFERENCES sgr_component_registry_detail(id) ON DELETE SET NULL "sgr_cqq_formulated_product_registry_id_fkey" FOREIGN KEY (formulated_product_registry_id) REFERENCES sgr_formulated_product_registry(id) ON DELETE SET NULL "sgr_cqq_ingredient_function_id_fkey" FOREIGN KEY (ingredient_function_id) REFERENCES sgr_ingredient_function(id) ON DELETE SET NULL "sgr_cqq_ingredient_id_fkey" FOREIGN KEY (ingredient_id) REFERENCES sgr_ingredient(id) ON DELETE CASCADE "sgr_cqq_max_uom_id_fkey" FOREIGN KEY (max_uom_id) REFERENCES product_uom(id) ON DELETE SET NULL "sgr_cqq_min_uom_id_fkey" FOREIGN KEY (min_uom_id) REFERENCES product_uom(id) ON DELETE SET NULL "sgr_cqq_technical_product_registry_id_fkey" FOREIGN KEY (technical_product_registry_id) REFERENCES sgr_technical_product_registry(id) ON DELETE SET NULL "sgr_cqq_uom_id_fkey" FOREIGN KEY (uom_id) REFERENCES product_uom(id) ON DELETE SET NULL Referenciada por: TABLE "sgr_scientific_namerel" CONSTRAINT "sgrscientific_name_rel_cqq_id_fkey" FOREIGN KEY (cqq_id) REFERENCES sgr_cqq(id) ON DELETE CASCADE