Created a new project Tango.MachineStudio.ThreadExtentions. Changes in Database.

24 files changed, 2110 insertions, 98 deletions

diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/COLOR_PROCESS_DATA.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/COLOR_PROCESS_DATA.cs
new file mode 100644
index 000000000..711e6597c
--- /dev/null
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/COLOR_PROCESS_DATA.cs
@@ -0,0 +1,29 @@
+//------------------------------------------------------------------------------
+// <auto-generated>
+//     This code was generated from a template.
+//
+//     Manual changes to this file may cause unexpected behavior in your application.
+//     Manual changes to this file will be overwritten if the code is regenerated.
+// </auto-generated>
+//------------------------------------------------------------------------------
+
+namespace Tango.DAL.Remote.DB
+{
+    using System;
+    using System.Collections.Generic;
+    
+    public partial class COLOR_PROCESS_DATA
+    {
+        public int ID { get; set; }
+        public string GUID { get; set; }
+        public System.DateTime LAST_UPDATED { get; set; }
+        public string COLOR_PROCESS_PARAMETERS_GUID { get; set; }
+        public string COLOR_NAME { get; set; }
+        public int INK_NL_CM { get; set; }
+        public double L { get; set; }
+        public double A { get; set; }
+        public double B { get; set; }
+    
+        public virtual COLOR_PROCESS_PARAMETERS COLOR_PROCESS_PARAMETERS { get; set; }
+    }
+}
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/COLOR_PROCESS_FACTOR.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/COLOR_PROCESS_FACTOR.cs
new file mode 100644
index 000000000..ad5eadb0a
--- /dev/null
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/COLOR_PROCESS_FACTOR.cs
@@ -0,0 +1,30 @@
+//------------------------------------------------------------------------------
+// <auto-generated>
+//     This code was generated from a template.
+//
+//     Manual changes to this file may cause unexpected behavior in your application.
+//     Manual changes to this file will be overwritten if the code is regenerated.
+// </auto-generated>
+//------------------------------------------------------------------------------
+
+namespace Tango.DAL.Remote.DB
+{
+    using System;
+    using System.Collections.Generic;
+    
+    public partial class COLOR_PROCESS_FACTOR
+    {
+        public int ID { get; set; }
+        public string GUID { get; set; }
+        public System.DateTime LAST_UPDATED { get; set; }
+        public string COLOR_PROCESS_PARAMETERS_GUID { get; set; }
+        public string COLOR_NAME { get; set; }
+        public int INK_NL_CM { get; set; }
+        public double L { get; set; }
+        public double A { get; set; }
+        public double B { get; set; }
+        public int FACTOR_PERCENT { get; set; }
+    
+        public virtual COLOR_PROCESS_PARAMETERS COLOR_PROCESS_PARAMETERS { get; set; }
+    }
+}
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/COLOR_PROCESS_PARAMETERS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/COLOR_PROCESS_PARAMETERS.cs
new file mode 100644
index 000000000..3e620912e
--- /dev/null
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/COLOR_PROCESS_PARAMETERS.cs
@@ -0,0 +1,38 @@
+//------------------------------------------------------------------------------
+// <auto-generated>
+//     This code was generated from a template.
+//
+//     Manual changes to this file may cause unexpected behavior in your application.
+//     Manual changes to this file will be overwritten if the code is regenerated.
+// </auto-generated>
+//------------------------------------------------------------------------------
+
+namespace Tango.DAL.Remote.DB
+{
+    using System;
+    using System.Collections.Generic;
+    
+    public partial class COLOR_PROCESS_PARAMETERS
+    {
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
+        public COLOR_PROCESS_PARAMETERS()
+        {
+            this.COLOR_PROCESS_DATA = new HashSet<COLOR_PROCESS_DATA>();
+            this.COLOR_PROCESS_FACTOR = new HashSet<COLOR_PROCESS_FACTOR>();
+        }
+    
+        public int ID { get; set; }
+        public string GUID { get; set; }
+        public System.DateTime LAST_UPDATED { get; set; }
+        public string RMLS_EXTENSIONS_GUID { get; set; }
+        public double WHITE_POINT_L { get; set; }
+        public double WHITE_POINT_A { get; set; }
+        public double WHITE_POINT_B { get; set; }
+    
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
+        public virtual ICollection<COLOR_PROCESS_DATA> COLOR_PROCESS_DATA { get; set; }
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
+        public virtual ICollection<COLOR_PROCESS_FACTOR> COLOR_PROCESS_FACTOR { get; set; }
+        public virtual RMLS_EXTENSIONS RMLS_EXTENSIONS { get; set; }
+    }
+}
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/RML.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/RML.cs
index 4a9908912..f4c6880bc 100644
--- a/Software/Visual_Studio/Tango.DAL.Remote/DB/RML.cs
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/RML.cs
@@ -22,6 +22,7 @@ namespace Tango.DAL.Remote.DB
             this.JOBS = new HashSet<JOB>();
             this.LIQUID_TYPES_RMLS = new HashSet<LIQUID_TYPES_RMLS>();
             this.PROCESS_PARAMETERS_TABLES_GROUPS = new HashSet<PROCESS_PARAMETERS_TABLES_GROUPS>();
+            this.RMLS_EXTENSIONS = new HashSet<RMLS_EXTENSIONS>();
             this.RMLS_SPOOLS = new HashSet<RMLS_SPOOLS>();
             this.SITES_RMLS = new HashSet<SITES_RMLS>();
         }
@@ -99,6 +100,8 @@ namespace Tango.DAL.Remote.DB
         [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
         public virtual ICollection<PROCESS_PARAMETERS_TABLES_GROUPS> PROCESS_PARAMETERS_TABLES_GROUPS { get; set; }
         [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
+        public virtual ICollection<RMLS_EXTENSIONS> RMLS_EXTENSIONS { get; set; }
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
         public virtual ICollection<RMLS_SPOOLS> RMLS_SPOOLS { get; set; }
         [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
         public virtual ICollection<SITES_RMLS> SITES_RMLS { get; set; }
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/RMLS_EXTENSIONS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/RMLS_EXTENSIONS.cs
index c8f452bc4..a65820556 100644
--- a/Software/Visual_Studio/Tango.DAL.Remote/DB/RMLS_EXTENSIONS.cs
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/RMLS_EXTENSIONS.cs
@@ -14,10 +14,68 @@ namespace Tango.DAL.Remote.DB
     
     public partial class RMLS_EXTENSIONS
     {
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
+        public RMLS_EXTENSIONS()
+        {
+            this.COLOR_PROCESS_PARAMETERS = new HashSet<COLOR_PROCESS_PARAMETERS>();
+        }
+    
         public int ID { get; set; }
         public string GUID { get; set; }
         public System.DateTime LAST_UPDATED { get; set; }
-        public string NAME { get; set; }
-        public string DESCRIPTION { get; set; }
+        public string RML_GUID { get; set; }
+        public string USER_GUID { get; set; }
+        public System.DateTime CREATED { get; set; }
+        public string YARN_MANUFACTURER_GUID { get; set; }
+        public string YARN_BRAND_GUID { get; set; }
+        public string COUNTRY { get; set; }
+        public string YARN_END_USE_GUID { get; set; }
+        public string YARN_APPLICATIONS_GUID { get; set; }
+        public string YARN_INDUSTRYSECTOR_GUID { get; set; }
+        public string YARN_MATERIAL_GUID { get; set; }
+        public string YARN_TYPE_GUID { get; set; }
+        public string YARN_FAMILY_GUID { get; set; }
+        public string YARN_SUB_FAMILY_GUID { get; set; }
+        public string YARN_GROUP_GUID { get; set; }
+        public string YARN_TEXTURING_GUID { get; set; }
+        public string YARN_GEOMETRY_GUID { get; set; }
+        public string YARN_COLOR_GUID { get; set; }
+        public string YARN_GLOSS_LEVEL_GUID { get; set; }
+        public int LINEAR_DENSITY { get; set; }
+        public int UNIT { get; set; }
+        public int PLIES { get; set; }
+        public int FILAMENT_COUNT { get; set; }
+        public int TWIST_TPM { get; set; }
+        public Nullable<int> TWIST_DIRECTION { get; set; }
+        public Nullable<double> MIN_ELONGATION { get; set; }
+        public Nullable<double> MAX_ELONGATION { get; set; }
+        public Nullable<double> MIN_MAX_FORCE_N { get; set; }
+        public Nullable<double> MAX_MAX_FORCE_N { get; set; }
+        public Nullable<double> MIN_ELASTICITY { get; set; }
+        public Nullable<double> MAX_ELASTICITY { get; set; }
+        public Nullable<double> MIN_TENACITY { get; set; }
+        public Nullable<double> MAX_TENACITY { get; set; }
+        public string FINISHING { get; set; }
+        public string FILE_NAME { get; set; }
+        public byte[] DATA { get; set; }
+    
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
+        public virtual ICollection<COLOR_PROCESS_PARAMETERS> COLOR_PROCESS_PARAMETERS { get; set; }
+        public virtual RML RML { get; set; }
+        public virtual USER USER { get; set; }
+        public virtual YARN_APPLICATIONS YARN_APPLICATIONS { get; set; }
+        public virtual YARN_BRAND YARN_BRAND { get; set; }
+        public virtual YARN_COLOR YARN_COLOR { get; set; }
+        public virtual YARN_END_USE YARN_END_USE { get; set; }
+        public virtual YARN_FAMILY YARN_FAMILY { get; set; }
+        public virtual YARN_GEOMETRY YARN_GEOMETRY { get; set; }
+        public virtual YARN_GLOSS_LEVEL YARN_GLOSS_LEVEL { get; set; }
+        public virtual YARN_GROUP YARN_GROUP { get; set; }
+        public virtual YARN_INDUSTRYSECTOR YARN_INDUSTRYSECTOR { get; set; }
+        public virtual YARN_MANUFACTURER YARN_MANUFACTURER { get; set; }
+        public virtual YARN_MATERIALS YARN_MATERIALS { get; set; }
+        public virtual YARN_SUB_FAMILY YARN_SUB_FAMILY { get; set; }
+        public virtual YARN_TEXTURING YARN_TEXTURING { get; set; }
+        public virtual YARN_TYPE YARN_TYPE { get; set; }
     }
 }
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.Context.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.Context.cs
index d86ec98ae..a37de51db 100644
--- a/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.Context.cs
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.Context.cs
@@ -42,6 +42,9 @@ namespace Tango.DAL.Remote.DB
         public virtual DbSet<COLOR_CATALOGS_GROUPS> COLOR_CATALOGS_GROUPS { get; set; }
         public virtual DbSet<COLOR_CATALOGS_ITEMS> COLOR_CATALOGS_ITEMS { get; set; }
         public virtual DbSet<COLOR_CATALOGS_ITEMS_RECIPES> COLOR_CATALOGS_ITEMS_RECIPES { get; set; }
+        public virtual DbSet<COLOR_PROCESS_DATA> COLOR_PROCESS_DATA { get; set; }
+        public virtual DbSet<COLOR_PROCESS_FACTOR> COLOR_PROCESS_FACTOR { get; set; }
+        public virtual DbSet<COLOR_PROCESS_PARAMETERS> COLOR_PROCESS_PARAMETERS { get; set; }
         public virtual DbSet<COLOR_SPACES> COLOR_SPACES { get; set; }
         public virtual DbSet<CONFIGURATION> CONFIGURATIONS { get; set; }
         public virtual DbSet<CONTACT> CONTACTS { get; set; }
@@ -115,5 +118,19 @@ namespace Tango.DAL.Remote.DB
         public virtual DbSet<USER> USERS { get; set; }
         public virtual DbSet<USERS_ROLES> USERS_ROLES { get; set; }
         public virtual DbSet<WINDING_METHODS> WINDING_METHODS { get; set; }
+        public virtual DbSet<YARN_APPLICATIONS> YARN_APPLICATIONS { get; set; }
+        public virtual DbSet<YARN_BRAND> YARN_BRAND { get; set; }
+        public virtual DbSet<YARN_COLOR> YARN_COLOR { get; set; }
+        public virtual DbSet<YARN_END_USE> YARN_END_USE { get; set; }
+        public virtual DbSet<YARN_FAMILY> YARN_FAMILY { get; set; }
+        public virtual DbSet<YARN_GEOMETRY> YARN_GEOMETRY { get; set; }
+        public virtual DbSet<YARN_GLOSS_LEVEL> YARN_GLOSS_LEVEL { get; set; }
+        public virtual DbSet<YARN_GROUP> YARN_GROUP { get; set; }
+        public virtual DbSet<YARN_INDUSTRYSECTOR> YARN_INDUSTRYSECTOR { get; set; }
+        public virtual DbSet<YARN_MANUFACTURER> YARN_MANUFACTURER { get; set; }
+        public virtual DbSet<YARN_MATERIALS> YARN_MATERIALS { get; set; }
+        public virtual DbSet<YARN_SUB_FAMILY> YARN_SUB_FAMILY { get; set; }
+        public virtual DbSet<YARN_TEXTURING> YARN_TEXTURING { get; set; }
+        public virtual DbSet<YARN_TYPE> YARN_TYPE { get; set; }
     }
 }
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx b/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx
index 8ce8f6e02..79403a182 100644
--- a/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx
@@ -243,6 +243,47 @@
           <Property Name="BLACK" Type="float" Nullable="false" />
           <Property Name="PROCESS_PARAMETERS_TABLE_INDEX" Type="int" Nullable="false" />
         </EntityType>
+        <EntityType Name="COLOR_PROCESS_DATA">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
+          <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" />
+          <Property Name="COLOR_PROCESS_PARAMETERS_GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="COLOR_NAME" Type="varchar" MaxLength="50" Nullable="false" />
+          <Property Name="INK_NL_CM" Type="int" Nullable="false" />
+          <Property Name="L" Type="float" Nullable="false" />
+          <Property Name="A" Type="float" Nullable="false" />
+          <Property Name="B" Type="float" Nullable="false" />
+        </EntityType>
+        <EntityType Name="COLOR_PROCESS_FACTOR">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
+          <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" />
+          <Property Name="COLOR_PROCESS_PARAMETERS_GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="COLOR_NAME" Type="varchar" MaxLength="50" Nullable="false" />
+          <Property Name="INK_NL_CM" Type="int" Nullable="false" />
+          <Property Name="L" Type="float" Nullable="false" />
+          <Property Name="A" Type="float" Nullable="false" />
+          <Property Name="B" Type="float" Nullable="false" />
+          <Property Name="FACTOR_PERCENT" Type="int" Nullable="false" />
+        </EntityType>
+        <EntityType Name="COLOR_PROCESS_PARAMETERS">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
+          <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" />
+          <Property Name="RMLS_EXTENSIONS_GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="WHITE_POINT_L" Type="float" Nullable="false" />
+          <Property Name="WHITE_POINT_A" Type="float" Nullable="false" />
+          <Property Name="WHITE_POINT_B" Type="float" Nullable="false" />
+        </EntityType>
         <EntityType Name="COLOR_SPACES">
           <Key>
             <PropertyRef Name="GUID" />
@@ -1098,8 +1139,41 @@
           <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
           <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" />
           <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" />
-          <Property Name="NAME" Type="nvarchar" MaxLength="100" Nullable="false" />
-          <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="200" />
+          <Property Name="RML_GUID" Type="varchar" MaxLength="36" />
+          <Property Name="USER_GUID" Type="varchar" MaxLength="36" />
+          <Property Name="CREATED" Type="datetime2" Precision="3" Nullable="false" />
+          <Property Name="YARN_MANUFACTURER_GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="YARN_BRAND_GUID" Type="varchar" MaxLength="36" />
+          <Property Name="COUNTRY" Type="varchar" MaxLength="60" />
+          <Property Name="YARN_END_USE_GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="YARN_APPLICATIONS_GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="YARN_INDUSTRYSECTOR_GUID" Type="varchar" MaxLength="36" />
+          <Property Name="YARN_MATERIAL_GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="YARN_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="YARN_FAMILY_GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="YARN_SUB_FAMILY_GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="YARN_GROUP_GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="YARN_TEXTURING_GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="YARN_GEOMETRY_GUID" Type="varchar" MaxLength="36" />
+          <Property Name="YARN_COLOR_GUID" Type="varchar" MaxLength="36" />
+          <Property Name="YARN_GLOSS_LEVEL_GUID" Type="varchar" MaxLength="36" />
+          <Property Name="LINEAR_DENSITY" Type="int" Nullable="false" />
+          <Property Name="UNIT" Type="int" Nullable="false" />
+          <Property Name="PLIES" Type="int" Nullable="false" />
+          <Property Name="FILAMENT_COUNT" Type="int" Nullable="false" />
+          <Property Name="TWIST_TPM" Type="int" Nullable="false" />
+          <Property Name="TWIST_DIRECTION" Type="int" />
+          <Property Name="MIN_ELONGATION" Type="float" />
+          <Property Name="MAX_ELONGATION" Type="float" />
+          <Property Name="MIN_MAX_FORCE_N" Type="float" />
+          <Property Name="MAX_MAX_FORCE_N" Type="float" />
+          <Property Name="MIN_ELASTICITY" Type="float" />
+          <Property Name="MAX_ELASTICITY" Type="float" />
+          <Property Name="MIN_TENACITY" Type="float" />
+          <Property Name="MAX_TENACITY" Type="float" />
+          <Property Name="FINISHING" Type="varchar" MaxLength="36" />
+          <Property Name="FILE_NAME" Type="nvarchar" MaxLength="100" />
+          <Property Name="DATA" Type="image" />
         </EntityType>
         <EntityType Name="RMLS_SPOOLS">
           <Key>
