--
-- Type: TABLE; Owner: BIOMART; Name: MIRNA_BIO_ASSAY_FEATURE_GROUP
--
 CREATE TABLE "BIOMART"."MIRNA_BIO_ASSAY_FEATURE_GROUP" 
  (	"BIO_ASSAY_FEATURE_GROUP_ID" NUMBER(18,0) NOT NULL ENABLE, 
"FEATURE_GROUP_NAME" VARCHAR2(100 BYTE) NOT NULL ENABLE, 
"FEATURE_GROUP_TYPE" VARCHAR2(50 BYTE) NOT NULL ENABLE, 
 CONSTRAINT "MIRNA_BIO_ASY_FEATURE_GRP_PK" PRIMARY KEY ("BIO_ASSAY_FEATURE_GROUP_ID")
 USING INDEX
 TABLESPACE "TRANSMART"  ENABLE
  ) SEGMENT CREATION IMMEDIATE
 TABLESPACE "TRANSMART" ;

--
-- Type: TRIGGER; Owner: BIOMART; Name: TRG_MIRNA_BIO_ASSAY_F_G_ID
--
  CREATE OR REPLACE TRIGGER "BIOMART"."TRG_MIRNA_BIO_ASSAY_F_G_ID" before insert on "BIOMART"."MIRNA_BIO_ASSAY_FEATURE_GROUP"  
          for each row begin 
	  if inserting then  
	  if :NEW."BIO_ASSAY_FEATURE_GROUP_ID" is null then   
	  select SEQ_BIO_DATA_ID.nextval into :NEW."BIO_ASSAY_FEATURE_GROUP_ID" from dual;
	  end if;
	  end if; end;
/
ALTER TRIGGER "BIOMART"."TRG_MIRNA_BIO_ASSAY_F_G_ID" ENABLE;
 
