In this story example, You will find the database step, then the Data structure step, the Functions step, the Web step, the Jar Implementation Step and the final step.

 

 

DATABASE step

Now the objectives are written, we can start the process to start from the OpenLSD framework. First, we extend the database table LSDDOCUMENT as follow:

FROM

CREATE TABLE "LSD"."LSDDOCUMENT"

   (   "LID" NUMBER(30,0) NOT NULL ENABLE,

       "SID" NUMBER(30,0) NOT NULL ENABLE,

       "DID" NUMBER(30,0) NOT NULL ENABLE,

       "SIZEDOC" NUMBER(30,0) DEFAULT 0 NOT NULL ENABLE,

       "IDMETIER" VARCHAR2(240 BYTE),

       "DOCDATE" TIMESTAMP (3),

       "EMPREINT" VARCHAR2(240 BYTE),

        CONSTRAINT "PK_DOCUMENT" PRIMARY KEY ("LID", "SID", "DID")

  USING INDEX COMPUTE STATISTICS

  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645)

  TABLESPACE "DATA"  ENABLE,

        CONSTRAINT "FK_DOC_STO" FOREIGN KEY ("LID", "SID")

         REFERENCES "LSD"."LSDSTORAGE" ("LID", "SID") ENABLE

   ) NOCOMPRESS LOGGING

  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645)

  TABLESPACE "DATA" ;

 

MODIFIED TO (Business ID = IDMETIER, Business Unit Id = IDBUNIT, Business Owner Id = IDOWNER)

CREATE TABLE "LSD"."LSDDOCUMENT"

   (   "LID" NUMBER(30,0) NOT NULL ENABLE,

       "SID" NUMBER(30,0) NOT NULL ENABLE,

       "DID" NUMBER(30,0) NOT NULL ENABLE,

       "SIZEDOC" NUMBER(30,0) DEFAULT 0 NOT NULL ENABLE,

       "IDMETIER" VARCHAR2(240 BYTE),

       "DOCDATE" TIMESTAMP (3),

       "EMPREINT" VARCHAR2(240 BYTE),

       "IDBUNIT" NUMBER(30,0),

       "IDOWNER" VARCHAR2(150 BYTE),

       "LIMITDATE" TIMESTAMP (3),

        CONSTRAINT "PK_DOCUMENT" PRIMARY KEY ("LID", "SID", "DID")

  USING INDEX COMPUTE STATISTICS

  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645)

  TABLESPACE "DATA"  ENABLE,

        CONSTRAINT "FK_DOC_STO" FOREIGN KEY ("LID", "SID")

         REFERENCES "LSD"."LSDSTORAGE" ("LID", "SID") ENABLE

   ) NOCOMPRESS LOGGING

  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645)

  TABLESPACE "DATA" ;

AND

CREATE INDEX "LSD"."IDX_DOC_IDOWNER" ON "LSD"."LSDDOCUMENT" ("IDOWNER")

  COMPUTE STATISTICS

  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645)

  TABLESPACE "INDEX" ;

AND

CREATE INDEX "LSD"."IDX_DOC_IDBUNIT" ON "LSD"."LSDDOCUMENT" ("IDBUNIT")

  COMPUTE STATISTICS

  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645)

  TABLESPACE "INDEX" ;

AND

CREATE INDEX "LSD"."IDX_DOC_LIMITDATE" ON "LSD"."LSDDOCUMENT" ("LIMITDATE")

  COMPUTE STATISTICS

  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645)

  TABLESPACE "INDEX" ;