You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by mg...@apache.org on 2017/01/16 22:39:42 UTC
[1/5] cayenne-modeler git commit: Moved sample model file to test
resources.
Repository: cayenne-modeler
Updated Branches:
refs/heads/master a29096d7c -> 8a569dbc5
http://git-wip-us.apache.org/repos/asf/cayenne-modeler/blob/8a569dbc/src/test/resources/cayenne-analytic.xml
----------------------------------------------------------------------
diff --git a/src/test/resources/cayenne-analytic.xml b/src/test/resources/cayenne-analytic.xml
new file mode 100644
index 0000000..a5b1898
--- /dev/null
+++ b/src/test/resources/cayenne-analytic.xml
@@ -0,0 +1,14 @@
+<?xml version="1.0" encoding="utf-8"?>
+<domain project-version="9">
+ <property name="cayenne.DataDomain.validatingObjectsOnCommit" value="false"/>
+ <property name="cayenne.DataRowStore.remote.notify" value="true"/>
+
+ <map name="analytic"/>
+
+ <node name="analytic"
+ factory="org.apache.cayenne.configuration.server.JNDIDataSourceFactory"
+ parameters="jdbc/analytic-db"
+ >
+ <map-ref name="analytic"/>
+ </node>
+</domain>
[4/5] cayenne-modeler git commit: Moved sample model file to test
resources.
Posted by mg...@apache.org.
http://git-wip-us.apache.org/repos/asf/cayenne-modeler/blob/8a569dbc/src/main/resources/analytic.map.xml
----------------------------------------------------------------------
diff --git a/src/main/resources/analytic.map.xml b/src/main/resources/analytic.map.xml
deleted file mode 100644
index 4fc0ba9..0000000
--- a/src/main/resources/analytic.map.xml
+++ /dev/null
@@ -1,2608 +0,0 @@
-<?xml version="1.0" encoding="utf-8"?>
-<data-map xmlns="http://cayenne.apache.org/schema/9/modelMap"
- xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
- xsi:schemaLocation="http://cayenne.apache.org/schema/9/modelMap http://cayenne.apache.org/schema/9/modelMap.xsd"
- project-version="9">
- <property name="defaultPackage" value="org.example.analytic.model"/>
- <property name="defaultSuperclass" value="org.example.analytic.model.AnalyticBase"/>
- <db-entity name="p_advance_procurement_cost_element_categories" catalog="cxe">
- <db-attribute name="advance_procurement_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
- <db-attribute name="type" type="VARCHAR" isMandatory="true" length="10"/>
- </db-entity>
- <db-entity name="p_advance_procurement_cost_elements" catalog="cxe">
- <db-attribute name="advance_procurement_cost_element_category_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="for_fiscal_year" type="VARCHAR" length="4"/>
- <db-attribute name="for_fiscal_year_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="quantity_per_assembly" type="SMALLINT" length="5"/>
- <db-attribute name="quantity_per_assembly_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="termination_liability_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="termination_liability_total_cost_fk" type="BIGINT" length="10"/>
- <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="title_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
- <db-attribute name="when_required_months" type="SMALLINT" length="5"/>
- <db-attribute name="when_required_months_footnote" type="LONGVARCHAR" length="65535"/>
- </db-entity>
- <db-entity name="p_advance_procurement_eoq_costs" catalog="cxe">
- <db-attribute name="advance_procurement_cost_element_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="for_fiscal_year" type="VARCHAR" length="4"/>
- <db-attribute name="for_fiscal_year_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="quantity" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="quantity_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
- </db-entity>
- <db-entity name="p_advance_procurements" catalog="cxe">
- <db-attribute name="description" type="LONGVARCHAR" length="16777215"/>
- <db-attribute name="first_system_award_month_and_year" type="DATE" length="10"/>
- <db-attribute name="first_system_award_month_and_year_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="first_system_completion_month_and_year" type="DATE" length="10"/>
- <db-attribute name="first_system_completion_month_and_year_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="id_code" type="CHAR" length="2"/>
- <db-attribute name="mdap_codes" type="VARCHAR" length="100"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="production_lead_time_months" type="SMALLINT" length="5"/>
- <db-attribute name="production_lead_time_months_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="system_interval_months" type="SMALLINT" length="5"/>
- <db-attribute name="system_interval_months_footnote" type="LONGVARCHAR" length="65535"/>
- </db-entity>
- <db-entity name="p_budget_quarters" catalog="cxe">
- <db-attribute name="by1_base_q1" type="INTEGER" length="7"/>
- <db-attribute name="by1_base_q1_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by1_base_q2" type="INTEGER" length="7"/>
- <db-attribute name="by1_base_q2_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by1_base_q3" type="INTEGER" length="7"/>
- <db-attribute name="by1_base_q3_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by1_base_q4" type="INTEGER" length="7"/>
- <db-attribute name="by1_base_q4_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by1_oco_q1" type="INTEGER" length="7"/>
- <db-attribute name="by1_oco_q1_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by1_oco_q2" type="INTEGER" length="7"/>
- <db-attribute name="by1_oco_q2_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by1_oco_q3" type="INTEGER" length="7"/>
- <db-attribute name="by1_oco_q3_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by1_oco_q4" type="INTEGER" length="7"/>
- <db-attribute name="by1_oco_q4_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by1_q1" type="INTEGER" length="7"/>
- <db-attribute name="by1_q1_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by1_q2" type="INTEGER" length="7"/>
- <db-attribute name="by1_q2_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by1_q3" type="INTEGER" length="7"/>
- <db-attribute name="by1_q3_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by1_q4" type="INTEGER" length="7"/>
- <db-attribute name="by1_q4_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by2_q1" type="INTEGER" length="7"/>
- <db-attribute name="by2_q1_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by2_q2" type="INTEGER" length="7"/>
- <db-attribute name="by2_q2_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by2_q3" type="INTEGER" length="7"/>
- <db-attribute name="by2_q3_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by2_q4" type="INTEGER" length="7"/>
- <db-attribute name="by2_q4_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by3_q1" type="INTEGER" length="7"/>
- <db-attribute name="by3_q1_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by3_q2" type="INTEGER" length="7"/>
- <db-attribute name="by3_q2_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by3_q3" type="INTEGER" length="7"/>
- <db-attribute name="by3_q3_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by3_q4" type="INTEGER" length="7"/>
- <db-attribute name="by3_q4_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by4_q1" type="INTEGER" length="7"/>
- <db-attribute name="by4_q1_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by4_q2" type="INTEGER" length="7"/>
- <db-attribute name="by4_q2_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by4_q3" type="INTEGER" length="7"/>
- <db-attribute name="by4_q3_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by4_q4" type="INTEGER" length="7"/>
- <db-attribute name="by4_q4_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by5_q1" type="INTEGER" length="7"/>
- <db-attribute name="by5_q1_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by5_q2" type="INTEGER" length="7"/>
- <db-attribute name="by5_q2_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by5_q3" type="INTEGER" length="7"/>
- <db-attribute name="by5_q3_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by5_q4" type="INTEGER" length="7"/>
- <db-attribute name="by5_q4_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="continuing" type="BIT"/>
- <db-attribute name="continuing_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="cy_q1" type="INTEGER" length="7"/>
- <db-attribute name="cy_q1_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="cy_q2" type="INTEGER" length="7"/>
- <db-attribute name="cy_q2_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="cy_q3" type="INTEGER" length="7"/>
- <db-attribute name="cy_q3_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="cy_q4" type="INTEGER" length="7"/>
- <db-attribute name="cy_q4_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="py_q1" type="INTEGER" length="7"/>
- <db-attribute name="py_q1_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="py_q2" type="INTEGER" length="7"/>
- <db-attribute name="py_q2_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="py_q3" type="INTEGER" length="7"/>
- <db-attribute name="py_q3_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="py_q4" type="INTEGER" length="7"/>
- <db-attribute name="py_q4_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="pys" type="INTEGER" length="7"/>
- <db-attribute name="pys_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="to_complete" type="INTEGER" length="7"/>
- <db-attribute name="to_complete_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="total_cost" type="INTEGER" length="7"/>
- <db-attribute name="total_cost_footnote" type="LONGVARCHAR" length="65535"/>
- </db-entity>
- <db-entity name="p_cost_element_categories" catalog="cxe">
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="item_fk" type="BIGINT" length="10"/>
- <db-attribute name="modification_group_fk" type="BIGINT" length="10"/>
- <db-attribute name="modification_item_fk" type="BIGINT" length="10"/>
- <db-attribute name="name" type="VARCHAR" length="255"/>
- <db-attribute name="name_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="quantity_fk" type="BIGINT" length="10"/>
- <db-attribute name="secondary_distribution_remarks" type="LONGVARCHAR" length="16777215"/>
- <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
- <db-attribute name="type" type="VARCHAR" isMandatory="true" length="20"/>
- </db-entity>
- <db-entity name="p_cost_element_sub_categories" catalog="cxe">
- <db-attribute name="cost_element_category_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="quantity_fk" type="BIGINT" length="10"/>
- <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
- <db-attribute name="type" type="VARCHAR" isMandatory="true" length="20"/>
- </db-entity>
- <db-entity name="p_cost_elements" catalog="cxe">
- <db-attribute name="all_pys_deliveries" type="DECIMAL" length="15" scale="3"/>
- <db-attribute name="all_pys_deliveries_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="category_supply_name" type="VARCHAR" length="50"/>
- <db-attribute name="contracted" type="BIT" isMandatory="true"/>
- <db-attribute name="cost_element_category_fk" type="BIGINT" length="10"/>
- <db-attribute name="cost_element_sub_category_fk" type="BIGINT" length="10"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="id_code" type="CHAR" length="2"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="quantity_fk" type="BIGINT" length="10"/>
- <db-attribute name="remarks" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
- <db-attribute name="unit_cost_fk" type="BIGINT" length="10"/>
- </db-entity>
- <db-entity name="p_delivery_schedules" catalog="cxe">
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="history_planning_fk" type="BIGINT" length="10"/>
- <db-attribute name="history_planning_for_total_fk" type="BIGINT" length="10"/>
- <db-attribute name="organization_fk" type="BIGINT" length="10"/>
- <db-attribute name="organization_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="organization_suffix" type="VARCHAR" length="100"/>
- <db-attribute name="organization_suffix_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="organizational_unit_fk" type="BIGINT" length="10"/>
- <db-attribute name="organizational_unit_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="total_quantity" type="DECIMAL" length="15" scale="3"/>
- <db-attribute name="total_quantity_footnote" type="LONGVARCHAR" length="65535"/>
- </db-entity>
- <db-entity name="p_facilities">
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="facility_project_type" type="CHAR" isMandatory="true" length="20"/>
- <db-attribute name="facility_type" type="CHAR" isMandatory="true" length="4"/>
- <db-attribute name="line_item_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="location" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="name" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- </db-entity>
- <db-entity name="p_histories_and_plannings" catalog="cxe">
- <db-attribute name="award_date" type="DATE" isMandatory="true" length="10"/>
- <db-attribute name="award_date_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="contract_designation_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="first_delivery_date" type="DATE" length="10"/>
- <db-attribute name="first_delivery_date_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="fiscal_year" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="fiscal_year_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="is_oco" type="BIT"/>
- <db-attribute name="is_oco_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="manufacturer_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="pco_location" type="VARCHAR" length="100"/>
- <db-attribute name="pco_location_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="quantity" type="DECIMAL" isMandatory="true" length="15" scale="3"/>
- <db-attribute name="quantity_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="revisions_available_date" type="DATE" length="10"/>
- <db-attribute name="revisions_available_date_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="rfp_issue_date" type="DATE" length="10"/>
- <db-attribute name="rfp_issue_date_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="specs_available_now" type="BIT"/>
- <db-attribute name="specs_available_now_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="suffix" type="VARCHAR" length="25"/>
- <db-attribute name="suffix_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="unit_cost" type="DECIMAL" isMandatory="true" length="15" scale="3"/>
- <db-attribute name="unit_cost_footnote" type="LONGVARCHAR" length="65535"/>
- </db-entity>
- <db-entity name="p_inactive_industrial_facility_project_fundings">
- <db-attribute name="inactive_industrial_facility_project_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="total_cost_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="type" type="CHAR" isMandatory="true" length="16"/>
- </db-entity>
- <db-entity name="p_inactive_industrial_facility_projects">
- <db-attribute name="category" type="VARCHAR" length="75"/>
- <db-attribute name="contractor" type="VARCHAR" length="125"/>
- <db-attribute name="description" type="LONGVARCHAR" length="16777215"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="facility_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="total_cost_fk" type="BIGINT" isMandatory="true" length="10"/>
- </db-entity>
- <db-entity name="p_item_categories" catalog="cxe">
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="item_group_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="title" type="VARCHAR" length="255"/>
- <db-attribute name="title_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
- </db-entity>
- <db-entity name="p_item_groups" catalog="cxe">
- <db-attribute name="exhibit_display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="is_modification_item" type="BIT" isMandatory="true"/>
- <db-attribute name="p21_remarks" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="p5a_remarks" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="quantity_fk" type="BIGINT" length="10"/>
- <db-attribute name="remarks" type="LONGVARCHAR" length="16777215"/>
- <db-attribute name="title" type="VARCHAR" length="255"/>
- <db-attribute name="title_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
- <db-attribute name="unit_cost_fk" type="BIGINT" length="10"/>
- </db-entity>
- <db-entity name="p_items" catalog="cxe">
- <db-attribute name="advance_procurement_fk" type="BIGINT" length="10"/>
- <db-attribute name="all_pys_deliveries" type="DECIMAL" length="15" scale="3"/>
- <db-attribute name="all_pys_deliveries_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="dodic" type="VARCHAR" length="5"/>
- <db-attribute name="exhibit_display_order" type="SMALLINT" length="5"/>
- <db-attribute name="id_code" type="CHAR" length="2"/>
- <db-attribute name="include_in_pdf" type="BIT" isMandatory="true"/>
- <db-attribute name="item_category_fk" type="BIGINT" length="10"/>
- <db-attribute name="line_item_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="mdap_code" type="VARCHAR" length="4"/>
- <db-attribute name="mdap_code_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="modification_type" type="VARCHAR" length="255"/>
- <db-attribute name="modification_type_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="number" type="VARCHAR" length="25"/>
- <db-attribute name="number_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="p21_remarks" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="p5a_remarks" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="pys_quantity_delta" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="pys_total_cost_delta" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="remarks" type="LONGVARCHAR" length="16777215"/>
- <db-attribute name="secondary_distribution_remarks" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="title_footnote" type="LONGVARCHAR" length="65535"/>
- </db-entity>
- <db-entity name="p_layaway_distribution_projects">
- <db-attribute name="annual_maintenance_cost" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="category" type="VARCHAR" length="255"/>
- <db-attribute name="code" type="VARCHAR" isMandatory="true" length="25"/>
- <db-attribute name="description" type="LONGVARCHAR" length="16777215"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="facility_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="layaway_cost" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="other_costs" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="production_ends" type="VARCHAR" length="75"/>
- <db-attribute name="production_lines_laid_away_location" type="VARCHAR" length="255"/>
- <db-attribute name="production_lines_laid_away_name" type="VARCHAR" length="255"/>
- <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="total_cost_fk" type="BIGINT" isMandatory="true" length="10"/>
- </db-entity>
- <db-entity name="p_line_items" catalog="cxe">
- <db-attribute name="advance_procurement_description" type="LONGVARCHAR" length="16777215"/>
- <db-attribute name="advance_procurement_justification" type="LONGVARCHAR" length="16777215"/>
- <db-attribute name="advance_procurement_p1_line_number" type="VARCHAR" length="10"/>
- <db-attribute name="ap_only_flag" type="BIT"/>
- <db-attribute name="combined_p5_flag" type="BIT"/>
- <db-attribute name="delta_quantity_fk" type="BIGINT" length="10"/>
- <db-attribute name="delta_total_cost_fk" type="BIGINT" length="10"/>
- <db-attribute name="description" type="LONGVARCHAR" length="16777215"/>
- <db-attribute name="funding_designation_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="id_code" type="CHAR" length="2"/>
- <db-attribute name="line_item_number" type="VARCHAR" isMandatory="true" length="25"/>
- <db-attribute name="line_item_title" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="mdap_codes" type="VARCHAR" length="100"/>
- <db-attribute name="mdap_codes_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="myp1_count" type="SMALLINT" length="5"/>
- <db-attribute name="myp2_count" type="SMALLINT" length="5"/>
- <db-attribute name="myp3_count" type="SMALLINT" length="5"/>
- <db-attribute name="myp4_count" type="SMALLINT" length="5"/>
- <db-attribute name="p10_count" type="SMALLINT" length="5"/>
- <db-attribute name="p17_count" type="SMALLINT" length="5"/>
- <db-attribute name="p18_count" type="SMALLINT" length="5"/>
- <db-attribute name="p1_count" type="SMALLINT" length="5"/>
- <db-attribute name="p1_line_number" type="VARCHAR" length="10"/>
- <db-attribute name="p20_count" type="SMALLINT" length="5"/>
- <db-attribute name="p21_count" type="SMALLINT" length="5"/>
- <db-attribute name="p23_count" type="SMALLINT" length="5"/>
- <db-attribute name="p25_count" type="SMALLINT" length="5"/>
- <db-attribute name="p26_count" type="SMALLINT" length="5"/>
- <db-attribute name="p3a_count" type="SMALLINT" length="5"/>
- <db-attribute name="p40a_count" type="SMALLINT" length="5"/>
- <db-attribute name="p40a_item_schedule_flag" type="CHAR" isMandatory="true" length="28"/>
- <db-attribute name="p5_count" type="SMALLINT" length="5"/>
- <db-attribute name="p5a_count" type="SMALLINT" length="5"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="production_rate_interval" type="CHAR" isMandatory="true" length="9"/>
- <db-attribute name="pys_quantity_delta" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="pys_total_cost_delta" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="quantity_unit_format" type="CHAR" length="5"/>
- <db-attribute name="remarks" type="LONGVARCHAR" length="16777215"/>
- <db-attribute name="secondary_distribution_remarks" type="LONGVARCHAR" length="16777215"/>
- <db-attribute name="secondary_distribution_subtotal_quantity_fk" type="BIGINT" length="10"/>
- <db-attribute name="secondary_distribution_subtotal_total_cost_fk" type="BIGINT" length="10"/>
- <db-attribute name="total_cost_format" type="CHAR" isMandatory="true" length="9"/>
- <db-attribute name="unit_cost_format" type="CHAR" isMandatory="true" length="9"/>
- <db-attribute name="unit_quantity_format" type="CHAR" isMandatory="true" length="9"/>
- </db-entity>
- <db-entity name="p_manufacturers" catalog="cxe">
- <db-attribute name="admin_lead_time_after_oct1_initial_months" type="SMALLINT" length="5"/>
- <db-attribute name="admin_lead_time_after_oct1_initial_months_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="admin_lead_time_after_oct1_reorder_months" type="SMALLINT" length="5"/>
- <db-attribute name="admin_lead_time_after_oct1_reorder_months_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="admin_lead_time_prior_oct1_initial_months" type="SMALLINT" length="5"/>
- <db-attribute name="admin_lead_time_prior_oct1_initial_months_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="admin_lead_time_prior_oct1_reorder_months" type="SMALLINT" length="5"/>
- <db-attribute name="admin_lead_time_prior_oct1_reorder_months_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="advance_procurement_cost_element_fk" type="BIGINT" length="10"/>
- <db-attribute name="contract_location" type="VARCHAR" isMandatory="true" length="125"/>
- <db-attribute name="contract_location_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="contractor" type="VARCHAR" isMandatory="true" length="125"/>
- <db-attribute name="contractor_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="cost_element_fk" type="BIGINT" length="10"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="item_fk" type="BIGINT" length="10"/>
- <db-attribute name="maximum_production_rate" type="DECIMAL" length="14" scale="2"/>
- <db-attribute name="maximum_production_rate_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="minimum_sustaining_rate" type="DECIMAL" length="14" scale="2"/>
- <db-attribute name="minimum_sustaining_rate_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="one_eight_five" type="DECIMAL" length="14" scale="2"/>
- <db-attribute name="one_eight_five_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="production_lead_time_initial_months" type="SMALLINT" length="5"/>
- <db-attribute name="production_lead_time_initial_months_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="production_lead_time_reorder_months" type="SMALLINT" length="5"/>
- <db-attribute name="production_lead_time_reorder_months_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="total_lead_time_initial_months" type="SMALLINT" length="5"/>
- <db-attribute name="total_lead_time_initial_months_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="total_lead_time_reorder_months" type="SMALLINT" length="5"/>
- <db-attribute name="total_lead_time_reorder_months_footnote" type="LONGVARCHAR" length="65535"/>
- </db-entity>
- <db-entity name="p_models_affected">
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="item_fk" type="BIGINT" length="10"/>
- <db-attribute name="modification_group_fk" type="BIGINT" length="10"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="title_footnote" type="LONGVARCHAR" length="65535"/>
- </db-entity>
- <db-entity name="p_modification_groups" catalog="cxe">
- <db-attribute name="advance_procurement_fk" type="BIGINT" length="10"/>
- <db-attribute name="description" type="LONGVARCHAR" isMandatory="true" length="16777215"/>
- <db-attribute name="exhibit_display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="installation_quantity_subtotal_fk" type="BIGINT" length="10"/>
- <db-attribute name="installation_total_cost_subtotal_fk" type="BIGINT" length="10"/>
- <db-attribute name="line_item_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="mdap_code" type="VARCHAR" length="4"/>
- <db-attribute name="mdap_code_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="models" type="VARCHAR" length="255"/>
- <db-attribute name="models_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="modification_number" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="modification_number_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="procurement_quantity_subtotal_fk" type="BIGINT" length="10"/>
- <db-attribute name="procurement_total_cost_subtotal_fk" type="BIGINT" length="10"/>
- <db-attribute name="pys_quantity_delta" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="pys_total_cost_delta" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="secondary_distribution_remarks" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="support_secondary_distribution_remarks" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="title_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="type" type="VARCHAR" length="255"/>
- <db-attribute name="type_footnote" type="LONGVARCHAR" length="65535"/>
- </db-entity>
- <db-entity name="p_modification_item_implementation_methods" catalog="cxe">
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="install_name" type="VARCHAR" length="100"/>
- <db-attribute name="install_name_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="modification_item_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="name" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="name_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="quantity" type="BIGINT" length="10"/>
- <db-attribute name="quantity_footnote" type="LONGVARCHAR" length="65535"/>
- </db-entity>
- <db-entity name="p_modification_item_installation_costs" catalog="cxe">
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="fiscal_year" type="CHAR" isMandatory="true" length="5"/>
- <db-attribute name="modification_item_implementation_method_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="quantity_fk" type="BIGINT" length="10"/>
- <db-attribute name="secondary_distribution_remarks" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
- </db-entity>
- <db-entity name="p_modification_item_installation_ins_outs" catalog="cxe">
- <db-attribute name="budget_quarters_fk" type="BIGINT" length="10"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="modification_item_implementation_method_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="type" type="CHAR" isMandatory="true" length="2"/>
- </db-entity>
- <db-entity name="p_modification_item_manufacturers" catalog="cxe">
- <db-attribute name="admin_lead_time_months" type="SMALLINT" length="5"/>
- <db-attribute name="admin_lead_time_months_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="award_date_by1" type="TIMESTAMP" length="19"/>
- <db-attribute name="award_date_by1_base" type="TIMESTAMP" length="19"/>
- <db-attribute name="award_date_by1_base_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="award_date_by1_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="award_date_by1_oco" type="TIMESTAMP" length="19"/>
- <db-attribute name="award_date_by1_oco_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="award_date_by2" type="TIMESTAMP" length="19"/>
- <db-attribute name="award_date_by2_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="award_date_by3" type="TIMESTAMP" length="19"/>
- <db-attribute name="award_date_by3_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="award_date_by4" type="TIMESTAMP" length="19"/>
- <db-attribute name="award_date_by4_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="award_date_by5" type="TIMESTAMP" length="19"/>
- <db-attribute name="award_date_by5_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="award_date_cy" type="TIMESTAMP" length="19"/>
- <db-attribute name="award_date_cy_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="award_date_py" type="TIMESTAMP" length="19"/>
- <db-attribute name="award_date_py_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="delivery_date_by1" type="TIMESTAMP" length="19"/>
- <db-attribute name="delivery_date_by1_base" type="TIMESTAMP" length="19"/>
- <db-attribute name="delivery_date_by1_base_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="delivery_date_by1_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="delivery_date_by1_oco" type="TIMESTAMP" length="19"/>
- <db-attribute name="delivery_date_by1_oco_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="delivery_date_by2" type="TIMESTAMP" length="19"/>
- <db-attribute name="delivery_date_by2_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="delivery_date_by3" type="TIMESTAMP" length="19"/>
- <db-attribute name="delivery_date_by3_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="delivery_date_by4" type="TIMESTAMP" length="19"/>
- <db-attribute name="delivery_date_by4_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="delivery_date_by5" type="TIMESTAMP" length="19"/>
- <db-attribute name="delivery_date_by5_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="delivery_date_cy" type="TIMESTAMP" length="19"/>
- <db-attribute name="delivery_date_cy_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="delivery_date_py" type="TIMESTAMP" length="19"/>
- <db-attribute name="delivery_date_py_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="location" type="VARCHAR" isMandatory="true" length="125"/>
- <db-attribute name="location_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="modification_item_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="name" type="VARCHAR" isMandatory="true" length="125"/>
- <db-attribute name="name_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="production_lead_time_months" type="SMALLINT" length="5"/>
- <db-attribute name="production_lead_time_months_footnote" type="LONGVARCHAR" length="65535"/>
- </db-entity>
- <db-entity name="p_modification_items" catalog="cxe">
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="installation_subtotal_quantity_fk" type="BIGINT" length="10"/>
- <db-attribute name="installation_subtotal_total_cost_fk" type="BIGINT" length="10"/>
- <db-attribute name="mdap_code" type="VARCHAR" length="4"/>
- <db-attribute name="mdap_code_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="modification_group_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="procurement_subtotal_quantity_fk" type="BIGINT" length="10"/>
- <db-attribute name="procurement_subtotal_total_cost_fk" type="BIGINT" length="10"/>
- <db-attribute name="remarks" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="secondary_distribution_remarks" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
- </db-entity>
- <db-entity name="p_modification_milestones">
- <db-attribute name="description" type="VARCHAR" length="1000"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="milestone" type="DATE" isMandatory="true"/>
- <db-attribute name="milestone_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="modification_group_fk" type="BIGINT" isMandatory="true"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true"/>
- <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="title_footnote" type="LONGVARCHAR" length="65535"/>
- </db-entity>
- <db-entity name="p_monthly_deliveries" catalog="cxe">
- <db-attribute name="delivery_schedule_fk" type="BIGINT" length="10"/>
- <db-attribute name="month_and_year" type="DATE" isMandatory="true" length="10"/>
- <db-attribute name="month_and_year_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="quantity" type="DECIMAL" length="15" scale="3"/>
- <db-attribute name="quantity_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="secondary_distribution_delivery_schedule_fk" type="BIGINT" length="10"/>
- </db-entity>
- <db-entity name="p_organizational_units" catalog="cxe">
- <db-attribute name="code" type="VARCHAR" isMandatory="true" length="15"/>
- <db-attribute name="description" type="VARCHAR" length="100"/>
- <db-attribute name="name" type="VARCHAR" isMandatory="true" length="50"/>
- <db-attribute name="organization_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- </db-entity>
- <db-entity name="p_production_support_facility_project_cost_element_items">
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="production_support_facility_project_cost_element_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="title" type="VARCHAR" isMandatory="true" length="75"/>
- <db-attribute name="total_cost_fk" type="BIGINT" isMandatory="true" length="10"/>
- </db-entity>
- <db-entity name="p_production_support_facility_project_cost_elements">
- <db-attribute name="note" type="VARCHAR" length="1000"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="production_support_facility_project_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="total_cost_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="type" type="CHAR" isMandatory="true" length="32"/>
- </db-entity>
- <db-entity name="p_production_support_facility_project_milestones">
- <db-attribute name="comment" type="VARCHAR" length="25"/>
- <db-attribute name="month_and_year" type="DATE"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="production_support_facility_project_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="type" type="CHAR" isMandatory="true" length="32"/>
- </db-entity>
- <db-entity name="p_production_support_facility_project_related_projects">
- <db-attribute name="appropriation_code" type="VARCHAR" length="100"/>
- <db-attribute name="code" type="VARCHAR" isMandatory="true" length="25"/>
- <db-attribute name="completion_date" type="DATE"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="facing" type="VARCHAR" length="25"/>
- <db-attribute name="fiscal_year" type="SMALLINT" isMandatory="true"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="production_support_facility_project_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="start_date" type="DATE"/>
- <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="value" type="DECIMAL" isMandatory="true" length="13" scale="3"/>
- </db-entity>
- <db-entity name="p_production_support_facility_projects">
- <db-attribute name="capacity_after" type="VARCHAR" length="10"/>
- <db-attribute name="capacity_before" type="VARCHAR" length="10"/>
- <db-attribute name="category" type="VARCHAR" length="255"/>
- <db-attribute name="code" type="VARCHAR" isMandatory="true" length="25"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="end_item" type="VARCHAR" length="255"/>
- <db-attribute name="facility_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="narrative" type="LONGVARCHAR" length="16777215"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="total_cost_fk" type="BIGINT" isMandatory="true" length="10"/>
- </db-entity>
- <db-entity name="p_related_program_elements" catalog="cxe">
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="line_item_fk" type="BIGINT" length="10"/>
- <db-attribute name="modification_group_fk" type="BIGINT" length="10"/>
- <db-attribute name="modification_item_fk" type="BIGINT" length="10"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="program_element_number" type="VARCHAR" length="10"/>
- <db-attribute name="program_element_number_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="quantity_fk" type="BIGINT" length="10"/>
- <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
- <db-attribute name="type" type="CHAR" isMandatory="true" length="1"/>
- </db-entity>
- <db-entity name="p_resource_summaries" catalog="cxe">
- <db-attribute name="budget_years_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="id_code" type="CHAR" length="2"/>
- <db-attribute name="item_fk" type="BIGINT" length="10"/>
- <db-attribute name="line_item_fk" type="BIGINT" length="10"/>
- <db-attribute name="modification_group_fk" type="BIGINT" length="10"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="title" type="VARCHAR" length="255"/>
- <db-attribute name="title_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="type" type="VARCHAR" isMandatory="true" length="16"/>
- </db-entity>
- <db-entity name="p_secondary_distribution_delivery_schedules" catalog="cxe">
- <db-attribute name="delivery_schedule_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="organization_fk" type="BIGINT" length="10"/>
- <db-attribute name="organization_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="organization_suffix" type="VARCHAR" length="100"/>
- <db-attribute name="organization_suffix_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="organizational_unit_fk" type="BIGINT" length="10"/>
- <db-attribute name="organizational_unit_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="procurement_quantity" type="DECIMAL" length="15" scale="3"/>
- <db-attribute name="procurement_quantity_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="remarks" type="LONGVARCHAR" length="65535"/>
- </db-entity>
- <db-entity name="p_secondary_distributions" catalog="cxe">
- <db-attribute name="cost_element_category_fk" type="BIGINT" length="10"/>
- <db-attribute name="delta_out_years_quantity_fk" type="BIGINT" length="10"/>
- <db-attribute name="delta_out_years_total_cost_fk" type="BIGINT" length="10"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="item_fk" type="BIGINT" length="10"/>
- <db-attribute name="line_item_fk" type="BIGINT" length="10"/>
- <db-attribute name="modification_group_fk" type="BIGINT" length="10"/>
- <db-attribute name="modification_item_fk" type="BIGINT" length="10"/>
- <db-attribute name="modification_item_installation_cost_fk" type="BIGINT" length="10"/>
- <db-attribute name="organization_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="organization_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="organization_suffix" type="VARCHAR" length="100"/>
- <db-attribute name="organization_suffix_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="organizational_unit_fk" type="BIGINT" length="10"/>
- <db-attribute name="organizational_unit_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="quantity_fk" type="BIGINT" length="10"/>
- <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
- </db-entity>
- <db-entity name="p_spare_parts_budget_activities" catalog="cxe">
- <db-attribute name="budget_activity_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="spare_parts_category_fk" type="BIGINT" isMandatory="true" length="10"/>
- </db-entity>
- <db-entity name="p_spare_parts_categories" catalog="cxe">
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="spare_parts_group_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
- <db-attribute name="type" type="VARCHAR" isMandatory="true" length="20"/>
- </db-entity>
- <db-entity name="p_spare_parts_groups" catalog="cxe">
- <db-attribute name="exempt_spares_total_cost_fk" type="BIGINT" length="10"/>
- <db-attribute name="exhibit_display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="name" type="VARCHAR" length="255"/>
- <db-attribute name="name_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="pys_delta" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="remarks" type="LONGVARCHAR" length="16777215"/>
- <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
- <db-attribute name="wcf_total_cost_fk" type="BIGINT" length="10"/>
- </db-entity>
- <db-entity name="p_spare_parts_items" catalog="cxe">
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="line_item_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="line_item_number" type="VARCHAR" length="25"/>
- <db-attribute name="line_item_title" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="mdap_code" type="VARCHAR" length="4"/>
- <db-attribute name="mdap_code_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="remarks" type="LONGVARCHAR" length="16777215"/>
- <db-attribute name="spare_parts_budget_activity_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
- </db-entity>
- <db-entity name="p_sub_cost_elements" catalog="cxe">
- <db-attribute name="budget_quarters_fk" type="BIGINT" length="10"/>
- <db-attribute name="cost_element_fk" type="BIGINT" length="10"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="id_code" type="CHAR" length="2"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="quantity_fk" type="BIGINT" length="10"/>
- <db-attribute name="remarks" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="title" type="VARCHAR" length="255"/>
- <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
- <db-attribute name="unit_cost_fk" type="BIGINT" length="10"/>
- </db-entity>
- <db-entity name="r_accomplishments_planned_programs" catalog="cxe">
- <db-attribute name="accomplishment_article_py" type="BIGINT" length="10"/>
- <db-attribute name="accomplishment_py" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="accomplishment_py_other" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="accomplishment_py_text" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="description" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="planned_program_article_by1" type="BIGINT" length="10"/>
- <db-attribute name="planned_program_article_by1_base" type="BIGINT" length="10"/>
- <db-attribute name="planned_program_article_by1_oco" type="BIGINT" length="10"/>
- <db-attribute name="planned_program_article_cy" type="BIGINT" length="10"/>
- <db-attribute name="planned_program_by1" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="planned_program_by1_base" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="planned_program_by1_base_other" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="planned_program_by1_oco" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="planned_program_by1_oco_other" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="planned_program_by1_other" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="planned_program_by1_text_base" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="planned_program_by1_text_oco" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="planned_program_cy" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="planned_program_cy_other" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="planned_program_cy_text" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="project_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
- </db-entity>
- <db-entity name="r_congressional_add_details" catalog="cxe">
- <db-attribute name="cy" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="cy_text" type="VARCHAR" length="4000"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="project_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="py" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="py_text" type="VARCHAR" length="4000"/>
- <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
- </db-entity>
- <db-entity name="r_cost_category_groups" catalog="cxe">
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="project_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="remarks" type="VARCHAR" length="5000"/>
- <db-attribute name="type" type="CHAR" isMandatory="true" length="20"/>
- </db-entity>
- <db-entity name="r_cost_category_items" catalog="cxe">
- <db-attribute name="award_date_by1_base" type="DATE"/>
- <db-attribute name="award_date_by1_oco" type="DATE"/>
- <db-attribute name="award_date_cy" type="DATE"/>
- <db-attribute name="award_date_py" type="DATE"/>
- <db-attribute name="contract_designation_fk" type="BIGINT" length="10"/>
- <db-attribute name="cost_category_group_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="name" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="performing_activity" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="performing_activity_location" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="target_value" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="target_value_continuing" type="BIT"/>
- <db-attribute name="target_value_str" type="VARCHAR" length="11"/>
- <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
- </db-entity>
- <db-entity name="r_joint_fundings" catalog="cxe">
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="project_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="target_value" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="target_value_continuing" type="BIT"/>
- <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
- </db-entity>
- <db-entity name="r_major_performers" catalog="cxe">
- <db-attribute name="date_awarded" type="DATE" length="10"/>
- <db-attribute name="description" type="VARCHAR" length="512"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="funds" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="location" type="VARCHAR" length="255"/>
- <db-attribute name="name" type="VARCHAR" isMandatory="true" length="75"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="project_fk" type="BIGINT" isMandatory="true" length="10"/>
- </db-entity>
- <db-entity name="r_other_adjustments" catalog="cxe">
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="program_element_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
- </db-entity>
- <db-entity name="r_other_program_fundings" catalog="cxe">
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="line_item" type="VARCHAR" isMandatory="true" length="35"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="project_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
- </db-entity>
- <db-entity name="r_program_elements" catalog="cxe">
- <db-attribute name="change_summary_explanation" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="congressional_adds_fk" type="BIGINT" length="10"/>
- <db-attribute name="congressional_directed_reductions_fk" type="BIGINT" length="10"/>
- <db-attribute name="congressional_directed_transfers_fk" type="BIGINT" length="10"/>
- <db-attribute name="congressional_general_reductions_fk" type="BIGINT" length="10"/>
- <db-attribute name="congressional_rescissions_fk" type="BIGINT" length="10"/>
- <db-attribute name="current_pb_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="format" type="CHAR" length="9"/>
- <db-attribute name="funding_designation_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="mdap_codes" type="VARCHAR" length="100"/>
- <db-attribute name="mission_description" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="monetary_unit_format" type="CHAR" isMandatory="true" length="9"/>
- <db-attribute name="notes" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="previous_pb_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="program_element_number" type="VARCHAR" isMandatory="true" length="10"/>
- <db-attribute name="pys_delta" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="r1_count" type="SMALLINT" length="5"/>
- <db-attribute name="r1_number" type="VARCHAR" length="10"/>
- <db-attribute name="r2_count" type="SMALLINT" length="5"/>
- <db-attribute name="r2a_count" type="SMALLINT" length="5"/>
- <db-attribute name="r3_count" type="SMALLINT" length="5"/>
- <db-attribute name="r4_count" type="SMALLINT" length="5"/>
- <db-attribute name="r4a_count" type="SMALLINT" length="5"/>
- <db-attribute name="r5_count" type="SMALLINT" length="5"/>
- <db-attribute name="reprogrammings_fk" type="BIGINT" length="10"/>
- <db-attribute name="sbir_sttr_transfer_fk" type="BIGINT" length="10"/>
- <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="total_adjusted_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="total_cost_fk" type="BIGINT" isMandatory="true" length="10"/>
- </db-entity>
- <db-entity name="r_projects" catalog="cxe">
- <db-attribute name="articles_in_accomplishments_planned_program" type="BIT"/>
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="include_project_in_pdf" type="BIT" isMandatory="true"/>
- <db-attribute name="mdap_code" type="VARCHAR" length="4"/>
- <db-attribute name="mission_description" type="LONGVARCHAR" isMandatory="true" length="65535"/>
- <db-attribute name="notes" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="other_program_remarks" type="LONGVARCHAR" length="5000"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="program_element_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="project_acquisition_strategy" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="project_article_fk" type="BIGINT" length="10"/>
- <db-attribute name="project_major_performers" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="project_number" type="VARCHAR" isMandatory="true" length="25"/>
- <db-attribute name="project_performance_metrics" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="project_schedule_detail_remarks" type="LONGVARCHAR" length="5000"/>
- <db-attribute name="project_schedule_profile_remarks" type="LONGVARCHAR" length="5000"/>
- <db-attribute name="project_title" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="pys_delta" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="r3_remarks" type="LONGVARCHAR" length="5000"/>
- <db-attribute name="special_project" type="BIT" isMandatory="true"/>
- <db-attribute name="termination_liability_fk" type="BIGINT" length="10"/>
- <db-attribute name="termination_liability_remarks" type="LONGVARCHAR" length="5000"/>
- <db-attribute name="total_cost_fk" type="BIGINT" isMandatory="true" length="10"/>
- </db-entity>
- <db-entity name="r_schedule_details" catalog="cxe">
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="end_quarter" type="TINYINT" isMandatory="true" length="3"/>
- <db-attribute name="end_year" type="SMALLINT" isMandatory="true"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="schedule_sub_project_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="start_quarter" type="TINYINT" isMandatory="true" length="3"/>
- <db-attribute name="start_year" type="SMALLINT" isMandatory="true"/>
- <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
- </db-entity>
- <db-entity name="r_schedule_profiles" catalog="cxe">
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="image_data" type="LONGVARBINARY" isMandatory="true" length="16777215"/>
- <db-attribute name="image_name" type="VARCHAR" isMandatory="true" length="255"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="project_fk" type="BIGINT" isMandatory="true" length="10"/>
- </db-entity>
- <db-entity name="r_schedule_sub_projects" catalog="cxe">
- <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="project_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
- </db-entity>
- <db-entity name="s_appropriations" catalog="cxe">
- <db-attribute name="code" type="VARCHAR" isMandatory="true" length="10"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="title" type="VARCHAR" isMandatory="true" length="75"/>
- </db-entity>
- <db-entity name="s_budget_activities" catalog="cxe">
- <db-attribute name="code" type="VARCHAR" isMandatory="true" length="10"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="title" type="VARCHAR" isMandatory="true" length="75"/>
- </db-entity>
- <db-entity name="s_budget_periods" catalog="cxe">
- <db-attribute name="cycle" type="CHAR" isMandatory="true" length="4"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="submission_date" type="DATE" isMandatory="true" length="10"/>
- <db-attribute name="suffix" type="VARCHAR" length="25"/>
- <db-attribute name="year" type="VARCHAR" isMandatory="true" length="4"/>
- </db-entity>
- <db-entity name="s_budget_sub_activities" catalog="cxe">
- <db-attribute name="code" type="VARCHAR" isMandatory="true" length="10"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="title" type="VARCHAR" isMandatory="true" length="75"/>
- </db-entity>
- <db-entity name="s_budget_years">
- <db-attribute name="by1" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="by1_base" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="by1_base_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by1_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by1_oco" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="by1_oco_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by2" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="by2_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by3" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="by3_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by4" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="by4_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="by5" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="by5_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="continuing" type="BOOLEAN"/>
- <db-attribute name="continuing_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="cy" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="cy_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="py" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="py_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="pys" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="pys_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="to_complete" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="to_complete_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="total" type="DECIMAL" length="13" scale="3"/>
- <db-attribute name="total_footnote" type="LONGVARCHAR" length="65535"/>
- <db-attribute name="type" type="VARCHAR" isMandatory="true" length="2"/>
- </db-entity>
- <db-entity name="s_contract_designations" catalog="cxe">
- <db-attribute name="contract_method" type="VARCHAR" length="25"/>
- <db-attribute name="contract_type" type="VARCHAR" length="25"/>
- <db-attribute name="funding_vehicle" type="VARCHAR" length="25"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- </db-entity>
- <db-entity name="s_funding_designations" catalog="cxe">
- <db-attribute name="appropriation_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="budget_activity_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="budget_period_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="budget_sub_activity_fk" type="BIGINT" length="10"/>
- <db-attribute name="exhibit_category" type="CHAR" isMandatory="true" length="2"/>
- <db-attribute name="organization_fk" type="BIGINT" isMandatory="true" length="10"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- </db-entity>
- <db-entity name="s_organizations" catalog="cxe">
- <db-attribute name="code" type="VARCHAR" isMandatory="true" length="8"/>
- <db-attribute name="name" type="VARCHAR" isMandatory="true" length="75"/>
- <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
- <db-attribute name="smca" type="BIT" isMandatory="true"/>
- </db-entity>
- <obj-entity name="AccomplishmentPlannedProgram" className="org.example.analytic.model.AccomplishmentPlannedProgram" dbEntityName="r_accomplishments_planned_programs" superClassName="org.example.analytic.model.AnalyticBase">
- <obj-attribute name="accomplishmentArticlePY" type="java.lang.Long" db-attribute-path="accomplishment_article_py"/>
- <obj-attribute name="accomplishmentPY" type="java.math.BigDecimal" db-attribute-path="accomplishment_py"/>
- <obj-attribute name="accomplishmentPYOther" type="java.math.BigDecimal" db-attribute-path="accomplishment_py_other"/>
- <obj-attribute name="accomplishmentPYText" type="java.lang.String" db-attribute-path="accomplishment_py_text"/>
- <obj-attribute name="description" type="java.lang.String" db-attribute-path="description"/>
- <obj-attribute name="displayOrder" type="java.lang.Short" db-attribute-path="display_order"/>
- <obj-attribute name="plannedProgramArticleBY1" type="java.lang.Long" db-attribute-path="planned_program_article_by1"/>
- <obj-attribute name="plannedProgramArticleBY1Base" type="java.lang.Long" db-attribute-path="planned_program_article_by1_base"/>
- <obj-attribute name="plannedProgramArticleBY1OCO" type="java.lang.Long" db-attribute-path="planned_program_article_by1_oco"/>
- <obj-attribute name="plannedProgramArticleCY" type="java.lang.Long" db-attribute-path="planned_program_article_cy"/>
- <obj-attribute name="plannedProgramBY1" type="java.math.BigDecimal" db-attribute-path="planned_program_by1"/>
- <obj-attribute name="plannedProgramBY1Base" type="java.math.BigDecimal" db-attribute-path="planned_program_by1_base"/>
- <obj-attribute name="plannedProgramBY1BaseOther" type="java.math.BigDecimal" db-attribute-path="planned_program_by1_base_other"/>
- <obj-attribute name="plannedProgramBY1OCO" type="java.math.BigDecimal" db-attribute-path="planned_program_by1_oco"/>
- <obj-attribute name="plannedProgramBY1OCOOther" type="java.math.BigDecimal" db-attribute-path="planned_program_by1_oco_other"/>
- <obj-attribute name="plannedProgramBY1Other" type="java.math.BigDecimal" db-attribute-path="planned_program_by1_other"/>
- <obj-attribute name="plannedProgramBY1TextBase" type="java.lang.String" db-attribute-path="planned_program_by1_text_base"/>
- <obj-attribute name="plannedProgramBY1TextOCO" type="java.lang.String" db-attribute-path="planned_program_by1_text_oco"/>
- <obj-attribute name="plannedProgramCY" type="java.math.BigDecimal" db-attribute-path="planned_program_cy"/>
- <obj-attribute name="plannedProgramCYOther" type="java.math.BigDecimal" db-attribute-path="planned_program_cy_other"/>
- <obj-attribute name="plannedProgramCYText" type="java.lang.String" db-attribute-path="planned_program_cy_text"/>
- <obj-attribute name="title" type="java.lang.String" db-attribute-path="title"/>
- </obj-entity>
- <obj-entity name="AdvanceProcurement" className="org.example.analytic.model.AdvanceProcurement" dbEntityName="p_advance_procurements" superClassName="org.example.analytic.model.AnalyticBase">
- <obj-attribute name="description" type="java.lang.String" db-attribute-path="description"/>
- <obj-attribute name="firstSystemAwardMonthAndYear" type="java.util.Date" db-attribute-path="first_system_award_month_and_year"/>
- <obj-attribute name="firstSystemAwardMonthAndYearFootnote" type="java.lang.String" db-attribute-path="first_system_award_month_and_year_footnote"/>
- <obj-attribute name="firstSystemCompletionMonthAndYear" type="java.util.Date" db-attribute-path="first_system_completion_month_and_year"/>
- <obj-attribute name="firstSystemCompletionMonthAndYearFootnote" type="java.lang.String" db-attribute-path="first_system_completion_month_and_year_footnote"/>
- <obj-attribute name="idCode" type="org.example.analytic.model.constants.IDCodeType" db-attribute-path="id_code"/>
- <obj-attribute name="mdapCodes" type="java.lang.String" db-attribute-path="mdap_codes"/>
- <obj-attribute name="productionLeadTimeMonths" type="java.lang.Short" db-attribute-path="production_lead_time_months"/>
- <obj-attribute name="productionLeadTimeMonthsFootnote" type="java.lang.String" db-attribute-path="production_lead_time_months_footnote"/>
- <obj-attribute name="systemIntervalMonths" type="java.lang.Short" db-attribute-path="system_interval_months"/>
- <obj-attribute name="systemIntervalMonthsFootnote" type="java.lang.String" db-attribute-path="system_interval_months_footnote"/>
- </obj-entity>
- <obj-entity name="AdvanceProcurementCostElement" className="org.example.analytic.model.AdvanceProcurementCostElement" dbEntityName="p_advance_procurement_cost_elements" superClassName="org.example.analytic.model.AnalyticBase">
- <obj-attribute name="displayOrder" type="java.lang.Short" db-attribute-path="display_order"/>
- <obj-attribute name="forFiscalYear" type="java.lang.String" db-attribute-path="for_fiscal_year"/>
- <obj-attribute name="forFiscalYearFootnote" type="java.lang.String" db-attribute-path="for_fiscal_year_footnote"/>
- <obj-attribute name="quantityPerAssembly" type="java.lang.Short" db-attribute-path="quantity_per_assembly"/>
- <obj-attribute name="quantityPerAssemblyFootnote" type="java.lang.String" db-attribute-path="quantity_per_assembly_footnote"/>
- <obj-attribute name="terminationLiabilityFootnote" type="java.lang.String" db-attribute-path="termination_liability_footnote"/>
- <obj-attribute name="title" type="java.lang.String" db-attribute-path="title"/>
- <obj-attribute name="titleFootnote" type="java.lang.String" db-attribute-path="title_footnote"/>
- <obj-attribute name="whenRequiredMonths" type="java.lang.Short" db-attribute-path="when_required_months"/>
- <obj-attribute name="whenRequiredMonthsFootnote" type="java.lang.String" db-attribute-path="when_required_months_footnote"/>
- </obj-entity>
- <obj-entity name="AdvanceProcurementCostElementCategory" className="org.example.analytic.model.AdvanceProcurementCostElementCategory" dbEntityName="p_advance_procurement_cost_element_categories" superClassName="org.example.analytic.model.AnalyticBase">
- <obj-attribute name="type" type="org.example.analytic.model.constants.AdvanceProcurementCostElementCategoryType" db-attribute-path="type"/>
- </obj-entity>
- <obj-entity name="AdvanceProcurementEOQCost" className="org.example.analytic.model.AdvanceProcurementEOQCost" dbEntityName="p_advance_procurement_eoq_costs" superClassName="org.example.analytic.model.AnalyticBase">
- <obj-attribute name="displayOrder" type="java.lang.Short" db-attribute-path="display_order"/>
- <obj-attribute name="forFiscalYear" type="java.lang.String" db-attribute-path="for_fiscal_year"/>
- <obj-attribute name="forFiscalYearFootnote" type="java.lang.String" db-attribute-path="for_fiscal_year_footnote"/>
- <obj-attribute name="quantity" type="java.math.BigDecimal" db-attribute-path="quantity"/>
- <obj-attribute name="quantityFootnote" type="java.lang.String" db-attribute-path="quantity_footnote"/>
- </obj-entity>
- <obj-entity name="Appropriation" className="org.example.analytic.model.Appropriation" dbEntityName="s_appropriations" superClassName="org.example.analytic.model.AnalyticBase">
- <obj-attribute name="code" type="java.lang.String" db-attribute-path="code"/>
- <obj-attribute name="title" type="java.lang.String" db-attribute-path="title"/>
- </obj-entity>
- <obj-entity name="BudgetActivity" className="org.example.analytic.model.BudgetActivity" dbEntityName="s_budget_activities" superClassName="org.example.analytic.model.AnalyticBase">
- <obj-attribute name="code" type="java.lang.String" db-attribute-path="code"/>
- <obj-attribute name="title" type="java.lang.String" db-attribute-path="title"/>
- </obj-entity>
- <obj-entity name="BudgetPeriod" className="org.example.analytic.model.BudgetPeriod" dbEntityName="s_budget_periods" superClassName="org.example.analytic.model.AnalyticBase">
- <obj-attribute name="cycle" type="org.example.analytic.model.constants.BudgetCycleType" db-attribute-path="cycle"/>
- <obj-attribute name="submissionDate" type="java.util.Date" db-attribute-path="submission_date"/>
- <obj-attribute name="suffix" type="java.lang.String" db-attribute-path="suffix"/>
- <obj-attribute name="year" type="java.lang.String" db-attribute-path="year"/>
- </obj-entity>
- <obj-entity name="BudgetQuarters" className="org.example.analytic.model.BudgetQuarters" dbEntityName="p_budget_quarters" superClassName="org.example.analytic.model.AnalyticBase">
- <obj-attribute name="APY" type="java.lang.Integer" db-attribute-path="pys"/>
- <obj-attribute name="APYFootnote" type="java.lang.String" db-attribute-path="pys_footnote"/>
- <obj-attribute name="BY1BaseQ1" type="java.lang.Integer" db-attribute-path="by1_base_q1"/>
- <obj-attribute name="BY1BaseQ1Footnote" type="java.lang.String" db-attribute-path="by1_base_q1_footnote"/>
- <obj-attribute name="BY1BaseQ2" type="java.lang.Integer" db-attribute-path="by1_base_q2"/>
- <obj-attribute name="BY1BaseQ2Footnote" type="java.lang.String" db-attribute-path="by1_base_q2_footnote"/>
- <obj-attribute name="BY1BaseQ3" type="java.lang.Integer" db-attribute-path="by1_base_q3"/>
- <obj-attribute name="BY1BaseQ3Footnote" type="java.lang.String" db-attribute-path="by1_base_q3_footnote"/>
- <obj-attribute name="BY1BaseQ4" type="java.lang.Integer" db-attribute-path="by1_base_q4"/>
- <obj-attribute name="BY1BaseQ4Footnote" type="java.lang.String" db-attribute-path="by1_base_q4_footnote"/>
- <obj-attribute name="BY1OCOQ1" type="java.lang.Integer" db-attribute-path="by1_oco_q1"/>
- <obj-attribute name="BY1OCOQ1Footnote" type="java.lang.String" db-attribute-path="by1_oco_q1_footnote"/>
- <obj-attribute name="BY1OCOQ2" type="java.lang.Integer" db-attribute-path="by1_oco_q2"/>
- <obj-attribute name="BY1OCOQ2Footnote" type="java.lang.String" db-attribute-path="by1_oco_q2_footnote"/>
- <obj-attribute name="BY1OCOQ3" type="java.lang.Integer" db-attribute-path="by1_oco_q3"/>
- <obj-attribute name="BY1OCOQ3Footnote" type="java.lang.String" db-attribute-path="by1_oco_q3_footnote"/>
- <obj-attribute name="BY1OCOQ4" type="java.lang.Integer" db-attribute-path="by1_oco_q4"/>
- <obj-attribute name="BY1OCOQ4Footnote" type="java.lang.String" db-attribute-path="by1_oco_q4_footnote"/>
- <obj-attribute name="BY1Q1" type="java.lang.Integer" db-attribute-path="by1_q1"/>
- <obj-attribute name="BY1Q1Footnote" type="java.lang.String" db-attribute-path="by1_q1_footnote"/>
- <obj-attribute name="BY1Q2" type="java.lang.Integer" db-attribute-path="by1_q2"/>
- <obj-attribute name="BY1Q2Footnote" type="java.lang.String" db-attribute-path="by1_q2_footnote"/>
- <obj-attribute name="BY1Q3" type="java.lang.Integer" db-attribute-path="by1_q3"/>
- <obj-attribute name="BY1Q3Footnote" type="java.lang.String" db-attribute-path="by1_q3_footnote"/>
- <obj-attribute name="BY1Q4" type="java.lang.Integer" db-attribute-path="by1_q4"/>
- <obj-attribute name="BY1Q4Footnote" type="java.lang.String" db-attribute-path="by1_q4_footnote"/>
- <obj-attribute name="BY2Q1" type="java.lang.Integer" db-attribute-path="by2_q1"/>
- <obj-attribute name="BY2Q1Footnote" type="java.lang.String" db-attribute-path="by2_q1_footnote"/>
- <obj-attribute name="BY2Q2" type="java.lang.Integer" db-attribute-path="by2_q2"/>
- <obj-attribute name="BY2Q2Footnote" type="java.lang.String" db-attribute-path="by2_q2_footnote"/>
- <obj-attribute name="BY2Q3" type="java.lang.Integer" db-attribute-path="by2_q3"/>
- <obj-attribute name="BY2Q3Footnote" type="java.lang.String" db-attribute-path="by2_q3_footnote"/>
- <obj-attribute name="BY2Q4" type="java.lang.Integer" db-attribute-path="by2_q4"/>
- <obj-attribute name="BY2Q4Footnote" type="java.lang.String" db-attribute-path="by2_q4_footnote"/>
- <obj-attribute name="BY3Q1" type="java.lang.Integer" db-attribute-path="by3_q1"/>
- <obj-attribute name="BY3Q1Footnote" type="java.lang.String" db-attribute-path="by3_q1_footnote"/>
- <obj-attribute name="BY3Q2" type="java.lang.Integer" db-attribute-path="by3_q2"/>
- <obj-attribute name="BY3Q2Footnote" type="java.lang.String" db-attribute-path="by3_q2_footnote"/>
- <obj-attribute name="BY3Q3" type="java.lang.Integer" db-attribute-path="by3_q3"/>
- <obj-attribute name="BY3Q3Footnote" type="java.lang.String" db-attribute-path="by3_q3_footnote"/>
- <obj-attribute name="BY3Q4" type="java.lang.Integer" db-attribute-path="by3_q4"/>
- <obj-attribute name="BY3Q4Footnote" type="java.lang.String" db-attribute-path="by3_q4_footnote"/>
- <obj-attribute name="BY4Q1" type="java.lang.Integer" db-attribute-path="by4_q1"/>
- <obj-attribute name="BY4Q1Footnote" type="java.lang.String" db-attribute-path="by4_q1_footnote"/>
- <obj-attribute name="BY4Q2" type="java.lang.Integer" db-attribute-path="by4_q2"/>
- <obj-attribute name="BY4Q2Footnote" type="java.lang.String" db-attribute-path="by4_q2_footnote"/>
- <obj-attribute name="BY4Q3" type="java.lang.Integer" db-attribute-path="by4_q3"/>
- <obj-attribute name="BY4Q3Footnote" type="java.lang.String" db-attribute-path="by4_q3_footnote"/>
- <obj-attribute name="BY4Q4" type="java.lang.Integer" db-attribute-path="by4_q4"/>
- <obj-attribute name="BY4Q4Footnote" type="java.lang.String" db-attribute-path="by4_q4_footnote"/>
- <obj-attribute name="BY5Q1" type="java.lang.Integer" db-attribute-path="by5_q1"/>
- <obj-attribute name="BY5Q1Footnote" type="java.lang.String" db-attribute-path="by5_q1_footnote"/>
- <obj-attribute name="BY5Q2" type="java.lang.Integer" db-attribute-path="by5_q2"/>
- <obj-attribute name="BY5Q2Footnote" type="java.lang.String" db-attribute-path="by5_q2_footnote"/>
- <obj-attribute name="BY5Q3" type="java.lang.Integer" db-attribute-path="by5_q3"/>
- <obj-attribute name="BY5Q3Footnote" type="java.lang.String" db-attribute-path="by5_q3_footnote"/>
- <obj-attribute name="BY5Q4" type="java.lang.Integer" db-attribute-path="by5_q4"/>
- <obj-attribute name="BY5Q4Footnote" type="java.lang.String" db-attribute-path="by5_q4_footnote"/>
- <obj-attribute name="CYQ1" type="java.lang.Integer" db-attribute-path="cy_q1"/>
- <obj-attribute name="CYQ1Footnote" type="java.lang.String" db-attribute-path="cy_q1_footnote"/>
- <obj-attribute name="CYQ2" type="java.lang.Integer" db-attribute-path="cy_q2"/>
- <obj-attribute name="CYQ2Footnote" type="java.lang.String" db-attribute-path="cy_q2_footnote"/>
- <obj-attribute name="CYQ3" type="java.lang.Integer" db-attribute-path="cy_q3"/>
- <obj-attribute name="CYQ3Footnote" type="java.lang.String" db-attribute-path="cy_q3_footnote"/>
- <obj-attribute name="CYQ4" type="java.lang.Integer" db-attribute-path="cy_q4"/>
- <obj-attribute name="CYQ4Footnote" type="java.lang.String" db-attribute-path="cy_q4_footnote"/>
- <obj-attribute name="PYQ1" type="java.lang.Integer" db-attribute-path="py_q1"/>
- <obj-attribute name="PYQ1Footnote" type="java.lang.String" db-attribute-path="py_q1_footnote"/>
- <obj-attribute name="PYQ2" type="java.lang.Integer" db-attribute-path="py_q2"/>
- <obj-attribute name="PYQ2Footnote" type="java.lang.String" db-attribute-path="py_q2_footnote"/>
- <obj-attribute name="PYQ3" type="java.lang.Integer" db-attribute-path="py_q3"/>
- <obj-attribute name="PYQ3Footnote" type="java.lang.String" db-attribute-path="py_q3_footnote"/>
- <obj-attribute name="PYQ4" type="java.lang.Integer" db-attribute-path="py_q4"/>
- <obj-attribute name="PYQ4Footnote" type="java.lang.String" db-attribute-path="py_q4_footnote"/>
- <obj-attribute name="continuing" type="java.lang.Boolean" db-attribute-path="continuing"/>
- <obj-attribute name="continuingFootnote" type="java.lang.String" db-attribute-path="continuing_footnote"/>
- <obj-attribute name="toComplete" type="java.lang.Integer" db-attribute-path="to_complete"/>
- <obj-attribute name="toCompleteFootnote" type="java.lang.String" db-attribute-path="to_complete_footnote"/>
- <obj-attribute name="totalCost" type="java.lang.Integer" db-attribute-path="total_cost"/>
- <obj-attribute name="totalCostFootnote" type="java.lang.String" db-attribute-path="total_cost_footnote"/>
- </obj-entity>
- <obj-entity name="BudgetSubActivity" className="org.example.analytic.model.BudgetSubActivity" dbEntityName="s_budget_sub_activities" superClassName="org.example.analytic.model.AnalyticBase">
- <obj-attribute name="code" type="java.lang.String" db-attribute-path="code"/>
- <obj-attribute name="title" type="java.lang.String" db-attribute-path="title"/>
- </obj-entity>
- <obj-entity name="BudgetYears" className="org.example.analytic.model.BudgetYears" dbEntityName="s_budget_years" superClassName="org.example.analytic.model.AnalyticBase">
- <obj-attribute name="APY" type="java.math.BigDecimal" db-attribute-path="pys"/>
- <obj-attribute name="APYFootnote" type="java.lang.String" db-attribute-path="pys_footnote"/>
- <obj-attribute name="BY1" type="java.math.BigDecimal" db-attribute-path="by1"/>
- <obj-attribute name="BY1Base" type="java.math.BigDecimal" db-attribute-path="by1_base"/>
- <obj-attribute name="BY1BaseFootnote" type="java.lang.String" db-attribute-path="by1_base_footnote"/>
- <obj-attribute name="BY1Footnote" type="java.lang.String" db-attribute-path="by1_footnote"/>
- <obj-attribute name="BY1OCO" type="java.math.BigDecimal" db-attribute-path="by1_oco"/>
- <obj-attribute name="BY1OCOFootnote" type="java.lang.String" db-attribute-path="by1_oco_footnote"/>
- <obj-attribute name="BY2" type="java.math.BigDecimal" db-attribute-path="by2"/>
- <obj-attribute name="BY2Footnote" type="java.lang.String" db-attribute-path="by2_footnote"/>
- <obj-attribute name="BY3" type="java.math.BigDecimal" db-attribute-path="by3"/>
- <obj-attribute name="BY3Footnote" type="java.lang.String" db-attribute-path="by3_footnote"/>
- <obj-attribute name="BY4" type="java.math.BigDecimal" db-attribute-path="by4"/>
- <obj-attribute name="BY4Footnote" type="java.lang.String" db-attribute-path="by4_footnote"/>
- <obj-attribute name="BY5" type="java.math.BigDecimal" db-attribute-path="by5"/>
- <obj-attribute name="BY5Footnote" type="java.lang.String" db-attribute-path="by5_footnote"/>
- <obj-attribute name="CY" type="java.math.BigDecimal" db-attribute-path="cy"/>
- <obj-attribute name="CYFootnote" type="java.lang.String" db-attribute-path="cy_footnote"/>
- <obj-attribute name="PY" type="java.math.BigDecimal" db-attribute-path="py"/>
- <obj-attribute name="PYFootnote" type="java.lang.String" db-attribute-path="py_footnote"/>
- <obj-attribute name="continuing" type="java.lang.Boolean" db-attribute-path="continuing"/>
- <obj-attribute name="continuingFootnote" type="java.lang.String" db-attribute-path="continuing_footnote"/>
- <obj-attribute name="toComplete" type="java.math.BigDecimal" db-attribute-path="to_complete"/>
- <obj-attribute name="toCompleteFootnote" type="java.lang.String" db-attribute-path="to_complete_footnote"/>
- <obj-attribute name="total" type="java.math.BigDecimal" db-attribute-path="total"/>
- <obj-attribute name="totalFootnote" type="java.lang.String" db-attribute-path="total_footnote"/>
- <obj-attribute name="type" type="org.example.analytic.model.constants.BudgetYearsType" db-attribute-path="type"/>
- </obj-entity>
- <obj-entity name="CongressionalAddDetail" className="org.example.analytic.model.CongressionalAddDetail" dbEntityName="r_congressional_add_details" superClassName="org.example.analytic.model.AnalyticBase">
- <obj-attribute name="CY" type="java.math.BigDecimal" db-attribute-path="cy"/>
- <obj-attribute name="CYText" type="java.lang.String" db-attribute-path="cy_text"/>
- <obj-attribute name="PY" type="java.math.BigDecimal" db-attribute-path="py"/>
- <obj-attribute name="PYText" type="java.lang.String" db-attribute-path="py_text"/>
- <obj-attribute name="displayOrder" type="java.lang.Short" db-attribute-path="display_order"/>
- <obj-attribute name="title" type="java.lang.String" db-attribute-path="title"/>
- </obj-entity>
- <obj-entity name="ContractDesignation" className="org.example.analytic.model.ContractDesignation" dbEntityName="s_contract_designations" superClassName="org.example.analytic.model.AnalyticBase">
- <obj-attribute name="contractMethod" type="org.example.analytic.model.constants.ContractMethodType" db-attribute-path="contract_method"/>
- <obj-attribute name="contractType" type="org.example.an
<TRUNCATED>
[2/5] cayenne-modeler git commit: Moved sample model file to test
resources.
Posted by mg...@apache.org.
http://git-wip-us.apache.org/repos/asf/cayenne-modeler/blob/8a569dbc/src/test/resources/analytic.map.xml
----------------------------------------------------------------------
diff --git a/src/test/resources/analytic.map.xml b/src/test/resources/analytic.map.xml
new file mode 100644
index 0000000..4fc0ba9
--- /dev/null
+++ b/src/test/resources/analytic.map.xml
@@ -0,0 +1,2608 @@
+<?xml version="1.0" encoding="utf-8"?>
+<data-map xmlns="http://cayenne.apache.org/schema/9/modelMap"
+ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:schemaLocation="http://cayenne.apache.org/schema/9/modelMap http://cayenne.apache.org/schema/9/modelMap.xsd"
+ project-version="9">
+ <property name="defaultPackage" value="org.example.analytic.model"/>
+ <property name="defaultSuperclass" value="org.example.analytic.model.AnalyticBase"/>
+ <db-entity name="p_advance_procurement_cost_element_categories" catalog="cxe">
+ <db-attribute name="advance_procurement_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
+ <db-attribute name="type" type="VARCHAR" isMandatory="true" length="10"/>
+ </db-entity>
+ <db-entity name="p_advance_procurement_cost_elements" catalog="cxe">
+ <db-attribute name="advance_procurement_cost_element_category_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="for_fiscal_year" type="VARCHAR" length="4"/>
+ <db-attribute name="for_fiscal_year_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="quantity_per_assembly" type="SMALLINT" length="5"/>
+ <db-attribute name="quantity_per_assembly_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="termination_liability_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="termination_liability_total_cost_fk" type="BIGINT" length="10"/>
+ <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="title_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
+ <db-attribute name="when_required_months" type="SMALLINT" length="5"/>
+ <db-attribute name="when_required_months_footnote" type="LONGVARCHAR" length="65535"/>
+ </db-entity>
+ <db-entity name="p_advance_procurement_eoq_costs" catalog="cxe">
+ <db-attribute name="advance_procurement_cost_element_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="for_fiscal_year" type="VARCHAR" length="4"/>
+ <db-attribute name="for_fiscal_year_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="quantity" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="quantity_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
+ </db-entity>
+ <db-entity name="p_advance_procurements" catalog="cxe">
+ <db-attribute name="description" type="LONGVARCHAR" length="16777215"/>
+ <db-attribute name="first_system_award_month_and_year" type="DATE" length="10"/>
+ <db-attribute name="first_system_award_month_and_year_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="first_system_completion_month_and_year" type="DATE" length="10"/>
+ <db-attribute name="first_system_completion_month_and_year_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="id_code" type="CHAR" length="2"/>
+ <db-attribute name="mdap_codes" type="VARCHAR" length="100"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="production_lead_time_months" type="SMALLINT" length="5"/>
+ <db-attribute name="production_lead_time_months_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="system_interval_months" type="SMALLINT" length="5"/>
+ <db-attribute name="system_interval_months_footnote" type="LONGVARCHAR" length="65535"/>
+ </db-entity>
+ <db-entity name="p_budget_quarters" catalog="cxe">
+ <db-attribute name="by1_base_q1" type="INTEGER" length="7"/>
+ <db-attribute name="by1_base_q1_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by1_base_q2" type="INTEGER" length="7"/>
+ <db-attribute name="by1_base_q2_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by1_base_q3" type="INTEGER" length="7"/>
+ <db-attribute name="by1_base_q3_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by1_base_q4" type="INTEGER" length="7"/>
+ <db-attribute name="by1_base_q4_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by1_oco_q1" type="INTEGER" length="7"/>
+ <db-attribute name="by1_oco_q1_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by1_oco_q2" type="INTEGER" length="7"/>
+ <db-attribute name="by1_oco_q2_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by1_oco_q3" type="INTEGER" length="7"/>
+ <db-attribute name="by1_oco_q3_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by1_oco_q4" type="INTEGER" length="7"/>
+ <db-attribute name="by1_oco_q4_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by1_q1" type="INTEGER" length="7"/>
+ <db-attribute name="by1_q1_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by1_q2" type="INTEGER" length="7"/>
+ <db-attribute name="by1_q2_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by1_q3" type="INTEGER" length="7"/>
+ <db-attribute name="by1_q3_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by1_q4" type="INTEGER" length="7"/>
+ <db-attribute name="by1_q4_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by2_q1" type="INTEGER" length="7"/>
+ <db-attribute name="by2_q1_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by2_q2" type="INTEGER" length="7"/>
+ <db-attribute name="by2_q2_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by2_q3" type="INTEGER" length="7"/>
+ <db-attribute name="by2_q3_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by2_q4" type="INTEGER" length="7"/>
+ <db-attribute name="by2_q4_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by3_q1" type="INTEGER" length="7"/>
+ <db-attribute name="by3_q1_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by3_q2" type="INTEGER" length="7"/>
+ <db-attribute name="by3_q2_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by3_q3" type="INTEGER" length="7"/>
+ <db-attribute name="by3_q3_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by3_q4" type="INTEGER" length="7"/>
+ <db-attribute name="by3_q4_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by4_q1" type="INTEGER" length="7"/>
+ <db-attribute name="by4_q1_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by4_q2" type="INTEGER" length="7"/>
+ <db-attribute name="by4_q2_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by4_q3" type="INTEGER" length="7"/>
+ <db-attribute name="by4_q3_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by4_q4" type="INTEGER" length="7"/>
+ <db-attribute name="by4_q4_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by5_q1" type="INTEGER" length="7"/>
+ <db-attribute name="by5_q1_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by5_q2" type="INTEGER" length="7"/>
+ <db-attribute name="by5_q2_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by5_q3" type="INTEGER" length="7"/>
+ <db-attribute name="by5_q3_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by5_q4" type="INTEGER" length="7"/>
+ <db-attribute name="by5_q4_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="continuing" type="BIT"/>
+ <db-attribute name="continuing_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="cy_q1" type="INTEGER" length="7"/>
+ <db-attribute name="cy_q1_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="cy_q2" type="INTEGER" length="7"/>
+ <db-attribute name="cy_q2_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="cy_q3" type="INTEGER" length="7"/>
+ <db-attribute name="cy_q3_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="cy_q4" type="INTEGER" length="7"/>
+ <db-attribute name="cy_q4_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="py_q1" type="INTEGER" length="7"/>
+ <db-attribute name="py_q1_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="py_q2" type="INTEGER" length="7"/>
+ <db-attribute name="py_q2_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="py_q3" type="INTEGER" length="7"/>
+ <db-attribute name="py_q3_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="py_q4" type="INTEGER" length="7"/>
+ <db-attribute name="py_q4_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="pys" type="INTEGER" length="7"/>
+ <db-attribute name="pys_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="to_complete" type="INTEGER" length="7"/>
+ <db-attribute name="to_complete_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="total_cost" type="INTEGER" length="7"/>
+ <db-attribute name="total_cost_footnote" type="LONGVARCHAR" length="65535"/>
+ </db-entity>
+ <db-entity name="p_cost_element_categories" catalog="cxe">
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="item_fk" type="BIGINT" length="10"/>
+ <db-attribute name="modification_group_fk" type="BIGINT" length="10"/>
+ <db-attribute name="modification_item_fk" type="BIGINT" length="10"/>
+ <db-attribute name="name" type="VARCHAR" length="255"/>
+ <db-attribute name="name_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="quantity_fk" type="BIGINT" length="10"/>
+ <db-attribute name="secondary_distribution_remarks" type="LONGVARCHAR" length="16777215"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
+ <db-attribute name="type" type="VARCHAR" isMandatory="true" length="20"/>
+ </db-entity>
+ <db-entity name="p_cost_element_sub_categories" catalog="cxe">
+ <db-attribute name="cost_element_category_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="quantity_fk" type="BIGINT" length="10"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
+ <db-attribute name="type" type="VARCHAR" isMandatory="true" length="20"/>
+ </db-entity>
+ <db-entity name="p_cost_elements" catalog="cxe">
+ <db-attribute name="all_pys_deliveries" type="DECIMAL" length="15" scale="3"/>
+ <db-attribute name="all_pys_deliveries_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="category_supply_name" type="VARCHAR" length="50"/>
+ <db-attribute name="contracted" type="BIT" isMandatory="true"/>
+ <db-attribute name="cost_element_category_fk" type="BIGINT" length="10"/>
+ <db-attribute name="cost_element_sub_category_fk" type="BIGINT" length="10"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="id_code" type="CHAR" length="2"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="quantity_fk" type="BIGINT" length="10"/>
+ <db-attribute name="remarks" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
+ <db-attribute name="unit_cost_fk" type="BIGINT" length="10"/>
+ </db-entity>
+ <db-entity name="p_delivery_schedules" catalog="cxe">
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="history_planning_fk" type="BIGINT" length="10"/>
+ <db-attribute name="history_planning_for_total_fk" type="BIGINT" length="10"/>
+ <db-attribute name="organization_fk" type="BIGINT" length="10"/>
+ <db-attribute name="organization_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="organization_suffix" type="VARCHAR" length="100"/>
+ <db-attribute name="organization_suffix_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="organizational_unit_fk" type="BIGINT" length="10"/>
+ <db-attribute name="organizational_unit_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="total_quantity" type="DECIMAL" length="15" scale="3"/>
+ <db-attribute name="total_quantity_footnote" type="LONGVARCHAR" length="65535"/>
+ </db-entity>
+ <db-entity name="p_facilities">
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="facility_project_type" type="CHAR" isMandatory="true" length="20"/>
+ <db-attribute name="facility_type" type="CHAR" isMandatory="true" length="4"/>
+ <db-attribute name="line_item_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="location" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="name" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ </db-entity>
+ <db-entity name="p_histories_and_plannings" catalog="cxe">
+ <db-attribute name="award_date" type="DATE" isMandatory="true" length="10"/>
+ <db-attribute name="award_date_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="contract_designation_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="first_delivery_date" type="DATE" length="10"/>
+ <db-attribute name="first_delivery_date_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="fiscal_year" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="fiscal_year_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="is_oco" type="BIT"/>
+ <db-attribute name="is_oco_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="manufacturer_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="pco_location" type="VARCHAR" length="100"/>
+ <db-attribute name="pco_location_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="quantity" type="DECIMAL" isMandatory="true" length="15" scale="3"/>
+ <db-attribute name="quantity_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="revisions_available_date" type="DATE" length="10"/>
+ <db-attribute name="revisions_available_date_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="rfp_issue_date" type="DATE" length="10"/>
+ <db-attribute name="rfp_issue_date_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="specs_available_now" type="BIT"/>
+ <db-attribute name="specs_available_now_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="suffix" type="VARCHAR" length="25"/>
+ <db-attribute name="suffix_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="unit_cost" type="DECIMAL" isMandatory="true" length="15" scale="3"/>
+ <db-attribute name="unit_cost_footnote" type="LONGVARCHAR" length="65535"/>
+ </db-entity>
+ <db-entity name="p_inactive_industrial_facility_project_fundings">
+ <db-attribute name="inactive_industrial_facility_project_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="type" type="CHAR" isMandatory="true" length="16"/>
+ </db-entity>
+ <db-entity name="p_inactive_industrial_facility_projects">
+ <db-attribute name="category" type="VARCHAR" length="75"/>
+ <db-attribute name="contractor" type="VARCHAR" length="125"/>
+ <db-attribute name="description" type="LONGVARCHAR" length="16777215"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="facility_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" isMandatory="true" length="10"/>
+ </db-entity>
+ <db-entity name="p_item_categories" catalog="cxe">
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="item_group_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="title" type="VARCHAR" length="255"/>
+ <db-attribute name="title_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
+ </db-entity>
+ <db-entity name="p_item_groups" catalog="cxe">
+ <db-attribute name="exhibit_display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="is_modification_item" type="BIT" isMandatory="true"/>
+ <db-attribute name="p21_remarks" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="p5a_remarks" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="quantity_fk" type="BIGINT" length="10"/>
+ <db-attribute name="remarks" type="LONGVARCHAR" length="16777215"/>
+ <db-attribute name="title" type="VARCHAR" length="255"/>
+ <db-attribute name="title_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
+ <db-attribute name="unit_cost_fk" type="BIGINT" length="10"/>
+ </db-entity>
+ <db-entity name="p_items" catalog="cxe">
+ <db-attribute name="advance_procurement_fk" type="BIGINT" length="10"/>
+ <db-attribute name="all_pys_deliveries" type="DECIMAL" length="15" scale="3"/>
+ <db-attribute name="all_pys_deliveries_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="dodic" type="VARCHAR" length="5"/>
+ <db-attribute name="exhibit_display_order" type="SMALLINT" length="5"/>
+ <db-attribute name="id_code" type="CHAR" length="2"/>
+ <db-attribute name="include_in_pdf" type="BIT" isMandatory="true"/>
+ <db-attribute name="item_category_fk" type="BIGINT" length="10"/>
+ <db-attribute name="line_item_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="mdap_code" type="VARCHAR" length="4"/>
+ <db-attribute name="mdap_code_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="modification_type" type="VARCHAR" length="255"/>
+ <db-attribute name="modification_type_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="number" type="VARCHAR" length="25"/>
+ <db-attribute name="number_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="p21_remarks" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="p5a_remarks" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="pys_quantity_delta" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="pys_total_cost_delta" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="remarks" type="LONGVARCHAR" length="16777215"/>
+ <db-attribute name="secondary_distribution_remarks" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="title_footnote" type="LONGVARCHAR" length="65535"/>
+ </db-entity>
+ <db-entity name="p_layaway_distribution_projects">
+ <db-attribute name="annual_maintenance_cost" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="category" type="VARCHAR" length="255"/>
+ <db-attribute name="code" type="VARCHAR" isMandatory="true" length="25"/>
+ <db-attribute name="description" type="LONGVARCHAR" length="16777215"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="facility_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="layaway_cost" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="other_costs" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="production_ends" type="VARCHAR" length="75"/>
+ <db-attribute name="production_lines_laid_away_location" type="VARCHAR" length="255"/>
+ <db-attribute name="production_lines_laid_away_name" type="VARCHAR" length="255"/>
+ <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" isMandatory="true" length="10"/>
+ </db-entity>
+ <db-entity name="p_line_items" catalog="cxe">
+ <db-attribute name="advance_procurement_description" type="LONGVARCHAR" length="16777215"/>
+ <db-attribute name="advance_procurement_justification" type="LONGVARCHAR" length="16777215"/>
+ <db-attribute name="advance_procurement_p1_line_number" type="VARCHAR" length="10"/>
+ <db-attribute name="ap_only_flag" type="BIT"/>
+ <db-attribute name="combined_p5_flag" type="BIT"/>
+ <db-attribute name="delta_quantity_fk" type="BIGINT" length="10"/>
+ <db-attribute name="delta_total_cost_fk" type="BIGINT" length="10"/>
+ <db-attribute name="description" type="LONGVARCHAR" length="16777215"/>
+ <db-attribute name="funding_designation_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="id_code" type="CHAR" length="2"/>
+ <db-attribute name="line_item_number" type="VARCHAR" isMandatory="true" length="25"/>
+ <db-attribute name="line_item_title" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="mdap_codes" type="VARCHAR" length="100"/>
+ <db-attribute name="mdap_codes_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="myp1_count" type="SMALLINT" length="5"/>
+ <db-attribute name="myp2_count" type="SMALLINT" length="5"/>
+ <db-attribute name="myp3_count" type="SMALLINT" length="5"/>
+ <db-attribute name="myp4_count" type="SMALLINT" length="5"/>
+ <db-attribute name="p10_count" type="SMALLINT" length="5"/>
+ <db-attribute name="p17_count" type="SMALLINT" length="5"/>
+ <db-attribute name="p18_count" type="SMALLINT" length="5"/>
+ <db-attribute name="p1_count" type="SMALLINT" length="5"/>
+ <db-attribute name="p1_line_number" type="VARCHAR" length="10"/>
+ <db-attribute name="p20_count" type="SMALLINT" length="5"/>
+ <db-attribute name="p21_count" type="SMALLINT" length="5"/>
+ <db-attribute name="p23_count" type="SMALLINT" length="5"/>
+ <db-attribute name="p25_count" type="SMALLINT" length="5"/>
+ <db-attribute name="p26_count" type="SMALLINT" length="5"/>
+ <db-attribute name="p3a_count" type="SMALLINT" length="5"/>
+ <db-attribute name="p40a_count" type="SMALLINT" length="5"/>
+ <db-attribute name="p40a_item_schedule_flag" type="CHAR" isMandatory="true" length="28"/>
+ <db-attribute name="p5_count" type="SMALLINT" length="5"/>
+ <db-attribute name="p5a_count" type="SMALLINT" length="5"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="production_rate_interval" type="CHAR" isMandatory="true" length="9"/>
+ <db-attribute name="pys_quantity_delta" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="pys_total_cost_delta" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="quantity_unit_format" type="CHAR" length="5"/>
+ <db-attribute name="remarks" type="LONGVARCHAR" length="16777215"/>
+ <db-attribute name="secondary_distribution_remarks" type="LONGVARCHAR" length="16777215"/>
+ <db-attribute name="secondary_distribution_subtotal_quantity_fk" type="BIGINT" length="10"/>
+ <db-attribute name="secondary_distribution_subtotal_total_cost_fk" type="BIGINT" length="10"/>
+ <db-attribute name="total_cost_format" type="CHAR" isMandatory="true" length="9"/>
+ <db-attribute name="unit_cost_format" type="CHAR" isMandatory="true" length="9"/>
+ <db-attribute name="unit_quantity_format" type="CHAR" isMandatory="true" length="9"/>
+ </db-entity>
+ <db-entity name="p_manufacturers" catalog="cxe">
+ <db-attribute name="admin_lead_time_after_oct1_initial_months" type="SMALLINT" length="5"/>
+ <db-attribute name="admin_lead_time_after_oct1_initial_months_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="admin_lead_time_after_oct1_reorder_months" type="SMALLINT" length="5"/>
+ <db-attribute name="admin_lead_time_after_oct1_reorder_months_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="admin_lead_time_prior_oct1_initial_months" type="SMALLINT" length="5"/>
+ <db-attribute name="admin_lead_time_prior_oct1_initial_months_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="admin_lead_time_prior_oct1_reorder_months" type="SMALLINT" length="5"/>
+ <db-attribute name="admin_lead_time_prior_oct1_reorder_months_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="advance_procurement_cost_element_fk" type="BIGINT" length="10"/>
+ <db-attribute name="contract_location" type="VARCHAR" isMandatory="true" length="125"/>
+ <db-attribute name="contract_location_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="contractor" type="VARCHAR" isMandatory="true" length="125"/>
+ <db-attribute name="contractor_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="cost_element_fk" type="BIGINT" length="10"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="item_fk" type="BIGINT" length="10"/>
+ <db-attribute name="maximum_production_rate" type="DECIMAL" length="14" scale="2"/>
+ <db-attribute name="maximum_production_rate_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="minimum_sustaining_rate" type="DECIMAL" length="14" scale="2"/>
+ <db-attribute name="minimum_sustaining_rate_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="one_eight_five" type="DECIMAL" length="14" scale="2"/>
+ <db-attribute name="one_eight_five_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="production_lead_time_initial_months" type="SMALLINT" length="5"/>
+ <db-attribute name="production_lead_time_initial_months_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="production_lead_time_reorder_months" type="SMALLINT" length="5"/>
+ <db-attribute name="production_lead_time_reorder_months_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="total_lead_time_initial_months" type="SMALLINT" length="5"/>
+ <db-attribute name="total_lead_time_initial_months_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="total_lead_time_reorder_months" type="SMALLINT" length="5"/>
+ <db-attribute name="total_lead_time_reorder_months_footnote" type="LONGVARCHAR" length="65535"/>
+ </db-entity>
+ <db-entity name="p_models_affected">
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="item_fk" type="BIGINT" length="10"/>
+ <db-attribute name="modification_group_fk" type="BIGINT" length="10"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="title_footnote" type="LONGVARCHAR" length="65535"/>
+ </db-entity>
+ <db-entity name="p_modification_groups" catalog="cxe">
+ <db-attribute name="advance_procurement_fk" type="BIGINT" length="10"/>
+ <db-attribute name="description" type="LONGVARCHAR" isMandatory="true" length="16777215"/>
+ <db-attribute name="exhibit_display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="installation_quantity_subtotal_fk" type="BIGINT" length="10"/>
+ <db-attribute name="installation_total_cost_subtotal_fk" type="BIGINT" length="10"/>
+ <db-attribute name="line_item_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="mdap_code" type="VARCHAR" length="4"/>
+ <db-attribute name="mdap_code_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="models" type="VARCHAR" length="255"/>
+ <db-attribute name="models_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="modification_number" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="modification_number_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="procurement_quantity_subtotal_fk" type="BIGINT" length="10"/>
+ <db-attribute name="procurement_total_cost_subtotal_fk" type="BIGINT" length="10"/>
+ <db-attribute name="pys_quantity_delta" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="pys_total_cost_delta" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="secondary_distribution_remarks" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="support_secondary_distribution_remarks" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="title_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="type" type="VARCHAR" length="255"/>
+ <db-attribute name="type_footnote" type="LONGVARCHAR" length="65535"/>
+ </db-entity>
+ <db-entity name="p_modification_item_implementation_methods" catalog="cxe">
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="install_name" type="VARCHAR" length="100"/>
+ <db-attribute name="install_name_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="modification_item_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="name" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="name_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="quantity" type="BIGINT" length="10"/>
+ <db-attribute name="quantity_footnote" type="LONGVARCHAR" length="65535"/>
+ </db-entity>
+ <db-entity name="p_modification_item_installation_costs" catalog="cxe">
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="fiscal_year" type="CHAR" isMandatory="true" length="5"/>
+ <db-attribute name="modification_item_implementation_method_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="quantity_fk" type="BIGINT" length="10"/>
+ <db-attribute name="secondary_distribution_remarks" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
+ </db-entity>
+ <db-entity name="p_modification_item_installation_ins_outs" catalog="cxe">
+ <db-attribute name="budget_quarters_fk" type="BIGINT" length="10"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="modification_item_implementation_method_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="type" type="CHAR" isMandatory="true" length="2"/>
+ </db-entity>
+ <db-entity name="p_modification_item_manufacturers" catalog="cxe">
+ <db-attribute name="admin_lead_time_months" type="SMALLINT" length="5"/>
+ <db-attribute name="admin_lead_time_months_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="award_date_by1" type="TIMESTAMP" length="19"/>
+ <db-attribute name="award_date_by1_base" type="TIMESTAMP" length="19"/>
+ <db-attribute name="award_date_by1_base_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="award_date_by1_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="award_date_by1_oco" type="TIMESTAMP" length="19"/>
+ <db-attribute name="award_date_by1_oco_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="award_date_by2" type="TIMESTAMP" length="19"/>
+ <db-attribute name="award_date_by2_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="award_date_by3" type="TIMESTAMP" length="19"/>
+ <db-attribute name="award_date_by3_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="award_date_by4" type="TIMESTAMP" length="19"/>
+ <db-attribute name="award_date_by4_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="award_date_by5" type="TIMESTAMP" length="19"/>
+ <db-attribute name="award_date_by5_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="award_date_cy" type="TIMESTAMP" length="19"/>
+ <db-attribute name="award_date_cy_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="award_date_py" type="TIMESTAMP" length="19"/>
+ <db-attribute name="award_date_py_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="delivery_date_by1" type="TIMESTAMP" length="19"/>
+ <db-attribute name="delivery_date_by1_base" type="TIMESTAMP" length="19"/>
+ <db-attribute name="delivery_date_by1_base_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="delivery_date_by1_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="delivery_date_by1_oco" type="TIMESTAMP" length="19"/>
+ <db-attribute name="delivery_date_by1_oco_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="delivery_date_by2" type="TIMESTAMP" length="19"/>
+ <db-attribute name="delivery_date_by2_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="delivery_date_by3" type="TIMESTAMP" length="19"/>
+ <db-attribute name="delivery_date_by3_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="delivery_date_by4" type="TIMESTAMP" length="19"/>
+ <db-attribute name="delivery_date_by4_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="delivery_date_by5" type="TIMESTAMP" length="19"/>
+ <db-attribute name="delivery_date_by5_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="delivery_date_cy" type="TIMESTAMP" length="19"/>
+ <db-attribute name="delivery_date_cy_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="delivery_date_py" type="TIMESTAMP" length="19"/>
+ <db-attribute name="delivery_date_py_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="location" type="VARCHAR" isMandatory="true" length="125"/>
+ <db-attribute name="location_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="modification_item_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="name" type="VARCHAR" isMandatory="true" length="125"/>
+ <db-attribute name="name_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="production_lead_time_months" type="SMALLINT" length="5"/>
+ <db-attribute name="production_lead_time_months_footnote" type="LONGVARCHAR" length="65535"/>
+ </db-entity>
+ <db-entity name="p_modification_items" catalog="cxe">
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="installation_subtotal_quantity_fk" type="BIGINT" length="10"/>
+ <db-attribute name="installation_subtotal_total_cost_fk" type="BIGINT" length="10"/>
+ <db-attribute name="mdap_code" type="VARCHAR" length="4"/>
+ <db-attribute name="mdap_code_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="modification_group_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="procurement_subtotal_quantity_fk" type="BIGINT" length="10"/>
+ <db-attribute name="procurement_subtotal_total_cost_fk" type="BIGINT" length="10"/>
+ <db-attribute name="remarks" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="secondary_distribution_remarks" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
+ </db-entity>
+ <db-entity name="p_modification_milestones">
+ <db-attribute name="description" type="VARCHAR" length="1000"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="milestone" type="DATE" isMandatory="true"/>
+ <db-attribute name="milestone_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="modification_group_fk" type="BIGINT" isMandatory="true"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true"/>
+ <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="title_footnote" type="LONGVARCHAR" length="65535"/>
+ </db-entity>
+ <db-entity name="p_monthly_deliveries" catalog="cxe">
+ <db-attribute name="delivery_schedule_fk" type="BIGINT" length="10"/>
+ <db-attribute name="month_and_year" type="DATE" isMandatory="true" length="10"/>
+ <db-attribute name="month_and_year_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="quantity" type="DECIMAL" length="15" scale="3"/>
+ <db-attribute name="quantity_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="secondary_distribution_delivery_schedule_fk" type="BIGINT" length="10"/>
+ </db-entity>
+ <db-entity name="p_organizational_units" catalog="cxe">
+ <db-attribute name="code" type="VARCHAR" isMandatory="true" length="15"/>
+ <db-attribute name="description" type="VARCHAR" length="100"/>
+ <db-attribute name="name" type="VARCHAR" isMandatory="true" length="50"/>
+ <db-attribute name="organization_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ </db-entity>
+ <db-entity name="p_production_support_facility_project_cost_element_items">
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="production_support_facility_project_cost_element_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="title" type="VARCHAR" isMandatory="true" length="75"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" isMandatory="true" length="10"/>
+ </db-entity>
+ <db-entity name="p_production_support_facility_project_cost_elements">
+ <db-attribute name="note" type="VARCHAR" length="1000"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="production_support_facility_project_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="type" type="CHAR" isMandatory="true" length="32"/>
+ </db-entity>
+ <db-entity name="p_production_support_facility_project_milestones">
+ <db-attribute name="comment" type="VARCHAR" length="25"/>
+ <db-attribute name="month_and_year" type="DATE"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="production_support_facility_project_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="type" type="CHAR" isMandatory="true" length="32"/>
+ </db-entity>
+ <db-entity name="p_production_support_facility_project_related_projects">
+ <db-attribute name="appropriation_code" type="VARCHAR" length="100"/>
+ <db-attribute name="code" type="VARCHAR" isMandatory="true" length="25"/>
+ <db-attribute name="completion_date" type="DATE"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="facing" type="VARCHAR" length="25"/>
+ <db-attribute name="fiscal_year" type="SMALLINT" isMandatory="true"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="production_support_facility_project_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="start_date" type="DATE"/>
+ <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="value" type="DECIMAL" isMandatory="true" length="13" scale="3"/>
+ </db-entity>
+ <db-entity name="p_production_support_facility_projects">
+ <db-attribute name="capacity_after" type="VARCHAR" length="10"/>
+ <db-attribute name="capacity_before" type="VARCHAR" length="10"/>
+ <db-attribute name="category" type="VARCHAR" length="255"/>
+ <db-attribute name="code" type="VARCHAR" isMandatory="true" length="25"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="end_item" type="VARCHAR" length="255"/>
+ <db-attribute name="facility_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="narrative" type="LONGVARCHAR" length="16777215"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" isMandatory="true" length="10"/>
+ </db-entity>
+ <db-entity name="p_related_program_elements" catalog="cxe">
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="line_item_fk" type="BIGINT" length="10"/>
+ <db-attribute name="modification_group_fk" type="BIGINT" length="10"/>
+ <db-attribute name="modification_item_fk" type="BIGINT" length="10"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="program_element_number" type="VARCHAR" length="10"/>
+ <db-attribute name="program_element_number_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="quantity_fk" type="BIGINT" length="10"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
+ <db-attribute name="type" type="CHAR" isMandatory="true" length="1"/>
+ </db-entity>
+ <db-entity name="p_resource_summaries" catalog="cxe">
+ <db-attribute name="budget_years_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="id_code" type="CHAR" length="2"/>
+ <db-attribute name="item_fk" type="BIGINT" length="10"/>
+ <db-attribute name="line_item_fk" type="BIGINT" length="10"/>
+ <db-attribute name="modification_group_fk" type="BIGINT" length="10"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="title" type="VARCHAR" length="255"/>
+ <db-attribute name="title_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="type" type="VARCHAR" isMandatory="true" length="16"/>
+ </db-entity>
+ <db-entity name="p_secondary_distribution_delivery_schedules" catalog="cxe">
+ <db-attribute name="delivery_schedule_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="organization_fk" type="BIGINT" length="10"/>
+ <db-attribute name="organization_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="organization_suffix" type="VARCHAR" length="100"/>
+ <db-attribute name="organization_suffix_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="organizational_unit_fk" type="BIGINT" length="10"/>
+ <db-attribute name="organizational_unit_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="procurement_quantity" type="DECIMAL" length="15" scale="3"/>
+ <db-attribute name="procurement_quantity_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="remarks" type="LONGVARCHAR" length="65535"/>
+ </db-entity>
+ <db-entity name="p_secondary_distributions" catalog="cxe">
+ <db-attribute name="cost_element_category_fk" type="BIGINT" length="10"/>
+ <db-attribute name="delta_out_years_quantity_fk" type="BIGINT" length="10"/>
+ <db-attribute name="delta_out_years_total_cost_fk" type="BIGINT" length="10"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="item_fk" type="BIGINT" length="10"/>
+ <db-attribute name="line_item_fk" type="BIGINT" length="10"/>
+ <db-attribute name="modification_group_fk" type="BIGINT" length="10"/>
+ <db-attribute name="modification_item_fk" type="BIGINT" length="10"/>
+ <db-attribute name="modification_item_installation_cost_fk" type="BIGINT" length="10"/>
+ <db-attribute name="organization_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="organization_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="organization_suffix" type="VARCHAR" length="100"/>
+ <db-attribute name="organization_suffix_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="organizational_unit_fk" type="BIGINT" length="10"/>
+ <db-attribute name="organizational_unit_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="quantity_fk" type="BIGINT" length="10"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
+ </db-entity>
+ <db-entity name="p_spare_parts_budget_activities" catalog="cxe">
+ <db-attribute name="budget_activity_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="spare_parts_category_fk" type="BIGINT" isMandatory="true" length="10"/>
+ </db-entity>
+ <db-entity name="p_spare_parts_categories" catalog="cxe">
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="spare_parts_group_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
+ <db-attribute name="type" type="VARCHAR" isMandatory="true" length="20"/>
+ </db-entity>
+ <db-entity name="p_spare_parts_groups" catalog="cxe">
+ <db-attribute name="exempt_spares_total_cost_fk" type="BIGINT" length="10"/>
+ <db-attribute name="exhibit_display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="name" type="VARCHAR" length="255"/>
+ <db-attribute name="name_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="pys_delta" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="remarks" type="LONGVARCHAR" length="16777215"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
+ <db-attribute name="wcf_total_cost_fk" type="BIGINT" length="10"/>
+ </db-entity>
+ <db-entity name="p_spare_parts_items" catalog="cxe">
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="line_item_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="line_item_number" type="VARCHAR" length="25"/>
+ <db-attribute name="line_item_title" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="mdap_code" type="VARCHAR" length="4"/>
+ <db-attribute name="mdap_code_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="remarks" type="LONGVARCHAR" length="16777215"/>
+ <db-attribute name="spare_parts_budget_activity_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
+ </db-entity>
+ <db-entity name="p_sub_cost_elements" catalog="cxe">
+ <db-attribute name="budget_quarters_fk" type="BIGINT" length="10"/>
+ <db-attribute name="cost_element_fk" type="BIGINT" length="10"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="id_code" type="CHAR" length="2"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="quantity_fk" type="BIGINT" length="10"/>
+ <db-attribute name="remarks" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="title" type="VARCHAR" length="255"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
+ <db-attribute name="unit_cost_fk" type="BIGINT" length="10"/>
+ </db-entity>
+ <db-entity name="r_accomplishments_planned_programs" catalog="cxe">
+ <db-attribute name="accomplishment_article_py" type="BIGINT" length="10"/>
+ <db-attribute name="accomplishment_py" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="accomplishment_py_other" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="accomplishment_py_text" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="description" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="planned_program_article_by1" type="BIGINT" length="10"/>
+ <db-attribute name="planned_program_article_by1_base" type="BIGINT" length="10"/>
+ <db-attribute name="planned_program_article_by1_oco" type="BIGINT" length="10"/>
+ <db-attribute name="planned_program_article_cy" type="BIGINT" length="10"/>
+ <db-attribute name="planned_program_by1" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="planned_program_by1_base" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="planned_program_by1_base_other" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="planned_program_by1_oco" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="planned_program_by1_oco_other" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="planned_program_by1_other" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="planned_program_by1_text_base" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="planned_program_by1_text_oco" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="planned_program_cy" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="planned_program_cy_other" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="planned_program_cy_text" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="project_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
+ </db-entity>
+ <db-entity name="r_congressional_add_details" catalog="cxe">
+ <db-attribute name="cy" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="cy_text" type="VARCHAR" length="4000"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="project_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="py" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="py_text" type="VARCHAR" length="4000"/>
+ <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
+ </db-entity>
+ <db-entity name="r_cost_category_groups" catalog="cxe">
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="project_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="remarks" type="VARCHAR" length="5000"/>
+ <db-attribute name="type" type="CHAR" isMandatory="true" length="20"/>
+ </db-entity>
+ <db-entity name="r_cost_category_items" catalog="cxe">
+ <db-attribute name="award_date_by1_base" type="DATE"/>
+ <db-attribute name="award_date_by1_oco" type="DATE"/>
+ <db-attribute name="award_date_cy" type="DATE"/>
+ <db-attribute name="award_date_py" type="DATE"/>
+ <db-attribute name="contract_designation_fk" type="BIGINT" length="10"/>
+ <db-attribute name="cost_category_group_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="name" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="performing_activity" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="performing_activity_location" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="target_value" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="target_value_continuing" type="BIT"/>
+ <db-attribute name="target_value_str" type="VARCHAR" length="11"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
+ </db-entity>
+ <db-entity name="r_joint_fundings" catalog="cxe">
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="project_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="target_value" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="target_value_continuing" type="BIT"/>
+ <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
+ </db-entity>
+ <db-entity name="r_major_performers" catalog="cxe">
+ <db-attribute name="date_awarded" type="DATE" length="10"/>
+ <db-attribute name="description" type="VARCHAR" length="512"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="funds" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="location" type="VARCHAR" length="255"/>
+ <db-attribute name="name" type="VARCHAR" isMandatory="true" length="75"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="project_fk" type="BIGINT" isMandatory="true" length="10"/>
+ </db-entity>
+ <db-entity name="r_other_adjustments" catalog="cxe">
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="program_element_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
+ </db-entity>
+ <db-entity name="r_other_program_fundings" catalog="cxe">
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="line_item" type="VARCHAR" isMandatory="true" length="35"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="project_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" length="10"/>
+ </db-entity>
+ <db-entity name="r_program_elements" catalog="cxe">
+ <db-attribute name="change_summary_explanation" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="congressional_adds_fk" type="BIGINT" length="10"/>
+ <db-attribute name="congressional_directed_reductions_fk" type="BIGINT" length="10"/>
+ <db-attribute name="congressional_directed_transfers_fk" type="BIGINT" length="10"/>
+ <db-attribute name="congressional_general_reductions_fk" type="BIGINT" length="10"/>
+ <db-attribute name="congressional_rescissions_fk" type="BIGINT" length="10"/>
+ <db-attribute name="current_pb_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="format" type="CHAR" length="9"/>
+ <db-attribute name="funding_designation_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="mdap_codes" type="VARCHAR" length="100"/>
+ <db-attribute name="mission_description" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="monetary_unit_format" type="CHAR" isMandatory="true" length="9"/>
+ <db-attribute name="notes" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="previous_pb_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="program_element_number" type="VARCHAR" isMandatory="true" length="10"/>
+ <db-attribute name="pys_delta" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="r1_count" type="SMALLINT" length="5"/>
+ <db-attribute name="r1_number" type="VARCHAR" length="10"/>
+ <db-attribute name="r2_count" type="SMALLINT" length="5"/>
+ <db-attribute name="r2a_count" type="SMALLINT" length="5"/>
+ <db-attribute name="r3_count" type="SMALLINT" length="5"/>
+ <db-attribute name="r4_count" type="SMALLINT" length="5"/>
+ <db-attribute name="r4a_count" type="SMALLINT" length="5"/>
+ <db-attribute name="r5_count" type="SMALLINT" length="5"/>
+ <db-attribute name="reprogrammings_fk" type="BIGINT" length="10"/>
+ <db-attribute name="sbir_sttr_transfer_fk" type="BIGINT" length="10"/>
+ <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="total_adjusted_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" isMandatory="true" length="10"/>
+ </db-entity>
+ <db-entity name="r_projects" catalog="cxe">
+ <db-attribute name="articles_in_accomplishments_planned_program" type="BIT"/>
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="include_project_in_pdf" type="BIT" isMandatory="true"/>
+ <db-attribute name="mdap_code" type="VARCHAR" length="4"/>
+ <db-attribute name="mission_description" type="LONGVARCHAR" isMandatory="true" length="65535"/>
+ <db-attribute name="notes" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="other_program_remarks" type="LONGVARCHAR" length="5000"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="program_element_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="project_acquisition_strategy" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="project_article_fk" type="BIGINT" length="10"/>
+ <db-attribute name="project_major_performers" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="project_number" type="VARCHAR" isMandatory="true" length="25"/>
+ <db-attribute name="project_performance_metrics" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="project_schedule_detail_remarks" type="LONGVARCHAR" length="5000"/>
+ <db-attribute name="project_schedule_profile_remarks" type="LONGVARCHAR" length="5000"/>
+ <db-attribute name="project_title" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="pys_delta" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="r3_remarks" type="LONGVARCHAR" length="5000"/>
+ <db-attribute name="special_project" type="BIT" isMandatory="true"/>
+ <db-attribute name="termination_liability_fk" type="BIGINT" length="10"/>
+ <db-attribute name="termination_liability_remarks" type="LONGVARCHAR" length="5000"/>
+ <db-attribute name="total_cost_fk" type="BIGINT" isMandatory="true" length="10"/>
+ </db-entity>
+ <db-entity name="r_schedule_details" catalog="cxe">
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="end_quarter" type="TINYINT" isMandatory="true" length="3"/>
+ <db-attribute name="end_year" type="SMALLINT" isMandatory="true"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="schedule_sub_project_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="start_quarter" type="TINYINT" isMandatory="true" length="3"/>
+ <db-attribute name="start_year" type="SMALLINT" isMandatory="true"/>
+ <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
+ </db-entity>
+ <db-entity name="r_schedule_profiles" catalog="cxe">
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="image_data" type="LONGVARBINARY" isMandatory="true" length="16777215"/>
+ <db-attribute name="image_name" type="VARCHAR" isMandatory="true" length="255"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="project_fk" type="BIGINT" isMandatory="true" length="10"/>
+ </db-entity>
+ <db-entity name="r_schedule_sub_projects" catalog="cxe">
+ <db-attribute name="display_order" type="SMALLINT" isMandatory="true" length="5"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="project_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="title" type="VARCHAR" isMandatory="true" length="255"/>
+ </db-entity>
+ <db-entity name="s_appropriations" catalog="cxe">
+ <db-attribute name="code" type="VARCHAR" isMandatory="true" length="10"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="title" type="VARCHAR" isMandatory="true" length="75"/>
+ </db-entity>
+ <db-entity name="s_budget_activities" catalog="cxe">
+ <db-attribute name="code" type="VARCHAR" isMandatory="true" length="10"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="title" type="VARCHAR" isMandatory="true" length="75"/>
+ </db-entity>
+ <db-entity name="s_budget_periods" catalog="cxe">
+ <db-attribute name="cycle" type="CHAR" isMandatory="true" length="4"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="submission_date" type="DATE" isMandatory="true" length="10"/>
+ <db-attribute name="suffix" type="VARCHAR" length="25"/>
+ <db-attribute name="year" type="VARCHAR" isMandatory="true" length="4"/>
+ </db-entity>
+ <db-entity name="s_budget_sub_activities" catalog="cxe">
+ <db-attribute name="code" type="VARCHAR" isMandatory="true" length="10"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="title" type="VARCHAR" isMandatory="true" length="75"/>
+ </db-entity>
+ <db-entity name="s_budget_years">
+ <db-attribute name="by1" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="by1_base" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="by1_base_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by1_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by1_oco" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="by1_oco_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by2" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="by2_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by3" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="by3_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by4" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="by4_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="by5" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="by5_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="continuing" type="BOOLEAN"/>
+ <db-attribute name="continuing_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="cy" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="cy_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="py" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="py_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="pys" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="pys_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="to_complete" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="to_complete_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="total" type="DECIMAL" length="13" scale="3"/>
+ <db-attribute name="total_footnote" type="LONGVARCHAR" length="65535"/>
+ <db-attribute name="type" type="VARCHAR" isMandatory="true" length="2"/>
+ </db-entity>
+ <db-entity name="s_contract_designations" catalog="cxe">
+ <db-attribute name="contract_method" type="VARCHAR" length="25"/>
+ <db-attribute name="contract_type" type="VARCHAR" length="25"/>
+ <db-attribute name="funding_vehicle" type="VARCHAR" length="25"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ </db-entity>
+ <db-entity name="s_funding_designations" catalog="cxe">
+ <db-attribute name="appropriation_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="budget_activity_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="budget_period_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="budget_sub_activity_fk" type="BIGINT" length="10"/>
+ <db-attribute name="exhibit_category" type="CHAR" isMandatory="true" length="2"/>
+ <db-attribute name="organization_fk" type="BIGINT" isMandatory="true" length="10"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ </db-entity>
+ <db-entity name="s_organizations" catalog="cxe">
+ <db-attribute name="code" type="VARCHAR" isMandatory="true" length="8"/>
+ <db-attribute name="name" type="VARCHAR" isMandatory="true" length="75"/>
+ <db-attribute name="pk" type="BIGINT" isPrimaryKey="true" isGenerated="true" isMandatory="true" length="10"/>
+ <db-attribute name="smca" type="BIT" isMandatory="true"/>
+ </db-entity>
+ <obj-entity name="AccomplishmentPlannedProgram" className="org.example.analytic.model.AccomplishmentPlannedProgram" dbEntityName="r_accomplishments_planned_programs" superClassName="org.example.analytic.model.AnalyticBase">
+ <obj-attribute name="accomplishmentArticlePY" type="java.lang.Long" db-attribute-path="accomplishment_article_py"/>
+ <obj-attribute name="accomplishmentPY" type="java.math.BigDecimal" db-attribute-path="accomplishment_py"/>
+ <obj-attribute name="accomplishmentPYOther" type="java.math.BigDecimal" db-attribute-path="accomplishment_py_other"/>
+ <obj-attribute name="accomplishmentPYText" type="java.lang.String" db-attribute-path="accomplishment_py_text"/>
+ <obj-attribute name="description" type="java.lang.String" db-attribute-path="description"/>
+ <obj-attribute name="displayOrder" type="java.lang.Short" db-attribute-path="display_order"/>
+ <obj-attribute name="plannedProgramArticleBY1" type="java.lang.Long" db-attribute-path="planned_program_article_by1"/>
+ <obj-attribute name="plannedProgramArticleBY1Base" type="java.lang.Long" db-attribute-path="planned_program_article_by1_base"/>
+ <obj-attribute name="plannedProgramArticleBY1OCO" type="java.lang.Long" db-attribute-path="planned_program_article_by1_oco"/>
+ <obj-attribute name="plannedProgramArticleCY" type="java.lang.Long" db-attribute-path="planned_program_article_cy"/>
+ <obj-attribute name="plannedProgramBY1" type="java.math.BigDecimal" db-attribute-path="planned_program_by1"/>
+ <obj-attribute name="plannedProgramBY1Base" type="java.math.BigDecimal" db-attribute-path="planned_program_by1_base"/>
+ <obj-attribute name="plannedProgramBY1BaseOther" type="java.math.BigDecimal" db-attribute-path="planned_program_by1_base_other"/>
+ <obj-attribute name="plannedProgramBY1OCO" type="java.math.BigDecimal" db-attribute-path="planned_program_by1_oco"/>
+ <obj-attribute name="plannedProgramBY1OCOOther" type="java.math.BigDecimal" db-attribute-path="planned_program_by1_oco_other"/>
+ <obj-attribute name="plannedProgramBY1Other" type="java.math.BigDecimal" db-attribute-path="planned_program_by1_other"/>
+ <obj-attribute name="plannedProgramBY1TextBase" type="java.lang.String" db-attribute-path="planned_program_by1_text_base"/>
+ <obj-attribute name="plannedProgramBY1TextOCO" type="java.lang.String" db-attribute-path="planned_program_by1_text_oco"/>
+ <obj-attribute name="plannedProgramCY" type="java.math.BigDecimal" db-attribute-path="planned_program_cy"/>
+ <obj-attribute name="plannedProgramCYOther" type="java.math.BigDecimal" db-attribute-path="planned_program_cy_other"/>
+ <obj-attribute name="plannedProgramCYText" type="java.lang.String" db-attribute-path="planned_program_cy_text"/>
+ <obj-attribute name="title" type="java.lang.String" db-attribute-path="title"/>
+ </obj-entity>
+ <obj-entity name="AdvanceProcurement" className="org.example.analytic.model.AdvanceProcurement" dbEntityName="p_advance_procurements" superClassName="org.example.analytic.model.AnalyticBase">
+ <obj-attribute name="description" type="java.lang.String" db-attribute-path="description"/>
+ <obj-attribute name="firstSystemAwardMonthAndYear" type="java.util.Date" db-attribute-path="first_system_award_month_and_year"/>
+ <obj-attribute name="firstSystemAwardMonthAndYearFootnote" type="java.lang.String" db-attribute-path="first_system_award_month_and_year_footnote"/>
+ <obj-attribute name="firstSystemCompletionMonthAndYear" type="java.util.Date" db-attribute-path="first_system_completion_month_and_year"/>
+ <obj-attribute name="firstSystemCompletionMonthAndYearFootnote" type="java.lang.String" db-attribute-path="first_system_completion_month_and_year_footnote"/>
+ <obj-attribute name="idCode" type="org.example.analytic.model.constants.IDCodeType" db-attribute-path="id_code"/>
+ <obj-attribute name="mdapCodes" type="java.lang.String" db-attribute-path="mdap_codes"/>
+ <obj-attribute name="productionLeadTimeMonths" type="java.lang.Short" db-attribute-path="production_lead_time_months"/>
+ <obj-attribute name="productionLeadTimeMonthsFootnote" type="java.lang.String" db-attribute-path="production_lead_time_months_footnote"/>
+ <obj-attribute name="systemIntervalMonths" type="java.lang.Short" db-attribute-path="system_interval_months"/>
+ <obj-attribute name="systemIntervalMonthsFootnote" type="java.lang.String" db-attribute-path="system_interval_months_footnote"/>
+ </obj-entity>
+ <obj-entity name="AdvanceProcurementCostElement" className="org.example.analytic.model.AdvanceProcurementCostElement" dbEntityName="p_advance_procurement_cost_elements" superClassName="org.example.analytic.model.AnalyticBase">
+ <obj-attribute name="displayOrder" type="java.lang.Short" db-attribute-path="display_order"/>
+ <obj-attribute name="forFiscalYear" type="java.lang.String" db-attribute-path="for_fiscal_year"/>
+ <obj-attribute name="forFiscalYearFootnote" type="java.lang.String" db-attribute-path="for_fiscal_year_footnote"/>
+ <obj-attribute name="quantityPerAssembly" type="java.lang.Short" db-attribute-path="quantity_per_assembly"/>
+ <obj-attribute name="quantityPerAssemblyFootnote" type="java.lang.String" db-attribute-path="quantity_per_assembly_footnote"/>
+ <obj-attribute name="terminationLiabilityFootnote" type="java.lang.String" db-attribute-path="termination_liability_footnote"/>
+ <obj-attribute name="title" type="java.lang.String" db-attribute-path="title"/>
+ <obj-attribute name="titleFootnote" type="java.lang.String" db-attribute-path="title_footnote"/>
+ <obj-attribute name="whenRequiredMonths" type="java.lang.Short" db-attribute-path="when_required_months"/>
+ <obj-attribute name="whenRequiredMonthsFootnote" type="java.lang.String" db-attribute-path="when_required_months_footnote"/>
+ </obj-entity>
+ <obj-entity name="AdvanceProcurementCostElementCategory" className="org.example.analytic.model.AdvanceProcurementCostElementCategory" dbEntityName="p_advance_procurement_cost_element_categories" superClassName="org.example.analytic.model.AnalyticBase">
+ <obj-attribute name="type" type="org.example.analytic.model.constants.AdvanceProcurementCostElementCategoryType" db-attribute-path="type"/>
+ </obj-entity>
+ <obj-entity name="AdvanceProcurementEOQCost" className="org.example.analytic.model.AdvanceProcurementEOQCost" dbEntityName="p_advance_procurement_eoq_costs" superClassName="org.example.analytic.model.AnalyticBase">
+ <obj-attribute name="displayOrder" type="java.lang.Short" db-attribute-path="display_order"/>
+ <obj-attribute name="forFiscalYear" type="java.lang.String" db-attribute-path="for_fiscal_year"/>
+ <obj-attribute name="forFiscalYearFootnote" type="java.lang.String" db-attribute-path="for_fiscal_year_footnote"/>
+ <obj-attribute name="quantity" type="java.math.BigDecimal" db-attribute-path="quantity"/>
+ <obj-attribute name="quantityFootnote" type="java.lang.String" db-attribute-path="quantity_footnote"/>
+ </obj-entity>
+ <obj-entity name="Appropriation" className="org.example.analytic.model.Appropriation" dbEntityName="s_appropriations" superClassName="org.example.analytic.model.AnalyticBase">
+ <obj-attribute name="code" type="java.lang.String" db-attribute-path="code"/>
+ <obj-attribute name="title" type="java.lang.String" db-attribute-path="title"/>
+ </obj-entity>
+ <obj-entity name="BudgetActivity" className="org.example.analytic.model.BudgetActivity" dbEntityName="s_budget_activities" superClassName="org.example.analytic.model.AnalyticBase">
+ <obj-attribute name="code" type="java.lang.String" db-attribute-path="code"/>
+ <obj-attribute name="title" type="java.lang.String" db-attribute-path="title"/>
+ </obj-entity>
+ <obj-entity name="BudgetPeriod" className="org.example.analytic.model.BudgetPeriod" dbEntityName="s_budget_periods" superClassName="org.example.analytic.model.AnalyticBase">
+ <obj-attribute name="cycle" type="org.example.analytic.model.constants.BudgetCycleType" db-attribute-path="cycle"/>
+ <obj-attribute name="submissionDate" type="java.util.Date" db-attribute-path="submission_date"/>
+ <obj-attribute name="suffix" type="java.lang.String" db-attribute-path="suffix"/>
+ <obj-attribute name="year" type="java.lang.String" db-attribute-path="year"/>
+ </obj-entity>
+ <obj-entity name="BudgetQuarters" className="org.example.analytic.model.BudgetQuarters" dbEntityName="p_budget_quarters" superClassName="org.example.analytic.model.AnalyticBase">
+ <obj-attribute name="APY" type="java.lang.Integer" db-attribute-path="pys"/>
+ <obj-attribute name="APYFootnote" type="java.lang.String" db-attribute-path="pys_footnote"/>
+ <obj-attribute name="BY1BaseQ1" type="java.lang.Integer" db-attribute-path="by1_base_q1"/>
+ <obj-attribute name="BY1BaseQ1Footnote" type="java.lang.String" db-attribute-path="by1_base_q1_footnote"/>
+ <obj-attribute name="BY1BaseQ2" type="java.lang.Integer" db-attribute-path="by1_base_q2"/>
+ <obj-attribute name="BY1BaseQ2Footnote" type="java.lang.String" db-attribute-path="by1_base_q2_footnote"/>
+ <obj-attribute name="BY1BaseQ3" type="java.lang.Integer" db-attribute-path="by1_base_q3"/>
+ <obj-attribute name="BY1BaseQ3Footnote" type="java.lang.String" db-attribute-path="by1_base_q3_footnote"/>
+ <obj-attribute name="BY1BaseQ4" type="java.lang.Integer" db-attribute-path="by1_base_q4"/>
+ <obj-attribute name="BY1BaseQ4Footnote" type="java.lang.String" db-attribute-path="by1_base_q4_footnote"/>
+ <obj-attribute name="BY1OCOQ1" type="java.lang.Integer" db-attribute-path="by1_oco_q1"/>
+ <obj-attribute name="BY1OCOQ1Footnote" type="java.lang.String" db-attribute-path="by1_oco_q1_footnote"/>
+ <obj-attribute name="BY1OCOQ2" type="java.lang.Integer" db-attribute-path="by1_oco_q2"/>
+ <obj-attribute name="BY1OCOQ2Footnote" type="java.lang.String" db-attribute-path="by1_oco_q2_footnote"/>
+ <obj-attribute name="BY1OCOQ3" type="java.lang.Integer" db-attribute-path="by1_oco_q3"/>
+ <obj-attribute name="BY1OCOQ3Footnote" type="java.lang.String" db-attribute-path="by1_oco_q3_footnote"/>
+ <obj-attribute name="BY1OCOQ4" type="java.lang.Integer" db-attribute-path="by1_oco_q4"/>
+ <obj-attribute name="BY1OCOQ4Footnote" type="java.lang.String" db-attribute-path="by1_oco_q4_footnote"/>
+ <obj-attribute name="BY1Q1" type="java.lang.Integer" db-attribute-path="by1_q1"/>
+ <obj-attribute name="BY1Q1Footnote" type="java.lang.String" db-attribute-path="by1_q1_footnote"/>
+ <obj-attribute name="BY1Q2" type="java.lang.Integer" db-attribute-path="by1_q2"/>
+ <obj-attribute name="BY1Q2Footnote" type="java.lang.String" db-attribute-path="by1_q2_footnote"/>
+ <obj-attribute name="BY1Q3" type="java.lang.Integer" db-attribute-path="by1_q3"/>
+ <obj-attribute name="BY1Q3Footnote" type="java.lang.String" db-attribute-path="by1_q3_footnote"/>
+ <obj-attribute name="BY1Q4" type="java.lang.Integer" db-attribute-path="by1_q4"/>
+ <obj-attribute name="BY1Q4Footnote" type="java.lang.String" db-attribute-path="by1_q4_footnote"/>
+ <obj-attribute name="BY2Q1" type="java.lang.Integer" db-attribute-path="by2_q1"/>
+ <obj-attribute name="BY2Q1Footnote" type="java.lang.String" db-attribute-path="by2_q1_footnote"/>
+ <obj-attribute name="BY2Q2" type="java.lang.Integer" db-attribute-path="by2_q2"/>
+ <obj-attribute name="BY2Q2Footnote" type="java.lang.String" db-attribute-path="by2_q2_footnote"/>
+ <obj-attribute name="BY2Q3" type="java.lang.Integer" db-attribute-path="by2_q3"/>
+ <obj-attribute name="BY2Q3Footnote" type="java.lang.String" db-attribute-path="by2_q3_footnote"/>
+ <obj-attribute name="BY2Q4" type="java.lang.Integer" db-attribute-path="by2_q4"/>
+ <obj-attribute name="BY2Q4Footnote" type="java.lang.String" db-attribute-path="by2_q4_footnote"/>
+ <obj-attribute name="BY3Q1" type="java.lang.Integer" db-attribute-path="by3_q1"/>
+ <obj-attribute name="BY3Q1Footnote" type="java.lang.String" db-attribute-path="by3_q1_footnote"/>
+ <obj-attribute name="BY3Q2" type="java.lang.Integer" db-attribute-path="by3_q2"/>
+ <obj-attribute name="BY3Q2Footnote" type="java.lang.String" db-attribute-path="by3_q2_footnote"/>
+ <obj-attribute name="BY3Q3" type="java.lang.Integer" db-attribute-path="by3_q3"/>
+ <obj-attribute name="BY3Q3Footnote" type="java.lang.String" db-attribute-path="by3_q3_footnote"/>
+ <obj-attribute name="BY3Q4" type="java.lang.Integer" db-attribute-path="by3_q4"/>
+ <obj-attribute name="BY3Q4Footnote" type="java.lang.String" db-attribute-path="by3_q4_footnote"/>
+ <obj-attribute name="BY4Q1" type="java.lang.Integer" db-attribute-path="by4_q1"/>
+ <obj-attribute name="BY4Q1Footnote" type="java.lang.String" db-attribute-path="by4_q1_footnote"/>
+ <obj-attribute name="BY4Q2" type="java.lang.Integer" db-attribute-path="by4_q2"/>
+ <obj-attribute name="BY4Q2Footnote" type="java.lang.String" db-attribute-path="by4_q2_footnote"/>
+ <obj-attribute name="BY4Q3" type="java.lang.Integer" db-attribute-path="by4_q3"/>
+ <obj-attribute name="BY4Q3Footnote" type="java.lang.String" db-attribute-path="by4_q3_footnote"/>
+ <obj-attribute name="BY4Q4" type="java.lang.Integer" db-attribute-path="by4_q4"/>
+ <obj-attribute name="BY4Q4Footnote" type="java.lang.String" db-attribute-path="by4_q4_footnote"/>
+ <obj-attribute name="BY5Q1" type="java.lang.Integer" db-attribute-path="by5_q1"/>
+ <obj-attribute name="BY5Q1Footnote" type="java.lang.String" db-attribute-path="by5_q1_footnote"/>
+ <obj-attribute name="BY5Q2" type="java.lang.Integer" db-attribute-path="by5_q2"/>
+ <obj-attribute name="BY5Q2Footnote" type="java.lang.String" db-attribute-path="by5_q2_footnote"/>
+ <obj-attribute name="BY5Q3" type="java.lang.Integer" db-attribute-path="by5_q3"/>
+ <obj-attribute name="BY5Q3Footnote" type="java.lang.String" db-attribute-path="by5_q3_footnote"/>
+ <obj-attribute name="BY5Q4" type="java.lang.Integer" db-attribute-path="by5_q4"/>
+ <obj-attribute name="BY5Q4Footnote" type="java.lang.String" db-attribute-path="by5_q4_footnote"/>
+ <obj-attribute name="CYQ1" type="java.lang.Integer" db-attribute-path="cy_q1"/>
+ <obj-attribute name="CYQ1Footnote" type="java.lang.String" db-attribute-path="cy_q1_footnote"/>
+ <obj-attribute name="CYQ2" type="java.lang.Integer" db-attribute-path="cy_q2"/>
+ <obj-attribute name="CYQ2Footnote" type="java.lang.String" db-attribute-path="cy_q2_footnote"/>
+ <obj-attribute name="CYQ3" type="java.lang.Integer" db-attribute-path="cy_q3"/>
+ <obj-attribute name="CYQ3Footnote" type="java.lang.String" db-attribute-path="cy_q3_footnote"/>
+ <obj-attribute name="CYQ4" type="java.lang.Integer" db-attribute-path="cy_q4"/>
+ <obj-attribute name="CYQ4Footnote" type="java.lang.String" db-attribute-path="cy_q4_footnote"/>
+ <obj-attribute name="PYQ1" type="java.lang.Integer" db-attribute-path="py_q1"/>
+ <obj-attribute name="PYQ1Footnote" type="java.lang.String" db-attribute-path="py_q1_footnote"/>
+ <obj-attribute name="PYQ2" type="java.lang.Integer" db-attribute-path="py_q2"/>
+ <obj-attribute name="PYQ2Footnote" type="java.lang.String" db-attribute-path="py_q2_footnote"/>
+ <obj-attribute name="PYQ3" type="java.lang.Integer" db-attribute-path="py_q3"/>
+ <obj-attribute name="PYQ3Footnote" type="java.lang.String" db-attribute-path="py_q3_footnote"/>
+ <obj-attribute name="PYQ4" type="java.lang.Integer" db-attribute-path="py_q4"/>
+ <obj-attribute name="PYQ4Footnote" type="java.lang.String" db-attribute-path="py_q4_footnote"/>
+ <obj-attribute name="continuing" type="java.lang.Boolean" db-attribute-path="continuing"/>
+ <obj-attribute name="continuingFootnote" type="java.lang.String" db-attribute-path="continuing_footnote"/>
+ <obj-attribute name="toComplete" type="java.lang.Integer" db-attribute-path="to_complete"/>
+ <obj-attribute name="toCompleteFootnote" type="java.lang.String" db-attribute-path="to_complete_footnote"/>
+ <obj-attribute name="totalCost" type="java.lang.Integer" db-attribute-path="total_cost"/>
+ <obj-attribute name="totalCostFootnote" type="java.lang.String" db-attribute-path="total_cost_footnote"/>
+ </obj-entity>
+ <obj-entity name="BudgetSubActivity" className="org.example.analytic.model.BudgetSubActivity" dbEntityName="s_budget_sub_activities" superClassName="org.example.analytic.model.AnalyticBase">
+ <obj-attribute name="code" type="java.lang.String" db-attribute-path="code"/>
+ <obj-attribute name="title" type="java.lang.String" db-attribute-path="title"/>
+ </obj-entity>
+ <obj-entity name="BudgetYears" className="org.example.analytic.model.BudgetYears" dbEntityName="s_budget_years" superClassName="org.example.analytic.model.AnalyticBase">
+ <obj-attribute name="APY" type="java.math.BigDecimal" db-attribute-path="pys"/>
+ <obj-attribute name="APYFootnote" type="java.lang.String" db-attribute-path="pys_footnote"/>
+ <obj-attribute name="BY1" type="java.math.BigDecimal" db-attribute-path="by1"/>
+ <obj-attribute name="BY1Base" type="java.math.BigDecimal" db-attribute-path="by1_base"/>
+ <obj-attribute name="BY1BaseFootnote" type="java.lang.String" db-attribute-path="by1_base_footnote"/>
+ <obj-attribute name="BY1Footnote" type="java.lang.String" db-attribute-path="by1_footnote"/>
+ <obj-attribute name="BY1OCO" type="java.math.BigDecimal" db-attribute-path="by1_oco"/>
+ <obj-attribute name="BY1OCOFootnote" type="java.lang.String" db-attribute-path="by1_oco_footnote"/>
+ <obj-attribute name="BY2" type="java.math.BigDecimal" db-attribute-path="by2"/>
+ <obj-attribute name="BY2Footnote" type="java.lang.String" db-attribute-path="by2_footnote"/>
+ <obj-attribute name="BY3" type="java.math.BigDecimal" db-attribute-path="by3"/>
+ <obj-attribute name="BY3Footnote" type="java.lang.String" db-attribute-path="by3_footnote"/>
+ <obj-attribute name="BY4" type="java.math.BigDecimal" db-attribute-path="by4"/>
+ <obj-attribute name="BY4Footnote" type="java.lang.String" db-attribute-path="by4_footnote"/>
+ <obj-attribute name="BY5" type="java.math.BigDecimal" db-attribute-path="by5"/>
+ <obj-attribute name="BY5Footnote" type="java.lang.String" db-attribute-path="by5_footnote"/>
+ <obj-attribute name="CY" type="java.math.BigDecimal" db-attribute-path="cy"/>
+ <obj-attribute name="CYFootnote" type="java.lang.String" db-attribute-path="cy_footnote"/>
+ <obj-attribute name="PY" type="java.math.BigDecimal" db-attribute-path="py"/>
+ <obj-attribute name="PYFootnote" type="java.lang.String" db-attribute-path="py_footnote"/>
+ <obj-attribute name="continuing" type="java.lang.Boolean" db-attribute-path="continuing"/>
+ <obj-attribute name="continuingFootnote" type="java.lang.String" db-attribute-path="continuing_footnote"/>
+ <obj-attribute name="toComplete" type="java.math.BigDecimal" db-attribute-path="to_complete"/>
+ <obj-attribute name="toCompleteFootnote" type="java.lang.String" db-attribute-path="to_complete_footnote"/>
+ <obj-attribute name="total" type="java.math.BigDecimal" db-attribute-path="total"/>
+ <obj-attribute name="totalFootnote" type="java.lang.String" db-attribute-path="total_footnote"/>
+ <obj-attribute name="type" type="org.example.analytic.model.constants.BudgetYearsType" db-attribute-path="type"/>
+ </obj-entity>
+ <obj-entity name="CongressionalAddDetail" className="org.example.analytic.model.CongressionalAddDetail" dbEntityName="r_congressional_add_details" superClassName="org.example.analytic.model.AnalyticBase">
+ <obj-attribute name="CY" type="java.math.BigDecimal" db-attribute-path="cy"/>
+ <obj-attribute name="CYText" type="java.lang.String" db-attribute-path="cy_text"/>
+ <obj-attribute name="PY" type="java.math.BigDecimal" db-attribute-path="py"/>
+ <obj-attribute name="PYText" type="java.lang.String" db-attribute-path="py_text"/>
+ <obj-attribute name="displayOrder" type="java.lang.Short" db-attribute-path="display_order"/>
+ <obj-attribute name="title" type="java.lang.String" db-attribute-path="title"/>
+ </obj-entity>
+ <obj-entity name="ContractDesignation" className="org.example.analytic.model.ContractDesignation" dbEntityName="s_contract_designations" superClassName="org.example.analytic.model.AnalyticBase">
+ <obj-attribute name="contractMethod" type="org.example.analytic.model.constants.ContractMethodType" db-attribute-path="contract_method"/>
+ <obj-attribute name="contractType" type="org.example.analyt
<TRUNCATED>
[3/5] cayenne-modeler git commit: Moved sample model file to test
resources.
Posted by mg...@apache.org.
http://git-wip-us.apache.org/repos/asf/cayenne-modeler/blob/8a569dbc/src/main/resources/cayenne-analytic.xml
----------------------------------------------------------------------
diff --git a/src/main/resources/cayenne-analytic.xml b/src/main/resources/cayenne-analytic.xml
deleted file mode 100644
index a5b1898..0000000
--- a/src/main/resources/cayenne-analytic.xml
+++ /dev/null
@@ -1,14 +0,0 @@
-<?xml version="1.0" encoding="utf-8"?>
-<domain project-version="9">
- <property name="cayenne.DataDomain.validatingObjectsOnCommit" value="false"/>
- <property name="cayenne.DataRowStore.remote.notify" value="true"/>
-
- <map name="analytic"/>
-
- <node name="analytic"
- factory="org.apache.cayenne.configuration.server.JNDIDataSourceFactory"
- parameters="jdbc/analytic-db"
- >
- <map-ref name="analytic"/>
- </node>
-</domain>
http://git-wip-us.apache.org/repos/asf/cayenne-modeler/blob/8a569dbc/src/test/java/org/apache/cayenne/modeler/adapters/TestDataDomainAdapter.java
----------------------------------------------------------------------
diff --git a/src/test/java/org/apache/cayenne/modeler/adapters/TestDataDomainAdapter.java b/src/test/java/org/apache/cayenne/modeler/adapters/TestDataDomainAdapter.java
index 0182885..3ec1909 100644
--- a/src/test/java/org/apache/cayenne/modeler/adapters/TestDataDomainAdapter.java
+++ b/src/test/java/org/apache/cayenne/modeler/adapters/TestDataDomainAdapter.java
@@ -31,7 +31,7 @@ public class TestDataDomainAdapter
{
Injection.setInjector(DIBootstrap.createInjector(appendModules(new ArrayList<Module>())));
- dataDomainAdapter = new DataDomainAdapter(CayenneProjectManager.projectForPath("src/main/resources/cayenne-analytic.xml"));
+ dataDomainAdapter = new DataDomainAdapter(CayenneProjectManager.projectForPath("src/test/resources/cayenne-analytic.xml"));
}
@Test
[5/5] cayenne-modeler git commit: Moved sample model file to test
resources.
Posted by mg...@apache.org.
Moved sample model file to test resources.
Project: http://git-wip-us.apache.org/repos/asf/cayenne-modeler/repo
Commit: http://git-wip-us.apache.org/repos/asf/cayenne-modeler/commit/8a569dbc
Tree: http://git-wip-us.apache.org/repos/asf/cayenne-modeler/tree/8a569dbc
Diff: http://git-wip-us.apache.org/repos/asf/cayenne-modeler/diff/8a569dbc
Branch: refs/heads/master
Commit: 8a569dbc59a235a1f9b125bb9ef956239bb22c96
Parents: a29096d
Author: mrg <bl...@gmail.com>
Authored: Mon Jan 16 17:39:36 2017 -0500
Committer: mrg <bl...@gmail.com>
Committed: Mon Jan 16 17:39:36 2017 -0500
----------------------------------------------------------------------
docs/Sample-Model.md | 2 +-
src/main/resources/analytic.map.xml | 2608 ------------------
src/main/resources/cayenne-analytic.xml | 14 -
.../modeler/adapters/TestDataDomainAdapter.java | 2 +-
src/test/resources/analytic.map.xml | 2608 ++++++++++++++++++
src/test/resources/cayenne-analytic.xml | 14 +
6 files changed, 2624 insertions(+), 2624 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/cayenne-modeler/blob/8a569dbc/docs/Sample-Model.md
----------------------------------------------------------------------
diff --git a/docs/Sample-Model.md b/docs/Sample-Model.md
index 1389045..8f77f34 100644
--- a/docs/Sample-Model.md
+++ b/docs/Sample-Model.md
@@ -1,3 +1,3 @@
# Development > Sample Model
-A sample model exists at `src/main/resources/cayenne-analytic.xml` and can be opened from the Splash Panel on startup for testing purposes.
+A sample model exists at `src/test/resources/cayenne-analytic.xml` and can be opened from the Splash Panel on startup for testing purposes.