 CREATE TABLE "ASEDBUSR"."EMAIL" 
   (	"PKEY" NUMBER(12,0) NOT NULL ENABLE, 
	"BOID" VARCHAR2(40 CHAR) NOT NULL ENABLE, 
	"METABO" NUMBER(12,0) NOT NULL ENABLE, 
	"LASTUPDATE" TIMESTAMP (9) NOT NULL ENABLE, 
	"PROCESSID" VARCHAR2(40 CHAR) NOT NULL ENABLE, 
	"ROWCOMMENT" VARCHAR2(15 CHAR), 
	"CREATED" TIMESTAMP (9) NOT NULL ENABLE, 
	"CREATEDUSER" VARCHAR2(40 CHAR) NOT NULL ENABLE, 
	"REPLACED" TIMESTAMP (9) NOT NULL ENABLE, 
	"REPLACEDUSER" VARCHAR2(40 CHAR), 
	"ARCHIVETAG" VARCHAR2(40 CHAR), 
	"GUELTAB" DATE NOT NULL ENABLE, 
	"GUELTBIS" DATE NOT NULL ENABLE, 
	"BIZCREATED" TIMESTAMP (9) NOT NULL ENABLE, 
	"BIZUSER" VARCHAR2(40 CHAR), 
	"STATEFROM" DATE NOT NULL ENABLE, 
	"STATEUPTO" DATE NOT NULL ENABLE, 
	"STATEBEGIN" DATE NOT NULL ENABLE, 
	"STATEEND" DATE NOT NULL ENABLE, 
	"ITSPARTNER" VARCHAR2(40 CHAR), 
	"ITSADRESSE" VARCHAR2(40 CHAR), 
	"ITSCONTACTPOINTDEF" VARCHAR2(40 CHAR), 
	"EMAILADRESS" VARCHAR2(255 CHAR) NOT NULL ENABLE, 
	"EXTCONTACTPOINTID" VARCHAR2(255 CHAR), 
	"EXTQUELLE" VARCHAR2(40 CHAR), 
	"EXTERNALVERSION" TIMESTAMP (9), 
	"ISDEFAULT" NUMBER(12,0) NOT NULL ENABLE, 
	"ITSCPMUGRUND" VARCHAR2(40 CHAR), 
	"NL_EMAILADRESS" VARCHAR2(255 CHAR), 
	"ISCPDEFDEFAULT" NUMBER(12,0) NOT NULL ENABLE, 
	"ITSHARMSOURCE" VARCHAR2(40 CHAR), 
	"MDBID" VARCHAR2(255 CHAR), 
	"CPQUALITYLEVEL" VARCHAR2(40 CHAR) DEFAULT null, 
	"LIFECYCLE" VARCHAR2(40 CHAR) DEFAULT null NOT NULL ENABLE, 
	"CK_CPQUALITYLEVEL" VARCHAR2(40 CHAR) DEFAULT null, 
	 CONSTRAINT "PK500287" PRIMARY KEY ("PKEY")
  USING INDEX PCTFREE 10 INITRANS 80 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "ASEDBUSR_DAT"  ENABLE, 
	 SUPPLEMENTAL LOG DATA (ALL) COLUMNS
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "ASEDBUSR_DAT" ;