Skip to main content
summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
Diffstat (limited to 'plugins/org.eclipse.osee.framework.core.datastore/support')
-rw-r--r--plugins/org.eclipse.osee.framework.core.datastore/support/SKYNET.VERSIONING.SCHEMA.xml1240
1 files changed, 620 insertions, 620 deletions
diff --git a/plugins/org.eclipse.osee.framework.core.datastore/support/SKYNET.VERSIONING.SCHEMA.xml b/plugins/org.eclipse.osee.framework.core.datastore/support/SKYNET.VERSIONING.SCHEMA.xml
index bef6084cf2..31eb377790 100644
--- a/plugins/org.eclipse.osee.framework.core.datastore/support/SKYNET.VERSIONING.SCHEMA.xml
+++ b/plugins/org.eclipse.osee.framework.core.datastore/support/SKYNET.VERSIONING.SCHEMA.xml
@@ -1,620 +1,620 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<TableConfig>
-
- <!-- _____________________________________________________ -->
- <!-- -->
- <!-- MAIN ARTIFACT TABLES -->
- <!-- -->
- <!-- _____________________________________________________ -->
-
- <Table name="OSEE_ARTIFACT" schema="OSEE" tablespace="osee_data">
- <Column id="GAMMA_ID" defaultValue="not null" type="BIGINT" />
- <Column id="ART_ID" defaultValue="not null" type="INTEGER" />
- <Column id="ART_TYPE_ID" defaultValue="not null" type="smallint" />
- <Column id="GUID" defaultValue="not null" limits="22" type="VARCHAR" />
- <Column id="HUMAN_READABLE_ID" defaultValue="not null" limits="5" type="VARCHAR" />
- <Constraint schema="OSEE" id="OSEE_ARTS__G_A_PK" type="PRIMARY KEY" appliesTo="ART_ID, GAMMA_ID" />
- <Constraint schema="OSEE" id="OSEE_ARTS__ART_TYPE_ID_FK" type="FOREIGN KEY" appliesTo="ART_TYPE_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_ARTIFACT_TYPE" column="ART_TYPE_ID" />
- </Constraint>
- <Index id="OSEE_ARTS__ART_ID_IDX" tablespace="osee_data">
- <AppliesTo id="ART_ID"/>
- </Index>
- <Index id="OSEE_ARTS__GUID_IDX" tablespace="osee_data">
- <AppliesTo id="GUID"/>
- </Index>
- <Index id="OSEE_ARTS__ART_TYPE_ID_IDX" tablespace="osee_data">
- <AppliesTo id="ART_TYPE_ID"/>
- </Index>
- </Table>
-
- <Table name="OSEE_JOIN_ARTIFACT" schema="OSEE" tablespace="osee_data">
- <Column id="QUERY_ID" defaultValue="not null" type="INTEGER" />
- <Column id="ART_ID" defaultValue="not null" type="INTEGER" />
- <Column id="BRANCH_ID" defaultValue="not null" type="INTEGER" />
- <Column id="TRANSACTION_ID" type="INTEGER" />
- <Column id="INSERT_TIME" defaultValue="not null" type="TIMESTAMP" />
- <Index id="OSEE_JOIN_ART__Q_A_B_T_IDX" type="UNIQUE" tablespace="osee_data">
- <AppliesTo id="QUERY_ID"/>
- <AppliesTo id="ART_ID"/>
- <AppliesTo id="BRANCH_ID"/>
- <AppliesTo id="TRANSACTION_ID"/>
- </Index>
- </Table>
-
- <Table name="OSEE_JOIN_ID" schema="OSEE" tablespace="osee_data">
- <Column id="QUERY_ID" defaultValue="not null" type="INTEGER" />
- <Column id="ID" type="INTEGER" />
- <Column id="INSERT_TIME" defaultValue="not null" type="TIMESTAMP" />
- <Index id="OSEE_JOIN_ID__Q_I_IDX" type="UNIQUE" tablespace="osee_data">
- <AppliesTo id="QUERY_ID"/>
- <AppliesTo id="ID"/>
- </Index>
- </Table>
-
- <Table name="OSEE_JOIN_CLEANUP" schema="OSEE" tablespace="osee_data">
- <Column id="QUERY_ID" defaultValue="not null" type="INTEGER" />
- <Column id="SESSION_ID" defaultValue="not null" type="VARCHAR" limits="28" />
- <Column id="TABLE_NAME" defaultValue="not null" type="VARCHAR" limits="28"/>
- <Index id="OSEE_JOIN_CLEANUP__Q_IDX" type="UNIQUE" tablespace="osee_data">
- <AppliesTo id="QUERY_ID"/>
- </Index>
- </Table>
-
- <Table name="OSEE_JOIN_CHAR_ID" schema="OSEE" tablespace="osee_data">
- <Column id="QUERY_ID" defaultValue="not null" type="INTEGER" />
- <Column id="ID" defaultValue="not null" type="VARCHAR" limits="4000"/>
- <Index id="OSEE_JOIN_CHAR__Q_IDX" tablespace="osee_data">
- <AppliesTo id="QUERY_ID"/>
- </Index>
- </Table>
-
- <Table name="OSEE_ARTIFACT_TYPE" schema="OSEE" tablespace="osee_data">
- <Column id="ART_TYPE_GUID" defaultValue="not null" limits="28" type="VARCHAR" />
- <Column id="ART_TYPE_ID" defaultValue="not null" type="smallint" />
- <Column id="IS_ABSTRACT" defaultValue="not null" type="smallint" />
- <Column id="NAME" defaultValue="not null" limits="75" type="VARCHAR" />
- <Column id="IMAGE" type="BLOB" />
- <Constraint schema="OSEE" id="OSEE_ARTIFACT_TYPE_AR_PK" type="PRIMARY KEY" appliesTo="ART_TYPE_ID" />
- <Constraint schema="OSEE" id="OSEE_ARTIFACT_TYPE_G_IDX" type="UNIQUE" appliesTo="ART_TYPE_GUID" />
- <Index id="OSEE_ARTIFACT_TYPE_N_IDX" type="UNIQUE" tablespace="osee_data">
- <AppliesTo id="NAME"/>
- </Index>
- </Table>
-
- <Table name="OSEE_ARTIFACT_TYPE_INHERITANCE" schema="OSEE" tablespace="osee_data">
- <Column id="ART_TYPE_ID" defaultValue="not null" type="smallint" />
- <Column id="SUPER_ART_TYPE_ID" defaultValue="not null" type="smallint" />
- <Constraint schema="OSEE" id="OSEE_ART_TYPE_INHERIT_PK" type="PRIMARY KEY" appliesTo="ART_TYPE_ID, SUPER_ART_TYPE_ID" />
- <Constraint schema="OSEE" id="OSEE_ART_TYPE_ITEM_FK" type="FOREIGN KEY" appliesTo="ART_TYPE_ID">
- <References schema="OSEE" table="OSEE_ARTIFACT_TYPE" column="ART_TYPE_ID" />
- </Constraint>
- <Constraint schema="OSEE" id="OSEE_ART_SUPER_TYPE_FK" type="FOREIGN KEY" appliesTo="SUPER_ART_TYPE_ID">
- <References schema="OSEE" table="OSEE_ARTIFACT_TYPE" column="ART_TYPE_ID" />
- </Constraint>
- </Table>
-
- <Table name="OSEE_ARTIFACT_TYPE_ATTRIBUTES" schema="OSEE" tablespace="osee_data">
- <Column id="ART_TYPE_ID" defaultValue="not null" type="smallint" />
- <Column id="ATTR_TYPE_ID" defaultValue="not null" type="smallint" />
- <Column id="BRANCH_ID" type="INTEGER" defaultValue="not null" />
- <Constraint schema="OSEE" id="OSEE_ARTIFACT_TYPE_ATTRIB_PK" type="PRIMARY KEY" appliesTo="ART_TYPE_ID, ATTR_TYPE_ID, BRANCH_ID" />
- <Constraint schema="OSEE" id="OSEE_ARTIFACT_TYPE_ATTRIB_FK1" type="FOREIGN KEY" appliesTo="ATTR_TYPE_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_ATTRIBUTE_TYPE" column="ATTR_TYPE_ID" />
- </Constraint>
- <Constraint schema="OSEE" id="OSEE_ARTIFACT_TYPE_ATTRIB_FK2" type="FOREIGN KEY" appliesTo="ART_TYPE_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_ARTIFACT_TYPE" column="ART_TYPE_ID" />
- </Constraint>
- <Constraint schema="OSEE" id="OSEE_ARTIFACT_TYPE_ATTRIB_FK3" type="FOREIGN KEY" appliesTo="BRANCH_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_BRANCH" column="BRANCH_ID" />
- </Constraint>
- </Table>
-
- <Table name="OSEE_ATTRIBUTE" schema="OSEE" tablespace="osee_data">
- <Column id="GAMMA_ID" defaultValue="not null" type="BIGINT" />
- <Column id="ART_ID" defaultValue="not null" type="INTEGER" />
- <Column id="ATTR_ID" defaultValue="not null" type="INTEGER" />
- <Column id="ATTR_TYPE_ID" defaultValue="not null" type="smallint" />
- <Column id="VALUE" limits="4000" type="VARCHAR" />
- <Column id="URI" limits="200" type="VARCHAR" />
- <Constraint schema="OSEE" id="OSEE_ATTRIBUTE_AT_G_PK" type="PRIMARY KEY" appliesTo="ATTR_ID, GAMMA_ID" />
- <Index id="OSEE_ATTRIBUTE_ATT_IDX" tablespace="osee_data">
- <AppliesTo id="ATTR_TYPE_ID"/>
- </Index>
- <Index id="OSEE_ATTRIBUTE_V_IDX" mySqlIgnore="true" tablespace="osee_data">
- <AppliesTo id="VALUE"/>
- </Index>
- <Index id="OSEE_ATTRIBUTE_AR_V_IDX" mySqlIgnore="true" tablespace="osee_data">
- <AppliesTo id="ART_ID"/>
- <AppliesTo id="VALUE"/>
- </Index>
- <Index id="OSEE_ATTRIBUTE_AR_G_IDX" type="UNIQUE" tablespace="osee_data">
- <AppliesTo id="ART_ID"/>
- <AppliesTo id="GAMMA_ID"/>
- </Index>
- <Index id="OSEE_ATTRIBUTE_G_AT_IDX" type="UNIQUE" tablespace="osee_data">
- <AppliesTo id="GAMMA_ID"/>
- <AppliesTo id="ATTR_ID"/>
- </Index>
- <Index id="OSEE_ATTRIBUTE_G_IDX" type="UNIQUE" tablespace="osee_data">
- <AppliesTo id="GAMMA_ID"/>
- </Index>
- <Index id="OSEE_ATTRIBUTE_AT_IDX" tablespace="osee_data">
- <AppliesTo id="ATTR_ID"/>
- </Index>
- <Index id="OSEE_ATTRIBUTE_AR_IDX" mySqlIgnore="true" tablespace="osee_data">
- <AppliesTo id="ART_ID"/>
- </Index>
- </Table>
-
- <Table name="OSEE_ENUM_TYPE" schema="OSEE" tablespace="osee_data">
- <Column id="ENUM_TYPE_GUID" defaultValue="not null" limits="28" type="VARCHAR" />
- <Column id="ENUM_TYPE_ID" defaultValue="not null" type="smallint" />
- <Column id="ENUM_TYPE_NAME" defaultValue="not null" limits="500" type="VARCHAR" />
- <Constraint schema="OSEE" id="OSEE_ENUM_TYPE_PK" type="PRIMARY KEY" appliesTo="ENUM_TYPE_ID" />
- <Constraint schema="OSEE" id="OSEE_ENUM_TYPE_G_IDX" type="UNIQUE" appliesTo="ENUM_TYPE_GUID" />
- </Table>
-
- <Table name="OSEE_ENUM_TYPE_DEF" schema="OSEE" tablespace="osee_data">
- <Column id="ENUM_ENTRY_GUID" defaultValue="not null" limits="28" type="VARCHAR" />
- <Column id="ENUM_TYPE_ID" defaultValue="not null" type="smallint" />
- <Column id="NAME" defaultValue="not null" limits="500" type="VARCHAR" />
- <Column id="ORDINAL" defaultValue="not null" type="smallint" />
- <Constraint schema="OSEE" id="OSEE_ENUM_TYPE_DEF_EO_PK" type="PRIMARY KEY" appliesTo="ENUM_TYPE_ID, ORDINAL" />
- <Constraint schema="OSEE" id="OSEE_ENUM_TYPE_DEF_G_IDX" type="UNIQUE" appliesTo="ENUM_ENTRY_GUID" />
- <Constraint schema="OSEE" id="ENUM_TYPE_ID_FK1" type="FOREIGN KEY" appliesTo="ENUM_TYPE_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_ENUM_TYPE" column="ENUM_TYPE_ID" />
- </Constraint>
- </Table>
-
- <Table name="OSEE_ATTRIBUTE_TYPE" schema="OSEE" tablespace="osee_data">
- <Column id="ATTR_TYPE_GUID" defaultValue="not null" limits="28" type="VARCHAR" />
- <Column id="ATTR_TYPE_ID" defaultValue="not null" type="smallint" />
- <Column id="ATTR_BASE_TYPE_ID" defaultValue="not null" type="smallint" />
- <Column id="ATTR_PROVIDER_TYPE_ID" defaultValue="not null" type="smallint" />
- <Column id="FILE_TYPE_EXTENSION" limits="20" type="VARCHAR" />
- <Column id="NAME" defaultValue="not null" limits="500" type="VARCHAR" />
- <Column id="DEFAULT_VALUE" limits="2000" type="VARCHAR" />
- <Column id="ENUM_TYPE_ID" defaultValue="not null" type="smallint" />
- <Column id="MIN_OCCURENCE" defaultValue="not null" type="INTEGER" />
- <Column id="MAX_OCCURENCE" defaultValue="not null" type="INTEGER" />
- <Column id="TIP_TEXT" limits="4000" type="VARCHAR" />
- <Column id="TAGGER_ID" limits="500" type="VARCHAR" />
- <Constraint schema="OSEE" id="OSEE_ATTRIBUTE_TYPE_AT_PK" type="PRIMARY KEY" appliesTo="ATTR_TYPE_ID" />
- <Constraint schema="OSEE" id="OSEE_ATTRIBUTE_TYPE_G_IDX" type="UNIQUE" appliesTo="ATTR_TYPE_GUID" />
- <Constraint schema="OSEE" id="ATTR_BASE_TYPE_ID_FK" type="FOREIGN KEY" appliesTo="ATTR_BASE_TYPE_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_ATTRIBUTE_BASE_TYPE" column="ATTR_BASE_TYPE_ID" />
- </Constraint>
- <Constraint schema="OSEE" id="ATTR_PROVIDER_TYPE_ID_FK" type="FOREIGN KEY" appliesTo="ATTR_PROVIDER_TYPE_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_ATTRIBUTE_PROVIDER_TYPE" column="ATTR_PROVIDER_TYPE_ID" />
- </Constraint>
- <Index id="OSEE_ATTRIBUTE_TYPE_N_IDX" tablespace="osee_data">
- <AppliesTo id="NAME"/>
- </Index>
- </Table>
-
- <Table name="OSEE_ATTRIBUTE_BASE_TYPE" schema="OSEE" tablespace="osee_data">
- <Column id="ATTR_BASE_TYPE_ID" defaultValue="not null" type="smallint" />
- <Column id="ATTRIBUTE_CLASS" defaultValue="not null" limits="500" type="VARCHAR" />
- <Constraint schema="OSEE" id="OSEE_ATTR_BASE_TYPE_AT_PK" type="PRIMARY KEY" appliesTo="ATTR_BASE_TYPE_ID" />
- </Table>
-
- <Table name="OSEE_ATTRIBUTE_PROVIDER_TYPE" schema="OSEE" tablespace="osee_data">
- <Column id="ATTR_PROVIDER_TYPE_ID" defaultValue="not null" type="smallint" />
- <Column id="ATTRIBUTE_PROVIDER_CLASS" defaultValue="not null" limits="500" type="VARCHAR" />
- <Constraint schema="OSEE" id="OSEE_ATTR_PROVIDER_TYPE_AT_PK" type="PRIMARY KEY" appliesTo="ATTR_PROVIDER_TYPE_ID" />
- </Table>
-
- <Table name="OSEE_RELATION_LINK" schema="OSEE" tablespace="osee_data">
- <Column id="GAMMA_ID" defaultValue="not null" type="BIGINT" />
- <Column id="REL_LINK_ID" defaultValue="not null" type="INTEGER" />
- <Column id="REL_LINK_TYPE_ID" defaultValue="not null" type="smallint" />
- <Column id="A_ART_ID" defaultValue="not null" type="INTEGER" />
- <Column id="B_ART_ID" defaultValue="not null" type="INTEGER" />
- <Column id="RATIONALE" limits="4000" type="VARCHAR" />
- <Constraint schema="OSEE" id="OSEE_RELATION__G_PK" type="PRIMARY KEY" appliesTo="GAMMA_ID" />
- <Constraint schema="OSEE" id="OSEE_RELATION__REL_TYPE_FK" type="FOREIGN KEY" appliesTo="REL_LINK_TYPE_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_RELATION_LINK_TYPE" column="REL_LINK_TYPE_ID" />
- </Constraint>
- <Index id="OSEE_RELATION__R_G_IDX" type="UNIQUE" tablespace="osee_data">
- <AppliesTo id="REL_LINK_ID"/>
- <AppliesTo id="GAMMA_ID"/>
- </Index>
- <Index id="OSEE_RELATION__A_IDX" tablespace="osee_data">
- <AppliesTo id="A_ART_ID"/>
- </Index>
- <Index id="OSEE_RELATION__B_IDX" tablespace="osee_data">
- <AppliesTo id="B_ART_ID"/>
- </Index>
- </Table>
-
- <Table name="OSEE_RELATION_LINK_TYPE" schema="OSEE" tablespace="osee_data">
- <Column id="REL_LINK_TYPE_GUID" defaultValue="not null" limits="28" type="VARCHAR" />
- <Column id="REL_LINK_TYPE_ID" defaultValue="not null" type="smallint" />
- <Column id="TYPE_NAME" defaultValue="not null" limits="50" type="VARCHAR" />
- <Column id="A_NAME" defaultValue="not null" limits="50" type="VARCHAR" />
- <Column id="B_NAME" defaultValue="not null" limits="50" type="VARCHAR" />
- <Column id="A_ART_TYPE_ID" defaultValue="not null" type="smallint" />
- <Column id="B_ART_TYPE_ID" defaultValue="not null" type="smallint" />
- <Column id="MULTIPLICITY" defaultValue="not null" type="smallint" />
- <Column id="DEFAULT_ORDER_TYPE_GUID" defaultValue="not null" limits="28" type="VARCHAR" />
- <Constraint schema="OSEE" id="OSEE_REL_LINK_TYPE_RLT_PK" type="PRIMARY KEY" appliesTo="REL_LINK_TYPE_ID" />
- <Constraint schema="OSEE" id="OSEE_REL_LINK_TYPE_G_IDX" type="UNIQUE" appliesTo="REL_LINK_TYPE_GUID" />
- </Table>
-
- <!-- __________________________________________________________ -->
- <!-- -->
- <!-- MAIN VERSIONING TABLES - CHANGE, TX, AND BRANCH SUPPORT -->
- <!-- -->
- <!-- __________________________________________________________ -->
-
-
- <Table name="OSEE_BRANCH" schema="OSEE" tablespace="osee_data">
- <Column id="BRANCH_GUID" defaultValue="not null" limits="28" type="VARCHAR" />
- <Column id="BRANCH_ID" defaultValue="not null" type="INTEGER" />
- <Column id="BRANCH_NAME" defaultValue="not null" limits="200" type="VARCHAR" />
- <Column id="PARENT_BRANCH_ID" defaultValue="not null" type="INTEGER" />
- <Column id="PARENT_TRANSACTION_ID" defaultValue="not null" type="INTEGER" />
- <Column id="ARCHIVED" defaultValue="not null" type="smallint" />
- <Column id="BRANCH_STATE" defaultValue="not null" type="smallint" />
- <Column id="ASSOCIATED_ART_ID" defaultValue="not null" type="INTEGER" />
- <Column id="BRANCH_TYPE" defaultValue="not null" type="smallint" />
- <Column id="BASELINE_TRANSACTION_ID" defaultValue="not null" type="INTEGER" />
-
- <Constraint schema="OSEE" id="OSEE_BRANCH_B_PK" type="PRIMARY KEY" appliesTo="BRANCH_ID" />
- <Constraint schema="OSEE" id="OSEE_BRANCH_G_IDX" type="UNIQUE" appliesTo="BRANCH_GUID" />
- <!--
- <Constraint schema="OSEE" id="OSEE_TRANSACTION_ID_FK2" type="FOREIGN KEY" appliesTo="PARENT_TRANSACTION_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_TX_DETAILS" column="TRANSACTION_ID"" />
- </Constraint>
- -->
- <Index id="OSEE_BRANCH_A_IDX" tablespace="osee_data">
- <AppliesTo id="ARCHIVED" />
- </Index>
- </Table>
-
- <Table name="OSEE_TXS" schema="OSEE" tablespace="osee_data">
- <Column id="BRANCH_ID" type="INTEGER" defaultValue="not null" />
- <Column id="GAMMA_ID" defaultValue="not null" type="BIGINT" />
- <Column id="TX_CURRENT" defaultValue="not null" type="smallint" />
- <Column id="MOD_TYPE" defaultValue="not null" type="smallint" />
- <Column id="TRANSACTION_ID" defaultValue="not null" type="INTEGER" />
- <Constraint schema="OSEE" id="OSEE_TXS__TRANSACTION_FK" type="FOREIGN KEY" appliesTo="TRANSACTION_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_TX_DETAILS" column="TRANSACTION_ID" />
- </Constraint>
- <Constraint schema="OSEE" id="OSEE_TXS__BRANCH_FK" type="FOREIGN KEY" appliesTo="BRANCH_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_BRANCH" column="BRANCH_ID" />
- </Constraint>
- <Index id="OSEE_TXS_B_G_C_M_T_IDX" type="UNIQUE" tablespace="osee_data">
- <AppliesTo id="BRANCH_ID"/>
- <AppliesTo id="GAMMA_ID"/>
- <AppliesTo id="TX_CURRENT"/>
- <AppliesTo id="MOD_TYPE"/>
- <AppliesTo id="TRANSACTION_ID" />
- </Index>
- </Table>
-
- <Table name="OSEE_TXS_ARCHIVED" schema="OSEE" tablespace="osee_archive">
- <Column id="BRANCH_ID" defaultValue="not null" type="INTEGER" />
- <Column id="GAMMA_ID" defaultValue="not null" type="BIGINT" />
- <Column id="TX_CURRENT" defaultValue="not null" type="smallint" />
- <Column id="MOD_TYPE" defaultValue="not null" type="smallint" />
- <Column id="TRANSACTION_ID" defaultValue="not null" type="INTEGER" />
- <Constraint schema="OSEE" id="OSEE_TXSA__TRANSACTION_FK" type="FOREIGN KEY" appliesTo="TRANSACTION_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_TX_DETAILS" column="TRANSACTION_ID" />
- </Constraint>
- <Constraint schema="OSEE" id="OSEE_TXSA__BRANCH_FK" type="FOREIGN KEY" appliesTo="BRANCH_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_BRANCH" column="BRANCH_ID" />
- </Constraint>
- <Index id="OSEE_TXSA_B_G_C_M_T_IDX" type="UNIQUE" tablespace="osee_archive">
- <AppliesTo id="BRANCH_ID"/>
- <AppliesTo id="GAMMA_ID"/>
- <AppliesTo id="TX_CURRENT"/>
- <AppliesTo id="MOD_TYPE"/>
- <AppliesTo id="TRANSACTION_ID" />
- </Index>
- </Table>
-
- <Table name="OSEE_TX_DETAILS" schema="OSEE" tablespace="osee_data">
- <Column id="TRANSACTION_ID" defaultValue="not null" type="INTEGER" />
- <Column id="TX_TYPE" defaultValue="not null" type="smallint" />
- <Column id="BRANCH_ID" defaultValue="not null" type="INTEGER" />
- <Column id="OSEE_COMMENT" limits="1000" type="VARCHAR" />
- <Column id="TIME" defaultValue="not null" type="TIMESTAMP"/>
- <Column id="AUTHOR" defaultValue="not null" type="INTEGER"/>
- <Column id="COMMIT_ART_ID" type="INTEGER" />
- <Constraint schema="OSEE" id="OSEE_TX_DETAILS_TX_PK" type="PRIMARY KEY" appliesTo="TRANSACTION_ID" />
- <Constraint schema="OSEE" id="BRANCH_ID_FK1" type="FOREIGN KEY" appliesTo="BRANCH_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_BRANCH" column="BRANCH_ID" />
- </Constraint>
- <Index id="OSEE_TX_DETAILS_B_TX_IDX" type="UNIQUE" tablespace="osee_data">
- <AppliesTo id="BRANCH_ID"/>
- <AppliesTo id="TRANSACTION_ID" />
- </Index>
- <Index id="OSEE_TX_DETAILS_TX_B_IDX" type="UNIQUE" tablespace="osee_data">
- <AppliesTo id="TRANSACTION_ID" />
- <AppliesTo id="BRANCH_ID"/>
- </Index>
- </Table>
-
- <!-- __________________________________________________________ -->
- <!-- -->
- <!-- ACCESS CONTROL LIST TABLES -->
- <!-- -->
- <!-- __________________________________________________________ -->
-
- <Table name="OSEE_ARTIFACT_ACL" schema="OSEE" tablespace="osee_data">
- <Column id="ART_ID" defaultValue="not null" type="INTEGER" />
- <Column id="PERMISSION_ID" defaultValue="not null" type="INTEGER" />
- <Column id="PRIVILEGE_ENTITY_ID" defaultValue="not null" type="INTEGER" />
- <Column id="BRANCH_ID" defaultValue="not null" type="INTEGER" />
- <Constraint schema="OSEE" id="OSEE_ARTIFACT_ACL_A_P_B_PK" type="PRIMARY KEY" appliesTo="ART_ID, PRIVILEGE_ENTITY_ID, BRANCH_ID" />
- <Constraint schema="OSEE" id="ARTIFACT_ACL_PERM_FK" type="FOREIGN KEY" appliesTo="PERMISSION_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_PERMISSION" column="PERMISSION_ID" />
- </Constraint>
- </Table>
-
- <Table name="OSEE_RELATION_LINK_TYPE_ACL" schema="OSEE" tablespace="osee_data">
- <Column id="REL_LINK_TYPE_ID" defaultValue="not null" type="smallint" />
- <Column id="PERMISSION_ID" defaultValue="not null" type="INTEGER" />
- <Column id="PRIVILEGE_ENTITY_ID" defaultValue="not null" type="INTEGER" />
- <Column id="BRANCH_ID" defaultValue="not null" type="INTEGER" />
- <Constraint schema="OSEE" id="RELATION_LINK_TYPE_ACL_PK" type="PRIMARY KEY" appliesTo="REL_LINK_TYPE_ID, PRIVILEGE_ENTITY_ID, BRANCH_ID" />
- <Constraint schema="OSEE" id="RELATION_LINK_TYPE_PERM_FK" type="FOREIGN KEY" appliesTo="PERMISSION_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_PERMISSION" column="PERMISSION_ID" />
- </Constraint>
- </Table>
-
- <Table name="OSEE_ARTIFACT_TYPE_ACL" schema="OSEE" tablespace="osee_data">
- <Column id="ART_TYPE_ID" defaultValue="not null" type="smallint" />
- <Column id="PERMISSION_ID" defaultValue="not null" type="INTEGER" />
- <Column id="PRIVILEGE_ENTITY_ID" defaultValue="not null" type="INTEGER" />
- <Column id="BRANCH_ID" defaultValue="not null" type="INTEGER" />
- <Constraint schema="OSEE" id="OSEE_ART_TYPE_ACL_AT_P_B_PK" type="PRIMARY KEY" appliesTo="ART_TYPE_ID, PRIVILEGE_ENTITY_ID, BRANCH_ID" />
- <Constraint schema="OSEE" id="ARTIFACT_TYPE_PERM_FK" type="FOREIGN KEY" appliesTo="PERMISSION_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_PERMISSION" column="PERMISSION_ID" />
- </Constraint>
- </Table>
-
- <Table name="OSEE_ATTRIBUTE_TYPE_ACL" schema="OSEE" tablespace="osee_data">
- <Column id="ATTR_TYPE_ID" defaultValue="not null" type="smallint" />
- <Column id="PERMISSION_ID" defaultValue="not null" type="INTEGER" />
- <Column id="PRIVILEGE_ENTITY_ID" defaultValue="not null" type="INTEGER" />
- <Column id="BRANCH_ID" defaultValue="not null" type="INTEGER" />
- <Constraint schema="OSEE" id="OSEE_ATTR_TYPE_ACL_A_P_B_PK" type="PRIMARY KEY" appliesTo="ATTR_TYPE_ID, PRIVILEGE_ENTITY_ID, BRANCH_ID" />
- <Constraint schema="OSEE" id="ATTRIBUTE_TYPE_PERM_FK" type="FOREIGN KEY" appliesTo="PERMISSION_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_PERMISSION" column="PERMISSION_ID" />
- </Constraint>
- </Table>
-
- <Table name="OSEE_BRANCH_ACL" schema="OSEE" tablespace="osee_data">
- <Column id="BRANCH_ID" defaultValue="not null" type="INTEGER" />
- <Column id="PERMISSION_ID" defaultValue="not null" type="INTEGER" />
- <Column id="PRIVILEGE_ENTITY_ID" defaultValue="not null" type="INTEGER" />
- <Constraint schema="OSEE" id="OSEE_BRANCH_ACL_B_P_PK" type="PRIMARY KEY" appliesTo="BRANCH_ID, PRIVILEGE_ENTITY_ID" />
- <Constraint schema="OSEE" id="BRANCH_ACL_FK" type="FOREIGN KEY" appliesTo="BRANCH_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_BRANCH" column="BRANCH_ID" />
- </Constraint>
- <Constraint schema="OSEE" id="BRANCH_ACL_PERM_FK" type="FOREIGN KEY" appliesTo="PERMISSION_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_PERMISSION" column="PERMISSION_ID" />
- </Constraint>
- </Table>
-
- <Table name="OSEE_PERMISSION" schema="OSEE" tablespace="osee_data">
- <Column id="PERMISSION_ID" defaultValue="not null" type="INTEGER" />
- <Column id="PERMISSION_NAME" defaultValue="not null" limits="50" type="VARCHAR" />
- <Constraint schema="OSEE" id="PERMISSION_PK" type="PRIMARY KEY" appliesTo="PERMISSION_ID" />
- </Table>
-
- <!-- __________________________________________________________ -->
- <!-- -->
- <!-- TAGGING TABLES -->
- <!-- -->
- <!-- __________________________________________________________ -->
-
- <Table name="OSEE_SEARCH_TAGS" schema="OSEE" tablespace="osee_data">
- <Column id="GAMMA_ID" defaultValue="not null" type="BIGINT" />
- <Column id="CODED_TAG_ID" defaultValue="not null" type="BIGINT" />
- <Constraint schema="OSEE" id="OSEE_SEARCH_TAGS__PK" type="PRIMARY KEY" appliesTo="CODED_TAG_ID, GAMMA_ID" />
- <Index id="OSEE_SEARCH_TAGS_C_IDX" tablespace="osee_data">
- <AppliesTo id="CODED_TAG_ID"/>
- </Index>
- <Index id="OSEE_SEARCH_TAGS_G_IDX" tablespace="osee_data">
- <AppliesTo id="GAMMA_ID"/>
- </Index>
- </Table>
-
- <Table name="OSEE_JOIN_SEARCH_TAGS" schema="OSEE" tablespace="osee_data">
- <Column id="QUERY_ID" defaultValue="not null" type="INTEGER" />
- <Column id="CODED_TAG_ID" defaultValue="not null" type="BIGINT" />
- <Column id="INSERT_TIME" defaultValue="not null" type="TIMESTAMP" />
- <Constraint schema="OSEE" id="OSEE_JOIN_SEARCH_TAGS_Q_C_PK" type="PRIMARY KEY" appliesTo="QUERY_ID, CODED_TAG_ID" />
- <Index id="OSEE_JOIN_SEARCH_TAGS_Q_IDX" tablespace="osee_data">
- <AppliesTo id="QUERY_ID"/>
- </Index>
- </Table>
-
- <Table name="OSEE_TAG_GAMMA_QUEUE" schema="OSEE" tablespace="osee_data">
- <Column id="QUERY_ID" defaultValue="not null" type="INTEGER" />
- <Column id="GAMMA_ID" defaultValue="not null" type="BIGINT" />
- <Column id="INSERT_TIME" defaultValue="not null" type="TIMESTAMP" />
- <Constraint schema="OSEE" id="OSEE_JOIN_GAMMA_Q_G_PK" type="PRIMARY KEY" appliesTo="QUERY_ID, GAMMA_ID" />
- </Table>
-
- <!-- __________________________________________________________ -->
- <!-- -->
- <!-- OSEE SEQUENCES and INFO -->
- <!-- -->
- <!-- __________________________________________________________ -->
-
- <Table name="OSEE_SEQUENCE" schema="OSEE" tablespace="osee_data">
- <Column id="LAST_SEQUENCE" defaultValue="not null" type="BIGINT" />
- <Column id="SEQUENCE_NAME" defaultValue="not null" type="VARCHAR" limits="128" />
- <Constraint schema="OSEE" id="SEQUENCE_ID_UN" type="UNIQUE" appliesTo="SEQUENCE_NAME" />
- </Table>
-
-
- <Table name="OSEE_INFO" schema="OSEE" tablespace="osee_data">
- <Column defaultValue="not null" id="OSEE_VALUE" type="VARCHAR" limits="1000" />
- <Column defaultValue="not null" id="OSEE_KEY" type="VARCHAR" limits="50" />
- <Constraint schema="OSEE" id="OSEE_INFO_KEY_UN_IDX" type="UNIQUE" appliesTo="OSEE_KEY" />
- </Table>
-
- <!-- __________________________________________________________ -->
- <!-- -->
- <!-- OSEE Merge -->
- <!-- -->
- <!-- __________________________________________________________ -->
-
- <Table name="OSEE_MERGE" schema="OSEE" tablespace="osee_data">
- <Column id="SOURCE_BRANCH_ID" defaultValue="not null" type="INTEGER" />
- <Column id="DEST_BRANCH_ID" defaultValue="not null" type="INTEGER" />
- <Column id="MERGE_BRANCH_ID" defaultValue="not null" type="INTEGER" />
- <Column id="COMMIT_TRANSACTION_ID" defaultValue="not null" type="INTEGER" />
- <Constraint schema="OSEE" id="OSEE_MERGE__PK" type="PRIMARY KEY" appliesTo="MERGE_BRANCH_ID" />
- <Constraint schema="OSEE" id="OSEE_MERGE__MBI_FK" type="FOREIGN KEY" appliesTo="MERGE_BRANCH_ID">
- <References schema="OSEE" table="OSEE_BRANCH" column="BRANCH_ID" />
- </Constraint>
- <Constraint schema="OSEE" id="OSEE_MERGE__DBI_FK" type="FOREIGN KEY" appliesTo="DEST_BRANCH_ID">
- <References schema="OSEE" table="OSEE_BRANCH" column="BRANCH_ID" />
- </Constraint>
- </Table>
-
- <Table name="OSEE_CONFLICT" schema="OSEE" tablespace="osee_data">
- <Column id="CONFLICT_ID" defaultValue="not null" type="INTEGER" />
- <Column id="MERGE_BRANCH_ID" defaultValue="not null" type="INTEGER" />
- <Column id="CONFLICT_TYPE" defaultValue="not null" type="smallint" />
- <Column id="SOURCE_GAMMA_ID" defaultValue="not null" type="BIGINT" />
- <Column id="DEST_GAMMA_ID" defaultValue="not null" type="BIGINT" />
- <Column id="STATUS" defaultValue="not null" type="smallint" />
- <Constraint schema="OSEE" id="OSEE_CONFLICT__PK" type="PRIMARY KEY" appliesTo="MERGE_BRANCH_ID, SOURCE_GAMMA_ID" />
- <Constraint schema="OSEE" id="OSEE_CONFLICT__MBI_FK" type="FOREIGN KEY" appliesTo="MERGE_BRANCH_ID">
- <References schema="OSEE" table="OSEE_MERGE" column="MERGE_BRANCH_ID" />
- </Constraint>
- </Table>
-
-
- <Table name="OSEE_JOIN_TRANSACTION" schema="OSEE" tablespace="osee_data">
- <Column id="QUERY_ID" defaultValue="not null" type="INTEGER" />
- <Column id="TRANSACTION_ID" defaultValue="not null" type="INTEGER" />
- <Column id="GAMMA_ID" defaultValue="not null" type="BIGINT" />
- <Column id="INSERT_TIME" defaultValue="not null" type="TIMESTAMP" />
- <Index id="OSEE_JOIN_TRANSACTION_Q_IDX" tablespace="osee_data">
- <AppliesTo id="QUERY_ID"/>
- </Index>
- </Table>
-
- <!-- __________________________________________________________ -->
- <!-- -->
- <!-- Reverted TXS -->
- <!-- -->
- <!-- __________________________________________________________ -->
-
- <Table name="OSEE_REMOVED_TXS" schema="OSEE" tablespace="osee_data">
- <Column id="TRANSACTION_ID" defaultValue="not null" type="INTEGER" />
- <Column id="REM_GAMMA_ID" defaultValue="not null" type="BIGINT" />
- <Column id="REM_MOD_TYPE" defaultValue="not null" type="smallint" />
- <Column id="REM_TX_CURRENT" defaultValue="not null" type="smallint" />
- <Column id="REM_TRANSACTION_ID" defaultValue="not null" type="INTEGER" />
- <Constraint schema="OSEE" id="OSEE_REM_TXS_RG_RTX_PK" type="PRIMARY KEY" appliesTo="REM_GAMMA_ID, REM_TRANSACTION_ID"/>
- </Table>
-
-
- <!-- __________________________________________________________ -->
- <!-- -->
- <!-- IMPORT TABLES -->
- <!-- __________________________________________________________ -->
-
- <Table name="OSEE_JOIN_EXPORT_IMPORT" schema="OSEE" tablespace="osee_data">
- <Column id="QUERY_ID" defaultValue="not null" type="INTEGER" />
- <Column id="ID1" defaultValue="not null" type="BIGINT" />
- <Column id="ID2" defaultValue="not null" type="BIGINT" />
- <Column id="INSERT_TIME" defaultValue="not null" type="TIMESTAMP" />
- <Index id="OSEE_JOIN_EXPORT_IMPORT_Q_IDX" tablespace="osee_data">
- <AppliesTo id="QUERY_ID"/>
- </Index>
- </Table>
- <Table name="OSEE_IMPORT_SOURCE" schema="OSEE" tablespace="osee_data">
- <Column id="IMPORT_ID" defaultValue="not null" type="INTEGER" />
- <Column id="DB_SOURCE_GUID" defaultValue="not null" type="VARCHAR" limits="28"/>
- <Column id="SOURCE_EXPORT_DATE" defaultValue="not null" type="TIMESTAMP" />
- <Column id="DATE_IMPORTED" defaultValue="not null" type="TIMESTAMP" />
- <Constraint schema="OSEE" id="OSEE_IMPORT_MAP_PK" type="PRIMARY KEY" appliesTo="IMPORT_ID" />
- </Table>
- <Table name="OSEE_IMPORT_SAVE_POINT" schema="OSEE" tablespace="osee_data">
- <Column id="IMPORT_ID" defaultValue="not null" type="INTEGER" />
- <Column id="SAVE_POINT_NAME" defaultValue="not null" type="VARCHAR" limits="128"/>
- <Column id="STATUS" defaultValue="not null" type="INTEGER" />
- <Column id="STATE_ERROR" type="VARCHAR" limits="4000" />
- <Constraint schema="OSEE" id="OSEE_IMP_SAVE_POINT_II_PK" type="PRIMARY KEY" appliesTo="IMPORT_ID, SAVE_POINT_NAME" />
- <Constraint schema="OSEE" id="OSEE_IMP_SAVE_POINT_II_FK" type="FOREIGN KEY" appliesTo="IMPORT_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_IMPORT_SOURCE" column="IMPORT_ID" />
- </Constraint>
- </Table>
- <Table name="OSEE_IMPORT_MAP" schema="OSEE" tablespace="osee_data">
- <Column id="IMPORT_ID" defaultValue="not null" type="INTEGER" />
- <Column id="SEQUENCE_ID" defaultValue="not null" type="INTEGER" />
- <Column id="SEQUENCE_NAME" defaultValue="not null" type="VARCHAR" limits="128"/>
- <Constraint schema="OSEE" id="OSEE_IMPORT_MAP_II_PK" type="PRIMARY KEY" appliesTo="SEQUENCE_ID" />
- <Constraint schema="OSEE" id="OSEE_IMPORT_MAP_II_FK" type="FOREIGN KEY" appliesTo="IMPORT_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_IMPORT_SOURCE" column="IMPORT_ID" />
- </Constraint>
- </Table>
- <Table name="OSEE_IMPORT_INDEX_MAP" schema="OSEE" tablespace="osee_data">
- <Column id="SEQUENCE_ID" defaultValue="not null" type="INTEGER" />
- <Column id="ORIGINAL_ID" defaultValue="not null" type="BIGINT"/>
- <Column id="MAPPED_ID" defaultValue="not null" type="BIGINT" />
- <Constraint schema="OSEE" id="OSEE_IMPORT_INDEX_MAP_IOM_PK" type="PRIMARY KEY" appliesTo="SEQUENCE_ID, ORIGINAL_ID, MAPPED_ID" />
- <Constraint schema="OSEE" id="OSEE_IMPORT_INDEX_MAP_II_FK" type="FOREIGN KEY" appliesTo="SEQUENCE_ID" deferrable="true">
- <References schema="OSEE" table="OSEE_IMPORT_MAP" column="SEQUENCE_ID" />
- </Constraint>
- <Index id="OSEE_IMPORT_INDEX_MAP_IO_IDX" tablespace="osee_data">
- <AppliesTo id="SEQUENCE_ID"/>
- <AppliesTo id="ORIGINAL_ID"/>
- </Index>
- <Index id="OSEE_IMPORT_INDEX_MAP_IM_IDX" tablespace="osee_data">
- <AppliesTo id="SEQUENCE_ID"/>
- <AppliesTo id="MAPPED_ID"/>
- </Index>
- </Table>
-
- <!-- __________________________________________________________ -->
- <!-- -->
- <!-- Application Server -->
- <!-- -->
- <!-- __________________________________________________________ -->
-
- <Table name="OSEE_SERVER_LOOKUP" schema="OSEE" tablespace="osee_data">
- <Column id="VERSION_ID" defaultValue="not null" type="VARCHAR" limits="100" />
- <Column id="SERVER_ADDRESS" defaultValue="not null" type="VARCHAR" limits="255"/>
- <Column id="PORT" defaultValue="not null" type="INTEGER" />
- <Column id="ACCEPTS_REQUESTS" defaultValue="not null" type="smallint" />
- <Column id="START_TIME" defaultValue="not null" type="TIMESTAMP" />
- <Column id="SERVER_ID" defaultValue="not null" type="VARCHAR" limits="40" />
- <Constraint schema="OSEE" id="OSEE_SERVER_LOOKUP_PK" type="PRIMARY KEY" appliesTo="SERVER_ADDRESS, PORT, VERSION_ID" />
- </Table>
-
- <Table name="OSEE_SESSION" schema="OSEE" tablespace="osee_data">
- <Column id="MANAGED_BY_SERVER_ID" defaultValue="not null" type="VARCHAR" limits="40" />
- <Column id="SESSION_ID" defaultValue="not null" type="VARCHAR" limits="28" />
- <Column id="USER_ID" defaultValue="not null" type="VARCHAR" limits="100"/>
- <Column id="CLIENT_MACHINE_NAME" defaultValue="not null" type="VARCHAR" limits="100"/>
- <Column id="CLIENT_ADDRESS" defaultValue="not null" type="VARCHAR" limits="255"/>
- <Column id="CLIENT_PORT" defaultValue="not null" type="INTEGER" />
- <Column id="CLIENT_VERSION" defaultValue="not null" type="VARCHAR" limits="100"/>
- <Column id="CREATED_ON" defaultValue="not null" type="TIMESTAMP" />
- <Column id="LAST_INTERACTION_DATE" defaultValue="not null" type="TIMESTAMP" />
- <Column id="LAST_INTERACTION" defaultValue="not null" type="VARCHAR" limits="1000"/>
- <Constraint schema="OSEE" id="OSEE_SESSION_PK" type="PRIMARY KEY" appliesTo="SESSION_ID" />
- </Table>
-
- <!-- __________________________________________________________ -->
- <!-- Coverage Temp -->
- <!-- __________________________________________________________ -->
- <Table name="OSEE_CVG_TESTUNITS" schema="OSEE" tablespace="osee_data">
- <Column id="NAME_ID" limits="8,0" type="DECIMAL" />
- <Column id="NAME" limits="255" type="VARCHAR" />
- <Constraint schema="OSEE" id="CVG_NAME_ID_PK" type="UNIQUE" appliesTo="NAME_ID" />
- </Table>
-
-</TableConfig>
+<?xml version="1.0" encoding="UTF-8"?>
+<TableConfig>
+
+ <!-- _____________________________________________________ -->
+ <!-- -->
+ <!-- MAIN ARTIFACT TABLES -->
+ <!-- -->
+ <!-- _____________________________________________________ -->
+
+ <Table name="OSEE_ARTIFACT" schema="OSEE" tablespace="osee_data">
+ <Column id="GAMMA_ID" defaultValue="not null" type="BIGINT" />
+ <Column id="ART_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="ART_TYPE_ID" defaultValue="not null" type="smallint" />
+ <Column id="GUID" defaultValue="not null" limits="22" type="VARCHAR" />
+ <Column id="HUMAN_READABLE_ID" defaultValue="not null" limits="5" type="VARCHAR" />
+ <Constraint schema="OSEE" id="OSEE_ARTS__G_A_PK" type="PRIMARY KEY" appliesTo="ART_ID, GAMMA_ID" />
+ <Constraint schema="OSEE" id="OSEE_ARTS__ART_TYPE_ID_FK" type="FOREIGN KEY" appliesTo="ART_TYPE_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_ARTIFACT_TYPE" column="ART_TYPE_ID" />
+ </Constraint>
+ <Index id="OSEE_ARTS__ART_ID_IDX" tablespace="osee_data">
+ <AppliesTo id="ART_ID"/>
+ </Index>
+ <Index id="OSEE_ARTS__GUID_IDX" tablespace="osee_data">
+ <AppliesTo id="GUID"/>
+ </Index>
+ <Index id="OSEE_ARTS__ART_TYPE_ID_IDX" tablespace="osee_data">
+ <AppliesTo id="ART_TYPE_ID"/>
+ </Index>
+ </Table>
+
+ <Table name="OSEE_JOIN_ARTIFACT" schema="OSEE" tablespace="osee_data">
+ <Column id="QUERY_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="ART_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="BRANCH_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="TRANSACTION_ID" type="INTEGER" />
+ <Column id="INSERT_TIME" defaultValue="not null" type="TIMESTAMP" />
+ <Index id="OSEE_JOIN_ART__Q_A_B_T_IDX" type="UNIQUE" tablespace="osee_data">
+ <AppliesTo id="QUERY_ID"/>
+ <AppliesTo id="ART_ID"/>
+ <AppliesTo id="BRANCH_ID"/>
+ <AppliesTo id="TRANSACTION_ID"/>
+ </Index>
+ </Table>
+
+ <Table name="OSEE_JOIN_ID" schema="OSEE" tablespace="osee_data">
+ <Column id="QUERY_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="ID" type="INTEGER" />
+ <Column id="INSERT_TIME" defaultValue="not null" type="TIMESTAMP" />
+ <Index id="OSEE_JOIN_ID__Q_I_IDX" type="UNIQUE" tablespace="osee_data">
+ <AppliesTo id="QUERY_ID"/>
+ <AppliesTo id="ID"/>
+ </Index>
+ </Table>
+
+ <Table name="OSEE_JOIN_CLEANUP" schema="OSEE" tablespace="osee_data">
+ <Column id="QUERY_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="SESSION_ID" defaultValue="not null" type="VARCHAR" limits="28" />
+ <Column id="TABLE_NAME" defaultValue="not null" type="VARCHAR" limits="28"/>
+ <Index id="OSEE_JOIN_CLEANUP__Q_IDX" type="UNIQUE" tablespace="osee_data">
+ <AppliesTo id="QUERY_ID"/>
+ </Index>
+ </Table>
+
+ <Table name="OSEE_JOIN_CHAR_ID" schema="OSEE" tablespace="osee_data">
+ <Column id="QUERY_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="ID" defaultValue="not null" type="VARCHAR" limits="4000"/>
+ <Index id="OSEE_JOIN_CHAR__Q_IDX" tablespace="osee_data">
+ <AppliesTo id="QUERY_ID"/>
+ </Index>
+ </Table>
+
+ <Table name="OSEE_ARTIFACT_TYPE" schema="OSEE" tablespace="osee_data">
+ <Column id="ART_TYPE_GUID" defaultValue="not null" limits="28" type="VARCHAR" />
+ <Column id="ART_TYPE_ID" defaultValue="not null" type="smallint" />
+ <Column id="IS_ABSTRACT" defaultValue="not null" type="smallint" />
+ <Column id="NAME" defaultValue="not null" limits="75" type="VARCHAR" />
+ <Column id="IMAGE" type="BLOB" />
+ <Constraint schema="OSEE" id="OSEE_ARTIFACT_TYPE_AR_PK" type="PRIMARY KEY" appliesTo="ART_TYPE_ID" />
+ <Constraint schema="OSEE" id="OSEE_ARTIFACT_TYPE_G_IDX" type="UNIQUE" appliesTo="ART_TYPE_GUID" />
+ <Index id="OSEE_ARTIFACT_TYPE_N_IDX" type="UNIQUE" tablespace="osee_data">
+ <AppliesTo id="NAME"/>
+ </Index>
+ </Table>
+
+ <Table name="OSEE_ARTIFACT_TYPE_INHERITANCE" schema="OSEE" tablespace="osee_data">
+ <Column id="ART_TYPE_ID" defaultValue="not null" type="smallint" />
+ <Column id="SUPER_ART_TYPE_ID" defaultValue="not null" type="smallint" />
+ <Constraint schema="OSEE" id="OSEE_ART_TYPE_INHERIT_PK" type="PRIMARY KEY" appliesTo="ART_TYPE_ID, SUPER_ART_TYPE_ID" />
+ <Constraint schema="OSEE" id="OSEE_ART_TYPE_ITEM_FK" type="FOREIGN KEY" appliesTo="ART_TYPE_ID">
+ <References schema="OSEE" table="OSEE_ARTIFACT_TYPE" column="ART_TYPE_ID" />
+ </Constraint>
+ <Constraint schema="OSEE" id="OSEE_ART_SUPER_TYPE_FK" type="FOREIGN KEY" appliesTo="SUPER_ART_TYPE_ID">
+ <References schema="OSEE" table="OSEE_ARTIFACT_TYPE" column="ART_TYPE_ID" />
+ </Constraint>
+ </Table>
+
+ <Table name="OSEE_ARTIFACT_TYPE_ATTRIBUTES" schema="OSEE" tablespace="osee_data">
+ <Column id="ART_TYPE_ID" defaultValue="not null" type="smallint" />
+ <Column id="ATTR_TYPE_ID" defaultValue="not null" type="smallint" />
+ <Column id="BRANCH_ID" type="INTEGER" defaultValue="not null" />
+ <Constraint schema="OSEE" id="OSEE_ARTIFACT_TYPE_ATTRIB_PK" type="PRIMARY KEY" appliesTo="ART_TYPE_ID, ATTR_TYPE_ID, BRANCH_ID" />
+ <Constraint schema="OSEE" id="OSEE_ARTIFACT_TYPE_ATTRIB_FK1" type="FOREIGN KEY" appliesTo="ATTR_TYPE_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_ATTRIBUTE_TYPE" column="ATTR_TYPE_ID" />
+ </Constraint>
+ <Constraint schema="OSEE" id="OSEE_ARTIFACT_TYPE_ATTRIB_FK2" type="FOREIGN KEY" appliesTo="ART_TYPE_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_ARTIFACT_TYPE" column="ART_TYPE_ID" />
+ </Constraint>
+ <Constraint schema="OSEE" id="OSEE_ARTIFACT_TYPE_ATTRIB_FK3" type="FOREIGN KEY" appliesTo="BRANCH_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_BRANCH" column="BRANCH_ID" />
+ </Constraint>
+ </Table>
+
+ <Table name="OSEE_ATTRIBUTE" schema="OSEE" tablespace="osee_data">
+ <Column id="GAMMA_ID" defaultValue="not null" type="BIGINT" />
+ <Column id="ART_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="ATTR_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="ATTR_TYPE_ID" defaultValue="not null" type="smallint" />
+ <Column id="VALUE" limits="4000" type="VARCHAR" />
+ <Column id="URI" limits="200" type="VARCHAR" />
+ <Constraint schema="OSEE" id="OSEE_ATTRIBUTE_AT_G_PK" type="PRIMARY KEY" appliesTo="ATTR_ID, GAMMA_ID" />
+ <Index id="OSEE_ATTRIBUTE_ATT_IDX" tablespace="osee_data">
+ <AppliesTo id="ATTR_TYPE_ID"/>
+ </Index>
+ <Index id="OSEE_ATTRIBUTE_V_IDX" mySqlIgnore="true" tablespace="osee_data">
+ <AppliesTo id="VALUE"/>
+ </Index>
+ <Index id="OSEE_ATTRIBUTE_AR_V_IDX" mySqlIgnore="true" tablespace="osee_data">
+ <AppliesTo id="ART_ID"/>
+ <AppliesTo id="VALUE"/>
+ </Index>
+ <Index id="OSEE_ATTRIBUTE_AR_G_IDX" type="UNIQUE" tablespace="osee_data">
+ <AppliesTo id="ART_ID"/>
+ <AppliesTo id="GAMMA_ID"/>
+ </Index>
+ <Index id="OSEE_ATTRIBUTE_G_AT_IDX" type="UNIQUE" tablespace="osee_data">
+ <AppliesTo id="GAMMA_ID"/>
+ <AppliesTo id="ATTR_ID"/>
+ </Index>
+ <Index id="OSEE_ATTRIBUTE_G_IDX" type="UNIQUE" tablespace="osee_data">
+ <AppliesTo id="GAMMA_ID"/>
+ </Index>
+ <Index id="OSEE_ATTRIBUTE_AT_IDX" tablespace="osee_data">
+ <AppliesTo id="ATTR_ID"/>
+ </Index>
+ <Index id="OSEE_ATTRIBUTE_AR_IDX" mySqlIgnore="true" tablespace="osee_data">
+ <AppliesTo id="ART_ID"/>
+ </Index>
+ </Table>
+
+ <Table name="OSEE_ENUM_TYPE" schema="OSEE" tablespace="osee_data">
+ <Column id="ENUM_TYPE_GUID" defaultValue="not null" limits="28" type="VARCHAR" />
+ <Column id="ENUM_TYPE_ID" defaultValue="not null" type="smallint" />
+ <Column id="ENUM_TYPE_NAME" defaultValue="not null" limits="500" type="VARCHAR" />
+ <Constraint schema="OSEE" id="OSEE_ENUM_TYPE_PK" type="PRIMARY KEY" appliesTo="ENUM_TYPE_ID" />
+ <Constraint schema="OSEE" id="OSEE_ENUM_TYPE_G_IDX" type="UNIQUE" appliesTo="ENUM_TYPE_GUID" />
+ </Table>
+
+ <Table name="OSEE_ENUM_TYPE_DEF" schema="OSEE" tablespace="osee_data">
+ <Column id="ENUM_ENTRY_GUID" defaultValue="not null" limits="28" type="VARCHAR" />
+ <Column id="ENUM_TYPE_ID" defaultValue="not null" type="smallint" />
+ <Column id="NAME" defaultValue="not null" limits="500" type="VARCHAR" />
+ <Column id="ORDINAL" defaultValue="not null" type="smallint" />
+ <Constraint schema="OSEE" id="OSEE_ENUM_TYPE_DEF_EO_PK" type="PRIMARY KEY" appliesTo="ENUM_TYPE_ID, ORDINAL" />
+ <Constraint schema="OSEE" id="OSEE_ENUM_TYPE_DEF_G_IDX" type="UNIQUE" appliesTo="ENUM_ENTRY_GUID" />
+ <Constraint schema="OSEE" id="ENUM_TYPE_ID_FK1" type="FOREIGN KEY" appliesTo="ENUM_TYPE_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_ENUM_TYPE" column="ENUM_TYPE_ID" />
+ </Constraint>
+ </Table>
+
+ <Table name="OSEE_ATTRIBUTE_TYPE" schema="OSEE" tablespace="osee_data">
+ <Column id="ATTR_TYPE_GUID" defaultValue="not null" limits="28" type="VARCHAR" />
+ <Column id="ATTR_TYPE_ID" defaultValue="not null" type="smallint" />
+ <Column id="ATTR_BASE_TYPE_ID" defaultValue="not null" type="smallint" />
+ <Column id="ATTR_PROVIDER_TYPE_ID" defaultValue="not null" type="smallint" />
+ <Column id="FILE_TYPE_EXTENSION" limits="20" type="VARCHAR" />
+ <Column id="NAME" defaultValue="not null" limits="500" type="VARCHAR" />
+ <Column id="DEFAULT_VALUE" limits="2000" type="VARCHAR" />
+ <Column id="ENUM_TYPE_ID" defaultValue="not null" type="smallint" />
+ <Column id="MIN_OCCURENCE" defaultValue="not null" type="INTEGER" />
+ <Column id="MAX_OCCURENCE" defaultValue="not null" type="INTEGER" />
+ <Column id="TIP_TEXT" limits="4000" type="VARCHAR" />
+ <Column id="TAGGER_ID" limits="500" type="VARCHAR" />
+ <Constraint schema="OSEE" id="OSEE_ATTRIBUTE_TYPE_AT_PK" type="PRIMARY KEY" appliesTo="ATTR_TYPE_ID" />
+ <Constraint schema="OSEE" id="OSEE_ATTRIBUTE_TYPE_G_IDX" type="UNIQUE" appliesTo="ATTR_TYPE_GUID" />
+ <Constraint schema="OSEE" id="ATTR_BASE_TYPE_ID_FK" type="FOREIGN KEY" appliesTo="ATTR_BASE_TYPE_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_ATTRIBUTE_BASE_TYPE" column="ATTR_BASE_TYPE_ID" />
+ </Constraint>
+ <Constraint schema="OSEE" id="ATTR_PROVIDER_TYPE_ID_FK" type="FOREIGN KEY" appliesTo="ATTR_PROVIDER_TYPE_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_ATTRIBUTE_PROVIDER_TYPE" column="ATTR_PROVIDER_TYPE_ID" />
+ </Constraint>
+ <Index id="OSEE_ATTRIBUTE_TYPE_N_IDX" tablespace="osee_data">
+ <AppliesTo id="NAME"/>
+ </Index>
+ </Table>
+
+ <Table name="OSEE_ATTRIBUTE_BASE_TYPE" schema="OSEE" tablespace="osee_data">
+ <Column id="ATTR_BASE_TYPE_ID" defaultValue="not null" type="smallint" />
+ <Column id="ATTRIBUTE_CLASS" defaultValue="not null" limits="500" type="VARCHAR" />
+ <Constraint schema="OSEE" id="OSEE_ATTR_BASE_TYPE_AT_PK" type="PRIMARY KEY" appliesTo="ATTR_BASE_TYPE_ID" />
+ </Table>
+
+ <Table name="OSEE_ATTRIBUTE_PROVIDER_TYPE" schema="OSEE" tablespace="osee_data">
+ <Column id="ATTR_PROVIDER_TYPE_ID" defaultValue="not null" type="smallint" />
+ <Column id="ATTRIBUTE_PROVIDER_CLASS" defaultValue="not null" limits="500" type="VARCHAR" />
+ <Constraint schema="OSEE" id="OSEE_ATTR_PROVIDER_TYPE_AT_PK" type="PRIMARY KEY" appliesTo="ATTR_PROVIDER_TYPE_ID" />
+ </Table>
+
+ <Table name="OSEE_RELATION_LINK" schema="OSEE" tablespace="osee_data">
+ <Column id="GAMMA_ID" defaultValue="not null" type="BIGINT" />
+ <Column id="REL_LINK_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="REL_LINK_TYPE_ID" defaultValue="not null" type="smallint" />
+ <Column id="A_ART_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="B_ART_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="RATIONALE" limits="4000" type="VARCHAR" />
+ <Constraint schema="OSEE" id="OSEE_RELATION__G_PK" type="PRIMARY KEY" appliesTo="GAMMA_ID" />
+ <Constraint schema="OSEE" id="OSEE_RELATION__REL_TYPE_FK" type="FOREIGN KEY" appliesTo="REL_LINK_TYPE_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_RELATION_LINK_TYPE" column="REL_LINK_TYPE_ID" />
+ </Constraint>
+ <Index id="OSEE_RELATION__R_G_IDX" type="UNIQUE" tablespace="osee_data">
+ <AppliesTo id="REL_LINK_ID"/>
+ <AppliesTo id="GAMMA_ID"/>
+ </Index>
+ <Index id="OSEE_RELATION__A_IDX" tablespace="osee_data">
+ <AppliesTo id="A_ART_ID"/>
+ </Index>
+ <Index id="OSEE_RELATION__B_IDX" tablespace="osee_data">
+ <AppliesTo id="B_ART_ID"/>
+ </Index>
+ </Table>
+
+ <Table name="OSEE_RELATION_LINK_TYPE" schema="OSEE" tablespace="osee_data">
+ <Column id="REL_LINK_TYPE_GUID" defaultValue="not null" limits="28" type="VARCHAR" />
+ <Column id="REL_LINK_TYPE_ID" defaultValue="not null" type="smallint" />
+ <Column id="TYPE_NAME" defaultValue="not null" limits="50" type="VARCHAR" />
+ <Column id="A_NAME" defaultValue="not null" limits="50" type="VARCHAR" />
+ <Column id="B_NAME" defaultValue="not null" limits="50" type="VARCHAR" />
+ <Column id="A_ART_TYPE_ID" defaultValue="not null" type="smallint" />
+ <Column id="B_ART_TYPE_ID" defaultValue="not null" type="smallint" />
+ <Column id="MULTIPLICITY" defaultValue="not null" type="smallint" />
+ <Column id="DEFAULT_ORDER_TYPE_GUID" defaultValue="not null" limits="28" type="VARCHAR" />
+ <Constraint schema="OSEE" id="OSEE_REL_LINK_TYPE_RLT_PK" type="PRIMARY KEY" appliesTo="REL_LINK_TYPE_ID" />
+ <Constraint schema="OSEE" id="OSEE_REL_LINK_TYPE_G_IDX" type="UNIQUE" appliesTo="REL_LINK_TYPE_GUID" />
+ </Table>
+
+ <!-- __________________________________________________________ -->
+ <!-- -->
+ <!-- MAIN VERSIONING TABLES - CHANGE, TX, AND BRANCH SUPPORT -->
+ <!-- -->
+ <!-- __________________________________________________________ -->
+
+
+ <Table name="OSEE_BRANCH" schema="OSEE" tablespace="osee_data">
+ <Column id="BRANCH_GUID" defaultValue="not null" limits="28" type="VARCHAR" />
+ <Column id="BRANCH_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="BRANCH_NAME" defaultValue="not null" limits="200" type="VARCHAR" />
+ <Column id="PARENT_BRANCH_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="PARENT_TRANSACTION_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="ARCHIVED" defaultValue="not null" type="smallint" />
+ <Column id="BRANCH_STATE" defaultValue="not null" type="smallint" />
+ <Column id="ASSOCIATED_ART_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="BRANCH_TYPE" defaultValue="not null" type="smallint" />
+ <Column id="BASELINE_TRANSACTION_ID" defaultValue="not null" type="INTEGER" />
+
+ <Constraint schema="OSEE" id="OSEE_BRANCH_B_PK" type="PRIMARY KEY" appliesTo="BRANCH_ID" />
+ <Constraint schema="OSEE" id="OSEE_BRANCH_G_IDX" type="UNIQUE" appliesTo="BRANCH_GUID" />
+ <!--
+ <Constraint schema="OSEE" id="OSEE_TRANSACTION_ID_FK2" type="FOREIGN KEY" appliesTo="PARENT_TRANSACTION_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_TX_DETAILS" column="TRANSACTION_ID"" />
+ </Constraint>
+ -->
+ <Index id="OSEE_BRANCH_A_IDX" tablespace="osee_data">
+ <AppliesTo id="ARCHIVED" />
+ </Index>
+ </Table>
+
+ <Table name="OSEE_TXS" schema="OSEE" tablespace="osee_data">
+ <Column id="BRANCH_ID" type="INTEGER" defaultValue="not null" />
+ <Column id="GAMMA_ID" defaultValue="not null" type="BIGINT" />
+ <Column id="TX_CURRENT" defaultValue="not null" type="smallint" />
+ <Column id="MOD_TYPE" defaultValue="not null" type="smallint" />
+ <Column id="TRANSACTION_ID" defaultValue="not null" type="INTEGER" />
+ <Constraint schema="OSEE" id="OSEE_TXS__TRANSACTION_FK" type="FOREIGN KEY" appliesTo="TRANSACTION_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_TX_DETAILS" column="TRANSACTION_ID" />
+ </Constraint>
+ <Constraint schema="OSEE" id="OSEE_TXS__BRANCH_FK" type="FOREIGN KEY" appliesTo="BRANCH_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_BRANCH" column="BRANCH_ID" />
+ </Constraint>
+ <Index id="OSEE_TXS_B_G_C_M_T_IDX" type="UNIQUE" tablespace="osee_data">
+ <AppliesTo id="BRANCH_ID"/>
+ <AppliesTo id="GAMMA_ID"/>
+ <AppliesTo id="TX_CURRENT"/>
+ <AppliesTo id="MOD_TYPE"/>
+ <AppliesTo id="TRANSACTION_ID" />
+ </Index>
+ </Table>
+
+ <Table name="OSEE_TXS_ARCHIVED" schema="OSEE" tablespace="osee_archive">
+ <Column id="BRANCH_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="GAMMA_ID" defaultValue="not null" type="BIGINT" />
+ <Column id="TX_CURRENT" defaultValue="not null" type="smallint" />
+ <Column id="MOD_TYPE" defaultValue="not null" type="smallint" />
+ <Column id="TRANSACTION_ID" defaultValue="not null" type="INTEGER" />
+ <Constraint schema="OSEE" id="OSEE_TXSA__TRANSACTION_FK" type="FOREIGN KEY" appliesTo="TRANSACTION_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_TX_DETAILS" column="TRANSACTION_ID" />
+ </Constraint>
+ <Constraint schema="OSEE" id="OSEE_TXSA__BRANCH_FK" type="FOREIGN KEY" appliesTo="BRANCH_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_BRANCH" column="BRANCH_ID" />
+ </Constraint>
+ <Index id="OSEE_TXSA_B_G_C_M_T_IDX" type="UNIQUE" tablespace="osee_archive">
+ <AppliesTo id="BRANCH_ID"/>
+ <AppliesTo id="GAMMA_ID"/>
+ <AppliesTo id="TX_CURRENT"/>
+ <AppliesTo id="MOD_TYPE"/>
+ <AppliesTo id="TRANSACTION_ID" />
+ </Index>
+ </Table>
+
+ <Table name="OSEE_TX_DETAILS" schema="OSEE" tablespace="osee_data">
+ <Column id="TRANSACTION_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="TX_TYPE" defaultValue="not null" type="smallint" />
+ <Column id="BRANCH_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="OSEE_COMMENT" limits="1000" type="VARCHAR" />
+ <Column id="TIME" defaultValue="not null" type="TIMESTAMP"/>
+ <Column id="AUTHOR" defaultValue="not null" type="INTEGER"/>
+ <Column id="COMMIT_ART_ID" type="INTEGER" />
+ <Constraint schema="OSEE" id="OSEE_TX_DETAILS_TX_PK" type="PRIMARY KEY" appliesTo="TRANSACTION_ID" />
+ <Constraint schema="OSEE" id="BRANCH_ID_FK1" type="FOREIGN KEY" appliesTo="BRANCH_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_BRANCH" column="BRANCH_ID" />
+ </Constraint>
+ <Index id="OSEE_TX_DETAILS_B_TX_IDX" type="UNIQUE" tablespace="osee_data">
+ <AppliesTo id="BRANCH_ID"/>
+ <AppliesTo id="TRANSACTION_ID" />
+ </Index>
+ <Index id="OSEE_TX_DETAILS_TX_B_IDX" type="UNIQUE" tablespace="osee_data">
+ <AppliesTo id="TRANSACTION_ID" />
+ <AppliesTo id="BRANCH_ID"/>
+ </Index>
+ </Table>
+
+ <!-- __________________________________________________________ -->
+ <!-- -->
+ <!-- ACCESS CONTROL LIST TABLES -->
+ <!-- -->
+ <!-- __________________________________________________________ -->
+
+ <Table name="OSEE_ARTIFACT_ACL" schema="OSEE" tablespace="osee_data">
+ <Column id="ART_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="PERMISSION_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="PRIVILEGE_ENTITY_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="BRANCH_ID" defaultValue="not null" type="INTEGER" />
+ <Constraint schema="OSEE" id="OSEE_ARTIFACT_ACL_A_P_B_PK" type="PRIMARY KEY" appliesTo="ART_ID, PRIVILEGE_ENTITY_ID, BRANCH_ID" />
+ <Constraint schema="OSEE" id="ARTIFACT_ACL_PERM_FK" type="FOREIGN KEY" appliesTo="PERMISSION_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_PERMISSION" column="PERMISSION_ID" />
+ </Constraint>
+ </Table>
+
+ <Table name="OSEE_RELATION_LINK_TYPE_ACL" schema="OSEE" tablespace="osee_data">
+ <Column id="REL_LINK_TYPE_ID" defaultValue="not null" type="smallint" />
+ <Column id="PERMISSION_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="PRIVILEGE_ENTITY_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="BRANCH_ID" defaultValue="not null" type="INTEGER" />
+ <Constraint schema="OSEE" id="RELATION_LINK_TYPE_ACL_PK" type="PRIMARY KEY" appliesTo="REL_LINK_TYPE_ID, PRIVILEGE_ENTITY_ID, BRANCH_ID" />
+ <Constraint schema="OSEE" id="RELATION_LINK_TYPE_PERM_FK" type="FOREIGN KEY" appliesTo="PERMISSION_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_PERMISSION" column="PERMISSION_ID" />
+ </Constraint>
+ </Table>
+
+ <Table name="OSEE_ARTIFACT_TYPE_ACL" schema="OSEE" tablespace="osee_data">
+ <Column id="ART_TYPE_ID" defaultValue="not null" type="smallint" />
+ <Column id="PERMISSION_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="PRIVILEGE_ENTITY_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="BRANCH_ID" defaultValue="not null" type="INTEGER" />
+ <Constraint schema="OSEE" id="OSEE_ART_TYPE_ACL_AT_P_B_PK" type="PRIMARY KEY" appliesTo="ART_TYPE_ID, PRIVILEGE_ENTITY_ID, BRANCH_ID" />
+ <Constraint schema="OSEE" id="ARTIFACT_TYPE_PERM_FK" type="FOREIGN KEY" appliesTo="PERMISSION_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_PERMISSION" column="PERMISSION_ID" />
+ </Constraint>
+ </Table>
+
+ <Table name="OSEE_ATTRIBUTE_TYPE_ACL" schema="OSEE" tablespace="osee_data">
+ <Column id="ATTR_TYPE_ID" defaultValue="not null" type="smallint" />
+ <Column id="PERMISSION_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="PRIVILEGE_ENTITY_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="BRANCH_ID" defaultValue="not null" type="INTEGER" />
+ <Constraint schema="OSEE" id="OSEE_ATTR_TYPE_ACL_A_P_B_PK" type="PRIMARY KEY" appliesTo="ATTR_TYPE_ID, PRIVILEGE_ENTITY_ID, BRANCH_ID" />
+ <Constraint schema="OSEE" id="ATTRIBUTE_TYPE_PERM_FK" type="FOREIGN KEY" appliesTo="PERMISSION_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_PERMISSION" column="PERMISSION_ID" />
+ </Constraint>
+ </Table>
+
+ <Table name="OSEE_BRANCH_ACL" schema="OSEE" tablespace="osee_data">
+ <Column id="BRANCH_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="PERMISSION_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="PRIVILEGE_ENTITY_ID" defaultValue="not null" type="INTEGER" />
+ <Constraint schema="OSEE" id="OSEE_BRANCH_ACL_B_P_PK" type="PRIMARY KEY" appliesTo="BRANCH_ID, PRIVILEGE_ENTITY_ID" />
+ <Constraint schema="OSEE" id="BRANCH_ACL_FK" type="FOREIGN KEY" appliesTo="BRANCH_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_BRANCH" column="BRANCH_ID" />
+ </Constraint>
+ <Constraint schema="OSEE" id="BRANCH_ACL_PERM_FK" type="FOREIGN KEY" appliesTo="PERMISSION_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_PERMISSION" column="PERMISSION_ID" />
+ </Constraint>
+ </Table>
+
+ <Table name="OSEE_PERMISSION" schema="OSEE" tablespace="osee_data">
+ <Column id="PERMISSION_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="PERMISSION_NAME" defaultValue="not null" limits="50" type="VARCHAR" />
+ <Constraint schema="OSEE" id="PERMISSION_PK" type="PRIMARY KEY" appliesTo="PERMISSION_ID" />
+ </Table>
+
+ <!-- __________________________________________________________ -->
+ <!-- -->
+ <!-- TAGGING TABLES -->
+ <!-- -->
+ <!-- __________________________________________________________ -->
+
+ <Table name="OSEE_SEARCH_TAGS" schema="OSEE" tablespace="osee_data">
+ <Column id="GAMMA_ID" defaultValue="not null" type="BIGINT" />
+ <Column id="CODED_TAG_ID" defaultValue="not null" type="BIGINT" />
+ <Constraint schema="OSEE" id="OSEE_SEARCH_TAGS__PK" type="PRIMARY KEY" appliesTo="CODED_TAG_ID, GAMMA_ID" />
+ <Index id="OSEE_SEARCH_TAGS_C_IDX" tablespace="osee_data">
+ <AppliesTo id="CODED_TAG_ID"/>
+ </Index>
+ <Index id="OSEE_SEARCH_TAGS_G_IDX" tablespace="osee_data">
+ <AppliesTo id="GAMMA_ID"/>
+ </Index>
+ </Table>
+
+ <Table name="OSEE_JOIN_SEARCH_TAGS" schema="OSEE" tablespace="osee_data">
+ <Column id="QUERY_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="CODED_TAG_ID" defaultValue="not null" type="BIGINT" />
+ <Column id="INSERT_TIME" defaultValue="not null" type="TIMESTAMP" />
+ <Constraint schema="OSEE" id="OSEE_JOIN_SEARCH_TAGS_Q_C_PK" type="PRIMARY KEY" appliesTo="QUERY_ID, CODED_TAG_ID" />
+ <Index id="OSEE_JOIN_SEARCH_TAGS_Q_IDX" tablespace="osee_data">
+ <AppliesTo id="QUERY_ID"/>
+ </Index>
+ </Table>
+
+ <Table name="OSEE_TAG_GAMMA_QUEUE" schema="OSEE" tablespace="osee_data">
+ <Column id="QUERY_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="GAMMA_ID" defaultValue="not null" type="BIGINT" />
+ <Column id="INSERT_TIME" defaultValue="not null" type="TIMESTAMP" />
+ <Constraint schema="OSEE" id="OSEE_JOIN_GAMMA_Q_G_PK" type="PRIMARY KEY" appliesTo="QUERY_ID, GAMMA_ID" />
+ </Table>
+
+ <!-- __________________________________________________________ -->
+ <!-- -->
+ <!-- OSEE SEQUENCES and INFO -->
+ <!-- -->
+ <!-- __________________________________________________________ -->
+
+ <Table name="OSEE_SEQUENCE" schema="OSEE" tablespace="osee_data">
+ <Column id="LAST_SEQUENCE" defaultValue="not null" type="BIGINT" />
+ <Column id="SEQUENCE_NAME" defaultValue="not null" type="VARCHAR" limits="128" />
+ <Constraint schema="OSEE" id="SEQUENCE_ID_UN" type="UNIQUE" appliesTo="SEQUENCE_NAME" />
+ </Table>
+
+
+ <Table name="OSEE_INFO" schema="OSEE" tablespace="osee_data">
+ <Column defaultValue="not null" id="OSEE_VALUE" type="VARCHAR" limits="1000" />
+ <Column defaultValue="not null" id="OSEE_KEY" type="VARCHAR" limits="50" />
+ <Constraint schema="OSEE" id="OSEE_INFO_KEY_UN_IDX" type="UNIQUE" appliesTo="OSEE_KEY" />
+ </Table>
+
+ <!-- __________________________________________________________ -->
+ <!-- -->
+ <!-- OSEE Merge -->
+ <!-- -->
+ <!-- __________________________________________________________ -->
+
+ <Table name="OSEE_MERGE" schema="OSEE" tablespace="osee_data">
+ <Column id="SOURCE_BRANCH_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="DEST_BRANCH_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="MERGE_BRANCH_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="COMMIT_TRANSACTION_ID" defaultValue="not null" type="INTEGER" />
+ <Constraint schema="OSEE" id="OSEE_MERGE__PK" type="PRIMARY KEY" appliesTo="MERGE_BRANCH_ID" />
+ <Constraint schema="OSEE" id="OSEE_MERGE__MBI_FK" type="FOREIGN KEY" appliesTo="MERGE_BRANCH_ID">
+ <References schema="OSEE" table="OSEE_BRANCH" column="BRANCH_ID" />
+ </Constraint>
+ <Constraint schema="OSEE" id="OSEE_MERGE__DBI_FK" type="FOREIGN KEY" appliesTo="DEST_BRANCH_ID">
+ <References schema="OSEE" table="OSEE_BRANCH" column="BRANCH_ID" />
+ </Constraint>
+ </Table>
+
+ <Table name="OSEE_CONFLICT" schema="OSEE" tablespace="osee_data">
+ <Column id="CONFLICT_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="MERGE_BRANCH_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="CONFLICT_TYPE" defaultValue="not null" type="smallint" />
+ <Column id="SOURCE_GAMMA_ID" defaultValue="not null" type="BIGINT" />
+ <Column id="DEST_GAMMA_ID" defaultValue="not null" type="BIGINT" />
+ <Column id="STATUS" defaultValue="not null" type="smallint" />
+ <Constraint schema="OSEE" id="OSEE_CONFLICT__PK" type="PRIMARY KEY" appliesTo="MERGE_BRANCH_ID, SOURCE_GAMMA_ID" />
+ <Constraint schema="OSEE" id="OSEE_CONFLICT__MBI_FK" type="FOREIGN KEY" appliesTo="MERGE_BRANCH_ID">
+ <References schema="OSEE" table="OSEE_MERGE" column="MERGE_BRANCH_ID" />
+ </Constraint>
+ </Table>
+
+
+ <Table name="OSEE_JOIN_TRANSACTION" schema="OSEE" tablespace="osee_data">
+ <Column id="QUERY_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="TRANSACTION_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="GAMMA_ID" defaultValue="not null" type="BIGINT" />
+ <Column id="INSERT_TIME" defaultValue="not null" type="TIMESTAMP" />
+ <Index id="OSEE_JOIN_TRANSACTION_Q_IDX" tablespace="osee_data">
+ <AppliesTo id="QUERY_ID"/>
+ </Index>
+ </Table>
+
+ <!-- __________________________________________________________ -->
+ <!-- -->
+ <!-- Reverted TXS -->
+ <!-- -->
+ <!-- __________________________________________________________ -->
+
+ <Table name="OSEE_REMOVED_TXS" schema="OSEE" tablespace="osee_data">
+ <Column id="TRANSACTION_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="REM_GAMMA_ID" defaultValue="not null" type="BIGINT" />
+ <Column id="REM_MOD_TYPE" defaultValue="not null" type="smallint" />
+ <Column id="REM_TX_CURRENT" defaultValue="not null" type="smallint" />
+ <Column id="REM_TRANSACTION_ID" defaultValue="not null" type="INTEGER" />
+ <Constraint schema="OSEE" id="OSEE_REM_TXS_RG_RTX_PK" type="PRIMARY KEY" appliesTo="REM_GAMMA_ID, REM_TRANSACTION_ID"/>
+ </Table>
+
+
+ <!-- __________________________________________________________ -->
+ <!-- -->
+ <!-- IMPORT TABLES -->
+ <!-- __________________________________________________________ -->
+
+ <Table name="OSEE_JOIN_EXPORT_IMPORT" schema="OSEE" tablespace="osee_data">
+ <Column id="QUERY_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="ID1" defaultValue="not null" type="BIGINT" />
+ <Column id="ID2" defaultValue="not null" type="BIGINT" />
+ <Column id="INSERT_TIME" defaultValue="not null" type="TIMESTAMP" />
+ <Index id="OSEE_JOIN_EXPORT_IMPORT_Q_IDX" tablespace="osee_data">
+ <AppliesTo id="QUERY_ID"/>
+ </Index>
+ </Table>
+ <Table name="OSEE_IMPORT_SOURCE" schema="OSEE" tablespace="osee_data">
+ <Column id="IMPORT_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="DB_SOURCE_GUID" defaultValue="not null" type="VARCHAR" limits="28"/>
+ <Column id="SOURCE_EXPORT_DATE" defaultValue="not null" type="TIMESTAMP" />
+ <Column id="DATE_IMPORTED" defaultValue="not null" type="TIMESTAMP" />
+ <Constraint schema="OSEE" id="OSEE_IMPORT_MAP_PK" type="PRIMARY KEY" appliesTo="IMPORT_ID" />
+ </Table>
+ <Table name="OSEE_IMPORT_SAVE_POINT" schema="OSEE" tablespace="osee_data">
+ <Column id="IMPORT_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="SAVE_POINT_NAME" defaultValue="not null" type="VARCHAR" limits="128"/>
+ <Column id="STATUS" defaultValue="not null" type="INTEGER" />
+ <Column id="STATE_ERROR" type="VARCHAR" limits="4000" />
+ <Constraint schema="OSEE" id="OSEE_IMP_SAVE_POINT_II_PK" type="PRIMARY KEY" appliesTo="IMPORT_ID, SAVE_POINT_NAME" />
+ <Constraint schema="OSEE" id="OSEE_IMP_SAVE_POINT_II_FK" type="FOREIGN KEY" appliesTo="IMPORT_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_IMPORT_SOURCE" column="IMPORT_ID" />
+ </Constraint>
+ </Table>
+ <Table name="OSEE_IMPORT_MAP" schema="OSEE" tablespace="osee_data">
+ <Column id="IMPORT_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="SEQUENCE_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="SEQUENCE_NAME" defaultValue="not null" type="VARCHAR" limits="128"/>
+ <Constraint schema="OSEE" id="OSEE_IMPORT_MAP_II_PK" type="PRIMARY KEY" appliesTo="SEQUENCE_ID" />
+ <Constraint schema="OSEE" id="OSEE_IMPORT_MAP_II_FK" type="FOREIGN KEY" appliesTo="IMPORT_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_IMPORT_SOURCE" column="IMPORT_ID" />
+ </Constraint>
+ </Table>
+ <Table name="OSEE_IMPORT_INDEX_MAP" schema="OSEE" tablespace="osee_data">
+ <Column id="SEQUENCE_ID" defaultValue="not null" type="INTEGER" />
+ <Column id="ORIGINAL_ID" defaultValue="not null" type="BIGINT"/>
+ <Column id="MAPPED_ID" defaultValue="not null" type="BIGINT" />
+ <Constraint schema="OSEE" id="OSEE_IMPORT_INDEX_MAP_IOM_PK" type="PRIMARY KEY" appliesTo="SEQUENCE_ID, ORIGINAL_ID, MAPPED_ID" />
+ <Constraint schema="OSEE" id="OSEE_IMPORT_INDEX_MAP_II_FK" type="FOREIGN KEY" appliesTo="SEQUENCE_ID" deferrable="true">
+ <References schema="OSEE" table="OSEE_IMPORT_MAP" column="SEQUENCE_ID" />
+ </Constraint>
+ <Index id="OSEE_IMPORT_INDEX_MAP_IO_IDX" tablespace="osee_data">
+ <AppliesTo id="SEQUENCE_ID"/>
+ <AppliesTo id="ORIGINAL_ID"/>
+ </Index>
+ <Index id="OSEE_IMPORT_INDEX_MAP_IM_IDX" tablespace="osee_data">
+ <AppliesTo id="SEQUENCE_ID"/>
+ <AppliesTo id="MAPPED_ID"/>
+ </Index>
+ </Table>
+
+ <!-- __________________________________________________________ -->
+ <!-- -->
+ <!-- Application Server -->
+ <!-- -->
+ <!-- __________________________________________________________ -->
+
+ <Table name="OSEE_SERVER_LOOKUP" schema="OSEE" tablespace="osee_data">
+ <Column id="VERSION_ID" defaultValue="not null" type="VARCHAR" limits="100" />
+ <Column id="SERVER_ADDRESS" defaultValue="not null" type="VARCHAR" limits="255"/>
+ <Column id="PORT" defaultValue="not null" type="INTEGER" />
+ <Column id="ACCEPTS_REQUESTS" defaultValue="not null" type="smallint" />
+ <Column id="START_TIME" defaultValue="not null" type="TIMESTAMP" />
+ <Column id="SERVER_ID" defaultValue="not null" type="VARCHAR" limits="40" />
+ <Constraint schema="OSEE" id="OSEE_SERVER_LOOKUP_PK" type="PRIMARY KEY" appliesTo="SERVER_ADDRESS, PORT, VERSION_ID" />
+ </Table>
+
+ <Table name="OSEE_SESSION" schema="OSEE" tablespace="osee_data">
+ <Column id="MANAGED_BY_SERVER_ID" defaultValue="not null" type="VARCHAR" limits="40" />
+ <Column id="SESSION_ID" defaultValue="not null" type="VARCHAR" limits="28" />
+ <Column id="USER_ID" defaultValue="not null" type="VARCHAR" limits="100"/>
+ <Column id="CLIENT_MACHINE_NAME" defaultValue="not null" type="VARCHAR" limits="100"/>
+ <Column id="CLIENT_ADDRESS" defaultValue="not null" type="VARCHAR" limits="255"/>
+ <Column id="CLIENT_PORT" defaultValue="not null" type="INTEGER" />
+ <Column id="CLIENT_VERSION" defaultValue="not null" type="VARCHAR" limits="100"/>
+ <Column id="CREATED_ON" defaultValue="not null" type="TIMESTAMP" />
+ <Column id="LAST_INTERACTION_DATE" defaultValue="not null" type="TIMESTAMP" />
+ <Column id="LAST_INTERACTION" defaultValue="not null" type="VARCHAR" limits="1000"/>
+ <Constraint schema="OSEE" id="OSEE_SESSION_PK" type="PRIMARY KEY" appliesTo="SESSION_ID" />
+ </Table>
+
+ <!-- __________________________________________________________ -->
+ <!-- Coverage Temp -->
+ <!-- __________________________________________________________ -->
+ <Table name="OSEE_CVG_TESTUNITS" schema="OSEE" tablespace="osee_data">
+ <Column id="NAME_ID" limits="8,0" type="DECIMAL" />
+ <Column id="NAME" limits="255" type="VARCHAR" />
+ <Constraint schema="OSEE" id="CVG_NAME_ID_PK" type="UNIQUE" appliesTo="NAME_ID" />
+ </Table>
+
+</TableConfig>

Back to the top