   , "NAME" VARCHAR2(255) CONSTRAINT NN_ARRAYDESIGN_NAME NOT NULL
   , "PROVIDER" VARCHAR2(255)
   , "LOADDATE" DATE
-  , "MAPPINGSWID" NUMBER(22,0) CONSTRAINT NN_ARRAYDESIGN_MAPPINGSW NOT NULL) ;
+  , "MAPPINGSWID" NUMBER(22,0) /*CONSTRAINT NN_ARRAYDESIGN_MAPPINGSW NOT NULL*/) ;
 
 
   ALTER TABLE "A2_ARRAYDESIGN" 


ALTER TRIGGER A2_GENEGPV_INSERT ENABLE;

    
--------------------------------------------------------
-- ARRAY DESIGN


 ALTER TABLE "A2_BIOENTITY2BIOENTITY"
  ADD CONSTRAINT "UQ_BE2BE_FROM_TO_RELATION"
    UNIQUE("BIOENTITYIDFROM", "BIOENTITYIDTO", "BERELATIONTYPEID", "SOFTWAREID")
    ENABLE;

 ALTER TABLE "A2_BIOENTITY2BIOENTITY"