@@ -1389,6 +1463,132 @@
           <Property Name="NAME" Type="varchar" MaxLength="50" Nullable="false" />
           <Property Name="DESCRIPTION" Type="varchar" MaxLength="100" Nullable="false" />
         </EntityType>
+        <EntityType Name="YARN_APPLICATIONS">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
+          <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" />
+          <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" />
+        </EntityType>
+        <EntityType Name="YARN_BRAND">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
+          <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" />
+          <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" />
+        </EntityType>
+        <EntityType Name="YARN_COLOR">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
+          <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" />
+          <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" />
+        </EntityType>
+        <EntityType Name="YARN_END_USE">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
+          <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" />
+          <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" />
+        </EntityType>
+        <EntityType Name="YARN_FAMILY">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
+          <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" />
+          <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" />
+        </EntityType>
+        <EntityType Name="YARN_GEOMETRY">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
+          <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" />
+          <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" />
+        </EntityType>
+        <EntityType Name="YARN_GLOSS_LEVEL">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
+          <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" />
+          <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" />
+        </EntityType>
+        <EntityType Name="YARN_GROUP">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
+          <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" />
+          <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" />
+        </EntityType>
+        <EntityType Name="YARN_INDUSTRYSECTOR">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
+          <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" />
+          <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" />
+        </EntityType>
+        <EntityType Name="YARN_MANUFACTURER">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
+          <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" />
+          <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" />
+        </EntityType>
+        <EntityType Name="YARN_MATERIALS">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
+          <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" />
+          <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" />
+        </EntityType>
+        <EntityType Name="YARN_SUB_FAMILY">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
+          <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" />
+          <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" />
+        </EntityType>
+        <EntityType Name="YARN_TEXTURING">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
+          <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" />
+          <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" />
+        </EntityType>
+        <EntityType Name="YARN_TYPE">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
+          <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" />
+          <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" />
+          <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" />
+        </EntityType>
         <Association Name="FK_ACTION_LOGS_USERS">
           <End Role="USERS" Type="Self.USERS" Multiplicity="0..1" />
           <End Role="ACTION_LOGS" Type="Self.ACTION_LOGS" Multiplicity="*" />
@@ -1549,6 +1749,48 @@
             </Dependent>
           </ReferentialConstraint>
         </Association>
+        <Association Name="FK_COLOR_PROCESS_DATA_COLOR_PROCESS_PARAMETERS">
+          <End Role="COLOR_PROCESS_PARAMETERS" Type="Self.COLOR_PROCESS_PARAMETERS" Multiplicity="1">
+            <OnDelete Action="Cascade" />
+          </End>
+          <End Role="COLOR_PROCESS_DATA" Type="Self.COLOR_PROCESS_DATA" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="COLOR_PROCESS_PARAMETERS">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="COLOR_PROCESS_DATA">
+              <PropertyRef Name="COLOR_PROCESS_PARAMETERS_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_COLOR_PROCESS_FACTOR_COLOR_PROCESS_PARAMETERS">
+          <End Role="COLOR_PROCESS_PARAMETERS" Type="Self.COLOR_PROCESS_PARAMETERS" Multiplicity="1">
+            <OnDelete Action="Cascade" />
+          </End>
+          <End Role="COLOR_PROCESS_FACTOR" Type="Self.COLOR_PROCESS_FACTOR" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="COLOR_PROCESS_PARAMETERS">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="COLOR_PROCESS_FACTOR">
+              <PropertyRef Name="COLOR_PROCESS_PARAMETERS_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_COLOR_PROCESS_PARAMETERS_RMLS_EXTENSIONS">
+          <End Role="RMLS_EXTENSIONS" Type="Self.RMLS_EXTENSIONS" Multiplicity="1">
+            <OnDelete Action="Cascade" />
+          </End>
+          <End Role="COLOR_PROCESS_PARAMETERS" Type="Self.COLOR_PROCESS_PARAMETERS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="COLOR_PROCESS_PARAMETERS">
+              <PropertyRef Name="RMLS_EXTENSIONS_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
         <Association Name="FK_CONFIGURATIONS_APPLICATION_DISPLAY_PANEL_VERSIONS">
           <End Role="APPLICATION_DISPLAY_PANEL_VERSIONS" Type="Self.APPLICATION_DISPLAY_PANEL_VERSIONS" Multiplicity="1" />
           <End Role="CONFIGURATIONS" Type="Self.CONFIGURATIONS" Multiplicity="*" />
@@ -2323,6 +2565,200 @@
             </Dependent>
           </ReferentialConstraint>
         </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_RMLS">
+          <End Role="RMLS" Type="Self.RMLS" Multiplicity="0..1">
+            <OnDelete Action="Cascade" />
+          </End>
+          <End Role="RMLS_EXTENSIONS" Type="Self.RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="RMLS">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="RML_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_USERS">
+          <End Role="USERS" Type="Self.USERS" Multiplicity="0..1" />
+          <End Role="RMLS_EXTENSIONS" Type="Self.RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="USERS">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="USER_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_APPLICATIONS">
+          <End Role="YARN_APPLICATIONS" Type="Self.YARN_APPLICATIONS" Multiplicity="1" />
+          <End Role="RMLS_EXTENSIONS" Type="Self.RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_APPLICATIONS">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_APPLICATIONS_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_BRAND">
+          <End Role="YARN_BRAND" Type="Self.YARN_BRAND" Multiplicity="0..1" />
+          <End Role="RMLS_EXTENSIONS" Type="Self.RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_BRAND">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_BRAND_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_COLOR">
+          <End Role="YARN_COLOR" Type="Self.YARN_COLOR" Multiplicity="0..1" />
+          <End Role="RMLS_EXTENSIONS" Type="Self.RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_COLOR">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_COLOR_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_END_USE">
+          <End Role="YARN_END_USE" Type="Self.YARN_END_USE" Multiplicity="1" />
+          <End Role="RMLS_EXTENSIONS" Type="Self.RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_END_USE">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_END_USE_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_FAMILY">
+          <End Role="YARN_FAMILY" Type="Self.YARN_FAMILY" Multiplicity="1" />
+          <End Role="RMLS_EXTENSIONS" Type="Self.RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_FAMILY">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_FAMILY_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_GEOMETRY">
+          <End Role="YARN_GEOMETRY" Type="Self.YARN_GEOMETRY" Multiplicity="0..1" />
+          <End Role="RMLS_EXTENSIONS" Type="Self.RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_GEOMETRY">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_GEOMETRY_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_GLOSS_LEVEL">
+          <End Role="YARN_GLOSS_LEVEL" Type="Self.YARN_GLOSS_LEVEL" Multiplicity="0..1" />
+          <End Role="RMLS_EXTENSIONS" Type="Self.RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_GLOSS_LEVEL">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_GLOSS_LEVEL_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_GROUP">
+          <End Role="YARN_GROUP" Type="Self.YARN_GROUP" Multiplicity="1" />
+          <End Role="RMLS_EXTENSIONS" Type="Self.RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_GROUP">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_GROUP_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_INDUSTRYSECTOR">
+          <End Role="YARN_INDUSTRYSECTOR" Type="Self.YARN_INDUSTRYSECTOR" Multiplicity="0..1" />
+          <End Role="RMLS_EXTENSIONS" Type="Self.RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_INDUSTRYSECTOR">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_INDUSTRYSECTOR_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_MANUFACTURER">
+          <End Role="YARN_MANUFACTURER" Type="Self.YARN_MANUFACTURER" Multiplicity="1" />
+          <End Role="RMLS_EXTENSIONS" Type="Self.RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_MANUFACTURER">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_MANUFACTURER_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_MATERIALS">
+          <End Role="YARN_MATERIALS" Type="Self.YARN_MATERIALS" Multiplicity="1" />
+          <End Role="RMLS_EXTENSIONS" Type="Self.RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_MATERIALS">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_MATERIAL_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_SUB_FAMILY">
+          <End Role="YARN_SUB_FAMILY" Type="Self.YARN_SUB_FAMILY" Multiplicity="1" />
+          <End Role="RMLS_EXTENSIONS" Type="Self.RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_SUB_FAMILY">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_SUB_FAMILY_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_TEXTURING">
+          <End Role="YARN_TEXTURING" Type="Self.YARN_TEXTURING" Multiplicity="1" />
+          <End Role="RMLS_EXTENSIONS" Type="Self.RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_TEXTURING">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_TEXTURING_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_TYPE">
+          <End Role="YARN_TYPE" Type="Self.YARN_TYPE" Multiplicity="1" />
+          <End Role="RMLS_EXTENSIONS" Type="Self.RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_TYPE">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_TYPE_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
         <Association Name="FK_RMLS_SPOOLS_RMLS">
           <End Role="RMLS" Type="Self.RMLS" Multiplicity="1">
             <OnDelete Action="Cascade" />
@@ -2594,6 +3030,9 @@
           <EntitySet Name="COLOR_CATALOGS_GROUPS" EntityType="Self.COLOR_CATALOGS_GROUPS" Schema="dbo" store:Type="Tables" />
           <EntitySet Name="COLOR_CATALOGS_ITEMS" EntityType="Self.COLOR_CATALOGS_ITEMS" Schema="dbo" store:Type="Tables" />
           <EntitySet Name="COLOR_CATALOGS_ITEMS_RECIPES" EntityType="Self.COLOR_CATALOGS_ITEMS_RECIPES" Schema="dbo" store:Type="Tables" />
+          <EntitySet Name="COLOR_PROCESS_DATA" EntityType="Self.COLOR_PROCESS_DATA" Schema="dbo" store:Type="Tables" />
+          <EntitySet Name="COLOR_PROCESS_FACTOR" EntityType="Self.COLOR_PROCESS_FACTOR" Schema="dbo" store:Type="Tables" />
+          <EntitySet Name="COLOR_PROCESS_PARAMETERS" EntityType="Self.COLOR_PROCESS_PARAMETERS" Schema="dbo" store:Type="Tables" />
           <EntitySet Name="COLOR_SPACES" EntityType="Self.COLOR_SPACES" Schema="dbo" store:Type="Tables" />
           <EntitySet Name="CONFIGURATIONS" EntityType="Self.CONFIGURATIONS" Schema="dbo" store:Type="Tables" />
           <EntitySet Name="CONTACTS" EntityType="Self.CONTACTS" Schema="dbo" store:Type="Tables" />
@@ -2668,6 +3107,20 @@
           <EntitySet Name="USERS" EntityType="Self.USERS" Schema="dbo" store:Type="Tables" />
           <EntitySet Name="USERS_ROLES" EntityType="Self.USERS_ROLES" Schema="dbo" store:Type="Tables" />
           <EntitySet Name="WINDING_METHODS" EntityType="Self.WINDING_METHODS" Schema="dbo" store:Type="Tables" />
+          <EntitySet Name="YARN_APPLICATIONS" EntityType="Self.YARN_APPLICATIONS" Schema="dbo" store:Type="Tables" />
+          <EntitySet Name="YARN_BRAND" EntityType="Self.YARN_BRAND" Schema="dbo" store:Type="Tables" />
+          <EntitySet Name="YARN_COLOR" EntityType="Self.YARN_COLOR" Schema="dbo" store:Type="Tables" />
+          <EntitySet Name="YARN_END_USE" EntityType="Self.YARN_END_USE" Schema="dbo" store:Type="Tables" />
+          <EntitySet Name="YARN_FAMILY" EntityType="Self.YARN_FAMILY" Schema="dbo" store:Type="Tables" />
+          <EntitySet Name="YARN_GEOMETRY" EntityType="Self.YARN_GEOMETRY" Schema="dbo" store:Type="Tables" />
+          <EntitySet Name="YARN_GLOSS_LEVEL" EntityType="Self.YARN_GLOSS_LEVEL" Schema="dbo" store:Type="Tables" />
+          <EntitySet Name="YARN_GROUP" EntityType="Self.YARN_GROUP" Schema="dbo" store:Type="Tables" />
+          <EntitySet Name="YARN_INDUSTRYSECTOR" EntityType="Self.YARN_INDUSTRYSECTOR" Schema="dbo" store:Type="Tables" />
+          <EntitySet Name="YARN_MANUFACTURER" EntityType="Self.YARN_MANUFACTURER" Schema="dbo" store:Type="Tables" />
+          <EntitySet Name="YARN_MATERIALS" EntityType="Self.YARN_MATERIALS" Schema="dbo" store:Type="Tables" />
+          <EntitySet Name="YARN_SUB_FAMILY" EntityType="Self.YARN_SUB_FAMILY" Schema="dbo" store:Type="Tables" />
+          <EntitySet Name="YARN_TEXTURING" EntityType="Self.YARN_TEXTURING" Schema="dbo" store:Type="Tables" />
+          <EntitySet Name="YARN_TYPE" EntityType="Self.YARN_TYPE" Schema="dbo" store:Type="Tables" />
           <AssociationSet Name="FK_ACTION_LOGS_USERS" Association="Self.FK_ACTION_LOGS_USERS">
             <End Role="USERS" EntitySet="USERS" />
             <End Role="ACTION_LOGS" EntitySet="ACTION_LOGS" />
@@ -2716,6 +3169,18 @@
             <End Role="RMLS" EntitySet="RMLS" />
             <End Role="COLOR_CATALOGS_ITEMS_RECIPES" EntitySet="COLOR_CATALOGS_ITEMS_RECIPES" />
           </AssociationSet>
+          <AssociationSet Name="FK_COLOR_PROCESS_DATA_COLOR_PROCESS_PARAMETERS" Association="Self.FK_COLOR_PROCESS_DATA_COLOR_PROCESS_PARAMETERS">
+            <End Role="COLOR_PROCESS_PARAMETERS" EntitySet="COLOR_PROCESS_PARAMETERS" />
+            <End Role="COLOR_PROCESS_DATA" EntitySet="COLOR_PROCESS_DATA" />
+          </AssociationSet>
+          <AssociationSet Name="FK_COLOR_PROCESS_FACTOR_COLOR_PROCESS_PARAMETERS" Association="Self.FK_COLOR_PROCESS_FACTOR_COLOR_PROCESS_PARAMETERS">
+            <End Role="COLOR_PROCESS_PARAMETERS" EntitySet="COLOR_PROCESS_PARAMETERS" />
+            <End Role="COLOR_PROCESS_FACTOR" EntitySet="COLOR_PROCESS_FACTOR" />
+          </AssociationSet>
+          <AssociationSet Name="FK_COLOR_PROCESS_PARAMETERS_RMLS_EXTENSIONS" Association="Self.FK_COLOR_PROCESS_PARAMETERS_RMLS_EXTENSIONS">
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+            <End Role="COLOR_PROCESS_PARAMETERS" EntitySet="COLOR_PROCESS_PARAMETERS" />
+          </AssociationSet>
           <AssociationSet Name="FK_CONFIGURATIONS_APPLICATION_DISPLAY_PANEL_VERSIONS" Association="Self.FK_CONFIGURATIONS_APPLICATION_DISPLAY_PANEL_VERSIONS">
             <End Role="APPLICATION_DISPLAY_PANEL_VERSIONS" EntitySet="APPLICATION_DISPLAY_PANEL_VERSIONS" />
             <End Role="CONFIGURATIONS" EntitySet="CONFIGURATIONS" />
@@ -2956,6 +3421,70 @@
             <End Role="CCTS" EntitySet="CCTS" />
             <End Role="RMLS" EntitySet="RMLS" />
           </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_RMLS" Association="Self.FK_RMLS_EXTENSIONS_RMLS">
