🏠 Menú principal

← Volver a tablas

---

LACLS.LACLS_CO_DANE_COUNTRY_CODES

Base de datos origen: PDB1

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	DANE_CODE_ID	NUMBER(15,0)	NO
2	GEOGRAPHY_NAME	VARCHAR2(360)	NO
3	GEOGRAPHY_CODE	VARCHAR2(30)	NO
4	GEOGRAPHY_CODE_ISO3	VARCHAR2(30)	NO
5	ADD_ATT1	VARCHAR2(150)	SI
6	ADD_ATT2	VARCHAR2(150)	SI
7	ADD_ATT3	VARCHAR2(150)	SI
8	ADD_ATT4	VARCHAR2(150)	SI
9	ADD_ATT5	VARCHAR2(150)	SI
10	ADD_ATT6	VARCHAR2(150)	SI
11	ADD_ATT7	VARCHAR2(150)	SI
12	ADD_ATT8	VARCHAR2(150)	SI
13	ADD_ATT9	VARCHAR2(150)	SI
14	ADD_ATT10	VARCHAR2(150)	SI
15	ADD_ATT11	VARCHAR2(150)	SI
16	ADD_ATT12	VARCHAR2(150)	SI
17	ADD_ATT13	VARCHAR2(150)	SI
18	ADD_ATT14	VARCHAR2(150)	SI
19	ADD_ATT15	VARCHAR2(150)	SI
20	CREATION_DATE	DATE	SI
21	CREATED_BY	VARCHAR2(64)	SI
22	LAST_UPDATE_DATE	DATE	SI
23	LAST_UPDATED_BY	VARCHAR2(64)	SI
24	LAST_UPDATE_LOGIN	VARCHAR2(32)	SI

Restricciones

CHECK: SYS_C0014623

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

CHECK: SYS_C0014624

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

CHECK: SYS_C0014625

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

CHECK: SYS_C0014626

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

DDL

CREATE TABLE "LACLS"."LACLS_CO_DANE_COUNTRY_CODES" 
   (	"DANE_CODE_ID" NUMBER(15,0) NOT NULL ENABLE, 
	"GEOGRAPHY_NAME" VARCHAR2(360) NOT NULL ENABLE, 
	"GEOGRAPHY_CODE" VARCHAR2(30) NOT NULL ENABLE, 
	"GEOGRAPHY_CODE_ISO3" VARCHAR2(30) NOT NULL ENABLE, 
	"ADD_ATT1" VARCHAR2(150), 
	"ADD_ATT2" VARCHAR2(150), 
	"ADD_ATT3" VARCHAR2(150), 
	"ADD_ATT4" VARCHAR2(150), 
	"ADD_ATT5" VARCHAR2(150), 
	"ADD_ATT6" VARCHAR2(150), 
	"ADD_ATT7" VARCHAR2(150), 
	"ADD_ATT8" VARCHAR2(150), 
	"ADD_ATT9" VARCHAR2(150), 
	"ADD_ATT10" VARCHAR2(150), 
	"ADD_ATT11" VARCHAR2(150), 
	"ADD_ATT12" VARCHAR2(150), 
	"ADD_ATT13" VARCHAR2(150), 
	"ADD_ATT14" VARCHAR2(150), 
	"ADD_ATT15" VARCHAR2(150), 
	"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_DANE_COUNTRY_CODES" TO "SOPORTE_COE";
  GRANT INSERT ON "LACLS"."LACLS_CO_DANE_COUNTRY_CODES" TO "SOPORTE_COE";
  GRANT SELECT ON "LACLS"."LACLS_CO_DANE_COUNTRY_CODES" TO "SOPORTE_COE";
  GRANT UPDATE ON "LACLS"."LACLS_CO_DANE_COUNTRY_CODES" TO "SOPORTE_COE";

CREATE UNIQUE INDEX "LACLS"."LACLS_CO_DANE_COUNTRY_CODES_U0" ON "LACLS"."LACLS_CO_DANE_COUNTRY_CODES" ("GEOGRAPHY_CODE") 
  ;
  CREATE UNIQUE INDEX "LACLS"."LACLS_CO_DANE_COUNTRY_CODES_U1" ON "LACLS"."LACLS_CO_DANE_COUNTRY_CODES" ("DANE_CODE_ID") 
  ;

---

← Volver a tablas de LACLS

🏠 Volver al menú principal