------------------------------------------------- -- Enterprise Architect Schema Script -- DBMS: Oracle -- VERSION: 9i, 10g, 11g -- CREATED: 21/1/2010 -- EA BUILD: 852 ------------------------------------------------- PROMPT >>> Drop tables BEGIN EXECUTE IMMEDIATE 'DROP TABLE T_ATTRIBUTE'; EXECUTE IMMEDIATE 'DROP TABLE T_ATTRIBUTECONSTRAINTS'; EXECUTE IMMEDIATE 'DROP TABLE T_ATTRIBUTETAG'; EXECUTE IMMEDIATE 'DROP TABLE T_AUTHORS'; EXECUTE IMMEDIATE 'DROP TABLE T_CARDINALITY'; EXECUTE IMMEDIATE 'DROP TABLE T_CATEGORY'; EXECUTE IMMEDIATE 'DROP TABLE T_CLIENTS'; EXECUTE IMMEDIATE 'DROP TABLE T_COMPLEXITYTYPES'; EXECUTE IMMEDIATE 'DROP TABLE T_CONNECTOR'; EXECUTE IMMEDIATE 'DROP TABLE T_CONNECTORCONSTRAINT'; EXECUTE IMMEDIATE 'DROP TABLE T_CONNECTORTAG'; EXECUTE IMMEDIATE 'DROP TABLE T_CONNECTORTYPES'; EXECUTE IMMEDIATE 'DROP TABLE T_CONSTANTS'; EXECUTE IMMEDIATE 'DROP TABLE T_CONSTRAINTTYPES'; EXECUTE IMMEDIATE 'DROP TABLE T_DATATYPES'; EXECUTE IMMEDIATE 'DROP TABLE T_DIAGRAM CASCADE CONSTRAINTS'; EXECUTE IMMEDIATE 'DROP TABLE T_DIAGRAMLINKS'; EXECUTE IMMEDIATE 'DROP TABLE T_DIAGRAMOBJECTS'; EXECUTE IMMEDIATE 'DROP TABLE T_DIAGRAMTYPES CASCADE CONSTRAINTS'; EXECUTE IMMEDIATE 'DROP TABLE T_DOCUMENT'; EXECUTE IMMEDIATE 'DROP TABLE T_ECF'; EXECUTE IMMEDIATE 'DROP TABLE T_EFFORTTYPES'; EXECUTE IMMEDIATE 'DROP TABLE T_FILES'; EXECUTE IMMEDIATE 'DROP TABLE T_GENOPT'; EXECUTE IMMEDIATE 'DROP TABLE T_GLOSSARY'; EXECUTE IMMEDIATE 'DROP TABLE T_HTML'; EXECUTE IMMEDIATE 'DROP TABLE T_IMAGE'; EXECUTE IMMEDIATE 'DROP TABLE T_IMPLEMENT'; EXECUTE IMMEDIATE 'DROP TABLE T_ISSUES'; EXECUTE IMMEDIATE 'DROP TABLE T_LISTS'; EXECUTE IMMEDIATE 'DROP TABLE T_MAINTTYPES'; EXECUTE IMMEDIATE 'DROP TABLE T_METHOD'; EXECUTE IMMEDIATE 'DROP TABLE T_METRICTYPES CASCADE CONSTRAINTS'; EXECUTE IMMEDIATE 'DROP TABLE T_OBJECT'; EXECUTE IMMEDIATE 'DROP TABLE T_OBJECTCONSTRAINT'; EXECUTE IMMEDIATE 'DROP TABLE T_OBJECTEFFORT'; EXECUTE IMMEDIATE 'DROP TABLE T_OBJECTFILES'; EXECUTE IMMEDIATE 'DROP TABLE T_OBJECTMETRICS'; EXECUTE IMMEDIATE 'DROP TABLE T_OBJECTPROBLEMS'; EXECUTE IMMEDIATE 'DROP TABLE T_OBJECTPROPERTIES'; EXECUTE IMMEDIATE 'DROP TABLE T_OBJECTREQUIRES'; EXECUTE IMMEDIATE 'DROP TABLE T_OBJECTRESOURCE'; EXECUTE IMMEDIATE 'DROP TABLE T_OBJECTRISKS'; EXECUTE IMMEDIATE 'DROP TABLE T_OBJECTSCENARIOS'; EXECUTE IMMEDIATE 'DROP TABLE T_OBJECTTESTS'; EXECUTE IMMEDIATE 'DROP TABLE T_OBJECTTRX'; EXECUTE IMMEDIATE 'DROP TABLE T_OBJECTTYPES'; EXECUTE IMMEDIATE 'DROP TABLE T_OCF'; EXECUTE IMMEDIATE 'DROP TABLE T_OPERATION'; EXECUTE IMMEDIATE 'DROP TABLE T_OPERATIONPARAMS'; EXECUTE IMMEDIATE 'DROP TABLE T_OPERATIONPOSTS'; EXECUTE IMMEDIATE 'DROP TABLE T_OPERATIONPRES'; EXECUTE IMMEDIATE 'DROP TABLE T_OPERATIONTAG'; EXECUTE IMMEDIATE 'DROP TABLE T_PACKAGE CASCADE CONSTRAINTS'; EXECUTE IMMEDIATE 'DROP TABLE T_PALETTE'; EXECUTE IMMEDIATE 'DROP TABLE T_PALETTEITEM'; EXECUTE IMMEDIATE 'DROP TABLE T_PHASE'; EXECUTE IMMEDIATE 'DROP TABLE T_PRIMITIVES'; EXECUTE IMMEDIATE 'DROP TABLE T_PROBLEMTYPES'; EXECUTE IMMEDIATE 'DROP TABLE T_PROJECTROLES'; EXECUTE IMMEDIATE 'DROP TABLE T_PROPERTYTYPES'; EXECUTE IMMEDIATE 'DROP TABLE T_REQUIRETYPES'; EXECUTE IMMEDIATE 'DROP TABLE T_RESOURCES'; EXECUTE IMMEDIATE 'DROP TABLE T_RISKTYPES'; EXECUTE IMMEDIATE 'DROP TABLE T_ROLECONSTRAINT'; EXECUTE IMMEDIATE 'DROP TABLE T_RTF'; EXECUTE IMMEDIATE 'DROP TABLE T_RTFREPORT'; EXECUTE IMMEDIATE 'DROP TABLE T_RULES'; EXECUTE IMMEDIATE 'DROP TABLE T_SCENARIOTYPES'; EXECUTE IMMEDIATE 'DROP TABLE T_SCRIPT'; EXECUTE IMMEDIATE 'DROP TABLE T_SECGROUP'; EXECUTE IMMEDIATE 'DROP TABLE T_SECGROUPPERMISSION'; EXECUTE IMMEDIATE 'DROP TABLE T_SECLOCKS'; EXECUTE IMMEDIATE 'DROP TABLE T_SECPERMISSION'; EXECUTE IMMEDIATE 'DROP TABLE T_SECPOLICIES'; EXECUTE IMMEDIATE 'DROP TABLE T_SECUSER'; EXECUTE IMMEDIATE 'DROP TABLE T_SECUSERGROUP'; EXECUTE IMMEDIATE 'DROP TABLE T_SECUSERPERMISSION'; EXECUTE IMMEDIATE 'DROP TABLE T_SNAPSHOT'; EXECUTE IMMEDIATE 'DROP TABLE T_STATUSTYPES'; EXECUTE IMMEDIATE 'DROP TABLE T_STEREOTYPES'; EXECUTE IMMEDIATE 'DROP TABLE T_TAGGEDVALUE'; EXECUTE IMMEDIATE 'DROP TABLE T_TASKS'; EXECUTE IMMEDIATE 'DROP TABLE T_TCF'; EXECUTE IMMEDIATE 'DROP TABLE T_TEMPLATE'; EXECUTE IMMEDIATE 'DROP TABLE T_TESTCLASS'; EXECUTE IMMEDIATE 'DROP TABLE T_TESTPLANS'; EXECUTE IMMEDIATE 'DROP TABLE T_TESTTYPES'; EXECUTE IMMEDIATE 'DROP TABLE T_TRXTYPES'; EXECUTE IMMEDIATE 'DROP TABLE T_UMLPATTERN'; EXECUTE IMMEDIATE 'DROP TABLE T_VERSION'; EXECUTE IMMEDIATE 'DROP TABLE T_XREF'; EXECUTE IMMEDIATE 'DROP TABLE T_XREFSYSTEM'; EXECUTE IMMEDIATE 'DROP TABLE T_XREFUSER'; EXECUTE IMMEDIATE 'DROP TABLE USYSOLDTABLES'; EXECUTE IMMEDIATE 'DROP TABLE USYSQUERIES'; EXECUTE IMMEDIATE 'DROP TABLE USYSTABLES'; EXECUTE IMMEDIATE 'DROP TABLE USYS_SYSTEM'; EXECUTE IMMEDIATE 'DROP SEQUENCE ID_SEQ'; EXECUTE IMMEDIATE 'DROP SEQUENCE PROPERTYID_SEQ'; EXECUTE IMMEDIATE 'DROP SEQUENCE CATEGORYID_SEQ'; EXECUTE IMMEDIATE 'DROP SEQUENCE CONNECTOR_ID_SEQ'; EXECUTE IMMEDIATE 'DROP SEQUENCE DATATYPEID_SEQ'; EXECUTE IMMEDIATE 'DROP SEQUENCE DIAGRAM_ID_SEQ'; EXECUTE IMMEDIATE 'DROP SEQUENCE INSTANCE_ID_SEQ'; EXECUTE IMMEDIATE 'DROP SEQUENCE GLOSSARYID_SEQ'; EXECUTE IMMEDIATE 'DROP SEQUENCE IMAGEID_SEQ'; EXECUTE IMMEDIATE 'DROP SEQUENCE ISSUEID_SEQ'; EXECUTE IMMEDIATE 'DROP SEQUENCE OBJECT_ID_SEQ'; EXECUTE IMMEDIATE 'DROP SEQUENCE REQID_SEQ'; EXECUTE IMMEDIATE 'DROP SEQUENCE OPERATIONID_SEQ'; EXECUTE IMMEDIATE 'DROP SEQUENCE PACKAGE_ID_SEQ'; EXECUTE IMMEDIATE 'DROP SEQUENCE PALETTEID_SEQ'; EXECUTE IMMEDIATE 'DROP SEQUENCE SCRIPTID_SEQ'; EXECUTE IMMEDIATE 'DROP SEQUENCE TASKID_SEQ'; EXECUTE IMMEDIATE 'DROP SEQUENCE TRX_ID_SEQ'; EXECUTE IMMEDIATE 'DROP SEQUENCE PATTERNID_SEQ'; EXCEPTION WHEN OTHERS THEN NULL; END; / ----------------------------------------------------------- PROMPT >>> Creating tables PROMPT >>> T_ATTRIBUTE CREATE TABLE "T_ATTRIBUTE" ( "OBJECT_ID" NUMBER(10,0) DEFAULT 0 NOT NULL, "NAME" VARCHAR2(255) NOT NULL, "SCOPE" VARCHAR2(50), "STEREOTYPE" VARCHAR2(50), "CONTAINMENT" VARCHAR2(50), "ISSTATIC" NUMBER(10,0) DEFAULT 0, "ISCOLLECTION" NUMBER(10,0) DEFAULT 0, "ISORDERED" NUMBER(10,0) DEFAULT 0, "ALLOWDUPLICATES" NUMBER(10,0) DEFAULT 0, "LOWERBOUND" VARCHAR2(50), "UPPERBOUND" VARCHAR2(50), "CONTAINER" VARCHAR2(50), "NOTES" CLOB, "DERIVED" CHAR(1), "ID" NUMBER(10,0), "POS" NUMBER(10,0), "GENOPTION" CLOB, "LENGTH" NUMBER(10,0), "PRECISION" NUMBER(10,0), "SCALE" NUMBER(10,0), "CONST" NUMBER(10,0), "STYLE" VARCHAR2(255), "CLASSIFIER" VARCHAR2(50), "Default" CLOB, "TYPE" VARCHAR2(255), "EA_GUID" VARCHAR2(50), "STYLEEX" CLOB, CONSTRAINT "PK_ATTRIBUTE" PRIMARY KEY ("ID") ) / CREATE INDEX "IX_ATTR_CLASSIFIER" ON "T_ATTRIBUTE" ("CLASSIFIER") / CREATE INDEX "IX_ATTR_TYPE" ON "T_ATTRIBUTE" ("TYPE") / CREATE UNIQUE INDEX "UX_ATTR_EAGUID" ON "T_ATTRIBUTE" ("EA_GUID") / CREATE INDEX "IX_ATTR_OBJECTID" ON "T_ATTRIBUTE" ("OBJECT_ID") / CREATE INDEX "IX_ATTR_NAME" ON "T_ATTRIBUTE" ("NAME") / ----------------------------------------------------------- PROMPT >>> T_ATTRIBUTECONSTRAINTS CREATE TABLE "T_ATTRIBUTECONSTRAINTS" ( "OBJECT_ID" NUMBER(10,0) DEFAULT 0, "Constraint" VARCHAR2(255), "ATTNAME" VARCHAR2(255), "TYPE" VARCHAR2(255), "NOTES" CLOB, "ID" NUMBER(10,0), CONSTRAINT "PK_ATTRIBUTECONSTRAINTS" PRIMARY KEY ("ID", "Constraint") ) / ----------------------------------------------------------- PROMPT >>> T_ATTRIBUTETAG CREATE TABLE "T_ATTRIBUTETAG" ( "PROPERTYID" NUMBER(10,0), "ELEMENTID" NUMBER(10,0), "PROPERTY" VARCHAR2(255), "VALUE" VARCHAR2(255), "NOTES" CLOB, "EA_GUID" VARCHAR2(40), CONSTRAINT "PK_ATTRIBUTETAG" PRIMARY KEY ("PROPERTYID") ) / CREATE INDEX "IX_ATTRTAG_ELEMENTID" ON "T_ATTRIBUTETAG" ("ELEMENTID") / CREATE INDEX "IX_ATTRTAG_VALUE" ON "T_ATTRIBUTETAG" ("VALUE") / ----------------------------------------------------------- PROMPT >>> T_AUTHORS CREATE TABLE "T_AUTHORS" ( "AUTHORNAME" VARCHAR2(255), "ROLES" VARCHAR2(255), "NOTES" VARCHAR2(255), CONSTRAINT "PK_AUTHORS" PRIMARY KEY ("AUTHORNAME") ) / ----------------------------------------------------------- PROMPT >>> T_CARDINALITY CREATE TABLE "T_CARDINALITY" ( "CARDINALITY" VARCHAR2(50), CONSTRAINT "PK_CARDINALITY" PRIMARY KEY ("CARDINALITY") ) / ----------------------------------------------------------- PROMPT >>> T_CATEGORY CREATE TABLE "T_CATEGORY" ( "CATEGORYID" NUMBER(10,0), "NAME" VARCHAR2(255), "TYPE" VARCHAR2(255), "NOTES" CLOB, CONSTRAINT "PK_CATEGORY" PRIMARY KEY ("CATEGORYID") ) / ----------------------------------------------------------- PROMPT >>> T_CLIENTS CREATE TABLE "T_CLIENTS" ( "NAME" VARCHAR2(255), "ORGANISATION" VARCHAR2(255), "PHONE1" VARCHAR2(50), "PHONE2" VARCHAR2(50), "MOBILE" VARCHAR2(50), "FAX" VARCHAR2(50), "EMAIL" VARCHAR2(50), "ROLES" VARCHAR2(255), "NOTES" VARCHAR2(255), CONSTRAINT "PK_CLIENTS" PRIMARY KEY ("NAME") ) / ----------------------------------------------------------- PROMPT >>> T_COMPLEXITYTYPES CREATE TABLE "T_COMPLEXITYTYPES" ( "COMPLEXITY" VARCHAR2(50), "NUMERICWEIGHT" NUMBER(10,0) DEFAULT 0, CONSTRAINT "PK_COMPLEXITYTYPES" PRIMARY KEY ("COMPLEXITY") ) / CREATE INDEX "IX_COMPLEX_NUMWEIGHT" ON "T_COMPLEXITYTYPES" ("NUMERICWEIGHT") / ----------------------------------------------------------- PROMPT >>> T_CONNECTOR CREATE TABLE "T_CONNECTOR" ( "CONNECTOR_ID" NUMBER(10,0), "NAME" VARCHAR2(255), "DIRECTION" VARCHAR2(50), "NOTES" CLOB, "CONNECTOR_TYPE" VARCHAR2(50) NOT NULL, "SUBTYPE" VARCHAR2(50), "SOURCECARD" VARCHAR2(50), "SOURCEACCESS" VARCHAR2(50), "SOURCEELEMENT" VARCHAR2(50), "DESTCARD" VARCHAR2(50), "DESTACCESS" VARCHAR2(50), "DESTELEMENT" VARCHAR2(50), "SOURCEROLE" VARCHAR2(255), "SOURCEROLETYPE" VARCHAR2(50), "SOURCEROLENOTE" CLOB, "SOURCECONTAINMENT" VARCHAR2(50), "SOURCEISAGGREGATE" NUMBER(10,0) DEFAULT '0', "SOURCEISORDERED" NUMBER(10,0) DEFAULT '0', "SOURCEQUALIFIER" VARCHAR2(50), "DESTROLE" VARCHAR2(255), "DESTROLETYPE" VARCHAR2(50), "DESTROLENOTE" CLOB, "DESTCONTAINMENT" VARCHAR2(50), "DESTISAGGREGATE" NUMBER(10,0) DEFAULT '0', "DESTISORDERED" NUMBER(10,0) DEFAULT '0', "DESTQUALIFIER" VARCHAR2(50), "START_OBJECT_ID" NUMBER(10,0) DEFAULT '0' NOT NULL, "END_OBJECT_ID" NUMBER(10,0) DEFAULT '0' NOT NULL, "TOP_START_LABEL" VARCHAR2(50), "TOP_MID_LABEL" VARCHAR2(50), "TOP_END_LABEL" VARCHAR2(50), "BTM_START_LABEL" VARCHAR2(50), "BTM_MID_LABEL" VARCHAR2(50), "BTM_END_LABEL" VARCHAR2(50), "START_EDGE" NUMBER(10,0) DEFAULT '0', "END_EDGE" NUMBER(10,0) DEFAULT '0', "PTSTARTX" NUMBER(10,0) DEFAULT '0', "PTSTARTY" NUMBER(10,0) DEFAULT '0', "PTENDX" NUMBER(10,0) DEFAULT '0', "PTENDY" NUMBER(10,0) DEFAULT '0', "SEQNO" NUMBER(10,0) DEFAULT '0', "HEADSTYLE" NUMBER(10,0) DEFAULT '0', "LINESTYLE" NUMBER(10,0) DEFAULT '0', "ROUTESTYLE" NUMBER(10,0) DEFAULT '0', "ISBOLD" NUMBER(10,0) DEFAULT '0', "LINECOLOR" NUMBER(10,0) DEFAULT '0', "STEREOTYPE" VARCHAR2(50), "VIRTUALINHERITANCE" CHAR(1), "LINKACCESS" VARCHAR2(50), "PDATA1" VARCHAR2(255), "PDATA3" VARCHAR2(255), "PDATA4" VARCHAR2(255), "DIAGRAMID" NUMBER(10,0) DEFAULT '0' NOT NULL, "EA_GUID" VARCHAR2(40) NOT NULL, "SOURCECONSTRAINT" VARCHAR2(255), "DESTCONSTRAINT" VARCHAR2(255), "SOURCEISNAVIGABLE" NUMBER(10,0), "DESTISNAVIGABLE" NUMBER(10,0), "ISROOT" NUMBER(10,0), "ISLEAF" NUMBER(10,0), "ISSPEC" NUMBER(10,0), "SOURCECHANGEABLE" VARCHAR2(12), "DESTCHANGEABLE" VARCHAR2(12), "SOURCETS" VARCHAR2(12), "DESTTS" VARCHAR2(12), "ACTIONFLAGS" VARCHAR2(255), "ISSIGNAL" NUMBER(10,0), "ISSTIMULUS" NUMBER(10,0), "DISPATCHACTION" VARCHAR2(255), "TARGET2" NUMBER(10,0), "STYLEEX" CLOB, "SOURCESTEREOTYPE" VARCHAR2(255), "DESTSTEREOTYPE" VARCHAR2(255), "SOURCESTYLE" CLOB, "DESTSTYLE" CLOB, "EVENTFLAGS" VARCHAR2(255), "PDATA2" CLOB, "PDATA5" CLOB, "STATEFLAGS" CLOB, CONSTRAINT "PK_CONNECTOR" PRIMARY KEY ("CONNECTOR_ID") ) / CREATE INDEX "IX_CONN_ENDOBJID" ON "T_CONNECTOR" ("END_OBJECT_ID") / CREATE INDEX "IX_CONN_STARTOBJID" ON "T_CONNECTOR" ("START_OBJECT_ID") / CREATE INDEX "IX_CONN_SEQNO" ON "T_CONNECTOR" ("SEQNO") / CREATE UNIQUE INDEX "UX_CONN_EAGUID" ON "T_CONNECTOR" ("EA_GUID") / CREATE INDEX "IX_CONN_CONNTYPE" ON "T_CONNECTOR" ("CONNECTOR_TYPE") / CREATE INDEX "IX_CONN_DIAGRAMID" ON "T_CONNECTOR" ("DIAGRAMID") / CREATE INDEX "IX_CONN_EIDCONNID" ON "T_CONNECTOR" ("END_OBJECT_ID", "CONNECTOR_ID") / CREATE INDEX "IX_CONN_SIDCONNID" ON "T_CONNECTOR" ("START_OBJECT_ID", "CONNECTOR_ID") / ----------------------------------------------------------- PROMPT >>> T_CONNECTORCONSTRAINT CREATE TABLE "T_CONNECTORCONSTRAINT" ( "CONNECTORID" NUMBER(10,0) DEFAULT '0' NOT NULL, "Constraint" VARCHAR2(255) NOT NULL, "CONSTRAINTTYPE" VARCHAR2(50), "NOTES" CLOB, CONSTRAINT "PK_CONNECTORCONSTRAINT" PRIMARY KEY ("CONNECTORID", "Constraint") ) / CREATE INDEX "IX_CONNCONSTR_CONSTRAINT" ON "T_CONNECTORCONSTRAINT" ("Constraint") / CREATE INDEX "IX_CONNCONSTR_CONNID" ON "T_CONNECTORCONSTRAINT" ("CONNECTORID") / ----------------------------------------------------------- PROMPT >>> T_CONNECTORTAG CREATE TABLE "T_CONNECTORTAG" ( "PROPERTYID" NUMBER(10,0), "ELEMENTID" NUMBER(10,0), "PROPERTY" VARCHAR2(255), "VALUE" VARCHAR2(255), "NOTES" CLOB, "EA_GUID" VARCHAR2(40), CONSTRAINT "PK_CONNECTORTAG" PRIMARY KEY ("PROPERTYID") ) / CREATE INDEX "IX_CONNTAG_ELEMENTID" ON "T_CONNECTORTAG" ("ELEMENTID") / CREATE INDEX "IX_CONNTAG_PROPERTY" ON "T_CONNECTORTAG" ("PROPERTY") / CREATE INDEX "IX_CONNTAG_VALUE" ON "T_CONNECTORTAG" ("VALUE") / ----------------------------------------------------------- PROMPT >>> T_CONNECTORTYPES CREATE TABLE "T_CONNECTORTYPES" ( "CONNECTOR_TYPE" VARCHAR2(50), "DESCRIPTION" VARCHAR2(50), CONSTRAINT "PK_CONNECTORTYPES" PRIMARY KEY ("CONNECTOR_TYPE") ) / ----------------------------------------------------------- PROMPT >>> T_CONSTANTS CREATE TABLE "T_CONSTANTS" ( "CONSTANTNAME" VARCHAR2(50), "CONSTANTVALUE" VARCHAR2(255), CONSTRAINT "PK_CONSTANTS" PRIMARY KEY ("CONSTANTNAME") ) / ----------------------------------------------------------- PROMPT >>> T_CONSTRAINTTYPES CREATE TABLE "T_CONSTRAINTTYPES" ( "Constraint" VARCHAR2(16), "DESCRIPTION" VARCHAR2(50), "NOTES" CLOB, CONSTRAINT "PK_CONSTRAINTTYPES" PRIMARY KEY ("Constraint") ) / ----------------------------------------------------------- PROMPT >>> T_DATATYPES CREATE TABLE "T_DATATYPES" ( "TYPE" VARCHAR2(50) NOT NULL, "PRODUCTNAME" VARCHAR2(50) NOT NULL, "DATATYPE" VARCHAR2(50), "Size" NUMBER(10,0), "MAXLEN" NUMBER(10,0), "MAXPREC" NUMBER(10,0), "MAXSCALE" NUMBER(10,0) DEFAULT 0, "DEFAULTLEN" NUMBER(10,0), "DEFAULTPREC" NUMBER(10,0), "DEFAULTSCALE" NUMBER(10,0), "User" NUMBER(10,0), "PDATA1" VARCHAR2(255), "PDATA2" VARCHAR2(255), "PDATA3" VARCHAR2(255), "PDATA4" VARCHAR2(255), "HASLENGTH" VARCHAR2(50), "GENERICTYPE" VARCHAR2(255), "DATATYPEID" NUMBER(10,0), CONSTRAINT "PK_DATATYPES" PRIMARY KEY ("DATATYPEID") ) / CREATE INDEX "IX_DATATYPE_PRODNAME" ON "T_DATATYPES" ("PRODUCTNAME") / CREATE INDEX "IX_DATATYPE_DATATYPE" ON "T_DATATYPES" ("DATATYPE") / ----------------------------------------------------------- PROMPT >>> T_DIAGRAM CREATE TABLE "T_DIAGRAM" ( "DIAGRAM_ID" NUMBER(10,0), "PACKAGE_ID" NUMBER(10,0) DEFAULT 1 NOT NULL, "PARENTID" NUMBER(10,0) DEFAULT 0, "DIAGRAM_TYPE" VARCHAR2(50), "NAME" VARCHAR2(255), "VERSION" VARCHAR2(50) DEFAULT '1.0', "AUTHOR" VARCHAR2(255), "SHOWDETAILS" NUMBER(10,0) DEFAULT 0, "NOTES" CLOB, "STEREOTYPE" VARCHAR2(50), "ATTPUB" NUMBER(10,0) DEFAULT 1, "ATTPRI" NUMBER(10,0) DEFAULT 1, "ATTPRO" NUMBER(10,0) DEFAULT 1, "ORIENTATION" CHAR(1) DEFAULT 'P', "CX" NUMBER(10,0) DEFAULT 0, "CY" NUMBER(10,0) DEFAULT 0, "SCALE" NUMBER(10,0) DEFAULT 100, "CREATEDDATE" DATE DEFAULT SYSDATE, "MODIFIEDDATE" DATE DEFAULT SYSDATE, "HTMLPATH" VARCHAR2(255), "SHOWFOREIGN" NUMBER(10,0) DEFAULT 1, "SHOWBORDER" NUMBER(10,0) DEFAULT 1, "SHOWPACKAGECONTENTS" NUMBER(10,0) DEFAULT 1, "PDATA" VARCHAR2(255), "LOCKED" NUMBER(10,0), "EA_GUID" VARCHAR2(40) NOT NULL, "TPOS" NUMBER(10,0), "SWIMLANES" VARCHAR2(255), "STYLEEX" CLOB, CONSTRAINT "PK_DIAGRAM" PRIMARY KEY ("DIAGRAM_ID") ) / CREATE INDEX "IX_DIAG_PACKAGEID" ON "T_DIAGRAM" ("PACKAGE_ID") / CREATE INDEX "IX_DIAG_DIAGTYPE" ON "T_DIAGRAM" ("DIAGRAM_TYPE") / CREATE INDEX "IX_DIAG_PARENT" ON "T_DIAGRAM" ("PARENTID") / ----------------------------------------------------------- PROMPT >>> T_DIAGRAMLINKS CREATE TABLE "T_DIAGRAMLINKS" ( "DIAGRAMID" NUMBER(10,0) NOT NULL, "CONNECTORID" NUMBER(10,0) NOT NULL, "GEOMETRY" CLOB, "STYLE" VARCHAR2(255), "HIDDEN" NUMBER(10,0), "PATH" VARCHAR2(255), "INSTANCE_ID" NUMBER(10,0), CONSTRAINT "PK_DIAGRAMLINKS" PRIMARY KEY ("INSTANCE_ID") ) / CREATE INDEX "IX_DIAGLINKS_DIAGRAMID" ON "T_DIAGRAMLINKS" ("DIAGRAMID") / CREATE INDEX "IX_DIAGLINKS_CONNECTORID" ON "T_DIAGRAMLINKS" ("CONNECTORID") / ----------------------------------------------------------- PROMPT >>> T_DIAGRAMOBJECTS CREATE TABLE "T_DIAGRAMOBJECTS" ( "DIAGRAM_ID" NUMBER(10,0) DEFAULT 0, "OBJECT_ID" NUMBER(10,0) DEFAULT 0, "RECTTOP" NUMBER(10,0) DEFAULT 0, "RECTLEFT" NUMBER(10,0) DEFAULT 0, "RECTRIGHT" NUMBER(10,0) DEFAULT 0, "RECTBOTTOM" NUMBER(10,0) DEFAULT 0, "SEQUENCE" NUMBER(10,0) DEFAULT 0, "OBJECTSTYLE" VARCHAR2(255), "INSTANCE_ID" NUMBER(10,0), CONSTRAINT "PK_DIAGRAMOBJECTS" PRIMARY KEY ("INSTANCE_ID") ) / CREATE INDEX "IX_DIAGOBJ_DIAGRAMID" ON "T_DIAGRAMOBJECTS" ("DIAGRAM_ID") / CREATE INDEX "IX_DIAGOBJ_OBJECTID" ON "T_DIAGRAMOBJECTS" ("OBJECT_ID") / ----------------------------------------------------------- PROMPT >>> T_DIAGRAMTYPES CREATE TABLE "T_DIAGRAMTYPES" ( "DIAGRAM_TYPE" VARCHAR2(50), "NAME" VARCHAR2(255), "PACKAGE_ID" NUMBER(10,0) DEFAULT 0 NOT NULL, CONSTRAINT "PK_DIAGRAMTYPES" PRIMARY KEY ("DIAGRAM_TYPE") ) / ----------------------------------------------------------- PROMPT >>> T_DOCUMENT CREATE TABLE "T_DOCUMENT" ( "DOCID" VARCHAR2(40), "DOCNAME" VARCHAR2(100), "NOTES" VARCHAR2(255), "STYLE" VARCHAR2(255), "ELEMENTID" VARCHAR2(40) NOT NULL, "ELEMENTTYPE" VARCHAR2(50) NOT NULL, "STRCONTENT" CLOB, "BINCONTENT" BLOB, "DOCTYPE" VARCHAR2(100), "AUTHOR" VARCHAR2(255), "VERSION" VARCHAR2(50), "ISACTIVE" NUMBER(10,0), "SEQUENCE" NUMBER(10,0), "DOCDATE" DATE, CONSTRAINT "PK_DOCUMENT" PRIMARY KEY ("DOCID") ) / CREATE INDEX "IX_DOC_ELEMENTID" ON "T_DOCUMENT" ("ELEMENTID") / ----------------------------------------------------------- PROMPT >>> T_ECF CREATE TABLE "T_ECF" ( "ECFID" VARCHAR2(12), "DESCRIPTION" VARCHAR2(50), "WEIGHT" FLOAT(126) DEFAULT 1 NOT NULL, "VALUE" FLOAT(126) DEFAULT 0, "NOTES" VARCHAR2(255), CONSTRAINT "PK_ECF" PRIMARY KEY ("ECFID") ) / CREATE INDEX "IX_ECF_WEIGHT" ON "T_ECF" ("WEIGHT") / ----------------------------------------------------------- PROMPT >>> T_EFFORTTYPES CREATE TABLE "T_EFFORTTYPES" ( "EFFORTTYPE" VARCHAR2(12), "DESCRIPTION" VARCHAR2(255), "NUMERICWEIGHT" FLOAT(126) DEFAULT 0 NOT NULL, "NOTES" VARCHAR2(255), CONSTRAINT "PK_EFFORTTYPES" PRIMARY KEY ("EFFORTTYPE") ) / CREATE INDEX "IX_EFFTYPES_NUMWEIGHT" ON "T_EFFORTTYPES" ("NUMERICWEIGHT") / ----------------------------------------------------------- PROMPT >>> T_FILES CREATE TABLE "T_FILES" ( "FILEID" VARCHAR2(50), "APPLIESTO" VARCHAR2(50) NOT NULL, "CATEGORY" VARCHAR2(100) NOT NULL, "NAME" VARCHAR2(150) NOT NULL, "File" VARCHAR2(255), "NOTES" CLOB, "FILEDATE" DATE, "FILESIZE" NUMBER(10,0), PRIMARY KEY ("FILEID") ) / ----------------------------------------------------------- PROMPT >>> T_GENOPT CREATE TABLE "T_GENOPT" ( "APPLIESTO" VARCHAR2(12), "Option" CLOB ) / ----------------------------------------------------------- PROMPT >>> T_GLOSSARY CREATE TABLE "T_GLOSSARY" ( "TERM" VARCHAR2(255), "TYPE" VARCHAR2(255), "MEANING" CLOB, "GLOSSARYID" NUMBER(10,0), CONSTRAINT "PK_GLOSSARY" PRIMARY KEY ("GLOSSARYID") ) / ----------------------------------------------------------- PROMPT >>> T_HTML CREATE TABLE "T_HTML" ( "TYPE" VARCHAR2(50), "TEMPLATE" CLOB ) / ----------------------------------------------------------- PROMPT >>> T_IMAGE CREATE TABLE "T_IMAGE" ( "IMAGEID" NUMBER(10,0), "NAME" VARCHAR2(255), "TYPE" VARCHAR2(255), "IMAGE" BLOB, CONSTRAINT "PK_IMAGE" PRIMARY KEY ("IMAGEID") ) / ----------------------------------------------------------- PROMPT >>> T_IMPLEMENT CREATE TABLE "T_IMPLEMENT" ( "TYPE" VARCHAR2(50) ) / ----------------------------------------------------------- PROMPT >>> T_ISSUES CREATE TABLE "T_ISSUES" ( "ISSUE" VARCHAR2(255), "ISSUEDATE" DATE, "OWNER" VARCHAR2(255), "STATUS" VARCHAR2(50), "NOTES" CLOB, "RESOLVER" VARCHAR2(255), "DATERESOLVED" DATE, "RESOLUTION" CLOB, "ISSUEID" NUMBER(10,0), "CATEGORY" VARCHAR2(255), "PRIORITY" VARCHAR2(50), "SEVERITY" VARCHAR2(50), "ISSUETYPE" VARCHAR2(100), CONSTRAINT "PK_ISSUES" PRIMARY KEY ("ISSUEID") ) / ----------------------------------------------------------- PROMPT >>> T_LISTS CREATE TABLE "T_LISTS" ( "LISTID" VARCHAR2(50), "CATEGORY" VARCHAR2(100) NOT NULL, "NAME" VARCHAR2(150) NOT NULL, "NVAL" NUMBER(10,0), "NOTES" CLOB, CONSTRAINT "PK_LISTS" PRIMARY KEY ("LISTID") ) / ----------------------------------------------------------- PROMPT >>> T_MAINTTYPES CREATE TABLE "T_MAINTTYPES" ( "MAINTTYPE" VARCHAR2(12), "DESCRIPTION" VARCHAR2(50), "NUMERICWEIGHT" FLOAT(126) DEFAULT 1 NOT NULL, "NOTES" VARCHAR2(255), CONSTRAINT "PK_MAINTTYPES" PRIMARY KEY ("MAINTTYPE") ) / CREATE INDEX "IX_MAINTYPES_NUMWEIGHT" ON "T_MAINTTYPES" ("NUMERICWEIGHT") / ----------------------------------------------------------- PROMPT >>> T_METHOD CREATE TABLE "T_METHOD" ( "OBJECT_ID" NUMBER(10,0), "NAME" VARCHAR2(255) NOT NULL, "SCOPE" VARCHAR2(50), "TYPE" VARCHAR2(50), CONSTRAINT "PK_METHOD" PRIMARY KEY ("OBJECT_ID", "NAME") ) / ----------------------------------------------------------- PROMPT >>> T_METRICTYPES CREATE TABLE "T_METRICTYPES" ( "METRIC" VARCHAR2(12) NOT NULL, "DESCRIPTION" VARCHAR2(50), "NUMERICWEIGHT" FLOAT(126) DEFAULT 1 NOT NULL, "NOTES" VARCHAR2(255), CONSTRAINT "PK_METRICTYPES" PRIMARY KEY ("METRIC") ) / CREATE INDEX "IX_METTYPES_NUMWEIGHT" ON "T_METRICTYPES" ("NUMERICWEIGHT") / ----------------------------------------------------------- PROMPT >>> T_OBJECT CREATE TABLE "T_OBJECT" ( "OBJECT_ID" NUMBER(10,0), "OBJECT_TYPE" VARCHAR2(255), "DIAGRAM_ID" NUMBER(10,0) DEFAULT 0, "NAME" VARCHAR2(255), "ALIAS" VARCHAR2(255), "AUTHOR" VARCHAR2(255), "VERSION" VARCHAR2(50) DEFAULT '1.0', "NOTE" CLOB, "PACKAGE_ID" NUMBER(10,0) DEFAULT 0 NOT NULL, "STEREOTYPE" VARCHAR2(255), "NTYPE" NUMBER(10,0) DEFAULT 0, "COMPLEXITY" VARCHAR2(50) DEFAULT 2, "EFFORT" NUMBER(10,0) DEFAULT 0, "STYLE" VARCHAR2(255), "BACKCOLOR" NUMBER(10,0) DEFAULT 0, "BORDERSTYLE" NUMBER(10,0) DEFAULT 0, "BORDERWIDTH" NUMBER(10,0) DEFAULT 0, "FONTCOLOR" NUMBER(10,0) DEFAULT 0, "BORDERCOLOR" NUMBER(10,0) DEFAULT 0, "CREATEDDATE" DATE DEFAULT SYSDATE, "MODIFIEDDATE" DATE DEFAULT SYSDATE, "STATUS" VARCHAR2(50), "ABSTRACT" CHAR(1), "TAGGED" NUMBER(10,0) DEFAULT 0, "PDATA1" VARCHAR2(255), "PDATA2" CLOB, "PDATA3" CLOB, "PDATA4" CLOB, "PDATA5" VARCHAR2(255), "CONCURRENCY" VARCHAR2(50), "VISIBILITY" VARCHAR2(50), "PERSISTENCE" VARCHAR2(50), "CARDINALITY" VARCHAR2(50), "GENTYPE" VARCHAR2(50), "GENFILE" VARCHAR2(255), "HEADER1" CLOB, "HEADER2" CLOB, "PHASE" VARCHAR2(50), "SCOPE" VARCHAR2(25), "GENOPTION" CLOB, "GENLINKS" CLOB, "CLASSIFIER" NUMBER(10,0), "EA_GUID" VARCHAR2(40) NOT NULL, "PARENTID" NUMBER(10,0), "RUNSTATE" CLOB, "CLASSIFIER_GUID" VARCHAR2(40), "TPOS" NUMBER(10,0), "ISROOT" NUMBER(10,0), "ISLEAF" NUMBER(10,0), "ISSPEC" NUMBER(10,0), "ISACTIVE" NUMBER(10,0), "STATEFLAGS" VARCHAR2(255), "PACKAGEFLAGS" VARCHAR2(255), "MULTIPLICITY" VARCHAR2(50), "STYLEEX" CLOB, "ACTIONFLAGS" VARCHAR2(255), "EVENTFLAGS" VARCHAR2(255), CONSTRAINT "PK_OBJECT" PRIMARY KEY ("OBJECT_ID") ) / CREATE INDEX "IX_OBJ_OBJECT_TYPE" ON "T_OBJECT" ("OBJECT_TYPE") / CREATE INDEX "IX_OBJ_CLASSIFIER" ON "T_OBJECT" ("CLASSIFIER") / CREATE INDEX "IX_OBJ_CLASSIFIER_GUID" ON "T_OBJECT" ("CLASSIFIER_GUID") / CREATE INDEX "IX_OBJ_NAME" ON "T_OBJECT" ("NAME") / CREATE INDEX "IX_OBJ_NTYPE" ON "T_OBJECT" ("NTYPE") / CREATE INDEX "IX_OBJ_PACKAGEID" ON "T_OBJECT" ("PACKAGE_ID") / CREATE INDEX "IX_OBJ_PARENTID" ON "T_OBJECT" ("PARENTID") / CREATE INDEX "IX_OBJ_PDATA1" ON "T_OBJECT" ("PDATA1") / CREATE INDEX "IX_OBJ_EVENTFLAGS" ON "T_OBJECT" ("EVENTFLAGS") / CREATE INDEX "IX_OBJ_PKG_PD1_CLASS" ON "T_OBJECT" ("PACKAGE_ID", "PDATA1", "CLASSIFIER") / CREATE UNIQUE INDEX "UX_OBJ_EAGUID" ON "T_OBJECT" ("EA_GUID") / ----------------------------------------------------------- PROMPT >>> T_OBJECTCONSTRAINT CREATE TABLE "T_OBJECTCONSTRAINT" ( "OBJECT_ID" NUMBER(10,0) DEFAULT 0 NOT NULL, "Constraint" VARCHAR2(255) NOT NULL, "CONSTRAINTTYPE" VARCHAR2(30) NOT NULL, "WEIGHT" FLOAT(126) DEFAULT 0, "NOTES" CLOB, "STATUS" VARCHAR2(50), CONSTRAINT "PK_OBJECTCONSTRAINT" PRIMARY KEY ("OBJECT_ID", "Constraint", "CONSTRAINTTYPE") ) / CREATE INDEX "IX_OBJCONSTR_CONSTRAINT" ON "T_OBJECTCONSTRAINT" ("Constraint") / CREATE INDEX "IX_OBJCONSTR_OBJECTID" ON "T_OBJECTCONSTRAINT" ("OBJECT_ID") / ----------------------------------------------------------- PROMPT >>> T_OBJECTEFFORT CREATE TABLE "T_OBJECTEFFORT" ( "OBJECT_ID" NUMBER(10,0) DEFAULT 0 NOT NULL, "EFFORT" VARCHAR2(255) NOT NULL, "EFFORTTYPE" VARCHAR2(12), "EVALUE" FLOAT(126) DEFAULT 0, "NOTES" CLOB, CONSTRAINT "PK_OBJECTEFFORT" PRIMARY KEY ("OBJECT_ID", "EFFORT") ) / CREATE INDEX "IX_OBJEFFORT_OBJECTID" ON "T_OBJECTEFFORT" ("OBJECT_ID") / ----------------------------------------------------------- PROMPT >>> T_OBJECTFILES CREATE TABLE "T_OBJECTFILES" ( "OBJECT_ID" NUMBER(10,0) DEFAULT 0 NOT NULL, "FILENAME" VARCHAR2(255) NOT NULL, "TYPE" VARCHAR2(50), "NOTE" CLOB, "FILESIZE" VARCHAR2(255), "FILEDATE" VARCHAR2(255), CONSTRAINT "PK_OBJECTFILES" PRIMARY KEY ("OBJECT_ID", "FILENAME") ) / ----------------------------------------------------------- PROMPT >>> T_OBJECTMETRICS CREATE TABLE "T_OBJECTMETRICS" ( "OBJECT_ID" NUMBER(10,0) DEFAULT 0 NOT NULL, "METRIC" VARCHAR2(255) NOT NULL, "METRICTYPE" VARCHAR2(12) NOT NULL, "EVALUE" FLOAT(126) DEFAULT 1, "NOTES" CLOB, CONSTRAINT "PK_OBJECTMETRICS" PRIMARY KEY ("OBJECT_ID", "METRIC") ) / CREATE INDEX "IX_OBJMET_METTYPE" ON "T_OBJECTMETRICS" ("METRICTYPE") / CREATE INDEX "IX_OBJMET_OBJECTID" ON "T_OBJECTMETRICS" ("OBJECT_ID") / CREATE INDEX "IX_OBJMET_METRIC" ON "T_OBJECTMETRICS" ("METRIC") / ----------------------------------------------------------- PROMPT >>> T_OBJECTPROBLEMS CREATE TABLE "T_OBJECTPROBLEMS" ( "OBJECT_ID" NUMBER(10,0) DEFAULT 0 NOT NULL, "PROBLEM" VARCHAR2(255) NOT NULL, "PROBLEMTYPE" VARCHAR2(255) NOT NULL, "DATEREPORTED" DATE, "STATUS" VARCHAR2(50), "PROBLEMNOTES" CLOB, "REPORTEDBY" VARCHAR2(255), "RESOLVEDBY" VARCHAR2(255), "DATERESOLVED" DATE, "VERSION" VARCHAR2(50), "RESOLVERNOTES" CLOB, "PRIORITY" VARCHAR2(50), "SEVERITY" VARCHAR2(50), CONSTRAINT "PK_OBJECTPROBLEMS" PRIMARY KEY ("OBJECT_ID", "PROBLEM", "PROBLEMTYPE") ) / CREATE INDEX "IX_OBJPROBS_OBJECTID" ON "T_OBJECTPROBLEMS" ("OBJECT_ID") / CREATE INDEX "IX_OBJPROBS_PROB" ON "T_OBJECTPROBLEMS" ("PROBLEM") / ----------------------------------------------------------- PROMPT >>> T_OBJECTPROPERTIES CREATE TABLE "T_OBJECTPROPERTIES" ( "PROPERTYID" NUMBER(10,0), "OBJECT_ID" NUMBER(10,0) DEFAULT 0 NOT NULL, "PROPERTY" VARCHAR2(255), "VALUE" VARCHAR2(255), "NOTES" CLOB, "EA_GUID" VARCHAR2(40), CONSTRAINT "PK_OBJECTPROPERTIES" PRIMARY KEY ("PROPERTYID") ) / CREATE INDEX "IX_OBJPROPS_OBJECTID" ON "T_OBJECTPROPERTIES" ("OBJECT_ID") / CREATE INDEX "IX_OBJPROPS_VALUE" ON "T_OBJECTPROPERTIES" ("VALUE") / ----------------------------------------------------------- PROMPT >>> T_OBJECTREQUIRES CREATE TABLE "T_OBJECTREQUIRES" ( "REQID" NUMBER(10,0), "OBJECT_ID" NUMBER(10,0) DEFAULT 0 NOT NULL, "REQUIREMENT" VARCHAR2(255), "REQTYPE" VARCHAR2(255), "STATUS" VARCHAR2(50), "NOTES" CLOB, "STABILITY" VARCHAR2(50), "DIFFICULTY" VARCHAR2(50), "PRIORITY" VARCHAR2(50), "LASTUPDATE" VARCHAR2(19) DEFAULT SYSDATE, CONSTRAINT "PK_OBJECTREQUIRES" PRIMARY KEY ("REQID") ) / CREATE INDEX "IX_OBJREQ_OBJECTID" ON "T_OBJECTREQUIRES" ("OBJECT_ID") / CREATE INDEX "IX_OBJREQ_REQ" ON "T_OBJECTREQUIRES" ("REQUIREMENT") / ----------------------------------------------------------- PROMPT >>> T_OBJECTRESOURCE CREATE TABLE "T_OBJECTRESOURCE" ( "OBJECT_ID" NUMBER(10,0) DEFAULT 0 NOT NULL, "Resource" VARCHAR2(255) NOT NULL, "ROLE" VARCHAR2(255) NOT NULL, "TIME" FLOAT(126) DEFAULT 0, "NOTES" CLOB, "PERCENTCOMPLETE" NUMBER(5,0) DEFAULT 0, "DATESTART" DATE, "DATEEND" DATE, "HISTORY" CLOB, "EXPECTEDHOURS" NUMBER(10,0), "ACTUALHOURS" NUMBER(10,0), CONSTRAINT "PK_OBJECTRESOURCE" PRIMARY KEY ("OBJECT_ID", "Resource", "ROLE") ) / CREATE INDEX "IX_OBJRES_OBJECTID" ON "T_OBJECTRESOURCE" ("OBJECT_ID") / ----------------------------------------------------------- PROMPT >>> T_OBJECTRISKS CREATE TABLE "T_OBJECTRISKS" ( "OBJECT_ID" NUMBER(10,0) DEFAULT 0 NOT NULL, "RISK" VARCHAR2(255) NOT NULL, "RISKTYPE" VARCHAR2(12), "EVALUE" FLOAT(126) DEFAULT 0, "NOTES" CLOB, CONSTRAINT "PK_OBJECTRISKS" PRIMARY KEY ("OBJECT_ID", "RISK") ) / CREATE INDEX "IX_OBJRISKS_OBJECTID" ON "T_OBJECTRISKS" ("OBJECT_ID") / ----------------------------------------------------------- PROMPT >>> T_OBJECTSCENARIOS CREATE TABLE "T_OBJECTSCENARIOS" ( "OBJECT_ID" NUMBER(10,0) DEFAULT 0 NOT NULL, "SCENARIO" VARCHAR2(255) NOT NULL, "SCENARIOTYPE" VARCHAR2(12), "EVALUE" FLOAT(126) DEFAULT 0, "NOTES" CLOB, "EA_GUID" VARCHAR2(40) NOT NULL, "XMLCONTENT" CLOB, CONSTRAINT "PK_OBJECTSCENARIOS" PRIMARY KEY ("OBJECT_ID", "SCENARIO") ) / CREATE INDEX "IX_OBJSCEN_OBJECTID" ON "T_OBJECTSCENARIOS" ("OBJECT_ID") / CREATE INDEX "IX_OBJSCEN_IDEVALSCEN" ON "T_OBJECTSCENARIOS" ("OBJECT_ID", "EVALUE", "SCENARIO") / ----------------------------------------------------------- PROMPT >>> T_OBJECTTESTS CREATE TABLE "T_OBJECTTESTS" ( "OBJECT_ID" NUMBER(10,0) DEFAULT 0 NOT NULL, "TEST" VARCHAR2(255) NOT NULL, "TESTCLASS" NUMBER(10,0) DEFAULT 0 NOT NULL, "TESTTYPE" VARCHAR2(50), "NOTES" CLOB, "INPUTDATA" CLOB, "ACCEPTANCECRITERIA" CLOB, "STATUS" VARCHAR2(32), "DATERUN" DATE DEFAULT SYSDATE, "RESULTS" CLOB, "RUNBY" VARCHAR2(255), "CHECKBY" VARCHAR2(255), CONSTRAINT "PK_OBJECTTESTS" PRIMARY KEY ("OBJECT_ID", "TEST", "TESTCLASS") ) / CREATE INDEX "IX_OBJTESTS_OBJECTID" ON "T_OBJECTTESTS" ("OBJECT_ID") / ----------------------------------------------------------- PROMPT >>> T_OBJECTTRX CREATE TABLE "T_OBJECTTRX" ( "OBJECT_ID" NUMBER(10,0) DEFAULT 0 NOT NULL, "TRX" VARCHAR2(255) NOT NULL, "TRXTYPE" VARCHAR2(12) NOT NULL, "WEIGHT" FLOAT(126) DEFAULT 0, "NOTES" CLOB, CONSTRAINT "PK_OBJECTTRX" PRIMARY KEY ("OBJECT_ID", "TRX", "TRXTYPE") ) / CREATE INDEX "IX_OBJTRX_TRX" ON "T_OBJECTTRX" ("TRX") / CREATE INDEX "IX_OBJTRX_OBJECTID" ON "T_OBJECTTRX" ("OBJECT_ID") / ----------------------------------------------------------- PROMPT >>> T_OBJECTTYPES CREATE TABLE "T_OBJECTTYPES" ( "OBJECT_TYPE" VARCHAR2(50), "DESCRIPTION" VARCHAR2(255), "DESIGNOBJECT" NUMBER(10,0), "IMAGEID" NUMBER(5,0) DEFAULT 0 NOT NULL, CONSTRAINT "PK_OBJECTTYPES" PRIMARY KEY ("OBJECT_TYPE") ) / CREATE INDEX "IX_OBJTYPES_IMAGEID" ON "T_OBJECTTYPES" ("IMAGEID") / ----------------------------------------------------------- PROMPT >>> T_OCF CREATE TABLE "T_OCF" ( "OBJECTTYPE" VARCHAR2(50), "COMPLEXITYWEIGHT" FLOAT(126) DEFAULT 0 ) / ----------------------------------------------------------- PROMPT >>> T_OPERATION CREATE TABLE "T_OPERATION" ( "OPERATIONID" NUMBER(10,0), "OBJECT_ID" NUMBER(10,0) DEFAULT 0 NOT NULL, "NAME" VARCHAR2(255) NOT NULL, "SCOPE" VARCHAR2(50), "TYPE" VARCHAR2(255), "RETURNARRAY" CHAR(1), "STEREOTYPE" VARCHAR2(50), "ISSTATIC" CHAR(1), "CONCURRENCY" VARCHAR2(50), "NOTES" CLOB, "BEHAVIOUR" CLOB, "ABSTRACT" CHAR(1), "GENOPTION" CLOB, "SYNCHRONIZED" CHAR(1), "POS" NUMBER(10,0), "CONST" NUMBER(10,0), "STYLE" VARCHAR2(255), "PURE" NUMBER(10,0), "THROWS" VARCHAR2(255), "CLASSIFIER" VARCHAR2(50), "CODE" CLOB, "ISROOT" NUMBER(10,0), "ISLEAF" NUMBER(10,0), "ISQUERY" NUMBER(10,0), "STATEFLAGS" VARCHAR2(255), "EA_GUID" VARCHAR2(50) NOT NULL, "STYLEEX" CLOB, CONSTRAINT "PK_OPERATION" PRIMARY KEY ("OPERATIONID") ) / CREATE INDEX "IX_OP_CLASSIFIER" ON "T_OPERATION" ("CLASSIFIER") / CREATE UNIQUE INDEX "UX_OP_EAGUID" ON "T_OPERATION" ("EA_GUID") / CREATE INDEX "IX_OP_NAME" ON "T_OPERATION" ("NAME") / CREATE INDEX "IX_OP_OBJECT_ID" ON "T_OPERATION" ("OBJECT_ID") / ----------------------------------------------------------- PROMPT >>> T_OPERATIONPARAMS CREATE TABLE "T_OPERATIONPARAMS" ( "OPERATIONID" NUMBER(10,0) DEFAULT 0 NOT NULL, "NAME" VARCHAR2(255) NOT NULL, "TYPE" VARCHAR2(255), "Default" VARCHAR2(255), "NOTES" CLOB, "POS" NUMBER(10,0) NOT NULL, "CONST" NUMBER(10,0), "STYLE" VARCHAR2(255), "KIND" VARCHAR2(12), "CLASSIFIER" VARCHAR2(50), "EA_GUID" VARCHAR2(50), "STYLEEX" CLOB, CONSTRAINT "PK_OPERATIONPARAMS" PRIMARY KEY ("OPERATIONID", "NAME") ) / CREATE INDEX "IX_OPPARAMS_CLASSIFIER" ON "T_OPERATIONPARAMS" ("CLASSIFIER") / CREATE UNIQUE INDEX "UX_OPPARAMS_EAGUID" ON "T_OPERATIONPARAMS" ("EA_GUID") / CREATE INDEX "IX_OPPARAMS_OPID" ON "T_OPERATIONPARAMS" ("OPERATIONID") / CREATE INDEX "IX_OPPARAMS_OPID_POS" ON "T_OPERATIONPARAMS" ("OPERATIONID", "POS") / ----------------------------------------------------------- PROMPT >>> T_OPERATIONPOSTS CREATE TABLE "T_OPERATIONPOSTS" ( "OPERATIONID" NUMBER(10,0) DEFAULT 0 NOT NULL, "POSTCONDITION" VARCHAR2(255) NOT NULL, "TYPE" VARCHAR2(255), "NOTES" CLOB, CONSTRAINT "PK_OPERATIONPOSTS" PRIMARY KEY ("OPERATIONID", "POSTCONDITION") ) / CREATE INDEX "IX_OPPOST_OPID" ON "T_OPERATIONPOSTS" ("OPERATIONID") / ----------------------------------------------------------- PROMPT >>> T_OPERATIONPRES CREATE TABLE "T_OPERATIONPRES" ( "OPERATIONID" NUMBER(10,0) DEFAULT 0 NOT NULL, "PRECONDITION" VARCHAR2(255) NOT NULL, "TYPE" VARCHAR2(50), "NOTES" CLOB, CONSTRAINT "PK_OPERATIONPRES" PRIMARY KEY ("OPERATIONID", "PRECONDITION") ) / CREATE INDEX "IX_OPPRES_OPID" ON "T_OPERATIONPRES" ("OPERATIONID") / ----------------------------------------------------------- PROMPT >>> T_OPERATIONTAG CREATE TABLE "T_OPERATIONTAG" ( "PROPERTYID" NUMBER(10,0), "ELEMENTID" NUMBER(10,0) NOT NULL, "PROPERTY" VARCHAR2(255), "VALUE" VARCHAR2(255), "NOTES" CLOB, "EA_GUID" VARCHAR2(40), CONSTRAINT "PK_OPERATIONTAG" PRIMARY KEY ("PROPERTYID") ) / CREATE INDEX "IX_OPTAG_ELEMENTID" ON "T_OPERATIONTAG" ("ELEMENTID") / CREATE INDEX "IX_OPTAG_VALUE" ON "T_OPERATIONTAG" ("VALUE") / ----------------------------------------------------------- PROMPT >>> T_PACKAGE CREATE TABLE "T_PACKAGE" ( "PACKAGE_ID" NUMBER(10,0), "NAME" VARCHAR2(255), "PARENT_ID" NUMBER(10,0) DEFAULT 0 NOT NULL, "CREATEDDATE" DATE DEFAULT SYSDATE, "MODIFIEDDATE" DATE DEFAULT SYSDATE, "NOTES" CLOB, "EA_GUID" VARCHAR2(40) NOT NULL, "XMLPATH" VARCHAR2(255), "ISCONTROLLED" NUMBER(10,0), "LASTLOADDATE" DATE, "LASTSAVEDATE" DATE, "VERSION" VARCHAR2(50), "PROTECTED" NUMBER(10,0), "PKGOWNER" VARCHAR2(255), "UMLVERSION" VARCHAR2(50), "USEDTD" NUMBER(10,0), "LOGXML" NUMBER(10,0), "CODEPATH" VARCHAR2(255), "NAMESPACE" VARCHAR2(50), "TPOS" NUMBER(10,0), "PACKAGEFLAGS" VARCHAR2(255), "BATCHSAVE" NUMBER(10,0), "BATCHLOAD" NUMBER(10,0), CONSTRAINT "PK_PACKAGE" PRIMARY KEY ("PACKAGE_ID") ) / CREATE INDEX "IX_PACKAGE_PARENTID" ON "T_PACKAGE" ("PARENT_ID") / CREATE INDEX "IX_PACKAGE_NAME" ON "T_PACKAGE" ("NAME") / CREATE UNIQUE INDEX "UX_PACKAGE_EAGUID" ON "T_PACKAGE" ("EA_GUID") / ----------------------------------------------------------- PROMPT >>> T_PALETTE CREATE TABLE "T_PALETTE" ( "PALETTEID" NUMBER(10,0), "NAME" VARCHAR2(255), "TYPE" VARCHAR2(255), CONSTRAINT "UC_PALETTE" UNIQUE ("PALETTEID") ) / ----------------------------------------------------------- PROMPT >>> T_PALETTEITEM CREATE TABLE "T_PALETTEITEM" ( "PALETTEID" NUMBER(10,0), "ITEMID" NUMBER(10,0) ) / ----------------------------------------------------------- PROMPT >>> T_PHASE CREATE TABLE "T_PHASE" ( "PHASEID" VARCHAR2(40), "PHASENAME" VARCHAR2(100) NOT NULL, "PHASENOTES" CLOB, "PHASESTYLE" VARCHAR2(255), "STARTDATE" DATE, "ENDDATE" DATE, "PHASECONTENT" CLOB, CONSTRAINT "PK_PHASE" PRIMARY KEY ("PHASEID") ) / ----------------------------------------------------------- PROMPT >>> T_PRIMITIVES CREATE TABLE "T_PRIMITIVES" ( "DATATYPE" VARCHAR2(50), "DESCRIPTION" VARCHAR2(50), CONSTRAINT "PK_PRIMITIVES" PRIMARY KEY ("DATATYPE") ) / ----------------------------------------------------------- PROMPT >>> T_PROBLEMTYPES CREATE TABLE "T_PROBLEMTYPES" ( "PROBLEMTYPE" VARCHAR2(12), "DESCRIPTION" VARCHAR2(255), "NUMERICWEIGHT" FLOAT(126) DEFAULT 1 NOT NULL, "NOTES" VARCHAR2(255), CONSTRAINT "PK_PROBLEMTYPES" PRIMARY KEY ("PROBLEMTYPE") ) / CREATE INDEX "IX_PROBTYPES_NUMWEIGHT" ON "T_PROBLEMTYPES" ("NUMERICWEIGHT") / ----------------------------------------------------------- PROMPT >>> T_PROJECTROLES CREATE TABLE "T_PROJECTROLES" ( "ROLE" VARCHAR2(255), "DESCRIPTION" VARCHAR2(255), "NOTES" CLOB, CONSTRAINT "PK_PROJECTROLES" PRIMARY KEY ("ROLE") ) / ----------------------------------------------------------- PROMPT >>> T_PROPERTYTYPES CREATE TABLE "T_PROPERTYTYPES" ( "PROPERTY" VARCHAR2(50), "DESCRIPTION" VARCHAR2(50), "NOTES" CLOB, CONSTRAINT "PK_PROPERTYTYPES" PRIMARY KEY ("PROPERTY") ) / ----------------------------------------------------------- PROMPT >>> T_REQUIRETYPES CREATE TABLE "T_REQUIRETYPES" ( "REQUIREMENT" VARCHAR2(12), "DESCRIPTION" VARCHAR2(50), "NUMERICWEIGHT" FLOAT(126) DEFAULT 1 NOT NULL, "NOTES" VARCHAR2(255), CONSTRAINT "PK_REQUIRETYPES" PRIMARY KEY ("REQUIREMENT") ) / CREATE INDEX "IX_REQTYPES_NUMWEIGHT" ON "T_REQUIRETYPES" ("NUMERICWEIGHT") / ----------------------------------------------------------- PROMPT >>> T_RESOURCES CREATE TABLE "T_RESOURCES" ( "NAME" VARCHAR2(255), "ORGANISATION" VARCHAR2(255), "PHONE1" VARCHAR2(50), "PHONE2" VARCHAR2(50), "MOBILE" VARCHAR2(50), "FAX" VARCHAR2(50), "EMAIL" VARCHAR2(255), "ROLES" VARCHAR2(255), "NOTES" VARCHAR2(255), CONSTRAINT "PK_RESOURCES" PRIMARY KEY ("NAME") ) / ----------------------------------------------------------- PROMPT >>> T_RISKTYPES CREATE TABLE "T_RISKTYPES" ( "RISK" VARCHAR2(12), "DESCRIPTION" VARCHAR2(50), "NUMERICWEIGHT" FLOAT(126) DEFAULT 0 NOT NULL, "NOTES" VARCHAR2(255), CONSTRAINT "PK_RISKTYPES" PRIMARY KEY ("RISK") ) / CREATE INDEX "IX_RISKTYPES_NUMWEIGHT" ON "T_RISKTYPES" ("NUMERICWEIGHT") / ----------------------------------------------------------- PROMPT >>> T_ROLECONSTRAINT CREATE TABLE "T_ROLECONSTRAINT" ( "CONNECTORID" NUMBER(10,0) DEFAULT 0 NOT NULL, "Constraint" VARCHAR2(255) NOT NULL, "CONNECTOREND" VARCHAR2(50) NOT NULL, "CONSTRAINTTYPE" VARCHAR2(12) NOT NULL, "NOTES" CLOB, CONSTRAINT "PK_ROLECONSTRAINT" PRIMARY KEY ("CONNECTORID", "Constraint", "CONNECTOREND", "CONSTRAINTTYPE") ) / CREATE INDEX "IX_ROLECONSTR_CONSTR" ON "T_ROLECONSTRAINT" ("Constraint") / CREATE INDEX "IX_ROLECONSTR_CONNID" ON "T_ROLECONSTRAINT" ("CONNECTORID") / ----------------------------------------------------------- PROMPT >>> T_RTF CREATE TABLE "T_RTF" ( "TYPE" VARCHAR2(50), "TEMPLATE" CLOB ) / ----------------------------------------------------------- PROMPT >>> T_RTFREPORT CREATE TABLE "T_RTFREPORT" ( "TEMPLATEID" VARCHAR2(200), "ROOTPACKAGE" NUMBER(10,0) DEFAULT 0, "FILENAME" VARCHAR2(255), "DETAILS" NUMBER(10,0), "PROCESSCHILDREN" NUMBER(10,0), "SHOWDIAGRAMS" NUMBER(10,0), "HEADING" VARCHAR2(255), "REQUIREMENTS" NUMBER(10,0), "ASSOCIATIONS" NUMBER(10,0), "SCENARIOS" NUMBER(10,0), "CHILDDIAGRAMS" NUMBER(10,0), "ATTRIBUTES" NUMBER(10,0), "METHODS" NUMBER(10,0), "IMAGETYPE" NUMBER(10,0) DEFAULT 0, "PAGING" NUMBER(10,0), "INTRO" CLOB, "RESOURCES" NUMBER(10,0) DEFAULT 1, "Constraints" NUMBER(10,0) DEFAULT 1, "TAGGED" NUMBER(10,0), "SHOWTAG" NUMBER(10,0), "SHOWALIAS" NUMBER(10,0), "PDATA1" VARCHAR2(255), "PDATA2" VARCHAR2(255), "PDATA3" VARCHAR2(255), "PDATA4" CLOB, CONSTRAINT "PK_RTFREPORT" PRIMARY KEY ("TEMPLATEID") ) / ----------------------------------------------------------- PROMPT >>> T_RULES CREATE TABLE "T_RULES" ( "RULEID" VARCHAR2(50), "RULENAME" VARCHAR2(255) NOT NULL, "RULETYPE" VARCHAR2(255) NOT NULL, "RULEACTIVE" NUMBER(10,0) NOT NULL, "ERRORMSG" VARCHAR2(255), "FLAGS" VARCHAR2(255), "RULEOCL" CLOB, "RULEXML" CLOB, "NOTES" CLOB, CONSTRAINT "PK_RULES" PRIMARY KEY ("RULEID") ) / ----------------------------------------------------------- PROMPT >>> T_SCENARIOTYPES CREATE TABLE "T_SCENARIOTYPES" ( "SCENARIOTYPE" VARCHAR2(12), "DESCRIPTION" VARCHAR2(50), "NUMERICWEIGHT" FLOAT(126) DEFAULT 1 NOT NULL, "NOTES" VARCHAR2(255), CONSTRAINT "PK_SCENARIOTYPES" PRIMARY KEY ("SCENARIOTYPE") ) / CREATE INDEX "IX_SCENTYPES_NUMWEIGHT" ON "T_SCENARIOTYPES" ("NUMERICWEIGHT") / ----------------------------------------------------------- PROMPT >>> T_SCRIPT CREATE TABLE "T_SCRIPT" ( "SCRIPTID" NUMBER(10,0), "SCRIPTCATEGORY" VARCHAR2(100), "SCRIPTNAME" VARCHAR2(150), "SCRIPTAUTHOR" VARCHAR2(255), "NOTES" CLOB, "SCRIPT" CLOB, CONSTRAINT "PK_SCRIPT" PRIMARY KEY ("SCRIPTID") ) / ----------------------------------------------------------- PROMPT >>> T_SECGROUP CREATE TABLE "T_SECGROUP" ( "GROUPID" VARCHAR2(40), "GROUPNAME" VARCHAR2(32) NOT NULL, "DESCRIPTION" VARCHAR2(100), CONSTRAINT "PK_SECGROUP" PRIMARY KEY ("GROUPID") ) / ----------------------------------------------------------- PROMPT >>> T_SECGROUPPERMISSION CREATE TABLE "T_SECGROUPPERMISSION" ( "GROUPID" VARCHAR2(40) NOT NULL, "PERMISSIONID" NUMBER(10,0) NOT NULL, CONSTRAINT "PK_SECGROUPPERMISSION" PRIMARY KEY ("GROUPID", "PERMISSIONID") ) / ----------------------------------------------------------- PROMPT >>> T_SECLOCKS CREATE TABLE "T_SECLOCKS" ( "USERID" VARCHAR2(40) NOT NULL, "GROUPID" VARCHAR2(40), "ENTITYTYPE" VARCHAR2(32) NOT NULL, "ENTITYID" VARCHAR2(40), "TIMESTAMP" DATE NOT NULL, "LOCKTYPE" VARCHAR2(255), CONSTRAINT "PK_SECLOCKS" PRIMARY KEY ("ENTITYID") ) / ----------------------------------------------------------- PROMPT >>> T_SECPERMISSION CREATE TABLE "T_SECPERMISSION" ( "PERMISSIONID" NUMBER(10,0), "PERMISSIONNAME" VARCHAR2(50) NOT NULL, CONSTRAINT "PK_SECPERMISSION" PRIMARY KEY ("PERMISSIONID") ) / ----------------------------------------------------------- PROMPT >>> T_SECPOLICIES CREATE TABLE "T_SECPOLICIES" ( "PROPERTY" VARCHAR2(100), "VALUE" VARCHAR2(255) NOT NULL, CONSTRAINT "PK_SECPOLICIES" PRIMARY KEY ("PROPERTY") ) / ----------------------------------------------------------- PROMPT >>> T_SECUSER CREATE TABLE "T_SECUSER" ( "USERID" VARCHAR2(40), "USERLOGIN" VARCHAR2(32) NOT NULL, "FIRSTNAME" VARCHAR2(50) NOT NULL, "SURNAME" VARCHAR2(50) NOT NULL, "DEPARTMENT" VARCHAR2(50), "PASSWORD" VARCHAR2(12), CONSTRAINT "PK_SECUSER" PRIMARY KEY ("USERID") ) / ----------------------------------------------------------- PROMPT >>> T_SECUSERGROUP CREATE TABLE "T_SECUSERGROUP" ( "USERID" VARCHAR2(40) NOT NULL, "GROUPID" VARCHAR2(40) NOT NULL, CONSTRAINT "PK_SECUSERGROUP" PRIMARY KEY ("USERID", "GROUPID") ) / ----------------------------------------------------------- PROMPT >>> T_SECUSERPERMISSION CREATE TABLE "T_SECUSERPERMISSION" ( "USERID" VARCHAR2(40) NOT NULL, "PERMISSIONID" NUMBER(10,0) NOT NULL, CONSTRAINT "PK_SECUSERPERMISSION" PRIMARY KEY ("USERID", "PERMISSIONID") ) / ----------------------------------------------------------- PROMPT >>> T_SNAPSHOT CREATE TABLE "T_SNAPSHOT" ( "SNAPSHOTID" VARCHAR2(40), "SERIESID" VARCHAR2(40) NOT NULL, "POSITION" NUMBER(10,0) NOT NULL, "SNAPSHOTNAME" VARCHAR2(100) NOT NULL, "NOTES" CLOB, "STYLE" VARCHAR2(255) NOT NULL, "ELEMENTID" VARCHAR2(40), "ELEMENTTYPE" VARCHAR2(50) NOT NULL, "STRCONTENT" CLOB, "BINCONTENT1" BLOB, "BINCONTENT2" BLOB, CONSTRAINT "PK_SNAPSHOT" PRIMARY KEY ("SNAPSHOTID") ) / ----------------------------------------------------------- PROMPT >>> T_STATUSTYPES CREATE TABLE "T_STATUSTYPES" ( "STATUS" VARCHAR2(50), "DESCRIPTION" VARCHAR2(50), CONSTRAINT "PK_STATUSTYPES" PRIMARY KEY ("STATUS") ) / ----------------------------------------------------------- PROMPT >>> T_STEREOTYPES CREATE TABLE "T_STEREOTYPES" ( "STEREOTYPE" VARCHAR2(255) NOT NULL, "APPLIESTO" VARCHAR2(255) NOT NULL, "DESCRIPTION" VARCHAR2(255), "MFENABLED" NUMBER(10,0), "MFPATH" VARCHAR2(255), "METAFILE" BLOB, "STYLE" CLOB, "EA_GUID" VARCHAR2(50) NOT NULL, "VISUALTYPE" VARCHAR2(100), CONSTRAINT "PK_STEREOTYPES" PRIMARY KEY ("STEREOTYPE", "APPLIESTO") ) / CREATE INDEX "IX_STEROTYPES_STEREOTYPE" ON "T_STEREOTYPES" ("STEREOTYPE") / ----------------------------------------------------------- PROMPT >>> T_TAGGEDVALUE CREATE TABLE "T_TAGGEDVALUE" ( "PROPERTYID" VARCHAR2(40), "ELEMENTID" VARCHAR2(40) NOT NULL, "BASECLASS" VARCHAR2(100) NOT NULL, "TAGVALUE" CLOB, "NOTES" CLOB, CONSTRAINT "PK_TAGGEDVALUE" PRIMARY KEY ("PROPERTYID") ) / CREATE INDEX "IX_TAGVAL_ELEMID" ON "T_TAGGEDVALUE" ("ELEMENTID") / ----------------------------------------------------------- PROMPT >>> T_TASKS CREATE TABLE "T_TASKS" ( "TASKID" NUMBER(10,0), "NAME" VARCHAR2(255), "TASKTYPE" VARCHAR2(255), "NOTES" CLOB, "PRIORITY" VARCHAR2(255), "STATUS" VARCHAR2(255), "OWNER" VARCHAR2(255), "STARTDATE" DATE, "ENDDATE" DATE, "PHASE" VARCHAR2(50), "HISTORY" CLOB, "PERCENT" NUMBER(10,0), "TOTALTIME" NUMBER(10,0), "ACTUALTIME" NUMBER(10,0), "ASSIGNEDTO" VARCHAR2(255), CONSTRAINT "PK_TASKS" PRIMARY KEY ("TASKID") ) / ----------------------------------------------------------- PROMPT >>> T_TCF CREATE TABLE "T_TCF" ( "TCFID" VARCHAR2(12) NOT NULL, "DESCRIPTION" VARCHAR2(50), "WEIGHT" FLOAT(126) DEFAULT 1 NOT NULL, "VALUE" FLOAT(126) DEFAULT 0, "NOTES" VARCHAR2(255), CONSTRAINT "PK_TCF" PRIMARY KEY ("TCFID") ) / CREATE INDEX "IX_TCF_NUMWEIGHT" ON "T_TCF" ("WEIGHT") / ----------------------------------------------------------- PROMPT >>> T_TEMPLATE CREATE TABLE "T_TEMPLATE" ( "TEMPLATEID" VARCHAR2(40), "TEMPLATETYPE" VARCHAR2(50) NOT NULL, "TEMPLATENAME" VARCHAR2(100) NOT NULL, "NOTES" VARCHAR2(255), "STYLE" VARCHAR2(255), "TEMPLATE" CLOB, CONSTRAINT "PK_TEMPLATE" PRIMARY KEY ("TEMPLATEID") ) / ----------------------------------------------------------- PROMPT >>> T_TESTCLASS CREATE TABLE "T_TESTCLASS" ( "TESTCLASS" VARCHAR2(50), "DESCRIPTION" VARCHAR2(50), CONSTRAINT "PK_TESTCLASS" PRIMARY KEY ("TESTCLASS") ) / ----------------------------------------------------------- PROMPT >>> T_TESTPLANS CREATE TABLE "T_TESTPLANS" ( "PLANID" VARCHAR2(50), "CATEGORY" VARCHAR2(100) NOT NULL, "NAME" VARCHAR2(150) NOT NULL, "AUTHOR" VARCHAR2(255), "NOTES" CLOB, "TESTPLAN" CLOB, CONSTRAINT "PK_TESTPLANS" PRIMARY KEY ("PLANID") ) / ----------------------------------------------------------- PROMPT >>> T_TESTTYPES CREATE TABLE "T_TESTTYPES" ( "TESTTYPE" VARCHAR2(12), "DESCRIPTION" VARCHAR2(50), "NUMERICWEIGHT" FLOAT(126) DEFAULT 1 NOT NULL, "NOTES" VARCHAR2(255), CONSTRAINT "PK_TESTTYPES" PRIMARY KEY ("TESTTYPE") ) / CREATE INDEX "IX_TESTTYPES_NUMWEIGHT" ON "T_TESTTYPES" ("NUMERICWEIGHT") / ----------------------------------------------------------- PROMPT >>> T_TRXTYPES CREATE TABLE "T_TRXTYPES" ( "TRX" VARCHAR2(255), "DESCRIPTION" VARCHAR2(50), "NUMERICWEIGHT" FLOAT(126) DEFAULT 1, "NOTES" CLOB, "STYLE" CLOB, "TRX_ID" NUMBER(10,0), CONSTRAINT "PK_TRXTYPES" PRIMARY KEY ("TRX_ID") ) / CREATE INDEX "IX_TRXTYPES_NUMWEIGHT" ON "T_TRXTYPES" ("NUMERICWEIGHT") / ----------------------------------------------------------- PROMPT >>> T_UMLPATTERN CREATE TABLE "T_UMLPATTERN" ( "PATTERNID" NUMBER(10,0), "PATTERNCATEGORY" VARCHAR2(100), "PATTERNNAME" VARCHAR2(150) NOT NULL, "STYLE" VARCHAR2(250), "NOTES" CLOB, "PATTERNXML" CLOB NOT NULL, "VERSION" VARCHAR2(50), CONSTRAINT "PK_UMLPATTERN" PRIMARY KEY ("PATTERNID") ) / ----------------------------------------------------------- PROMPT >>> T_VERSION CREATE TABLE "T_VERSION" ( "ELEMENTID" VARCHAR2(50) NOT NULL, "VERSIONID" VARCHAR2(255) NOT NULL, "ELEMENTTYPE" VARCHAR2(100) NOT NULL, "FLAGS" VARCHAR2(255), "EXTERNALFILE" VARCHAR2(255), "NOTES" VARCHAR2(255), "OWNER" VARCHAR2(255), "VERSIONDATE" DATE NOT NULL, "BRANCH" VARCHAR2(255), "ELEMENTXML" CLOB, CONSTRAINT "PK_VERSION" PRIMARY KEY ("ELEMENTID", "VERSIONID") ) / CREATE INDEX "IX_VERSION_ELEMID" ON "T_VERSION" ("ELEMENTID") / ----------------------------------------------------------- PROMPT >>> T_XREF CREATE TABLE "T_XREF" ( "XREFID" VARCHAR2(255), "NAME" VARCHAR2(255), "TYPE" VARCHAR2(255) NOT NULL, "VISIBILITY" VARCHAR2(255), "NAMESPACE" VARCHAR2(255), "REQUIREMENT" VARCHAR2(255), "Constraint" VARCHAR2(255), "BEHAVIOR" VARCHAR2(255), "PARTITION" VARCHAR2(255), "DESCRIPTION" CLOB, "CLIENT" VARCHAR2(255), "SUPPLIER" VARCHAR2(255), "LINK" VARCHAR2(255), CONSTRAINT "PK_XREF" PRIMARY KEY ("XREFID") ) / CREATE INDEX "IX_XREF_CLIENT" ON "T_XREF" ("CLIENT") / CREATE INDEX "IX_XREF_SUPPLIER" ON "T_XREF" ("SUPPLIER") / CREATE INDEX "IX_XREF_TYPE" ON "T_XREF" ("TYPE") / CREATE INDEX "IX_XREF_NAME" ON "T_XREF" ("NAME") / ----------------------------------------------------------- PROMPT >>> T_XREFSYSTEM CREATE TABLE "T_XREFSYSTEM" ( "XREFID" VARCHAR2(255), "NAME" VARCHAR2(255), "TYPE" VARCHAR2(255) NOT NULL, "VISIBILITY" VARCHAR2(255), "NAMESPACE" VARCHAR2(255), "REQUIREMENT" VARCHAR2(255), "Constraint" VARCHAR2(255), "BEHAVIOR" VARCHAR2(255), "PARTITION" VARCHAR2(255), "DESCRIPTION" CLOB, "CLIENT" VARCHAR2(255), "SUPPLIER" VARCHAR2(255), "LINK" VARCHAR2(255), "TOOLID" VARCHAR2(50), CONSTRAINT "PK_XREFSYSTEM" PRIMARY KEY ("XREFID") ) / CREATE INDEX "IX_XREFSYSTEM_CLIENT" ON "T_XREFSYSTEM" ("CLIENT") / CREATE INDEX "IX_XREFSYSTEM_SUPPLIER" ON "T_XREFSYSTEM" ("SUPPLIER") / CREATE INDEX "IX_XREFSYSTEM_TYPE" ON "T_XREFSYSTEM" ("TYPE") / ----------------------------------------------------------- PROMPT >>> T_XREFUSER CREATE TABLE "T_XREFUSER" ( "XREFID" VARCHAR2(255), "NAME" VARCHAR2(255), "TYPE" VARCHAR2(255) NOT NULL, "VISIBILITY" VARCHAR2(255), "NAMESPACE" VARCHAR2(255), "REQUIREMENT" VARCHAR2(255), "Constraint" VARCHAR2(255), "BEHAVIOR" VARCHAR2(255), "PARTITION" VARCHAR2(255), "DESCRIPTION" CLOB, "CLIENT" VARCHAR2(255), "SUPPLIER" VARCHAR2(255), "LINK" VARCHAR2(255), "TOOLID" VARCHAR2(50), CONSTRAINT "PK_XREFUSER" PRIMARY KEY ("XREFID") ) / CREATE INDEX "IX_XREFUSER_CLIENT" ON "T_XREFUSER" ("CLIENT") / CREATE INDEX "IX_XREFUSER_SUPPLIER" ON "T_XREFUSER" ("SUPPLIER") / CREATE INDEX "IX_XREFUSER_TYPE" ON "T_XREFUSER" ("TYPE") / ----------------------------------------------------------- PROMPT >>> USYS_SYSTEM CREATE TABLE "USYS_SYSTEM" ( "PROPERTY" VARCHAR2(50), "VALUE" VARCHAR2(50), CONSTRAINT "PK_USYS_SYSTEM" PRIMARY KEY ("PROPERTY") ) / ----------------------------------------------------------- PROMPT >>> USYSTABLES CREATE TABLE "USYSTABLES" ( "TABLENAME" VARCHAR2(50), "RELORDER" NUMBER(10,0) DEFAULT 0, "DISPLAYNAME" VARCHAR2(50), "FROMVER" VARCHAR2(50), "TOVER" VARCHAR2(50), CONSTRAINT "PK_USYSTABLES" PRIMARY KEY ("TABLENAME") ) / ----------------------------------------------------------- PROMPT >>> USYSOLDTABLES CREATE TABLE "USYSOLDTABLES" ( "TABLENAME" VARCHAR2(50), "NEWNAME" VARCHAR2(50), "RELORDER" NUMBER(10,0) DEFAULT 0, "FIXCODE" NUMBER(10,0) ) / ----------------------------------------------------------- PROMPT >>> USYSQUERIES CREATE TABLE "USYSQUERIES" ( "QUERYNAME" VARCHAR2(50), "NEWNAME" VARCHAR2(50), "FIXCODE" NUMBER(10,0) ) / PROMPT >>> Done!