diff options
27 files changed, 1419 insertions, 392 deletions
diff --git a/Software/DB/Tango-old.db b/Software/DB/Tango-old.db Binary files differnew file mode 100644 index 000000000..0693a2623 --- /dev/null +++ b/Software/DB/Tango-old.db diff --git a/Software/DB/Tango.db b/Software/DB/Tango.db Binary files differindex 0693a2623..081f6ce61 100644 --- a/Software/DB/Tango.db +++ b/Software/DB/Tango.db diff --git a/Software/DB/Tango.mdf b/Software/DB/Tango.mdf Binary files differindex b2f5b395c..330100d0b 100644 --- a/Software/DB/Tango.mdf +++ b/Software/DB/Tango.mdf diff --git a/Software/DB/Tango_log.ldf b/Software/DB/Tango_log.ldf Binary files differindex 3bab614f7..7b95ce038 100644 --- a/Software/DB/Tango_log.ldf +++ b/Software/DB/Tango_log.ldf diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/BRUSH_STOPS.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/BRUSH_STOPS.cs new file mode 100644 index 000000000..0aac9e9d8 --- /dev/null +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/BRUSH_STOPS.cs @@ -0,0 +1,35 @@ +//------------------------------------------------------------------------------ +// <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.Local.DB +{ + using System; + using System.Collections.Generic; + + public partial class BRUSH_STOPS + { + public long ID { get; set; } + public string GUID { get; set; } + public System.DateTime LAST_UPDATED { get; set; } + public string SEGMENT_GUID { get; set; } + public string COLOR_SPACE_GUID { get; set; } + public double OFFSET_PERCENT { get; set; } + public double CYAN { get; set; } + public double MAGENTA { get; set; } + public double YELLOW { get; set; } + public double BLACK { get; set; } + public long RED { get; set; } + public long GREEN { get; set; } + public long BLUE { get; set; } + public long L { get; set; } + public long A { get; set; } + public long B { get; set; } + public string PANTON_GUID { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/CAT.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/CAT.cs index 8b610ca97..14a746a89 100644 --- a/Software/Visual_Studio/Tango.DAL.Local/DB/CAT.cs +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/CAT.cs @@ -17,8 +17,9 @@ namespace Tango.DAL.Local.DB public long ID { get; set; } public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } + public string NAME { get; set; } public string LIQUID_TYPE_GUID { get; set; } - public string MACHINE_GUID { get; set; } + public string RML_GUID { get; set; } public byte[] DATA { get; set; } } } diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/COLOR_SPACES.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/COLOR_SPACES.cs new file mode 100644 index 000000000..a466897e0 --- /dev/null +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/COLOR_SPACES.cs @@ -0,0 +1,24 @@ +//------------------------------------------------------------------------------ +// <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.Local.DB +{ + using System; + using System.Collections.Generic; + + public partial class COLOR_SPACES + { + public long ID { get; set; } + public string GUID { get; set; } + public System.DateTime LAST_UPDATED { get; set; } + public long CODE { get; set; } + public string NAME { get; set; } + public string DESCRIPTION { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/JOB.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/JOB.cs new file mode 100644 index 000000000..8b4f27fa5 --- /dev/null +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/JOB.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.Local.DB +{ + using System; + using System.Collections.Generic; + + public partial class JOB + { + public long ID { get; set; } + public string GUID { get; set; } + public System.DateTime LAST_UPDATED { get; set; } + public System.DateTime CREATION_DATE { get; set; } + public string MACHINE_GUID { get; set; } + public string RML_GUID { get; set; } + public string WINDING_METHOD_GUID { get; set; } + public string NAME { get; set; } + public string DESCRIPTION { get; set; } + public double INTER_SEGMENT_LENGTH { get; set; } + public bool ENABLE_INTER_SEGMENT { get; set; } + public bool ENABLE_LUBRICATION { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/JOB_RUNS.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/JOB_RUNS.cs new file mode 100644 index 000000000..c2535012d --- /dev/null +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/JOB_RUNS.cs @@ -0,0 +1,25 @@ +//------------------------------------------------------------------------------ +// <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.Local.DB +{ + using System; + using System.Collections.Generic; + + public partial class JOB_RUNS + { + public long ID { get; set; } + public string GUID { get; set; } + public System.DateTime LAST_UPDATED { get; set; } + public string JOB_GUID { get; set; } + public System.DateTime START_DATE { get; set; } + public System.DateTime END_DATE { get; set; } + public bool SUCCESSFUL { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.Context.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.Context.cs index 2d9091e58..0dffbab6c 100644 --- a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.Context.cs +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.Context.cs @@ -31,9 +31,11 @@ namespace Tango.DAL.Local.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<APPLICATION_VERSIONS> APPLICATION_VERSIONS { get; set; } + public virtual DbSet<BRUSH_STOPS> BRUSH_STOPS { 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; } + public virtual DbSet<COLOR_SPACES> COLOR_SPACES { get; set; } public virtual DbSet<CONFIGURATION> CONFIGURATIONS { get; set; } public virtual DbSet<CONTACT> CONTACTS { get; set; } public virtual DbSet<DISPENSER_TYPES> DISPENSER_TYPES { get; set; } @@ -45,6 +47,8 @@ namespace Tango.DAL.Local.DB public virtual DbSet<FIBER_SYNTHS> FIBER_SYNTHS { get; set; } public virtual DbSet<HARDWARE_VERSIONS> HARDWARE_VERSIONS { get; set; } public virtual DbSet<IDS_PACKS> IDS_PACKS { get; set; } + public virtual DbSet<JOB_RUNS> JOB_RUNS { get; set; } + public virtual DbSet<JOB> JOBS { get; set; } public virtual DbSet<LINEAR_MASS_DENSITY_UNITS> LINEAR_MASS_DENSITY_UNITS { get; set; } public virtual DbSet<LIQUID_TYPES> LIQUID_TYPES { get; set; } public virtual DbSet<LIQUID_TYPES_RMLS> LIQUID_TYPES_RMLS { get; set; } @@ -59,11 +63,16 @@ namespace Tango.DAL.Local.DB public virtual DbSet<MID_TANK_TYPES> MID_TANK_TYPES { get; set; } public virtual DbSet<ORGANIZATION> ORGANIZATIONS { get; set; } public virtual DbSet<PERMISSION> PERMISSIONS { get; set; } + public virtual DbSet<PROCESS_PARAMETERS_TABLES> PROCESS_PARAMETERS_TABLES { get; set; } + public virtual DbSet<PROCESS_PARAMETERS_TABLES_GROUPS> PROCESS_PARAMETERS_TABLES_GROUPS { get; set; } public virtual DbSet<RML> RMLS { get; set; } public virtual DbSet<ROLE> ROLES { get; set; } public virtual DbSet<ROLES_PERMISSIONS> ROLES_PERMISSIONS { get; set; } + public virtual DbSet<SEGMENT> SEGMENTS { get; set; } + public virtual DbSet<SENSOR> SENSORS { get; set; } public virtual DbSet<SYNC_CONFIGURATIONS> SYNC_CONFIGURATIONS { get; set; } 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; } } } diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx index 9fb01760a..23fbed26c 100644 --- a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx @@ -9,147 +9,181 @@ <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="100" Nullable="false" /> </EntityType> <EntityType Name="ADDRESSES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> - <Property Name="ADDRESS_STRING" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="LOCALITY" Type="nvarchar" MaxLength="2147483647" /> - <Property Name="COUNTRY" Type="nvarchar" MaxLength="2147483647" /> - <Property Name="CITY" Type="nvarchar" MaxLength="2147483647" /> - <Property Name="STATE" Type="nvarchar" MaxLength="2147483647" /> - <Property Name="COUNTRY_CODE" Type="nvarchar" MaxLength="2147483647" /> - <Property Name="POSTAL_CODE" Type="nvarchar" MaxLength="2147483647" /> + <Property Name="ADDRESS_STRING" Type="nvarchar" MaxLength="100" Nullable="false" /> + <Property Name="LOCALITY" Type="nvarchar" MaxLength="56" /> + <Property Name="COUNTRY" Type="nvarchar" MaxLength="50" /> + <Property Name="CITY" Type="nvarchar" MaxLength="30" /> + <Property Name="STATE" Type="nvarchar" MaxLength="30" /> + <Property Name="COUNTRY_CODE" Type="nvarchar" MaxLength="2" /> + <Property Name="POSTAL_CODE" Type="nvarchar" MaxLength="15" /> </EntityType> <EntityType Name="APPLICATION_DISPLAY_PANEL_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="VERSION" Type="real" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> </EntityType> <EntityType Name="APPLICATION_FIRMWARE_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="VERSION" Type="real" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> </EntityType> <EntityType Name="APPLICATION_OS_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="VERSION" Type="real" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> </EntityType> <EntityType Name="APPLICATION_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="VERSION" Type="real" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + </EntityType> + <EntityType Name="BRUSH_STOPS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="SEGMENT_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="COLOR_SPACE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="OFFSET_PERCENT" Type="real" Nullable="false" /> + <Property Name="CYAN" Type="real" Nullable="false" /> + <Property Name="MAGENTA" Type="real" Nullable="false" /> + <Property Name="YELLOW" Type="real" Nullable="false" /> + <Property Name="BLACK" Type="real" Nullable="false" /> + <Property Name="RED" Type="integer" Nullable="false" /> + <Property Name="GREEN" Type="integer" Nullable="false" /> + <Property Name="BLUE" Type="integer" Nullable="false" /> + <Property Name="L" Type="integer" Nullable="false" /> + <Property Name="A" Type="integer" Nullable="false" /> + <Property Name="B" Type="integer" Nullable="false" /> + <Property Name="PANTON_GUID" Type="varchar" MaxLength="36" /> </EntityType> <EntityType Name="CARTRIDGE_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> </EntityType> <EntityType Name="CATS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="LIQUID_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="MACHINE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="LIQUID_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="RML_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="DATA" Type="blob" Nullable="false" /> </EntityType> <EntityType Name="CCTS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="FORWARD_FILE_NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="INVERSE_FILE_NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="100" Nullable="false" /> + <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="200" Nullable="false" /> + <Property Name="FORWARD_FILE_NAME" Type="nvarchar" MaxLength="100" Nullable="false" /> + <Property Name="INVERSE_FILE_NAME" Type="nvarchar" MaxLength="100" Nullable="false" /> <Property Name="FORWARD_DATA" Type="blob" Nullable="false" /> <Property Name="INVERSE_DATA" Type="blob" Nullable="false" /> <Property Name="VERSION" Type="real" Nullable="false" /> - <Property Name="RML_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="RML_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + </EntityType> + <EntityType Name="COLOR_SPACES"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="CODE" Type="integer" Nullable="false" /> + <Property Name="NAME" Type="varchar" MaxLength="50" Nullable="false" /> + <Property Name="DESCRIPTION" Type="varchar" MaxLength="100" Nullable="false" /> </EntityType> <EntityType Name="CONFIGURATIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="CREATION_DATE" Type="datetime" Nullable="false" /> - <Property Name="APPLICATION_VERSION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="APPLICATION_OS_VERSION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="APPLICATION_FIRMWARE_VERSION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="EMBEDDED_FIRMWARE_VERSION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="EMBEDDED_SOFTWARE_VERSION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="HARDWARE_VERSION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="APPLICATION_VERSION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="APPLICATION_OS_VERSION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="APPLICATION_FIRMWARE_VERSION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="EMBEDDED_FIRMWARE_VERSION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="EMBEDDED_SOFTWARE_VERSION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="HARDWARE_VERSION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> </EntityType> <EntityType Name="CONTACTS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> - <Property Name="FIRST_NAME" Type="nvarchar" MaxLength="2147483647" /> - <Property Name="LAST_NAME" Type="nvarchar" MaxLength="2147483647" /> - <Property Name="FULL_NAME" Type="nvarchar" MaxLength="2147483647" /> - <Property Name="EMAIL" Type="nvarchar" MaxLength="2147483647" /> - <Property Name="PHONE_NUMBER" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="FAX" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="FIRST_NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="LAST_NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="FULL_NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="EMAIL" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="PHONE_NUMBER" Type="nvarchar" MaxLength="50" /> + <Property Name="FAX" Type="nvarchar" MaxLength="50" /> </EntityType> <EntityType Name="DISPENSER_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="NL_PER_PULSE" Type="real" Nullable="false" /> <Property Name="CAPACITY" Type="real" Nullable="false" /> </EntityType> @@ -157,107 +191,136 @@ <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="VERSION" Type="real" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> </EntityType> <EntityType Name="EMBEDDED_SOFTWARE_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="VERSION" Type="real" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> </EntityType> <EntityType Name="EVENT_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="100" Nullable="false" /> </EntityType> <EntityType Name="EVENT_TYPES_ACTIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="EVENT_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="ACTION_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="EVENT_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="ACTION_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> </EntityType> <EntityType Name="FIBER_SHAPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> </EntityType> <EntityType Name="FIBER_SYNTHS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> </EntityType> <EntityType Name="HARDWARE_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="VERSION" Type="real" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> </EntityType> <EntityType Name="IDS_PACKS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="CONFIGURATION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="DISPENSER_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="LIQUID_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="CARTRIDGE_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="MID_TANK_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="CONFIGURATION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="DISPENSER_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LIQUID_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="CARTRIDGE_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="MID_TANK_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="PACK_INDEX" Type="integer" Nullable="false" /> </EntityType> + <EntityType Name="JOB_RUNS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="JOB_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="START_DATE" Type="datetime" Nullable="false" /> + <Property Name="END_DATE" Type="datetime" Nullable="false" /> + <Property Name="SUCCESSFUL" Type="bit" Nullable="false" /> + </EntityType> + <EntityType Name="JOBS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="CREATION_DATE" Type="datetime" Nullable="false" /> + <Property Name="MACHINE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="RML_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="WINDING_METHOD_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="100" Nullable="false" /> + <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="200" /> + <Property Name="INTER_SEGMENT_LENGTH" Type="real" Nullable="false" /> + <Property Name="ENABLE_INTER_SEGMENT" Type="bit" Nullable="false" /> + <Property Name="ENABLE_LUBRICATION" Type="bit" Nullable="false" /> + </EntityType> <EntityType Name="LINEAR_MASS_DENSITY_UNITS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> </EntityType> <EntityType Name="LIQUID_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="VERSION" Type="real" Nullable="false" /> <Property Name="COLOR" Type="integer" Nullable="false" /> </EntityType> @@ -265,67 +328,67 @@ <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="LIQUID_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="RML_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="LIQUID_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="RML_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="MAX_NL_PER_CM" Type="real" Nullable="false" /> </EntityType> <EntityType Name="MACHINE_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="VERSION" Type="real" Nullable="false" /> - <Property Name="DEFAULT_CONFIGURATION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="DEFAULT_CONFIGURATION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> </EntityType> <EntityType Name="MACHINES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="SERIAL_NUMBER" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" /> + <Property Name="SERIAL_NUMBER" Type="varchar" MaxLength="50" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" /> <Property Name="PRODUCTION_DATE" Type="datetime" Nullable="false" /> - <Property Name="ORGANIZATION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="MACHINE_VERSION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="CONFIGURATION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ORGANIZATION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="MACHINE_VERSION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="CONFIGURATION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> </EntityType> <EntityType Name="MACHINES_CONFIGURATIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="MACHINE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="CONFIGURATION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="MACHINE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="CONFIGURATION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> </EntityType> <EntityType Name="MACHINES_EVENTS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="MACHINE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="EVENT_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="USER_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="MACHINE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="EVENT_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="USER_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="DATE_TIME" Type="datetime" Nullable="false" /> - <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="200" /> </EntityType> <EntityType Name="MEDIA_COLORS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="COLOR" Type="integer" Nullable="false" /> </EntityType> @@ -333,81 +396,120 @@ <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> </EntityType> <EntityType Name="MEDIA_MATERIALS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> </EntityType> <EntityType Name="MEDIA_PURPOSES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> </EntityType> <EntityType Name="MID_TANK_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="LITER_CAPACITY" Type="real" Nullable="false" /> </EntityType> <EntityType Name="ORGANIZATIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="CONTACT_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="ADDRESS_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="CONTACT_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="ADDRESS_GUID" Type="varchar" MaxLength="36" Nullable="false" /> </EntityType> <EntityType Name="PERMISSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="30" Nullable="false" /> + <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="100" Nullable="false" /> + </EntityType> + <EntityType Name="PROCESS_PARAMETERS_TABLES"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="DYEING_SPEED" Type="real" Nullable="false" /> + <Property Name="MIN_INK_UPTAKE" Type="real" Nullable="false" /> + <Property Name="MIXER_TEMP" Type="real" Nullable="false" /> + <Property Name="HEAD_ZONE1_TEMP" Type="real" Nullable="false" /> + <Property Name="HEAD_ZONE2_TEMP" Type="real" Nullable="false" /> + <Property Name="HEAD_ZONE3_TEMP" Type="real" Nullable="false" /> + <Property Name="HEAD_AIR_FLOW" Type="real" Nullable="false" /> + <Property Name="FEEDER_TENSION" Type="real" Nullable="false" /> + <Property Name="PULLER_TENSION" Type="real" Nullable="false" /> + <Property Name="DRYER_BUFFER_LENGTH" Type="real" Nullable="false" /> + <Property Name="DRYER_ZONE1_TEMP" Type="real" Nullable="false" /> + <Property Name="DRYER_ZONE2_TEMP" Type="real" Nullable="false" /> + <Property Name="DRYER_ZONE3_TEMP" Type="real" Nullable="false" /> + <Property Name="DRYER_AIR_FLOW" Type="real" Nullable="false" /> + <Property Name="WINDER_TENSION" Type="real" Nullable="false" /> + <Property Name="PROCESS_PARAMETERS_TABLES_GROUP_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="TABLE_INDEX" Type="integer" Nullable="false" /> + </EntityType> + <EntityType Name="PROCESS_PARAMETERS_TABLES_GROUPS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="RML_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="NAME" Type="varchar" MaxLength="50" Nullable="false" /> + <Property Name="ACTIVE" Type="bit" Nullable="false" /> + <Property Name="SAVE_DATE" Type="datetime" Nullable="false" /> </EntityType> <EntityType Name="RMLS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="MANUFACTURER" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="MATERIAL_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="COLOR_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="PURPOSE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="CONDITION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="LINEAR_MASS_DENSITY_UNIT_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="FIBER_SHAPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="FIBER_SYNTH_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="MANUFACTURER" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="CODE" Type="integer" Nullable="false" /> + <Property Name="MATERIAL_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="COLOR_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="PURPOSE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="CONDITION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LINEAR_MASS_DENSITY_UNIT_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="FIBER_SHAPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="FIBER_SYNTH_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="FIBER_SIZE" Type="real" Nullable="false" /> <Property Name="NUMBER_OF_FIBERS" Type="integer" Nullable="false" /> <Property Name="PLIES_PER_FIBER" Type="integer" Nullable="false" /> @@ -423,55 +525,94 @@ <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="30" Nullable="false" /> + <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="100" Nullable="false" /> </EntityType> <EntityType Name="ROLES_PERMISSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="ROLE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="PERMISSION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + </EntityType> + <EntityType Name="SEGMENTS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="ROLE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="PERMISSION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="JOB_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LENGTH" Type="real" Nullable="false" /> + </EntityType> + <EntityType Name="SENSORS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="CODE" Type="integer" Nullable="false" /> + <Property Name="NAME" Type="varchar" MaxLength="100" Nullable="false" /> + <Property Name="DESCRIPTION" Type="varchar" MaxLength="100" Nullable="false" /> + <Property Name="MIN" Type="real" Nullable="false" /> + <Property Name="MAX" Type="real" Nullable="false" /> + <Property Name="UNITS" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="POINTS_PER_FRAME" Type="integer" Nullable="false" /> + <Property Name="MULTI_CHANNEL" Type="bit" Nullable="false" /> + <Property Name="CHANNEL_COUNT" Type="integer" Nullable="false" /> </EntityType> <EntityType Name="SYNC_CONFIGURATIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="TABLE_NAME" Type="varchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="TABLE_NAME" Type="varchar" MaxLength="100" Nullable="false" /> <Property Name="SYNC_TYPE" Type="integer" Nullable="false" /> </EntityType> <EntityType Name="USERS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> - <Property Name="EMAIL" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="PASSWORD" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="ORGANIZATION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="CONTACT_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="ADDRESS_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="EMAIL" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="PASSWORD" Type="nvarchar" MaxLength="200" Nullable="false" /> + <Property Name="ORGANIZATION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="CONTACT_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="ADDRESS_GUID" Type="varchar" MaxLength="36" Nullable="false" /> </EntityType> <EntityType Name="USERS_ROLES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> - <Property Name="USER_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="ROLE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="USER_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="ROLE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + </EntityType> + <EntityType Name="WINDING_METHODS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="CODE" Type="integer" Nullable="false" /> + <Property Name="NAME" Type="varchar" MaxLength="50" Nullable="false" /> + <Property Name="DESCRIPTION" Type="varchar" MaxLength="100" Nullable="false" /> </EntityType> <EntityContainer Name="LocalModelStoreContainer"> <EntitySet Name="ACTION_TYPES" EntityType="Self.ACTION_TYPES" store:Type="Tables" /> @@ -480,9 +621,11 @@ <EntitySet Name="APPLICATION_FIRMWARE_VERSIONS" EntityType="Self.APPLICATION_FIRMWARE_VERSIONS" store:Type="Tables" /> <EntitySet Name="APPLICATION_OS_VERSIONS" EntityType="Self.APPLICATION_OS_VERSIONS" store:Type="Tables" /> <EntitySet Name="APPLICATION_VERSIONS" EntityType="Self.APPLICATION_VERSIONS" store:Type="Tables" /> + <EntitySet Name="BRUSH_STOPS" EntityType="Self.BRUSH_STOPS" store:Type="Tables" /> <EntitySet Name="CARTRIDGE_TYPES" EntityType="Self.CARTRIDGE_TYPES" store:Type="Tables" /> <EntitySet Name="CATS" EntityType="Self.CATS" store:Type="Tables" /> <EntitySet Name="CCTS" EntityType="Self.CCTS" store:Type="Tables" /> + <EntitySet Name="COLOR_SPACES" EntityType="Self.COLOR_SPACES" store:Type="Tables" /> <EntitySet Name="CONFIGURATIONS" EntityType="Self.CONFIGURATIONS" store:Type="Tables" /> <EntitySet Name="CONTACTS" EntityType="Self.CONTACTS" store:Type="Tables" /> <EntitySet Name="DISPENSER_TYPES" EntityType="Self.DISPENSER_TYPES" store:Type="Tables" /> @@ -494,6 +637,8 @@ <EntitySet Name="FIBER_SYNTHS" EntityType="Self.FIBER_SYNTHS" store:Type="Tables" /> <EntitySet Name="HARDWARE_VERSIONS" EntityType="Self.HARDWARE_VERSIONS" store:Type="Tables" /> <EntitySet Name="IDS_PACKS" EntityType="Self.IDS_PACKS" store:Type="Tables" /> + <EntitySet Name="JOB_RUNS" EntityType="Self.JOB_RUNS" store:Type="Tables" /> + <EntitySet Name="JOBS" EntityType="Self.JOBS" store:Type="Tables" /> <EntitySet Name="LINEAR_MASS_DENSITY_UNITS" EntityType="Self.LINEAR_MASS_DENSITY_UNITS" store:Type="Tables" /> <EntitySet Name="LIQUID_TYPES" EntityType="Self.LIQUID_TYPES" store:Type="Tables" /> <EntitySet Name="LIQUID_TYPES_RMLS" EntityType="Self.LIQUID_TYPES_RMLS" store:Type="Tables" /> @@ -508,12 +653,17 @@ <EntitySet Name="MID_TANK_TYPES" EntityType="Self.MID_TANK_TYPES" store:Type="Tables" /> <EntitySet Name="ORGANIZATIONS" EntityType="Self.ORGANIZATIONS" store:Type="Tables" /> <EntitySet Name="PERMISSIONS" EntityType="Self.PERMISSIONS" store:Type="Tables" /> + <EntitySet Name="PROCESS_PARAMETERS_TABLES" EntityType="Self.PROCESS_PARAMETERS_TABLES" store:Type="Tables" /> + <EntitySet Name="PROCESS_PARAMETERS_TABLES_GROUPS" EntityType="Self.PROCESS_PARAMETERS_TABLES_GROUPS" store:Type="Tables" /> <EntitySet Name="RMLS" EntityType="Self.RMLS" store:Type="Tables" /> <EntitySet Name="ROLES" EntityType="Self.ROLES" store:Type="Tables" /> <EntitySet Name="ROLES_PERMISSIONS" EntityType="Self.ROLES_PERMISSIONS" store:Type="Tables" /> + <EntitySet Name="SEGMENTS" EntityType="Self.SEGMENTS" store:Type="Tables" /> + <EntitySet Name="SENSORS" EntityType="Self.SENSORS" store:Type="Tables" /> <EntitySet Name="SYNC_CONFIGURATIONS" EntityType="Self.SYNC_CONFIGURATIONS" store:Type="Tables" /> <EntitySet Name="USERS" EntityType="Self.USERS" store:Type="Tables" /> <EntitySet Name="USERS_ROLES" EntityType="Self.USERS_ROLES" store:Type="Tables" /> + <EntitySet Name="WINDING_METHODS" EntityType="Self.WINDING_METHODS" store:Type="Tables" /> </EntityContainer> </Schema></edmx:StorageModels> <!-- CSDL content --> @@ -526,9 +676,11 @@ <EntitySet Name="APPLICATION_FIRMWARE_VERSIONS" EntityType="LocalModel.APPLICATION_FIRMWARE_VERSIONS" /> <EntitySet Name="APPLICATION_OS_VERSIONS" EntityType="LocalModel.APPLICATION_OS_VERSIONS" /> <EntitySet Name="APPLICATION_VERSIONS" EntityType="LocalModel.APPLICATION_VERSIONS" /> + <EntitySet Name="BRUSH_STOPS" EntityType="LocalModel.BRUSH_STOPS" /> <EntitySet Name="CARTRIDGE_TYPES" EntityType="LocalModel.CARTRIDGE_TYPES" /> <EntitySet Name="CATS" EntityType="LocalModel.CAT" /> <EntitySet Name="CCTS" EntityType="LocalModel.CCT" /> + <EntitySet Name="COLOR_SPACES" EntityType="LocalModel.COLOR_SPACES" /> <EntitySet Name="CONFIGURATIONS" EntityType="LocalModel.CONFIGURATION" /> <EntitySet Name="CONTACTS" EntityType="LocalModel.CONTACT" /> <EntitySet Name="DISPENSER_TYPES" EntityType="LocalModel.DISPENSER_TYPES" /> @@ -540,6 +692,8 @@ <EntitySet Name="FIBER_SYNTHS" EntityType="LocalModel.FIBER_SYNTHS" /> <EntitySet Name="HARDWARE_VERSIONS" EntityType="LocalModel.HARDWARE_VERSIONS" /> <EntitySet Name="IDS_PACKS" EntityType="LocalModel.IDS_PACKS" /> + <EntitySet Name="JOB_RUNS" EntityType="LocalModel.JOB_RUNS" /> + <EntitySet Name="JOBS" EntityType="LocalModel.JOB" /> <EntitySet Name="LINEAR_MASS_DENSITY_UNITS" EntityType="LocalModel.LINEAR_MASS_DENSITY_UNITS" /> <EntitySet Name="LIQUID_TYPES" EntityType="LocalModel.LIQUID_TYPES" /> <EntitySet Name="LIQUID_TYPES_RMLS" EntityType="LocalModel.LIQUID_TYPES_RMLS" /> @@ -554,158 +708,197 @@ <EntitySet Name="MID_TANK_TYPES" EntityType="LocalModel.MID_TANK_TYPES" /> <EntitySet Name="ORGANIZATIONS" EntityType="LocalModel.ORGANIZATION" /> <EntitySet Name="PERMISSIONS" EntityType="LocalModel.PERMISSION" /> + <EntitySet Name="PROCESS_PARAMETERS_TABLES" EntityType="LocalModel.PROCESS_PARAMETERS_TABLES" /> + <EntitySet Name="PROCESS_PARAMETERS_TABLES_GROUPS" EntityType="LocalModel.PROCESS_PARAMETERS_TABLES_GROUPS" /> <EntitySet Name="RMLS" EntityType="LocalModel.RML" /> <EntitySet Name="ROLES" EntityType="LocalModel.ROLE" /> <EntitySet Name="ROLES_PERMISSIONS" EntityType="LocalModel.ROLES_PERMISSIONS" /> + <EntitySet Name="SEGMENTS" EntityType="LocalModel.SEGMENT" /> + <EntitySet Name="SENSORS" EntityType="LocalModel.SENSOR" /> <EntitySet Name="SYNC_CONFIGURATIONS" EntityType="LocalModel.SYNC_CONFIGURATIONS" /> <EntitySet Name="USERS" EntityType="LocalModel.USER" /> <EntitySet Name="USERS_ROLES" EntityType="LocalModel.USERS_ROLES" /> + <EntitySet Name="WINDING_METHODS" EntityType="LocalModel.WINDING_METHODS" /> </EntityContainer> <EntityType Name="ACTION_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> <Property Name="CODE" Type="Int64" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="ADDRESS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="ADDRESS_STRING" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="LOCALITY" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="COUNTRY" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="CITY" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="STATE" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="COUNTRY_CODE" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="POSTAL_CODE" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ADDRESS_STRING" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> + <Property Name="LOCALITY" Type="String" MaxLength="56" FixedLength="false" Unicode="true" /> + <Property Name="COUNTRY" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="CITY" Type="String" MaxLength="30" FixedLength="false" Unicode="true" /> + <Property Name="STATE" Type="String" MaxLength="30" FixedLength="false" Unicode="true" /> + <Property Name="COUNTRY_CODE" Type="String" MaxLength="2" FixedLength="false" Unicode="true" /> + <Property Name="POSTAL_CODE" Type="String" MaxLength="15" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="APPLICATION_DISPLAY_PANEL_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> <Property Name="VERSION" Type="Double" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="APPLICATION_FIRMWARE_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> <Property Name="VERSION" Type="Double" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="APPLICATION_OS_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> <Property Name="VERSION" Type="Double" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="APPLICATION_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> <Property Name="VERSION" Type="Double" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + </EntityType> + <EntityType Name="BRUSH_STOPS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="Int64" 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" /> + <Property Name="SEGMENT_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="COLOR_SPACE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="OFFSET_PERCENT" Type="Double" Nullable="false" /> + <Property Name="CYAN" Type="Double" Nullable="false" /> + <Property Name="MAGENTA" Type="Double" Nullable="false" /> + <Property Name="YELLOW" Type="Double" Nullable="false" /> + <Property Name="BLACK" Type="Double" Nullable="false" /> + <Property Name="RED" Type="Int64" Nullable="false" /> + <Property Name="GREEN" Type="Int64" Nullable="false" /> + <Property Name="BLUE" Type="Int64" Nullable="false" /> + <Property Name="L" Type="Int64" Nullable="false" /> + <Property Name="A" Type="Int64" Nullable="false" /> + <Property Name="B" Type="Int64" Nullable="false" /> + <Property Name="PANTON_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" /> </EntityType> <EntityType Name="CARTRIDGE_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> <Property Name="CODE" Type="Int64" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="CAT"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> - <Property Name="LIQUID_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="MACHINE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="LIQUID_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="RML_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="DATA" Type="Binary" Nullable="false" MaxLength="2147483647" FixedLength="false" /> </EntityType> <EntityType Name="CCT"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="FORWARD_FILE_NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="INVERSE_FILE_NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> + <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="true" /> + <Property Name="FORWARD_FILE_NAME" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> + <Property Name="INVERSE_FILE_NAME" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> <Property Name="FORWARD_DATA" Type="Binary" Nullable="false" MaxLength="2147483647" FixedLength="false" /> <Property Name="INVERSE_DATA" Type="Binary" Nullable="false" MaxLength="2147483647" FixedLength="false" /> <Property Name="VERSION" Type="Double" Nullable="false" /> - <Property Name="RML_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="RML_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + </EntityType> + <EntityType Name="COLOR_SPACES"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="Int64" 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" /> + <Property Name="CODE" Type="Int64" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" /> + <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" /> </EntityType> <EntityType Name="CONFIGURATION"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> - <Property Name="NAME" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="CREATION_DATE" Type="DateTime" Nullable="false" /> - <Property Name="APPLICATION_VERSION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="APPLICATION_OS_VERSION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="APPLICATION_FIRMWARE_VERSION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="EMBEDDED_FIRMWARE_VERSION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="EMBEDDED_SOFTWARE_VERSION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="HARDWARE_VERSION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="APPLICATION_VERSION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="APPLICATION_OS_VERSION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="APPLICATION_FIRMWARE_VERSION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="EMBEDDED_FIRMWARE_VERSION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="EMBEDDED_SOFTWARE_VERSION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="HARDWARE_VERSION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> </EntityType> <EntityType Name="CONTACT"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="FIRST_NAME" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="LAST_NAME" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="FULL_NAME" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="EMAIL" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="PHONE_NUMBER" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="FAX" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="FIRST_NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="LAST_NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="FULL_NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="EMAIL" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="PHONE_NUMBER" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="FAX" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="DISPENSER_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> <Property Name="CODE" Type="Int64" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="NL_PER_PULSE" Type="Double" Nullable="false" /> <Property Name="CAPACITY" Type="Double" Nullable="false" /> </EntityType> @@ -713,107 +906,136 @@ <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> <Property Name="VERSION" Type="Double" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="EMBEDDED_SOFTWARE_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> <Property Name="VERSION" Type="Double" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="EVENT_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> <Property Name="CODE" Type="Int64" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="EVENT_TYPES_ACTIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> - <Property Name="EVENT_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="ACTION_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="EVENT_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="ACTION_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> </EntityType> <EntityType Name="FIBER_SHAPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="CODE" Type="Int64" Nullable="false" /> </EntityType> <EntityType Name="FIBER_SYNTHS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="CODE" Type="Int64" Nullable="false" /> </EntityType> <EntityType Name="HARDWARE_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> <Property Name="VERSION" Type="Double" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="IDS_PACKS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> - <Property Name="CONFIGURATION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="DISPENSER_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="LIQUID_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="CARTRIDGE_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="MID_TANK_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="CONFIGURATION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="DISPENSER_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="LIQUID_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="CARTRIDGE_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="MID_TANK_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="PACK_INDEX" Type="Int64" Nullable="false" /> </EntityType> + <EntityType Name="JOB_RUNS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="Int64" 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" /> + <Property Name="JOB_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="START_DATE" Type="DateTime" Nullable="false" /> + <Property Name="END_DATE" Type="DateTime" Nullable="false" /> + <Property Name="SUCCESSFUL" Type="Boolean" Nullable="false" /> + </EntityType> + <EntityType Name="JOB"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="Int64" 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" /> + <Property Name="CREATION_DATE" Type="DateTime" Nullable="false" /> + <Property Name="MACHINE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="RML_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="WINDING_METHOD_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <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="INTER_SEGMENT_LENGTH" Type="Double" Nullable="false" /> + <Property Name="ENABLE_INTER_SEGMENT" Type="Boolean" Nullable="false" /> + <Property Name="ENABLE_LUBRICATION" Type="Boolean" Nullable="false" /> + </EntityType> <EntityType Name="LINEAR_MASS_DENSITY_UNITS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="CODE" Type="Int64" Nullable="false" /> </EntityType> <EntityType Name="LIQUID_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> <Property Name="CODE" Type="Int64" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="VERSION" Type="Double" Nullable="false" /> <Property Name="COLOR" Type="Int64" Nullable="false" /> </EntityType> @@ -821,67 +1043,67 @@ <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> - <Property Name="LIQUID_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="RML_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="LIQUID_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="RML_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="MAX_NL_PER_CM" Type="Double" Nullable="false" /> </EntityType> <EntityType Name="MACHINE_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="VERSION" Type="Double" Nullable="false" /> - <Property Name="DEFAULT_CONFIGURATION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="DEFAULT_CONFIGURATION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> </EntityType> <EntityType Name="MACHINE"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> - <Property Name="SERIAL_NUMBER" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="NAME" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="SERIAL_NUMBER" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" /> + <Property Name="NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="PRODUCTION_DATE" Type="DateTime" Nullable="false" /> - <Property Name="ORGANIZATION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="MACHINE_VERSION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="CONFIGURATION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ORGANIZATION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="MACHINE_VERSION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="CONFIGURATION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> </EntityType> <EntityType Name="MACHINES_CONFIGURATIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> - <Property Name="MACHINE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="CONFIGURATION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="MACHINE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="CONFIGURATION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> </EntityType> <EntityType Name="MACHINES_EVENTS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> - <Property Name="MACHINE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="EVENT_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="USER_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="MACHINE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="EVENT_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="USER_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="DATE_TIME" Type="DateTime" Nullable="false" /> - <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="DESCRIPTION" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="MEDIA_COLORS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> <Property Name="COLOR" Type="Int64" Nullable="false" /> </EntityType> @@ -889,81 +1111,120 @@ <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="CODE" Type="Int64" Nullable="false" /> </EntityType> <EntityType Name="MEDIA_MATERIALS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="CODE" Type="Int64" Nullable="false" /> </EntityType> <EntityType Name="MEDIA_PURPOSES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="CODE" Type="Int64" Nullable="false" /> </EntityType> <EntityType Name="MID_TANK_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> <Property Name="CODE" Type="Int64" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="LITER_CAPACITY" Type="Double" Nullable="false" /> </EntityType> <EntityType Name="ORGANIZATION"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="CONTACT_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="ADDRESS_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="CONTACT_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="ADDRESS_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> </EntityType> <EntityType Name="PERMISSION"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> <Property Name="CODE" Type="Int64" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="30" FixedLength="false" Unicode="true" /> + <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> + </EntityType> + <EntityType Name="PROCESS_PARAMETERS_TABLES"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="Int64" 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" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="DYEING_SPEED" Type="Double" Nullable="false" /> + <Property Name="MIN_INK_UPTAKE" Type="Double" Nullable="false" /> + <Property Name="MIXER_TEMP" Type="Double" Nullable="false" /> + <Property Name="HEAD_ZONE1_TEMP" Type="Double" Nullable="false" /> + <Property Name="HEAD_ZONE2_TEMP" Type="Double" Nullable="false" /> + <Property Name="HEAD_ZONE3_TEMP" Type="Double" Nullable="false" /> + <Property Name="HEAD_AIR_FLOW" Type="Double" Nullable="false" /> + <Property Name="FEEDER_TENSION" Type="Double" Nullable="false" /> + <Property Name="PULLER_TENSION" Type="Double" Nullable="false" /> + <Property Name="DRYER_BUFFER_LENGTH" Type="Double" Nullable="false" /> + <Property Name="DRYER_ZONE1_TEMP" Type="Double" Nullable="false" /> + <Property Name="DRYER_ZONE2_TEMP" Type="Double" Nullable="false" /> + <Property Name="DRYER_ZONE3_TEMP" Type="Double" Nullable="false" /> + <Property Name="DRYER_AIR_FLOW" Type="Double" Nullable="false" /> + <Property Name="WINDER_TENSION" Type="Double" Nullable="false" /> + <Property Name="PROCESS_PARAMETERS_TABLES_GROUP_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="TABLE_INDEX" Type="Int64" Nullable="false" /> + </EntityType> + <EntityType Name="PROCESS_PARAMETERS_TABLES_GROUPS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="Int64" 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" /> + <Property Name="RML_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" /> + <Property Name="ACTIVE" Type="Boolean" Nullable="false" /> + <Property Name="SAVE_DATE" Type="DateTime" Nullable="false" /> </EntityType> <EntityType Name="RML"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="MANUFACTURER" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="MATERIAL_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="COLOR_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="PURPOSE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="CONDITION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="LINEAR_MASS_DENSITY_UNIT_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="FIBER_SHAPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="FIBER_SYNTH_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="MANUFACTURER" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="CODE" Type="Int64" Nullable="false" /> + <Property Name="MATERIAL_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="COLOR_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="PURPOSE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="CONDITION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="LINEAR_MASS_DENSITY_UNIT_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="FIBER_SHAPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="FIBER_SYNTH_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="FIBER_SIZE" Type="Double" Nullable="false" /> <Property Name="NUMBER_OF_FIBERS" Type="Int64" Nullable="false" /> <Property Name="PLIES_PER_FIBER" Type="Int64" Nullable="false" /> @@ -979,55 +1240,94 @@ <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> <Property Name="CODE" Type="Int64" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="30" FixedLength="false" Unicode="true" /> + <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="ROLES_PERMISSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> + <Property Name="ROLE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="PERMISSION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + </EntityType> + <EntityType Name="SEGMENT"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="Int64" 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" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="JOB_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="LENGTH" Type="Double" Nullable="false" /> + </EntityType> + <EntityType Name="SENSOR"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="Int64" 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" /> - <Property Name="ROLE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="PERMISSION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="CODE" Type="Int64" 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" /> + <Property Name="MIN" Type="Double" Nullable="false" /> + <Property Name="MAX" Type="Double" Nullable="false" /> + <Property Name="UNITS" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="POINTS_PER_FRAME" Type="Int64" Nullable="false" /> + <Property Name="MULTI_CHANNEL" Type="Boolean" Nullable="false" /> + <Property Name="CHANNEL_COUNT" Type="Int64" Nullable="false" /> </EntityType> <EntityType Name="SYNC_CONFIGURATIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="TABLE_NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="false" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="TABLE_NAME" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="SYNC_TYPE" Type="Int64" Nullable="false" /> </EntityType> <EntityType Name="USER"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="EMAIL" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="PASSWORD" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="ORGANIZATION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="CONTACT_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="ADDRESS_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="EMAIL" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="PASSWORD" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="true" /> + <Property Name="ORGANIZATION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="CONTACT_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="ADDRESS_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> </EntityType> <EntityType Name="USERS_ROLES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" 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" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="USER_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="ROLE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="USER_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="ROLE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + </EntityType> + <EntityType Name="WINDING_METHODS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="Int64" 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" /> + <Property Name="CODE" Type="Int64" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" /> + <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" /> </EntityType> </Schema> </edmx:ConceptualModels> @@ -1108,6 +1408,29 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> + <EntitySetMapping Name="BRUSH_STOPS"> + <EntityTypeMapping TypeName="LocalModel.BRUSH_STOPS"> + <MappingFragment StoreEntitySet="BRUSH_STOPS"> + <ScalarProperty Name="PANTON_GUID" ColumnName="PANTON_GUID" /> + <ScalarProperty Name="B" ColumnName="B" /> + <ScalarProperty Name="A" ColumnName="A" /> + <ScalarProperty Name="L" ColumnName="L" /> + <ScalarProperty Name="BLUE" ColumnName="BLUE" /> + <ScalarProperty Name="GREEN" ColumnName="GREEN" /> + <ScalarProperty Name="RED" ColumnName="RED" /> + <ScalarProperty Name="BLACK" ColumnName="BLACK" /> + <ScalarProperty Name="YELLOW" ColumnName="YELLOW" /> + <ScalarProperty Name="MAGENTA" ColumnName="MAGENTA" /> + <ScalarProperty Name="CYAN" ColumnName="CYAN" /> + <ScalarProperty Name="OFFSET_PERCENT" ColumnName="OFFSET_PERCENT" /> + <ScalarProperty Name="COLOR_SPACE_GUID" ColumnName="COLOR_SPACE_GUID" /> + <ScalarProperty Name="SEGMENT_GUID" ColumnName="SEGMENT_GUID" /> + <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="LocalModel.CARTRIDGE_TYPES"> <MappingFragment StoreEntitySet="CARTRIDGE_TYPES"> @@ -1123,8 +1446,9 @@ <EntityTypeMapping TypeName="LocalModel.CAT"> <MappingFragment StoreEntitySet="CATS"> <ScalarProperty Name="DATA" ColumnName="DATA" /> - <ScalarProperty Name="MACHINE_GUID" ColumnName="MACHINE_GUID" /> + <ScalarProperty Name="RML_GUID" ColumnName="RML_GUID" /> <ScalarProperty Name="LIQUID_TYPE_GUID" ColumnName="LIQUID_TYPE_GUID" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="GUID" ColumnName="GUID" /> <ScalarProperty Name="ID" ColumnName="ID" /> @@ -1148,6 +1472,18 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> + <EntitySetMapping Name="COLOR_SPACES"> + <EntityTypeMapping TypeName="LocalModel.COLOR_SPACES"> + <MappingFragment StoreEntitySet="COLOR_SPACES"> + <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="CONFIGURATIONS"> <EntityTypeMapping TypeName="LocalModel.CONFIGURATION"> <MappingFragment StoreEntitySet="CONFIGURATIONS"> @@ -1289,6 +1625,37 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> + <EntitySetMapping Name="JOB_RUNS"> + <EntityTypeMapping TypeName="LocalModel.JOB_RUNS"> + <MappingFragment StoreEntitySet="JOB_RUNS"> + <ScalarProperty Name="SUCCESSFUL" ColumnName="SUCCESSFUL" /> + <ScalarProperty Name="END_DATE" ColumnName="END_DATE" /> + <ScalarProperty Name="START_DATE" ColumnName="START_DATE" /> + <ScalarProperty Name="JOB_GUID" ColumnName="JOB_GUID" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> + </MappingFragment> + </EntityTypeMapping> + </EntitySetMapping> + <EntitySetMapping Name="JOBS"> + <EntityTypeMapping TypeName="LocalModel.JOB"> + <MappingFragment StoreEntitySet="JOBS"> + <ScalarProperty Name="ENABLE_LUBRICATION" ColumnName="ENABLE_LUBRICATION" /> + <ScalarProperty Name="ENABLE_INTER_SEGMENT" ColumnName="ENABLE_INTER_SEGMENT" /> + <ScalarProperty Name="INTER_SEGMENT_LENGTH" ColumnName="INTER_SEGMENT_LENGTH" /> + <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="WINDING_METHOD_GUID" ColumnName="WINDING_METHOD_GUID" /> + <ScalarProperty Name="RML_GUID" ColumnName="RML_GUID" /> + <ScalarProperty Name="MACHINE_GUID" ColumnName="MACHINE_GUID" /> + <ScalarProperty Name="CREATION_DATE" ColumnName="CREATION_DATE" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> + </MappingFragment> + </EntityTypeMapping> + </EntitySetMapping> <EntitySetMapping Name="LINEAR_MASS_DENSITY_UNITS"> <EntityTypeMapping TypeName="LocalModel.LINEAR_MASS_DENSITY_UNITS"> <MappingFragment StoreEntitySet="LINEAR_MASS_DENSITY_UNITS"> @@ -1329,8 +1696,8 @@ <EntityTypeMapping TypeName="LocalModel.MACHINE_VERSIONS"> <MappingFragment StoreEntitySet="MACHINE_VERSIONS"> <ScalarProperty Name="DEFAULT_CONFIGURATION_GUID" ColumnName="DEFAULT_CONFIGURATION_GUID" /> - <ScalarProperty Name="VERSION" ColumnName="VERSION" /> <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="VERSION" ColumnName="VERSION" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="GUID" ColumnName="GUID" /> <ScalarProperty Name="ID" ColumnName="ID" /> @@ -1456,6 +1823,46 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> + <EntitySetMapping Name="PROCESS_PARAMETERS_TABLES"> + <EntityTypeMapping TypeName="LocalModel.PROCESS_PARAMETERS_TABLES"> + <MappingFragment StoreEntitySet="PROCESS_PARAMETERS_TABLES"> + <ScalarProperty Name="TABLE_INDEX" ColumnName="TABLE_INDEX" /> + <ScalarProperty Name="PROCESS_PARAMETERS_TABLES_GROUP_GUID" ColumnName="PROCESS_PARAMETERS_TABLES_GROUP_GUID" /> + <ScalarProperty Name="WINDER_TENSION" ColumnName="WINDER_TENSION" /> + <ScalarProperty Name="DRYER_AIR_FLOW" ColumnName="DRYER_AIR_FLOW" /> + <ScalarProperty Name="DRYER_ZONE3_TEMP" ColumnName="DRYER_ZONE3_TEMP" /> + <ScalarProperty Name="DRYER_ZONE2_TEMP" ColumnName="DRYER_ZONE2_TEMP" /> + <ScalarProperty Name="DRYER_ZONE1_TEMP" ColumnName="DRYER_ZONE1_TEMP" /> + <ScalarProperty Name="DRYER_BUFFER_LENGTH" ColumnName="DRYER_BUFFER_LENGTH" /> + <ScalarProperty Name="PULLER_TENSION" ColumnName="PULLER_TENSION" /> + <ScalarProperty Name="FEEDER_TENSION" ColumnName="FEEDER_TENSION" /> + <ScalarProperty Name="HEAD_AIR_FLOW" ColumnName="HEAD_AIR_FLOW" /> + <ScalarProperty Name="HEAD_ZONE3_TEMP" ColumnName="HEAD_ZONE3_TEMP" /> + <ScalarProperty Name="HEAD_ZONE2_TEMP" ColumnName="HEAD_ZONE2_TEMP" /> + <ScalarProperty Name="HEAD_ZONE1_TEMP" ColumnName="HEAD_ZONE1_TEMP" /> + <ScalarProperty Name="MIXER_TEMP" ColumnName="MIXER_TEMP" /> + <ScalarProperty Name="MIN_INK_UPTAKE" ColumnName="MIN_INK_UPTAKE" /> + <ScalarProperty Name="DYEING_SPEED" ColumnName="DYEING_SPEED" /> + <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="PROCESS_PARAMETERS_TABLES_GROUPS"> + <EntityTypeMapping TypeName="LocalModel.PROCESS_PARAMETERS_TABLES_GROUPS"> + <MappingFragment StoreEntitySet="PROCESS_PARAMETERS_TABLES_GROUPS"> + <ScalarProperty Name="SAVE_DATE" ColumnName="SAVE_DATE" /> + <ScalarProperty Name="ACTIVE" ColumnName="ACTIVE" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="RML_GUID" ColumnName="RML_GUID" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> + </MappingFragment> + </EntityTypeMapping> + </EntitySetMapping> <EntitySetMapping Name="RMLS"> <EntityTypeMapping TypeName="LocalModel.RML"> <MappingFragment StoreEntitySet="RMLS"> @@ -1476,6 +1883,7 @@ <ScalarProperty Name="PURPOSE_GUID" ColumnName="PURPOSE_GUID" /> <ScalarProperty Name="COLOR_GUID" ColumnName="COLOR_GUID" /> <ScalarProperty Name="MATERIAL_GUID" ColumnName="MATERIAL_GUID" /> + <ScalarProperty Name="CODE" ColumnName="CODE" /> <ScalarProperty Name="MANUFACTURER" ColumnName="MANUFACTURER" /> <ScalarProperty Name="NAME" ColumnName="NAME" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> @@ -1507,6 +1915,36 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> + <EntitySetMapping Name="SEGMENTS"> + <EntityTypeMapping TypeName="LocalModel.SEGMENT"> + <MappingFragment StoreEntitySet="SEGMENTS"> + <ScalarProperty Name="LENGTH" ColumnName="LENGTH" /> + <ScalarProperty Name="JOB_GUID" ColumnName="JOB_GUID" /> + <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="SENSORS"> + <EntityTypeMapping TypeName="LocalModel.SENSOR"> + <MappingFragment StoreEntitySet="SENSORS"> + <ScalarProperty Name="CHANNEL_COUNT" ColumnName="CHANNEL_COUNT" /> + <ScalarProperty Name="MULTI_CHANNEL" ColumnName="MULTI_CHANNEL" /> + <ScalarProperty Name="POINTS_PER_FRAME" ColumnName="POINTS_PER_FRAME" /> + <ScalarProperty Name="UNITS" ColumnName="UNITS" /> + <ScalarProperty Name="MAX" ColumnName="MAX" /> + <ScalarProperty Name="MIN" ColumnName="MIN" /> + <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="SYNC_CONFIGURATIONS"> <EntityTypeMapping TypeName="LocalModel.SYNC_CONFIGURATIONS"> <MappingFragment StoreEntitySet="SYNC_CONFIGURATIONS"> @@ -1543,6 +1981,18 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> + <EntitySetMapping Name="WINDING_METHODS"> + <EntityTypeMapping TypeName="LocalModel.WINDING_METHODS"> + <MappingFragment StoreEntitySet="WINDING_METHODS"> + <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> </EntityContainerMapping> </Mapping> </edmx:Mappings> diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx.diagram b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx.diagram index 06fe3fd60..bce29c8bf 100644 --- a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx.diagram +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx.diagram @@ -11,40 +11,49 @@ <EntityTypeShape EntityType="LocalModel.APPLICATION_FIRMWARE_VERSIONS" Width="1.5" PointX="0.75" PointY="4.75" /> <EntityTypeShape EntityType="LocalModel.APPLICATION_OS_VERSIONS" Width="1.5" PointX="2.75" PointY="4.75" /> <EntityTypeShape EntityType="LocalModel.APPLICATION_VERSIONS" Width="1.5" PointX="4.75" PointY="3.75" /> - <EntityTypeShape EntityType="LocalModel.CARTRIDGE_TYPES" Width="1.5" PointX="6.75" PointY="0.75" /> - <EntityTypeShape EntityType="LocalModel.CAT" Width="1.5" PointX="6.75" PointY="3.75" /> - <EntityTypeShape EntityType="LocalModel.CCT" Width="1.5" PointX="4.75" PointY="6.75" /> - <EntityTypeShape EntityType="LocalModel.CONFIGURATION" Width="1.5" PointX="6.75" PointY="6.75" /> - <EntityTypeShape EntityType="LocalModel.CONTACT" Width="1.5" PointX="0.75" PointY="7.75" /> - <EntityTypeShape EntityType="LocalModel.DISPENSER_TYPES" Width="1.5" PointX="8.75" PointY="0.75" /> - <EntityTypeShape EntityType="LocalModel.EMBEDDED_FIRMWARE_VERSIONS" Width="1.5" PointX="8.75" PointY="4.75" /> - <EntityTypeShape EntityType="LocalModel.EMBEDDED_SOFTWARE_VERSIONS" Width="1.5" PointX="8.75" PointY="7.75" /> - <EntityTypeShape EntityType="LocalModel.EVENT_TYPES" Width="1.5" PointX="10.75" PointY="0.75" /> - <EntityTypeShape EntityType="LocalModel.EVENT_TYPES_ACTIONS" Width="1.5" PointX="2.75" PointY="10.75" /> - <EntityTypeShape EntityType="LocalModel.FIBER_SHAPES" Width="1.5" PointX="10.75" PointY="3.75" /> - <EntityTypeShape EntityType="LocalModel.FIBER_SYNTHS" Width="1.5" PointX="10.75" PointY="6.75" /> - <EntityTypeShape EntityType="LocalModel.HARDWARE_VERSIONS" Width="1.5" PointX="8.75" PointY="10.75" /> - <EntityTypeShape EntityType="LocalModel.IDS_PACKS" Width="1.5" PointX="10.75" PointY="9.75" /> - <EntityTypeShape EntityType="LocalModel.LINEAR_MASS_DENSITY_UNITS" Width="1.5" PointX="4.75" PointY="11.75" /> - <EntityTypeShape EntityType="LocalModel.LIQUID_TYPES" Width="1.5" PointX="12.75" PointY="0.75" /> - <EntityTypeShape EntityType="LocalModel.LIQUID_TYPES_RMLS" Width="1.5" PointX="12.75" PointY="4.75" /> - <EntityTypeShape EntityType="LocalModel.MACHINE_VERSIONS" Width="1.5" PointX="12.75" PointY="7.75" /> - <EntityTypeShape EntityType="LocalModel.MACHINE" Width="1.5" PointX="12.75" PointY="10.75" /> - <EntityTypeShape EntityType="LocalModel.MACHINES_CONFIGURATIONS" Width="1.5" PointX="0.75" PointY="13.75" /> - <EntityTypeShape EntityType="LocalModel.MACHINES_EVENTS" Width="1.5" PointX="6.75" PointY="13.75" /> - <EntityTypeShape EntityType="LocalModel.MEDIA_COLORS" Width="1.5" PointX="8.75" PointY="13.75" /> - <EntityTypeShape EntityType="LocalModel.MEDIA_CONDITIONS" Width="1.5" PointX="14.75" PointY="0.75" /> - <EntityTypeShape EntityType="LocalModel.MEDIA_MATERIALS" Width="1.5" PointX="2.75" PointY="14.75" /> - <EntityTypeShape EntityType="LocalModel.MEDIA_PURPOSES" Width="1.5" PointX="14.75" PointY="3.75" /> - <EntityTypeShape EntityType="LocalModel.MID_TANK_TYPES" Width="1.5" PointX="14.75" PointY="6.75" /> - <EntityTypeShape EntityType="LocalModel.ORGANIZATION" Width="1.5" PointX="14.75" PointY="9.75" /> - <EntityTypeShape EntityType="LocalModel.PERMISSION" Width="1.5" PointX="10.75" PointY="14.75" /> - <EntityTypeShape EntityType="LocalModel.RML" Width="1.5" PointX="14.75" PointY="12.75" /> - <EntityTypeShape EntityType="LocalModel.ROLE" Width="1.5" PointX="16.75" PointY="0.75" /> - <EntityTypeShape EntityType="LocalModel.ROLES_PERMISSIONS" Width="1.5" PointX="16.75" PointY="3.75" /> - <EntityTypeShape EntityType="LocalModel.SYNC_CONFIGURATIONS" Width="1.5" PointX="16.75" PointY="6.75" /> - <EntityTypeShape EntityType="LocalModel.USER" Width="1.5" PointX="16.75" PointY="9.75" /> - <EntityTypeShape EntityType="LocalModel.USERS_ROLES" Width="1.5" PointX="16.75" PointY="13.75" /> + <EntityTypeShape EntityType="LocalModel.BRUSH_STOPS" Width="1.5" PointX="6.75" PointY="0.75" /> + <EntityTypeShape EntityType="LocalModel.CARTRIDGE_TYPES" Width="1.5" PointX="4.75" PointY="6.75" /> + <EntityTypeShape EntityType="LocalModel.CAT" Width="1.5" PointX="6.75" PointY="6.75" /> + <EntityTypeShape EntityType="LocalModel.CCT" Width="1.5" PointX="0.75" PointY="7.75" /> + <EntityTypeShape EntityType="LocalModel.COLOR_SPACES" Width="1.5" PointX="8.75" PointY="0.75" /> + <EntityTypeShape EntityType="LocalModel.CONFIGURATION" Width="1.5" PointX="8.75" PointY="3.75" /> + <EntityTypeShape EntityType="LocalModel.CONTACT" Width="1.5" PointX="8.75" PointY="8.75" /> + <EntityTypeShape EntityType="LocalModel.DISPENSER_TYPES" Width="1.5" PointX="2.75" PointY="9.75" /> + <EntityTypeShape EntityType="LocalModel.EMBEDDED_FIRMWARE_VERSIONS" Width="1.5" PointX="10.75" PointY="0.75" /> + <EntityTypeShape EntityType="LocalModel.EMBEDDED_SOFTWARE_VERSIONS" Width="1.5" PointX="10.75" PointY="3.75" /> + <EntityTypeShape EntityType="LocalModel.EVENT_TYPES" Width="1.5" PointX="4.75" PointY="10.75" /> + <EntityTypeShape EntityType="LocalModel.EVENT_TYPES_ACTIONS" Width="1.5" PointX="10.75" PointY="6.75" /> + <EntityTypeShape EntityType="LocalModel.FIBER_SHAPES" Width="1.5" PointX="10.75" PointY="9.75" /> + <EntityTypeShape EntityType="LocalModel.FIBER_SYNTHS" Width="1.5" PointX="12.75" PointY="0.75" /> + <EntityTypeShape EntityType="LocalModel.HARDWARE_VERSIONS" Width="1.5" PointX="12.75" PointY="3.75" /> + <EntityTypeShape EntityType="LocalModel.IDS_PACKS" Width="1.5" PointX="12.75" PointY="6.75" /> + <EntityTypeShape EntityType="LocalModel.JOB_RUNS" Width="1.5" PointX="6.75" PointY="12.75" /> + <EntityTypeShape EntityType="LocalModel.JOB" Width="1.5" PointX="8.75" PointY="12.75" /> + <EntityTypeShape EntityType="LocalModel.LINEAR_MASS_DENSITY_UNITS" Width="1.5" PointX="12.75" PointY="10.75" /> + <EntityTypeShape EntityType="LocalModel.LIQUID_TYPES" Width="1.5" PointX="0.75" PointY="13.75" /> + <EntityTypeShape EntityType="LocalModel.LIQUID_TYPES_RMLS" Width="1.5" PointX="2.75" PointY="13.75" /> + <EntityTypeShape EntityType="LocalModel.MACHINE_VERSIONS" Width="1.5" PointX="10.75" PointY="13.75" /> + <EntityTypeShape EntityType="LocalModel.MACHINE" Width="1.5" PointX="12.75" PointY="13.75" /> + <EntityTypeShape EntityType="LocalModel.MACHINES_CONFIGURATIONS" Width="1.5" PointX="14.75" PointY="0.75" /> + <EntityTypeShape EntityType="LocalModel.MACHINES_EVENTS" Width="1.5" PointX="14.75" PointY="3.75" /> + <EntityTypeShape EntityType="LocalModel.MEDIA_COLORS" Width="1.5" PointX="14.75" PointY="7.75" /> + <EntityTypeShape EntityType="LocalModel.MEDIA_CONDITIONS" Width="1.5" PointX="14.75" PointY="10.75" /> + <EntityTypeShape EntityType="LocalModel.MEDIA_MATERIALS" Width="1.5" PointX="14.75" PointY="13.75" /> + <EntityTypeShape EntityType="LocalModel.MEDIA_PURPOSES" Width="1.5" PointX="16.75" PointY="0.75" /> + <EntityTypeShape EntityType="LocalModel.MID_TANK_TYPES" Width="1.5" PointX="2.75" PointY="16.75" /> + <EntityTypeShape EntityType="LocalModel.ORGANIZATION" Width="1.5" PointX="16.75" PointY="3.75" /> + <EntityTypeShape EntityType="LocalModel.PERMISSION" Width="1.5" PointX="4.75" PointY="16.75" /> + <EntityTypeShape EntityType="LocalModel.PROCESS_PARAMETERS_TABLES" Width="1.5" PointX="16.75" PointY="6.75" /> + <EntityTypeShape EntityType="LocalModel.PROCESS_PARAMETERS_TABLES_GROUPS" Width="1.5" PointX="16.75" PointY="12.75" /> + <EntityTypeShape EntityType="LocalModel.RML" Width="1.5" PointX="14.75" PointY="16.75" /> + <EntityTypeShape EntityType="LocalModel.ROLE" Width="1.5" PointX="16.75" PointY="16.75" /> + <EntityTypeShape EntityType="LocalModel.ROLES_PERMISSIONS" Width="1.5" PointX="6.75" PointY="17.75" /> + <EntityTypeShape EntityType="LocalModel.SEGMENT" Width="1.5" PointX="8.75" PointY="17.75" /> + <EntityTypeShape EntityType="LocalModel.SENSOR" Width="1.5" PointX="10.75" PointY="17.75" /> + <EntityTypeShape EntityType="LocalModel.SYNC_CONFIGURATIONS" Width="1.5" PointX="18.75" PointY="0.75" /> + <EntityTypeShape EntityType="LocalModel.USER" Width="1.5" PointX="18.75" PointY="3.75" /> + <EntityTypeShape EntityType="LocalModel.USERS_ROLES" Width="1.5" PointX="18.75" PointY="7.75" /> + <EntityTypeShape EntityType="LocalModel.WINDING_METHODS" Width="1.5" PointX="18.75" PointY="10.75" /> </Diagram> </edmx:Diagrams> </edmx:Designer> diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/MACHINE_VERSIONS.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/MACHINE_VERSIONS.cs index 8507deef3..02dc00a67 100644 --- a/Software/Visual_Studio/Tango.DAL.Local/DB/MACHINE_VERSIONS.cs +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/MACHINE_VERSIONS.cs @@ -17,8 +17,8 @@ namespace Tango.DAL.Local.DB public long ID { get; set; } public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } - public string NAME { get; set; } public double VERSION { get; set; } + public string NAME { get; set; } public string DEFAULT_CONFIGURATION_GUID { get; set; } } } diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/PROCESS_PARAMETERS_TABLES.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/PROCESS_PARAMETERS_TABLES.cs new file mode 100644 index 000000000..a680f9bdd --- /dev/null +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/PROCESS_PARAMETERS_TABLES.cs @@ -0,0 +1,39 @@ +//------------------------------------------------------------------------------ +// <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.Local.DB +{ + using System; + using System.Collections.Generic; + + public partial class PROCESS_PARAMETERS_TABLES + { + public long ID { get; set; } + public string GUID { get; set; } + public System.DateTime LAST_UPDATED { get; set; } + public string NAME { get; set; } + public double DYEING_SPEED { get; set; } + public double MIN_INK_UPTAKE { get; set; } + public double MIXER_TEMP { get; set; } + public double HEAD_ZONE1_TEMP { get; set; } + public double HEAD_ZONE2_TEMP { get; set; } + public double HEAD_ZONE3_TEMP { get; set; } + public double HEAD_AIR_FLOW { get; set; } + public double FEEDER_TENSION { get; set; } + public double PULLER_TENSION { get; set; } + public double DRYER_BUFFER_LENGTH { get; set; } + public double DRYER_ZONE1_TEMP { get; set; } + public double DRYER_ZONE2_TEMP { get; set; } + public double DRYER_ZONE3_TEMP { get; set; } + public double DRYER_AIR_FLOW { get; set; } + public double WINDER_TENSION { get; set; } + public string PROCESS_PARAMETERS_TABLES_GROUP_GUID { get; set; } + public long TABLE_INDEX { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/PROCESS_PARAMETERS_TABLES_GROUPS.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/PROCESS_PARAMETERS_TABLES_GROUPS.cs new file mode 100644 index 000000000..66eccc9da --- /dev/null +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/PROCESS_PARAMETERS_TABLES_GROUPS.cs @@ -0,0 +1,25 @@ +//------------------------------------------------------------------------------ +// <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.Local.DB +{ + using System; + using System.Collections.Generic; + + public partial class PROCESS_PARAMETERS_TABLES_GROUPS + { + public long ID { get; set; } + public string GUID { get; set; } + public System.DateTime LAST_UPDATED { get; set; } + public string RML_GUID { get; set; } + public string NAME { get; set; } + public bool ACTIVE { get; set; } + public System.DateTime SAVE_DATE { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/RML.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/RML.cs index acadec6a9..f529c3a14 100644 --- a/Software/Visual_Studio/Tango.DAL.Local/DB/RML.cs +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/RML.cs @@ -19,6 +19,7 @@ namespace Tango.DAL.Local.DB public System.DateTime LAST_UPDATED { get; set; } public string NAME { get; set; } public string MANUFACTURER { get; set; } + public long CODE { get; set; } public string MATERIAL_GUID { get; set; } public string COLOR_GUID { get; set; } public string PURPOSE_GUID { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/SEGMENT.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/SEGMENT.cs new file mode 100644 index 000000000..2fec238ca --- /dev/null +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/SEGMENT.cs @@ -0,0 +1,24 @@ +//------------------------------------------------------------------------------ +// <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.Local.DB +{ + using System; + using System.Collections.Generic; + + public partial class SEGMENT + { + public long ID { get; set; } + public string GUID { get; set; } + public System.DateTime LAST_UPDATED { get; set; } + public string NAME { get; set; } + public string JOB_GUID { get; set; } + public double LENGTH { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/SENSOR.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/SENSOR.cs new file mode 100644 index 000000000..52684215f --- /dev/null +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/SENSOR.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.Local.DB +{ + using System; + using System.Collections.Generic; + + public partial class SENSOR + { + public long ID { get; set; } + public string GUID { get; set; } + public System.DateTime LAST_UPDATED { get; set; } + public long CODE { get; set; } + public string NAME { get; set; } + public string DESCRIPTION { get; set; } + public double MIN { get; set; } + public double MAX { get; set; } + public string UNITS { get; set; } + public long POINTS_PER_FRAME { get; set; } + public bool MULTI_CHANNEL { get; set; } + public long CHANNEL_COUNT { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/WINDING_METHODS.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/WINDING_METHODS.cs new file mode 100644 index 000000000..a85ca408c --- /dev/null +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/WINDING_METHODS.cs @@ -0,0 +1,24 @@ +//------------------------------------------------------------------------------ +// <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.Local.DB +{ + using System; + using System.Collections.Generic; + + public partial class WINDING_METHODS + { + public long ID { get; set; } + public string GUID { get; set; } + public System.DateTime LAST_UPDATED { get; set; } + public long CODE { get; set; } + public string NAME { get; set; } + public string DESCRIPTION { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.DAL.Local/Tango.DAL.Local.csproj b/Software/Visual_Studio/Tango.DAL.Local/Tango.DAL.Local.csproj index 62e4f2953..1d3577302 100644 --- a/Software/Visual_Studio/Tango.DAL.Local/Tango.DAL.Local.csproj +++ b/Software/Visual_Studio/Tango.DAL.Local/Tango.DAL.Local.csproj @@ -83,6 +83,9 @@ <Compile Include="DB\APPLICATION_VERSIONS.cs"> <DependentUpon>LocalADO.tt</DependentUpon> </Compile> + <Compile Include="DB\BRUSH_STOPS.cs"> + <DependentUpon>LocalADO.tt</DependentUpon> + </Compile> <Compile Include="DB\CARTRIDGE_TYPES.cs"> <DependentUpon>LocalADO.tt</DependentUpon> </Compile> @@ -92,6 +95,9 @@ <Compile Include="DB\CCT.cs"> <DependentUpon>LocalADO.tt</DependentUpon> </Compile> + <Compile Include="DB\COLOR_SPACES.cs"> + <DependentUpon>LocalADO.tt</DependentUpon> + </Compile> <Compile Include="DB\CONFIGURATION.cs"> <DependentUpon>LocalADO.tt</DependentUpon> </Compile> @@ -125,6 +131,12 @@ <Compile Include="DB\IDS_PACKS.cs"> <DependentUpon>LocalADO.tt</DependentUpon> </Compile> + <Compile Include="DB\JOB.cs"> + <DependentUpon>LocalADO.tt</DependentUpon> + </Compile> + <Compile Include="DB\JOB_RUNS.cs"> + <DependentUpon>LocalADO.tt</DependentUpon> + </Compile> <Compile Include="DB\LINEAR_MASS_DENSITY_UNITS.cs"> <DependentUpon>LocalADO.tt</DependentUpon> </Compile> @@ -182,6 +194,12 @@ <Compile Include="DB\PERMISSION.cs"> <DependentUpon>LocalADO.tt</DependentUpon> </Compile> + <Compile Include="DB\PROCESS_PARAMETERS_TABLES.cs"> + <DependentUpon>LocalADO.tt</DependentUpon> + </Compile> + <Compile Include="DB\PROCESS_PARAMETERS_TABLES_GROUPS.cs"> + <DependentUpon>LocalADO.tt</DependentUpon> + </Compile> <Compile Include="DB\RML.cs"> <DependentUpon>LocalADO.tt</DependentUpon> </Compile> @@ -191,6 +209,12 @@ <Compile Include="DB\ROLES_PERMISSIONS.cs"> <DependentUpon>LocalADO.tt</DependentUpon> </Compile> + <Compile Include="DB\SEGMENT.cs"> + <DependentUpon>LocalADO.tt</DependentUpon> + </Compile> + <Compile Include="DB\SENSOR.cs"> + <DependentUpon>LocalADO.tt</DependentUpon> + </Compile> <Compile Include="DB\SYNC_CONFIGURATIONS.cs"> <DependentUpon>LocalADO.tt</DependentUpon> </Compile> @@ -200,6 +224,9 @@ <Compile Include="DB\USERS_ROLES.cs"> <DependentUpon>LocalADO.tt</DependentUpon> </Compile> + <Compile Include="DB\WINDING_METHODS.cs"> + <DependentUpon>LocalADO.tt</DependentUpon> + </Compile> <Compile Include="Partials\LocalDB.cs" /> <Compile Include="Properties\AssemblyInfo.cs" /> </ItemGroup> diff --git a/Software/Visual_Studio/Tango.Synchronization/Remote/RemoteDBComparer.cs b/Software/Visual_Studio/Tango.Synchronization/Remote/RemoteDBComparer.cs index af10f9637..59ac980ba 100644 --- a/Software/Visual_Studio/Tango.Synchronization/Remote/RemoteDBComparer.cs +++ b/Software/Visual_Studio/Tango.Synchronization/Remote/RemoteDBComparer.cs @@ -68,6 +68,14 @@ namespace Tango.Synchronization.Remote var local_users = _localDB.USERS.ToList(); LogManager.Log("Querying all local users roles..."); var local_users_roles = _localDB.USERS_ROLES.ToList(); + LogManager.Log("Querying all local jobs..."); + var local_jobs = _localDB.JOBS.ToList(); + LogManager.Log("Querying all local job runs..."); + var local_job_runs = _localDB.JOB_RUNS.ToList(); + LogManager.Log("Querying all local segments..."); + var local_segments = _localDB.SEGMENTS.ToList(); + LogManager.Log("Querying all local brush stops..."); + var local_brush_stops = _localDB.BRUSH_STOPS.ToList(); //LogManager.Log("Querying all CATS..."); //var local_cats = _localDB.CATS.ToList(); @@ -125,6 +133,18 @@ namespace Tango.Synchronization.Remote guids = remote_ids_packs.Select(x => x.CARTRIDGE_TYPE_GUID).ToList(); var remote_cartridges_types = _remoteDB.CARTRIDGE_TYPES.Where(x => guids.Contains(x.GUID)).ToList(); + LogManager.Log("Querying all remote jobs..."); + var remote_jobs = remote_machines.SelectMany(x => x.JOBS).ToList(); + + LogManager.Log("Querying all remote job runs..."); + var remote_jobs_runs = remote_jobs.SelectMany(x => x.JOB_RUNS).ToList(); + + LogManager.Log("Querying all remote segments..."); + var remote_segments = remote_jobs.SelectMany(x => x.SEGMENTS).ToList(); + + LogManager.Log("Querying all remote brush stops..."); + var remote_brush_stops = remote_segments.SelectMany(x => x.BRUSH_STOPS).ToList(); + //LogManager.Log("Querying all remote CATS..."); //guids = remote_machines.Select(x => x.GUID).ToList(); //var remote_cats = _remoteDB.CATS.Where(x => guids.Contains(x.MACHINE_GUID)).ToList(); @@ -166,6 +186,18 @@ namespace Tango.Synchronization.Remote LogManager.Log("Comparing users roles"); CompareCollections(remote_users_roles, local_users_roles, _remoteDB.USERS_ROLES, _localDB.USERS_ROLES); + LogManager.Log("Comparing jobs"); + CompareCollections(remote_jobs, local_jobs, _remoteDB.JOBS, _localDB.JOBS); + + LogManager.Log("Comparing job runs"); + CompareCollections(remote_jobs_runs, local_job_runs, _remoteDB.JOB_RUNS, _localDB.JOB_RUNS); + + LogManager.Log("Comparing segments"); + CompareCollections(remote_segments, local_segments, _remoteDB.SEGMENTS, _localDB.SEGMENTS); + + LogManager.Log("Comparing brush stops"); + CompareCollections(remote_brush_stops, local_brush_stops, _remoteDB.BRUSH_STOPS, _localDB.BRUSH_STOPS); + //LogManager.Log("Comparing cats"); //CompareCollections(remote_cats, local_cats, _remoteDB.CATS, _localDB.CATS); diff --git a/Software/Visual_Studio/Tango.sln b/Software/Visual_Studio/Tango.sln index d16c26a38..caf47b3b8 100644 --- a/Software/Visual_Studio/Tango.sln +++ b/Software/Visual_Studio/Tango.sln @@ -115,6 +115,8 @@ Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "RealTimeGraphEx", "SideChai EndProject Project("{54435603-DBB4-11D2-8724-00A0C9A8B90C}") = "Tango.MachineStudio.Installer", "MachineStudio\Tango.MachineStudio.Installer\Tango.MachineStudio.Installer.vdproj", "{A19DEAB8-7356-4BCD-9FA8-B2FA09077165}" EndProject +Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "Tango.SQLiteGenerator.CLI", "Utilities\Tango.SQLiteGenerator.CLI\Tango.SQLiteGenerator.CLI.csproj", "{8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}" +EndProject Global GlobalSection(SolutionConfigurationPlatforms) = preSolution Debug|Any CPU = Debug|Any CPU @@ -1463,6 +1465,36 @@ Global {A19DEAB8-7356-4BCD-9FA8-B2FA09077165}.Release|ARM64.ActiveCfg = Release {A19DEAB8-7356-4BCD-9FA8-B2FA09077165}.Release|x64.ActiveCfg = Release {A19DEAB8-7356-4BCD-9FA8-B2FA09077165}.Release|x86.ActiveCfg = Release + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.Debug|Any CPU.ActiveCfg = Debug|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.Debug|Any CPU.Build.0 = Debug|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.Debug|ARM.ActiveCfg = Debug|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.Debug|ARM.Build.0 = Debug|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.Debug|ARM64.ActiveCfg = Debug|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.Debug|ARM64.Build.0 = Debug|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.Debug|x64.ActiveCfg = Debug|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.Debug|x64.Build.0 = Debug|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.Debug|x86.ActiveCfg = Debug|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.Debug|x86.Build.0 = Debug|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.DefaultBuild|Any CPU.ActiveCfg = Debug|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.DefaultBuild|Any CPU.Build.0 = Debug|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.DefaultBuild|ARM.ActiveCfg = Debug|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.DefaultBuild|ARM.Build.0 = Debug|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.DefaultBuild|ARM64.ActiveCfg = Debug|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.DefaultBuild|ARM64.Build.0 = Debug|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.DefaultBuild|x64.ActiveCfg = Debug|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.DefaultBuild|x64.Build.0 = Debug|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.DefaultBuild|x86.ActiveCfg = Debug|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.DefaultBuild|x86.Build.0 = Debug|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.Release|Any CPU.ActiveCfg = Release|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.Release|Any CPU.Build.0 = Release|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.Release|ARM.ActiveCfg = Release|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.Release|ARM.Build.0 = Release|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.Release|ARM64.ActiveCfg = Release|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.Release|ARM64.Build.0 = Release|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.Release|x64.ActiveCfg = Release|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.Release|x64.Build.0 = Release|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.Release|x86.ActiveCfg = Release|Any CPU + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}.Release|x86.Build.0 = Release|Any CPU EndGlobalSection GlobalSection(SolutionProperties) = preSolution HideSolutionNode = FALSE @@ -1494,5 +1526,6 @@ Global {5D39C1E1-3ECD-4634-BD1B-2BCF71C54A15} = {B2AF4F3F-2828-47C3-8F3E-A0EA0BD66FF8} {B9AE25D6-BE35-492F-9079-21A7F3E6F7CC} = {EC62BC9C-F2FE-4333-B7E4-110E38D43958} {A19DEAB8-7356-4BCD-9FA8-B2FA09077165} = {57DF2A95-5DDD-4830-A4AF-B484B59C7C2B} + {8A03ADC0-991B-4DA8-8A19-E1D03F92E81C} = {5F6BBAA8-EAD0-4B18-97E5-55B4F56DD760} EndGlobalSection EndGlobal diff --git a/Software/Visual_Studio/Utilities/Tango.SQLiteGenerator.CLI/App.config b/Software/Visual_Studio/Utilities/Tango.SQLiteGenerator.CLI/App.config new file mode 100644 index 000000000..92aa00bf9 --- /dev/null +++ b/Software/Visual_Studio/Utilities/Tango.SQLiteGenerator.CLI/App.config @@ -0,0 +1,16 @@ +<?xml version="1.0" encoding="utf-8"?> +<configuration> + <configSections> + <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 --> + <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" /> + </configSections> + <startup> + <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6" /> + </startup> + <entityFramework> + <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" /> + <providers> + <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" /> + </providers> + </entityFramework> +</configuration>
\ No newline at end of file diff --git a/Software/Visual_Studio/Utilities/Tango.SQLiteGenerator.CLI/Program.cs b/Software/Visual_Studio/Utilities/Tango.SQLiteGenerator.CLI/Program.cs new file mode 100644 index 000000000..242cdcfa9 --- /dev/null +++ b/Software/Visual_Studio/Utilities/Tango.SQLiteGenerator.CLI/Program.cs @@ -0,0 +1,79 @@ +using System; +using System.Collections.Generic; +using System.IO; +using System.Linq; +using System.Text; +using System.Threading.Tasks; +using Tango.DAL.Remote.DB; +using Tango.Settings; +using Tango.Synchronization; +using Tango.Synchronization.Conversion; + +namespace Tango.SQLiteGenerator.CLI +{ + class Program + { + static void Main(string[] args) + { + String sqlitePath = args[0]; + + sqlitePath = Path.GetFullPath(sqlitePath); + + bool completed = false; + + String connectionString = SettingsManager.Default.DataBase.SQLServerAddress; + + Console.WriteLine("Connecting to " + connectionString + "..."); + + connectionString = String.Format("Data Source={0};Initial Catalog=Tango;Integrated Security=SSPI;", connectionString); + + List<SYNC_CONFIGURATIONS> sync_configurations = new List<SYNC_CONFIGURATIONS>(); + + using (RemoteDB db = RemoteDB.CreateDefault()) + { + sync_configurations = db.SYNC_CONFIGURATIONS.ToList(); + } + + SqlConversionHandler handler = new SqlConversionHandler(delegate (bool done, bool success, int percent, string msg) + { + Console.WriteLine(String.Format("{0} [%{1}]", msg, percent)); + + if (done) + { + if (success) + { + Console.WriteLine("SQLite database has been generated successfully on " + sqlitePath); + Environment.Exit(0); + } + else + { + Console.WriteLine("SQLite database generation failed!"); + Environment.Exit(-1); + } + + completed = true; + } + }); + + SqlTableSelectionHandler selectionHandler = new SqlTableSelectionHandler(delegate (List<TableSchema> schema) + { + List<TableSchema> updated = schema.Where(x => x.TableName.ToLower() != "sysdiagrams").ToList(); + + updated + .Where(table => sync_configurations.Where(config => (SyncConfiguration)config.SYNC_TYPE == SyncConfiguration.OverwriteLocal).ToList() + .Exists(config => config.TABLE_NAME == table.TableName)).ToList().ForEach(x => x.CopyData = true); + + return updated; + }); + + SqlServerToSQLiteConverter converter = new SqlServerToSQLiteConverter(); + + converter.ConvertSqlServerToSQLiteDatabase(connectionString, sqlitePath, null, handler, selectionHandler, null, false, false); + + while (!completed) + { + Console.ReadLine(); + } + } + } +} diff --git a/Software/Visual_Studio/Utilities/Tango.SQLiteGenerator.CLI/Properties/AssemblyInfo.cs b/Software/Visual_Studio/Utilities/Tango.SQLiteGenerator.CLI/Properties/AssemblyInfo.cs new file mode 100644 index 000000000..a050c5eff --- /dev/null +++ b/Software/Visual_Studio/Utilities/Tango.SQLiteGenerator.CLI/Properties/AssemblyInfo.cs @@ -0,0 +1,36 @@ +using System.Reflection; +using System.Runtime.CompilerServices; +using System.Runtime.InteropServices; + +// General Information about an assembly is controlled through the following +// set of attributes. Change these attribute values to modify the information +// associated with an assembly. +[assembly: AssemblyTitle("Tango.SQLiteGenerator.CLI")] +[assembly: AssemblyDescription("")] +[assembly: AssemblyConfiguration("")] +[assembly: AssemblyCompany("")] +[assembly: AssemblyProduct("Tango.SQLiteGenerator.CLI")] +[assembly: AssemblyCopyright("Copyright © 2018")] +[assembly: AssemblyTrademark("")] +[assembly: AssemblyCulture("")] + +// Setting ComVisible to false makes the types in this assembly not visible +// to COM components. If you need to access a type in this assembly from +// COM, set the ComVisible attribute to true on that type. +[assembly: ComVisible(false)] + +// The following GUID is for the ID of the typelib if this project is exposed to COM +[assembly: Guid("8a03adc0-991b-4da8-8a19-e1d03f92e81c")] + +// Version information for an assembly consists of the following four values: +// +// Major Version +// Minor Version +// Build Number +// Revision +// +// You can specify all the values or you can default the Build and Revision Numbers +// by using the '*' as shown below: +// [assembly: AssemblyVersion("1.0.*")] +[assembly: AssemblyVersion("1.0.0.0")] +[assembly: AssemblyFileVersion("1.0.0.0")] diff --git a/Software/Visual_Studio/Utilities/Tango.SQLiteGenerator.CLI/Tango.SQLiteGenerator.CLI.csproj b/Software/Visual_Studio/Utilities/Tango.SQLiteGenerator.CLI/Tango.SQLiteGenerator.CLI.csproj new file mode 100644 index 000000000..2e9420527 --- /dev/null +++ b/Software/Visual_Studio/Utilities/Tango.SQLiteGenerator.CLI/Tango.SQLiteGenerator.CLI.csproj @@ -0,0 +1,74 @@ +<?xml version="1.0" encoding="utf-8"?> +<Project ToolsVersion="15.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> + <Import Project="$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props" Condition="Exists('$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props')" /> + <PropertyGroup> + <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration> + <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform> + <ProjectGuid>{8A03ADC0-991B-4DA8-8A19-E1D03F92E81C}</ProjectGuid> + <OutputType>Exe</OutputType> + <RootNamespace>Tango.SQLiteGenerator.CLI</RootNamespace> + <AssemblyName>sqlitegen</AssemblyName> + <TargetFrameworkVersion>v4.6</TargetFrameworkVersion> + <FileAlignment>512</FileAlignment> + <AutoGenerateBindingRedirects>true</AutoGenerateBindingRedirects> + </PropertyGroup> + <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' "> + <PlatformTarget>AnyCPU</PlatformTarget> + <DebugSymbols>true</DebugSymbols> + <DebugType>full</DebugType> + <Optimize>false</Optimize> + <OutputPath>..\..\Build\Debug\</OutputPath> + <DefineConstants>DEBUG;TRACE</DefineConstants> + <ErrorReport>prompt</ErrorReport> + <WarningLevel>4</WarningLevel> + </PropertyGroup> + <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' "> + <PlatformTarget>AnyCPU</PlatformTarget> + <DebugType>pdbonly</DebugType> + <Optimize>true</Optimize> + <OutputPath>bin\Release\</OutputPath> + <DefineConstants>TRACE</DefineConstants> + <ErrorReport>prompt</ErrorReport> + <WarningLevel>4</WarningLevel> + </PropertyGroup> + <ItemGroup> + <Reference Include="EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, processorArchitecture=MSIL"> + <HintPath>..\..\packages\EntityFramework.6.0.0\lib\net45\EntityFramework.dll</HintPath> + </Reference> + <Reference Include="EntityFramework.SqlServer, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, processorArchitecture=MSIL"> + <HintPath>..\..\packages\EntityFramework.6.0.0\lib\net45\EntityFramework.SqlServer.dll</HintPath> + </Reference> + <Reference Include="System" /> + <Reference Include="System.ComponentModel.DataAnnotations" /> + <Reference Include="System.Core" /> + <Reference Include="System.Xml.Linq" /> + <Reference Include="System.Data.DataSetExtensions" /> + <Reference Include="Microsoft.CSharp" /> + <Reference Include="System.Data" /> + <Reference Include="System.Net.Http" /> + <Reference Include="System.Xml" /> + </ItemGroup> + <ItemGroup> + <Compile Include="Program.cs" /> + <Compile Include="Properties\AssemblyInfo.cs" /> + </ItemGroup> + <ItemGroup> + <None Include="App.config" /> + <None Include="packages.config" /> + </ItemGroup> + <ItemGroup> + <ProjectReference Include="..\..\Tango.DAL.Remote\Tango.DAL.Remote.csproj"> + <Project>{38197109-8610-4d3f-92b9-16d48df94d7c}</Project> + <Name>Tango.DAL.Remote</Name> + </ProjectReference> + <ProjectReference Include="..\..\Tango.Settings\Tango.Settings.csproj"> + <Project>{d8f1ad85-526a-4f50-b6dc-d437af63d8d8}</Project> + <Name>Tango.Settings</Name> + </ProjectReference> + <ProjectReference Include="..\..\Tango.Synchronization\Tango.Synchronization.csproj"> + <Project>{7ada4e86-cad7-4968-a210-3a8a9e5153ab}</Project> + <Name>Tango.Synchronization</Name> + </ProjectReference> + </ItemGroup> + <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" /> +</Project>
\ No newline at end of file diff --git a/Software/Visual_Studio/Utilities/Tango.SQLiteGenerator.CLI/packages.config b/Software/Visual_Studio/Utilities/Tango.SQLiteGenerator.CLI/packages.config new file mode 100644 index 000000000..9256e1591 --- /dev/null +++ b/Software/Visual_Studio/Utilities/Tango.SQLiteGenerator.CLI/packages.config @@ -0,0 +1,4 @@ +<?xml version="1.0" encoding="utf-8"?> +<packages> + <package id="EntityFramework" version="6.0.0" targetFramework="net46" /> +</packages>
\ No newline at end of file |