{"id":16492,"date":"2024-05-13T10:39:55","date_gmt":"2024-05-13T16:39:55","guid":{"rendered":"https:\/\/sada.services\/?p=16492"},"modified":"2024-05-13T11:14:24","modified_gmt":"2024-05-13T17:14:24","slug":"sigesa-oracle-machote-create-table-creacion-de-tabla","status":"publish","type":"post","link":"https:\/\/sada.services\/?p=16492","title":{"rendered":"SIGESA \/ Oracle: Machote create table \/ Creaci\u00f3n de Tabla"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>\/********************************************************\/\n\/********************************************************\/\n\/* VERIFICACI\u00d3N  EXISTENCIA TABLA                       *\/\n\/********************************************************\/\n\/********************************************************\/\nSELECT * FROM PRODUCTO_POAI;\n\n\/********************************************************\/\n\/********************************************************\/\n\/* CREACI\u00d3N DE TABLA                                    *\/\n\/********************************************************\/\n\/********************************************************\/\nCREATE TABLE \"PPI\".\"PRODUCTO_POAI\"\n(\n    \"ID_PRODUCTO_POAI\"              NUMBER (19,0)       NOT NULL ENABLE,\n    \"PLAN_OPERATIVO_ANUAL_INST\"     NUMBER (19,0)       NOT NULL ENABLE, \n    \"PROGRAMA_PRESUPUESTARIO\"       NUMBER(19,0)        NOT NULL ENABLE, \n    \"CODIGO\"                        NUMBER(10,0)        NOT NULL ENABLE, \n    \"DESCRIPCION\"                   VARCHAR2(4000 BYTE) NOT NULL ENABLE,\n    \"PRODUCTO_POAI_ORIGEN\"          NUMBER(19,0), \n    \n    \n    \/********************************************************\/\n    \/* CAMPOS: FRAMEWORK SDK-UNA                            *\/\n    \/********************************************************\/\n    \"FECHA_CREACION\"                DATE                NOT NULL ENABLE,\n    \"USUARIO_CREACION\"              NUMBER(19,0)        NOT NULL ENABLE,\n    \"FECHA_MODIFICACION\"            DATE                NOT NULL ENABLE,\n    \"USUARIO_MODIFICACION\"          NUMBER(19,0)        NOT NULL ENABLE,\n    \"VERSION\"                       NUMBER(19,0),\n    \"CAMPO_CONFIGURABLE\"            NUMBER(19,0),\n    \n    \/********************************************************\/\n    \/* LLAVE: PRIMARIA                                      *\/\n    \/********************************************************\/\n    CONSTRAINT \"PK_PRODUCTO_POAI\" PRIMARY KEY(\"ID_PRODUCTO_POAI\"),\n    \n    \/********************************************************\/\n    \/* LLAVE: FORANEAS                                      *\/\n    \/********************************************************\/\n    CONSTRAINT \"FK_PROD_POAI_POAI\"          FOREIGN KEY (\"PLAN_OPERATIVO_ANUAL_INST\")   REFERENCES \"PPI\".\"PLAN_OPERATIVO_ANUAL_INST\" (\"ID_PLAN_OPERATIVO_ANUAL_INST\") ENABLE, \n    CONSTRAINT \"FK_PROD_POAI_PROGA_PRESU\"   FOREIGN KEY (\"PROGRAMA_PRESUPUESTARIO\")\t    REFERENCES \"EPF\".\"PROGRAMA_PRESUPUESTARIO\" (\"ID_PROGRAMA_PRESUPUESTARIO\") ENABLE, \n    CONSTRAINT \"FK_PROD_POAI_OBJETI_POAI\"   FOREIGN KEY (\"PRODUCTO_POAI_ORIGEN\")\t    REFERENCES \"PPI\".\"PRODUCTO_POAI\" (\"ID_PRODUCTO_POAI\") ENABLE,\n      \n      \n    CONSTRAINT FK_PRO_POAI_USU_CRE FOREIGN KEY(USUARIO_CREACION)        REFERENCES SAS.USUARIO(ID_USUARIO),\n    CONSTRAINT FK_PRO_POAI_USU_MOD FOREIGN KEY(USUARIO_MODIFICACION)    REFERENCES SAS.USUARIO(ID_USUARIO),\n    CONSTRAINT FK_PRO_POAI_CAM_CON FOREIGN KEY(CAMPO_CONFIGURABLE)      REFERENCES SAS.CAMPO_CONFIGURABLE(ID_CAMPO_CONFIGURABLE)\n);\n\n\/********************************************************\/\n\/********************************************************\/\n\/* COMENTARIOS                                          *\/\n\/********************************************************\/\n\/********************************************************\/\nCOMMENT ON COLUMN \"PPI\".\"PRODUCTO_POAI\".\"ID_PRODUCTO_POAI\"              IS 'Identificador unico de la tabla.';\nCOMMENT ON COLUMN \"PPI\".\"PRODUCTO_POAI\".\"PLAN_OPERATIVO_ANUAL_INST\"     IS 'Id de la tabla PLAN_OPERATIVO_ANUAL_INST.';\nCOMMENT ON COLUMN \"PPI\".\"PRODUCTO_POAI\".\"PROGRAMA_PRESUPUESTARIO\"       IS 'Id de la tabla PROGRAMA_PRESUPUESTARIO.';\nCOMMENT ON COLUMN \"PPI\".\"PRODUCTO_POAI\".\"CODIGO\"                        IS 'Codigo del producto POAI.';\nCOMMENT ON COLUMN \"PPI\".\"PRODUCTO_POAI\".\"DESCRIPCION\"                   IS 'Descripcion del producto POAI.';\nCOMMENT ON COLUMN \"PPI\".\"PRODUCTO_POAI\".\"PRODUCTO_POAI_ORIGEN\"          IS 'Producto POAI del que se origina.';\nCOMMENT ON COLUMN \"PPI\".\"PRODUCTO_POAI\".\"FECHA_CREACION\"                IS 'Fecha cuando se creo el registro por primera vez.';\nCOMMENT ON COLUMN \"PPI\".\"PRODUCTO_POAI\".\"USUARIO_CREACION\"              IS 'Usuario que creo el registro por primera vez.';\nCOMMENT ON COLUMN \"PPI\".\"PRODUCTO_POAI\".\"FECHA_MODIFICACION\"            IS 'Fecha cuando se modifico el registro por ultima vez.';\nCOMMENT ON COLUMN \"PPI\".\"PRODUCTO_POAI\".\"USUARIO_MODIFICACION\"          IS 'Usuario que realizo la ultima modificacion del registro.';\nCOMMENT ON COLUMN \"PPI\".\"PRODUCTO_POAI\".\"CAMPO_CONFIGURABLE\"            IS 'Hace referencia a una tabla que tiene campos disponibles para utilizar de ser necesario.';\nCOMMENT ON COLUMN \"PPI\".\"PRODUCTO_POAI\".\"VERSION\"                       IS 'Version de la tabla.';\nCOMMENT ON TABLE \"PPI\".\"PRODUCTO_POAI\"                                  IS 'Tabla que guarda los productos POAI.';\n\n\n\/********************************************************\/\n\/********************************************************\/\n\/* SECUENCIA                                            *\/\n\/********************************************************\/\n\/********************************************************\/\nCREATE SEQUENCE \"PPI\".SQ_PRODUCTO_POAI START WITH 1 INCREMENT BY 1;\n\n\/********************************************************\/\n\/********************************************************\/\n\/* SINONIMOS                                            *\/\n\/********************************************************\/\n\/********************************************************\/\nCREATE PUBLIC SYNONYM PRODUCTO_POAI FOR \"PPI\".\"PRODUCTO_POAI\";\nCREATE PUBLIC SYNONYM SQ_PRODUCTO_POAI FOR PPI.SQ_PRODUCTO_POAI;\n\n\n\/********************************************************\/\n\/********************************************************\/\n\/* VERIFICACI\u00d3N  EXISTENCIA TABLA                       *\/\n\/********************************************************\/\n\/********************************************************\/\nSELECT * FROM PRODUCTO_POAI;\n\n\n\/********************************************************\/\n\/********************************************************\/\n\/* ELIMINAR TABLA                                       *\/\n\/********************************************************\/\n\/********************************************************\/\nDROP SEQUENCE \"PPI\".SQ_PRODUCTO_POAI;\nDROP PUBLIC SYNONYM PRODUCTO_POAI;\nDROP PUBLIC SYNONYM SQ_PRODUCTO_POAI;\nDROP TABLE \"PPI\".PRODUCTO_POAI;\n\n\/********************************************************\/\n\/********************************************************\/\n\/* GRANT PERMISOS SOBRE LA TABLA                        *\/\n\/********************************************************\/\n\/********************************************************\/\nGRANT SELECT, DELETE, UPDATE, INSERT ON PPI.PRODUCTO_POAI TO WWW_SIGESA;\nGRANT SELECT, ALTER ON PPI.SQ_PRODUCTO_POAI TO WWW_SIGESA;\nGRANT SELECT ON \"PPI\".\"PRODUCTO_POAI\" TO \"ANALISTA\", \"ANALISTA_SIGESA\";<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[519,443],"tags":[620,618,621,619],"class_list":["post-16492","post","type-post","status-publish","format-standard","hentry","category-oracle","category-sigesa","tag-crear-tabla","tag-create","tag-machote","tag-table"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/16492","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=16492"}],"version-history":[{"count":3,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/16492\/revisions"}],"predecessor-version":[{"id":16495,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/16492\/revisions\/16495"}],"wp:attachment":[{"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=16492"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=16492"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=16492"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}