🏠 Menú principal

← Volver a tablas

---

DWADW.DW_CLIENTES

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	ADDRESS1	VARCHAR2(1000)	SI
2	ADDRESS2	VARCHAR2(1000)	SI
3	ADDRESS3	VARCHAR2(1000)	SI
4	ADDRESS4	VARCHAR2(1000)	SI
5	CATEGORYCODE	VARCHAR2(50)	SI
6	CITY	VARCHAR2(1000)	SI
7	COMMENTS	VARCHAR2(1000)	SI
8	COUNTRY	VARCHAR2(1000)	SI
9	CREATEDBY	VARCHAR2(1000)	SI
10	CREATIONDATE	DATE	SI
11	FISCAL_CODE	VARCHAR2(1000)	SI
12	LAST_UPDATE	DATE	SI
13	LAST_UPDATE_DBY	VARCHAR2(1000)	SI
14	PARTY_ID	NUMBER	NO
15	PARTY_NAME	VARCHAR2(1000)	SI
16	PARTY_NUMBER	VARCHAR2(1000)	SI
17	PARTY_TYPE	VARCHAR2(1000)	SI
18	CONTACT_PERSON_ID	NUMBER	SI
19	SATE	VARCHAR2(1000)	SI
20	STATUS	VARCHAR2(50)	SI

Restricciones

CHECK: SYS_C0024763

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

PK: SYS_C0024764

• Estado: ENABLED
• Columnas: PARTY_ID

DDL

CREATE TABLE "DWADW"."DW_CLIENTES" 
   (	"ADDRESS1" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"ADDRESS2" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"ADDRESS3" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"ADDRESS4" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"CATEGORYCODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"CITY" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"COMMENTS" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"COUNTRY" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"CREATEDBY" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"CREATIONDATE" DATE, 
	"FISCAL_CODE" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"LAST_UPDATE" DATE, 
	"LAST_UPDATE_DBY" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"PARTY_ID" NUMBER(*,0) NOT NULL ENABLE, 
	"PARTY_NAME" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"PARTY_NUMBER" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"PARTY_TYPE" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"CONTACT_PERSON_ID" NUMBER(*,0), 
	"SATE" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"STATUS" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	 PRIMARY KEY ("PARTY_ID")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

GRANT INDEX ON "DWADW"."DW_CLIENTES" TO "BICC";
  GRANT REFERENCES ON "DWADW"."DW_CLIENTES" TO "BICC";
  GRANT ON COMMIT REFRESH ON "DWADW"."DW_CLIENTES" TO "BICC";
  GRANT QUERY REWRITE ON "DWADW"."DW_CLIENTES" TO "BICC";
  GRANT FLASHBACK ON "DWADW"."DW_CLIENTES" TO "BICC";
  GRANT DELETE ON "DWADW"."DW_CLIENTES" TO "MANAGE_DW_ST";
  GRANT INSERT ON "DWADW"."DW_CLIENTES" TO "MANAGE_DW_ST";
  GRANT SELECT ON "DWADW"."DW_CLIENTES" TO "MANAGE_DW_ST";
  GRANT UPDATE ON "DWADW"."DW_CLIENTES" TO "MANAGE_DW_ST";
  GRANT ALTER ON "DWADW"."DW_CLIENTES" TO "MANAGE_DW_ST";
  GRANT READ ON "DWADW"."DW_CLIENTES" TO "MANAGE_DW_ST";
  GRANT DEBUG ON "DWADW"."DW_CLIENTES" TO "MANAGE_DW_ST";
  GRANT ALTER ON "DWADW"."DW_CLIENTES" TO "BICC";
  GRANT DELETE ON "DWADW"."DW_CLIENTES" TO "BICC";
  GRANT INSERT ON "DWADW"."DW_CLIENTES" TO "BICC";
  GRANT SELECT ON "DWADW"."DW_CLIENTES" TO "BICC";
  GRANT UPDATE ON "DWADW"."DW_CLIENTES" TO "BICC";
  GRANT READ ON "DWADW"."DW_CLIENTES" TO "BICC";
  GRANT DEBUG ON "DWADW"."DW_CLIENTES" TO "BICC";
  GRANT SELECT ON "DWADW"."DW_CLIENTES" TO "POWER_BI";

CREATE UNIQUE INDEX "DWADW"."SYS_C0024764" ON "DWADW"."DW_CLIENTES" ("PARTY_ID") 
  ;
  CREATE INDEX "DWADW"."INDEX_PARTY_NAME_CUSTOMER" ON "DWADW"."DW_CLIENTES" ("PARTY_NAME") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal