
  CREATE TABLE "STDT_TASKS" 
   (	"TASK_ID" NUMBER(15,0) NOT NULL ENABLE, 
	"TASK_NAME" VARCHAR2(150) NOT NULL ENABLE, 
	"TASK_DESCRIPTION" VARCHAR2(2000), 
	"SUBJECT_ID" NUMBER(15,0), 
	"START_DATE" DATE NOT NULL ENABLE, 
	"END_DATE" DATE NOT NULL ENABLE, 
	"COMPLETION_PERCENT" NUMBER(15,0) NOT NULL ENABLE, 
	"CREATED_BY" VARCHAR2(150) NOT NULL ENABLE, 
	"CREATION_DATE" TIMESTAMP (6) WITH LOCAL TIME ZONE NOT NULL ENABLE, 
	"LAST_UPDATED_BY" VARCHAR2(150) NOT NULL ENABLE, 
	"LAST_UPDATE_DATE" TIMESTAMP (6) WITH LOCAL TIME ZONE NOT NULL ENABLE, 
	"STUDENT_ID" NUMBER, 
	"TERM_ID" NUMBER, 
	"IMAGE_01" BLOB, 
	"IMAGE_01_MIME_TYPE" VARCHAR2(150), 
	"IMAGE_01_FILE_NAME" VARCHAR2(240), 
	"IMAGE_02" BLOB, 
	"IMAGE_02_MIME_TYPE" VARCHAR2(150), 
	"IMAGE_02_FILE_NAME" VARCHAR2(240), 
	"IMAGE_03" BLOB, 
	"IMAGE_03_MIME_TYPE" VARCHAR2(150), 
	"IMAGE_03_FILE_NAME" VARCHAR2(240), 
	"IMAGE_04" BLOB, 
	"IMAGE_04_MIME_TYPE" VARCHAR2(150), 
	"IMAGE_04_FILE_NAME" VARCHAR2(240), 
	"IMAGE_05" BLOB, 
	"IMAGE_05_MIME_TYPE" VARCHAR2(150), 
	"IMAGE_05_FILE_NAME" VARCHAR2(240), 
	"TENANT_ID" NUMBER, 
	 CONSTRAINT "STDT_TASKS_PK" PRIMARY KEY ("TASK_ID")
  USING INDEX  ENABLE
   ) ;

  CREATE OR REPLACE EDITIONABLE TRIGGER "BI_STDT_TASKS" 
  before insert on "STDT_TASKS"               
  for each row  
begin   
  if :NEW."TASK_ID" is null then 
    select "STDT_TASKS_SEQ".nextval into :NEW."TASK_ID" from sys.dual; 
  end if; 
end; 

/
ALTER TRIGGER "BI_STDT_TASKS" ENABLE;