🏠 Menú principal

← Volver a tablas

---

STADW.ST_CONTACT_TMP_NEW

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	CONTACT_GID	VARCHAR2(404)	NO
2	CONTACT_XID	VARCHAR2(200)	NO
3	IS_PRIMARY_CONTACT	CHAR(4)	NO
4	ROUTE_THROUGH_LOCATION	CHAR(4)	NO
5	CONTACT_TYPE	VARCHAR2(120)	NO
6	IS_BROADCAST	VARCHAR2(4)	NO
7	LOCATION_GID	VARCHAR2(404)	SI
8	IS_EMAIL_VIRUS_PROTECTED	VARCHAR2(4)	NO
9	CONSOLIDATED_NOTIFY_ONLY	VARCHAR2(4)	NO
10	IS_NOTIFICATION_ON	VARCHAR2(4)	NO
11	IS_FROM_ADDRESS	VARCHAR2(4)	NO
12	SEND_AS_MESSAGE	VARCHAR2(4)	NO
13	NAME_ADDRESS_UPDATE_DATE	DATE	SI
14	FIRST_NAME	VARCHAR2(600)	SI
15	DOMAIN_NAME	VARCHAR2(200)	NO
16	INSERT_USER	VARCHAR2(512)	NO
17	INSERT_DATE	DATE	NO
18	UPDATE_USER	VARCHAR2(512)	SI
19	UPDATE_DATE	DATE	SI
20	IDMAESTROCARGUE	NUMBER(18,0)	NO

Restricciones

CHECK: SYS_C00172184

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

CHECK: SYS_C00172185

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

CHECK: SYS_C00172186

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

CHECK: SYS_C00172187

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

CHECK: SYS_C00172188

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

CHECK: SYS_C00172189

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

CHECK: SYS_C00172190

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

CHECK: SYS_C00172191

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

CHECK: SYS_C00172192

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

CHECK: SYS_C00172193

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

CHECK: SYS_C00172194

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

CHECK: SYS_C00172195

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

CHECK: SYS_C00172196

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

CHECK: SYS_C00172197

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

CHECK: SYS_C00172198

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

DDL

CREATE TABLE "STADW"."ST_CONTACT_TMP_NEW" 
   (	"CONTACT_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"CONTACT_XID" VARCHAR2(200) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_PRIMARY_CONTACT" CHAR(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"ROUTE_THROUGH_LOCATION" CHAR(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"CONTACT_TYPE" VARCHAR2(120) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_BROADCAST" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"LOCATION_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"IS_EMAIL_VIRUS_PROTECTED" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"CONSOLIDATED_NOTIFY_ONLY" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_NOTIFICATION_ON" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_FROM_ADDRESS" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"SEND_AS_MESSAGE" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"NAME_ADDRESS_UPDATE_DATE" DATE, 
	"FIRST_NAME" VARCHAR2(600) COLLATE "USING_NLS_COMP", 
	"DOMAIN_NAME" VARCHAR2(200) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"INSERT_USER" VARCHAR2(512) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"INSERT_DATE" DATE NOT NULL ENABLE, 
	"UPDATE_USER" VARCHAR2(512) COLLATE "USING_NLS_COMP", 
	"UPDATE_DATE" DATE, 
	"IDMAESTROCARGUE" NUMBER(18,0) NOT NULL ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

---

← Volver a tablas de STADW

🏠 Volver al menú principal