Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE "DSAC"."TBLCASENOTES"
- ( "PRIMARYID" NUMBER(11,0),
- "CLIENTID" NUMBER(11,0),
- "INTAKEID" NUMBER(11,0),
- "AGENCYID" NUMBER,
- "CREATEDDATE" DATE,
- "CREATEDBY" VARCHAR2(30 BYTE),
- "MODIFIEDBY" VARCHAR2(30 BYTE),
- "MODIFIEDDATE" DATE,
- "TCN" NUMBER DEFAULT 1,
- "STAFF" VARCHAR2(30 BYTE),
- "CASENOTETYPE" VARCHAR2(20 BYTE),
- "CONTACTDATE" DATE,
- "CONTACTHOUR" VARCHAR2(2 BYTE) DEFAULT NULL,
- "CONTACTMIN" VARCHAR2(2 BYTE) DEFAULT NULL,
- "CONTACTAMPM" VARCHAR2(2 BYTE) DEFAULT NULL,
- "DHOUR" VARCHAR2(2 BYTE) DEFAULT NULL,
- "DMIN" VARCHAR2(2 BYTE) DEFAULT NULL,
- "BFDATE" DATE,
- "NOTES" CLOB,
- CHECK ("PRIMARYID" IS NOT NULL) ENABLE,
- CHECK ("CLIENTID" IS NOT NULL) ENABLE,
- CHECK ("INTAKEID" IS NOT NULL) ENABLE,
- CONSTRAINT "PK_TBLCASENOTES" PRIMARY KEY ("PRIMARYID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "CONTACT" ENABLE,
- CONSTRAINT "CASENOTES_CLIENT_FK" FOREIGN KEY ("CLIENTID")
- REFERENCES "DSAC"."TBLCLIENT" ("CLIENTID") ON DELETE CASCADE ENABLE,
- CONSTRAINT "CASENOTES_INTAKE_FK" FOREIGN KEY ("INTAKEID")
- REFERENCES "DSAC"."TBLINTAKE" ("INTAKEID") ON DELETE CASCADE ENABLE
- ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "CONTACT"
- LOB ("NOTES") STORE AS (
- TABLESPACE "CONTACT" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) ;
- CREATE INDEX "DSAC"."CASENOTESAGENCYINDEX" ON "DSAC"."TBLCASENOTES" ("AGENCYID")
- PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "CONTACT" ;
- CREATE UNIQUE INDEX "DSAC"."PK_TBLCASENOTE" ON "DSAC"."TBLCASENOTES" ("PRIMARYID")
- PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "CONTACT" ;
- CREATE UNIQUE INDEX "DSAC"."SYS_IL0000059271C00019$$" ON "DSAC"."TBLCASENOTES" (
- PCTFREE 10 INITRANS 2 MAXTRANS 255
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "CONTACT"
- PARALLEL (DEGREE 0 INSTANCES 0) ;
- CREATE INDEX "DSAC"."TBLCASENOTESCLIENTINDEX" ON "DSAC"."TBLCASENOTES" ("CLIENTID")
- PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "CONTACT" ;
- CREATE INDEX "DSAC"."TBLCASENOTESINTAKEINDEX" ON "DSAC"."TBLCASENOTES" ("INTAKEID")
- PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
- TABLESPACE "CONTACT" ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement