From 2bfa60ab677ec1da8f968614015ac0147694d31e Mon Sep 17 00:00:00 2001
From: Roy Ben Shabat <Roy.mail.net@gmail.com>
Date: Mon, 15 Feb 2021 17:19:40 +0200
Subject: BTSR DB, BL & PMR.

---
 .../Tango.DAL.Remote/DB/BTSR_APPLICATION_TYPES.cs  |  33 ++++
 .../Tango.DAL.Remote/DB/BTSR_YARN_TYPES.cs         |  33 ++++
 .../DB/PROCESS_PARAMETERS_TABLES.cs                |   3 +
 Software/Visual_Studio/Tango.DAL.Remote/DB/RML.cs  |   4 +
 .../Tango.DAL.Remote/DB/RMLS_SPOOLS.cs             |   1 +
 .../Tango.DAL.Remote/DB/RemoteADO.Context.cs       |   2 +
 .../Tango.DAL.Remote/DB/RemoteADO.edmx             | 161 +++++++++++++++++++
 .../Tango.DAL.Remote/DB/RemoteADO.edmx.diagram     | 174 +++++++++++----------
 .../Tango.DAL.Remote/DB/SPOOL_TYPES.cs             |   1 +
 .../Tango.DAL.Remote/Tango.DAL.Remote.csproj       |   8 +-
 10 files changed, 334 insertions(+), 86 deletions(-)
 create mode 100644 Software/Visual_Studio/Tango.DAL.Remote/DB/BTSR_APPLICATION_TYPES.cs
 create mode 100644 Software/Visual_Studio/Tango.DAL.Remote/DB/BTSR_YARN_TYPES.cs

(limited to 'Software/Visual_Studio/Tango.DAL.Remote')

diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/BTSR_APPLICATION_TYPES.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/BTSR_APPLICATION_TYPES.cs
new file mode 100644
index 000000000..a4ebc4b0f
--- /dev/null
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/BTSR_APPLICATION_TYPES.cs
@@ -0,0 +1,33 @@
+//------------------------------------------------------------------------------
+// <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 BTSR_APPLICATION_TYPES
+    {
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
+        public BTSR_APPLICATION_TYPES()
+        {
+            this.RMLS = new HashSet<RML>();
+        }
+    
+        public int ID { get; set; }
+        public string GUID { get; set; }
+        public System.DateTime LAST_UPDATED { get; set; }
+        public int CODE { get; set; }
+        public string NAME { get; set; }
+        public string DESCRIPTION { get; set; }
+    
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
+        public virtual ICollection<RML> RMLS { get; set; }
+    }
+}
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/BTSR_YARN_TYPES.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/BTSR_YARN_TYPES.cs
new file mode 100644
index 000000000..256af7baf
--- /dev/null
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/BTSR_YARN_TYPES.cs
@@ -0,0 +1,33 @@
+//------------------------------------------------------------------------------
+// <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 BTSR_YARN_TYPES
+    {
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
+        public BTSR_YARN_TYPES()
+        {
+            this.RMLS = new HashSet<RML>();
+        }
+    
+        public int ID { get; set; }
+        public string GUID { get; set; }
+        public System.DateTime LAST_UPDATED { get; set; }
+        public int CODE { get; set; }
+        public string NAME { get; set; }
+        public string DESCRIPTION { get; set; }
+    
+        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
+        public virtual ICollection<RML> RMLS { get; set; }
+    }
+}
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/PROCESS_PARAMETERS_TABLES.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/PROCESS_PARAMETERS_TABLES.cs
index 5896f742e..b4719188c 100644
--- a/Software/Visual_Studio/Tango.DAL.Remote/DB/PROCESS_PARAMETERS_TABLES.cs
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/PROCESS_PARAMETERS_TABLES.cs
@@ -50,6 +50,9 @@ namespace Tango.DAL.Remote.DB
         public double L_BLOWER_FLOW { get; set; }
         public double L_BLOWER_TEMP { get; set; }
         public double PRESSURE_BUILD_UP { get; set; }