+            <End Role="RMLS" EntitySet="RMLS" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_USERS" Association="Self.FK_RMLS_EXTENSIONS_USERS">
+            <End Role="USERS" EntitySet="USERS" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_APPLICATIONS" Association="Self.FK_RMLS_EXTENSIONS_YARN_APPLICATIONS">
+            <End Role="YARN_APPLICATIONS" EntitySet="YARN_APPLICATIONS" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_BRAND" Association="Self.FK_RMLS_EXTENSIONS_YARN_BRAND">
+            <End Role="YARN_BRAND" EntitySet="YARN_BRAND" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_COLOR" Association="Self.FK_RMLS_EXTENSIONS_YARN_COLOR">
+            <End Role="YARN_COLOR" EntitySet="YARN_COLOR" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_END_USE" Association="Self.FK_RMLS_EXTENSIONS_YARN_END_USE">
+            <End Role="YARN_END_USE" EntitySet="YARN_END_USE" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_FAMILY" Association="Self.FK_RMLS_EXTENSIONS_YARN_FAMILY">
+            <End Role="YARN_FAMILY" EntitySet="YARN_FAMILY" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_GEOMETRY" Association="Self.FK_RMLS_EXTENSIONS_YARN_GEOMETRY">
+            <End Role="YARN_GEOMETRY" EntitySet="YARN_GEOMETRY" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_GLOSS_LEVEL" Association="Self.FK_RMLS_EXTENSIONS_YARN_GLOSS_LEVEL">
+            <End Role="YARN_GLOSS_LEVEL" EntitySet="YARN_GLOSS_LEVEL" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_GROUP" Association="Self.FK_RMLS_EXTENSIONS_YARN_GROUP">
+            <End Role="YARN_GROUP" EntitySet="YARN_GROUP" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_INDUSTRYSECTOR" Association="Self.FK_RMLS_EXTENSIONS_YARN_INDUSTRYSECTOR">
+            <End Role="YARN_INDUSTRYSECTOR" EntitySet="YARN_INDUSTRYSECTOR" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_MANUFACTURER" Association="Self.FK_RMLS_EXTENSIONS_YARN_MANUFACTURER">
+            <End Role="YARN_MANUFACTURER" EntitySet="YARN_MANUFACTURER" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_MATERIALS" Association="Self.FK_RMLS_EXTENSIONS_YARN_MATERIALS">
+            <End Role="YARN_MATERIALS" EntitySet="YARN_MATERIALS" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_SUB_FAMILY" Association="Self.FK_RMLS_EXTENSIONS_YARN_SUB_FAMILY">
+            <End Role="YARN_SUB_FAMILY" EntitySet="YARN_SUB_FAMILY" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_TEXTURING" Association="Self.FK_RMLS_EXTENSIONS_YARN_TEXTURING">
+            <End Role="YARN_TEXTURING" EntitySet="YARN_TEXTURING" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_TYPE" Association="Self.FK_RMLS_EXTENSIONS_YARN_TYPE">
+            <End Role="YARN_TYPE" EntitySet="YARN_TYPE" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
           <AssociationSet Name="FK_RMLS_SPOOLS_RMLS" Association="Self.FK_RMLS_SPOOLS_RMLS">
             <End Role="RMLS" EntitySet="RMLS" />
             <End Role="RMLS_SPOOLS" EntitySet="RMLS_SPOOLS" />
@@ -3055,6 +3584,9 @@
           <EntitySet Name="COLOR_CATALOGS_GROUPS" EntityType="RemoteModel.COLOR_CATALOGS_GROUPS" />
           <EntitySet Name="COLOR_CATALOGS_ITEMS" EntityType="RemoteModel.COLOR_CATALOGS_ITEMS" />
           <EntitySet Name="COLOR_CATALOGS_ITEMS_RECIPES" EntityType="RemoteModel.COLOR_CATALOGS_ITEMS_RECIPES" />
+          <EntitySet Name="COLOR_PROCESS_DATA" EntityType="RemoteModel.COLOR_PROCESS_DATA" />
+          <EntitySet Name="COLOR_PROCESS_FACTOR" EntityType="RemoteModel.COLOR_PROCESS_FACTOR" />
+          <EntitySet Name="COLOR_PROCESS_PARAMETERS" EntityType="RemoteModel.COLOR_PROCESS_PARAMETERS" />
           <EntitySet Name="COLOR_SPACES" EntityType="RemoteModel.COLOR_SPACES" />
           <EntitySet Name="CONFIGURATIONS" EntityType="RemoteModel.CONFIGURATION" />
           <EntitySet Name="CONTACTS" EntityType="RemoteModel.CONTACT" />
@@ -3128,6 +3660,20 @@
           <EntitySet Name="USERS" EntityType="RemoteModel.USER" />
           <EntitySet Name="USERS_ROLES" EntityType="RemoteModel.USERS_ROLES" />
           <EntitySet Name="WINDING_METHODS" EntityType="RemoteModel.WINDING_METHODS" />
+          <EntitySet Name="YARN_APPLICATIONS" EntityType="RemoteModel.YARN_APPLICATIONS" />
+          <EntitySet Name="YARN_BRAND" EntityType="RemoteModel.YARN_BRAND" />
+          <EntitySet Name="YARN_COLOR" EntityType="RemoteModel.YARN_COLOR" />
+          <EntitySet Name="YARN_END_USE" EntityType="RemoteModel.YARN_END_USE" />
+          <EntitySet Name="YARN_FAMILY" EntityType="RemoteModel.YARN_FAMILY" />
+          <EntitySet Name="YARN_GEOMETRY" EntityType="RemoteModel.YARN_GEOMETRY" />
+          <EntitySet Name="YARN_GLOSS_LEVEL" EntityType="RemoteModel.YARN_GLOSS_LEVEL" />
+          <EntitySet Name="YARN_GROUP" EntityType="RemoteModel.YARN_GROUP" />
+          <EntitySet Name="YARN_INDUSTRYSECTOR" EntityType="RemoteModel.YARN_INDUSTRYSECTOR" />
+          <EntitySet Name="YARN_MANUFACTURER" EntityType="RemoteModel.YARN_MANUFACTURER" />
+          <EntitySet Name="YARN_MATERIALS" EntityType="RemoteModel.YARN_MATERIALS" />
+          <EntitySet Name="YARN_SUB_FAMILY" EntityType="RemoteModel.YARN_SUB_FAMILY" />
+          <EntitySet Name="YARN_TEXTURING" EntityType="RemoteModel.YARN_TEXTURING" />
+          <EntitySet Name="YARN_TYPE" EntityType="RemoteModel.YARN_TYPE" />
           <AssociationSet Name="FK_ACTION_LOGS_USERS" Association="RemoteModel.FK_ACTION_LOGS_USERS">
             <End Role="USER" EntitySet="USERS" />
             <End Role="ACTION_LOGS" EntitySet="ACTION_LOGS" />
@@ -3220,6 +3766,18 @@
             <End Role="RML" EntitySet="RMLS" />
             <End Role="COLOR_CATALOGS_ITEMS_RECIPES" EntitySet="COLOR_CATALOGS_ITEMS_RECIPES" />
           </AssociationSet>
+          <AssociationSet Name="FK_COLOR_PROCESS_DATA_COLOR_PROCESS_PARAMETERS" Association="RemoteModel.FK_COLOR_PROCESS_DATA_COLOR_PROCESS_PARAMETERS">
+            <End Role="COLOR_PROCESS_PARAMETERS" EntitySet="COLOR_PROCESS_PARAMETERS" />
+            <End Role="COLOR_PROCESS_DATA" EntitySet="COLOR_PROCESS_DATA" />
+          </AssociationSet>
+          <AssociationSet Name="FK_COLOR_PROCESS_FACTOR_COLOR_PROCESS_PARAMETERS" Association="RemoteModel.FK_COLOR_PROCESS_FACTOR_COLOR_PROCESS_PARAMETERS">
+            <End Role="COLOR_PROCESS_PARAMETERS" EntitySet="COLOR_PROCESS_PARAMETERS" />
+            <End Role="COLOR_PROCESS_FACTOR" EntitySet="COLOR_PROCESS_FACTOR" />
+          </AssociationSet>
+          <AssociationSet Name="FK_COLOR_PROCESS_PARAMETERS_RMLS_EXTENSIONS" Association="RemoteModel.FK_COLOR_PROCESS_PARAMETERS_RMLS_EXTENSIONS">
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+            <End Role="COLOR_PROCESS_PARAMETERS" EntitySet="COLOR_PROCESS_PARAMETERS" />
+          </AssociationSet>
           <AssociationSet Name="FK_JOBS_COLOR_SPACES" Association="RemoteModel.FK_JOBS_COLOR_SPACES">
             <End Role="COLOR_SPACES" EntitySet="COLOR_SPACES" />
             <End Role="JOB" EntitySet="JOBS" />
@@ -3452,6 +4010,10 @@
             <End Role="PUBLISHED_PROCEDURE_PROJECTS" EntitySet="PUBLISHED_PROCEDURE_PROJECTS" />
             <End Role="PUBLISHED_PROCEDURE_PROJECTS_VERSIONS" EntitySet="PUBLISHED_PROCEDURE_PROJECTS_VERSIONS" />
           </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_RMLS" Association="RemoteModel.FK_RMLS_EXTENSIONS_RMLS">
+            <End Role="RML" EntitySet="RMLS" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
           <AssociationSet Name="FK_RMLS_SPOOLS_RMLS" Association="RemoteModel.FK_RMLS_SPOOLS_RMLS">
             <End Role="RML" EntitySet="RMLS" />
             <End Role="RMLS_SPOOLS" EntitySet="RMLS_SPOOLS" />
@@ -3460,6 +4022,66 @@
             <End Role="RML" EntitySet="RMLS" />
             <End Role="SITES_RMLS" EntitySet="SITES_RMLS" />
           </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_USERS" Association="RemoteModel.FK_RMLS_EXTENSIONS_USERS">
+            <End Role="USER" EntitySet="USERS" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_APPLICATIONS" Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_APPLICATIONS">
+            <End Role="YARN_APPLICATIONS" EntitySet="YARN_APPLICATIONS" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_BRAND" Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_BRAND">
+            <End Role="YARN_BRAND" EntitySet="YARN_BRAND" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_COLOR" Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_COLOR">
+            <End Role="YARN_COLOR" EntitySet="YARN_COLOR" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_END_USE" Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_END_USE">
+            <End Role="YARN_END_USE" EntitySet="YARN_END_USE" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_FAMILY" Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_FAMILY">
+            <End Role="YARN_FAMILY" EntitySet="YARN_FAMILY" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_GEOMETRY" Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_GEOMETRY">
+            <End Role="YARN_GEOMETRY" EntitySet="YARN_GEOMETRY" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_GLOSS_LEVEL" Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_GLOSS_LEVEL">
+            <End Role="YARN_GLOSS_LEVEL" EntitySet="YARN_GLOSS_LEVEL" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_GROUP" Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_GROUP">
+            <End Role="YARN_GROUP" EntitySet="YARN_GROUP" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_INDUSTRYSECTOR" Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_INDUSTRYSECTOR">
+            <End Role="YARN_INDUSTRYSECTOR" EntitySet="YARN_INDUSTRYSECTOR" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_MANUFACTURER" Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_MANUFACTURER">
+            <End Role="YARN_MANUFACTURER" EntitySet="YARN_MANUFACTURER" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_MATERIALS" Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_MATERIALS">
+            <End Role="YARN_MATERIALS" EntitySet="YARN_MATERIALS" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_SUB_FAMILY" Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_SUB_FAMILY">
+            <End Role="YARN_SUB_FAMILY" EntitySet="YARN_SUB_FAMILY" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_TEXTURING" Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_TEXTURING">
+            <End Role="YARN_TEXTURING" EntitySet="YARN_TEXTURING" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_EXTENSIONS_YARN_TYPE" Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_TYPE">
+            <End Role="YARN_TYPE" EntitySet="YARN_TYPE" />
+            <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" />
+          </AssociationSet>
           <AssociationSet Name="FK_RMLS_SPOOLS_SPOOL_TYPES" Association="RemoteModel.FK_RMLS_SPOOLS_SPOOL_TYPES">
             <End Role="SPOOL_TYPES" EntitySet="SPOOL_TYPES" />
             <End Role="RMLS_SPOOLS" EntitySet="RMLS_SPOOLS" />
@@ -3767,6 +4389,52 @@
           <NavigationProperty Name="COLOR_CATALOGS_ITEMS" Relationship="RemoteModel.FK_COLOR_CATALOGS_ITEMS_RECIPES_COLOR_CATALOGS_ITEMS" FromRole="COLOR_CATALOGS_ITEMS_RECIPES" ToRole="COLOR_CATALOGS_ITEMS" />
           <NavigationProperty Name="RML" Relationship="RemoteModel.FK_COLOR_CATALOGS_ITEMS_RECIPES_RMLS" FromRole="COLOR_CATALOGS_ITEMS_RECIPES" ToRole="RML" />
         </EntityType>
+        <EntityType Name="COLOR_PROCESS_DATA">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+          <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" />
+          <Property Name="COLOR_PROCESS_PARAMETERS_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="COLOR_NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
+          <Property Name="INK_NL_CM" Type="Int32" Nullable="false" />
+          <Property Name="L" Type="Double" Nullable="false" />
+          <Property Name="A" Type="Double" Nullable="false" />
+          <Property Name="B" Type="Double" Nullable="false" />
+          <NavigationProperty Name="COLOR_PROCESS_PARAMETERS" Relationship="RemoteModel.FK_COLOR_PROCESS_DATA_COLOR_PROCESS_PARAMETERS" FromRole="COLOR_PROCESS_DATA" ToRole="COLOR_PROCESS_PARAMETERS" />
+        </EntityType>
+        <EntityType Name="COLOR_PROCESS_FACTOR">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+          <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" />
+          <Property Name="COLOR_PROCESS_PARAMETERS_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="COLOR_NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
+          <Property Name="INK_NL_CM" Type="Int32" Nullable="false" />
+          <Property Name="L" Type="Double" Nullable="false" />
+          <Property Name="A" Type="Double" Nullable="false" />
+          <Property Name="B" Type="Double" Nullable="false" />
+          <Property Name="FACTOR_PERCENT" Type="Int32" Nullable="false" />
+          <NavigationProperty Name="COLOR_PROCESS_PARAMETERS" Relationship="RemoteModel.FK_COLOR_PROCESS_FACTOR_COLOR_PROCESS_PARAMETERS" FromRole="COLOR_PROCESS_FACTOR" ToRole="COLOR_PROCESS_PARAMETERS" />
+        </EntityType>
+        <EntityType Name="COLOR_PROCESS_PARAMETERS">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+          <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" />
+          <Property Name="RMLS_EXTENSIONS_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="WHITE_POINT_L" Type="Double" Nullable="false" />
+          <Property Name="WHITE_POINT_A" Type="Double" Nullable="false" />
+          <Property Name="WHITE_POINT_B" Type="Double" Nullable="false" />
+          <NavigationProperty Name="COLOR_PROCESS_DATA" Relationship="RemoteModel.FK_COLOR_PROCESS_DATA_COLOR_PROCESS_PARAMETERS" FromRole="COLOR_PROCESS_PARAMETERS" ToRole="COLOR_PROCESS_DATA" />
+          <NavigationProperty Name="COLOR_PROCESS_FACTOR" Relationship="RemoteModel.FK_COLOR_PROCESS_FACTOR_COLOR_PROCESS_PARAMETERS" FromRole="COLOR_PROCESS_PARAMETERS" ToRole="COLOR_PROCESS_FACTOR" />
+          <NavigationProperty Name="RMLS_EXTENSIONS" Relationship="RemoteModel.FK_COLOR_PROCESS_PARAMETERS_RMLS_EXTENSIONS" FromRole="COLOR_PROCESS_PARAMETERS" ToRole="RMLS_EXTENSIONS" />
+        </EntityType>
         <EntityType Name="COLOR_SPACES">
           <Key>
             <PropertyRef Name="GUID" />
@@ -4731,6 +5399,7 @@
           <NavigationProperty Name="MEDIA_MATERIALS" Relationship="RemoteModel.FK_RML_MEDIA_MATERIALS" FromRole="RML" ToRole="MEDIA_MATERIALS" />
           <NavigationProperty Name="MEDIA_PURPOSES" Relationship="RemoteModel.FK_RML_MEDIA_PURPOSES" FromRole="RML" ToRole="MEDIA_PURPOSES" />
           <NavigationProperty Name="PROCESS_PARAMETERS_TABLES_GROUPS" Relationship="RemoteModel.FK_PROCESS_PARAMETERS_TABLES_GROUPS_RMLS" FromRole="RML" ToRole="PROCESS_PARAMETERS_TABLES_GROUPS" />
+          <NavigationProperty Name="RMLS_EXTENSIONS" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_RMLS" FromRole="RML" ToRole="RMLS_EXTENSIONS" />
           <NavigationProperty Name="RMLS_SPOOLS" Relationship="RemoteModel.FK_RMLS_SPOOLS_RMLS" FromRole="RML" ToRole="RMLS_SPOOLS" />
           <NavigationProperty Name="SITES_RMLS" Relationship="RemoteModel.FK_SITES_RMLS_RMLS" FromRole="RML" ToRole="SITES_RMLS" />
         </EntityType>
@@ -4741,8 +5410,58 @@
           <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
           <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
           <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" />
