🏠 Menú principal

← Volver a tablas

---

LACLS.LACLS_CO_MM_REPORTED_VALUES

Base de datos origen: PDB1

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	REP_VALUE_ID	NUMBER	NO
2	CONCEPT_ID	NUMBER	NO
3	REPORTED_VALUE	NUMBER	SI
4	DESCRIPTION	VARCHAR2(100)	SI
5	MOVEMENT_TYPE	NUMBER	SI
6	CREATION_DATE	DATE	SI
7	CREATED_BY	VARCHAR2(64)	SI
8	LAST_UPDATE_DATE	DATE	SI
9	LAST_UPDATED_BY	VARCHAR2(64)	SI
10	LAST_UPDATE_LOGIN	VARCHAR2(32)	SI

Restricciones

CHECK: SYS_C0014586

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

CHECK: SYS_C0014587

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

DDL

CREATE TABLE "LACLS"."LACLS_CO_MM_REPORTED_VALUES" 
   (	"REP_VALUE_ID" NUMBER NOT NULL ENABLE, 
	"CONCEPT_ID" NUMBER NOT NULL ENABLE, 
	"REPORTED_VALUE" NUMBER, 
	"DESCRIPTION" VARCHAR2(100), 
	"MOVEMENT_TYPE" NUMBER, 
	"CREATION_DATE" DATE, 
	"CREATED_BY" VARCHAR2(64), 
	"LAST_UPDATE_DATE" DATE, 
	"LAST_UPDATED_BY" VARCHAR2(64), 
	"LAST_UPDATE_LOGIN" VARCHAR2(32)
   ) ;

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

CREATE UNIQUE INDEX "LACLS"."LACLS_CO_MM_REP_VALUES_U1" ON "LACLS"."LACLS_CO_MM_REPORTED_VALUES" ("CONCEPT_ID", "REPORTED_VALUE") 
  ;
  CREATE UNIQUE INDEX "LACLS"."LACLS_CO_MM_REP_VALUES_U2" ON "LACLS"."LACLS_CO_MM_REPORTED_VALUES" ("REP_VALUE_ID") 
  ;
  CREATE UNIQUE INDEX "LACLS"."LACLS_CO_MM_REP_VALUES_U3" ON "LACLS"."LACLS_CO_MM_REPORTED_VALUES" ("CONCEPT_ID", "REP_VALUE_ID") 
  ;

---

← Volver a tablas de LACLS

🏠 Volver al menú principal