STADW.ST_CONTACT

Base de datos origen: ADW COEXITO

Columnas

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

Restricciones

CHECK: SYS_C0041907

Estado: ENABLED
Columnas: ID
Condición: "ID" IS NOT NULL

CHECK: SYS_C0041908

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

CHECK: SYS_C0041909

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

CHECK: SYS_C0041910

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

CHECK: SYS_C0041911

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

CHECK: SYS_C0041912

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

CHECK: SYS_C0041913

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

CHECK: SYS_C0041914

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

CHECK: SYS_C0041915

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

CHECK: SYS_C0041916

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

CHECK: SYS_C0041917

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

CHECK: SYS_C0041918

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

CHECK: SYS_C0041919

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

CHECK: SYS_C0041920

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

CHECK: SYS_C0041921

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

CHECK: SYS_C0042194

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

PK: SYS_C0041922

Estado: ENABLED
Columnas: ID

DDL

CREATE TABLE "STADW"."ST_CONTACT" 
   (	"ID" NUMBER GENERATED BY DEFAULT AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  NOT NULL ENABLE, 
	"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, 
	 PRIMARY KEY ("ID")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

GRANT ALTER ON "STADW"."ST_CONTACT" TO "BICC";
  GRANT DELETE ON "STADW"."ST_CONTACT" TO "BICC";
  GRANT INDEX ON "STADW"."ST_CONTACT" TO "BICC";
  GRANT INSERT ON "STADW"."ST_CONTACT" TO "BICC";
  GRANT SELECT ON "STADW"."ST_CONTACT" TO "BICC";
  GRANT UPDATE ON "STADW"."ST_CONTACT" TO "BICC";
  GRANT REFERENCES ON "STADW"."ST_CONTACT" TO "BICC";
  GRANT READ ON "STADW"."ST_CONTACT" TO "BICC";
  GRANT ON COMMIT REFRESH ON "STADW"."ST_CONTACT" TO "BICC";
  GRANT QUERY REWRITE ON "STADW"."ST_CONTACT" TO "BICC";
  GRANT DEBUG ON "STADW"."ST_CONTACT" TO "BICC";
  GRANT FLASHBACK ON "STADW"."ST_CONTACT" TO "BICC";
  GRANT ASSERTION REFERENCES ON "STADW"."ST_CONTACT" TO "BICC";

CREATE UNIQUE INDEX "STADW"."SYS_C0041922" ON "STADW"."ST_CONTACT" ("ID") 
  ;

← Volver a tablas de STADW

🏠 Volver al menú principal