-          <Property Name="NAME" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
-          <Property Name="DESCRIPTION" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
+          <Property Name="RML_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="USER_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="CREATED" Type="DateTime" Nullable="false" Precision="3" />
+          <Property Name="YARN_MANUFACTURER_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="YARN_BRAND_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="COUNTRY" Type="String" MaxLength="60" FixedLength="false" Unicode="false" />
+          <Property Name="YARN_END_USE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="YARN_APPLICATIONS_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="YARN_INDUSTRYSECTOR_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="YARN_MATERIAL_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="YARN_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="YARN_FAMILY_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="YARN_SUB_FAMILY_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="YARN_GROUP_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="YARN_TEXTURING_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="YARN_GEOMETRY_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="YARN_COLOR_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="YARN_GLOSS_LEVEL_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="LINEAR_DENSITY" Type="Int32" Nullable="false" />
+          <Property Name="UNIT" Type="Int32" Nullable="false" />
+          <Property Name="PLIES" Type="Int32" Nullable="false" />
+          <Property Name="FILAMENT_COUNT" Type="Int32" Nullable="false" />
+          <Property Name="TWIST_TPM" Type="Int32" Nullable="false" />
+          <Property Name="TWIST_DIRECTION" Type="Int32" />
+          <Property Name="MIN_ELONGATION" Type="Double" />
+          <Property Name="MAX_ELONGATION" Type="Double" />
+          <Property Name="MIN_MAX_FORCE_N" Type="Double" />
+          <Property Name="MAX_MAX_FORCE_N" Type="Double" />
+          <Property Name="MIN_ELASTICITY" Type="Double" />
+          <Property Name="MAX_ELASTICITY" Type="Double" />
+          <Property Name="MIN_TENACITY" Type="Double" />
+          <Property Name="MAX_TENACITY" Type="Double" />
+          <Property Name="FINISHING" Type="String" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="FILE_NAME" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
+          <Property Name="DATA" Type="Binary" MaxLength="Max" FixedLength="false" />
+          <NavigationProperty Name="COLOR_PROCESS_PARAMETERS" Relationship="RemoteModel.FK_COLOR_PROCESS_PARAMETERS_RMLS_EXTENSIONS" FromRole="RMLS_EXTENSIONS" ToRole="COLOR_PROCESS_PARAMETERS" />
+          <NavigationProperty Name="RML" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_RMLS" FromRole="RMLS_EXTENSIONS" ToRole="RML" />
+          <NavigationProperty Name="USER" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_USERS" FromRole="RMLS_EXTENSIONS" ToRole="USER" />
+          <NavigationProperty Name="YARN_APPLICATIONS" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_APPLICATIONS" FromRole="RMLS_EXTENSIONS" ToRole="YARN_APPLICATIONS" />
+          <NavigationProperty Name="YARN_BRAND" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_BRAND" FromRole="RMLS_EXTENSIONS" ToRole="YARN_BRAND" />
+          <NavigationProperty Name="YARN_COLOR" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_COLOR" FromRole="RMLS_EXTENSIONS" ToRole="YARN_COLOR" />
+          <NavigationProperty Name="YARN_END_USE" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_END_USE" FromRole="RMLS_EXTENSIONS" ToRole="YARN_END_USE" />
+          <NavigationProperty Name="YARN_FAMILY" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_FAMILY" FromRole="RMLS_EXTENSIONS" ToRole="YARN_FAMILY" />
+          <NavigationProperty Name="YARN_GEOMETRY" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_GEOMETRY" FromRole="RMLS_EXTENSIONS" ToRole="YARN_GEOMETRY" />
+          <NavigationProperty Name="YARN_GLOSS_LEVEL" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_GLOSS_LEVEL" FromRole="RMLS_EXTENSIONS" ToRole="YARN_GLOSS_LEVEL" />
+          <NavigationProperty Name="YARN_GROUP" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_GROUP" FromRole="RMLS_EXTENSIONS" ToRole="YARN_GROUP" />
+          <NavigationProperty Name="YARN_INDUSTRYSECTOR" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_INDUSTRYSECTOR" FromRole="RMLS_EXTENSIONS" ToRole="YARN_INDUSTRYSECTOR" />
+          <NavigationProperty Name="YARN_MANUFACTURER" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_MANUFACTURER" FromRole="RMLS_EXTENSIONS" ToRole="YARN_MANUFACTURER" />
+          <NavigationProperty Name="YARN_MATERIALS" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_MATERIALS" FromRole="RMLS_EXTENSIONS" ToRole="YARN_MATERIALS" />
+          <NavigationProperty Name="YARN_SUB_FAMILY" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_SUB_FAMILY" FromRole="RMLS_EXTENSIONS" ToRole="YARN_SUB_FAMILY" />
+          <NavigationProperty Name="YARN_TEXTURING" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_TEXTURING" FromRole="RMLS_EXTENSIONS" ToRole="YARN_TEXTURING" />
+          <NavigationProperty Name="YARN_TYPE" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_TYPE" FromRole="RMLS_EXTENSIONS" ToRole="YARN_TYPE" />
         </EntityType>
         <EntityType Name="RMLS_SPOOLS">
           <Key>
@@ -5032,6 +5751,7 @@
           <NavigationProperty Name="MACHINE_STUDIO_VERSIONS" Relationship="RemoteModel.FK_MACHINE_STUDIO_VERSIONS_USERS" FromRole="USER" ToRole="MACHINE_STUDIO_VERSIONS" />
           <NavigationProperty Name="MACHINES_EVENTS" Relationship="RemoteModel.FK_MACHINES_EVENTS_USERS" FromRole="USER" ToRole="MACHINES_EVENTS" />
           <NavigationProperty Name="ORGANIZATION" Relationship="RemoteModel.FK_USERS_ORGANIZATIONS" FromRole="USER" ToRole="ORGANIZATION" />
+          <NavigationProperty Name="RMLS_EXTENSIONS" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_USERS" FromRole="USER" ToRole="RMLS_EXTENSIONS" />
           <NavigationProperty Name="TANGO_VERSIONS" Relationship="RemoteModel.FK_TANGO_VERSIONS_USERS" FromRole="USER" ToRole="TANGO_VERSIONS" />
           <NavigationProperty Name="USERS_ROLES" Relationship="RemoteModel.FK_USERS_ROLES_USERS" FromRole="USER" ToRole="USERS_ROLES" />
         </EntityType>
@@ -5059,6 +5779,146 @@
           <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
           <NavigationProperty Name="JOBS" Relationship="RemoteModel.FK_JOBS_WINDING_METHODS" FromRole="WINDING_METHODS" ToRole="JOB" />
         </EntityType>
+        <EntityType Name="YARN_APPLICATIONS">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+          <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" />
+          <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
+          <NavigationProperty Name="RMLS_EXTENSIONS" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_APPLICATIONS" FromRole="YARN_APPLICATIONS" ToRole="RMLS_EXTENSIONS" />
+        </EntityType>
+        <EntityType Name="YARN_BRAND">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+          <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" />
+          <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
+          <NavigationProperty Name="RMLS_EXTENSIONS" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_BRAND" FromRole="YARN_BRAND" ToRole="RMLS_EXTENSIONS" />
+        </EntityType>
+        <EntityType Name="YARN_COLOR">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+          <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" />
+          <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
+          <NavigationProperty Name="RMLS_EXTENSIONS" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_COLOR" FromRole="YARN_COLOR" ToRole="RMLS_EXTENSIONS" />
+        </EntityType>
+        <EntityType Name="YARN_END_USE">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+          <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" />
+          <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
+          <NavigationProperty Name="RMLS_EXTENSIONS" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_END_USE" FromRole="YARN_END_USE" ToRole="RMLS_EXTENSIONS" />
+        </EntityType>
+        <EntityType Name="YARN_FAMILY">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+          <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" />
+          <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
+          <NavigationProperty Name="RMLS_EXTENSIONS" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_FAMILY" FromRole="YARN_FAMILY" ToRole="RMLS_EXTENSIONS" />
+        </EntityType>
+        <EntityType Name="YARN_GEOMETRY">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+          <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" />
+          <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
+          <NavigationProperty Name="RMLS_EXTENSIONS" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_GEOMETRY" FromRole="YARN_GEOMETRY" ToRole="RMLS_EXTENSIONS" />
+        </EntityType>
+        <EntityType Name="YARN_GLOSS_LEVEL">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+          <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" />
+          <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
+          <NavigationProperty Name="RMLS_EXTENSIONS" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_GLOSS_LEVEL" FromRole="YARN_GLOSS_LEVEL" ToRole="RMLS_EXTENSIONS" />
+        </EntityType>
+        <EntityType Name="YARN_GROUP">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+          <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" />
+          <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
+          <NavigationProperty Name="RMLS_EXTENSIONS" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_GROUP" FromRole="YARN_GROUP" ToRole="RMLS_EXTENSIONS" />
+        </EntityType>
+        <EntityType Name="YARN_INDUSTRYSECTOR">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+          <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" />
+          <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
+          <NavigationProperty Name="RMLS_EXTENSIONS" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_INDUSTRYSECTOR" FromRole="YARN_INDUSTRYSECTOR" ToRole="RMLS_EXTENSIONS" />
+        </EntityType>
+        <EntityType Name="YARN_MANUFACTURER">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+          <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" />
+          <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
+          <NavigationProperty Name="RMLS_EXTENSIONS" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_MANUFACTURER" FromRole="YARN_MANUFACTURER" ToRole="RMLS_EXTENSIONS" />
+        </EntityType>
+        <EntityType Name="YARN_MATERIALS">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+          <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" />
+          <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
+          <NavigationProperty Name="RMLS_EXTENSIONS" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_MATERIALS" FromRole="YARN_MATERIALS" ToRole="RMLS_EXTENSIONS" />
+        </EntityType>
+        <EntityType Name="YARN_SUB_FAMILY">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+          <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" />
+          <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
+          <NavigationProperty Name="RMLS_EXTENSIONS" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_SUB_FAMILY" FromRole="YARN_SUB_FAMILY" ToRole="RMLS_EXTENSIONS" />
+        </EntityType>
+        <EntityType Name="YARN_TEXTURING">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+          <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" />
+          <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
+          <NavigationProperty Name="RMLS_EXTENSIONS" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_TEXTURING" FromRole="YARN_TEXTURING" ToRole="RMLS_EXTENSIONS" />
+        </EntityType>
+        <EntityType Name="YARN_TYPE">
+          <Key>
+            <PropertyRef Name="GUID" />
+          </Key>
+          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+          <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" />
+          <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
+          <NavigationProperty Name="RMLS_EXTENSIONS" Relationship="RemoteModel.FK_RMLS_EXTENSIONS_YARN_TYPE" FromRole="YARN_TYPE" ToRole="RMLS_EXTENSIONS" />
+        </EntityType>
         <Association Name="FK_ACTION_LOGS_USERS">
           <End Type="RemoteModel.USER" Role="USER" Multiplicity="0..1" />
           <End Type="RemoteModel.ACTION_LOGS" Role="ACTION_LOGS" Multiplicity="*" />
@@ -5355,6 +6215,48 @@
             </Dependent>
           </ReferentialConstraint>
         </Association>
+        <Association Name="FK_COLOR_PROCESS_DATA_COLOR_PROCESS_PARAMETERS">
+          <End Type="RemoteModel.COLOR_PROCESS_PARAMETERS" Role="COLOR_PROCESS_PARAMETERS" Multiplicity="1">
+            <OnDelete Action="Cascade" />
+          </End>
+          <End Type="RemoteModel.COLOR_PROCESS_DATA" Role="COLOR_PROCESS_DATA" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="COLOR_PROCESS_PARAMETERS">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="COLOR_PROCESS_DATA">
+              <PropertyRef Name="COLOR_PROCESS_PARAMETERS_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_COLOR_PROCESS_FACTOR_COLOR_PROCESS_PARAMETERS">
+          <End Type="RemoteModel.COLOR_PROCESS_PARAMETERS" Role="COLOR_PROCESS_PARAMETERS" Multiplicity="1">
+            <OnDelete Action="Cascade" />
+          </End>
+          <End Type="RemoteModel.COLOR_PROCESS_FACTOR" Role="COLOR_PROCESS_FACTOR" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="COLOR_PROCESS_PARAMETERS">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="COLOR_PROCESS_FACTOR">
+              <PropertyRef Name="COLOR_PROCESS_PARAMETERS_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_COLOR_PROCESS_PARAMETERS_RMLS_EXTENSIONS">
+          <End Type="RemoteModel.RMLS_EXTENSIONS" Role="RMLS_EXTENSIONS" Multiplicity="1">
+            <OnDelete Action="Cascade" />
+          </End>
+          <End Type="RemoteModel.COLOR_PROCESS_PARAMETERS" Role="COLOR_PROCESS_PARAMETERS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="COLOR_PROCESS_PARAMETERS">
+              <PropertyRef Name="RMLS_EXTENSIONS_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
         <Association Name="FK_JOBS_COLOR_SPACES">
           <End Type="RemoteModel.COLOR_SPACES" Role="COLOR_SPACES" Multiplicity="0..1" />
           <End Type="RemoteModel.JOB" Role="JOB" Multiplicity="*" />
@@ -6109,6 +7011,20 @@
             </Dependent>
           </ReferentialConstraint>
         </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_RMLS">
+          <End Type="RemoteModel.RML" Role="RML" Multiplicity="0..1">
+            <OnDelete Action="Cascade" />
+          </End>
+          <End Type="RemoteModel.RMLS_EXTENSIONS" Role="RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="RML">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="RML_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
         <Association Name="FK_RMLS_SPOOLS_RMLS">
           <End Type="RemoteModel.RML" Role="RML" Multiplicity="1">
             <OnDelete Action="Cascade" />
@@ -6137,6 +7053,186 @@
             </Dependent>
           </ReferentialConstraint>
         </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_USERS">
+          <End Type="RemoteModel.USER" Role="USER" Multiplicity="0..1" />
+          <End Type="RemoteModel.RMLS_EXTENSIONS" Role="RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="USER">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="USER_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_APPLICATIONS">
+          <End Type="RemoteModel.YARN_APPLICATIONS" Role="YARN_APPLICATIONS" Multiplicity="1" />
+          <End Type="RemoteModel.RMLS_EXTENSIONS" Role="RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_APPLICATIONS">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_APPLICATIONS_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_BRAND">
+          <End Type="RemoteModel.YARN_BRAND" Role="YARN_BRAND" Multiplicity="0..1" />
+          <End Type="RemoteModel.RMLS_EXTENSIONS" Role="RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_BRAND">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_BRAND_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_COLOR">
+          <End Type="RemoteModel.YARN_COLOR" Role="YARN_COLOR" Multiplicity="0..1" />
+          <End Type="RemoteModel.RMLS_EXTENSIONS" Role="RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_COLOR">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_COLOR_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_END_USE">
+          <End Type="RemoteModel.YARN_END_USE" Role="YARN_END_USE" Multiplicity="1" />
+          <End Type="RemoteModel.RMLS_EXTENSIONS" Role="RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_END_USE">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_END_USE_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_FAMILY">
+          <End Type="RemoteModel.YARN_FAMILY" Role="YARN_FAMILY" Multiplicity="1" />
+          <End Type="RemoteModel.RMLS_EXTENSIONS" Role="RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_FAMILY">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_FAMILY_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_GEOMETRY">
+          <End Type="RemoteModel.YARN_GEOMETRY" Role="YARN_GEOMETRY" Multiplicity="0..1" />
+          <End Type="RemoteModel.RMLS_EXTENSIONS" Role="RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_GEOMETRY">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_GEOMETRY_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_GLOSS_LEVEL">
+          <End Type="RemoteModel.YARN_GLOSS_LEVEL" Role="YARN_GLOSS_LEVEL" Multiplicity="0..1" />
+          <End Type="RemoteModel.RMLS_EXTENSIONS" Role="RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_GLOSS_LEVEL">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_GLOSS_LEVEL_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_GROUP">
+          <End Type="RemoteModel.YARN_GROUP" Role="YARN_GROUP" Multiplicity="1" />
+          <End Type="RemoteModel.RMLS_EXTENSIONS" Role="RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_GROUP">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_GROUP_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_INDUSTRYSECTOR">
+          <End Type="RemoteModel.YARN_INDUSTRYSECTOR" Role="YARN_INDUSTRYSECTOR" Multiplicity="0..1" />
+          <End Type="RemoteModel.RMLS_EXTENSIONS" Role="RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_INDUSTRYSECTOR">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_INDUSTRYSECTOR_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_MANUFACTURER">
+          <End Type="RemoteModel.YARN_MANUFACTURER" Role="YARN_MANUFACTURER" Multiplicity="1" />
+          <End Type="RemoteModel.RMLS_EXTENSIONS" Role="RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_MANUFACTURER">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_MANUFACTURER_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_MATERIALS">
+          <End Type="RemoteModel.YARN_MATERIALS" Role="YARN_MATERIALS" Multiplicity="1" />
+          <End Type="RemoteModel.RMLS_EXTENSIONS" Role="RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_MATERIALS">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_MATERIAL_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_SUB_FAMILY">
+          <End Type="RemoteModel.YARN_SUB_FAMILY" Role="YARN_SUB_FAMILY" Multiplicity="1" />
+          <End Type="RemoteModel.RMLS_EXTENSIONS" Role="RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_SUB_FAMILY">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_SUB_FAMILY_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_TEXTURING">
+          <End Type="RemoteModel.YARN_TEXTURING" Role="YARN_TEXTURING" Multiplicity="1" />
+          <End Type="RemoteModel.RMLS_EXTENSIONS" Role="RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_TEXTURING">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_TEXTURING_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_EXTENSIONS_YARN_TYPE">
+          <End Type="RemoteModel.YARN_TYPE" Role="YARN_TYPE" Multiplicity="1" />
+          <End Type="RemoteModel.RMLS_EXTENSIONS" Role="RMLS_EXTENSIONS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="YARN_TYPE">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS_EXTENSIONS">
+              <PropertyRef Name="YARN_TYPE_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
         <Association Name="FK_RMLS_SPOOLS_SPOOL_TYPES">
           <End Type="RemoteModel.SPOOL_TYPES" Role="SPOOL_TYPES" Multiplicity="1">
             <OnDelete Action="Cascade" />
