Database Upgrade Environment. for RML Data Collection.

Related Work Items: #4219

1 files changed, 232 insertions, 0 deletions

diff --git a/Software/DB/SQLExaminer Projects/GENERAL_ENV_UPGRADE.sdeproj b/Software/DB/SQLExaminer Projects/GENERAL_ENV_UPGRADE.sdeproj
index 4ef68e8e5..60bc2f960 100644
--- a/Software/DB/SQLExaminer Projects/GENERAL_ENV_UPGRADE.sdeproj
+++ b/Software/DB/SQLExaminer Projects/GENERAL_ENV_UPGRADE.sdeproj
@@ -1272,6 +1272,238 @@
         <Column name="DESCRIPTION" />
       </Columns>
     </Item>
+    <Item name="dbo.RMLS_EXTENSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="RMLS_GUID" />
+        <Column name="USERS_GUID" />
+        <Column name="CREATED" />
+        <Column name="YARN_BRAND_GUID" />
+        <Column name="COUNTRY" />
+        <Column name="YARN_APPLICATION_GUID" />
+        <Column name="YARN_INDUSTRYSECTOR_GUID" />
+        <Column name="YARN_TYPE_GUID" />
+        <Column name="YARN_FAMILY_GUID" />
+        <Column name="YARN_SUB_FAMILY_GUID" />
+        <Column name="YARN_GROUP_GUID" />
+        <Column name="YARN_TEXTURING_GUID" />
+        <Column name="YARN_WHITE_SHADE_GUID" />
+        <Column name="YARN_GLOSS_LEVEL_GUID" />
+        <Column name="LINERAR_DENSITY" />
+        <Column name="TWIST_TPM" />
+        <Column name="TWIST_DIRECTION" />
+        <Column name="MIN_ELONGATION" />
+        <Column name="MAX_ELONGATION" />
+        <Column name="MIN_MAX_FORCE_N" />
+        <Column name="MAX_MAX_FORCE_N" />
+        <Column name="MIN_ELASTICITY" />
+        <Column name="MAX_ELASTICITY" />
+        <Column name="MIN_TENACITY" />
+        <Column name="MAX_TENACITY" />
+        <Column name="FINISHING" />
+        <Column name="STATUS" />
+        <Column name="RML_LEVEL" />
+      </Columns>
+    </Item>
+    <Item name="dbo.YARN_APPLICATIONS" type="table" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.YARN_BRANDS" type="table" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.YARN_FAMILIES" type="table" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.YARN_GLOSS_LEVELS" type="table" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.YARN_GROUPS" type="table" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.YARN_INDUSTRYSECTORS" type="table" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.YARN_MANUFACTURERS" type="table" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.YARN_SUB_FAMILIES" type="table" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.YARN_TEXTURINGS" type="table" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.YARN_TYPES" type="table" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.YARN_WHITE_SHADES" type="table" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.COLOR_PROCESS_PARAMETERS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="RMLS_EXTENSIONS_GUID" />
+        <Column name="MACHINE_GUID" />
+        <Column name="WHITE_POINT_L" />
+        <Column name="WHITE_POINT_A" />
+        <Column name="WHITE_POINT_B" />
+      </Columns>
+    </Item>
+    <Item name="dbo.COLOR_PROCESS_FACTORS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="COLOR_PROCESS_PARAMETERS_GUID" />
+        <Column name="COLOR" />
+        <Column name="INK_NL_CM" />
+        <Column name="L" />
+        <Column name="A" />
+        <Column name="B" />
+        <Column name="FACTOR_PERCENT" />
+      </Columns>
+    </Item>
+    <Item name="dbo.COLOR_PROCESS_DATA" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="COLOR_PROCESS_PARAMETERS_GUID" />
+        <Column name="COLOR" />
+        <Column name="INK_NL_CM" />
+        <Column name="L" />
+        <Column name="A" />
+        <Column name="B" />
+      </Columns>
+    </Item>
+    <Item name="dbo.RML_EXTENSION_TEST_RESULTS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="RMLS_EXTENSIONS_GUID" />
+        <Column name="MACHINE_GUID" />
+        <Column name="RESULT_INDEX" />
+        <Column name="NAME" />
+        <Column name="DRYER_TEMPERATURE" />
+        <Column name="TUNNEL_TEMPERATURE" />
+        <Column name="TUNNEL_FLOW" />
+        <Column name="TUNNEL_AVG_TEMPERATURE" />
+        <Column name="TENSION_HEAD_MIN" />
+        <Column name="TENSION_HEAD_MAX" />
+        <Column name="TENSION_AFTER_DRYER_MIN" />
+        <Column name="TENSIOIN_AFTER_DRYER_MAX" />
+        <Column name="TENSION_WINDER_MIN" />
+        <Column name="TENSION_WINDER_MAX" />
+        <Column name="BTSR_MIN" />
+        <Column name="BTSR_MAX" />
+        <Column name="PULLER_TENSION_MIN" />
+        <Column name="PULLER_TENSION_MAX" />
+        <Column name="EXIT_TENSION_MIN" />
+        <Column name="EXIT_TENSION_MAX" />
+        <Column name="SEVERITY_ZONE1_MIN" />
+        <Column name="SEVERITY_ZONE1_MAX" />
+        <Column name="SEVERITY_ZONE2_MIN" />
+        <Column name="SEVERITY_ZONE2_MAX" />
+        <Column name="COMMENT" />
+        <Column name="CONCLUSIONS" />
+        <Column name="REF_LUB_VERSION" />
+        <Column name="REF_COF" />
+        <Column name="REF_LUB" />
+        <Column name="THREAD_LUB_VERSION" />
+        <Column name="THREAD_COF" />
+        <Column name="THREAD_LUB" />
+      </Columns>
+    </Item>
+    <Item name="dbo.RUBBING_RESULTS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="RML_EXTENSION_TEST_RESULTS_GUID" />
+        <Column name="COLOR" />
+        <Column name="DELTAE_CIE_100" />
+        <Column name="GS_100_MIN" />
+        <Column name="GS_100_MAX" />
+        <Column name="DELTAE_CIE_200" />
+        <Column name="GS_200_MIN" />
+        <Column name="GS_200_MAX" />
+      </Columns>
+    </Item>
+    <Item name="dbo.TENSILE_RESULTS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="RML_EXTENSION_TEST_RESULTS_GUID" />
+        <Column name="COLOR_PERCENT" />
+        <Column name="COLOR" />
+        <Column name="MAX_LOAD" />
+        <Column name="STDEV_MAX_LOAD" />
+        <Column name="STRAIN_MAX_LOAD" />
+        <Column name="STDEV_STRAIN_MAX_LOAD" />
+        <Column name="PERCENT_CHANGE_LOAD" />
+        <Column name="PERCENT_CHANGE_STRAIN" />
+      </Columns>
+    </Item>
   </Items>
   <SchemaMapping>
     <SMItem schema1="dbo" schema2="dbo" />