🏠 Menú principal

← Volver a tablas

---

LACLS.LACLS_CO_LOGS_MONITORING

Base de datos origen: PDB1

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	MONITORING_ID	NUMBER	NO
2	INSTANCE_ID	VARCHAR2(200)	SI
3	NAME_FLOW	VARCHAR2(240)	NO
4	DESCRIPTION	VARCHAR2(360)	NO
5	PARAMS	VARCHAR2(4000)	SI
6	START_DATE	DATE	NO
7	END_DATE	DATE	SI
8	STATUS	VARCHAR2(20)	SI
9	MESSAGE	VARCHAR2(4000)	SI
10	CREATION_DATE	DATE	NO
11	CREATED_BY	VARCHAR2(65)	NO
12	LAST_UPDATE_DATE	DATE	NO
13	LAST_UPDATED_BY	VARCHAR2(65)	NO
14	SHORT_MESSAGE	VARCHAR2(360)	SI

Restricciones

CHECK: SYS_C0014536

• Estado: ENABLED
• Columnas: MONITORING_ID
• Condición: "MONITORING_ID" IS NOT NULL

CHECK: SYS_C0014537

• Estado: ENABLED
• Columnas: NAME_FLOW
• Condición: "NAME_FLOW" IS NOT NULL

CHECK: SYS_C0014538

• Estado: ENABLED
• Columnas: DESCRIPTION
• Condición: "DESCRIPTION" IS NOT NULL

CHECK: SYS_C0014539

• Estado: ENABLED
• Columnas: START_DATE
• Condición: "START_DATE" IS NOT NULL

CHECK: SYS_C0014540

• Estado: ENABLED
• Columnas: CREATION_DATE
• Condición: "CREATION_DATE" IS NOT NULL

CHECK: SYS_C0014541

• Estado: ENABLED
• Columnas: CREATED_BY
• Condición: "CREATED_BY" IS NOT NULL

CHECK: SYS_C0014542

• Estado: ENABLED
• Columnas: LAST_UPDATE_DATE
• Condición: "LAST_UPDATE_DATE" IS NOT NULL

CHECK: SYS_C0014543

• Estado: ENABLED
• Columnas: LAST_UPDATED_BY
• Condición: "LAST_UPDATED_BY" IS NOT NULL

PK: LACLS_CO_LOGS_MONITORING_PK

• Estado: ENABLED
• Columnas: MONITORING_ID

DDL

CREATE TABLE "LACLS"."LACLS_CO_LOGS_MONITORING" 
   (	"MONITORING_ID" NUMBER NOT NULL ENABLE, 
	"INSTANCE_ID" VARCHAR2(200), 
	"NAME_FLOW" VARCHAR2(240) NOT NULL ENABLE, 
	"DESCRIPTION" VARCHAR2(360) NOT NULL ENABLE, 
	"PARAMS" VARCHAR2(4000), 
	"START_DATE" DATE NOT NULL ENABLE, 
	"END_DATE" DATE, 
	"STATUS" VARCHAR2(20), 
	"MESSAGE" VARCHAR2(4000), 
	"CREATION_DATE" DATE NOT NULL ENABLE, 
	"CREATED_BY" VARCHAR2(65) NOT NULL ENABLE, 
	"LAST_UPDATE_DATE" DATE NOT NULL ENABLE, 
	"LAST_UPDATED_BY" VARCHAR2(65) NOT NULL ENABLE, 
	"SHORT_MESSAGE" VARCHAR2(360), 
	 CONSTRAINT "LACLS_CO_LOGS_MONITORING_PK" PRIMARY KEY ("MONITORING_ID")
  USING INDEX  ENABLE
   ) ;

GRANT DELETE ON "LACLS"."LACLS_CO_LOGS_MONITORING" TO "SOPORTE_COE";
  GRANT INSERT ON "LACLS"."LACLS_CO_LOGS_MONITORING" TO "SOPORTE_COE";
  GRANT SELECT ON "LACLS"."LACLS_CO_LOGS_MONITORING" TO "SOPORTE_COE";
  GRANT UPDATE ON "LACLS"."LACLS_CO_LOGS_MONITORING" TO "SOPORTE_COE";

CREATE UNIQUE INDEX "LACLS"."LACLS_CO_LOGS_MONITORING_PK" ON "LACLS"."LACLS_CO_LOGS_MONITORING" ("MONITORING_ID") 
  ;
  CREATE INDEX "LACLS"."LACLS_CO_LOGS_MONITORING_N1" ON "LACLS"."LACLS_CO_LOGS_MONITORING" ("INSTANCE_ID") 
  ;

---

← Volver a tablas de LACLS

🏠 Volver al menú principal