@@ -6516,6 +7612,50 @@
               </MappingFragment>
             </EntityTypeMapping>
           </EntitySetMapping>
+          <EntitySetMapping Name="COLOR_PROCESS_DATA">
+            <EntityTypeMapping TypeName="RemoteModel.COLOR_PROCESS_DATA">
+              <MappingFragment StoreEntitySet="COLOR_PROCESS_DATA">
+                <ScalarProperty Name="B" ColumnName="B" />
+                <ScalarProperty Name="A" ColumnName="A" />
+                <ScalarProperty Name="L" ColumnName="L" />
+                <ScalarProperty Name="INK_NL_CM" ColumnName="INK_NL_CM" />
+                <ScalarProperty Name="COLOR_NAME" ColumnName="COLOR_NAME" />
+                <ScalarProperty Name="COLOR_PROCESS_PARAMETERS_GUID" ColumnName="COLOR_PROCESS_PARAMETERS_GUID" />
+                <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
+                <ScalarProperty Name="GUID" ColumnName="GUID" />
+                <ScalarProperty Name="ID" ColumnName="ID" />
+              </MappingFragment>
+            </EntityTypeMapping>
+          </EntitySetMapping>
+          <EntitySetMapping Name="COLOR_PROCESS_FACTOR">
+            <EntityTypeMapping TypeName="RemoteModel.COLOR_PROCESS_FACTOR">
+              <MappingFragment StoreEntitySet="COLOR_PROCESS_FACTOR">
+                <ScalarProperty Name="FACTOR_PERCENT" ColumnName="FACTOR_PERCENT" />
+                <ScalarProperty Name="B" ColumnName="B" />
+                <ScalarProperty Name="A" ColumnName="A" />
+                <ScalarProperty Name="L" ColumnName="L" />
+                <ScalarProperty Name="INK_NL_CM" ColumnName="INK_NL_CM" />
+                <ScalarProperty Name="COLOR_NAME" ColumnName="COLOR_NAME" />
+                <ScalarProperty Name="COLOR_PROCESS_PARAMETERS_GUID" ColumnName="COLOR_PROCESS_PARAMETERS_GUID" />
+                <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
+                <ScalarProperty Name="GUID" ColumnName="GUID" />
+                <ScalarProperty Name="ID" ColumnName="ID" />
+              </MappingFragment>
+            </EntityTypeMapping>
+          </EntitySetMapping>
+          <EntitySetMapping Name="COLOR_PROCESS_PARAMETERS">
+            <EntityTypeMapping TypeName="RemoteModel.COLOR_PROCESS_PARAMETERS">
+              <MappingFragment StoreEntitySet="COLOR_PROCESS_PARAMETERS">
+                <ScalarProperty Name="WHITE_POINT_B" ColumnName="WHITE_POINT_B" />
+                <ScalarProperty Name="WHITE_POINT_A" ColumnName="WHITE_POINT_A" />
+                <ScalarProperty Name="WHITE_POINT_L" ColumnName="WHITE_POINT_L" />
+                <ScalarProperty Name="RMLS_EXTENSIONS_GUID" ColumnName="RMLS_EXTENSIONS_GUID" />
+                <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
+                <ScalarProperty Name="GUID" ColumnName="GUID" />
+                <ScalarProperty Name="ID" ColumnName="ID" />
+              </MappingFragment>
+            </EntityTypeMapping>
+          </EntitySetMapping>
           <EntitySetMapping Name="COLOR_SPACES">
             <EntityTypeMapping TypeName="RemoteModel.COLOR_SPACES">
               <MappingFragment StoreEntitySet="COLOR_SPACES">
@@ -7418,8 +8558,41 @@
           <EntitySetMapping Name="RMLS_EXTENSIONS">
             <EntityTypeMapping TypeName="RemoteModel.RMLS_EXTENSIONS">
               <MappingFragment StoreEntitySet="RMLS_EXTENSIONS">
-                <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" />
-                <ScalarProperty Name="NAME" ColumnName="NAME" />
+                <ScalarProperty Name="DATA" ColumnName="DATA" />
+                <ScalarProperty Name="FILE_NAME" ColumnName="FILE_NAME" />
+                <ScalarProperty Name="FINISHING" ColumnName="FINISHING" />
+                <ScalarProperty Name="MAX_TENACITY" ColumnName="MAX_TENACITY" />
+                <ScalarProperty Name="MIN_TENACITY" ColumnName="MIN_TENACITY" />
+                <ScalarProperty Name="MAX_ELASTICITY" ColumnName="MAX_ELASTICITY" />
+                <ScalarProperty Name="MIN_ELASTICITY" ColumnName="MIN_ELASTICITY" />
+                <ScalarProperty Name="MAX_MAX_FORCE_N" ColumnName="MAX_MAX_FORCE_N" />
+                <ScalarProperty Name="MIN_MAX_FORCE_N" ColumnName="MIN_MAX_FORCE_N" />
+                <ScalarProperty Name="MAX_ELONGATION" ColumnName="MAX_ELONGATION" />
+                <ScalarProperty Name="MIN_ELONGATION" ColumnName="MIN_ELONGATION" />
+                <ScalarProperty Name="TWIST_DIRECTION" ColumnName="TWIST_DIRECTION" />
+                <ScalarProperty Name="TWIST_TPM" ColumnName="TWIST_TPM" />
+                <ScalarProperty Name="FILAMENT_COUNT" ColumnName="FILAMENT_COUNT" />
+                <ScalarProperty Name="PLIES" ColumnName="PLIES" />
+                <ScalarProperty Name="UNIT" ColumnName="UNIT" />
+                <ScalarProperty Name="LINEAR_DENSITY" ColumnName="LINEAR_DENSITY" />
+                <ScalarProperty Name="YARN_GLOSS_LEVEL_GUID" ColumnName="YARN_GLOSS_LEVEL_GUID" />
+                <ScalarProperty Name="YARN_COLOR_GUID" ColumnName="YARN_COLOR_GUID" />
+                <ScalarProperty Name="YARN_GEOMETRY_GUID" ColumnName="YARN_GEOMETRY_GUID" />
+                <ScalarProperty Name="YARN_TEXTURING_GUID" ColumnName="YARN_TEXTURING_GUID" />
+                <ScalarProperty Name="YARN_GROUP_GUID" ColumnName="YARN_GROUP_GUID" />
+                <ScalarProperty Name="YARN_SUB_FAMILY_GUID" ColumnName="YARN_SUB_FAMILY_GUID" />
+                <ScalarProperty Name="YARN_FAMILY_GUID" ColumnName="YARN_FAMILY_GUID" />
+                <ScalarProperty Name="YARN_TYPE_GUID" ColumnName="YARN_TYPE_GUID" />
+                <ScalarProperty Name="YARN_MATERIAL_GUID" ColumnName="YARN_MATERIAL_GUID" />
+                <ScalarProperty Name="YARN_INDUSTRYSECTOR_GUID" ColumnName="YARN_INDUSTRYSECTOR_GUID" />
+                <ScalarProperty Name="YARN_APPLICATIONS_GUID" ColumnName="YARN_APPLICATIONS_GUID" />
+                <ScalarProperty Name="YARN_END_USE_GUID" ColumnName="YARN_END_USE_GUID" />
+                <ScalarProperty Name="COUNTRY" ColumnName="COUNTRY" />
+                <ScalarProperty Name="YARN_BRAND_GUID" ColumnName="YARN_BRAND_GUID" />
+                <ScalarProperty Name="YARN_MANUFACTURER_GUID" ColumnName="YARN_MANUFACTURER_GUID" />
+                <ScalarProperty Name="CREATED" ColumnName="CREATED" />
+                <ScalarProperty Name="USER_GUID" ColumnName="USER_GUID" />
+                <ScalarProperty Name="RML_GUID" ColumnName="RML_GUID" />
                 <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
                 <ScalarProperty Name="GUID" ColumnName="GUID" />
                 <ScalarProperty Name="ID" ColumnName="ID" />
@@ -7727,6 +8900,146 @@
               </MappingFragment>
             </EntityTypeMapping>
           </EntitySetMapping>
+          <EntitySetMapping Name="YARN_APPLICATIONS">
+            <EntityTypeMapping TypeName="RemoteModel.YARN_APPLICATIONS">
+              <MappingFragment StoreEntitySet="YARN_APPLICATIONS">
+                <ScalarProperty Name="NAME" ColumnName="NAME" />
+                <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
+                <ScalarProperty Name="GUID" ColumnName="GUID" />
+                <ScalarProperty Name="ID" ColumnName="ID" />
+              </MappingFragment>
+            </EntityTypeMapping>
+          </EntitySetMapping>
+          <EntitySetMapping Name="YARN_BRAND">
+            <EntityTypeMapping TypeName="RemoteModel.YARN_BRAND">
+              <MappingFragment StoreEntitySet="YARN_BRAND">
+                <ScalarProperty Name="NAME" ColumnName="NAME" />
+                <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
+                <ScalarProperty Name="GUID" ColumnName="GUID" />
+                <ScalarProperty Name="ID" ColumnName="ID" />
+              </MappingFragment>
+            </EntityTypeMapping>
+          </EntitySetMapping>
+          <EntitySetMapping Name="YARN_COLOR">
+            <EntityTypeMapping TypeName="RemoteModel.YARN_COLOR">
+              <MappingFragment StoreEntitySet="YARN_COLOR">
+                <ScalarProperty Name="NAME" ColumnName="NAME" />
+                <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
+                <ScalarProperty Name="GUID" ColumnName="GUID" />
+                <ScalarProperty Name="ID" ColumnName="ID" />
+              </MappingFragment>
+            </EntityTypeMapping>
+          </EntitySetMapping>
+          <EntitySetMapping Name="YARN_END_USE">
+            <EntityTypeMapping TypeName="RemoteModel.YARN_END_USE">
+              <MappingFragment StoreEntitySet="YARN_END_USE">
+                <ScalarProperty Name="NAME" ColumnName="NAME" />
+                <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
+                <ScalarProperty Name="GUID" ColumnName="GUID" />
+                <ScalarProperty Name="ID" ColumnName="ID" />
+              </MappingFragment>
+            </EntityTypeMapping>
+          </EntitySetMapping>
+          <EntitySetMapping Name="YARN_FAMILY">
+            <EntityTypeMapping TypeName="RemoteModel.YARN_FAMILY">
+              <MappingFragment StoreEntitySet="YARN_FAMILY">
+                <ScalarProperty Name="NAME" ColumnName="NAME" />
+                <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
+                <ScalarProperty Name="GUID" ColumnName="GUID" />
+                <ScalarProperty Name="ID" ColumnName="ID" />
+              </MappingFragment>
+            </EntityTypeMapping>
+          </EntitySetMapping>
+          <EntitySetMapping Name="YARN_GEOMETRY">
+            <EntityTypeMapping TypeName="RemoteModel.YARN_GEOMETRY">
+              <MappingFragment StoreEntitySet="YARN_GEOMETRY">
+                <ScalarProperty Name="NAME" ColumnName="NAME" />
+                <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
+                <ScalarProperty Name="GUID" ColumnName="GUID" />
+                <ScalarProperty Name="ID" ColumnName="ID" />
+              </MappingFragment>
+            </EntityTypeMapping>
+          </EntitySetMapping>
+          <EntitySetMapping Name="YARN_GLOSS_LEVEL">
+            <EntityTypeMapping TypeName="RemoteModel.YARN_GLOSS_LEVEL">
+              <MappingFragment StoreEntitySet="YARN_GLOSS_LEVEL">
+                <ScalarProperty Name="NAME" ColumnName="NAME" />
+                <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
+                <ScalarProperty Name="GUID" ColumnName="GUID" />
+                <ScalarProperty Name="ID" ColumnName="ID" />
+              </MappingFragment>
+            </EntityTypeMapping>
+          </EntitySetMapping>
+          <EntitySetMapping Name="YARN_GROUP">
+            <EntityTypeMapping TypeName="RemoteModel.YARN_GROUP">
+              <MappingFragment StoreEntitySet="YARN_GROUP">
+                <ScalarProperty Name="NAME" ColumnName="NAME" />
+                <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
+                <ScalarProperty Name="GUID" ColumnName="GUID" />
+                <ScalarProperty Name="ID" ColumnName="ID" />
+              </MappingFragment>
+            </EntityTypeMapping>
+          </EntitySetMapping>
+          <EntitySetMapping Name="YARN_INDUSTRYSECTOR">
+            <EntityTypeMapping TypeName="RemoteModel.YARN_INDUSTRYSECTOR">
+              <MappingFragment StoreEntitySet="YARN_INDUSTRYSECTOR">
+                <ScalarProperty Name="NAME" ColumnName="NAME" />
+                <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
+                <ScalarProperty Name="GUID" ColumnName="GUID" />
+                <ScalarProperty Name="ID" ColumnName="ID" />
+              </MappingFragment>
+            </EntityTypeMapping>
+          </EntitySetMapping>
+          <EntitySetMapping Name="YARN_MANUFACTURER">
+            <EntityTypeMapping TypeName="RemoteModel.YARN_MANUFACTURER">
+              <MappingFragment StoreEntitySet="YARN_MANUFACTURER">
+                <ScalarProperty Name="NAME" ColumnName="NAME" />
+                <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
+                <ScalarProperty Name="GUID" ColumnName="GUID" />
+                <ScalarProperty Name="ID" ColumnName="ID" />
+              </MappingFragment>
+            </EntityTypeMapping>
+          </EntitySetMapping>
+          <EntitySetMapping Name="YARN_MATERIALS">
+            <EntityTypeMapping TypeName="RemoteModel.YARN_MATERIALS">
+              <MappingFragment StoreEntitySet="YARN_MATERIALS">
+                <ScalarProperty Name="NAME" ColumnName="NAME" />
+                <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
+                <ScalarProperty Name="GUID" ColumnName="GUID" />
+                <ScalarProperty Name="ID" ColumnName="ID" />
+              </MappingFragment>
+            </EntityTypeMapping>
+          </EntitySetMapping>
+          <EntitySetMapping Name="YARN_SUB_FAMILY">
+            <EntityTypeMapping TypeName="RemoteModel.YARN_SUB_FAMILY">
+              <MappingFragment StoreEntitySet="YARN_SUB_FAMILY">
+                <ScalarProperty Name="NAME" ColumnName="NAME" />
+                <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
+                <ScalarProperty Name="GUID" ColumnName="GUID" />
+                <ScalarProperty Name="ID" ColumnName="ID" />
+              </MappingFragment>
+            </EntityTypeMapping>
+          </EntitySetMapping>
+          <EntitySetMapping Name="YARN_TEXTURING">
+            <EntityTypeMapping TypeName="RemoteModel.YARN_TEXTURING">
+              <MappingFragment StoreEntitySet="YARN_TEXTURING">
+                <ScalarProperty Name="NAME" ColumnName="NAME" />
+                <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
+                <ScalarProperty Name="GUID" ColumnName="GUID" />
+                <ScalarProperty Name="ID" ColumnName="ID" />
+              </MappingFragment>
+            </EntityTypeMapping>
+          </EntitySetMapping>
+          <EntitySetMapping Name="YARN_TYPE">
+            <EntityTypeMapping TypeName="RemoteModel.YARN_TYPE">
+              <MappingFragment StoreEntitySet="YARN_TYPE">
+                <ScalarProperty Name="NAME" ColumnName="NAME" />
+                <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
+                <ScalarProperty Name="GUID" ColumnName="GUID" />
+                <ScalarProperty Name="ID" ColumnName="ID" />
+              </MappingFragment>
+            </EntityTypeMapping>
+          </EntitySetMapping>
           </EntityContainerMapping>
       </Mapping>
     </edmx:Mappings>
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx.diagram b/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx.diagram
index b47d276c4..017f43c06 100644
--- a/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx.diagram
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx.diagram
@@ -5,95 +5,112 @@
     <!-- Diagram content (shape and connector positions) -->
     <edmx:Diagrams>
       <Diagram DiagramId="f9ae01d708754bbd997add25a4bacc79" Name="Diagram1" ZoomLevel="87">
