44 lines
2.4 KiB
SQL
44 lines
2.4 KiB
SQL
--------------------------------------------------------
|
|
-- DDL for Table DEPLOYMENT_REQUEST
|
|
--------------------------------------------------------
|
|
|
|
CREATE TABLE "ENVX_OPER"."DEPLOYMENT_REQUEST"
|
|
( "ID_REQUEST" NUMBER(*,0),
|
|
"ID_ENVIROMENT_TYPE" NUMBER(*,0),
|
|
"ID_DEPLOYMENT_TYPE" NUMBER(*,0),
|
|
"ID_SCHEDULE" NUMBER(*,0),
|
|
"ID_REQ_INSTANCE" NUMBER(*,0),
|
|
"CREATION_DATE" DATE,
|
|
"ID_USER_CREATE" VARCHAR2(100 BYTE),
|
|
"REQUEST_STATUS" VARCHAR2(50 BYTE),
|
|
"ID_LAST_SEQ_STEP" NUMBER(*,0),
|
|
"DATE_TIME_DEPLOY" DATE,
|
|
"ID_USER_UDP" NUMBER(*,0),
|
|
"LAST_UPDATE_DATE" DATE,
|
|
"USER_CREATE" VARCHAR2(100 BYTE),
|
|
"AOL" NUMBER DEFAULT 0,
|
|
"ID_PROJECT" NUMBER,
|
|
"USE_CASE" VARCHAR2(1000 BYTE),
|
|
"TITTLE" VARCHAR2(500 BYTE),
|
|
"ID_REQUEST_REF" NUMBER
|
|
) SEGMENT CREATION IMMEDIATE
|
|
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
|
|
NOCOMPRESS LOGGING
|
|
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
|
|
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
|
|
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
|
|
TABLESPACE "APEX_3800503980117141" ;
|
|
|
|
COMMENT ON COLUMN "ENVX_OPER"."DEPLOYMENT_REQUEST"."ID_REQUEST" IS 'Identificador ¿nico de la Solicitud de despliegue';
|
|
COMMENT ON COLUMN "ENVX_OPER"."DEPLOYMENT_REQUEST"."ID_ENVIROMENT_TYPE" IS 'Identificador del tipo de ambiente';
|
|
COMMENT ON COLUMN "ENVX_OPER"."DEPLOYMENT_REQUEST"."ID_DEPLOYMENT_TYPE" IS 'Identificador del tipo de despliegue';
|
|
COMMENT ON COLUMN "ENVX_OPER"."DEPLOYMENT_REQUEST"."ID_SCHEDULE" IS 'Identificador del Cronograma';
|
|
COMMENT ON COLUMN "ENVX_OPER"."DEPLOYMENT_REQUEST"."ID_REQ_INSTANCE" IS 'Identificador ¿nico de la instancia de proceso';
|
|
COMMENT ON COLUMN "ENVX_OPER"."DEPLOYMENT_REQUEST"."CREATION_DATE" IS 'Fecha de creaci¿n';
|
|
COMMENT ON COLUMN "ENVX_OPER"."DEPLOYMENT_REQUEST"."ID_USER_CREATE" IS 'Identificador del usuario creador de la orden';
|
|
COMMENT ON COLUMN "ENVX_OPER"."DEPLOYMENT_REQUEST"."REQUEST_STATUS" IS 'Estado de la ORDER de despliegue en el proceso';
|
|
COMMENT ON COLUMN "ENVX_OPER"."DEPLOYMENT_REQUEST"."ID_LAST_SEQ_STEP" IS 'Ultimo paso ejecutado en el flujo de trabajo';
|
|
COMMENT ON COLUMN "ENVX_OPER"."DEPLOYMENT_REQUEST"."DATE_TIME_DEPLOY" IS 'Fecha y Hora calculada para el despliegue';
|
|
COMMENT ON COLUMN "ENVX_OPER"."DEPLOYMENT_REQUEST"."LAST_UPDATE_DATE" IS 'Ultima actualizaci¿n del la Solicitud de Despliegue';
|
|
GRANT SELECT ON "ENVX_OPER"."DEPLOYMENT_REQUEST" TO "ENVX_AUDIT";
|