+        public double BTSR_FEEDING_TENSION { get; set; }
+        public double BTSR_EXIT_TENSION { get; set; }
+        public double BTSR_THREAD_LENGTH_OFFSET { get; set; }
     
         public virtual PROCESS_PARAMETERS_TABLES_GROUPS PROCESS_PARAMETERS_TABLES_GROUPS { 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 f00189ce7..b5f9cacf3 100644
--- a/Software/Visual_Studio/Tango.DAL.Remote/DB/RML.cs
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/RML.cs
@@ -75,7 +75,11 @@ namespace Tango.DAL.Remote.DB
         public int CLEANER_FLOW { get; set; }
         public double ARC_HEAD_CLEANING_MOTOR_SPEED { get; set; }
         public double V_MAX { get; set; }
+        public string BTSR_APPLICATION_TYPE_GUID { get; set; }
+        public string BTSR_YARN_TYPE_GUID { get; set; }
     
+        public virtual BTSR_APPLICATION_TYPES BTSR_APPLICATION_TYPES { get; set; }
+        public virtual BTSR_YARN_TYPES BTSR_YARN_TYPES { get; set; }
         [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
         public virtual ICollection<CAT> CATS { get; set; }
         public virtual CCT CCT { get; set; }
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/RMLS_SPOOLS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/RMLS_SPOOLS.cs
index a314530ec..e6f7d52f7 100644
--- a/Software/Visual_Studio/Tango.DAL.Remote/DB/RMLS_SPOOLS.cs
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/RMLS_SPOOLS.cs
@@ -23,6 +23,7 @@ namespace Tango.DAL.Remote.DB
         public Nullable<double> LENGTH { get; set; }
         public Nullable<int> BACKING_RATE { get; set; }
         public Nullable<int> BOTTOM_BACKING_RATE { get; set; }
+        public Nullable<int> BTSR_SPOOL_TENSION { get; set; }
     
         public virtual RML RML { get; set; }
         public virtual SPOOL_TYPES SPOOL_TYPES { 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 49b63ad5d..c92b72726 100644
--- a/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.Context.cs
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.Context.cs
@@ -32,6 +32,8 @@ namespace Tango.DAL.Remote.DB
         public virtual DbSet<APPLICATION_FIRMWARE_VERSIONS> APPLICATION_FIRMWARE_VERSIONS { get; set; }
         public virtual DbSet<APPLICATION_OS_VERSIONS> APPLICATION_OS_VERSIONS { get; set; }
         public virtual DbSet<BRUSH_STOPS> BRUSH_STOPS { get; set; }
+        public virtual DbSet<BTSR_APPLICATION_TYPES> BTSR_APPLICATION_TYPES { get; set; }
+        public virtual DbSet<BTSR_YARN_TYPES> BTSR_YARN_TYPES { get; set; }
         public virtual DbSet<CARTRIDGE_TYPES> CARTRIDGE_TYPES { get; set; }
         public virtual DbSet<CAT> CATS { get; set; }
         public virtual DbSet<CCT> CCTS { 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 26e142522..a40614cf0 100644
--- a/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx
@@ -110,6 +110,28 @@
           <Property Name="COLOR_CATALOGS_ITEM_GUID" Type="varchar" MaxLength="36" />
           <Property Name="IS_TRANSPARENT" Type="bit" Nullable="false" />
         </EntityType>
+        <EntityType Name="BTSR_APPLICATION_TYPES">
+          <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="CODE" Type="int" Nullable="false" />
+          <Property Name="NAME" Type="varchar" MaxLength="100" Nullable="false" />
+          <Property Name="DESCRIPTION" Type="varchar" MaxLength="100" Nullable="false" />
+        </EntityType>
+        <EntityType Name="BTSR_YARN_TYPES">
+          <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="CODE" Type="int" Nullable="false" />
+          <Property Name="NAME" Type="varchar" MaxLength="100" Nullable="false" />
+          <Property Name="DESCRIPTION" Type="varchar" MaxLength="100" Nullable="false" />
+        </EntityType>
         <EntityType Name="CARTRIDGE_TYPES">
           <Key>
             <PropertyRef Name="GUID" />
@@ -956,6 +978,9 @@
           <Property Name="L_BLOWER_FLOW" Type="float" Nullable="false" />
           <Property Name="L_BLOWER_TEMP" Type="float" Nullable="false" />
           <Property Name="PRESSURE_BUILD_UP" Type="float" Nullable="false" />
+          <Property Name="BTSR_FEEDING_TENSION" Type="float" Nullable="false" />
+          <Property Name="BTSR_EXIT_TENSION" Type="float" Nullable="false" />
+          <Property Name="BTSR_THREAD_LENGTH_OFFSET" Type="float" Nullable="false" />
         </EntityType>
         <EntityType Name="PROCESS_PARAMETERS_TABLES_GROUPS">
           <Key>
@@ -1048,6 +1073,8 @@
           <Property Name="CLEANER_FLOW" Type="int" Nullable="false" />
           <Property Name="ARC_HEAD_CLEANING_MOTOR_SPEED" Type="float" Nullable="false" />
           <Property Name="V_MAX" Type="float" Nullable="false" />
+          <Property Name="BTSR_APPLICATION_TYPE_GUID" Type="varchar" MaxLength="36" />
+          <Property Name="BTSR_YARN_TYPE_GUID" Type="varchar" MaxLength="36" />
         </EntityType>
         <EntityType Name="RMLS_SPOOLS">
           <Key>
@@ -1062,6 +1089,7 @@
           <Property Name="LENGTH" Type="float" />
           <Property Name="BACKING_RATE" Type="int" />
           <Property Name="BOTTOM_BACKING_RATE" Type="int" />
+          <Property Name="BTSR_SPOOL_TENSION" Type="int" />
         </EntityType>
         <EntityType Name="ROLES">
           <Key>
@@ -1145,6 +1173,7 @@
           <Property Name="SEGMENT_OFFSET_PULSES" Type="int" Nullable="false" />
           <Property Name="BOTTOM_BACKING_RATE" Type="int" Nullable="false" />
           <Property Name="LIMIT_SWITCH_START_POINT_OFFSET" Type="int" Nullable="false" />
+          <Property Name="BTSR_SPOOL_TENSION" Type="int" Nullable="false" />
         </EntityType>
         <EntityType Name="SPOOLS">
           <Key>
@@ -2233,6 +2262,30 @@
             </Dependent>
           </ReferentialConstraint>
         </Association>
+        <Association Name="FK_RMLS_BTSR_APPLICATION_TYPES">
+          <End Role="BTSR_APPLICATION_TYPES" Type="Self.BTSR_APPLICATION_TYPES" Multiplicity="0..1" />
+          <End Role="RMLS" Type="Self.RMLS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="BTSR_APPLICATION_TYPES">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS">
+              <PropertyRef Name="BTSR_APPLICATION_TYPE_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_BTSR_YARN_TYPES">
+          <End Role="BTSR_YARN_TYPES" Type="Self.BTSR_YARN_TYPES" Multiplicity="0..1" />
+          <End Role="RMLS" Type="Self.RMLS" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="BTSR_YARN_TYPES">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RMLS">
+              <PropertyRef Name="BTSR_YARN_TYPE_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
         <Association Name="FK_RMLS_CCTS">
           <End Role="CCTS" Type="Self.CCTS" Multiplicity="0..1" />
           <End Role="RMLS" Type="Self.RMLS" Multiplicity="*" />
@@ -2506,6 +2559,8 @@
           <EntitySet Name="APPLICATION_FIRMWARE_VERSIONS" EntityType="Self.APPLICATION_FIRMWARE_VERSIONS" Schema="dbo" store:Type="Tables" />
           <EntitySet Name="APPLICATION_OS_VERSIONS" EntityType="Self.APPLICATION_OS_VERSIONS" Schema="dbo" store:Type="Tables" />
           <EntitySet Name="BRUSH_STOPS" EntityType="Self.BRUSH_STOPS" Schema="dbo" store:Type="Tables" />
+          <EntitySet Name="BTSR_APPLICATION_TYPES" EntityType="Self.BTSR_APPLICATION_TYPES" Schema="dbo" store:Type="Tables" />
+          <EntitySet Name="BTSR_YARN_TYPES" EntityType="Self.BTSR_YARN_TYPES" Schema="dbo" store:Type="Tables" />
           <EntitySet Name="CARTRIDGE_TYPES" EntityType="Self.CARTRIDGE_TYPES" Schema="dbo" store:Type="Tables" />
           <EntitySet Name="CATS" EntityType="Self.CATS" Schema="dbo" store:Type="Tables" />
           <EntitySet Name="CCTS" EntityType="Self.CCTS" Schema="dbo" store:Type="Tables" />
@@ -2862,6 +2917,14 @@
             <End Role="MEDIA_PURPOSES" EntitySet="MEDIA_PURPOSES" />
             <End Role="RMLS" EntitySet="RMLS" />
           </AssociationSet>
+          <AssociationSet Name="FK_RMLS_BTSR_APPLICATION_TYPES" Association="Self.FK_RMLS_BTSR_APPLICATION_TYPES">
+            <End Role="BTSR_APPLICATION_TYPES" EntitySet="BTSR_APPLICATION_TYPES" />
+            <End Role="RMLS" EntitySet="RMLS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_BTSR_YARN_TYPES" Association="Self.FK_RMLS_BTSR_YARN_TYPES">
+            <End Role="BTSR_YARN_TYPES" EntitySet="BTSR_YARN_TYPES" />
+            <End Role="RMLS" EntitySet="RMLS" />
+          </AssociationSet>
           <AssociationSet Name="FK_RMLS_CCTS" Association="Self.FK_RMLS_CCTS">
             <End Role="CCTS" EntitySet="CCTS" />
             <End Role="RMLS" EntitySet="RMLS" />
@@ -2955,6 +3018,8 @@
           <EntitySet Name="APPLICATION_FIRMWARE_VERSIONS" EntityType="RemoteModel.APPLICATION_FIRMWARE_VERSIONS" />
           <EntitySet Name="APPLICATION_OS_VERSIONS" EntityType="RemoteModel.APPLICATION_OS_VERSIONS" />
           <EntitySet Name="BRUSH_STOPS" EntityType="RemoteModel.BRUSH_STOPS" />
+          <EntitySet Name="BTSR_APPLICATION_TYPES" EntityType="RemoteModel.BTSR_APPLICATION_TYPES" />
+          <EntitySet Name="BTSR_YARN_TYPES" EntityType="RemoteModel.BTSR_YARN_TYPES" />
           <EntitySet Name="CARTRIDGE_TYPES" EntityType="RemoteModel.CARTRIDGE_TYPES" />
           <EntitySet Name="CATS" EntityType="RemoteModel.CAT" />
           <EntitySet Name="CCTS" EntityType="RemoteModel.CCT" />
@@ -3074,6 +3139,14 @@
             <End Role="SEGMENT" EntitySet="SEGMENTS" />
             <End Role="BRUSH_STOPS" EntitySet="BRUSH_STOPS" />
           </AssociationSet>
+          <AssociationSet Name="FK_RMLS_BTSR_APPLICATION_TYPES" Association="RemoteModel.FK_RMLS_BTSR_APPLICATION_TYPES">
+            <End Role="BTSR_APPLICATION_TYPES" EntitySet="BTSR_APPLICATION_TYPES" />
+            <End Role="RML" EntitySet="RMLS" />
+          </AssociationSet>
+          <AssociationSet Name="FK_RMLS_BTSR_YARN_TYPES" Association="RemoteModel.FK_RMLS_BTSR_YARN_TYPES">
+            <End Role="BTSR_YARN_TYPES" EntitySet="BTSR_YARN_TYPES" />
+            <End Role="RML" EntitySet="RMLS" />
+          </AssociationSet>
           <AssociationSet Name="FK_IDS_PACKS_CARTRIDGE_TYPES" Association="RemoteModel.FK_IDS_PACKS_CARTRIDGE_TYPES">
             <End Role="CARTRIDGE_TYPES" EntitySet="CARTRIDGE_TYPES" />
             <End Role="IDS_PACKS" EntitySet="IDS_PACKS" />
@@ -3514,6 +3587,30 @@
           <NavigationProperty Name="COLOR_SPACES" Relationship="RemoteModel.FK_BRUSH_STOPS_COLOR_SPACES" FromRole="BRUSH_STOPS" ToRole="COLOR_SPACES" />
           <NavigationProperty Name="SEGMENT" Relationship="RemoteModel.FK_BRUSH_STOPS_SEGMENTS" FromRole="BRUSH_STOPS" ToRole="SEGMENT" />
         </EntityType>
+        <EntityType Name="BTSR_APPLICATION_TYPES">
+          <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="CODE" Type="Int32" Nullable="false" />
+          <Property Name="NAME" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
+          <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
+          <NavigationProperty Name="RMLS" Relationship="RemoteModel.FK_RMLS_BTSR_APPLICATION_TYPES" FromRole="BTSR_APPLICATION_TYPES" ToRole="RML" />
+        </EntityType>
+        <EntityType Name="BTSR_YARN_TYPES">
+          <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="CODE" Type="Int32" Nullable="false" />
+          <Property Name="NAME" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
+          <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
+          <NavigationProperty Name="RMLS" Relationship="RemoteModel.FK_RMLS_BTSR_YARN_TYPES" FromRole="BTSR_YARN_TYPES" ToRole="RML" />
+        </EntityType>
         <EntityType Name="CARTRIDGE_TYPES">
           <Key>
             <PropertyRef Name="GUID" />
@@ -4474,6 +4571,9 @@
           <Property Name="L_BLOWER_FLOW" Type="Double" Nullable="false" />
           <Property Name="L_BLOWER_TEMP" Type="Double" Nullable="false" />
           <Property Name="PRESSURE_BUILD_UP" Type="Double" Nullable="false" />
+          <Property Name="BTSR_FEEDING_TENSION" Type="Double" Nullable="false" />
+          <Property Name="BTSR_EXIT_TENSION" Type="Double" Nullable="false" />
+          <Property Name="BTSR_THREAD_LENGTH_OFFSET" Type="Double" Nullable="false" />
           <NavigationProperty Name="PROCESS_PARAMETERS_TABLES_GROUPS" Relationship="RemoteModel.FK_PROCESS_PARAMETERS_TABLES_PROCESS_PARAMETERS_TABLES_GROUPS" FromRole="PROCESS_PARAMETERS_TABLES" ToRole="PROCESS_PARAMETERS_TABLES_GROUPS" />
         </EntityType>
         <EntityType Name="PROCESS_PARAMETERS_TABLES_GROUPS">
@@ -4571,6 +4671,10 @@
           <Property Name="CLEANER_FLOW" Type="Int32" Nullable="false" />
           <Property Name="ARC_HEAD_CLEANING_MOTOR_SPEED" Type="Double" Nullable="false" />
           <Property Name="V_MAX" Type="Double" Nullable="false" />
+          <Property Name="BTSR_APPLICATION_TYPE_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" />
+          <Property Name="BTSR_YARN_TYPE_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" />
+          <NavigationProperty Name="BTSR_APPLICATION_TYPES" Relationship="RemoteModel.FK_RMLS_BTSR_APPLICATION_TYPES" FromRole="RML" ToRole="BTSR_APPLICATION_TYPES" />
+          <NavigationProperty Name="BTSR_YARN_TYPES" Relationship="RemoteModel.FK_RMLS_BTSR_YARN_TYPES" FromRole="RML" ToRole="BTSR_YARN_TYPES" />
           <NavigationProperty Name="CATS" Relationship="RemoteModel.FK_CATS_RMLS" FromRole="RML" ToRole="CAT" />
           <NavigationProperty Name="CCT" Relationship="RemoteModel.FK_RMLS_CCTS" FromRole="RML" ToRole="CCT" />
           <NavigationProperty Name="COLOR_CATALOGS_ITEMS_RECIPES" Relationship="RemoteModel.FK_COLOR_CATALOGS_ITEMS_RECIPES_RMLS" FromRole="RML" ToRole="COLOR_CATALOGS_ITEMS_RECIPES" />
@@ -4599,6 +4703,7 @@
           <Property Name="LENGTH" Type="Double" />
           <Property Name="BACKING_RATE" Type="Int32" />
           <Property Name="BOTTOM_BACKING_RATE" Type="Int32" />
+          <Property Name="BTSR_SPOOL_TENSION" Type="Int32" />
           <NavigationProperty Name="RML" Relationship="RemoteModel.FK_RMLS_SPOOLS_RMLS" FromRole="RMLS_SPOOLS" ToRole="RML" />
           <NavigationProperty Name="SPOOL_TYPES" Relationship="RemoteModel.FK_RMLS_SPOOLS_SPOOL_TYPES" FromRole="RMLS_SPOOLS" ToRole="SPOOL_TYPES" />
         </EntityType>
@@ -4697,6 +4802,7 @@
           <Property Name="SEGMENT_OFFSET_PULSES" Type="Int32" Nullable="false" />
           <Property Name="BOTTOM_BACKING_RATE" Type="Int32" Nullable="false" />
           <Property Name="LIMIT_SWITCH_START_POINT_OFFSET" Type="Int32" Nullable="false" />
+          <Property Name="BTSR_SPOOL_TENSION" Type="Int32" Nullable="false" />
           <NavigationProperty Name="JOBS" Relationship="RemoteModel.FK_JOBS_SPOOL_TYPES" FromRole="SPOOL_TYPES" ToRole="JOB" />
           <NavigationProperty Name="RMLS_SPOOLS" Relationship="RemoteModel.FK_RMLS_SPOOLS_SPOOL_TYPES" FromRole="SPOOL_TYPES" ToRole="RMLS_SPOOLS" />
           <NavigationProperty Name="SPOOLS" Relationship="RemoteModel.FK_SPOOLS_SPOOL_TYPES" FromRole="SPOOL_TYPES" ToRole="SPOOL" />
@@ -5023,6 +5129,30 @@
             </Dependent>
           </ReferentialConstraint>
         </Association>
+        <Association Name="FK_RMLS_BTSR_APPLICATION_TYPES">
+          <End Type="RemoteModel.BTSR_APPLICATION_TYPES" Role="BTSR_APPLICATION_TYPES" Multiplicity="0..1" />
+          <End Type="RemoteModel.RML" Role="RML" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="BTSR_APPLICATION_TYPES">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RML">
+              <PropertyRef Name="BTSR_APPLICATION_TYPE_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
+        <Association Name="FK_RMLS_BTSR_YARN_TYPES">
+          <End Type="RemoteModel.BTSR_YARN_TYPES" Role="BTSR_YARN_TYPES" Multiplicity="0..1" />
+          <End Type="RemoteModel.RML" Role="RML" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="BTSR_YARN_TYPES">
+              <PropertyRef Name="GUID" />
+            </Principal>
+            <Dependent Role="RML">
+              <PropertyRef Name="BTSR_YARN_TYPE_GUID" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
         <Association Name="FK_IDS_PACKS_CARTRIDGE_TYPES">
           <End Type="RemoteModel.CARTRIDGE_TYPES" Role="CARTRIDGE_TYPES" Multiplicity="0..1" />
           <End Type="RemoteModel.IDS_PACKS" Role="IDS_PACKS" Multiplicity="*" />
@@ -6189,6 +6319,30 @@
               </MappingFragment>
             </EntityTypeMapping>
           </EntitySetMapping>
+          <EntitySetMapping Name="BTSR_APPLICATION_TYPES">
+            <EntityTypeMapping TypeName="RemoteModel.BTSR_APPLICATION_TYPES">
+              <MappingFragment StoreEntitySet="BTSR_APPLICATION_TYPES">
+                <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" />
+                <ScalarProperty Name="NAME" ColumnName="NAME" />
+                <ScalarProperty Name="CODE" ColumnName="CODE" />
+                <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
+                <ScalarProperty Name="GUID" ColumnName="GUID" />
+                <ScalarProperty Name="ID" ColumnName="ID" />
+              </MappingFragment>
+            </EntityTypeMapping>
+          </EntitySetMapping>
+          <EntitySetMapping Name="BTSR_YARN_TYPES">
+            <EntityTypeMapping TypeName="RemoteModel.BTSR_YARN_TYPES">
+              <MappingFragment StoreEntitySet="BTSR_YARN_TYPES">
+                <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" />
+                <ScalarProperty Name="NAME" ColumnName="NAME" />
+                <ScalarProperty Name="CODE" ColumnName="CODE" />
+                <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
+                <ScalarProperty Name="GUID" ColumnName="GUID" />
+                <ScalarProperty Name="ID" ColumnName="ID" />
+              </MappingFragment>
+            </EntityTypeMapping>
+          </EntitySetMapping>
           <EntitySetMapping Name="CARTRIDGE_TYPES">
             <EntityTypeMapping TypeName="RemoteModel.CARTRIDGE_TYPES">
               <MappingFragment StoreEntitySet="CARTRIDGE_TYPES">
@@ -7051,6 +7205,9 @@
           <EntitySetMapping Name="PROCESS_PARAMETERS_TABLES">
             <EntityTypeMapping TypeName="RemoteModel.PROCESS_PARAMETERS_TABLES">
               <MappingFragment StoreEntitySet="PROCESS_PARAMETERS_TABLES">
+                <ScalarProperty Name="BTSR_THREAD_LENGTH_OFFSET" ColumnName="BTSR_THREAD_LENGTH_OFFSET" />
+                <ScalarProperty Name="BTSR_EXIT_TENSION" ColumnName="BTSR_EXIT_TENSION" />
+                <ScalarProperty Name="BTSR_FEEDING_TENSION" ColumnName="BTSR_FEEDING_TENSION" />
                 <ScalarProperty Name="PRESSURE_BUILD_UP" ColumnName="PRESSURE_BUILD_UP" />
                 <ScalarProperty Name="L_BLOWER_TEMP" ColumnName="L_BLOWER_TEMP" />
                 <ScalarProperty Name="L_BLOWER_FLOW" ColumnName="L_BLOWER_FLOW" />
@@ -7134,6 +7291,8 @@
           <EntitySetMapping Name="RMLS">
             <EntityTypeMapping TypeName="RemoteModel.RML">
               <MappingFragment StoreEntitySet="RMLS">
+                <ScalarProperty Name="BTSR_YARN_TYPE_GUID" ColumnName="BTSR_YARN_TYPE_GUID" />
+                <ScalarProperty Name="BTSR_APPLICATION_TYPE_GUID" ColumnName="BTSR_APPLICATION_TYPE_GUID" />
                 <ScalarProperty Name="V_MAX" ColumnName="V_MAX" />
                 <ScalarProperty Name="ARC_HEAD_CLEANING_MOTOR_SPEED" ColumnName="ARC_HEAD_CLEANING_MOTOR_SPEED" />
                 <ScalarProperty Name="CLEANER_FLOW" ColumnName="CLEANER_FLOW" />
@@ -7189,6 +7348,7 @@
           <EntitySetMapping Name="RMLS_SPOOLS">
             <EntityTypeMapping TypeName="RemoteModel.RMLS_SPOOLS">
               <MappingFragment StoreEntitySet="RMLS_SPOOLS">
+                <ScalarProperty Name="BTSR_SPOOL_TENSION" ColumnName="BTSR_SPOOL_TENSION" />
                 <ScalarProperty Name="BOTTOM_BACKING_RATE" ColumnName="BOTTOM_BACKING_RATE" />
                 <ScalarProperty Name="BACKING_RATE" ColumnName="BACKING_RATE" />
                 <ScalarProperty Name="LENGTH" ColumnName="LENGTH" />
@@ -7274,6 +7434,7 @@
           <EntitySetMapping Name="SPOOL_TYPES">
             <EntityTypeMapping TypeName="RemoteModel.SPOOL_TYPES">
               <MappingFragment StoreEntitySet="SPOOL_TYPES">
+                <ScalarProperty Name="BTSR_SPOOL_TENSION" ColumnName="BTSR_SPOOL_TENSION" />
                 <ScalarProperty Name="LIMIT_SWITCH_START_POINT_OFFSET" ColumnName="LIMIT_SWITCH_START_POINT_OFFSET" />
                 <ScalarProperty Name="BOTTOM_BACKING_RATE" ColumnName="BOTTOM_BACKING_RATE" />
                 <ScalarProperty Name="SEGMENT_OFFSET_PULSES" ColumnName="SEGMENT_OFFSET_PULSES" />
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 ef97ba374..41e56d6d9 100644
--- a/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx.diagram
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx.diagram
@@ -5,91 +5,93 @@
     <!-- 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="13" />
-        <EntityTypeShape EntityType="RemoteModel.ADDRESS" Width="1.5" PointX="1.5" PointY="56.375" />
-        <EntityTypeShape EntityType="RemoteModel.APPLICATION_DISPLAY_PANEL_VERSIONS" Width="1.5" PointX="1.5" PointY="78.875" />
-        <EntityTypeShape EntityType="RemoteModel.APPLICATION_FIRMWARE_VERSIONS" Width="1.5" PointX="1.5" PointY="75.875" />
-        <EntityTypeShape EntityType="RemoteModel.APPLICATION_OS_VERSIONS" Width="1.5" PointX="1.5" PointY="84.75" />
-        <EntityTypeShape EntityType="RemoteModel.BRUSH_STOPS" Width="1.5" PointX="15.75" PointY="17.75" />
-        <EntityTypeShape EntityType="RemoteModel.CARTRIDGE_TYPES" Width="1.5" PointX="9" PointY="44.5" />
-        <EntityTypeShape EntityType="RemoteModel.CAT" Width="1.5" PointX="5.25" PointY="21" />
-        <EntityTypeShape EntityType="RemoteModel.CCT" Width="1.5" PointX="0.75" PointY="30.75" />
-        <EntityTypeShape EntityType="RemoteModel.COLOR_CATALOGS" Width="1.5" PointX="1.5" PointY="2.875" />
-        <EntityTypeShape EntityType="RemoteModel.COLOR_CATALOGS_GROUPS" Width="1.5" PointX="0.75" PointY="9.375" />
-        <EntityTypeShape EntityType="RemoteModel.COLOR_CATALOGS_ITEMS" Width="1.5" PointX="3" PointY="8.125" />
-        <EntityTypeShape EntityType="RemoteModel.COLOR_CATALOGS_ITEMS_RECIPES" Width="1.5" PointX="5.25" PointY="17" />
-        <EntityTypeShape EntityType="RemoteModel.COLOR_SPACES" Width="1.5" PointX="9" PointY="12.75" />
-        <EntityTypeShape EntityType="RemoteModel.CONFIGURATION" Width="1.5" PointX="0.75" PointY="70.25" />
-        <EntityTypeShape EntityType="RemoteModel.CONTACT" Width="1.5" PointX="1.5" PointY="60.5" />
-        <EntityTypeShape EntityType="RemoteModel.CUSTOMER" Width="1.5" PointX="9" PointY="9.25" />
-        <EntityTypeShape EntityType="RemoteModel.DATA_STORE_ITEMS" Width="1.5" PointX="5.25" PointY="57.375" />
-        <EntityTypeShape EntityType="RemoteModel.DISPENSER_TYPES" Width="1.5" PointX="6.75" PointY="80.625" />
-        <EntityTypeShape EntityType="RemoteModel.DISPENSER" Width="1.5" PointX="9" PointY="80" />
-        <EntityTypeShape EntityType="RemoteModel.EMBEDDED_FIRMWARE_VERSIONS" Width="1.5" PointX="1.5" PointY="81.75" />
-        <EntityTypeShape EntityType="RemoteModel.EVENT_TYPES" Width="1.5" PointX="9" PointY="85.25" />
-        <EntityTypeShape EntityType="RemoteModel.FIBER_SHAPES" Width="1.5" PointX="0.75" PointY="24.875" />
-        <EntityTypeShape EntityType="RemoteModel.FIBER_SYNTHS" Width="1.5" PointX="0.75" PointY="17" />
-        <EntityTypeShape EntityType="RemoteModel.FSE_VERSIONS" Width="1.5" PointX="11.25" PointY="9.375" />
-        <EntityTypeShape EntityType="RemoteModel.GLOBAL_DATA_STORE_ITEMS" Width="1.5" PointX="3.75" PointY="2" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_BLOWER_TYPES" Width="1.5" PointX="4.5" PointY="79.25" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_BLOWERS" Width="1.5" PointX="6.75" PointY="71.875" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_BREAK_SENSOR_TYPES" Width="1.5" PointX="1.5" PointY="92.25" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_BREAK_SENSORS" Width="1.5" PointX="3.75" PointY="71" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_DANCER_TYPES" Width="1.5" PointX="7.5" PointY="76.25" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_DANCERS" Width="1.5" PointX="9.75" PointY="69.125" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_MOTOR_TYPES" Width="1.5" PointX="4.5" PointY="75.125" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_MOTORS" Width="1.5" PointX="6.75" PointY="61.875" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_PID_CONTROL_TYPES" Width="1.5" PointX="1.5" PointY="88.25" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_PID_CONTROLS" Width="1.5" PointX="3.75" PointY="63.25" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_SPEED_SENSOR_TYPES" Width="1.5" PointX="7.5" PointY="58.25" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_SPEED_SENSORS" Width="1.5" PointX="9.75" PointY="61" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_VERSIONS" Width="1.5" PointX="1.5" PointY="64.625" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_WINDER_TYPES" Width="1.5" PointX="7.5" PointY="54.25" />
-        <EntityTypeShape EntityType="RemoteModel.HARDWARE_WINDERS" Width="1.5" PointX="9.75" PointY="65" />
-        <EntityTypeShape EntityType="RemoteModel.IDS_PACK_FORMULAS" Width="1.5" PointX="9" PointY="47.375" />
-        <EntityTypeShape EntityType="RemoteModel.IDS_PACKS" Width="1.5" PointX="11.25" PointY="40.875" />
-        <EntityTypeShape EntityType="RemoteModel.JOB_RUNS" Width="1.5" PointX="13.75" PointY="6" />
-        <EntityTypeShape EntityType="RemoteModel.JOB" Width="1.5" PointX="11.25" PointY="17.625" />
-        <EntityTypeShape EntityType="RemoteModel.LINEAR_MASS_DENSITY_UNITS" Width="1.5" PointX="0.75" PointY="27.75" />
-        <EntityTypeShape EntityType="RemoteModel.LIQUID_TYPES" Width="1.5" PointX="6" PointY="11.75" />
-        <EntityTypeShape EntityType="RemoteModel.LIQUID_TYPES_RMLS" Width="1.5" PointX="8.25" PointY="17.25" />
-        <EntityTypeShape EntityType="RemoteModel.MACHINE_PROTOTYPES" Width="1.5" PointX="5.75" PointY="2" />
-        <EntityTypeShape EntityType="RemoteModel.MACHINE_STUDIO_VERSIONS" Width="1.5" PointX="11.25" PointY="33.625" />
-        <EntityTypeShape EntityType="RemoteModel.MACHINE_VERSIONS" Width="1.5" PointX="0.75" PointY="45.375" />
-        <EntityTypeShape EntityType="RemoteModel.MACHINE" Width="1.5" PointX="3" PointY="45.875" />
-        <EntityTypeShape EntityType="RemoteModel.MACHINES_EVENTS" Width="1.5" PointX="11.25" PointY="28.625" />
-        <EntityTypeShape EntityType="RemoteModel.MEDIA_CONDITIONS" Width="1.5" PointX="0.75" PointY="21.5" />
-        <EntityTypeShape EntityType="RemoteModel.MEDIA_MATERIALS" Width="1.5" PointX="0.75" PointY="14" />
-        <EntityTypeShape EntityType="RemoteModel.MEDIA_PURPOSES" Width="1.5" PointX="0.75" PointY="34" />
-        <EntityTypeShape EntityType="RemoteModel.MID_TANK_TYPES" Width="1.5" PointX="9" PointY="50.75" />
-        <EntityTypeShape EntityType="RemoteModel.ORGANIZATION" Width="1.5" PointX="0.75" PointY="39.375" />
-        <EntityTypeShape EntityType="RemoteModel.PERMISSION" Width="1.5" PointX="9" PointY="94.625" />
-        <EntityTypeShape EntityType="RemoteModel.PROCESS_PARAMETERS_TABLES" Width="1.5" PointX="7.5" PointY="29.625" />
-        <EntityTypeShape EntityType="RemoteModel.PROCESS_PARAMETERS_TABLES_GROUPS" Width="1.5" PointX="5.25" PointY="32.375" />
-        <EntityTypeShape EntityType="RemoteModel.PUBLISHED_PROCEDURE_PROJECTS" Width="1.5" PointX="13.75" PointY="2.25" />
-        <EntityTypeShape EntityType="RemoteModel.PUBLISHED_PROCEDURE_PROJECTS_VERSIONS" Width="1.5" PointX="16" PointY="2.375" />
-        <EntityTypeShape EntityType="RemoteModel.RML" Width="1.5" PointX="3" PointY="16" />
-        <EntityTypeShape EntityType="RemoteModel.RMLS_SPOOLS" Width="1.5" PointX="5.25" PointY="25" />
-        <EntityTypeShape EntityType="RemoteModel.ROLE" Width="1.5" PointX="9" PointY="90.625" />
-        <EntityTypeShape EntityType="RemoteModel.ROLES_PERMISSIONS" Width="1.5" PointX="11.25" PointY="90.625" />
-        <EntityTypeShape EntityType="RemoteModel.SEGMENT" Width="1.5" PointX="13.5" PointY="21.25" />
-        <EntityTypeShape EntityType="RemoteModel.SITE" Width="1.5" PointX="6" PointY="8.25" />
-        <EntityTypeShape EntityType="RemoteModel.SITES_CATALOGS" Width="1.5" PointX="11.25" PointY="0.75" />
-        <EntityTypeShape EntityType="RemoteModel.SITES_RMLS" Width="1.5" PointX="8.25" PointY="21.5" />
-        <EntityTypeShape EntityType="RemoteModel.SPOOL_TYPES" Width="1.5" PointX="9" PointY="39.125" />
-        <EntityTypeShape EntityType="RemoteModel.SPOOL" Width="1.5" PointX="11.25" PointY="46.625" />
-        <EntityTypeShape EntityType="RemoteModel.sysdiagram" Width="1.5" PointX="5.75" PointY="5" />
-        <EntityTypeShape EntityType="RemoteModel.TANGO_UPDATES" Width="1.5" PointX="15.75" PointY="6" />
-        <EntityTypeShape EntityType="RemoteModel.TANGO_VERSIONS" Width="1.5" PointX="14.25" PointY="28.875" />
-        <EntityTypeShape EntityType="RemoteModel.TECH_CONTROLLERS" Width="1.5" PointX="15.75" PointY="11" />
-        <EntityTypeShape EntityType="RemoteModel.TECH_DISPENSERS" Width="1.5" PointX="17.75" PointY="6" />
-        <EntityTypeShape EntityType="RemoteModel.TECH_HEATERS" Width="1.5" PointX="17.75" PointY="9" />
-        <EntityTypeShape EntityType="RemoteModel.TECH_IOS" Width="1.5" PointX="17.75" PointY="12" />
-        <EntityTypeShape EntityType="RemoteModel.TECH_MONITORS" Width="1.5" PointX="17.75" PointY="17" />
-        <EntityTypeShape EntityType="RemoteModel.TECH_VALVES" Width="1.5" PointX="18.75" PointY="2" />
-        <EntityTypeShape EntityType="RemoteModel.USER" Width="1.5" PointX="9" PointY="3.375" />
-        <EntityTypeShape EntityType="RemoteModel.USERS_ROLES" Width="1.5" PointX="11.25" PointY="4.625" />
-        <EntityTypeShape EntityType="RemoteModel.WINDING_METHODS" Width="1.5" PointX="9" PointY="26.125" />
+        <EntityTypeShape EntityType="RemoteModel.ACTION_LOGS" Width="1.5" PointX="11.25" PointY="10.625" />
+        <EntityTypeShape EntityType="RemoteModel.ADDRESS" Width="1.5" PointX="1.5" PointY="42" />
+        <EntityTypeShape EntityType="RemoteModel.APPLICATION_DISPLAY_PANEL_VERSIONS" Width="1.5" PointX="4.5" PointY="71.375" />
+        <EntityTypeShape EntityType="RemoteModel.APPLICATION_FIRMWARE_VERSIONS" Width="1.5" PointX="4.5" PointY="68.5" />
+        <EntityTypeShape EntityType="RemoteModel.APPLICATION_OS_VERSIONS" Width="1.5" PointX="4.5" PointY="62.625" />
+        <EntityTypeShape EntityType="RemoteModel.BRUSH_STOPS" Width="1.5" PointX="15.75" PointY="18.875" />
+        <EntityTypeShape EntityType="RemoteModel.BTSR_APPLICATION_TYPES" Width="1.5" PointX="0.75" PointY="15" />
+        <EntityTypeShape EntityType="RemoteModel.BTSR_YARN_TYPES" Width="1.5" PointX="0.75" PointY="31.875" />
+        <EntityTypeShape EntityType="RemoteModel.CARTRIDGE_TYPES" Width="1.5" PointX="9.75" PointY="87" />
+        <EntityTypeShape EntityType="RemoteModel.CAT" Width="1.5" PointX="5.25" PointY="26.25" />
+        <EntityTypeShape EntityType="RemoteModel.CCT" Width="1.5" PointX="0.75" PointY="37.875" />
+        <EntityTypeShape EntityType="RemoteModel.COLOR_CATALOGS" Width="1.5" PointX="1.5" PointY="53" />
+        <EntityTypeShape EntityType="RemoteModel.COLOR_CATALOGS_GROUPS" Width="1.5" PointX="0.75" PointY="47.5" />
+        <EntityTypeShape EntityType="RemoteModel.COLOR_CATALOGS_ITEMS" Width="1.5" PointX="3" PointY="46.25" />
+        <EntityTypeShape EntityType="RemoteModel.COLOR_CATALOGS_ITEMS_RECIPES" Width="1.5" PointX="5.25" PointY="22.125" />
+        <EntityTypeShape EntityType="RemoteModel.COLOR_SPACES" Width="1.5" PointX="9" PointY="40.625" />
+        <EntityTypeShape EntityType="RemoteModel.CONFIGURATION" Width="1.5" PointX="6.75" PointY="64" />
+        <EntityTypeShape EntityType="RemoteModel.CONTACT" Width="1.5" PointX="1.5" PointY="1.125" />
+        <EntityTypeShape EntityType="RemoteModel.CUSTOMER" Width="1.5" PointX="9" PointY="15.125" />
+        <EntityTypeShape EntityType="RemoteModel.DATA_STORE_ITEMS" Width="1.5" PointX="11.25" PointY="74.375" />
+        <EntityTypeShape EntityType="RemoteModel.DISPENSER_TYPES" Width="1.5" PointX="7.5" PointY="90.5" />
+        <EntityTypeShape EntityType="RemoteModel.DISPENSER" Width="1.5" PointX="9.75" PointY="90" />
+        <EntityTypeShape EntityType="RemoteModel.EMBEDDED_FIRMWARE_VERSIONS" Width="1.5" PointX="4.5" PointY="65.625" />
+        <EntityTypeShape EntityType="RemoteModel.EVENT_TYPES" Width="1.5" PointX="9" PointY="95.125" />
+        <EntityTypeShape EntityType="RemoteModel.FIBER_SHAPES" Width="1.5" PointX="0.75" PointY="22.625" />
+        <EntityTypeShape EntityType="RemoteModel.FIBER_SYNTHS" Width="1.5" PointX="0.75" PointY="29" />
+        <EntityTypeShape EntityType="RemoteModel.FSE_VERSIONS" Width="1.5" PointX="11.25" PointY="15.125" />
+        <EntityTypeShape EntityType="RemoteModel.GLOBAL_DATA_STORE_ITEMS" Width="1.5" PointX="5.75" PointY="2.75" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_BLOWER_TYPES" Width="1.5" PointX="10.5" PointY="79" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_BLOWERS" Width="1.5" PointX="12.75" PointY="58.625" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_BREAK_SENSOR_TYPES" Width="1.5" PointX="4.5" PointY="43" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_BREAK_SENSORS" Width="1.5" PointX="6.75" PointY="58.625" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_DANCER_TYPES" Width="1.5" PointX="9.5" PointY="83" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_DANCERS" Width="1.5" PointX="11.75" PointY="62.875" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_MOTOR_TYPES" Width="1.5" PointX="12.5" PointY="68.875" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_MOTORS" Width="1.5" PointX="14.75" PointY="62.625" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_PID_CONTROL_TYPES" Width="1.5" PointX="7.5" PointY="37" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_PID_CONTROLS" Width="1.5" PointX="9.75" PointY="55" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_SPEED_SENSOR_TYPES" Width="1.5" PointX="10.5" PointY="47" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_SPEED_SENSORS" Width="1.5" PointX="12.75" PointY="54.625" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_VERSIONS" Width="1.5" PointX="4.5" PointY="58.375" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_WINDER_TYPES" Width="1.5" PointX="7.5" PointY="45" />
+        <EntityTypeShape EntityType="RemoteModel.HARDWARE_WINDERS" Width="1.5" PointX="9.75" PointY="50.75" />
+        <EntityTypeShape EntityType="RemoteModel.IDS_PACK_FORMULAS" Width="1.5" PointX="9.75" PointY="30.5" />
+        <EntityTypeShape EntityType="RemoteModel.IDS_PACKS" Width="1.5" PointX="12" PointY="38.875" />
+        <EntityTypeShape EntityType="RemoteModel.JOB_RUNS" Width="1.5" PointX="13.75" PointY="5.75" />
+        <EntityTypeShape EntityType="RemoteModel.JOB" Width="1.5" PointX="11.25" PointY="18.75" />
+        <EntityTypeShape EntityType="RemoteModel.LINEAR_MASS_DENSITY_UNITS" Width="1.5" PointX="0.75" PointY="12" />
+        <EntityTypeShape EntityType="RemoteModel.LIQUID_TYPES" Width="1.5" PointX="6" PointY="13.875" />
+        <EntityTypeShape EntityType="RemoteModel.LIQUID_TYPES_RMLS" Width="1.5" PointX="8.25" PointY="18.375" />
+        <EntityTypeShape EntityType="RemoteModel.MACHINE_PROTOTYPES" Width="1.5" PointX="5.75" PointY="6.75" />
+        <EntityTypeShape EntityType="RemoteModel.MACHINE_STUDIO_VERSIONS" Width="1.5" PointX="11.25" PointY="6.375" />
+        <EntityTypeShape EntityType="RemoteModel.MACHINE_VERSIONS" Width="1.5" PointX="6.75" PointY="74.375" />
+        <EntityTypeShape EntityType="RemoteModel.MACHINE" Width="1.5" PointX="9" PointY="62.875" />
+        <EntityTypeShape EntityType="RemoteModel.MACHINES_EVENTS" Width="1.5" PointX="11.25" PointY="34.5" />
+        <EntityTypeShape EntityType="RemoteModel.MEDIA_CONDITIONS" Width="1.5" PointX="0.75" PointY="35" />
+        <EntityTypeShape EntityType="RemoteModel.MEDIA_MATERIALS" Width="1.5" PointX="0.75" PointY="26" />
+        <EntityTypeShape EntityType="RemoteModel.MEDIA_PURPOSES" Width="1.5" PointX="0.75" PointY="18.125" />
+        <EntityTypeShape EntityType="RemoteModel.MID_TANK_TYPES" Width="1.5" PointX="9.75" PointY="0.75" />
+        <EntityTypeShape EntityType="RemoteModel.ORGANIZATION" Width="1.5" PointX="0.75" PointY="5.125" />
+        <EntityTypeShape EntityType="RemoteModel.PERMISSION" Width="1.5" PointX="10" PointY="105" />
+        <EntityTypeShape EntityType="RemoteModel.PROCESS_PARAMETERS_TABLES" Width="1.5" PointX="7.5" PointY="48.875" />
+        <EntityTypeShape EntityType="RemoteModel.PROCESS_PARAMETERS_TABLES_GROUPS" Width="1.5" PointX="5.25" PointY="51.875" />
+        <EntityTypeShape EntityType="RemoteModel.PUBLISHED_PROCEDURE_PROJECTS" Width="1.5" PointX="2.75" PointY="9.875" />
+        <EntityTypeShape EntityType="RemoteModel.PUBLISHED_PROCEDURE_PROJECTS_VERSIONS" Width="1.5" PointX="5" PointY="10.125" />
+        <EntityTypeShape EntityType="RemoteModel.RML" Width="1.5" PointX="3" PointY="16.75" />
+        <EntityTypeShape EntityType="RemoteModel.RMLS_SPOOLS" Width="1.5" PointX="8.25" PointY="22.125" />
+        <EntityTypeShape EntityType="RemoteModel.ROLE" Width="1.5" PointX="10" PointY="101" />
+        <EntityTypeShape EntityType="RemoteModel.ROLES_PERMISSIONS" Width="1.5" PointX="12.25" PointY="101" />
+        <EntityTypeShape EntityType="RemoteModel.SEGMENT" Width="1.5" PointX="13.5" PointY="22.375" />
+        <EntityTypeShape EntityType="RemoteModel.SITE" Width="1.5" PointX="3" PointY="5.375" />
+        <EntityTypeShape EntityType="RemoteModel.SITES_CATALOGS" Width="1.5" PointX="5.25" PointY="30.75" />
+        <EntityTypeShape EntityType="RemoteModel.SITES_RMLS" Width="1.5" PointX="5.25" PointY="18.625" />
+        <EntityTypeShape EntityType="RemoteModel.SPOOL_TYPES" Width="1.5" PointX="9" PointY="9.875" />
+        <EntityTypeShape EntityType="RemoteModel.SPOOL" Width="1.5" PointX="14.25" PointY="38.5" />
+        <EntityTypeShape EntityType="RemoteModel.sysdiagram" Width="1.5" PointX="2.75" PointY="13.75" />
+        <EntityTypeShape EntityType="RemoteModel.TANGO_UPDATES" Width="1.5" PointX="13.75" PointY="14.75" />
+        <EntityTypeShape EntityType="RemoteModel.TANGO_VERSIONS" Width="1.5" PointX="14.25" PointY="42.75" />
+        <EntityTypeShape EntityType="RemoteModel.TECH_CONTROLLERS" Width="1.5" PointX="15.75" PointY="2.75" />
+        <EntityTypeShape EntityType="RemoteModel.TECH_DISPENSERS" Width="1.5" PointX="15.75" PointY="6.75" />
+        <EntityTypeShape EntityType="RemoteModel.TECH_HEATERS" Width="1.5" PointX="15.75" PointY="9.75" />
+        <EntityTypeShape EntityType="RemoteModel.TECH_IOS" Width="1.5" PointX="15.75" PointY="12.75" />
+        <EntityTypeShape EntityType="RemoteModel.TECH_MONITORS" Width="1.5" PointX="17.75" PointY="2.75" />
+        <EntityTypeShape EntityType="RemoteModel.TECH_VALVES" Width="1.5" PointX="17.75" PointY="7.75" />
+        <EntityTypeShape EntityType="RemoteModel.USER" Width="1.5" PointX="9" PointY="4.125" />
+        <EntityTypeShape EntityType="RemoteModel.USERS_ROLES" Width="1.5" PointX="12.25" PointY="2.5" />
+        <EntityTypeShape EntityType="RemoteModel.WINDING_METHODS" Width="1.5" PointX="9" PointY="26.25" />
         <AssociationConnector Association="RemoteModel.FK_ACTION_LOGS_USERS" />
         <AssociationConnector Association="RemoteModel.FK_ORGANIZATIONS_ADDRESSES" />
         <AssociationConnector Association="RemoteModel.FK_USERS_ADDRESSES" />
@@ -100,6 +102,8 @@
         <AssociationConnector Association="RemoteModel.FK_BRUSH_STOPS_COLOR_CATALOGS_ITEMS" />
         <AssociationConnector Association="RemoteModel.FK_BRUSH_STOPS_COLOR_SPACES" />
         <AssociationConnector Association="RemoteModel.FK_BRUSH_STOPS_SEGMENTS" />
+        <AssociationConnector Association="RemoteModel.FK_RMLS_BTSR_APPLICATION_TYPES" />
+        <AssociationConnector Association="RemoteModel.FK_RMLS_BTSR_YARN_TYPES" />
         <AssociationConnector Association="RemoteModel.FK_IDS_PACKS_CARTRIDGE_TYPES" />
         <AssociationConnector Association="RemoteModel.FK_CATS_LIQUID_TYPES1" />
         <AssociationConnector Association="RemoteModel.FK_CATS_MACHINES" />
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/SPOOL_TYPES.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/SPOOL_TYPES.cs
index af2355553..836112ec7 100644
--- a/Software/Visual_Studio/Tango.DAL.Remote/DB/SPOOL_TYPES.cs
+++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/SPOOL_TYPES.cs
@@ -36,6 +36,7 @@ namespace Tango.DAL.Remote.DB
         public int SEGMENT_OFFSET_PULSES { get; set; }
         public int BOTTOM_BACKING_RATE { get; set; }
         public int LIMIT_SWITCH_START_POINT_OFFSET { get; set; }
+        public int BTSR_SPOOL_TENSION { get; set; }
     
         [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
         public virtual ICollection<JOB> JOBS { 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 bdb0b7715..6cf0f995c 100644
--- a/Software/Visual_Studio/Tango.DAL.Remote/Tango.DAL.Remote.csproj
+++ b/Software/Visual_Studio/Tango.DAL.Remote/Tango.DAL.Remote.csproj
@@ -84,6 +84,12 @@
     <Compile Include="DB\BRUSH_STOPS.cs">
       <DependentUpon>RemoteADO.tt</DependentUpon>
     </Compile>
+    <Compile Include="DB\BTSR_APPLICATION_TYPES.cs">
+      <DependentUpon>RemoteADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\BTSR_YARN_TYPES.cs">
+      <DependentUpon>RemoteADO.tt</DependentUpon>
+    </Compile>
     <Compile Include="DB\CARTRIDGE_TYPES.cs">
       <DependentUpon>RemoteADO.tt</DependentUpon>
     </Compile>
@@ -389,7 +395,7 @@
   </Target>
   <ProjectExtensions>
     <VisualStudio>
-      <UserProperties BuildVersion_StartDate="2000/1/1" BuildVersion_UseGlobalSettings="False" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" />
+      <UserProperties BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UseGlobalSettings="False" BuildVersion_StartDate="2000/1/1" />
     </VisualStudio>
   </ProjectExtensions>
 </Project>
\ No newline at end of file
-- 
cgit v1.3.1