-        <EntityTypeShape EntityType="RemoteModel.ACTION_LOGS" Width="1.5" PointX="11.25" PointY="11.5" />
-        <EntityTypeShape EntityType="RemoteModel.ADDRESS" Width="1.5" PointX="1.5" PointY="60.5" />
-        <EntityTypeShape EntityType="RemoteModel.APPLICATION_DISPLAY_PANEL_VERSIONS" Width="1.5" PointX="1.5" PointY="78.5" />
-        <EntityTypeShape EntityType="RemoteModel.APPLICATION_FIRMWARE_VERSIONS" Width="1.5" PointX="1.5" PointY="72.75" />
-        <EntityTypeShape EntityType="RemoteModel.APPLICATION_OS_VERSIONS" Width="1.5" PointX="1.5" PointY="75.625" />
-        <EntityTypeShape EntityType="RemoteModel.BIT_TYPES" Width="1.5" PointX="0.75" PointY="1.375" />
-        <EntityTypeShape EntityType="RemoteModel.BRUSH_STOPS" Width="1.5" PointX="15.75" PointY="17.625" />
-        <EntityTypeShape EntityType="RemoteModel.BTSR_APPLICATION_TYPES" Width="1.5" PointX="0.75" PointY="30.375" />
-        <EntityTypeShape EntityType="RemoteModel.BTSR_YARN_TYPES" Width="1.5" PointX="0.75" PointY="33.5" />
-        <EntityTypeShape EntityType="RemoteModel.CARTRIDGE_TYPES" Width="1.5" PointX="3.75" PointY="37.75" />
-        <EntityTypeShape EntityType="RemoteModel.CAT" Width="1.5" PointX="8.25" PointY="20.875" />
-        <EntityTypeShape EntityType="RemoteModel.CCT" Width="1.5" PointX="0.75" PointY="36.5" />
-        <EntityTypeShape EntityType="RemoteModel.COLOR_CATALOGS" Width="1.5" PointX="1.5" PointY="5.625" />
-        <EntityTypeShape EntityType="RemoteModel.COLOR_CATALOGS_GROUPS" Width="1.5" PointX="3.75" PointY="6.125" />
-        <EntityTypeShape EntityType="RemoteModel.COLOR_CATALOGS_ITEMS" Width="1.5" PointX="6" PointY="4.875" />
-        <EntityTypeShape EntityType="RemoteModel.COLOR_CATALOGS_ITEMS_RECIPES" Width="1.5" PointX="8.25" PointY="16.75" />
-        <EntityTypeShape EntityType="RemoteModel.COLOR_SPACES" Width="1.5" PointX="9" PointY="33.5" />
-        <EntityTypeShape EntityType="RemoteModel.CONFIGURATION" Width="1.5" PointX="3.75" PointY="74" />
-        <EntityTypeShape EntityType="RemoteModel.CONTACT" Width="1.5" PointX="1.5" PointY="64.5" />
-        <EntityTypeShape EntityType="RemoteModel.CUSTOMER" Width="1.5" PointX="9" PointY="30.5" />
-        <EntityTypeShape EntityType="RemoteModel.DATA_STORE_ITEMS" Width="1.5" PointX="8.25" PointY="77.25" />
-        <EntityTypeShape EntityType="RemoteModel.DISPENSER_TYPES" Width="1.5" PointX="1.5" PointY="85.875" />
-        <EntityTypeShape EntityType="RemoteModel.DISPENSER" Width="1.5" PointX="3.75" PointY="85.375" />
-        <EntityTypeShape EntityType="RemoteModel.EMBEDDED_FIRMWARE_VERSIONS" Width="1.5" PointX="1.5" PointY="81.5" />
-        <EntityTypeShape EntityType="RemoteModel.EVENT_TYPES" Width="1.5" PointX="9" PointY="40.625" />
-        <EntityTypeShape EntityType="RemoteModel.FIBER_SHAPES" Width="1.5" PointX="0.75" PointY="24.5" />
-        <EntityTypeShape EntityType="RemoteModel.FIBER_SYNTHS" Width="1.5" PointX="0.75" PointY="27.375" />
-        <EntityTypeShape EntityType="RemoteModel.FSE_VERSIONS" Width="1.5" PointX="11.25" PointY="8" />
-        <EntityTypeShape EntityType="RemoteModel.GLOBAL_DATA_STORE_ITEMS" Width="1.5" PointX="2.75" PointY="1.375" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_BLOWER_TYPES" Width="1.5" PointX="4.5" PointY="54" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_BLOWERS" Width="1.5" PointX="6.75" PointY="61.625" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_BREAK_SENSOR_TYPES" Width="1.5" PointX="1.5" PointY="57" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_BREAK_SENSORS" Width="1.5" PointX="3.75" PointY="68.75" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_DANCER_TYPES" Width="1.5" PointX="9.5" PointY="82" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_DANCERS" Width="1.5" PointX="11.75" PointY="68" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_MOTOR_TYPES" Width="1.5" PointX="6.5" PointY="81.875" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_MOTORS" Width="1.5" PointX="8.75" PointY="65.625" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_PID_CONTROL_TYPES" Width="1.5" PointX="9.5" PointY="86" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_PID_CONTROLS" Width="1.5" PointX="11.75" PointY="74.125" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_SPEED_SENSOR_TYPES" Width="1.5" PointX="10.5" PointY="58" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_SPEED_SENSORS" Width="1.5" PointX="12.75" PointY="63.75" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_VERSIONS" Width="1.5" PointX="1.5" PointY="68.5" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_WINDER_TYPES" Width="1.5" PointX="7.5" PointY="58" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_WINDERS" Width="1.5" PointX="9.75" PointY="61.875" />
-        <EntityTypeShape EntityType="RemoteModel.IDS_PACK_FORMULAS" Width="1.5" PointX="3.75" PointY="40.75" />
-        <EntityTypeShape EntityType="RemoteModel.IDS_PACKS" Width="1.5" PointX="6" PointY="42.125" />
-        <EntityTypeShape EntityType="RemoteModel.JOB_RUNS" Width="1.5" PointX="16.75" PointY="5.375" />
-        <EntityTypeShape EntityType="RemoteModel.JOB" Width="1.5" PointX="11.25" PointY="17.375" />
-        <EntityTypeShape EntityType="RemoteModel.LINEAR_MASS_DENSITY_UNITS" Width="1.5" PointX="0.75" PointY="16.5" />
-        <EntityTypeShape EntityType="RemoteModel.LIQUID_TYPES" Width="1.5" PointX="3" PointY="10.5" />
-        <EntityTypeShape EntityType="RemoteModel.LIQUID_TYPES_RMLS" Width="1.5" PointX="5.25" PointY="17" />
-        <EntityTypeShape EntityType="RemoteModel.MACHINE_PROTOTYPES" Width="1.5" PointX="4.75" PointY="1.375" />
-        <EntityTypeShape EntityType="RemoteModel.MACHINE_STUDIO_VERSIONS" Width="1.5" PointX="11.25" PointY="28.5" />
-        <EntityTypeShape EntityType="RemoteModel.MACHINE_VERSIONS" Width="1.5" PointX="3.75" PointY="57.125" />
-        <EntityTypeShape EntityType="RemoteModel.MACHINE" Width="1.5" PointX="6" PointY="65.625" />
-        <EntityTypeShape EntityType="RemoteModel.MACHINES_EVENTS" Width="1.5" PointX="11.25" PointY="41.125" />
-        <EntityTypeShape EntityType="RemoteModel.MEDIA_CONDITIONS" Width="1.5" PointX="0.75" PointY="21.375" />
-        <EntityTypeShape EntityType="RemoteModel.MEDIA_MATERIALS" Width="1.5" PointX="0.75" PointY="10.75" />
-        <EntityTypeShape EntityType="RemoteModel.MEDIA_PURPOSES" Width="1.5" PointX="0.75" PointY="13.625" />
-        <EntityTypeShape EntityType="RemoteModel.MID_TANK_TYPES" Width="1.5" PointX="3.75" PointY="44" />
-        <EntityTypeShape EntityType="RemoteModel.ORGANIZATION" Width="1.5" PointX="3.75" PointY="62.375" />
-        <EntityTypeShape EntityType="RemoteModel.PERMISSION" Width="1.5" PointX="12" PointY="0.75" />
-        <EntityTypeShape EntityType="RemoteModel.PROCESS_PARAMETERS_TABLES" Width="1.5" PointX="7.5" PointY="47.5" />
-        <EntityTypeShape EntityType="RemoteModel.PROCESS_PARAMETERS_TABLES_GROUPS" Width="1.5" PointX="5.25" PointY="50.5" />
-        <EntityTypeShape EntityType="RemoteModel.PUBLISHED_PROCEDURE_PROJECTS" Width="1.5" PointX="16.75" PointY="1.625" />
-        <EntityTypeShape EntityType="RemoteModel.PUBLISHED_PROCEDURE_PROJECTS_VERSIONS" Width="1.5" PointX="19" PointY="1.75" />
-        <EntityTypeShape EntityType="RemoteModel.RML" Width="1.5" PointX="3" PointY="15.375" />
-        <EntityTypeShape EntityType="RemoteModel.RMLS_EXTENSIONS" Width="1.5" PointX="6.75" PointY="1.375" />
-        <EntityTypeShape EntityType="RemoteModel.RMLS_SPOOLS" Width="1.5" PointX="5.25" PointY="20.75" />
-        <EntityTypeShape EntityType="RemoteModel.ROLE" Width="1.5" PointX="12" PointY="4.625" />
-        <EntityTypeShape EntityType="RemoteModel.ROLES_PERMISSIONS" Width="1.5" PointX="14.25" PointY="4.75" />
-        <EntityTypeShape EntityType="RemoteModel.SEGMENT" Width="1.5" PointX="13.5" PointY="21" />
-        <EntityTypeShape EntityType="RemoteModel.SITE" Width="1.5" PointX="3" PointY="31" />
-        <EntityTypeShape EntityType="RemoteModel.SITES_CATALOGS" Width="1.5" PointX="5.25" PointY="13.5" />
-        <EntityTypeShape EntityType="RemoteModel.SITES_RMLS" Width="1.5" PointX="5.25" PointY="25.25" />
-        <EntityTypeShape EntityType="RemoteModel.SPOOL_TYPES" Width="1.5" PointX="9" PointY="25.25" />
-        <EntityTypeShape EntityType="RemoteModel.SPOOL" Width="1.5" PointX="11.25" PointY="48.625" />
-        <EntityTypeShape EntityType="RemoteModel.sysdiagram" Width="1.5" PointX="8.75" PointY="1.375" />
-        <EntityTypeShape EntityType="RemoteModel.TANGO_UPDATES" Width="1.5" PointX="17.75" PointY="14.375" />
-        <EntityTypeShape EntityType="RemoteModel.TANGO_VERSIONS" Width="1.5" PointX="11.25" PointY="33.25" />
-        <EntityTypeShape EntityType="RemoteModel.TECH_CONTROLLERS" Width="1.5" PointX="8.75" PointY="4.375" />
-        <EntityTypeShape EntityType="RemoteModel.TECH_DISPENSERS" Width="1.5" PointX="13.75" PointY="8.375" />
-        <EntityTypeShape EntityType="RemoteModel.TECH_HEATERS" Width="1.5" PointX="18.75" PointY="5.375" />
-        <EntityTypeShape EntityType="RemoteModel.TECH_IOS" Width="1.5" PointX="18.75" PointY="8.375" />
-        <EntityTypeShape EntityType="RemoteModel.TECH_MONITORS" Width="1.5" PointX="17.75" PointY="19.375" />
-        <EntityTypeShape EntityType="RemoteModel.TECH_VALVES" Width="1.5" PointX="19.75" PointY="13.375" />
-        <EntityTypeShape EntityType="RemoteModel.USER" Width="1.5" PointX="9" PointY="10.375" />
-        <EntityTypeShape EntityType="RemoteModel.USERS_ROLES" Width="1.5" PointX="14.25" PointY="11.75" />
-        <EntityTypeShape EntityType="RemoteModel.WINDING_METHODS" Width="1.5" PointX="9" PointY="37" />
+        <EntityTypeShape EntityType="RemoteModel.ACTION_LOGS" Width="1.5" PointX="10.5" PointY="54.625" />
+        <EntityTypeShape EntityType="RemoteModel.ADDRESS" Width="1.5" PointX="0.75" PointY="30.125" />
+        <EntityTypeShape EntityType="RemoteModel.APPLICATION_DISPLAY_PANEL_VERSIONS" Width="1.5" PointX="0.75" PointY="52.25" />
+        <EntityTypeShape EntityType="RemoteModel.APPLICATION_FIRMWARE_VERSIONS" Width="1.5" PointX="0.75" PointY="39.25" />
+        <EntityTypeShape EntityType="RemoteModel.APPLICATION_OS_VERSIONS" Width="1.5" PointX="0.75" PointY="46.375" />
+        <EntityTypeShape EntityType="RemoteModel.BIT_TYPES" Width="1.5" PointX="0.75" PointY="5.25" />
+        <EntityTypeShape EntityType="RemoteModel.BRUSH_STOPS" Width="1.5" PointX="18" PointY="46.25" />
+        <EntityTypeShape EntityType="RemoteModel.BTSR_APPLICATION_TYPES" Width="1.5" PointX="6" PointY="9.5" />
+        <EntityTypeShape EntityType="RemoteModel.BTSR_YARN_TYPES" Width="1.5" PointX="6" PointY="23" />
+        <EntityTypeShape EntityType="RemoteModel.CARTRIDGE_TYPES" Width="1.5" PointX="13.25" PointY="96.625" />
+        <EntityTypeShape EntityType="RemoteModel.CAT" Width="1.5" PointX="7.5" PointY="48.25" />
+        <EntityTypeShape EntityType="RemoteModel.CCT" Width="1.5" PointX="6" PointY="13.125" />
+        <EntityTypeShape EntityType="RemoteModel.COLOR_CATALOGS" Width="1.5" PointX="5.25" PointY="28.5" />
+        <EntityTypeShape EntityType="RemoteModel.COLOR_CATALOGS_GROUPS" Width="1.5" PointX="13.5" PointY="62.75" />
+        <EntityTypeShape EntityType="RemoteModel.COLOR_CATALOGS_ITEMS" Width="1.5" PointX="15.75" PointY="61.5" />
+        <EntityTypeShape EntityType="RemoteModel.COLOR_CATALOGS_ITEMS_RECIPES" Width="1.5" PointX="22" PointY="37.25" />
+        <EntityTypeShape EntityType="RemoteModel.COLOR_PROCESS_DATA" Width="1.5" PointX="18" PointY="29.375" />
+        <EntityTypeShape EntityType="RemoteModel.COLOR_PROCESS_FACTOR" Width="1.5" PointX="18" PointY="33.125" />
+        <EntityTypeShape EntityType="RemoteModel.COLOR_PROCESS_PARAMETERS" Width="1.5" PointX="15.75" PointY="31.375" />
+        <EntityTypeShape EntityType="RemoteModel.COLOR_SPACES" Width="1.5" PointX="8.25" PointY="56.25" />
+        <EntityTypeShape EntityType="RemoteModel.CONFIGURATION" Width="1.5" PointX="3" PointY="44.75" />
+        <EntityTypeShape EntityType="RemoteModel.CONTACT" Width="1.5" PointX="0.75" PointY="34.25" />
+        <EntityTypeShape EntityType="RemoteModel.CUSTOMER" Width="1.5" PointX="5.25" PointY="57.5" />
+        <EntityTypeShape EntityType="RemoteModel.DATA_STORE_ITEMS" Width="1.5" PointX="7.5" PointY="44.125" />
+        <EntityTypeShape EntityType="RemoteModel.DISPENSER_TYPES" Width="1.5" PointX="11" PointY="86.25" />
+        <EntityTypeShape EntityType="RemoteModel.DISPENSER" Width="1.5" PointX="13.25" PointY="85.75" />
+        <EntityTypeShape EntityType="RemoteModel.EMBEDDED_FIRMWARE_VERSIONS" Width="1.5" PointX="0.75" PointY="49.375" />
+        <EntityTypeShape EntityType="RemoteModel.EVENT_TYPES" Width="1.5" PointX="14.25" PointY="50.25" />
+        <EntityTypeShape EntityType="RemoteModel.FIBER_SHAPES" Width="1.5" PointX="6" PointY="20.125" />
+        <EntityTypeShape EntityType="RemoteModel.FIBER_SYNTHS" Width="1.5" PointX="6" PointY="64.5" />
+        <EntityTypeShape EntityType="RemoteModel.FSE_VERSIONS" Width="1.5" PointX="10.5" PointY="58.25" />
+        <EntityTypeShape EntityType="RemoteModel.GLOBAL_DATA_STORE_ITEMS" Width="1.5" PointX="2.75" PointY="5.25" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_BLOWER_TYPES" Width="1.5" PointX="15.75" PointY="67.75" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_BLOWERS" Width="1.5" PointX="18" PointY="57.375" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_BREAK_SENSOR_TYPES" Width="1.5" PointX="0.75" PointY="67.75" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_BREAK_SENSORS" Width="1.5" PointX="3" PointY="59.5" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_DANCER_TYPES" Width="1.5" PointX="0.75" PointY="59.75" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_DANCERS" Width="1.5" PointX="3" PointY="49.625" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_MOTOR_TYPES" Width="1.5" PointX="0.75" PointY="26.625" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_MOTORS" Width="1.5" PointX="3" PointY="23.375" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_PID_CONTROL_TYPES" Width="1.5" PointX="16.75" PointY="25.75" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_PID_CONTROLS" Width="1.5" PointX="19" PointY="38.875" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_SPEED_SENSOR_TYPES" Width="1.5" PointX="0.75" PointY="63.75" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_SPEED_SENSORS" Width="1.5" PointX="3" PointY="55.5" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_VERSIONS" Width="1.5" PointX="0.75" PointY="42.125" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_WINDER_TYPES" Width="1.5" PointX="0.75" PointY="55.75" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_WINDERS" Width="1.5" PointX="3" PointY="40.5" />
+        <EntityTypeShape EntityType="RemoteModel.IDS_PACK_FORMULAS" Width="1.5" PointX="13.25" PointY="93.25" />
+        <EntityTypeShape EntityType="RemoteModel.IDS_PACKS" Width="1.5" PointX="15.5" PointY="56.125" />
+        <EntityTypeShape EntityType="RemoteModel.JOB_RUNS" Width="1.5" PointX="0.75" PointY="9.25" />
+        <EntityTypeShape EntityType="RemoteModel.JOB" Width="1.5" PointX="10.5" PointY="43" />
+        <EntityTypeShape EntityType="RemoteModel.LINEAR_MASS_DENSITY_UNITS" Width="1.5" PointX="6" PointY="61.5" />
+        <EntityTypeShape EntityType="RemoteModel.LIQUID_TYPES" Width="1.5" PointX="5.25" PointY="48" />
+        <EntityTypeShape EntityType="RemoteModel.LIQUID_TYPES_RMLS" Width="1.5" PointX="13.5" PointY="24" />
+        <EntityTypeShape EntityType="RemoteModel.MACHINE_PROTOTYPES" Width="1.5" PointX="4.75" PointY="5.25" />
+        <EntityTypeShape EntityType="RemoteModel.MACHINE_STUDIO_VERSIONS" Width="1.5" PointX="10.5" PointY="61.75" />
+        <EntityTypeShape EntityType="RemoteModel.MACHINE_VERSIONS" Width="1.5" PointX="8.25" PointY="29.625" />
+        <EntityTypeShape EntityType="RemoteModel.MACHINE" Width="1.5" PointX="5.25" PointY="37" />
+        <EntityTypeShape EntityType="RemoteModel.MACHINES_EVENTS" Width="1.5" PointX="16.5" PointY="41.75" />
+        <EntityTypeShape EntityType="RemoteModel.MEDIA_CONDITIONS" Width="1.5" PointX="6" PointY="17.25" />
+        <EntityTypeShape EntityType="RemoteModel.MEDIA_MATERIALS" Width="1.5" PointX="6" PointY="52.625" />
+        <EntityTypeShape EntityType="RemoteModel.MEDIA_PURPOSES" Width="1.5" PointX="6" PointY="67.375" />
+        <EntityTypeShape EntityType="RemoteModel.MID_TANK_TYPES" Width="1.5" PointX="13.25" PointY="90" />
+        <EntityTypeShape EntityType="RemoteModel.ORGANIZATION" Width="1.5" PointX="3" PointY="34.125" />
+        <EntityTypeShape EntityType="RemoteModel.PERMISSION" Width="1.5" PointX="17.25" PointY="21.625" />
+        <EntityTypeShape EntityType="RemoteModel.PROCESS_PARAMETERS_TABLES" Width="1.5" PointX="12.75" PointY="0.75" />
+        <EntityTypeShape EntityType="RemoteModel.PROCESS_PARAMETERS_TABLES_GROUPS" Width="1.5" PointX="10.5" PointY="3.875" />
+        <EntityTypeShape EntityType="RemoteModel.PUBLISHED_PROCEDURE_PROJECTS" Width="1.5" PointX="0.75" PointY="1.5" />
+        <EntityTypeShape EntityType="RemoteModel.PUBLISHED_PROCEDURE_PROJECTS_VERSIONS" Width="1.5" PointX="3" PointY="1.625" />
+        <EntityTypeShape EntityType="RemoteModel.RML" Width="1.5" PointX="8.25" PointY="7.125" />
+        <EntityTypeShape EntityType="RemoteModel.RMLS_EXTENSIONS" Width="1.5" PointX="13.5" PointY="33" />
+        <EntityTypeShape EntityType="RemoteModel.RMLS_SPOOLS" Width="1.5" PointX="20.5" PointY="33" />
+        <EntityTypeShape EntityType="RemoteModel.ROLE" Width="1.5" PointX="14.25" PointY="27.625" />
+        <EntityTypeShape EntityType="RemoteModel.ROLES_PERMISSIONS" Width="1.5" PointX="19.5" PointY="25.625" />
+        <EntityTypeShape EntityType="RemoteModel.SEGMENT" Width="1.5" PointX="12.75" PointY="46.625" />
+        <EntityTypeShape EntityType="RemoteModel.SITE" Width="1.5" PointX="5.25" PointY="32.875" />
+        <EntityTypeShape EntityType="RemoteModel.SITES_CATALOGS" Width="1.5" PointX="7.5" PointY="33.125" />
+        <EntityTypeShape EntityType="RemoteModel.SITES_RMLS" Width="1.5" PointX="10.5" PointY="33.125" />
+        <EntityTypeShape EntityType="RemoteModel.SPOOL_TYPES" Width="1.5" PointX="13.25" PointY="55.625" />
+        <EntityTypeShape EntityType="RemoteModel.SPOOL" Width="1.5" PointX="15.5" PointY="46.125" />
+        <EntityTypeShape EntityType="RemoteModel.sysdiagram" Width="1.5" PointX="5.75" PointY="1.25" />
+        <EntityTypeShape EntityType="RemoteModel.TANGO_UPDATES" Width="1.5" PointX="7.75" PointY="1.25" />
+        <EntityTypeShape EntityType="RemoteModel.TANGO_VERSIONS" Width="1.5" PointX="10.5" PointY="37.125" />
+        <EntityTypeShape EntityType="RemoteModel.TECH_CONTROLLERS" Width="1.5" PointX="2.75" PointY="9.25" />
+        <EntityTypeShape EntityType="RemoteModel.TECH_DISPENSERS" Width="1.5" PointX="2.75" PointY="13.25" />
+        <EntityTypeShape EntityType="RemoteModel.TECH_HEATERS" Width="1.5" PointX="13.75" PointY="10.25" />
+        <EntityTypeShape EntityType="RemoteModel.TECH_IOS" Width="1.5" PointX="13.75" PointY="13.25" />
+        <EntityTypeShape EntityType="RemoteModel.TECH_MONITORS" Width="1.5" PointX="14.75" PointY="1.25" />
+        <EntityTypeShape EntityType="RemoteModel.TECH_VALVES" Width="1.5" PointX="14.75" PointY="6.25" />
+        <EntityTypeShape EntityType="RemoteModel.USER" Width="1.5" PointX="8.25" PointY="36.25" />
+        <EntityTypeShape EntityType="RemoteModel.USERS_ROLES" Width="1.5" PointX="16.5" PointY="37.625" />
+        <EntityTypeShape EntityType="RemoteModel.WINDING_METHODS" Width="1.5" PointX="8.25" PointY="53.125" />
+        <EntityTypeShape EntityType="RemoteModel.YARN_APPLICATIONS" Width="1.5" PointX="11.25" PointY="79.875" />
+        <EntityTypeShape EntityType="RemoteModel.YARN_BRAND" Width="1.5" PointX="11.25" PointY="17" />
+        <EntityTypeShape EntityType="RemoteModel.YARN_COLOR" Width="1.5" PointX="11.25" PointY="20.125" />
+        <EntityTypeShape EntityType="RemoteModel.YARN_END_USE" Width="1.5" PointX="11.25" PointY="69" />
+        <EntityTypeShape EntityType="RemoteModel.YARN_FAMILY" Width="1.5" PointX="11.25" PointY="22.875" />
+        <EntityTypeShape EntityType="RemoteModel.YARN_GEOMETRY" Width="1.5" PointX="11.25" PointY="13.75" />
+        <EntityTypeShape EntityType="RemoteModel.YARN_GLOSS_LEVEL" Width="1.5" PointX="11.25" PointY="10.5" />
+        <EntityTypeShape EntityType="RemoteModel.YARN_GROUP" Width="1.5" PointX="11.25" PointY="66.25" />
+        <EntityTypeShape EntityType="RemoteModel.YARN_INDUSTRYSECTOR" Width="1.5" PointX="11.25" PointY="28.25" />
+        <EntityTypeShape EntityType="RemoteModel.YARN_MANUFACTURER" Width="1.5" PointX="11.25" PointY="74.375" />
+        <EntityTypeShape EntityType="RemoteModel.YARN_MATERIALS" Width="1.5" PointX="11.25" PointY="71.625" />
+        <EntityTypeShape EntityType="RemoteModel.YARN_SUB_FAMILY" Width="1.5" PointX="11.25" PointY="77.125" />
+        <EntityTypeShape EntityType="RemoteModel.YARN_TEXTURING" Width="1.5" PointX="11.25" PointY="82.625" />
+        <EntityTypeShape EntityType="RemoteModel.YARN_TYPE" Width="1.5" PointX="11.25" PointY="25.625" />
         <AssociationConnector Association="RemoteModel.FK_ACTION_LOGS_USERS" />
         <AssociationConnector Association="RemoteModel.FK_ORGANIZATIONS_ADDRESSES" />
         <AssociationConnector Association="RemoteModel.FK_USERS_ADDRESSES" />
@@ -117,6 +134,9 @@
         <AssociationConnector Association="RemoteModel.FK_COLOR_CATALOGS_ITEMS_COLOR_CATALOGS_GROUPS" />
         <AssociationConnector Association="RemoteModel.FK_COLOR_CATALOGS_ITEMS_RECIPES_COLOR_CATALOGS_ITEMS" />
         <AssociationConnector Association="RemoteModel.FK_COLOR_CATALOGS_ITEMS_RECIPES_RMLS" />
+        <AssociationConnector Association="RemoteModel.FK_COLOR_PROCESS_DATA_COLOR_PROCESS_PARAMETERS" />
+        <AssociationConnector Association="RemoteModel.FK_COLOR_PROCESS_FACTOR_COLOR_PROCESS_PARAMETERS" />
+        <AssociationConnector Association="RemoteModel.FK_COLOR_PROCESS_PARAMETERS_RMLS_EXTENSIONS" />
         <AssociationConnector Association="RemoteModel.FK_JOBS_COLOR_SPACES" />
         <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_EMBEDDED_FIRMWARE_VERSIONS" />
         <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_HARDWARE_VERSIONS" />
@@ -175,8 +195,24 @@
         <AssociationConnector Association="RemoteModel.FK_PROCESS_PARAMETERS_TABLES_PROCESS_PARAMETERS_TABLES_GROUPS" />
         <AssociationConnector Association="RemoteModel.FK_PROCESS_PARAMETERS_TABLES_GROUPS_RMLS" />
         <AssociationConnector Association="RemoteModel.FK_PUBLISHED_TEST_PROJECTS_VERSIONS_PUBLISHED_TEST_PROJECTS" />
+        <AssociationConnector Association="RemoteModel.FK_RMLS_EXTENSIONS_RMLS" />
         <AssociationConnector Association="RemoteModel.FK_RMLS_SPOOLS_RMLS" />
         <AssociationConnector Association="RemoteModel.FK_SITES_RMLS_RMLS" />
+        <AssociationConnector Association="RemoteModel.FK_RMLS_EXTENSIONS_USERS" />
+        <AssociationConnector Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_APPLICATIONS" />
+        <AssociationConnector Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_BRAND" />
+        <AssociationConnector Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_COLOR" />
+        <AssociationConnector Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_END_USE" />
+        <AssociationConnector Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_FAMILY" />
+        <AssociationConnector Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_GEOMETRY" />
+        <AssociationConnector Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_GLOSS_LEVEL" />
+        <AssociationConnector Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_GROUP" />
+        <AssociationConnector Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_INDUSTRYSECTOR" />
+        <AssociationConnector Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_MANUFACTURER" />
+        <AssociationConnector Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_MATERIALS" />
+        <AssociationConnector Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_SUB_FAMILY" />
+        <AssociationConnector Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_TEXTURING" />
+        <AssociationConnector Association="RemoteModel.FK_RMLS_EXTENSIONS_YARN_TYPE" />
         <AssociationConnector Association="RemoteModel.FK_RMLS_SPOOLS_SPOOL_TYPES" />
         <AssociationConnector Association="RemoteModel.FK_ROLES_PERMISSIONS_ROLES" />
         <AssociationConnector Association="RemoteModel.FK_USERS_ROLES_ROLES" />
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/USER.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/USER.cs
index 75cc4e444..375008753 100644
--- a/Software/Visual_Studio/Tango.DAL.Remote/DB/USER.cs
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/USER.cs
@@ -22,6 +22,7 @@ namespace Tango.DAL.Remote.DB
             this.JOBS = new HashSet<JOB>();
             this.MACHINE_STUDIO_VERSIONS = new HashSet<MACHINE_STUDIO_VERSIONS>();
             this.MACHINES_EVENTS = new HashSet<MACHINES_EVENTS>();
+            this.RMLS_EXTENSIONS = new HashSet<RMLS_EXTENSIONS>();
             this.TANGO_VERSIONS = new HashSet<TANGO_VERSIONS>();
             this.USERS_ROLES = new HashSet<USERS_ROLES>();
         }
@@ -52,6 +53,8 @@ namespace Tango.DAL.Remote.DB
         public virtual ICollection<MACHINES_EVENTS> MACHINES_EVENTS { get; set; }
         public virtual ORGANIZATION ORGANIZATION { get; set; }
         [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
+        public virtual ICollection<RMLS_EXTENSIONS> RMLS_EXTENSIONS { get; set; }
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
         public virtual ICollection<TANGO_VERSIONS> TANGO_VERSIONS { get; set; }
         [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
         public virtual ICollection<USERS_ROLES> USERS_ROLES { get; set; }
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_APPLICATIONS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_APPLICATIONS.cs
new file mode 100644
index 000000000..771e3ccaa
--- /dev/null
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_APPLICATIONS.cs
@@ -0,0 +1,31 @@
+//------------------------------------------------------------------------------
+// <auto-generated>
+//     This code was generated from a template.
+//
+//     Manual changes to this file may cause unexpected behavior in your application.
+//     Manual changes to this file will be overwritten if the code is regenerated.
+// </auto-generated>
+//------------------------------------------------------------------------------
+
+namespace Tango.DAL.Remote.DB
+{
+    using System;
+    using System.Collections.Generic;
+    
+    public partial class YARN_APPLICATIONS
+    {
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
+        public YARN_APPLICATIONS()
+        {
+            this.RMLS_EXTENSIONS = new HashSet<RMLS_EXTENSIONS>();
+        }
+    
+        public int ID { get; set; }
+        public string GUID { get; set; }
+        public System.DateTime LAST_UPDATED { get; set; }
+        public string NAME { get; set; }
+    
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
+        public virtual ICollection<RMLS_EXTENSIONS> RMLS_EXTENSIONS { get; set; }
+    }
+}
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_BRAND.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_BRAND.cs
new file mode 100644
index 000000000..2ba5f08cd
--- /dev/null
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_BRAND.cs
@@ -0,0 +1,31 @@
+//------------------------------------------------------------------------------
+// <auto-generated>
+//     This code was generated from a template.
+//
+//     Manual changes to this file may cause unexpected behavior in your application.
+//     Manual changes to this file will be overwritten if the code is regenerated.
+// </auto-generated>
+//------------------------------------------------------------------------------
+
+namespace Tango.DAL.Remote.DB
+{
+    using System;
+    using System.Collections.Generic;
+    
+    public partial class YARN_BRAND
+    {
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
+        public YARN_BRAND()
+        {
+            this.RMLS_EXTENSIONS = new HashSet<RMLS_EXTENSIONS>();
+        }
+    
+        public int ID { get; set; }
+        public string GUID { get; set; }
+        public System.DateTime LAST_UPDATED { get; set; }
+        public string NAME { get; set; }
+    
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
+        public virtual ICollection<RMLS_EXTENSIONS> RMLS_EXTENSIONS { get; set; }
+    }
+}
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_COLOR.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_COLOR.cs
new file mode 100644
index 000000000..b863f937c
--- /dev/null
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_COLOR.cs
@@ -0,0 +1,31 @@
+//------------------------------------------------------------------------------
+// <auto-generated>
+//     This code was generated from a template.
+//
+//     Manual changes to this file may cause unexpected behavior in your application.
+//     Manual changes to this file will be overwritten if the code is regenerated.
+// </auto-generated>
+//------------------------------------------------------------------------------
+
+namespace Tango.DAL.Remote.DB
+{
+    using System;
+    using System.Collections.Generic;
+    
+    public partial class YARN_COLOR
+    {
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
+        public YARN_COLOR()
+        {
+            this.RMLS_EXTENSIONS = new HashSet<RMLS_EXTENSIONS>();
+        }
+    
+        public int ID { get; set; }
+        public string GUID { get; set; }
+        public System.DateTime LAST_UPDATED { get; set; }
+        public string NAME { get; set; }
+    
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
+        public virtual ICollection<RMLS_EXTENSIONS> RMLS_EXTENSIONS { get; set; }
+    }
+}
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_END_USE.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_END_USE.cs
new file mode 100644
index 000000000..4008c4f0e
--- /dev/null
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_END_USE.cs
@@ -0,0 +1,31 @@
+//------------------------------------------------------------------------------
+// <auto-generated>
+//     This code was generated from a template.
+//
+//     Manual changes to this file may cause unexpected behavior in your application.
+//     Manual changes to this file will be overwritten if the code is regenerated.
+// </auto-generated>
+//------------------------------------------------------------------------------
+
+namespace Tango.DAL.Remote.DB
+{
+    using System;
+    using System.Collections.Generic;
+    
+    public partial class YARN_END_USE
+    {
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
+        public YARN_END_USE()
+        {
+            this.RMLS_EXTENSIONS = new HashSet<RMLS_EXTENSIONS>();
+        }
+    
+        public int ID { get; set; }
+        public string GUID { get; set; }
+        public System.DateTime LAST_UPDATED { get; set; }
+        public string NAME { get; set; }
+    
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
+        public virtual ICollection<RMLS_EXTENSIONS> RMLS_EXTENSIONS { get; set; }
+    }
+}
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_FAMILY.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_FAMILY.cs
new file mode 100644
index 000000000..4e29b0ab1
--- /dev/null
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_FAMILY.cs
@@ -0,0 +1,31 @@
+//------------------------------------------------------------------------------
+// <auto-generated>
+//     This code was generated from a template.
+//
+//     Manual changes to this file may cause unexpected behavior in your application.
+//     Manual changes to this file will be overwritten if the code is regenerated.
+// </auto-generated>
+//------------------------------------------------------------------------------
+
+namespace Tango.DAL.Remote.DB
+{
+    using System;
+    using System.Collections.Generic;
+    
+    public partial class YARN_FAMILY
+    {
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
+        public YARN_FAMILY()
+        {
+            this.RMLS_EXTENSIONS = new HashSet<RMLS_EXTENSIONS>();
+        }
+    
+        public int ID { get; set; }
+        public string GUID { get; set; }
+        public System.DateTime LAST_UPDATED { get; set; }
+        public string NAME { get; set; }
+    
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
+        public virtual ICollection<RMLS_EXTENSIONS> RMLS_EXTENSIONS { get; set; }
+    }
+}
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_GEOMETRY.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_GEOMETRY.cs
new file mode 100644
index 000000000..87f07131e
--- /dev/null
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_GEOMETRY.cs
@@ -0,0 +1,31 @@
+//------------------------------------------------------------------------------
+// <auto-generated>
+//     This code was generated from a template.
+//
+//     Manual changes to this file may cause unexpected behavior in your application.
+//     Manual changes to this file will be overwritten if the code is regenerated.
+// </auto-generated>
+//------------------------------------------------------------------------------
+
+namespace Tango.DAL.Remote.DB
+{
+    using System;
+    using System.Collections.Generic;
+    
+    public partial class YARN_GEOMETRY
+    {
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
+        public YARN_GEOMETRY()
+        {
+            this.RMLS_EXTENSIONS = new HashSet<RMLS_EXTENSIONS>();
+        }
+    
+        public int ID { get; set; }
+        public string GUID { get; set; }
+        public System.DateTime LAST_UPDATED { get; set; }
+        public string NAME { get; set; }
+    
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
+        public virtual ICollection<RMLS_EXTENSIONS> RMLS_EXTENSIONS { get; set; }
+    }
+}
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_GLOSS_LEVEL.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_GLOSS_LEVEL.cs
new file mode 100644
index 000000000..75f4dd0b4
--- /dev/null
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_GLOSS_LEVEL.cs
@@ -0,0 +1,31 @@
+//------------------------------------------------------------------------------
+// <auto-generated>
+//     This code was generated from a template.
+//
+//     Manual changes to this file may cause unexpected behavior in your application.
+//     Manual changes to this file will be overwritten if the code is regenerated.
+// </auto-generated>
+//------------------------------------------------------------------------------
+
+namespace Tango.DAL.Remote.DB
+{
+    using System;
+    using System.Collections.Generic;
+    
+    public partial class YARN_GLOSS_LEVEL
+    {
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
+        public YARN_GLOSS_LEVEL()
+        {
+            this.RMLS_EXTENSIONS = new HashSet<RMLS_EXTENSIONS>();
+        }
+    
+        public int ID { get; set; }
+        public string GUID { get; set; }
+        public System.DateTime LAST_UPDATED { get; set; }
+        public string NAME { get; set; }
+    
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
+        public virtual ICollection<RMLS_EXTENSIONS> RMLS_EXTENSIONS { get; set; }
+    }
+}
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_GROUP.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_GROUP.cs
new file mode 100644
index 000000000..1442fa1e1
--- /dev/null
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_GROUP.cs
@@ -0,0 +1,31 @@
+//------------------------------------------------------------------------------
+// <auto-generated>
+//     This code was generated from a template.
+//
+//     Manual changes to this file may cause unexpected behavior in your application.
+//     Manual changes to this file will be overwritten if the code is regenerated.
+// </auto-generated>
+//------------------------------------------------------------------------------
+
+namespace Tango.DAL.Remote.DB
+{
+    using System;
+    using System.Collections.Generic;
+    
+    public partial class YARN_GROUP
+    {
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
+        public YARN_GROUP()
+        {
+            this.RMLS_EXTENSIONS = new HashSet<RMLS_EXTENSIONS>();
+        }
+    
+        public int ID { get; set; }
+        public string GUID { get; set; }
+        public System.DateTime LAST_UPDATED { get; set; }
+        public string NAME { get; set; }
+    
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
+        public virtual ICollection<RMLS_EXTENSIONS> RMLS_EXTENSIONS { get; set; }
+    }
+}
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_INDUSTRYSECTOR.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_INDUSTRYSECTOR.cs
new file mode 100644
index 000000000..3ca6eeb67
--- /dev/null
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_INDUSTRYSECTOR.cs
@@ -0,0 +1,31 @@
+//------------------------------------------------------------------------------
+// <auto-generated>
+//     This code was generated from a template.
+//
+//     Manual changes to this file may cause unexpected behavior in your application.
+//     Manual changes to this file will be overwritten if the code is regenerated.
+// </auto-generated>
+//------------------------------------------------------------------------------
+
+namespace Tango.DAL.Remote.DB
+{
+    using System;
+    using System.Collections.Generic;
+    
+    public partial class YARN_INDUSTRYSECTOR
+    {
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
+        public YARN_INDUSTRYSECTOR()
+        {
+            this.RMLS_EXTENSIONS = new HashSet<RMLS_EXTENSIONS>();
+        }
+    
+        public int ID { get; set; }
+        public string GUID { get; set; }
+        public System.DateTime LAST_UPDATED { get; set; }
+        public string NAME { get; set; }
+    
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
+        public virtual ICollection<RMLS_EXTENSIONS> RMLS_EXTENSIONS { get; set; }
+    }
+}
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_MANUFACTURER.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_MANUFACTURER.cs
new file mode 100644
index 000000000..b2fec3ac4
--- /dev/null
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_MANUFACTURER.cs
@@ -0,0 +1,31 @@
+//------------------------------------------------------------------------------
+// <auto-generated>
+//     This code was generated from a template.
+//
+//     Manual changes to this file may cause unexpected behavior in your application.
+//     Manual changes to this file will be overwritten if the code is regenerated.
+// </auto-generated>
+//------------------------------------------------------------------------------
+
+namespace Tango.DAL.Remote.DB
+{
+    using System;
+    using System.Collections.Generic;
+    
+    public partial class YARN_MANUFACTURER
+    {
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
+        public YARN_MANUFACTURER()
+        {
+            this.RMLS_EXTENSIONS = new HashSet<RMLS_EXTENSIONS>();
+        }
+    
+        public int ID { get; set; }
+        public string GUID { get; set; }
+        public System.DateTime LAST_UPDATED { get; set; }
+        public string NAME { get; set; }
+    
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
+        public virtual ICollection<RMLS_EXTENSIONS> RMLS_EXTENSIONS { get; set; }
+    }
+}
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_MATERIALS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_MATERIALS.cs
new file mode 100644
index 000000000..8e14102bc
--- /dev/null
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_MATERIALS.cs
@@ -0,0 +1,31 @@
+//------------------------------------------------------------------------------
+// <auto-generated>
+//     This code was generated from a template.
+//
+//     Manual changes to this file may cause unexpected behavior in your application.
+//     Manual changes to this file will be overwritten if the code is regenerated.
+// </auto-generated>
+//------------------------------------------------------------------------------
+
+namespace Tango.DAL.Remote.DB
+{
+    using System;
+    using System.Collections.Generic;
+    
+    public partial class YARN_MATERIALS
+    {
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
+        public YARN_MATERIALS()
+        {
+            this.RMLS_EXTENSIONS = new HashSet<RMLS_EXTENSIONS>();
+        }
+    
+        public int ID { get; set; }
+        public string GUID { get; set; }
+        public System.DateTime LAST_UPDATED { get; set; }
+        public string NAME { get; set; }
+    
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
+        public virtual ICollection<RMLS_EXTENSIONS> RMLS_EXTENSIONS { get; set; }
+    }
+}
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_SUB_FAMILY.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_SUB_FAMILY.cs
new file mode 100644
index 000000000..5172bfb8e
--- /dev/null
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_SUB_FAMILY.cs
@@ -0,0 +1,31 @@
+//------------------------------------------------------------------------------
+// <auto-generated>
+//     This code was generated from a template.
+//
+//     Manual changes to this file may cause unexpected behavior in your application.
+//     Manual changes to this file will be overwritten if the code is regenerated.
+// </auto-generated>
+//------------------------------------------------------------------------------
+
+namespace Tango.DAL.Remote.DB
+{
+    using System;
+    using System.Collections.Generic;
+    
+    public partial class YARN_SUB_FAMILY
+    {
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
+        public YARN_SUB_FAMILY()
+        {
+            this.RMLS_EXTENSIONS = new HashSet<RMLS_EXTENSIONS>();
+        }
+    
+        public int ID { get; set; }
+        public string GUID { get; set; }
+        public System.DateTime LAST_UPDATED { get; set; }
+        public string NAME { get; set; }
+    
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
+        public virtual ICollection<RMLS_EXTENSIONS> RMLS_EXTENSIONS { get; set; }
+    }
+}
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_TEXTURING.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_TEXTURING.cs
new file mode 100644
index 000000000..7107eba01
--- /dev/null
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_TEXTURING.cs
@@ -0,0 +1,31 @@
+//------------------------------------------------------------------------------
+// <auto-generated>
+//     This code was generated from a template.
+//
+//     Manual changes to this file may cause unexpected behavior in your application.
+//     Manual changes to this file will be overwritten if the code is regenerated.
+// </auto-generated>
+//------------------------------------------------------------------------------
+
+namespace Tango.DAL.Remote.DB
+{
+    using System;
+    using System.Collections.Generic;
+    
+    public partial class YARN_TEXTURING
+    {
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
+        public YARN_TEXTURING()
+        {
+            this.RMLS_EXTENSIONS = new HashSet<RMLS_EXTENSIONS>();
+        }
+    
+        public int ID { get; set; }
+        public string GUID { get; set; }
+        public System.DateTime LAST_UPDATED { get; set; }
+        public string NAME { get; set; }
+    
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
+        public virtual ICollection<RMLS_EXTENSIONS> RMLS_EXTENSIONS { get; set; }
+    }
+}
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_TYPE.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_TYPE.cs
new file mode 100644
index 000000000..0070c5da6
--- /dev/null
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/YARN_TYPE.cs
@@ -0,0 +1,31 @@
+//------------------------------------------------------------------------------
+// <auto-generated>
+//     This code was generated from a template.
+//
+//     Manual changes to this file may cause unexpected behavior in your application.
+//     Manual changes to this file will be overwritten if the code is regenerated.
+// </auto-generated>
+//------------------------------------------------------------------------------
+
+namespace Tango.DAL.Remote.DB
+{
+    using System;
+    using System.Collections.Generic;
+    
+    public partial class YARN_TYPE
+    {
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
+        public YARN_TYPE()
+        {
+            this.RMLS_EXTENSIONS = new HashSet<RMLS_EXTENSIONS>();
+        }
+    
+        public int ID { get; set; }
+        public string GUID { get; set; }
+        public System.DateTime LAST_UPDATED { get; set; }
+        public string NAME { get; set; }
+    
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
+        public virtual ICollection<RMLS_EXTENSIONS> RMLS_EXTENSIONS { get; set; }
+    }
+}
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/Tango.DAL.Remote.csproj b/Software/Visual_Studio/Tango.DAL.Remote/Tango.DAL.Remote.csproj
index 13d896eb2..32add4378 100644
--- a/Software/Visual_Studio/Tango.DAL.Remote/Tango.DAL.Remote.csproj
+++ b/Software/Visual_Studio/Tango.DAL.Remote/Tango.DAL.Remote.csproj
@@ -114,6 +114,15 @@
     <Compile Include="DB\COLOR_CATALOGS_ITEMS_RECIPES.cs">
       <DependentUpon>RemoteADO.tt</DependentUpon>
     </Compile>
+    <Compile Include="DB\COLOR_PROCESS_DATA.cs">
+      <DependentUpon>RemoteADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\COLOR_PROCESS_FACTOR.cs">
+      <DependentUpon>RemoteADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\COLOR_PROCESS_PARAMETERS.cs">
+      <DependentUpon>RemoteADO.tt</DependentUpon>
+    </Compile>
     <Compile Include="DB\COLOR_SPACES.cs">
       <DependentUpon>RemoteADO.tt</DependentUpon>
     </Compile>
@@ -351,6 +360,48 @@
     <Compile Include="DB\WINDING_METHODS.cs">
       <DependentUpon>RemoteADO.tt</DependentUpon>
     </Compile>
+    <Compile Include="DB\YARN_APPLICATIONS.cs">
+      <DependentUpon>RemoteADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\YARN_BRAND.cs">
+      <DependentUpon>RemoteADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\YARN_COLOR.cs">
+      <DependentUpon>RemoteADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\YARN_END_USE.cs">
+      <DependentUpon>RemoteADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\YARN_FAMILY.cs">
+      <DependentUpon>RemoteADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\YARN_GEOMETRY.cs">
+      <DependentUpon>RemoteADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\YARN_GLOSS_LEVEL.cs">
+      <DependentUpon>RemoteADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\YARN_GROUP.cs">
+      <DependentUpon>RemoteADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\YARN_INDUSTRYSECTOR.cs">
+      <DependentUpon>RemoteADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\YARN_MANUFACTURER.cs">
+      <DependentUpon>RemoteADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\YARN_MATERIALS.cs">
+      <DependentUpon>RemoteADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\YARN_SUB_FAMILY.cs">
+      <DependentUpon>RemoteADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\YARN_TEXTURING.cs">
+      <DependentUpon>RemoteADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\YARN_TYPE.cs">
+      <DependentUpon>RemoteADO.tt</DependentUpon>
+    </Compile>
     <Compile Include="Partials\RemoteDB.cs" />
     <Compile Include="Properties\AssemblyInfo.cs" />
   </ItemGroup>
@@ -401,7 +452,7 @@
   </Target>
   <ProjectExtensions>
     <VisualStudio>
-      <UserProperties BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UseGlobalSettings="False" BuildVersion_StartDate="2000/1/1" />
+      <UserProperties BuildVersion_StartDate="2000/1/1" BuildVersion_UseGlobalSettings="False" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" />
     </VisualStudio>
   </ProjectExtensions>
 </Project>
\ No newline at end of file