diff options
52 files changed, 900 insertions, 845 deletions
diff --git a/Software/DB/Tango.db b/Software/DB/Tango.db Binary files differindex a0b28abd7..45575ec67 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 4e7df2ba3..3328da8c3 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 b1d387d73..b37f7d6c8 100644 --- a/Software/DB/Tango_log.ldf +++ b/Software/DB/Tango_log.ldf diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/ACTION.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/ACTION.cs index 0d6d93cbd..3f39ea77d 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/ACTION.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/ACTION.cs @@ -21,7 +21,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public int CODE { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/ADDRESS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/ADDRESS.cs index 3cbe7d0d6..d224e3273 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/ADDRESS.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/ADDRESS.cs @@ -22,7 +22,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public string ADDRESS1 { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/APPLICATION_DISPLAY_PANEL_VERSIONS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/APPLICATION_DISPLAY_PANEL_VERSIONS.cs index efba337da..703011569 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/APPLICATION_DISPLAY_PANEL_VERSIONS.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/APPLICATION_DISPLAY_PANEL_VERSIONS.cs @@ -21,7 +21,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/APPLICATION_FIRMWARE_VERSIONS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/APPLICATION_FIRMWARE_VERSIONS.cs index a51070adc..c1c51b057 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/APPLICATION_FIRMWARE_VERSIONS.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/APPLICATION_FIRMWARE_VERSIONS.cs @@ -21,7 +21,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/APPLICATION_OS_VERSIONS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/APPLICATION_OS_VERSIONS.cs index 2db9b1ceb..4c0535134 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/APPLICATION_OS_VERSIONS.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/APPLICATION_OS_VERSIONS.cs @@ -21,7 +21,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/APPLICATION_VERSIONS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/APPLICATION_VERSIONS.cs index 307d86358..beeb8c59e 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/APPLICATION_VERSIONS.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/APPLICATION_VERSIONS.cs @@ -21,7 +21,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/CONFIGURATION.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/CONFIGURATION.cs index 1d80a58a8..e846672d2 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/CONFIGURATION.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/CONFIGURATION.cs @@ -22,7 +22,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public System.DateTime CREATION_DATE { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/CONFIGURATIONS_DISPENSERS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/CONFIGURATIONS_DISPENSERS.cs index 314130c6a..43282f26c 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/CONFIGURATIONS_DISPENSERS.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/CONFIGURATIONS_DISPENSERS.cs @@ -15,7 +15,7 @@ namespace Tango.DAL.Remote.DB public partial class CONFIGURATIONS_DISPENSERS { public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public int CONFIGURATION_ID { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/CONTACT.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/CONTACT.cs index 776de0b9d..bbbbc625b 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/CONTACT.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/CONTACT.cs @@ -22,7 +22,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public string FIRST_NAME { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/DISPENSER.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/DISPENSER.cs index 0d85157cf..592b04eae 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/DISPENSER.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/DISPENSER.cs @@ -21,7 +21,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/EMBEDDED_FIRMWARE_VERSIONS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/EMBEDDED_FIRMWARE_VERSIONS.cs index 57c0ff17d..2c251b5e2 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/EMBEDDED_FIRMWARE_VERSIONS.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/EMBEDDED_FIRMWARE_VERSIONS.cs @@ -21,7 +21,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/EMBEDDED_SOFTWARE_VERSIONS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/EMBEDDED_SOFTWARE_VERSIONS.cs index 8729b1f14..5e1546b20 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/EMBEDDED_SOFTWARE_VERSIONS.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/EMBEDDED_SOFTWARE_VERSIONS.cs @@ -21,7 +21,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/EVENT.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/EVENT.cs index abfb0420f..556d2d789 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/EVENT.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/EVENT.cs @@ -22,7 +22,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public int CODE { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/EVENTS_ACTIONS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/EVENTS_ACTIONS.cs index 58797a747..9a0361b85 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/EVENTS_ACTIONS.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/EVENTS_ACTIONS.cs @@ -15,7 +15,7 @@ namespace Tango.DAL.Remote.DB public partial class EVENTS_ACTIONS { public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public int EVENT_ID { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/FIBER_SHAPES.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/FIBER_SHAPES.cs index bc97ccc51..06193f82e 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/FIBER_SHAPES.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/FIBER_SHAPES.cs @@ -21,7 +21,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public string NAME { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/FIBER_SYNTHESIS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/FIBER_SYNTHESIS.cs index 4182e0bc2..09ee686ce 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/FIBER_SYNTHESIS.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/FIBER_SYNTHESIS.cs @@ -21,7 +21,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public string NAME { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/HARDWARE_VERSIONS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/HARDWARE_VERSIONS.cs index da7891f4c..237448341 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/HARDWARE_VERSIONS.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/HARDWARE_VERSIONS.cs @@ -21,7 +21,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/LINEAR_MASS_DENSITY_UNITS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/LINEAR_MASS_DENSITY_UNITS.cs index a0af02a1d..aacbe6711 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/LINEAR_MASS_DENSITY_UNITS.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/LINEAR_MASS_DENSITY_UNITS.cs @@ -21,7 +21,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public string NAME { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/LIQUID.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/LIQUID.cs index 68bfed902..b606ef03f 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/LIQUID.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/LIQUID.cs @@ -22,7 +22,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public string NAME { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/LIQUIDS_RML.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/LIQUIDS_RML.cs index 3dff203c6..15ebbd482 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/LIQUIDS_RML.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/LIQUIDS_RML.cs @@ -15,7 +15,7 @@ namespace Tango.DAL.Remote.DB public partial class LIQUIDS_RML { public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public int LIQUID_ID { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/LIQUID_TYPES.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/LIQUID_TYPES.cs index f666b3517..f8203bafb 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/LIQUID_TYPES.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/LIQUID_TYPES.cs @@ -21,7 +21,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public string NAME { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/MACHINE.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/MACHINE.cs index 5a319a9fd..4db95037c 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/MACHINE.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/MACHINE.cs @@ -22,7 +22,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public string SERIAL_NUMBER { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/MACHINES_EVENTS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/MACHINES_EVENTS.cs index 94084ead1..21af0ab86 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/MACHINES_EVENTS.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/MACHINES_EVENTS.cs @@ -15,7 +15,7 @@ namespace Tango.DAL.Remote.DB public partial class MACHINES_EVENTS { public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public int MACHINE_ID { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/MACHINE_VERSIONS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/MACHINE_VERSIONS.cs index 581cb39a2..705343b7b 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/MACHINE_VERSIONS.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/MACHINE_VERSIONS.cs @@ -21,7 +21,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public double VERSION { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/MEDIA_COLORS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/MEDIA_COLORS.cs index 3a05bfc13..0978ccd5c 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/MEDIA_COLORS.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/MEDIA_COLORS.cs @@ -21,7 +21,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public int COLOR { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/MEDIA_CONDITIONS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/MEDIA_CONDITIONS.cs index d4127674f..c3d286353 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/MEDIA_CONDITIONS.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/MEDIA_CONDITIONS.cs @@ -21,7 +21,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public string NAME { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/MEDIA_MATERIALS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/MEDIA_MATERIALS.cs index ad0e44d0c..cfcb5bc60 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/MEDIA_MATERIALS.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/MEDIA_MATERIALS.cs @@ -21,7 +21,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public string NAME { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/MEDIA_PURPOSES.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/MEDIA_PURPOSES.cs index 0db016179..2f82fb67a 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/MEDIA_PURPOSES.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/MEDIA_PURPOSES.cs @@ -21,7 +21,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public string NAME { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/ORGANIZATION.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/ORGANIZATION.cs index 68ca7f84c..8bee25411 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/ORGANIZATION.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/ORGANIZATION.cs @@ -22,7 +22,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public string NAME { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/PERMISSION.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/PERMISSION.cs index a8c6105c3..106c4b5a7 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/PERMISSION.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/PERMISSION.cs @@ -21,7 +21,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public string NAME { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/RML.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/RML.cs index e43af9f36..3b0d164c8 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/RML.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/RML.cs @@ -21,7 +21,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public string MANUFACTURER { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/ROLE.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/ROLE.cs index f18f0663b..fb650c07a 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/ROLE.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/ROLE.cs @@ -22,7 +22,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public string NAME { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/ROLES_PERMISSIONS.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/ROLES_PERMISSIONS.cs index 910f18079..d5688a549 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/ROLES_PERMISSIONS.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/ROLES_PERMISSIONS.cs @@ -15,7 +15,7 @@ namespace Tango.DAL.Remote.DB public partial class ROLES_PERMISSIONS { public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public int ROLE_ID { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx b/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx index 5d48fdcd1..c024e5741 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx @@ -4,13 +4,13 @@ <edmx:Runtime> <!-- SSDL content --> <edmx:StorageModels> - <Schema Namespace="RemoteModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl"> + <Schema Namespace="RemoteModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl"> <EntityType Name="ACTIONS"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="CODE" Type="int" Nullable="false" /> @@ -22,7 +22,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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" Type="nvarchar" MaxLength="100" Nullable="false" /> @@ -38,7 +38,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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" /> </EntityType> @@ -47,7 +47,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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" /> </EntityType> @@ -56,7 +56,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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" /> </EntityType> @@ -65,7 +65,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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" /> </EntityType> @@ -74,7 +74,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="CREATION_DATE" Type="datetime" Nullable="false" /> @@ -92,7 +92,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="CONFIGURATION_ID" Type="int" Nullable="false" /> @@ -104,7 +104,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="50" Nullable="false" /> @@ -119,7 +119,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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" /> </EntityType> @@ -128,7 +128,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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" /> </EntityType> @@ -137,7 +137,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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" /> </EntityType> @@ -146,7 +146,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="CODE" Type="int" Nullable="false" /> @@ -158,7 +158,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="EVENT_ID" Type="int" Nullable="false" /> @@ -169,7 +169,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> @@ -180,7 +180,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> @@ -191,7 +191,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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" /> </EntityType> @@ -200,7 +200,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> @@ -211,7 +211,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> @@ -223,7 +223,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> @@ -235,7 +235,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="LIQUID_ID" Type="int" Nullable="false" /> @@ -246,7 +246,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="VERSION" Type="float" Nullable="false" /> @@ -257,7 +257,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="SERIAL_NUMBER" Type="varchar" MaxLength="50" Nullable="false" /> @@ -270,7 +270,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="MACHINE_ID" Type="int" Nullable="false" /> @@ -284,7 +284,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="COLOR" Type="int" Nullable="false" /> @@ -294,7 +294,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> @@ -305,7 +305,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> @@ -316,7 +316,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> @@ -327,7 +327,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> @@ -339,7 +339,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="NAME" Type="nvarchar" MaxLength="30" Nullable="false" /> @@ -350,7 +350,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="MANUFACTURER" Type="nvarchar" MaxLength="50" Nullable="false" /> @@ -377,7 +377,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="NAME" Type="nvarchar" MaxLength="30" Nullable="false" /> @@ -388,7 +388,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="ROLE_ID" Type="int" Nullable="false" /> @@ -399,7 +399,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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="50" Nullable="false" /> @@ -413,7 +413,7 @@ <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="uniqueidentifier" 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_ID" Type="int" Nullable="false" /> @@ -1064,88 +1064,276 @@ <End Role="USERS_ROLES" EntitySet="USERS_ROLES" /> </AssociationSet> </EntityContainer> - </Schema> - </edmx:StorageModels> + </Schema></edmx:StorageModels> <!-- CSDL content --> <edmx:ConceptualModels> <Schema Namespace="RemoteModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm"> + <EntityContainer Name="RemoteDB" annotation:LazyLoadingEnabled="true"> + <EntitySet Name="ACTIONS" EntityType="RemoteModel.ACTION" /> + <EntitySet Name="ADDRESSES" EntityType="RemoteModel.ADDRESS" /> + <EntitySet Name="APPLICATION_DISPLAY_PANEL_VERSIONS" EntityType="RemoteModel.APPLICATION_DISPLAY_PANEL_VERSIONS" /> + <EntitySet Name="APPLICATION_FIRMWARE_VERSIONS" EntityType="RemoteModel.APPLICATION_FIRMWARE_VERSIONS" /> + <EntitySet Name="APPLICATION_OS_VERSIONS" EntityType="RemoteModel.APPLICATION_OS_VERSIONS" /> + <EntitySet Name="APPLICATION_VERSIONS" EntityType="RemoteModel.APPLICATION_VERSIONS" /> + <EntitySet Name="CONFIGURATIONS" EntityType="RemoteModel.CONFIGURATION" /> + <EntitySet Name="CONFIGURATIONS_DISPENSERS" EntityType="RemoteModel.CONFIGURATIONS_DISPENSERS" /> + <EntitySet Name="CONTACTS" EntityType="RemoteModel.CONTACT" /> + <EntitySet Name="DISPENSERS" EntityType="RemoteModel.DISPENSER" /> + <EntitySet Name="EMBEDDED_FIRMWARE_VERSIONS" EntityType="RemoteModel.EMBEDDED_FIRMWARE_VERSIONS" /> + <EntitySet Name="EMBEDDED_SOFTWARE_VERSIONS" EntityType="RemoteModel.EMBEDDED_SOFTWARE_VERSIONS" /> + <EntitySet Name="EVENTS" EntityType="RemoteModel.EVENT" /> + <EntitySet Name="EVENTS_ACTIONS" EntityType="RemoteModel.EVENTS_ACTIONS" /> + <EntitySet Name="FIBER_SHAPES" EntityType="RemoteModel.FIBER_SHAPES" /> + <EntitySet Name="FIBER_SYNTHESIS" EntityType="RemoteModel.FIBER_SYNTHESIS" /> + <EntitySet Name="HARDWARE_VERSIONS" EntityType="RemoteModel.HARDWARE_VERSIONS" /> + <EntitySet Name="LINEAR_MASS_DENSITY_UNITS" EntityType="RemoteModel.LINEAR_MASS_DENSITY_UNITS" /> + <EntitySet Name="LIQUID_TYPES" EntityType="RemoteModel.LIQUID_TYPES" /> + <EntitySet Name="LIQUIDS" EntityType="RemoteModel.LIQUID" /> + <EntitySet Name="LIQUIDS_RML" EntityType="RemoteModel.LIQUIDS_RML" /> + <EntitySet Name="MACHINE_VERSIONS" EntityType="RemoteModel.MACHINE_VERSIONS" /> + <EntitySet Name="MACHINES" EntityType="RemoteModel.MACHINE" /> + <EntitySet Name="MACHINES_EVENTS" EntityType="RemoteModel.MACHINES_EVENTS" /> + <EntitySet Name="MEDIA_COLORS" EntityType="RemoteModel.MEDIA_COLORS" /> + <EntitySet Name="MEDIA_CONDITIONS" EntityType="RemoteModel.MEDIA_CONDITIONS" /> + <EntitySet Name="MEDIA_MATERIALS" EntityType="RemoteModel.MEDIA_MATERIALS" /> + <EntitySet Name="MEDIA_PURPOSES" EntityType="RemoteModel.MEDIA_PURPOSES" /> + <EntitySet Name="ORGANIZATIONS" EntityType="RemoteModel.ORGANIZATION" /> + <EntitySet Name="PERMISSIONS" EntityType="RemoteModel.PERMISSION" /> + <EntitySet Name="RMLs" EntityType="RemoteModel.RML" /> + <EntitySet Name="ROLES" EntityType="RemoteModel.ROLE" /> + <EntitySet Name="ROLES_PERMISSIONS" EntityType="RemoteModel.ROLES_PERMISSIONS" /> + <EntitySet Name="USERS" EntityType="RemoteModel.USER" /> + <EntitySet Name="USERS_ROLES" EntityType="RemoteModel.USERS_ROLES" /> + <AssociationSet Name="FK_EVENTS_ACTIONS_ACTIONS" Association="RemoteModel.FK_EVENTS_ACTIONS_ACTIONS"> + <End Role="ACTION" EntitySet="ACTIONS" /> + <End Role="EVENTS_ACTIONS" EntitySet="EVENTS_ACTIONS" /> + </AssociationSet> + <AssociationSet Name="FK_ORGANIZATIONS_ADDRESSES" Association="RemoteModel.FK_ORGANIZATIONS_ADDRESSES"> + <End Role="ADDRESS" EntitySet="ADDRESSES" /> + <End Role="ORGANIZATION" EntitySet="ORGANIZATIONS" /> + </AssociationSet> + <AssociationSet Name="FK_USERS_ADDRESSES" Association="RemoteModel.FK_USERS_ADDRESSES"> + <End Role="ADDRESS" EntitySet="ADDRESSES" /> + <End Role="USER" EntitySet="USERS" /> + </AssociationSet> + <AssociationSet Name="FK_CONFIGURATIONS_APPLICATION_DISPLAY_PANEL_VERSIONS" Association="RemoteModel.FK_CONFIGURATIONS_APPLICATION_DISPLAY_PANEL_VERSIONS"> + <End Role="APPLICATION_DISPLAY_PANEL_VERSIONS" EntitySet="APPLICATION_DISPLAY_PANEL_VERSIONS" /> + <End Role="CONFIGURATION" EntitySet="CONFIGURATIONS" /> + </AssociationSet> + <AssociationSet Name="FK_CONFIGURATIONS_APPLICATION_FIRMWARE_VERSIONS" Association="RemoteModel.FK_CONFIGURATIONS_APPLICATION_FIRMWARE_VERSIONS"> + <End Role="APPLICATION_FIRMWARE_VERSIONS" EntitySet="APPLICATION_FIRMWARE_VERSIONS" /> + <End Role="CONFIGURATION" EntitySet="CONFIGURATIONS" /> + </AssociationSet> + <AssociationSet Name="FK_CONFIGURATIONS_APPLICATION_OS_VERSIONS" Association="RemoteModel.FK_CONFIGURATIONS_APPLICATION_OS_VERSIONS"> + <End Role="APPLICATION_OS_VERSIONS" EntitySet="APPLICATION_OS_VERSIONS" /> + <End Role="CONFIGURATION" EntitySet="CONFIGURATIONS" /> + </AssociationSet> + <AssociationSet Name="FK_CONFIGURATIONS_APPLICATION_VERSIONS" Association="RemoteModel.FK_CONFIGURATIONS_APPLICATION_VERSIONS"> + <End Role="APPLICATION_VERSIONS" EntitySet="APPLICATION_VERSIONS" /> + <End Role="CONFIGURATION" EntitySet="CONFIGURATIONS" /> + </AssociationSet> + <AssociationSet Name="FK_CONFIGURATIONS_DISPENSERS_CONFIGURATIONS" Association="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_CONFIGURATIONS"> + <End Role="CONFIGURATION" EntitySet="CONFIGURATIONS" /> + <End Role="CONFIGURATIONS_DISPENSERS" EntitySet="CONFIGURATIONS_DISPENSERS" /> + </AssociationSet> + <AssociationSet Name="FK_CONFIGURATIONS_EMBEDDED_FIRMWARE_VERSIONS" Association="RemoteModel.FK_CONFIGURATIONS_EMBEDDED_FIRMWARE_VERSIONS"> + <End Role="EMBEDDED_FIRMWARE_VERSIONS" EntitySet="EMBEDDED_FIRMWARE_VERSIONS" /> + <End Role="CONFIGURATION" EntitySet="CONFIGURATIONS" /> + </AssociationSet> + <AssociationSet Name="FK_CONFIGURATIONS_EMBEDDED_SOFTWARE_VERSIONS" Association="RemoteModel.FK_CONFIGURATIONS_EMBEDDED_SOFTWARE_VERSIONS"> + <End Role="EMBEDDED_SOFTWARE_VERSIONS" EntitySet="EMBEDDED_SOFTWARE_VERSIONS" /> + <End Role="CONFIGURATION" EntitySet="CONFIGURATIONS" /> + </AssociationSet> + <AssociationSet Name="FK_CONFIGURATIONS_HARDWARE_VERSIONS" Association="RemoteModel.FK_CONFIGURATIONS_HARDWARE_VERSIONS"> + <End Role="HARDWARE_VERSIONS" EntitySet="HARDWARE_VERSIONS" /> + <End Role="CONFIGURATION" EntitySet="CONFIGURATIONS" /> + </AssociationSet> + <AssociationSet Name="FK_CONFIGURATIONS_MACHINES" Association="RemoteModel.FK_CONFIGURATIONS_MACHINES"> + <End Role="MACHINE" EntitySet="MACHINES" /> + <End Role="CONFIGURATION" EntitySet="CONFIGURATIONS" /> + </AssociationSet> + <AssociationSet Name="FK_MACHINE_VERSIONS_CONFIGURATIONS" Association="RemoteModel.FK_MACHINE_VERSIONS_CONFIGURATIONS"> + <End Role="CONFIGURATION" EntitySet="CONFIGURATIONS" /> + <End Role="MACHINE_VERSIONS" EntitySet="MACHINE_VERSIONS" /> + </AssociationSet> + <AssociationSet Name="FK_CONFIGURATIONS_DISPENSERS_DISPENSERS" Association="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_DISPENSERS"> + <End Role="DISPENSER" EntitySet="DISPENSERS" /> + <End Role="CONFIGURATIONS_DISPENSERS" EntitySet="CONFIGURATIONS_DISPENSERS" /> + </AssociationSet> + <AssociationSet Name="FK_CONFIGURATIONS_DISPENSERS_LIQUIDS" Association="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_LIQUIDS"> + <End Role="LIQUID" EntitySet="LIQUIDS" /> + <End Role="CONFIGURATIONS_DISPENSERS" EntitySet="CONFIGURATIONS_DISPENSERS" /> + </AssociationSet> + <AssociationSet Name="FK_ORGANIZATIONS_CONTACTS" Association="RemoteModel.FK_ORGANIZATIONS_CONTACTS"> + <End Role="CONTACT" EntitySet="CONTACTS" /> + <End Role="ORGANIZATION" EntitySet="ORGANIZATIONS" /> + </AssociationSet> + <AssociationSet Name="FK_USERS_CONTACTS" Association="RemoteModel.FK_USERS_CONTACTS"> + <End Role="CONTACT" EntitySet="CONTACTS" /> + <End Role="USER" EntitySet="USERS" /> + </AssociationSet> + <AssociationSet Name="FK_EVENTS_ACTIONS_EVENTS" Association="RemoteModel.FK_EVENTS_ACTIONS_EVENTS"> + <End Role="EVENT" EntitySet="EVENTS" /> + <End Role="EVENTS_ACTIONS" EntitySet="EVENTS_ACTIONS" /> + </AssociationSet> + <AssociationSet Name="FK_MACHINES_EVENTS_EVENTS" Association="RemoteModel.FK_MACHINES_EVENTS_EVENTS"> + <End Role="EVENT" EntitySet="EVENTS" /> + <End Role="MACHINES_EVENTS" EntitySet="MACHINES_EVENTS" /> + </AssociationSet> + <AssociationSet Name="FK_RML_FIBER_SHAPES" Association="RemoteModel.FK_RML_FIBER_SHAPES"> + <End Role="FIBER_SHAPES" EntitySet="FIBER_SHAPES" /> + <End Role="RML" EntitySet="RMLs" /> + </AssociationSet> + <AssociationSet Name="FK_RML_FIBER_SYNTHESIS" Association="RemoteModel.FK_RML_FIBER_SYNTHESIS"> + <End Role="FIBER_SYNTHESIS" EntitySet="FIBER_SYNTHESIS" /> + <End Role="RML" EntitySet="RMLs" /> + </AssociationSet> + <AssociationSet Name="FK_RML_LINEAR_MASS_DENSITY_UNITS" Association="RemoteModel.FK_RML_LINEAR_MASS_DENSITY_UNITS"> + <End Role="LINEAR_MASS_DENSITY_UNITS" EntitySet="LINEAR_MASS_DENSITY_UNITS" /> + <End Role="RML" EntitySet="RMLs" /> + </AssociationSet> + <AssociationSet Name="FK_LIQUIDS_LIQUID_TYPES" Association="RemoteModel.FK_LIQUIDS_LIQUID_TYPES"> + <End Role="LIQUID_TYPES" EntitySet="LIQUID_TYPES" /> + <End Role="LIQUID" EntitySet="LIQUIDS" /> + </AssociationSet> + <AssociationSet Name="FK_LIQUID_RML_LIQUIDS" Association="RemoteModel.FK_LIQUID_RML_LIQUIDS"> + <End Role="LIQUID" EntitySet="LIQUIDS" /> + <End Role="LIQUIDS_RML" EntitySet="LIQUIDS_RML" /> + </AssociationSet> + <AssociationSet Name="FK_LIQUID_RML_RML" Association="RemoteModel.FK_LIQUID_RML_RML"> + <End Role="RML" EntitySet="RMLs" /> + <End Role="LIQUIDS_RML" EntitySet="LIQUIDS_RML" /> + </AssociationSet> + <AssociationSet Name="FK_MACHINES_MACHINE_VERSIONS" Association="RemoteModel.FK_MACHINES_MACHINE_VERSIONS"> + <End Role="MACHINE_VERSIONS" EntitySet="MACHINE_VERSIONS" /> + <End Role="MACHINE" EntitySet="MACHINES" /> + </AssociationSet> + <AssociationSet Name="FK_MACHINE_EVENTS_MACHINES" Association="RemoteModel.FK_MACHINE_EVENTS_MACHINES"> + <End Role="MACHINE" EntitySet="MACHINES" /> + <End Role="MACHINES_EVENTS" EntitySet="MACHINES_EVENTS" /> + </AssociationSet> + <AssociationSet Name="FK_MACHINES_ORGANIZATIONS" Association="RemoteModel.FK_MACHINES_ORGANIZATIONS"> + <End Role="ORGANIZATION" EntitySet="ORGANIZATIONS" /> + <End Role="MACHINE" EntitySet="MACHINES" /> + </AssociationSet> + <AssociationSet Name="FK_MACHINES_EVENTS_USERS" Association="RemoteModel.FK_MACHINES_EVENTS_USERS"> + <End Role="USER" EntitySet="USERS" /> + <End Role="MACHINES_EVENTS" EntitySet="MACHINES_EVENTS" /> + </AssociationSet> + <AssociationSet Name="FK_RML_MEDIA_COLORS" Association="RemoteModel.FK_RML_MEDIA_COLORS"> + <End Role="MEDIA_COLORS" EntitySet="MEDIA_COLORS" /> + <End Role="RML" EntitySet="RMLs" /> + </AssociationSet> + <AssociationSet Name="FK_RML_MEDIA_CONDITIONS" Association="RemoteModel.FK_RML_MEDIA_CONDITIONS"> + <End Role="MEDIA_CONDITIONS" EntitySet="MEDIA_CONDITIONS" /> + <End Role="RML" EntitySet="RMLs" /> + </AssociationSet> + <AssociationSet Name="FK_RML_MEDIA_MATERIALS" Association="RemoteModel.FK_RML_MEDIA_MATERIALS"> + <End Role="MEDIA_MATERIALS" EntitySet="MEDIA_MATERIALS" /> + <End Role="RML" EntitySet="RMLs" /> + </AssociationSet> + <AssociationSet Name="FK_RML_MEDIA_PURPOSES" Association="RemoteModel.FK_RML_MEDIA_PURPOSES"> + <End Role="MEDIA_PURPOSES" EntitySet="MEDIA_PURPOSES" /> + <End Role="RML" EntitySet="RMLs" /> + </AssociationSet> + <AssociationSet Name="FK_USERS_ORGANIZATIONS" Association="RemoteModel.FK_USERS_ORGANIZATIONS"> + <End Role="ORGANIZATION" EntitySet="ORGANIZATIONS" /> + <End Role="USER" EntitySet="USERS" /> + </AssociationSet> + <AssociationSet Name="FK_ROLES_PERMISSIONS_PERMISSIONS" Association="RemoteModel.FK_ROLES_PERMISSIONS_PERMISSIONS"> + <End Role="PERMISSION" EntitySet="PERMISSIONS" /> + <End Role="ROLES_PERMISSIONS" EntitySet="ROLES_PERMISSIONS" /> + </AssociationSet> + <AssociationSet Name="FK_ROLES_PERMISSIONS_ROLES" Association="RemoteModel.FK_ROLES_PERMISSIONS_ROLES"> + <End Role="ROLE" EntitySet="ROLES" /> + <End Role="ROLES_PERMISSIONS" EntitySet="ROLES_PERMISSIONS" /> + </AssociationSet> + <AssociationSet Name="FK_USERS_ROLES_ROLES" Association="RemoteModel.FK_USERS_ROLES_ROLES"> + <End Role="ROLE" EntitySet="ROLES" /> + <End Role="USERS_ROLES" EntitySet="USERS_ROLES" /> + </AssociationSet> + <AssociationSet Name="FK_USERS_ROLES_USERS" Association="RemoteModel.FK_USERS_ROLES_USERS"> + <End Role="USER" EntitySet="USERS" /> + <End Role="USERS_ROLES" EntitySet="USERS_ROLES" /> + </AssociationSet> + </EntityContainer> <EntityType Name="ACTION"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> <Property Name="CODE" Type="Int32" Nullable="false" /> - <Property Name="NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> - <Property Name="DESCRIPTION" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" /> - <NavigationProperty Name="EVENTS_ACTIONS" Relationship="Self.FK_EVENTS_ACTIONS_ACTIONS" FromRole="ACTIONS" ToRole="EVENTS_ACTIONS" /> + <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" /> + <NavigationProperty Name="EVENTS_ACTIONS" Relationship="RemoteModel.FK_EVENTS_ACTIONS_ACTIONS" FromRole="ACTION" ToRole="EVENTS_ACTIONS" /> </EntityType> <EntityType Name="ADDRESS"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="ADDRESS1" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" /> + <Property Name="ADDRESS1" 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" /> - <NavigationProperty Name="ORGANIZATIONS" Relationship="Self.FK_ORGANIZATIONS_ADDRESSES" FromRole="ADDRESSES" ToRole="ORGANIZATIONS" /> - <NavigationProperty Name="USERS" Relationship="Self.FK_USERS_ADDRESSES" FromRole="ADDRESSES" ToRole="USERS" /> + <NavigationProperty Name="ORGANIZATIONS" Relationship="RemoteModel.FK_ORGANIZATIONS_ADDRESSES" FromRole="ADDRESS" ToRole="ORGANIZATION" /> + <NavigationProperty Name="USERS" Relationship="RemoteModel.FK_USERS_ADDRESSES" FromRole="ADDRESS" ToRole="USER" /> </EntityType> <EntityType Name="APPLICATION_DISPLAY_PANEL_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <NavigationProperty Name="CONFIGURATIONS" Relationship="Self.FK_CONFIGURATIONS_APPLICATION_DISPLAY_PANEL_VERSIONS" FromRole="APPLICATION_DISPLAY_PANEL_VERSIONS" ToRole="CONFIGURATIONS" /> + <NavigationProperty Name="CONFIGURATIONS" Relationship="RemoteModel.FK_CONFIGURATIONS_APPLICATION_DISPLAY_PANEL_VERSIONS" FromRole="APPLICATION_DISPLAY_PANEL_VERSIONS" ToRole="CONFIGURATION" /> </EntityType> <EntityType Name="APPLICATION_FIRMWARE_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <NavigationProperty Name="CONFIGURATIONS" Relationship="Self.FK_CONFIGURATIONS_APPLICATION_FIRMWARE_VERSIONS" FromRole="APPLICATION_FIRMWARE_VERSIONS" ToRole="CONFIGURATIONS" /> + <NavigationProperty Name="CONFIGURATIONS" Relationship="RemoteModel.FK_CONFIGURATIONS_APPLICATION_FIRMWARE_VERSIONS" FromRole="APPLICATION_FIRMWARE_VERSIONS" ToRole="CONFIGURATION" /> </EntityType> <EntityType Name="APPLICATION_OS_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <NavigationProperty Name="CONFIGURATIONS" Relationship="Self.FK_CONFIGURATIONS_APPLICATION_OS_VERSIONS" FromRole="APPLICATION_OS_VERSIONS" ToRole="CONFIGURATIONS" /> + <NavigationProperty Name="CONFIGURATIONS" Relationship="RemoteModel.FK_CONFIGURATIONS_APPLICATION_OS_VERSIONS" FromRole="APPLICATION_OS_VERSIONS" ToRole="CONFIGURATION" /> </EntityType> <EntityType Name="APPLICATION_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <NavigationProperty Name="CONFIGURATIONS" Relationship="Self.FK_CONFIGURATIONS_APPLICATION_VERSIONS" FromRole="APPLICATION_VERSIONS" ToRole="CONFIGURATIONS" /> + <NavigationProperty Name="CONFIGURATIONS" Relationship="RemoteModel.FK_CONFIGURATIONS_APPLICATION_VERSIONS" FromRole="APPLICATION_VERSIONS" ToRole="CONFIGURATION" /> </EntityType> <EntityType Name="CONFIGURATION"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> <Property Name="CREATION_DATE" Type="DateTime" Nullable="false" Precision="3" /> @@ -1157,229 +1345,229 @@ <Property Name="EMBEDDED_FIRMWARE_VERSION_ID" Type="Int32" Nullable="false" /> <Property Name="EMBEDDED_SOFTWARE_VERSION_ID" Type="Int32" Nullable="false" /> <Property Name="HARDWARE_VERSION_ID" Type="Int32" Nullable="false" /> - <NavigationProperty Name="APPLICATION_DISPLAY_PANEL_VERSIONS" Relationship="Self.FK_CONFIGURATIONS_APPLICATION_DISPLAY_PANEL_VERSIONS" FromRole="CONFIGURATIONS" ToRole="APPLICATION_DISPLAY_PANEL_VERSIONS" /> - <NavigationProperty Name="APPLICATION_FIRMWARE_VERSIONS" Relationship="Self.FK_CONFIGURATIONS_APPLICATION_FIRMWARE_VERSIONS" FromRole="CONFIGURATIONS" ToRole="APPLICATION_FIRMWARE_VERSIONS" /> - <NavigationProperty Name="APPLICATION_OS_VERSIONS" Relationship="Self.FK_CONFIGURATIONS_APPLICATION_OS_VERSIONS" FromRole="CONFIGURATIONS" ToRole="APPLICATION_OS_VERSIONS" /> - <NavigationProperty Name="APPLICATION_VERSIONS" Relationship="Self.FK_CONFIGURATIONS_APPLICATION_VERSIONS" FromRole="CONFIGURATIONS" ToRole="APPLICATION_VERSIONS" /> - <NavigationProperty Name="CONFIGURATIONS_DISPENSERS" Relationship="Self.FK_CONFIGURATIONS_DISPENSERS_CONFIGURATIONS" FromRole="CONFIGURATIONS" ToRole="CONFIGURATIONS_DISPENSERS" /> - <NavigationProperty Name="EMBEDDED_FIRMWARE_VERSIONS" Relationship="Self.FK_CONFIGURATIONS_EMBEDDED_FIRMWARE_VERSIONS" FromRole="CONFIGURATIONS" ToRole="EMBEDDED_FIRMWARE_VERSIONS" /> - <NavigationProperty Name="EMBEDDED_SOFTWARE_VERSIONS" Relationship="Self.FK_CONFIGURATIONS_EMBEDDED_SOFTWARE_VERSIONS" FromRole="CONFIGURATIONS" ToRole="EMBEDDED_SOFTWARE_VERSIONS" /> - <NavigationProperty Name="HARDWARE_VERSIONS" Relationship="Self.FK_CONFIGURATIONS_HARDWARE_VERSIONS" FromRole="CONFIGURATIONS" ToRole="HARDWARE_VERSIONS" /> - <NavigationProperty Name="MACHINE" Relationship="Self.FK_CONFIGURATIONS_MACHINES" FromRole="CONFIGURATIONS" ToRole="MACHINES" /> - <NavigationProperty Name="MACHINE_VERSIONS" Relationship="Self.FK_MACHINE_VERSIONS_CONFIGURATIONS" FromRole="CONFIGURATIONS" ToRole="MACHINE_VERSIONS" /> + <NavigationProperty Name="APPLICATION_DISPLAY_PANEL_VERSIONS" Relationship="RemoteModel.FK_CONFIGURATIONS_APPLICATION_DISPLAY_PANEL_VERSIONS" FromRole="CONFIGURATION" ToRole="APPLICATION_DISPLAY_PANEL_VERSIONS" /> + <NavigationProperty Name="APPLICATION_FIRMWARE_VERSIONS" Relationship="RemoteModel.FK_CONFIGURATIONS_APPLICATION_FIRMWARE_VERSIONS" FromRole="CONFIGURATION" ToRole="APPLICATION_FIRMWARE_VERSIONS" /> + <NavigationProperty Name="APPLICATION_OS_VERSIONS" Relationship="RemoteModel.FK_CONFIGURATIONS_APPLICATION_OS_VERSIONS" FromRole="CONFIGURATION" ToRole="APPLICATION_OS_VERSIONS" /> + <NavigationProperty Name="APPLICATION_VERSIONS" Relationship="RemoteModel.FK_CONFIGURATIONS_APPLICATION_VERSIONS" FromRole="CONFIGURATION" ToRole="APPLICATION_VERSIONS" /> + <NavigationProperty Name="CONFIGURATIONS_DISPENSERS" Relationship="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_CONFIGURATIONS" FromRole="CONFIGURATION" ToRole="CONFIGURATIONS_DISPENSERS" /> + <NavigationProperty Name="EMBEDDED_FIRMWARE_VERSIONS" Relationship="RemoteModel.FK_CONFIGURATIONS_EMBEDDED_FIRMWARE_VERSIONS" FromRole="CONFIGURATION" ToRole="EMBEDDED_FIRMWARE_VERSIONS" /> + <NavigationProperty Name="EMBEDDED_SOFTWARE_VERSIONS" Relationship="RemoteModel.FK_CONFIGURATIONS_EMBEDDED_SOFTWARE_VERSIONS" FromRole="CONFIGURATION" ToRole="EMBEDDED_SOFTWARE_VERSIONS" /> + <NavigationProperty Name="HARDWARE_VERSIONS" Relationship="RemoteModel.FK_CONFIGURATIONS_HARDWARE_VERSIONS" FromRole="CONFIGURATION" ToRole="HARDWARE_VERSIONS" /> + <NavigationProperty Name="MACHINE" Relationship="RemoteModel.FK_CONFIGURATIONS_MACHINES" FromRole="CONFIGURATION" ToRole="MACHINE" /> + <NavigationProperty Name="MACHINE_VERSIONS" Relationship="RemoteModel.FK_MACHINE_VERSIONS_CONFIGURATIONS" FromRole="CONFIGURATION" ToRole="MACHINE_VERSIONS" /> </EntityType> <EntityType Name="CONFIGURATIONS_DISPENSERS"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> <Property Name="CONFIGURATION_ID" Type="Int32" Nullable="false" /> <Property Name="DISPENSER_ID" Type="Int32" Nullable="false" /> <Property Name="LIQUID_ID" Type="Int32" Nullable="false" /> - <NavigationProperty Name="CONFIGURATION" Relationship="Self.FK_CONFIGURATIONS_DISPENSERS_CONFIGURATIONS" FromRole="CONFIGURATIONS_DISPENSERS" ToRole="CONFIGURATIONS" /> - <NavigationProperty Name="DISPENSER" Relationship="Self.FK_CONFIGURATIONS_DISPENSERS_DISPENSERS" FromRole="CONFIGURATIONS_DISPENSERS" ToRole="DISPENSERS" /> - <NavigationProperty Name="LIQUID" Relationship="Self.FK_CONFIGURATIONS_DISPENSERS_LIQUIDS" FromRole="CONFIGURATIONS_DISPENSERS" ToRole="LIQUIDS" /> + <NavigationProperty Name="CONFIGURATION" Relationship="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_CONFIGURATIONS" FromRole="CONFIGURATIONS_DISPENSERS" ToRole="CONFIGURATION" /> + <NavigationProperty Name="DISPENSER" Relationship="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_DISPENSERS" FromRole="CONFIGURATIONS_DISPENSERS" ToRole="DISPENSER" /> + <NavigationProperty Name="LIQUID" Relationship="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_LIQUIDS" FromRole="CONFIGURATIONS_DISPENSERS" ToRole="LIQUID" /> </EntityType> <EntityType Name="CONTACT"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="FIRST_NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> - <Property Name="LAST_NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> - <Property Name="FULL_NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> - <Property Name="EMAIL" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> + <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" /> - <NavigationProperty Name="ORGANIZATIONS" Relationship="Self.FK_ORGANIZATIONS_CONTACTS" FromRole="CONTACTS" ToRole="ORGANIZATIONS" /> - <NavigationProperty Name="USERS" Relationship="Self.FK_USERS_CONTACTS" FromRole="CONTACTS" ToRole="USERS" /> + <NavigationProperty Name="ORGANIZATIONS" Relationship="RemoteModel.FK_ORGANIZATIONS_CONTACTS" FromRole="CONTACT" ToRole="ORGANIZATION" /> + <NavigationProperty Name="USERS" Relationship="RemoteModel.FK_USERS_CONTACTS" FromRole="CONTACT" ToRole="USER" /> </EntityType> <EntityType Name="DISPENSER"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <NavigationProperty Name="CONFIGURATIONS_DISPENSERS" Relationship="Self.FK_CONFIGURATIONS_DISPENSERS_DISPENSERS" FromRole="DISPENSERS" ToRole="CONFIGURATIONS_DISPENSERS" /> + <NavigationProperty Name="CONFIGURATIONS_DISPENSERS" Relationship="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_DISPENSERS" FromRole="DISPENSER" ToRole="CONFIGURATIONS_DISPENSERS" /> </EntityType> <EntityType Name="EMBEDDED_FIRMWARE_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <NavigationProperty Name="CONFIGURATIONS" Relationship="Self.FK_CONFIGURATIONS_EMBEDDED_FIRMWARE_VERSIONS" FromRole="EMBEDDED_FIRMWARE_VERSIONS" ToRole="CONFIGURATIONS" /> + <NavigationProperty Name="CONFIGURATIONS" Relationship="RemoteModel.FK_CONFIGURATIONS_EMBEDDED_FIRMWARE_VERSIONS" FromRole="EMBEDDED_FIRMWARE_VERSIONS" ToRole="CONFIGURATION" /> </EntityType> <EntityType Name="EMBEDDED_SOFTWARE_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <NavigationProperty Name="CONFIGURATIONS" Relationship="Self.FK_CONFIGURATIONS_EMBEDDED_SOFTWARE_VERSIONS" FromRole="EMBEDDED_SOFTWARE_VERSIONS" ToRole="CONFIGURATIONS" /> + <NavigationProperty Name="CONFIGURATIONS" Relationship="RemoteModel.FK_CONFIGURATIONS_EMBEDDED_SOFTWARE_VERSIONS" FromRole="EMBEDDED_SOFTWARE_VERSIONS" ToRole="CONFIGURATION" /> </EntityType> <EntityType Name="EVENT"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> <Property Name="CODE" Type="Int32" Nullable="false" /> - <Property Name="NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> - <Property Name="DESCRIPTION" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" /> - <NavigationProperty Name="EVENTS_ACTIONS" Relationship="Self.FK_EVENTS_ACTIONS_EVENTS" FromRole="EVENTS" ToRole="EVENTS_ACTIONS" /> - <NavigationProperty Name="MACHINES_EVENTS" Relationship="Self.FK_MACHINES_EVENTS_EVENTS" FromRole="EVENTS" ToRole="MACHINES_EVENTS" /> + <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" /> + <NavigationProperty Name="EVENTS_ACTIONS" Relationship="RemoteModel.FK_EVENTS_ACTIONS_EVENTS" FromRole="EVENT" ToRole="EVENTS_ACTIONS" /> + <NavigationProperty Name="MACHINES_EVENTS" Relationship="RemoteModel.FK_MACHINES_EVENTS_EVENTS" FromRole="EVENT" ToRole="MACHINES_EVENTS" /> </EntityType> <EntityType Name="EVENTS_ACTIONS"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> <Property Name="EVENT_ID" Type="Int32" Nullable="false" /> <Property Name="ACTION_ID" Type="Int32" Nullable="false" /> - <NavigationProperty Name="ACTION" Relationship="Self.FK_EVENTS_ACTIONS_ACTIONS" FromRole="EVENTS_ACTIONS" ToRole="ACTIONS" /> - <NavigationProperty Name="EVENT" Relationship="Self.FK_EVENTS_ACTIONS_EVENTS" FromRole="EVENTS_ACTIONS" ToRole="EVENTS" /> + <NavigationProperty Name="ACTION" Relationship="RemoteModel.FK_EVENTS_ACTIONS_ACTIONS" FromRole="EVENTS_ACTIONS" ToRole="ACTION" /> + <NavigationProperty Name="EVENT" Relationship="RemoteModel.FK_EVENTS_ACTIONS_EVENTS" FromRole="EVENTS_ACTIONS" ToRole="EVENT" /> </EntityType> <EntityType Name="FIBER_SHAPES"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="CODE" Type="Int32" Nullable="false" /> - <NavigationProperty Name="RMLs" Relationship="Self.FK_RML_FIBER_SHAPES" FromRole="FIBER_SHAPES" ToRole="RML" /> + <NavigationProperty Name="RMLs" Relationship="RemoteModel.FK_RML_FIBER_SHAPES" FromRole="FIBER_SHAPES" ToRole="RML" /> </EntityType> <EntityType Name="FIBER_SYNTHESIS"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="CODE" Type="Int32" Nullable="false" /> - <NavigationProperty Name="RMLs" Relationship="Self.FK_RML_FIBER_SYNTHESIS" FromRole="FIBER_SYNTHESIS" ToRole="RML" /> + <NavigationProperty Name="RMLs" Relationship="RemoteModel.FK_RML_FIBER_SYNTHESIS" FromRole="FIBER_SYNTHESIS" ToRole="RML" /> </EntityType> <EntityType Name="HARDWARE_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <NavigationProperty Name="CONFIGURATIONS" Relationship="Self.FK_CONFIGURATIONS_HARDWARE_VERSIONS" FromRole="HARDWARE_VERSIONS" ToRole="CONFIGURATIONS" /> + <NavigationProperty Name="CONFIGURATIONS" Relationship="RemoteModel.FK_CONFIGURATIONS_HARDWARE_VERSIONS" FromRole="HARDWARE_VERSIONS" ToRole="CONFIGURATION" /> </EntityType> <EntityType Name="LINEAR_MASS_DENSITY_UNITS"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="CODE" Type="Int32" Nullable="false" /> - <NavigationProperty Name="RMLs" Relationship="Self.FK_RML_LINEAR_MASS_DENSITY_UNITS" FromRole="LINEAR_MASS_DENSITY_UNITS" ToRole="RML" /> + <NavigationProperty Name="RMLs" Relationship="RemoteModel.FK_RML_LINEAR_MASS_DENSITY_UNITS" FromRole="LINEAR_MASS_DENSITY_UNITS" ToRole="RML" /> </EntityType> <EntityType Name="LIQUID_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="DESCRIPTION" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> <Property Name="CODE" Type="Int32" Nullable="false" /> - <NavigationProperty Name="LIQUIDS" Relationship="Self.FK_LIQUIDS_LIQUID_TYPES" FromRole="LIQUID_TYPES" ToRole="LIQUIDS" /> + <NavigationProperty Name="LIQUIDS" Relationship="RemoteModel.FK_LIQUIDS_LIQUID_TYPES" FromRole="LIQUID_TYPES" ToRole="LIQUID" /> </EntityType> <EntityType Name="LIQUID"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="VERSION" Type="Double" Nullable="false" /> <Property Name="LIQUID_TYPE_ID" Type="Int32" Nullable="false" /> - <NavigationProperty Name="CONFIGURATIONS_DISPENSERS" Relationship="Self.FK_CONFIGURATIONS_DISPENSERS_LIQUIDS" FromRole="LIQUIDS" ToRole="CONFIGURATIONS_DISPENSERS" /> - <NavigationProperty Name="LIQUID_TYPES" Relationship="Self.FK_LIQUIDS_LIQUID_TYPES" FromRole="LIQUIDS" ToRole="LIQUID_TYPES" /> - <NavigationProperty Name="LIQUIDS_RML" Relationship="Self.FK_LIQUID_RML_LIQUIDS" FromRole="LIQUIDS" ToRole="LIQUIDS_RML" /> + <NavigationProperty Name="CONFIGURATIONS_DISPENSERS" Relationship="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_LIQUIDS" FromRole="LIQUID" ToRole="CONFIGURATIONS_DISPENSERS" /> + <NavigationProperty Name="LIQUID_TYPES" Relationship="RemoteModel.FK_LIQUIDS_LIQUID_TYPES" FromRole="LIQUID" ToRole="LIQUID_TYPES" /> + <NavigationProperty Name="LIQUIDS_RML" Relationship="RemoteModel.FK_LIQUID_RML_LIQUIDS" FromRole="LIQUID" ToRole="LIQUIDS_RML" /> </EntityType> <EntityType Name="LIQUIDS_RML"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> <Property Name="LIQUID_ID" Type="Int32" Nullable="false" /> <Property Name="RML_ID" Type="Int32" Nullable="false" /> - <NavigationProperty Name="LIQUID" Relationship="Self.FK_LIQUID_RML_LIQUIDS" FromRole="LIQUIDS_RML" ToRole="LIQUIDS" /> - <NavigationProperty Name="RML" Relationship="Self.FK_LIQUID_RML_RML" FromRole="LIQUIDS_RML" ToRole="RML" /> + <NavigationProperty Name="LIQUID" Relationship="RemoteModel.FK_LIQUID_RML_LIQUIDS" FromRole="LIQUIDS_RML" ToRole="LIQUID" /> + <NavigationProperty Name="RML" Relationship="RemoteModel.FK_LIQUID_RML_RML" FromRole="LIQUIDS_RML" ToRole="RML" /> </EntityType> <EntityType Name="MACHINE_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> <Property Name="VERSION" Type="Double" Nullable="false" /> <Property Name="DEFAULT_CONFIGURATION_ID" Type="Int32" Nullable="false" /> - <NavigationProperty Name="CONFIGURATION" Relationship="Self.FK_MACHINE_VERSIONS_CONFIGURATIONS" FromRole="MACHINE_VERSIONS" ToRole="CONFIGURATIONS" /> - <NavigationProperty Name="MACHINES" Relationship="Self.FK_MACHINES_MACHINE_VERSIONS" FromRole="MACHINE_VERSIONS" ToRole="MACHINES" /> + <NavigationProperty Name="CONFIGURATION" Relationship="RemoteModel.FK_MACHINE_VERSIONS_CONFIGURATIONS" FromRole="MACHINE_VERSIONS" ToRole="CONFIGURATION" /> + <NavigationProperty Name="MACHINES" Relationship="RemoteModel.FK_MACHINES_MACHINE_VERSIONS" FromRole="MACHINE_VERSIONS" ToRole="MACHINE" /> </EntityType> <EntityType Name="MACHINE"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="SERIAL_NUMBER" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" /> + <Property Name="SERIAL_NUMBER" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" /> <Property Name="PRODUCTION_DATE" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="ORGANIZATION_ID" Type="Int32" Nullable="false" /> <Property Name="MACHINE_VERSION_ID" Type="Int32" Nullable="false" /> - <NavigationProperty Name="CONFIGURATIONS" Relationship="Self.FK_CONFIGURATIONS_MACHINES" FromRole="MACHINES" ToRole="CONFIGURATIONS" /> - <NavigationProperty Name="MACHINE_VERSIONS" Relationship="Self.FK_MACHINES_MACHINE_VERSIONS" FromRole="MACHINES" ToRole="MACHINE_VERSIONS" /> - <NavigationProperty Name="MACHINES_EVENTS" Relationship="Self.FK_MACHINE_EVENTS_MACHINES" FromRole="MACHINES" ToRole="MACHINES_EVENTS" /> - <NavigationProperty Name="ORGANIZATION" Relationship="Self.FK_MACHINES_ORGANIZATIONS" FromRole="MACHINES" ToRole="ORGANIZATIONS" /> + <NavigationProperty Name="CONFIGURATIONS" Relationship="RemoteModel.FK_CONFIGURATIONS_MACHINES" FromRole="MACHINE" ToRole="CONFIGURATION" /> + <NavigationProperty Name="MACHINE_VERSIONS" Relationship="RemoteModel.FK_MACHINES_MACHINE_VERSIONS" FromRole="MACHINE" ToRole="MACHINE_VERSIONS" /> + <NavigationProperty Name="MACHINES_EVENTS" Relationship="RemoteModel.FK_MACHINE_EVENTS_MACHINES" FromRole="MACHINE" ToRole="MACHINES_EVENTS" /> + <NavigationProperty Name="ORGANIZATION" Relationship="RemoteModel.FK_MACHINES_ORGANIZATIONS" FromRole="MACHINE" ToRole="ORGANIZATION" /> </EntityType> <EntityType Name="MACHINES_EVENTS"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> <Property Name="MACHINE_ID" Type="Int32" Nullable="false" /> @@ -1387,94 +1575,94 @@ <Property Name="USER_ID" Type="Int32" Nullable="false" /> <Property Name="DATE_TIME" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DESCRIPTION" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> - <NavigationProperty Name="EVENT" Relationship="Self.FK_MACHINES_EVENTS_EVENTS" FromRole="MACHINES_EVENTS" ToRole="EVENTS" /> - <NavigationProperty Name="MACHINE" Relationship="Self.FK_MACHINE_EVENTS_MACHINES" FromRole="MACHINES_EVENTS" ToRole="MACHINES" /> - <NavigationProperty Name="USER" Relationship="Self.FK_MACHINES_EVENTS_USERS" FromRole="MACHINES_EVENTS" ToRole="USERS" /> + <NavigationProperty Name="EVENT" Relationship="RemoteModel.FK_MACHINES_EVENTS_EVENTS" FromRole="MACHINES_EVENTS" ToRole="EVENT" /> + <NavigationProperty Name="MACHINE" Relationship="RemoteModel.FK_MACHINE_EVENTS_MACHINES" FromRole="MACHINES_EVENTS" ToRole="MACHINE" /> + <NavigationProperty Name="USER" Relationship="RemoteModel.FK_MACHINES_EVENTS_USERS" FromRole="MACHINES_EVENTS" ToRole="USER" /> </EntityType> <EntityType Name="MEDIA_COLORS"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> <Property Name="COLOR" Type="Int32" Nullable="false" /> - <NavigationProperty Name="RMLs" Relationship="Self.FK_RML_MEDIA_COLORS" FromRole="MEDIA_COLORS" ToRole="RML" /> + <NavigationProperty Name="RMLs" Relationship="RemoteModel.FK_RML_MEDIA_COLORS" FromRole="MEDIA_COLORS" ToRole="RML" /> </EntityType> <EntityType Name="MEDIA_CONDITIONS"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="CODE" Type="Int32" Nullable="false" /> - <NavigationProperty Name="RMLs" Relationship="Self.FK_RML_MEDIA_CONDITIONS" FromRole="MEDIA_CONDITIONS" ToRole="RML" /> + <NavigationProperty Name="RMLs" Relationship="RemoteModel.FK_RML_MEDIA_CONDITIONS" FromRole="MEDIA_CONDITIONS" ToRole="RML" /> </EntityType> <EntityType Name="MEDIA_MATERIALS"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="CODE" Type="Int32" Nullable="false" /> - <NavigationProperty Name="RMLs" Relationship="Self.FK_RML_MEDIA_MATERIALS" FromRole="MEDIA_MATERIALS" ToRole="RML" /> + <NavigationProperty Name="RMLs" Relationship="RemoteModel.FK_RML_MEDIA_MATERIALS" FromRole="MEDIA_MATERIALS" ToRole="RML" /> </EntityType> <EntityType Name="MEDIA_PURPOSES"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="CODE" Type="Int32" Nullable="false" /> - <NavigationProperty Name="RMLs" Relationship="Self.FK_RML_MEDIA_PURPOSES" FromRole="MEDIA_PURPOSES" ToRole="RML" /> + <NavigationProperty Name="RMLs" Relationship="RemoteModel.FK_RML_MEDIA_PURPOSES" FromRole="MEDIA_PURPOSES" ToRole="RML" /> </EntityType> <EntityType Name="ORGANIZATION"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="CONTACT_ID" Type="Int32" Nullable="false" /> <Property Name="ADDRESS_ID" Type="Int32" Nullable="false" /> - <NavigationProperty Name="ADDRESS" Relationship="Self.FK_ORGANIZATIONS_ADDRESSES" FromRole="ORGANIZATIONS" ToRole="ADDRESSES" /> - <NavigationProperty Name="CONTACT" Relationship="Self.FK_ORGANIZATIONS_CONTACTS" FromRole="ORGANIZATIONS" ToRole="CONTACTS" /> - <NavigationProperty Name="MACHINES" Relationship="Self.FK_MACHINES_ORGANIZATIONS" FromRole="ORGANIZATIONS" ToRole="MACHINES" /> - <NavigationProperty Name="USERS" Relationship="Self.FK_USERS_ORGANIZATIONS" FromRole="ORGANIZATIONS" ToRole="USERS" /> + <NavigationProperty Name="ADDRESS" Relationship="RemoteModel.FK_ORGANIZATIONS_ADDRESSES" FromRole="ORGANIZATION" ToRole="ADDRESS" /> + <NavigationProperty Name="CONTACT" Relationship="RemoteModel.FK_ORGANIZATIONS_CONTACTS" FromRole="ORGANIZATION" ToRole="CONTACT" /> + <NavigationProperty Name="MACHINES" Relationship="RemoteModel.FK_MACHINES_ORGANIZATIONS" FromRole="ORGANIZATION" ToRole="MACHINE" /> + <NavigationProperty Name="USERS" Relationship="RemoteModel.FK_USERS_ORGANIZATIONS" FromRole="ORGANIZATION" ToRole="USER" /> </EntityType> <EntityType Name="PERMISSION"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="NAME" Type="String" MaxLength="30" FixedLength="false" Unicode="true" Nullable="false" /> - <Property Name="DESCRIPTION" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" /> - <NavigationProperty Name="ROLES_PERMISSIONS" Relationship="Self.FK_ROLES_PERMISSIONS_PERMISSIONS" FromRole="PERMISSIONS" ToRole="ROLES_PERMISSIONS" /> + <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" /> + <NavigationProperty Name="ROLES_PERMISSIONS" Relationship="RemoteModel.FK_ROLES_PERMISSIONS_PERMISSIONS" FromRole="PERMISSION" ToRole="ROLES_PERMISSIONS" /> </EntityType> <EntityType Name="RML"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="MANUFACTURER" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> + <Property Name="MANUFACTURER" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="MATERIAL_ID" Type="Int32" Nullable="false" /> <Property Name="COLOR_ID" Type="Int32" Nullable="false" /> <Property Name="PURPOSE_ID" Type="Int32" Nullable="false" /> @@ -1492,78 +1680,78 @@ <Property Name="TENSILE_STRENGTH" Type="Double" Nullable="false" /> <Property Name="ELONGATION_AT_BREAK_PERCENTAGE" Type="Double" Nullable="false" /> <Property Name="ESTIMATED_THREAD_DIAMETER" Type="Double" Nullable="false" /> - <NavigationProperty Name="FIBER_SHAPES" Relationship="Self.FK_RML_FIBER_SHAPES" FromRole="RML" ToRole="FIBER_SHAPES" /> - <NavigationProperty Name="FIBER_SYNTHESIS" Relationship="Self.FK_RML_FIBER_SYNTHESIS" FromRole="RML" ToRole="FIBER_SYNTHESIS" /> - <NavigationProperty Name="LINEAR_MASS_DENSITY_UNITS" Relationship="Self.FK_RML_LINEAR_MASS_DENSITY_UNITS" FromRole="RML" ToRole="LINEAR_MASS_DENSITY_UNITS" /> - <NavigationProperty Name="LIQUIDS_RML" Relationship="Self.FK_LIQUID_RML_RML" FromRole="RML" ToRole="LIQUIDS_RML" /> - <NavigationProperty Name="MEDIA_COLORS" Relationship="Self.FK_RML_MEDIA_COLORS" FromRole="RML" ToRole="MEDIA_COLORS" /> - <NavigationProperty Name="MEDIA_CONDITIONS" Relationship="Self.FK_RML_MEDIA_CONDITIONS" FromRole="RML" ToRole="MEDIA_CONDITIONS" /> - <NavigationProperty Name="MEDIA_MATERIALS" Relationship="Self.FK_RML_MEDIA_MATERIALS" FromRole="RML" ToRole="MEDIA_MATERIALS" /> - <NavigationProperty Name="MEDIA_PURPOSES" Relationship="Self.FK_RML_MEDIA_PURPOSES" FromRole="RML" ToRole="MEDIA_PURPOSES" /> + <NavigationProperty Name="FIBER_SHAPES" Relationship="RemoteModel.FK_RML_FIBER_SHAPES" FromRole="RML" ToRole="FIBER_SHAPES" /> + <NavigationProperty Name="FIBER_SYNTHESIS" Relationship="RemoteModel.FK_RML_FIBER_SYNTHESIS" FromRole="RML" ToRole="FIBER_SYNTHESIS" /> + <NavigationProperty Name="LINEAR_MASS_DENSITY_UNITS" Relationship="RemoteModel.FK_RML_LINEAR_MASS_DENSITY_UNITS" FromRole="RML" ToRole="LINEAR_MASS_DENSITY_UNITS" /> + <NavigationProperty Name="LIQUIDS_RML" Relationship="RemoteModel.FK_LIQUID_RML_RML" FromRole="RML" ToRole="LIQUIDS_RML" /> + <NavigationProperty Name="MEDIA_COLORS" Relationship="RemoteModel.FK_RML_MEDIA_COLORS" FromRole="RML" ToRole="MEDIA_COLORS" /> + <NavigationProperty Name="MEDIA_CONDITIONS" Relationship="RemoteModel.FK_RML_MEDIA_CONDITIONS" FromRole="RML" ToRole="MEDIA_CONDITIONS" /> + <NavigationProperty Name="MEDIA_MATERIALS" Relationship="RemoteModel.FK_RML_MEDIA_MATERIALS" FromRole="RML" ToRole="MEDIA_MATERIALS" /> + <NavigationProperty Name="MEDIA_PURPOSES" Relationship="RemoteModel.FK_RML_MEDIA_PURPOSES" FromRole="RML" ToRole="MEDIA_PURPOSES" /> </EntityType> <EntityType Name="ROLE"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="NAME" Type="String" MaxLength="30" FixedLength="false" Unicode="true" Nullable="false" /> - <Property Name="DESCRIPTION" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" /> - <NavigationProperty Name="ROLES_PERMISSIONS" Relationship="Self.FK_ROLES_PERMISSIONS_ROLES" FromRole="ROLES" ToRole="ROLES_PERMISSIONS" /> - <NavigationProperty Name="USERS_ROLES" Relationship="Self.FK_USERS_ROLES_ROLES" FromRole="ROLES" ToRole="USERS_ROLES" /> + <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" /> + <NavigationProperty Name="ROLES_PERMISSIONS" Relationship="RemoteModel.FK_ROLES_PERMISSIONS_ROLES" FromRole="ROLE" ToRole="ROLES_PERMISSIONS" /> + <NavigationProperty Name="USERS_ROLES" Relationship="RemoteModel.FK_USERS_ROLES_ROLES" FromRole="ROLE" ToRole="USERS_ROLES" /> </EntityType> <EntityType Name="ROLES_PERMISSIONS"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> <Property Name="ROLE_ID" Type="Int32" Nullable="false" /> <Property Name="PERMISSION_ID" Type="Int32" Nullable="false" /> - <NavigationProperty Name="PERMISSION" Relationship="Self.FK_ROLES_PERMISSIONS_PERMISSIONS" FromRole="ROLES_PERMISSIONS" ToRole="PERMISSIONS" /> - <NavigationProperty Name="ROLE" Relationship="Self.FK_ROLES_PERMISSIONS_ROLES" FromRole="ROLES_PERMISSIONS" ToRole="ROLES" /> + <NavigationProperty Name="PERMISSION" Relationship="RemoteModel.FK_ROLES_PERMISSIONS_PERMISSIONS" FromRole="ROLES_PERMISSIONS" ToRole="PERMISSION" /> + <NavigationProperty Name="ROLE" Relationship="RemoteModel.FK_ROLES_PERMISSIONS_ROLES" FromRole="ROLES_PERMISSIONS" ToRole="ROLE" /> </EntityType> <EntityType Name="USER"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="EMAIL" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" /> - <Property Name="PASSWORD" Type="String" MaxLength="200" FixedLength="false" Unicode="true" Nullable="false" /> + <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_ID" Type="Int32" Nullable="false" /> <Property Name="CONTACT_ID" Type="Int32" Nullable="false" /> <Property Name="ADDRESS_ID" Type="Int32" Nullable="false" /> - <NavigationProperty Name="ADDRESS" Relationship="Self.FK_USERS_ADDRESSES" FromRole="USERS" ToRole="ADDRESSES" /> - <NavigationProperty Name="CONTACT" Relationship="Self.FK_USERS_CONTACTS" FromRole="USERS" ToRole="CONTACTS" /> - <NavigationProperty Name="MACHINES_EVENTS" Relationship="Self.FK_MACHINES_EVENTS_USERS" FromRole="USERS" ToRole="MACHINES_EVENTS" /> - <NavigationProperty Name="ORGANIZATION" Relationship="Self.FK_USERS_ORGANIZATIONS" FromRole="USERS" ToRole="ORGANIZATIONS" /> - <NavigationProperty Name="USERS_ROLES" Relationship="Self.FK_USERS_ROLES_USERS" FromRole="USERS" ToRole="USERS_ROLES" /> + <NavigationProperty Name="ADDRESS" Relationship="RemoteModel.FK_USERS_ADDRESSES" FromRole="USER" ToRole="ADDRESS" /> + <NavigationProperty Name="CONTACT" Relationship="RemoteModel.FK_USERS_CONTACTS" FromRole="USER" ToRole="CONTACT" /> + <NavigationProperty Name="MACHINES_EVENTS" Relationship="RemoteModel.FK_MACHINES_EVENTS_USERS" FromRole="USER" ToRole="MACHINES_EVENTS" /> + <NavigationProperty Name="ORGANIZATION" Relationship="RemoteModel.FK_USERS_ORGANIZATIONS" FromRole="USER" ToRole="ORGANIZATION" /> + <NavigationProperty Name="USERS_ROLES" Relationship="RemoteModel.FK_USERS_ROLES_USERS" FromRole="USER" ToRole="USERS_ROLES" /> </EntityType> <EntityType Name="USERS_ROLES"> <Key> <PropertyRef Name="ID" /> </Key> <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> - <Property Name="GUID" Type="Guid" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> <Property Name="USER_ID" Type="Int32" Nullable="false" /> <Property Name="ROLE_ID" Type="Int32" Nullable="false" /> - <NavigationProperty Name="ROLE" Relationship="Self.FK_USERS_ROLES_ROLES" FromRole="USERS_ROLES" ToRole="ROLES" /> - <NavigationProperty Name="USER" Relationship="Self.FK_USERS_ROLES_USERS" FromRole="USERS_ROLES" ToRole="USERS" /> + <NavigationProperty Name="ROLE" Relationship="RemoteModel.FK_USERS_ROLES_ROLES" FromRole="USERS_ROLES" ToRole="ROLE" /> + <NavigationProperty Name="USER" Relationship="RemoteModel.FK_USERS_ROLES_USERS" FromRole="USERS_ROLES" ToRole="USER" /> </EntityType> <Association Name="FK_EVENTS_ACTIONS_ACTIONS"> - <End Role="ACTIONS" Type="Self.ACTION" Multiplicity="1" /> - <End Role="EVENTS_ACTIONS" Type="Self.EVENTS_ACTIONS" Multiplicity="*" /> + <End Type="RemoteModel.ACTION" Role="ACTION" Multiplicity="1" /> + <End Type="RemoteModel.EVENTS_ACTIONS" Role="EVENTS_ACTIONS" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="ACTIONS"> + <Principal Role="ACTION"> <PropertyRef Name="ID" /> </Principal> <Dependent Role="EVENTS_ACTIONS"> @@ -1572,82 +1760,82 @@ </ReferentialConstraint> </Association> <Association Name="FK_ORGANIZATIONS_ADDRESSES"> - <End Role="ADDRESSES" Type="Self.ADDRESS" Multiplicity="1" /> - <End Role="ORGANIZATIONS" Type="Self.ORGANIZATION" Multiplicity="*" /> + <End Type="RemoteModel.ADDRESS" Role="ADDRESS" Multiplicity="1" /> + <End Type="RemoteModel.ORGANIZATION" Role="ORGANIZATION" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="ADDRESSES"> + <Principal Role="ADDRESS"> <PropertyRef Name="ID" /> </Principal> - <Dependent Role="ORGANIZATIONS"> + <Dependent Role="ORGANIZATION"> <PropertyRef Name="ADDRESS_ID" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_USERS_ADDRESSES"> - <End Role="ADDRESSES" Type="Self.ADDRESS" Multiplicity="1" /> - <End Role="USERS" Type="Self.USER" Multiplicity="*" /> + <End Type="RemoteModel.ADDRESS" Role="ADDRESS" Multiplicity="1" /> + <End Type="RemoteModel.USER" Role="USER" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="ADDRESSES"> + <Principal Role="ADDRESS"> <PropertyRef Name="ID" /> </Principal> - <Dependent Role="USERS"> + <Dependent Role="USER"> <PropertyRef Name="ADDRESS_ID" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_CONFIGURATIONS_APPLICATION_DISPLAY_PANEL_VERSIONS"> - <End Role="APPLICATION_DISPLAY_PANEL_VERSIONS" Type="Self.APPLICATION_DISPLAY_PANEL_VERSIONS" Multiplicity="1" /> - <End Role="CONFIGURATIONS" Type="Self.CONFIGURATION" Multiplicity="*" /> + <End Type="RemoteModel.APPLICATION_DISPLAY_PANEL_VERSIONS" Role="APPLICATION_DISPLAY_PANEL_VERSIONS" Multiplicity="1" /> + <End Type="RemoteModel.CONFIGURATION" Role="CONFIGURATION" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="APPLICATION_DISPLAY_PANEL_VERSIONS"> <PropertyRef Name="ID" /> </Principal> - <Dependent Role="CONFIGURATIONS"> + <Dependent Role="CONFIGURATION"> <PropertyRef Name="APPLICATION_DISPLAY_PANEL_VERSION_ID" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_CONFIGURATIONS_APPLICATION_FIRMWARE_VERSIONS"> - <End Role="APPLICATION_FIRMWARE_VERSIONS" Type="Self.APPLICATION_FIRMWARE_VERSIONS" Multiplicity="1" /> - <End Role="CONFIGURATIONS" Type="Self.CONFIGURATION" Multiplicity="*" /> + <End Type="RemoteModel.APPLICATION_FIRMWARE_VERSIONS" Role="APPLICATION_FIRMWARE_VERSIONS" Multiplicity="1" /> + <End Type="RemoteModel.CONFIGURATION" Role="CONFIGURATION" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="APPLICATION_FIRMWARE_VERSIONS"> <PropertyRef Name="ID" /> </Principal> - <Dependent Role="CONFIGURATIONS"> + <Dependent Role="CONFIGURATION"> <PropertyRef Name="APPLICATION_FIRMWARE_VERSION_ID" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_CONFIGURATIONS_APPLICATION_OS_VERSIONS"> - <End Role="APPLICATION_OS_VERSIONS" Type="Self.APPLICATION_OS_VERSIONS" Multiplicity="1" /> - <End Role="CONFIGURATIONS" Type="Self.CONFIGURATION" Multiplicity="*" /> + <End Type="RemoteModel.APPLICATION_OS_VERSIONS" Role="APPLICATION_OS_VERSIONS" Multiplicity="1" /> + <End Type="RemoteModel.CONFIGURATION" Role="CONFIGURATION" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="APPLICATION_OS_VERSIONS"> <PropertyRef Name="ID" /> </Principal> - <Dependent Role="CONFIGURATIONS"> + <Dependent Role="CONFIGURATION"> <PropertyRef Name="APPLICATION_OS_VERSION_ID" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_CONFIGURATIONS_APPLICATION_VERSIONS"> - <End Role="APPLICATION_VERSIONS" Type="Self.APPLICATION_VERSIONS" Multiplicity="1" /> - <End Role="CONFIGURATIONS" Type="Self.CONFIGURATION" Multiplicity="*" /> + <End Type="RemoteModel.APPLICATION_VERSIONS" Role="APPLICATION_VERSIONS" Multiplicity="1" /> + <End Type="RemoteModel.CONFIGURATION" Role="CONFIGURATION" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="APPLICATION_VERSIONS"> <PropertyRef Name="ID" /> </Principal> - <Dependent Role="CONFIGURATIONS"> + <Dependent Role="CONFIGURATION"> <PropertyRef Name="APPLICATION_VERSION_ID" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_CONFIGURATIONS_DISPENSERS_CONFIGURATIONS"> - <End Role="CONFIGURATIONS" Type="Self.CONFIGURATION" Multiplicity="1" /> - <End Role="CONFIGURATIONS_DISPENSERS" Type="Self.CONFIGURATIONS_DISPENSERS" Multiplicity="*" /> + <End Type="RemoteModel.CONFIGURATION" Role="CONFIGURATION" Multiplicity="1" /> + <End Type="RemoteModel.CONFIGURATIONS_DISPENSERS" Role="CONFIGURATIONS_DISPENSERS" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="CONFIGURATIONS"> + <Principal Role="CONFIGURATION"> <PropertyRef Name="ID" /> </Principal> <Dependent Role="CONFIGURATIONS_DISPENSERS"> @@ -1656,58 +1844,58 @@ </ReferentialConstraint> </Association> <Association Name="FK_CONFIGURATIONS_EMBEDDED_FIRMWARE_VERSIONS"> - <End Role="EMBEDDED_FIRMWARE_VERSIONS" Type="Self.EMBEDDED_FIRMWARE_VERSIONS" Multiplicity="1" /> - <End Role="CONFIGURATIONS" Type="Self.CONFIGURATION" Multiplicity="*" /> + <End Type="RemoteModel.EMBEDDED_FIRMWARE_VERSIONS" Role="EMBEDDED_FIRMWARE_VERSIONS" Multiplicity="1" /> + <End Type="RemoteModel.CONFIGURATION" Role="CONFIGURATION" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="EMBEDDED_FIRMWARE_VERSIONS"> <PropertyRef Name="ID" /> </Principal> - <Dependent Role="CONFIGURATIONS"> + <Dependent Role="CONFIGURATION"> <PropertyRef Name="EMBEDDED_FIRMWARE_VERSION_ID" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_CONFIGURATIONS_EMBEDDED_SOFTWARE_VERSIONS"> - <End Role="EMBEDDED_SOFTWARE_VERSIONS" Type="Self.EMBEDDED_SOFTWARE_VERSIONS" Multiplicity="1" /> - <End Role="CONFIGURATIONS" Type="Self.CONFIGURATION" Multiplicity="*" /> + <End Type="RemoteModel.EMBEDDED_SOFTWARE_VERSIONS" Role="EMBEDDED_SOFTWARE_VERSIONS" Multiplicity="1" /> + <End Type="RemoteModel.CONFIGURATION" Role="CONFIGURATION" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="EMBEDDED_SOFTWARE_VERSIONS"> <PropertyRef Name="ID" /> </Principal> - <Dependent Role="CONFIGURATIONS"> + <Dependent Role="CONFIGURATION"> <PropertyRef Name="EMBEDDED_SOFTWARE_VERSION_ID" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_CONFIGURATIONS_HARDWARE_VERSIONS"> - <End Role="HARDWARE_VERSIONS" Type="Self.HARDWARE_VERSIONS" Multiplicity="1" /> - <End Role="CONFIGURATIONS" Type="Self.CONFIGURATION" Multiplicity="*" /> + <End Type="RemoteModel.HARDWARE_VERSIONS" Role="HARDWARE_VERSIONS" Multiplicity="1" /> + <End Type="RemoteModel.CONFIGURATION" Role="CONFIGURATION" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="HARDWARE_VERSIONS"> <PropertyRef Name="ID" /> </Principal> - <Dependent Role="CONFIGURATIONS"> + <Dependent Role="CONFIGURATION"> <PropertyRef Name="HARDWARE_VERSION_ID" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_CONFIGURATIONS_MACHINES"> - <End Role="MACHINES" Type="Self.MACHINE" Multiplicity="1" /> - <End Role="CONFIGURATIONS" Type="Self.CONFIGURATION" Multiplicity="*" /> + <End Type="RemoteModel.MACHINE" Role="MACHINE" Multiplicity="1" /> + <End Type="RemoteModel.CONFIGURATION" Role="CONFIGURATION" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="MACHINES"> + <Principal Role="MACHINE"> <PropertyRef Name="ID" /> </Principal> - <Dependent Role="CONFIGURATIONS"> + <Dependent Role="CONFIGURATION"> <PropertyRef Name="MACHINE_ID" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_MACHINE_VERSIONS_CONFIGURATIONS"> - <End Role="CONFIGURATIONS" Type="Self.CONFIGURATION" Multiplicity="1" /> - <End Role="MACHINE_VERSIONS" Type="Self.MACHINE_VERSIONS" Multiplicity="*" /> + <End Type="RemoteModel.CONFIGURATION" Role="CONFIGURATION" Multiplicity="1" /> + <End Type="RemoteModel.MACHINE_VERSIONS" Role="MACHINE_VERSIONS" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="CONFIGURATIONS"> + <Principal Role="CONFIGURATION"> <PropertyRef Name="ID" /> </Principal> <Dependent Role="MACHINE_VERSIONS"> @@ -1716,10 +1904,10 @@ </ReferentialConstraint> </Association> <Association Name="FK_CONFIGURATIONS_DISPENSERS_DISPENSERS"> - <End Role="DISPENSERS" Type="Self.DISPENSER" Multiplicity="1" /> - <End Role="CONFIGURATIONS_DISPENSERS" Type="Self.CONFIGURATIONS_DISPENSERS" Multiplicity="*" /> + <End Type="RemoteModel.DISPENSER" Role="DISPENSER" Multiplicity="1" /> + <End Type="RemoteModel.CONFIGURATIONS_DISPENSERS" Role="CONFIGURATIONS_DISPENSERS" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="DISPENSERS"> + <Principal Role="DISPENSER"> <PropertyRef Name="ID" /> </Principal> <Dependent Role="CONFIGURATIONS_DISPENSERS"> @@ -1728,10 +1916,10 @@ </ReferentialConstraint> </Association> <Association Name="FK_CONFIGURATIONS_DISPENSERS_LIQUIDS"> - <End Role="LIQUIDS" Type="Self.LIQUID" Multiplicity="1" /> - <End Role="CONFIGURATIONS_DISPENSERS" Type="Self.CONFIGURATIONS_DISPENSERS" Multiplicity="*" /> + <End Type="RemoteModel.LIQUID" Role="LIQUID" Multiplicity="1" /> + <End Type="RemoteModel.CONFIGURATIONS_DISPENSERS" Role="CONFIGURATIONS_DISPENSERS" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="LIQUIDS"> + <Principal Role="LIQUID"> <PropertyRef Name="ID" /> </Principal> <Dependent Role="CONFIGURATIONS_DISPENSERS"> @@ -1740,34 +1928,34 @@ </ReferentialConstraint> </Association> <Association Name="FK_ORGANIZATIONS_CONTACTS"> - <End Role="CONTACTS" Type="Self.CONTACT" Multiplicity="1" /> - <End Role="ORGANIZATIONS" Type="Self.ORGANIZATION" Multiplicity="*" /> + <End Type="RemoteModel.CONTACT" Role="CONTACT" Multiplicity="1" /> + <End Type="RemoteModel.ORGANIZATION" Role="ORGANIZATION" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="CONTACTS"> + <Principal Role="CONTACT"> <PropertyRef Name="ID" /> </Principal> - <Dependent Role="ORGANIZATIONS"> + <Dependent Role="ORGANIZATION"> <PropertyRef Name="CONTACT_ID" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_USERS_CONTACTS"> - <End Role="CONTACTS" Type="Self.CONTACT" Multiplicity="1" /> - <End Role="USERS" Type="Self.USER" Multiplicity="*" /> + <End Type="RemoteModel.CONTACT" Role="CONTACT" Multiplicity="1" /> + <End Type="RemoteModel.USER" Role="USER" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="CONTACTS"> + <Principal Role="CONTACT"> <PropertyRef Name="ID" /> </Principal> - <Dependent Role="USERS"> + <Dependent Role="USER"> <PropertyRef Name="CONTACT_ID" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_EVENTS_ACTIONS_EVENTS"> - <End Role="EVENTS" Type="Self.EVENT" Multiplicity="1" /> - <End Role="EVENTS_ACTIONS" Type="Self.EVENTS_ACTIONS" Multiplicity="*" /> + <End Type="RemoteModel.EVENT" Role="EVENT" Multiplicity="1" /> + <End Type="RemoteModel.EVENTS_ACTIONS" Role="EVENTS_ACTIONS" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="EVENTS"> + <Principal Role="EVENT"> <PropertyRef Name="ID" /> </Principal> <Dependent Role="EVENTS_ACTIONS"> @@ -1776,10 +1964,10 @@ </ReferentialConstraint> </Association> <Association Name="FK_MACHINES_EVENTS_EVENTS"> - <End Role="EVENTS" Type="Self.EVENT" Multiplicity="1" /> - <End Role="MACHINES_EVENTS" Type="Self.MACHINES_EVENTS" Multiplicity="*" /> + <End Type="RemoteModel.EVENT" Role="EVENT" Multiplicity="1" /> + <End Type="RemoteModel.MACHINES_EVENTS" Role="MACHINES_EVENTS" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="EVENTS"> + <Principal Role="EVENT"> <PropertyRef Name="ID" /> </Principal> <Dependent Role="MACHINES_EVENTS"> @@ -1788,8 +1976,8 @@ </ReferentialConstraint> </Association> <Association Name="FK_RML_FIBER_SHAPES"> - <End Role="FIBER_SHAPES" Type="Self.FIBER_SHAPES" Multiplicity="1" /> - <End Role="RML" Type="Self.RML" Multiplicity="*" /> + <End Type="RemoteModel.FIBER_SHAPES" Role="FIBER_SHAPES" Multiplicity="1" /> + <End Type="RemoteModel.RML" Role="RML" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="FIBER_SHAPES"> <PropertyRef Name="ID" /> @@ -1800,8 +1988,8 @@ </ReferentialConstraint> </Association> <Association Name="FK_RML_FIBER_SYNTHESIS"> - <End Role="FIBER_SYNTHESIS" Type="Self.FIBER_SYNTHESIS" Multiplicity="1" /> - <End Role="RML" Type="Self.RML" Multiplicity="*" /> + <End Type="RemoteModel.FIBER_SYNTHESIS" Role="FIBER_SYNTHESIS" Multiplicity="1" /> + <End Type="RemoteModel.RML" Role="RML" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="FIBER_SYNTHESIS"> <PropertyRef Name="ID" /> @@ -1812,8 +2000,8 @@ </ReferentialConstraint> </Association> <Association Name="FK_RML_LINEAR_MASS_DENSITY_UNITS"> - <End Role="LINEAR_MASS_DENSITY_UNITS" Type="Self.LINEAR_MASS_DENSITY_UNITS" Multiplicity="1" /> - <End Role="RML" Type="Self.RML" Multiplicity="*" /> + <End Type="RemoteModel.LINEAR_MASS_DENSITY_UNITS" Role="LINEAR_MASS_DENSITY_UNITS" Multiplicity="1" /> + <End Type="RemoteModel.RML" Role="RML" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="LINEAR_MASS_DENSITY_UNITS"> <PropertyRef Name="ID" /> @@ -1824,22 +2012,22 @@ </ReferentialConstraint> </Association> <Association Name="FK_LIQUIDS_LIQUID_TYPES"> - <End Role="LIQUID_TYPES" Type="Self.LIQUID_TYPES" Multiplicity="1" /> - <End Role="LIQUIDS" Type="Self.LIQUID" Multiplicity="*" /> + <End Type="RemoteModel.LIQUID_TYPES" Role="LIQUID_TYPES" Multiplicity="1" /> + <End Type="RemoteModel.LIQUID" Role="LIQUID" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="LIQUID_TYPES"> <PropertyRef Name="ID" /> </Principal> - <Dependent Role="LIQUIDS"> + <Dependent Role="LIQUID"> <PropertyRef Name="LIQUID_TYPE_ID" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_LIQUID_RML_LIQUIDS"> - <End Role="LIQUIDS" Type="Self.LIQUID" Multiplicity="1" /> - <End Role="LIQUIDS_RML" Type="Self.LIQUIDS_RML" Multiplicity="*" /> + <End Type="RemoteModel.LIQUID" Role="LIQUID" Multiplicity="1" /> + <End Type="RemoteModel.LIQUIDS_RML" Role="LIQUIDS_RML" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="LIQUIDS"> + <Principal Role="LIQUID"> <PropertyRef Name="ID" /> </Principal> <Dependent Role="LIQUIDS_RML"> @@ -1848,8 +2036,8 @@ </ReferentialConstraint> </Association> <Association Name="FK_LIQUID_RML_RML"> - <End Role="RML" Type="Self.RML" Multiplicity="1" /> - <End Role="LIQUIDS_RML" Type="Self.LIQUIDS_RML" Multiplicity="*" /> + <End Type="RemoteModel.RML" Role="RML" Multiplicity="1" /> + <End Type="RemoteModel.LIQUIDS_RML" Role="LIQUIDS_RML" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="RML"> <PropertyRef Name="ID" /> @@ -1860,22 +2048,22 @@ </ReferentialConstraint> </Association> <Association Name="FK_MACHINES_MACHINE_VERSIONS"> - <End Role="MACHINE_VERSIONS" Type="Self.MACHINE_VERSIONS" Multiplicity="1" /> - <End Role="MACHINES" Type="Self.MACHINE" Multiplicity="*" /> + <End Type="RemoteModel.MACHINE_VERSIONS" Role="MACHINE_VERSIONS" Multiplicity="1" /> + <End Type="RemoteModel.MACHINE" Role="MACHINE" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="MACHINE_VERSIONS"> <PropertyRef Name="ID" /> </Principal> - <Dependent Role="MACHINES"> + <Dependent Role="MACHINE"> <PropertyRef Name="MACHINE_VERSION_ID" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_MACHINE_EVENTS_MACHINES"> - <End Role="MACHINES" Type="Self.MACHINE" Multiplicity="1" /> - <End Role="MACHINES_EVENTS" Type="Self.MACHINES_EVENTS" Multiplicity="*" /> + <End Type="RemoteModel.MACHINE" Role="MACHINE" Multiplicity="1" /> + <End Type="RemoteModel.MACHINES_EVENTS" Role="MACHINES_EVENTS" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="MACHINES"> + <Principal Role="MACHINE"> <PropertyRef Name="ID" /> </Principal> <Dependent Role="MACHINES_EVENTS"> @@ -1884,22 +2072,22 @@ </ReferentialConstraint> </Association> <Association Name="FK_MACHINES_ORGANIZATIONS"> - <End Role="ORGANIZATIONS" Type="Self.ORGANIZATION" Multiplicity="1" /> - <End Role="MACHINES" Type="Self.MACHINE" Multiplicity="*" /> + <End Type="RemoteModel.ORGANIZATION" Role="ORGANIZATION" Multiplicity="1" /> + <End Type="RemoteModel.MACHINE" Role="MACHINE" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="ORGANIZATIONS"> + <Principal Role="ORGANIZATION"> <PropertyRef Name="ID" /> </Principal> - <Dependent Role="MACHINES"> + <Dependent Role="MACHINE"> <PropertyRef Name="ORGANIZATION_ID" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_MACHINES_EVENTS_USERS"> - <End Role="USERS" Type="Self.USER" Multiplicity="1" /> - <End Role="MACHINES_EVENTS" Type="Self.MACHINES_EVENTS" Multiplicity="*" /> + <End Type="RemoteModel.USER" Role="USER" Multiplicity="1" /> + <End Type="RemoteModel.MACHINES_EVENTS" Role="MACHINES_EVENTS" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="USERS"> + <Principal Role="USER"> <PropertyRef Name="ID" /> </Principal> <Dependent Role="MACHINES_EVENTS"> @@ -1908,8 +2096,8 @@ </ReferentialConstraint> </Association> <Association Name="FK_RML_MEDIA_COLORS"> - <End Role="MEDIA_COLORS" Type="Self.MEDIA_COLORS" Multiplicity="1" /> - <End Role="RML" Type="Self.RML" Multiplicity="*" /> + <End Type="RemoteModel.MEDIA_COLORS" Role="MEDIA_COLORS" Multiplicity="1" /> + <End Type="RemoteModel.RML" Role="RML" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="MEDIA_COLORS"> <PropertyRef Name="ID" /> @@ -1920,8 +2108,8 @@ </ReferentialConstraint> </Association> <Association Name="FK_RML_MEDIA_CONDITIONS"> - <End Role="MEDIA_CONDITIONS" Type="Self.MEDIA_CONDITIONS" Multiplicity="1" /> - <End Role="RML" Type="Self.RML" Multiplicity="*" /> + <End Type="RemoteModel.MEDIA_CONDITIONS" Role="MEDIA_CONDITIONS" Multiplicity="1" /> + <End Type="RemoteModel.RML" Role="RML" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="MEDIA_CONDITIONS"> <PropertyRef Name="ID" /> @@ -1932,8 +2120,8 @@ </ReferentialConstraint> </Association> <Association Name="FK_RML_MEDIA_MATERIALS"> - <End Role="MEDIA_MATERIALS" Type="Self.MEDIA_MATERIALS" Multiplicity="1" /> - <End Role="RML" Type="Self.RML" Multiplicity="*" /> + <End Type="RemoteModel.MEDIA_MATERIALS" Role="MEDIA_MATERIALS" Multiplicity="1" /> + <End Type="RemoteModel.RML" Role="RML" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="MEDIA_MATERIALS"> <PropertyRef Name="ID" /> @@ -1944,8 +2132,8 @@ </ReferentialConstraint> </Association> <Association Name="FK_RML_MEDIA_PURPOSES"> - <End Role="MEDIA_PURPOSES" Type="Self.MEDIA_PURPOSES" Multiplicity="1" /> - <End Role="RML" Type="Self.RML" Multiplicity="*" /> + <End Type="RemoteModel.MEDIA_PURPOSES" Role="MEDIA_PURPOSES" Multiplicity="1" /> + <End Type="RemoteModel.RML" Role="RML" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="MEDIA_PURPOSES"> <PropertyRef Name="ID" /> @@ -1956,22 +2144,22 @@ </ReferentialConstraint> </Association> <Association Name="FK_USERS_ORGANIZATIONS"> - <End Role="ORGANIZATIONS" Type="Self.ORGANIZATION" Multiplicity="1" /> - <End Role="USERS" Type="Self.USER" Multiplicity="*" /> + <End Type="RemoteModel.ORGANIZATION" Role="ORGANIZATION" Multiplicity="1" /> + <End Type="RemoteModel.USER" Role="USER" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="ORGANIZATIONS"> + <Principal Role="ORGANIZATION"> <PropertyRef Name="ID" /> </Principal> - <Dependent Role="USERS"> + <Dependent Role="USER"> <PropertyRef Name="ORGANIZATION_ID" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_ROLES_PERMISSIONS_PERMISSIONS"> - <End Role="PERMISSIONS" Type="Self.PERMISSION" Multiplicity="1" /> - <End Role="ROLES_PERMISSIONS" Type="Self.ROLES_PERMISSIONS" Multiplicity="*" /> + <End Type="RemoteModel.PERMISSION" Role="PERMISSION" Multiplicity="1" /> + <End Type="RemoteModel.ROLES_PERMISSIONS" Role="ROLES_PERMISSIONS" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="PERMISSIONS"> + <Principal Role="PERMISSION"> <PropertyRef Name="ID" /> </Principal> <Dependent Role="ROLES_PERMISSIONS"> @@ -1980,10 +2168,10 @@ </ReferentialConstraint> </Association> <Association Name="FK_ROLES_PERMISSIONS_ROLES"> - <End Role="ROLES" Type="Self.ROLE" Multiplicity="1" /> - <End Role="ROLES_PERMISSIONS" Type="Self.ROLES_PERMISSIONS" Multiplicity="*" /> + <End Type="RemoteModel.ROLE" Role="ROLE" Multiplicity="1" /> + <End Type="RemoteModel.ROLES_PERMISSIONS" Role="ROLES_PERMISSIONS" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="ROLES"> + <Principal Role="ROLE"> <PropertyRef Name="ID" /> </Principal> <Dependent Role="ROLES_PERMISSIONS"> @@ -1992,10 +2180,10 @@ </ReferentialConstraint> </Association> <Association Name="FK_USERS_ROLES_ROLES"> - <End Role="ROLES" Type="Self.ROLE" Multiplicity="1" /> - <End Role="USERS_ROLES" Type="Self.USERS_ROLES" Multiplicity="*" /> + <End Type="RemoteModel.ROLE" Role="ROLE" Multiplicity="1" /> + <End Type="RemoteModel.USERS_ROLES" Role="USERS_ROLES" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="ROLES"> + <Principal Role="ROLE"> <PropertyRef Name="ID" /> </Principal> <Dependent Role="USERS_ROLES"> @@ -2004,10 +2192,10 @@ </ReferentialConstraint> </Association> <Association Name="FK_USERS_ROLES_USERS"> - <End Role="USERS" Type="Self.USER" Multiplicity="1" /> - <End Role="USERS_ROLES" Type="Self.USERS_ROLES" Multiplicity="*" /> + <End Type="RemoteModel.USER" Role="USER" Multiplicity="1" /> + <End Type="RemoteModel.USERS_ROLES" Role="USERS_ROLES" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="USERS"> + <Principal Role="USER"> <PropertyRef Name="ID" /> </Principal> <Dependent Role="USERS_ROLES"> @@ -2015,195 +2203,6 @@ </Dependent> </ReferentialConstraint> </Association> - <EntityContainer Name="RemoteDB" annotation:LazyLoadingEnabled="true"> - <EntitySet Name="ACTIONS" EntityType="Self.ACTION" /> - <EntitySet Name="ADDRESSES" EntityType="Self.ADDRESS" /> - <EntitySet Name="APPLICATION_DISPLAY_PANEL_VERSIONS" EntityType="Self.APPLICATION_DISPLAY_PANEL_VERSIONS" /> - <EntitySet Name="APPLICATION_FIRMWARE_VERSIONS" EntityType="Self.APPLICATION_FIRMWARE_VERSIONS" /> - <EntitySet Name="APPLICATION_OS_VERSIONS" EntityType="Self.APPLICATION_OS_VERSIONS" /> - <EntitySet Name="APPLICATION_VERSIONS" EntityType="Self.APPLICATION_VERSIONS" /> - <EntitySet Name="CONFIGURATIONS" EntityType="Self.CONFIGURATION" /> - <EntitySet Name="CONFIGURATIONS_DISPENSERS" EntityType="Self.CONFIGURATIONS_DISPENSERS" /> - <EntitySet Name="CONTACTS" EntityType="Self.CONTACT" /> - <EntitySet Name="DISPENSERS" EntityType="Self.DISPENSER" /> - <EntitySet Name="EMBEDDED_FIRMWARE_VERSIONS" EntityType="Self.EMBEDDED_FIRMWARE_VERSIONS" /> - <EntitySet Name="EMBEDDED_SOFTWARE_VERSIONS" EntityType="Self.EMBEDDED_SOFTWARE_VERSIONS" /> - <EntitySet Name="EVENTS" EntityType="Self.EVENT" /> - <EntitySet Name="EVENTS_ACTIONS" EntityType="Self.EVENTS_ACTIONS" /> - <EntitySet Name="FIBER_SHAPES" EntityType="Self.FIBER_SHAPES" /> - <EntitySet Name="FIBER_SYNTHESIS" EntityType="Self.FIBER_SYNTHESIS" /> - <EntitySet Name="HARDWARE_VERSIONS" EntityType="Self.HARDWARE_VERSIONS" /> - <EntitySet Name="LINEAR_MASS_DENSITY_UNITS" EntityType="Self.LINEAR_MASS_DENSITY_UNITS" /> - <EntitySet Name="LIQUID_TYPES" EntityType="Self.LIQUID_TYPES" /> - <EntitySet Name="LIQUIDS" EntityType="Self.LIQUID" /> - <EntitySet Name="LIQUIDS_RML" EntityType="Self.LIQUIDS_RML" /> - <EntitySet Name="MACHINE_VERSIONS" EntityType="Self.MACHINE_VERSIONS" /> - <EntitySet Name="MACHINES" EntityType="Self.MACHINE" /> - <EntitySet Name="MACHINES_EVENTS" EntityType="Self.MACHINES_EVENTS" /> - <EntitySet Name="MEDIA_COLORS" EntityType="Self.MEDIA_COLORS" /> - <EntitySet Name="MEDIA_CONDITIONS" EntityType="Self.MEDIA_CONDITIONS" /> - <EntitySet Name="MEDIA_MATERIALS" EntityType="Self.MEDIA_MATERIALS" /> - <EntitySet Name="MEDIA_PURPOSES" EntityType="Self.MEDIA_PURPOSES" /> - <EntitySet Name="ORGANIZATIONS" EntityType="Self.ORGANIZATION" /> - <EntitySet Name="PERMISSIONS" EntityType="Self.PERMISSION" /> - <EntitySet Name="RMLs" EntityType="Self.RML" /> - <EntitySet Name="ROLES" EntityType="Self.ROLE" /> - <EntitySet Name="ROLES_PERMISSIONS" EntityType="Self.ROLES_PERMISSIONS" /> - <EntitySet Name="USERS" EntityType="Self.USER" /> - <EntitySet Name="USERS_ROLES" EntityType="Self.USERS_ROLES" /> - <AssociationSet Name="FK_EVENTS_ACTIONS_ACTIONS" Association="Self.FK_EVENTS_ACTIONS_ACTIONS"> - <End Role="ACTIONS" EntitySet="ACTIONS" /> - <End Role="EVENTS_ACTIONS" EntitySet="EVENTS_ACTIONS" /> - </AssociationSet> - <AssociationSet Name="FK_ORGANIZATIONS_ADDRESSES" Association="Self.FK_ORGANIZATIONS_ADDRESSES"> - <End Role="ADDRESSES" EntitySet="ADDRESSES" /> - <End Role="ORGANIZATIONS" EntitySet="ORGANIZATIONS" /> - </AssociationSet> - <AssociationSet Name="FK_USERS_ADDRESSES" Association="Self.FK_USERS_ADDRESSES"> - <End Role="ADDRESSES" EntitySet="ADDRESSES" /> - <End Role="USERS" EntitySet="USERS" /> - </AssociationSet> - <AssociationSet Name="FK_CONFIGURATIONS_APPLICATION_DISPLAY_PANEL_VERSIONS" Association="Self.FK_CONFIGURATIONS_APPLICATION_DISPLAY_PANEL_VERSIONS"> - <End Role="APPLICATION_DISPLAY_PANEL_VERSIONS" EntitySet="APPLICATION_DISPLAY_PANEL_VERSIONS" /> - <End Role="CONFIGURATIONS" EntitySet="CONFIGURATIONS" /> - </AssociationSet> - <AssociationSet Name="FK_CONFIGURATIONS_APPLICATION_FIRMWARE_VERSIONS" Association="Self.FK_CONFIGURATIONS_APPLICATION_FIRMWARE_VERSIONS"> - <End Role="APPLICATION_FIRMWARE_VERSIONS" EntitySet="APPLICATION_FIRMWARE_VERSIONS" /> - <End Role="CONFIGURATIONS" EntitySet="CONFIGURATIONS" /> - </AssociationSet> - <AssociationSet Name="FK_CONFIGURATIONS_APPLICATION_OS_VERSIONS" Association="Self.FK_CONFIGURATIONS_APPLICATION_OS_VERSIONS"> - <End Role="APPLICATION_OS_VERSIONS" EntitySet="APPLICATION_OS_VERSIONS" /> - <End Role="CONFIGURATIONS" EntitySet="CONFIGURATIONS" /> - </AssociationSet> - <AssociationSet Name="FK_CONFIGURATIONS_APPLICATION_VERSIONS" Association="Self.FK_CONFIGURATIONS_APPLICATION_VERSIONS"> - <End Role="APPLICATION_VERSIONS" EntitySet="APPLICATION_VERSIONS" /> - <End Role="CONFIGURATIONS" EntitySet="CONFIGURATIONS" /> - </AssociationSet> - <AssociationSet Name="FK_CONFIGURATIONS_DISPENSERS_CONFIGURATIONS" Association="Self.FK_CONFIGURATIONS_DISPENSERS_CONFIGURATIONS"> - <End Role="CONFIGURATIONS" EntitySet="CONFIGURATIONS" /> - <End Role="CONFIGURATIONS_DISPENSERS" EntitySet="CONFIGURATIONS_DISPENSERS" /> - </AssociationSet> - <AssociationSet Name="FK_CONFIGURATIONS_EMBEDDED_FIRMWARE_VERSIONS" Association="Self.FK_CONFIGURATIONS_EMBEDDED_FIRMWARE_VERSIONS"> - <End Role="EMBEDDED_FIRMWARE_VERSIONS" EntitySet="EMBEDDED_FIRMWARE_VERSIONS" /> - <End Role="CONFIGURATIONS" EntitySet="CONFIGURATIONS" /> - </AssociationSet> - <AssociationSet Name="FK_CONFIGURATIONS_EMBEDDED_SOFTWARE_VERSIONS" Association="Self.FK_CONFIGURATIONS_EMBEDDED_SOFTWARE_VERSIONS"> - <End Role="EMBEDDED_SOFTWARE_VERSIONS" EntitySet="EMBEDDED_SOFTWARE_VERSIONS" /> - <End Role="CONFIGURATIONS" EntitySet="CONFIGURATIONS" /> - </AssociationSet> - <AssociationSet Name="FK_CONFIGURATIONS_HARDWARE_VERSIONS" Association="Self.FK_CONFIGURATIONS_HARDWARE_VERSIONS"> - <End Role="HARDWARE_VERSIONS" EntitySet="HARDWARE_VERSIONS" /> - <End Role="CONFIGURATIONS" EntitySet="CONFIGURATIONS" /> - </AssociationSet> - <AssociationSet Name="FK_CONFIGURATIONS_MACHINES" Association="Self.FK_CONFIGURATIONS_MACHINES"> - <End Role="MACHINES" EntitySet="MACHINES" /> - <End Role="CONFIGURATIONS" EntitySet="CONFIGURATIONS" /> - </AssociationSet> - <AssociationSet Name="FK_MACHINE_VERSIONS_CONFIGURATIONS" Association="Self.FK_MACHINE_VERSIONS_CONFIGURATIONS"> - <End Role="CONFIGURATIONS" EntitySet="CONFIGURATIONS" /> - <End Role="MACHINE_VERSIONS" EntitySet="MACHINE_VERSIONS" /> - </AssociationSet> - <AssociationSet Name="FK_CONFIGURATIONS_DISPENSERS_DISPENSERS" Association="Self.FK_CONFIGURATIONS_DISPENSERS_DISPENSERS"> - <End Role="DISPENSERS" EntitySet="DISPENSERS" /> - <End Role="CONFIGURATIONS_DISPENSERS" EntitySet="CONFIGURATIONS_DISPENSERS" /> - </AssociationSet> - <AssociationSet Name="FK_CONFIGURATIONS_DISPENSERS_LIQUIDS" Association="Self.FK_CONFIGURATIONS_DISPENSERS_LIQUIDS"> - <End Role="LIQUIDS" EntitySet="LIQUIDS" /> - <End Role="CONFIGURATIONS_DISPENSERS" EntitySet="CONFIGURATIONS_DISPENSERS" /> - </AssociationSet> - <AssociationSet Name="FK_ORGANIZATIONS_CONTACTS" Association="Self.FK_ORGANIZATIONS_CONTACTS"> - <End Role="CONTACTS" EntitySet="CONTACTS" /> - <End Role="ORGANIZATIONS" EntitySet="ORGANIZATIONS" /> - </AssociationSet> - <AssociationSet Name="FK_USERS_CONTACTS" Association="Self.FK_USERS_CONTACTS"> - <End Role="CONTACTS" EntitySet="CONTACTS" /> - <End Role="USERS" EntitySet="USERS" /> - </AssociationSet> - <AssociationSet Name="FK_EVENTS_ACTIONS_EVENTS" Association="Self.FK_EVENTS_ACTIONS_EVENTS"> - <End Role="EVENTS" EntitySet="EVENTS" /> - <End Role="EVENTS_ACTIONS" EntitySet="EVENTS_ACTIONS" /> - </AssociationSet> - <AssociationSet Name="FK_MACHINES_EVENTS_EVENTS" Association="Self.FK_MACHINES_EVENTS_EVENTS"> - <End Role="EVENTS" EntitySet="EVENTS" /> - <End Role="MACHINES_EVENTS" EntitySet="MACHINES_EVENTS" /> - </AssociationSet> - <AssociationSet Name="FK_RML_FIBER_SHAPES" Association="Self.FK_RML_FIBER_SHAPES"> - <End Role="FIBER_SHAPES" EntitySet="FIBER_SHAPES" /> - <End Role="RML" EntitySet="RMLs" /> - </AssociationSet> - <AssociationSet Name="FK_RML_FIBER_SYNTHESIS" Association="Self.FK_RML_FIBER_SYNTHESIS"> - <End Role="FIBER_SYNTHESIS" EntitySet="FIBER_SYNTHESIS" /> - <End Role="RML" EntitySet="RMLs" /> - </AssociationSet> - <AssociationSet Name="FK_RML_LINEAR_MASS_DENSITY_UNITS" Association="Self.FK_RML_LINEAR_MASS_DENSITY_UNITS"> - <End Role="LINEAR_MASS_DENSITY_UNITS" EntitySet="LINEAR_MASS_DENSITY_UNITS" /> - <End Role="RML" EntitySet="RMLs" /> - </AssociationSet> - <AssociationSet Name="FK_LIQUIDS_LIQUID_TYPES" Association="Self.FK_LIQUIDS_LIQUID_TYPES"> - <End Role="LIQUID_TYPES" EntitySet="LIQUID_TYPES" /> - <End Role="LIQUIDS" EntitySet="LIQUIDS" /> - </AssociationSet> - <AssociationSet Name="FK_LIQUID_RML_LIQUIDS" Association="Self.FK_LIQUID_RML_LIQUIDS"> - <End Role="LIQUIDS" EntitySet="LIQUIDS" /> - <End Role="LIQUIDS_RML" EntitySet="LIQUIDS_RML" /> - </AssociationSet> - <AssociationSet Name="FK_LIQUID_RML_RML" Association="Self.FK_LIQUID_RML_RML"> - <End Role="RML" EntitySet="RMLs" /> - <End Role="LIQUIDS_RML" EntitySet="LIQUIDS_RML" /> - </AssociationSet> - <AssociationSet Name="FK_MACHINES_MACHINE_VERSIONS" Association="Self.FK_MACHINES_MACHINE_VERSIONS"> - <End Role="MACHINE_VERSIONS" EntitySet="MACHINE_VERSIONS" /> - <End Role="MACHINES" EntitySet="MACHINES" /> - </AssociationSet> - <AssociationSet Name="FK_MACHINE_EVENTS_MACHINES" Association="Self.FK_MACHINE_EVENTS_MACHINES"> - <End Role="MACHINES" EntitySet="MACHINES" /> - <End Role="MACHINES_EVENTS" EntitySet="MACHINES_EVENTS" /> - </AssociationSet> - <AssociationSet Name="FK_MACHINES_ORGANIZATIONS" Association="Self.FK_MACHINES_ORGANIZATIONS"> - <End Role="ORGANIZATIONS" EntitySet="ORGANIZATIONS" /> - <End Role="MACHINES" EntitySet="MACHINES" /> - </AssociationSet> - <AssociationSet Name="FK_MACHINES_EVENTS_USERS" Association="Self.FK_MACHINES_EVENTS_USERS"> - <End Role="USERS" EntitySet="USERS" /> - <End Role="MACHINES_EVENTS" EntitySet="MACHINES_EVENTS" /> - </AssociationSet> - <AssociationSet Name="FK_RML_MEDIA_COLORS" Association="Self.FK_RML_MEDIA_COLORS"> - <End Role="MEDIA_COLORS" EntitySet="MEDIA_COLORS" /> - <End Role="RML" EntitySet="RMLs" /> - </AssociationSet> - <AssociationSet Name="FK_RML_MEDIA_CONDITIONS" Association="Self.FK_RML_MEDIA_CONDITIONS"> - <End Role="MEDIA_CONDITIONS" EntitySet="MEDIA_CONDITIONS" /> - <End Role="RML" EntitySet="RMLs" /> - </AssociationSet> - <AssociationSet Name="FK_RML_MEDIA_MATERIALS" Association="Self.FK_RML_MEDIA_MATERIALS"> - <End Role="MEDIA_MATERIALS" EntitySet="MEDIA_MATERIALS" /> - <End Role="RML" EntitySet="RMLs" /> - </AssociationSet> - <AssociationSet Name="FK_RML_MEDIA_PURPOSES" Association="Self.FK_RML_MEDIA_PURPOSES"> - <End Role="MEDIA_PURPOSES" EntitySet="MEDIA_PURPOSES" /> - <End Role="RML" EntitySet="RMLs" /> - </AssociationSet> - <AssociationSet Name="FK_USERS_ORGANIZATIONS" Association="Self.FK_USERS_ORGANIZATIONS"> - <End Role="ORGANIZATIONS" EntitySet="ORGANIZATIONS" /> - <End Role="USERS" EntitySet="USERS" /> - </AssociationSet> - <AssociationSet Name="FK_ROLES_PERMISSIONS_PERMISSIONS" Association="Self.FK_ROLES_PERMISSIONS_PERMISSIONS"> - <End Role="PERMISSIONS" EntitySet="PERMISSIONS" /> - <End Role="ROLES_PERMISSIONS" EntitySet="ROLES_PERMISSIONS" /> - </AssociationSet> - <AssociationSet Name="FK_ROLES_PERMISSIONS_ROLES" Association="Self.FK_ROLES_PERMISSIONS_ROLES"> - <End Role="ROLES" EntitySet="ROLES" /> - <End Role="ROLES_PERMISSIONS" EntitySet="ROLES_PERMISSIONS" /> - </AssociationSet> - <AssociationSet Name="FK_USERS_ROLES_ROLES" Association="Self.FK_USERS_ROLES_ROLES"> - <End Role="ROLES" EntitySet="ROLES" /> - <End Role="USERS_ROLES" EntitySet="USERS_ROLES" /> - </AssociationSet> - <AssociationSet Name="FK_USERS_ROLES_USERS" Association="Self.FK_USERS_ROLES_USERS"> - <End Role="USERS" EntitySet="USERS" /> - <End Role="USERS_ROLES" EntitySet="USERS_ROLES" /> - </AssociationSet> - </EntityContainer> </Schema> </edmx:ConceptualModels> <!-- C-S mapping content --> @@ -2213,449 +2212,449 @@ <EntitySetMapping Name="ACTIONS"> <EntityTypeMapping TypeName="RemoteModel.ACTION"> <MappingFragment StoreEntitySet="ACTIONS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="CODE" ColumnName="CODE" /> - <ScalarProperty Name="NAME" ColumnName="NAME" /> <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="CODE" ColumnName="CODE" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="ADDRESSES"> <EntityTypeMapping TypeName="RemoteModel.ADDRESS"> <MappingFragment StoreEntitySet="ADDRESSES"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="ADDRESS1" ColumnName="ADDRESS" /> - <ScalarProperty Name="LOCALITY" ColumnName="LOCALITY" /> - <ScalarProperty Name="COUNTRY" ColumnName="COUNTRY" /> - <ScalarProperty Name="CITY" ColumnName="CITY" /> - <ScalarProperty Name="STATE" ColumnName="STATE" /> - <ScalarProperty Name="COUNTRY_CODE" ColumnName="COUNTRY_CODE" /> <ScalarProperty Name="POSTAL_CODE" ColumnName="POSTAL_CODE" /> + <ScalarProperty Name="COUNTRY_CODE" ColumnName="COUNTRY_CODE" /> + <ScalarProperty Name="STATE" ColumnName="STATE" /> + <ScalarProperty Name="CITY" ColumnName="CITY" /> + <ScalarProperty Name="COUNTRY" ColumnName="COUNTRY" /> + <ScalarProperty Name="LOCALITY" ColumnName="LOCALITY" /> + <ScalarProperty Name="ADDRESS1" ColumnName="ADDRESS" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="APPLICATION_DISPLAY_PANEL_VERSIONS"> <EntityTypeMapping TypeName="RemoteModel.APPLICATION_DISPLAY_PANEL_VERSIONS"> <MappingFragment StoreEntitySet="APPLICATION_DISPLAY_PANEL_VERSIONS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="APPLICATION_FIRMWARE_VERSIONS"> <EntityTypeMapping TypeName="RemoteModel.APPLICATION_FIRMWARE_VERSIONS"> <MappingFragment StoreEntitySet="APPLICATION_FIRMWARE_VERSIONS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="APPLICATION_OS_VERSIONS"> <EntityTypeMapping TypeName="RemoteModel.APPLICATION_OS_VERSIONS"> <MappingFragment StoreEntitySet="APPLICATION_OS_VERSIONS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="APPLICATION_VERSIONS"> <EntityTypeMapping TypeName="RemoteModel.APPLICATION_VERSIONS"> <MappingFragment StoreEntitySet="APPLICATION_VERSIONS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <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="RemoteModel.CONFIGURATION"> <MappingFragment StoreEntitySet="CONFIGURATIONS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="CREATION_DATE" ColumnName="CREATION_DATE" /> - <ScalarProperty Name="MACHINE_ID" ColumnName="MACHINE_ID" /> - <ScalarProperty Name="APPLICATION_VERSION_ID" ColumnName="APPLICATION_VERSION_ID" /> - <ScalarProperty Name="APPLICATION_OS_VERSION_ID" ColumnName="APPLICATION_OS_VERSION_ID" /> - <ScalarProperty Name="APPLICATION_FIRMWARE_VERSION_ID" ColumnName="APPLICATION_FIRMWARE_VERSION_ID" /> - <ScalarProperty Name="APPLICATION_DISPLAY_PANEL_VERSION_ID" ColumnName="APPLICATION_DISPLAY_PANEL_VERSION_ID" /> - <ScalarProperty Name="EMBEDDED_FIRMWARE_VERSION_ID" ColumnName="EMBEDDED_FIRMWARE_VERSION_ID" /> - <ScalarProperty Name="EMBEDDED_SOFTWARE_VERSION_ID" ColumnName="EMBEDDED_SOFTWARE_VERSION_ID" /> <ScalarProperty Name="HARDWARE_VERSION_ID" ColumnName="HARDWARE_VERSION_ID" /> + <ScalarProperty Name="EMBEDDED_SOFTWARE_VERSION_ID" ColumnName="EMBEDDED_SOFTWARE_VERSION_ID" /> + <ScalarProperty Name="EMBEDDED_FIRMWARE_VERSION_ID" ColumnName="EMBEDDED_FIRMWARE_VERSION_ID" /> + <ScalarProperty Name="APPLICATION_DISPLAY_PANEL_VERSION_ID" ColumnName="APPLICATION_DISPLAY_PANEL_VERSION_ID" /> + <ScalarProperty Name="APPLICATION_FIRMWARE_VERSION_ID" ColumnName="APPLICATION_FIRMWARE_VERSION_ID" /> + <ScalarProperty Name="APPLICATION_OS_VERSION_ID" ColumnName="APPLICATION_OS_VERSION_ID" /> + <ScalarProperty Name="APPLICATION_VERSION_ID" ColumnName="APPLICATION_VERSION_ID" /> + <ScalarProperty Name="MACHINE_ID" ColumnName="MACHINE_ID" /> + <ScalarProperty Name="CREATION_DATE" ColumnName="CREATION_DATE" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="CONFIGURATIONS_DISPENSERS"> <EntityTypeMapping TypeName="RemoteModel.CONFIGURATIONS_DISPENSERS"> <MappingFragment StoreEntitySet="CONFIGURATIONS_DISPENSERS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="CONFIGURATION_ID" ColumnName="CONFIGURATION_ID" /> - <ScalarProperty Name="DISPENSER_ID" ColumnName="DISPENSER_ID" /> <ScalarProperty Name="LIQUID_ID" ColumnName="LIQUID_ID" /> + <ScalarProperty Name="DISPENSER_ID" ColumnName="DISPENSER_ID" /> + <ScalarProperty Name="CONFIGURATION_ID" ColumnName="CONFIGURATION_ID" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="CONTACTS"> <EntityTypeMapping TypeName="RemoteModel.CONTACT"> <MappingFragment StoreEntitySet="CONTACTS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="FIRST_NAME" ColumnName="FIRST_NAME" /> - <ScalarProperty Name="LAST_NAME" ColumnName="LAST_NAME" /> - <ScalarProperty Name="FULL_NAME" ColumnName="FULL_NAME" /> - <ScalarProperty Name="EMAIL" ColumnName="EMAIL" /> - <ScalarProperty Name="PHONE_NUMBER" ColumnName="PHONE_NUMBER" /> <ScalarProperty Name="FAX" ColumnName="FAX" /> + <ScalarProperty Name="PHONE_NUMBER" ColumnName="PHONE_NUMBER" /> + <ScalarProperty Name="EMAIL" ColumnName="EMAIL" /> + <ScalarProperty Name="FULL_NAME" ColumnName="FULL_NAME" /> + <ScalarProperty Name="LAST_NAME" ColumnName="LAST_NAME" /> + <ScalarProperty Name="FIRST_NAME" ColumnName="FIRST_NAME" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="DISPENSERS"> <EntityTypeMapping TypeName="RemoteModel.DISPENSER"> <MappingFragment StoreEntitySet="DISPENSERS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="EMBEDDED_FIRMWARE_VERSIONS"> <EntityTypeMapping TypeName="RemoteModel.EMBEDDED_FIRMWARE_VERSIONS"> <MappingFragment StoreEntitySet="EMBEDDED_FIRMWARE_VERSIONS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="EMBEDDED_SOFTWARE_VERSIONS"> <EntityTypeMapping TypeName="RemoteModel.EMBEDDED_SOFTWARE_VERSIONS"> <MappingFragment StoreEntitySet="EMBEDDED_SOFTWARE_VERSIONS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="EVENTS"> <EntityTypeMapping TypeName="RemoteModel.EVENT"> <MappingFragment StoreEntitySet="EVENTS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="CODE" ColumnName="CODE" /> - <ScalarProperty Name="NAME" ColumnName="NAME" /> <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="CODE" ColumnName="CODE" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="EVENTS_ACTIONS"> <EntityTypeMapping TypeName="RemoteModel.EVENTS_ACTIONS"> <MappingFragment StoreEntitySet="EVENTS_ACTIONS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="EVENT_ID" ColumnName="EVENT_ID" /> <ScalarProperty Name="ACTION_ID" ColumnName="ACTION_ID" /> + <ScalarProperty Name="EVENT_ID" ColumnName="EVENT_ID" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="FIBER_SHAPES"> <EntityTypeMapping TypeName="RemoteModel.FIBER_SHAPES"> <MappingFragment StoreEntitySet="FIBER_SHAPES"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="NAME" ColumnName="NAME" /> <ScalarProperty Name="CODE" ColumnName="CODE" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="FIBER_SYNTHESIS"> <EntityTypeMapping TypeName="RemoteModel.FIBER_SYNTHESIS"> <MappingFragment StoreEntitySet="FIBER_SYNTHESIS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="NAME" ColumnName="NAME" /> <ScalarProperty Name="CODE" ColumnName="CODE" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="HARDWARE_VERSIONS"> <EntityTypeMapping TypeName="RemoteModel.HARDWARE_VERSIONS"> <MappingFragment StoreEntitySet="HARDWARE_VERSIONS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <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="RemoteModel.LINEAR_MASS_DENSITY_UNITS"> <MappingFragment StoreEntitySet="LINEAR_MASS_DENSITY_UNITS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="NAME" ColumnName="NAME" /> <ScalarProperty Name="CODE" ColumnName="CODE" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="LIQUID_TYPES"> <EntityTypeMapping TypeName="RemoteModel.LIQUID_TYPES"> <MappingFragment StoreEntitySet="LIQUID_TYPES"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="NAME" ColumnName="NAME" /> - <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> <ScalarProperty Name="CODE" ColumnName="CODE" /> + <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="LIQUIDS"> <EntityTypeMapping TypeName="RemoteModel.LIQUID"> <MappingFragment StoreEntitySet="LIQUIDS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="NAME" ColumnName="NAME" /> - <ScalarProperty Name="VERSION" ColumnName="VERSION" /> <ScalarProperty Name="LIQUID_TYPE_ID" ColumnName="LIQUID_TYPE_ID" /> + <ScalarProperty Name="VERSION" ColumnName="VERSION" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="LIQUIDS_RML"> <EntityTypeMapping TypeName="RemoteModel.LIQUIDS_RML"> <MappingFragment StoreEntitySet="LIQUIDS_RML"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="LIQUID_ID" ColumnName="LIQUID_ID" /> <ScalarProperty Name="RML_ID" ColumnName="RML_ID" /> + <ScalarProperty Name="LIQUID_ID" ColumnName="LIQUID_ID" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="MACHINE_VERSIONS"> <EntityTypeMapping TypeName="RemoteModel.MACHINE_VERSIONS"> <MappingFragment StoreEntitySet="MACHINE_VERSIONS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="VERSION" ColumnName="VERSION" /> <ScalarProperty Name="DEFAULT_CONFIGURATION_ID" ColumnName="DEFAULT_CONFIGURATION_ID" /> + <ScalarProperty Name="VERSION" ColumnName="VERSION" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="MACHINES"> <EntityTypeMapping TypeName="RemoteModel.MACHINE"> <MappingFragment StoreEntitySet="MACHINES"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="SERIAL_NUMBER" ColumnName="SERIAL_NUMBER" /> - <ScalarProperty Name="PRODUCTION_DATE" ColumnName="PRODUCTION_DATE" /> - <ScalarProperty Name="ORGANIZATION_ID" ColumnName="ORGANIZATION_ID" /> <ScalarProperty Name="MACHINE_VERSION_ID" ColumnName="MACHINE_VERSION_ID" /> + <ScalarProperty Name="ORGANIZATION_ID" ColumnName="ORGANIZATION_ID" /> + <ScalarProperty Name="PRODUCTION_DATE" ColumnName="PRODUCTION_DATE" /> + <ScalarProperty Name="SERIAL_NUMBER" ColumnName="SERIAL_NUMBER" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="MACHINES_EVENTS"> <EntityTypeMapping TypeName="RemoteModel.MACHINES_EVENTS"> <MappingFragment StoreEntitySet="MACHINES_EVENTS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="MACHINE_ID" ColumnName="MACHINE_ID" /> - <ScalarProperty Name="EVENT_ID" ColumnName="EVENT_ID" /> - <ScalarProperty Name="USER_ID" ColumnName="USER_ID" /> - <ScalarProperty Name="DATE_TIME" ColumnName="DATE_TIME" /> <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> + <ScalarProperty Name="DATE_TIME" ColumnName="DATE_TIME" /> + <ScalarProperty Name="USER_ID" ColumnName="USER_ID" /> + <ScalarProperty Name="EVENT_ID" ColumnName="EVENT_ID" /> + <ScalarProperty Name="MACHINE_ID" ColumnName="MACHINE_ID" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="MEDIA_COLORS"> <EntityTypeMapping TypeName="RemoteModel.MEDIA_COLORS"> <MappingFragment StoreEntitySet="MEDIA_COLORS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> <ScalarProperty Name="COLOR" ColumnName="COLOR" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="MEDIA_CONDITIONS"> <EntityTypeMapping TypeName="RemoteModel.MEDIA_CONDITIONS"> <MappingFragment StoreEntitySet="MEDIA_CONDITIONS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="NAME" ColumnName="NAME" /> <ScalarProperty Name="CODE" ColumnName="CODE" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="MEDIA_MATERIALS"> <EntityTypeMapping TypeName="RemoteModel.MEDIA_MATERIALS"> <MappingFragment StoreEntitySet="MEDIA_MATERIALS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="NAME" ColumnName="NAME" /> <ScalarProperty Name="CODE" ColumnName="CODE" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="MEDIA_PURPOSES"> <EntityTypeMapping TypeName="RemoteModel.MEDIA_PURPOSES"> <MappingFragment StoreEntitySet="MEDIA_PURPOSES"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="NAME" ColumnName="NAME" /> <ScalarProperty Name="CODE" ColumnName="CODE" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="ORGANIZATIONS"> <EntityTypeMapping TypeName="RemoteModel.ORGANIZATION"> <MappingFragment StoreEntitySet="ORGANIZATIONS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="NAME" ColumnName="NAME" /> - <ScalarProperty Name="CONTACT_ID" ColumnName="CONTACT_ID" /> <ScalarProperty Name="ADDRESS_ID" ColumnName="ADDRESS_ID" /> + <ScalarProperty Name="CONTACT_ID" ColumnName="CONTACT_ID" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="PERMISSIONS"> <EntityTypeMapping TypeName="RemoteModel.PERMISSION"> <MappingFragment StoreEntitySet="PERMISSIONS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="NAME" ColumnName="NAME" /> <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <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="RemoteModel.RML"> <MappingFragment StoreEntitySet="RML"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="MANUFACTURER" ColumnName="MANUFACTURER" /> - <ScalarProperty Name="MATERIAL_ID" ColumnName="MATERIAL_ID" /> - <ScalarProperty Name="COLOR_ID" ColumnName="COLOR_ID" /> - <ScalarProperty Name="PURPOSE_ID" ColumnName="PURPOSE_ID" /> - <ScalarProperty Name="CONDITION_ID" ColumnName="CONDITION_ID" /> - <ScalarProperty Name="LINEAR_MASS_DENSITY_UNIT_ID" ColumnName="LINEAR_MASS_DENSITY_UNIT_ID" /> - <ScalarProperty Name="FIBER_SHAPE_ID" ColumnName="FIBER_SHAPE_ID" /> - <ScalarProperty Name="FIBER_SYNTHESIS_ID" ColumnName="FIBER_SYNTHESIS_ID" /> - <ScalarProperty Name="FIBER_SIZE" ColumnName="FIBER_SIZE" /> - <ScalarProperty Name="NUMBER_OF_FIBERS" ColumnName="NUMBER_OF_FIBERS" /> - <ScalarProperty Name="PLIES_PER_FIBER" ColumnName="PLIES_PER_FIBER" /> - <ScalarProperty Name="PLIES_PER_THREAD" ColumnName="PLIES_PER_THREAD" /> - <ScalarProperty Name="TWISTED" ColumnName="TWISTED" /> - <ScalarProperty Name="AIR_ENTANGLEMENT" ColumnName="AIR_ENTANGLEMENT" /> - <ScalarProperty Name="LUBRICANT" ColumnName="LUBRICANT" /> - <ScalarProperty Name="TENSILE_STRENGTH" ColumnName="TENSILE_STRENGTH" /> - <ScalarProperty Name="ELONGATION_AT_BREAK_PERCENTAGE" ColumnName="ELONGATION_AT_BREAK_PERCENTAGE" /> <ScalarProperty Name="ESTIMATED_THREAD_DIAMETER" ColumnName="ESTIMATED_THREAD_DIAMETER" /> + <ScalarProperty Name="ELONGATION_AT_BREAK_PERCENTAGE" ColumnName="ELONGATION_AT_BREAK_PERCENTAGE" /> + <ScalarProperty Name="TENSILE_STRENGTH" ColumnName="TENSILE_STRENGTH" /> + <ScalarProperty Name="LUBRICANT" ColumnName="LUBRICANT" /> + <ScalarProperty Name="AIR_ENTANGLEMENT" ColumnName="AIR_ENTANGLEMENT" /> + <ScalarProperty Name="TWISTED" ColumnName="TWISTED" /> + <ScalarProperty Name="PLIES_PER_THREAD" ColumnName="PLIES_PER_THREAD" /> + <ScalarProperty Name="PLIES_PER_FIBER" ColumnName="PLIES_PER_FIBER" /> + <ScalarProperty Name="NUMBER_OF_FIBERS" ColumnName="NUMBER_OF_FIBERS" /> + <ScalarProperty Name="FIBER_SIZE" ColumnName="FIBER_SIZE" /> + <ScalarProperty Name="FIBER_SYNTHESIS_ID" ColumnName="FIBER_SYNTHESIS_ID" /> + <ScalarProperty Name="FIBER_SHAPE_ID" ColumnName="FIBER_SHAPE_ID" /> + <ScalarProperty Name="LINEAR_MASS_DENSITY_UNIT_ID" ColumnName="LINEAR_MASS_DENSITY_UNIT_ID" /> + <ScalarProperty Name="CONDITION_ID" ColumnName="CONDITION_ID" /> + <ScalarProperty Name="PURPOSE_ID" ColumnName="PURPOSE_ID" /> + <ScalarProperty Name="COLOR_ID" ColumnName="COLOR_ID" /> + <ScalarProperty Name="MATERIAL_ID" ColumnName="MATERIAL_ID" /> + <ScalarProperty Name="MANUFACTURER" ColumnName="MANUFACTURER" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="ROLES"> <EntityTypeMapping TypeName="RemoteModel.ROLE"> <MappingFragment StoreEntitySet="ROLES"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="NAME" ColumnName="NAME" /> <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="ROLES_PERMISSIONS"> <EntityTypeMapping TypeName="RemoteModel.ROLES_PERMISSIONS"> <MappingFragment StoreEntitySet="ROLES_PERMISSIONS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="ROLE_ID" ColumnName="ROLE_ID" /> <ScalarProperty Name="PERMISSION_ID" ColumnName="PERMISSION_ID" /> + <ScalarProperty Name="ROLE_ID" ColumnName="ROLE_ID" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="USERS"> <EntityTypeMapping TypeName="RemoteModel.USER"> <MappingFragment StoreEntitySet="USERS"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="EMAIL" ColumnName="EMAIL" /> - <ScalarProperty Name="PASSWORD" ColumnName="PASSWORD" /> - <ScalarProperty Name="ORGANIZATION_ID" ColumnName="ORGANIZATION_ID" /> - <ScalarProperty Name="CONTACT_ID" ColumnName="CONTACT_ID" /> <ScalarProperty Name="ADDRESS_ID" ColumnName="ADDRESS_ID" /> + <ScalarProperty Name="CONTACT_ID" ColumnName="CONTACT_ID" /> + <ScalarProperty Name="ORGANIZATION_ID" ColumnName="ORGANIZATION_ID" /> + <ScalarProperty Name="PASSWORD" ColumnName="PASSWORD" /> + <ScalarProperty Name="EMAIL" ColumnName="EMAIL" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="USERS_ROLES"> <EntityTypeMapping TypeName="RemoteModel.USERS_ROLES"> <MappingFragment StoreEntitySet="USERS_ROLES"> - <ScalarProperty Name="ID" ColumnName="ID" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="DELETED" ColumnName="DELETED" /> - <ScalarProperty Name="USER_ID" ColumnName="USER_ID" /> <ScalarProperty Name="ROLE_ID" ColumnName="ROLE_ID" /> + <ScalarProperty Name="USER_ID" ColumnName="USER_ID" /> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx.diagram b/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx.diagram index 7a0050ae1..9a2df60b4 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx.diagram +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx.diagram @@ -5,79 +5,79 @@ <!-- Diagram content (shape and connector positions) --> <edmx:Diagrams> <Diagram DiagramId="f9ae01d708754bbd997add25a4bacc79" Name="Diagram1"> - <EntityTypeShape EntityType="RemoteModel.ACTION" Width="1.5" PointX="14.25" PointY="38.25" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.ADDRESS" Width="1.5" PointX="0.75" PointY="7.875" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.APPLICATION_DISPLAY_PANEL_VERSIONS" Width="1.5" PointX="8.25" PointY="12.375" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.APPLICATION_FIRMWARE_VERSIONS" Width="1.5" PointX="8.25" PointY="15" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.APPLICATION_OS_VERSIONS" Width="1.5" PointX="8.25" PointY="17.75" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.APPLICATION_VERSIONS" Width="1.5" PointX="8.25" PointY="20.5" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.CONFIGURATION" Width="1.5" PointX="10.5" PointY="6.875" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.CONFIGURATIONS_DISPENSERS" Width="1.5" PointX="15.75" PointY="8.125" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.CONTACT" Width="1.5" PointX="0.75" PointY="2.875" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.DISPENSER" Width="1.5" PointX="13.5" PointY="0.75" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.EMBEDDED_FIRMWARE_VERSIONS" Width="1.5" PointX="8.25" PointY="23.25" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.EMBEDDED_SOFTWARE_VERSIONS" Width="1.5" PointX="8.25" PointY="26" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.EVENT" Width="1.5" PointX="11.25" PointY="3.25" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.EVENTS_ACTIONS" Width="1.5" PointX="16.5" PointY="3.25" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.FIBER_SHAPES" Width="1.5" PointX="15.75" PointY="15" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.FIBER_SYNTHESIS" Width="1.5" PointX="15.75" PointY="19.375" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.HARDWARE_VERSIONS" Width="1.5" PointX="8.25" PointY="28.75" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.LINEAR_MASS_DENSITY_UNITS" Width="1.5" PointX="15.75" PointY="22.375" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.LIQUID_TYPES" Width="1.5" PointX="11.25" PointY="15.625" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.LIQUID" Width="1.5" PointX="13.5" PointY="15.5" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.LIQUIDS_RML" Width="1.5" PointX="20.25" PointY="14.875" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.MACHINE_VERSIONS" Width="1.5" PointX="12.75" PointY="12" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.MACHINE" Width="1.5" PointX="5.25" PointY="7.875" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.MACHINES_EVENTS" Width="1.5" PointX="13.5" PointY="7.875" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.MEDIA_COLORS" Width="1.5" PointX="15.75" PointY="25.5" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.MEDIA_CONDITIONS" Width="1.5" PointX="15.75" PointY="28.5" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.MEDIA_MATERIALS" Width="1.5" PointX="15.75" PointY="31.625" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.MEDIA_PURPOSES" Width="1.5" PointX="15.75" PointY="34.75" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.ORGANIZATION" Width="1.5" PointX="3" PointY="8" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.PERMISSION" Width="1.5" PointX="11.25" PointY="23.375" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.RML" Width="1.5" PointX="18" PointY="12.75" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.ROLE" Width="1.5" PointX="11.25" PointY="19.25" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.ROLES_PERMISSIONS" Width="1.5" PointX="13.5" PointY="19.25" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.USER" Width="1.5" PointX="8.25" PointY="7.75" IsExpanded="true" /> - <EntityTypeShape EntityType="RemoteModel.USERS_ROLES" Width="1.5" PointX="13.5" PointY="4.25" IsExpanded="true" /> - <AssociationConnector Association="RemoteModel.FK_EVENTS_ACTIONS_ACTIONS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_ORGANIZATIONS_ADDRESSES" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_USERS_ADDRESSES" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_APPLICATION_DISPLAY_PANEL_VERSIONS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_APPLICATION_FIRMWARE_VERSIONS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_APPLICATION_OS_VERSIONS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_APPLICATION_VERSIONS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_CONFIGURATIONS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_EMBEDDED_FIRMWARE_VERSIONS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_EMBEDDED_SOFTWARE_VERSIONS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_HARDWARE_VERSIONS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_MACHINES" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_MACHINE_VERSIONS_CONFIGURATIONS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_DISPENSERS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_LIQUIDS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_ORGANIZATIONS_CONTACTS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_USERS_CONTACTS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_EVENTS_ACTIONS_EVENTS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_MACHINES_EVENTS_EVENTS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_RML_FIBER_SHAPES" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_RML_FIBER_SYNTHESIS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_RML_LINEAR_MASS_DENSITY_UNITS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_LIQUIDS_LIQUID_TYPES" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_LIQUID_RML_LIQUIDS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_LIQUID_RML_RML" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_MACHINES_MACHINE_VERSIONS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_MACHINE_EVENTS_MACHINES" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_MACHINES_ORGANIZATIONS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_MACHINES_EVENTS_USERS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_RML_MEDIA_COLORS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_RML_MEDIA_CONDITIONS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_RML_MEDIA_MATERIALS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_RML_MEDIA_PURPOSES" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_USERS_ORGANIZATIONS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_ROLES_PERMISSIONS_PERMISSIONS" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_ROLES_PERMISSIONS_ROLES" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_USERS_ROLES_ROLES" ManuallyRouted="false" /> - <AssociationConnector Association="RemoteModel.FK_USERS_ROLES_USERS" ManuallyRouted="false" /> + <EntityTypeShape EntityType="RemoteModel.ACTION" Width="1.5" PointX="14.25" PointY="38.25" /> + <EntityTypeShape EntityType="RemoteModel.ADDRESS" Width="1.5" PointX="0.75" PointY="7.875" /> + <EntityTypeShape EntityType="RemoteModel.APPLICATION_DISPLAY_PANEL_VERSIONS" Width="1.5" PointX="8.25" PointY="17.75" /> + <EntityTypeShape EntityType="RemoteModel.APPLICATION_FIRMWARE_VERSIONS" Width="1.5" PointX="8.25" PointY="28.75" /> + <EntityTypeShape EntityType="RemoteModel.APPLICATION_OS_VERSIONS" Width="1.5" PointX="8.25" PointY="26" /> + <EntityTypeShape EntityType="RemoteModel.APPLICATION_VERSIONS" Width="1.5" PointX="8.25" PointY="20.5" /> + <EntityTypeShape EntityType="RemoteModel.CONFIGURATION" Width="1.5" PointX="10.5" PointY="6.875" /> + <EntityTypeShape EntityType="RemoteModel.CONFIGURATIONS_DISPENSERS" Width="1.5" PointX="15.75" PointY="8.125" /> + <EntityTypeShape EntityType="RemoteModel.CONTACT" Width="1.5" PointX="0.75" PointY="2.875" /> + <EntityTypeShape EntityType="RemoteModel.DISPENSER" Width="1.5" PointX="13.5" PointY="0.75" /> + <EntityTypeShape EntityType="RemoteModel.EMBEDDED_FIRMWARE_VERSIONS" Width="1.5" PointX="8.25" PointY="15" /> + <EntityTypeShape EntityType="RemoteModel.EMBEDDED_SOFTWARE_VERSIONS" Width="1.5" PointX="8.25" PointY="12.375" /> + <EntityTypeShape EntityType="RemoteModel.EVENT" Width="1.5" PointX="11.25" PointY="3.25" /> + <EntityTypeShape EntityType="RemoteModel.EVENTS_ACTIONS" Width="1.5" PointX="16.5" PointY="3.25" /> + <EntityTypeShape EntityType="RemoteModel.FIBER_SHAPES" Width="1.5" PointX="15.75" PointY="34.75" /> + <EntityTypeShape EntityType="RemoteModel.FIBER_SYNTHESIS" Width="1.5" PointX="15.75" PointY="31.625" /> + <EntityTypeShape EntityType="RemoteModel.HARDWARE_VERSIONS" Width="1.5" PointX="8.25" PointY="23.25" /> + <EntityTypeShape EntityType="RemoteModel.LINEAR_MASS_DENSITY_UNITS" Width="1.5" PointX="15.75" PointY="28.5" /> + <EntityTypeShape EntityType="RemoteModel.LIQUID_TYPES" Width="1.5" PointX="11.25" PointY="15.625" /> + <EntityTypeShape EntityType="RemoteModel.LIQUID" Width="1.5" PointX="13.5" PointY="15.5" /> + <EntityTypeShape EntityType="RemoteModel.LIQUIDS_RML" Width="1.5" PointX="20.25" PointY="14.875" /> + <EntityTypeShape EntityType="RemoteModel.MACHINE_VERSIONS" Width="1.5" PointX="12.75" PointY="12" /> + <EntityTypeShape EntityType="RemoteModel.MACHINE" Width="1.5" PointX="5.25" PointY="7.875" /> + <EntityTypeShape EntityType="RemoteModel.MACHINES_EVENTS" Width="1.5" PointX="13.5" PointY="7.875" /> + <EntityTypeShape EntityType="RemoteModel.MEDIA_COLORS" Width="1.5" PointX="15.75" PointY="19.375" /> + <EntityTypeShape EntityType="RemoteModel.MEDIA_CONDITIONS" Width="1.5" PointX="15.75" PointY="25.375" /> + <EntityTypeShape EntityType="RemoteModel.MEDIA_MATERIALS" Width="1.5" PointX="15.75" PointY="15" /> + <EntityTypeShape EntityType="RemoteModel.MEDIA_PURPOSES" Width="1.5" PointX="15.75" PointY="22.25" /> + <EntityTypeShape EntityType="RemoteModel.ORGANIZATION" Width="1.5" PointX="3" PointY="8" /> + <EntityTypeShape EntityType="RemoteModel.PERMISSION" Width="1.5" PointX="11.25" PointY="23.375" /> + <EntityTypeShape EntityType="RemoteModel.RML" Width="1.5" PointX="18" PointY="12.75" /> + <EntityTypeShape EntityType="RemoteModel.ROLE" Width="1.5" PointX="11.25" PointY="19.25" /> + <EntityTypeShape EntityType="RemoteModel.ROLES_PERMISSIONS" Width="1.5" PointX="13.5" PointY="19.25" /> + <EntityTypeShape EntityType="RemoteModel.USER" Width="1.5" PointX="8.25" PointY="7.75" /> + <EntityTypeShape EntityType="RemoteModel.USERS_ROLES" Width="1.5" PointX="13.5" PointY="4.25" /> + <AssociationConnector Association="RemoteModel.FK_EVENTS_ACTIONS_ACTIONS" /> + <AssociationConnector Association="RemoteModel.FK_ORGANIZATIONS_ADDRESSES" /> + <AssociationConnector Association="RemoteModel.FK_USERS_ADDRESSES" /> + <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_APPLICATION_DISPLAY_PANEL_VERSIONS" /> + <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_APPLICATION_FIRMWARE_VERSIONS" /> + <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_APPLICATION_OS_VERSIONS" /> + <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_APPLICATION_VERSIONS" /> + <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_CONFIGURATIONS" /> + <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_EMBEDDED_FIRMWARE_VERSIONS" /> + <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_EMBEDDED_SOFTWARE_VERSIONS" /> + <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_HARDWARE_VERSIONS" /> + <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_MACHINES" /> + <AssociationConnector Association="RemoteModel.FK_MACHINE_VERSIONS_CONFIGURATIONS" /> + <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_DISPENSERS" /> + <AssociationConnector Association="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_LIQUIDS" /> + <AssociationConnector Association="RemoteModel.FK_ORGANIZATIONS_CONTACTS" /> + <AssociationConnector Association="RemoteModel.FK_USERS_CONTACTS" /> + <AssociationConnector Association="RemoteModel.FK_EVENTS_ACTIONS_EVENTS" /> + <AssociationConnector Association="RemoteModel.FK_MACHINES_EVENTS_EVENTS" /> + <AssociationConnector Association="RemoteModel.FK_RML_FIBER_SHAPES" /> + <AssociationConnector Association="RemoteModel.FK_RML_FIBER_SYNTHESIS" /> + <AssociationConnector Association="RemoteModel.FK_RML_LINEAR_MASS_DENSITY_UNITS" /> + <AssociationConnector Association="RemoteModel.FK_LIQUIDS_LIQUID_TYPES" /> + <AssociationConnector Association="RemoteModel.FK_LIQUID_RML_LIQUIDS" /> + <AssociationConnector Association="RemoteModel.FK_LIQUID_RML_RML" /> + <AssociationConnector Association="RemoteModel.FK_MACHINES_MACHINE_VERSIONS" /> + <AssociationConnector Association="RemoteModel.FK_MACHINE_EVENTS_MACHINES" /> + <AssociationConnector Association="RemoteModel.FK_MACHINES_ORGANIZATIONS" /> + <AssociationConnector Association="RemoteModel.FK_MACHINES_EVENTS_USERS" /> + <AssociationConnector Association="RemoteModel.FK_RML_MEDIA_COLORS" /> + <AssociationConnector Association="RemoteModel.FK_RML_MEDIA_CONDITIONS" /> + <AssociationConnector Association="RemoteModel.FK_RML_MEDIA_MATERIALS" /> + <AssociationConnector Association="RemoteModel.FK_RML_MEDIA_PURPOSES" /> + <AssociationConnector Association="RemoteModel.FK_USERS_ORGANIZATIONS" /> + <AssociationConnector Association="RemoteModel.FK_ROLES_PERMISSIONS_PERMISSIONS" /> + <AssociationConnector Association="RemoteModel.FK_ROLES_PERMISSIONS_ROLES" /> + <AssociationConnector Association="RemoteModel.FK_USERS_ROLES_ROLES" /> + <AssociationConnector Association="RemoteModel.FK_USERS_ROLES_USERS" /> </Diagram> </edmx:Diagrams> </edmx:Designer> diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/USER.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/USER.cs index 6307c9f9b..fe07de059 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/USER.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/USER.cs @@ -22,7 +22,7 @@ namespace Tango.DAL.Remote.DB } public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public string EMAIL { get; set; } diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/USERS_ROLES.cs b/Software/Visual_Studio/Tango.DAL.Remote/DB/USERS_ROLES.cs index 30a5cf961..407449350 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/USERS_ROLES.cs +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/USERS_ROLES.cs @@ -15,7 +15,7 @@ namespace Tango.DAL.Remote.DB public partial class USERS_ROLES { public int ID { get; set; } - public System.Guid GUID { get; set; } + public string GUID { get; set; } public System.DateTime LAST_UPDATED { get; set; } public bool DELETED { get; set; } public int USER_ID { get; set; } diff --git a/Software/Visual_Studio/Tango.Synchronization/SqlDiff.cs b/Software/Visual_Studio/Tango.Synchronization/Diff.cs index b5a274cdc..45bd1581c 100644 --- a/Software/Visual_Studio/Tango.Synchronization/SqlDiff.cs +++ b/Software/Visual_Studio/Tango.Synchronization/Diff.cs @@ -7,16 +7,16 @@ using System.Threading.Tasks; namespace Tango.Synchronization { /// <summary> - /// Represents an <see cref="SqlDataBaseComparer.Compare"/> result. + /// Represents an <see cref="LocalDBComparer.Compare"/> result. /// </summary> - public class SqlDiff + public class Diff { private Action _action; /// <summary> /// Gets the difference action. /// </summary> - public SqlDiffAction Action { get; private set; } + public DiffAction Action { get; private set; } /// <summary> /// Gets the difference description. @@ -29,13 +29,13 @@ namespace Tango.Synchronization public String Command { get; private set; } /// <summary> - /// Initializes a new instance of the <see cref="SqlDiff"/> class. + /// Initializes a new instance of the <see cref="Diff"/> class. /// </summary> /// <param name="dataBaseAction">The data base action.</param> /// <param name="description">The description.</param> /// <param name="action">The action.</param> /// <param name="command">The command.</param> - public SqlDiff(SqlDiffAction dataBaseAction, String description, Action action, String command) + public Diff(DiffAction dataBaseAction, String description, Action action, String command) { Action = dataBaseAction; Description = description; diff --git a/Software/Visual_Studio/Tango.Synchronization/SqlDiffAction.cs b/Software/Visual_Studio/Tango.Synchronization/DiffAction.cs index 798be78d8..2395d819c 100644 --- a/Software/Visual_Studio/Tango.Synchronization/SqlDiffAction.cs +++ b/Software/Visual_Studio/Tango.Synchronization/DiffAction.cs @@ -8,9 +8,9 @@ using System.Threading.Tasks; namespace Tango.Synchronization { /// <summary> - /// Represents the type of <see cref="SqlDiff"/>. + /// Represents the type of <see cref="Diff"/>. /// </summary> - public enum SqlDiffAction + public enum DiffAction { /// <summary> /// Add table to slave diff --git a/Software/Visual_Studio/Tango.Synchronization/Constants.cs b/Software/Visual_Studio/Tango.Synchronization/Local/Constants.cs index 3558fd506..ed8084301 100644 --- a/Software/Visual_Studio/Tango.Synchronization/Constants.cs +++ b/Software/Visual_Studio/Tango.Synchronization/Local/Constants.cs @@ -4,7 +4,7 @@ using System.Linq; using System.Text; using System.Threading.Tasks; -namespace Tango.Synchronization +namespace Tango.Synchronization.Local { internal static class Constants { diff --git a/Software/Visual_Studio/Tango.Synchronization/ExtensionMethods.cs b/Software/Visual_Studio/Tango.Synchronization/Local/ExtensionMethods.cs index 7f16f7006..8746f9146 100644 --- a/Software/Visual_Studio/Tango.Synchronization/ExtensionMethods.cs +++ b/Software/Visual_Studio/Tango.Synchronization/Local/ExtensionMethods.cs @@ -6,7 +6,7 @@ using System.Linq; using System.Text; using System.Threading.Tasks; -namespace Tango.Synchronization +namespace Tango.Synchronization.Local { internal static class SQLExtensions { diff --git a/Software/Visual_Studio/Tango.Synchronization/ISqlDataBase.cs b/Software/Visual_Studio/Tango.Synchronization/Local/ILocalDataBase.cs index fa4e018be..7e53aeb1c 100644 --- a/Software/Visual_Studio/Tango.Synchronization/ISqlDataBase.cs +++ b/Software/Visual_Studio/Tango.Synchronization/Local/ILocalDataBase.cs @@ -5,13 +5,13 @@ using System.Linq; using System.Text; using System.Threading.Tasks; -namespace Tango.Synchronization +namespace Tango.Synchronization.Local { /// <summary> - /// Represents an SQL data base adapter used by <see cref="SqlDataBaseComparer"/>. + /// Represents an SQL data base adapter used by <see cref="LocalDBComparer"/>. /// </summary> /// <seealso cref="System.IDisposable" /> - public interface ISqlDataBase : IDisposable + public interface ILocalDataBase : IDisposable { /// <summary> /// Gets the database source URL/File. @@ -34,15 +34,15 @@ namespace Tango.Synchronization /// <param name="otherDB">The other database.</param> /// <param name="otherTable">The other table.</param> /// <returns></returns> - DataTable CloneTableFrom(ISqlDataBase otherDB, DataTable otherTable); + DataTable CloneTableFrom(ILocalDataBase otherDB, DataTable otherTable); /// <summary> - /// Gets the SQL command for <see cref="CloneTableFrom(ISqlDataBase, DataTable)"/>. + /// Gets the SQL command for <see cref="CloneTableFrom(ILocalDataBase, DataTable)"/>. /// </summary> /// <param name="otherDB">The other database.</param> /// <param name="otherTable">The other table.</param> /// <returns></returns> - String GetCloneTableFromCommand(ISqlDataBase otherDB, DataTable otherTable); + String GetCloneTableFromCommand(ILocalDataBase otherDB, DataTable otherTable); /// <summary> /// Adds the specified column to the specified table. diff --git a/Software/Visual_Studio/Tango.Synchronization/SqlDataBaseComparer.cs b/Software/Visual_Studio/Tango.Synchronization/Local/LocalDBComparer.cs index 980a23f1e..63f2ecfaa 100644 --- a/Software/Visual_Studio/Tango.Synchronization/SqlDataBaseComparer.cs +++ b/Software/Visual_Studio/Tango.Synchronization/Local/LocalDBComparer.cs @@ -7,40 +7,40 @@ using System.Text; using System.Threading.Tasks; using Tango.Logging; -namespace Tango.Synchronization +namespace Tango.Synchronization.Local { /// <summary> - /// Represents an <see cref="ISqlDataBase"/> synchronization engine. + /// Represents an <see cref="ILocalDataBase"/> synchronization engine. /// </summary> /// <seealso cref="System.IDisposable" /> - public class SqlDataBaseComparer : IDisposable + public class LocalDBComparer : IDisposable { /// <summary> /// Gets the master SQL. /// </summary> - public ISqlDataBase MasterSQL { get; private set; } + public ILocalDataBase MasterSQL { get; private set; } /// <summary> /// Gets the slave SQL. /// </summary> - public ISqlDataBase SlaveSQL { get; private set; } + public ILocalDataBase SlaveSQL { get; private set; } /// <summary> - /// Initializes a new instance of the <see cref="SqlDataBaseComparer"/> class. + /// Initializes a new instance of the <see cref="LocalDBComparer"/> class. /// </summary> /// <param name="masterSQL">The master SQL.</param> /// <param name="slaveSQL">The slave SQL.</param> - public SqlDataBaseComparer(ISqlDataBase masterSQL, ISqlDataBase slaveSQL) + public LocalDBComparer(ILocalDataBase masterSQL, ILocalDataBase slaveSQL) { MasterSQL = masterSQL; SlaveSQL = slaveSQL; } /// <summary> - /// Compares the master and slave SQL data base and returns a collection of <see cref="SqlDiff"/>. + /// Compares the master and slave SQL data base and returns a collection of <see cref="Diff"/>. /// </summary> /// <returns></returns> - public List<SqlDiff> Compare() + public List<Diff> Compare() { LogManager.Log("Comparing databases " + Path.GetFileName(MasterSQL.Source) + " <=> " + Path.GetFileName(SlaveSQL.Source)); @@ -50,7 +50,7 @@ namespace Tango.Synchronization LogManager.Log("Loading slave tables..."); SlaveSQL.LoadTables(); - List<SqlDiff> diffs = new List<SqlDiff>(); + List<Diff> diffs = new List<Diff>(); foreach (var masterTable in MasterSQL.Tables) { @@ -63,7 +63,7 @@ namespace Tango.Synchronization { LogManager.Log("Table not found on slave, adding difference."); //Clone table from slave db to master db including records! - diffs.Add(new SqlDiff(SqlDiffAction.AddTableToSlave, String.Format("Add table {0} to slave", masterTable.TableName), () => SlaveSQL.CloneTableFrom(MasterSQL, masterTable), SlaveSQL.GetCloneTableFromCommand(MasterSQL, masterTable))); + diffs.Add(new Diff(DiffAction.AddTableToSlave, String.Format("Add table {0} to slave", masterTable.TableName), () => SlaveSQL.CloneTableFrom(MasterSQL, masterTable), SlaveSQL.GetCloneTableFromCommand(MasterSQL, masterTable))); continue; } @@ -79,7 +79,7 @@ namespace Tango.Synchronization { LogManager.Log("Column not found on slave, adding difference."); //Add column to slave table. - diffs.Add(new SqlDiff(SqlDiffAction.AddColumnToSlave, String.Format("Add column {0} to slave table", masterColumn.ColumnName), () => SlaveSQL.AddColumn(masterTable, masterColumn), SlaveSQL.GetAddColumnCommand(masterTable, masterColumn))); + diffs.Add(new Diff(DiffAction.AddColumnToSlave, String.Format("Add column {0} to slave table", masterColumn.ColumnName), () => SlaveSQL.AddColumn(masterTable, masterColumn), SlaveSQL.GetAddColumnCommand(masterTable, masterColumn))); } LogManager.Log("Column found."); @@ -162,22 +162,22 @@ namespace Tango.Synchronization foreach (var row in addToSlave) { - diffs.Add(new SqlDiff(SqlDiffAction.AddRowToSlave, String.Format("Add row to slave table {0}", slaveTable.TableName), () => SlaveSQL.AddRow(slaveTable, row), SlaveSQL.GetAddRowCommand(slaveTable, row))); + diffs.Add(new Diff(DiffAction.AddRowToSlave, String.Format("Add row to slave table {0}", slaveTable.TableName), () => SlaveSQL.AddRow(slaveTable, row), SlaveSQL.GetAddRowCommand(slaveTable, row))); } foreach (var row in addToMaster) { - diffs.Add(new SqlDiff(SqlDiffAction.AddRowToMaster, String.Format("Add row to master table {0}", masterTable.TableName), () => MasterSQL.AddRow(masterTable, row), MasterSQL.GetAddRowCommand(masterTable, row))); + diffs.Add(new Diff(DiffAction.AddRowToMaster, String.Format("Add row to master table {0}", masterTable.TableName), () => MasterSQL.AddRow(masterTable, row), MasterSQL.GetAddRowCommand(masterTable, row))); } foreach (var row in updateSlave) { - diffs.Add(new SqlDiff(SqlDiffAction.UpdateRowInSlave, String.Format("Update row in slave table {0}", slaveTable.TableName), () => SlaveSQL.UpdateRow(slaveTable, row), SlaveSQL.GetUpdateRowCommand(slaveTable, row))); + diffs.Add(new Diff(DiffAction.UpdateRowInSlave, String.Format("Update row in slave table {0}", slaveTable.TableName), () => SlaveSQL.UpdateRow(slaveTable, row), SlaveSQL.GetUpdateRowCommand(slaveTable, row))); } foreach (var row in updateMaster) { - diffs.Add(new SqlDiff(SqlDiffAction.UpdateRowInMaster, String.Format("Update row in master table {0}", masterTable.TableName), () => MasterSQL.UpdateRow(masterTable, row), MasterSQL.GetUpdateRowCommand(masterTable, row))); + diffs.Add(new Diff(DiffAction.UpdateRowInMaster, String.Format("Update row in master table {0}", masterTable.TableName), () => MasterSQL.UpdateRow(masterTable, row), MasterSQL.GetUpdateRowCommand(masterTable, row))); } LogManager.Log("Done comparing table " + masterTable.TableName); diff --git a/Software/Visual_Studio/Tango.Synchronization/SqliteDataBase.cs b/Software/Visual_Studio/Tango.Synchronization/Local/SqliteDataBase.cs index 75259fc28..35e54c66a 100644 --- a/Software/Visual_Studio/Tango.Synchronization/SqliteDataBase.cs +++ b/Software/Visual_Studio/Tango.Synchronization/Local/SqliteDataBase.cs @@ -9,13 +9,13 @@ using System.Linq; using System.Text; using System.Threading.Tasks; -namespace Tango.Synchronization +namespace Tango.Synchronization.Local { /// <summary> - /// Represents an SQLite database adapter used for synchronization by <see cref="SqlDataBaseComparer"/>. + /// Represents an SQLite database adapter used for synchronization by <see cref="LocalDBComparer"/>. /// </summary> /// <seealso cref="Tango.Synchronization.ISqlDataBase" /> - public class SqliteDataBase : ISqlDataBase + public class SQLiteDataBase : ILocalDataBase { private SQLiteConnection _connection; @@ -30,10 +30,10 @@ namespace Tango.Synchronization public List<DataTable> Tables { get; private set; } /// <summary> - /// Initializes a new instance of the <see cref="SqliteDataBase"/> class. + /// Initializes a new instance of the <see cref="SQLiteDataBase"/> class. /// </summary> /// <param name="filePath">The file path.</param> - public SqliteDataBase(String filePath) + public SQLiteDataBase(String filePath) { Source = filePath; @@ -105,7 +105,7 @@ namespace Tango.Synchronization /// <param name="otherDB">The other database.</param> /// <param name="otherTable">The other table.</param> /// <returns></returns> - public DataTable CloneTableFrom(ISqlDataBase otherDB, DataTable otherTable) + public DataTable CloneTableFrom(ILocalDataBase otherDB, DataTable otherTable) { String cmd = String.Format("CREATE TABLE {0} (", otherTable.TableName); @@ -148,12 +148,12 @@ namespace Tango.Synchronization } /// <summary> - /// Gets the SQL command for <see cref="CloneTableFrom(ISqlDataBase, DataTable)" />. + /// Gets the SQL command for <see cref="CloneTableFrom(ILocalDataBase, DataTable)" />. /// </summary> /// <param name="otherDB">The other database.</param> /// <param name="otherTable">The other table.</param> /// <returns></returns> - public String GetCloneTableFromCommand(ISqlDataBase otherDB, DataTable otherTable) + public String GetCloneTableFromCommand(ILocalDataBase otherDB, DataTable otherTable) { String cmd = String.Format("CREATE TABLE {0} (", otherTable.TableName); diff --git a/Software/Visual_Studio/Tango.Synchronization/Remote/RemoteDBComparer.cs b/Software/Visual_Studio/Tango.Synchronization/Remote/RemoteDBComparer.cs new file mode 100644 index 000000000..1635e6fa7 --- /dev/null +++ b/Software/Visual_Studio/Tango.Synchronization/Remote/RemoteDBComparer.cs @@ -0,0 +1,45 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; +using remote = Tango.DAL.Remote.DB; +using local = Tango.DAL.Local.DB; + +namespace Tango.Synchronization.Remote +{ + public class RemoteDBComparer : IDisposable + { + private remote.RemoteDB _remoteDB; + private local.LocalDB _localDB; + private String _machineSerial; + + public RemoteDBComparer(remote.RemoteDB remoteDB, local.LocalDB localDB,String machineSerial) + { + _machineSerial = machineSerial; + _remoteDB = remoteDB; + _localDB = localDB; + } + + public List<Diff> Compare() + { + List<Diff> diffs = new List<Diff>(); + + var remoteMachine = _remoteDB.MACHINES.SingleOrDefault(x => x.SERIAL_NUMBER == _machineSerial); + + + //var localMachine = _localDB.MACHINES.SingleOrDefault(x => x.Se) + + + + + return diffs; + } + + public void Dispose() + { + _remoteDB.Dispose(); + _localDB.Dispose(); + } + } +} diff --git a/Software/Visual_Studio/Tango.Synchronization/Tango.Synchronization.csproj b/Software/Visual_Studio/Tango.Synchronization/Tango.Synchronization.csproj index 98a5044ce..b94eec9fa 100644 --- a/Software/Visual_Studio/Tango.Synchronization/Tango.Synchronization.csproj +++ b/Software/Visual_Studio/Tango.Synchronization/Tango.Synchronization.csproj @@ -64,25 +64,35 @@ <Compile Include="..\Versioning\GlobalVersionInfo.cs"> <Link>GlobalVersionInfo.cs</Link> </Compile> - <Compile Include="Constants.cs" /> - <Compile Include="ExtensionMethods.cs" /> - <Compile Include="ISqlDataBase.cs" /> + <Compile Include="Local\Constants.cs" /> + <Compile Include="Local\ExtensionMethods.cs" /> + <Compile Include="Local\ILocalDataBase.cs" /> <Compile Include="Properties\AssemblyInfo.cs" /> - <Compile Include="SqlDataBaseComparer.cs" /> - <Compile Include="SqlDiff.cs" /> - <Compile Include="SqlDiffAction.cs" /> - <Compile Include="SqliteDataBase.cs" /> + <Compile Include="Local\LocalDBComparer.cs" /> + <Compile Include="Diff.cs" /> + <Compile Include="DiffAction.cs" /> + <Compile Include="Local\SQLiteDataBase.cs" /> + <Compile Include="Remote\RemoteDBComparer.cs" /> </ItemGroup> <ItemGroup> <None Include="App.config" /> <None Include="packages.config" /> </ItemGroup> <ItemGroup> + <ProjectReference Include="..\Tango.DAL.Local\Tango.DAL.Local.csproj"> + <Project>{0e0eef3e-8f4e-4f23-9d19-479fd8d76c12}</Project> + <Name>Tango.DAL.Local</Name> + </ProjectReference> + <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.Logging\Tango.Logging.csproj"> <Project>{bc932dbd-7cdb-488c-99e4-f02cf441f55e}</Project> <Name>Tango.Logging</Name> </ProjectReference> </ItemGroup> + <ItemGroup /> <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" /> <Import Project="..\packages\System.Data.SQLite.Core.1.0.106.0\build\net46\System.Data.SQLite.Core.targets" Condition="Exists('..\packages\System.Data.SQLite.Core.1.0.106.0\build\net46\System.Data.SQLite.Core.targets')" /> <Target Name="EnsureNuGetPackageBuildImports" BeforeTargets="PrepareForBuild"> diff --git a/Software/Visual_Studio/Tango.UnitTesting/DAL_TST.cs b/Software/Visual_Studio/Tango.UnitTesting/DAL_TST.cs index b56f04c70..a04e5605d 100644 --- a/Software/Visual_Studio/Tango.UnitTesting/DAL_TST.cs +++ b/Software/Visual_Studio/Tango.UnitTesting/DAL_TST.cs @@ -12,7 +12,7 @@ namespace Tango.UnitTesting [TestMethod] public void Validate_Server_SQLServer_Connection() { - Guid guid = Guid.NewGuid(); + String guid = Guid.NewGuid().ToString(); using (var db = new DAL.Remote.DB.RemoteDB("LOCALHOST\\SQLEXPRESS", false)) { diff --git a/Software/Visual_Studio/Tango.UnitTesting/Protobuf_TST.cs b/Software/Visual_Studio/Tango.UnitTesting/Protobuf_TST.cs index ed3bfbb7d..b6304d451 100644 --- a/Software/Visual_Studio/Tango.UnitTesting/Protobuf_TST.cs +++ b/Software/Visual_Studio/Tango.UnitTesting/Protobuf_TST.cs @@ -97,7 +97,7 @@ namespace Tango.UnitTesting } /// <summary> - /// Calls a C++ native library and get a result. + /// Calls a C++ native library using protobuf and gets a result. /// </summary> [TestMethod] public void Call_CPP_And_Get_Result() diff --git a/Software/Visual_Studio/Utilities/Tango.Synchronization.UI/ViewModels/MainViewVM.cs b/Software/Visual_Studio/Utilities/Tango.Synchronization.UI/ViewModels/MainViewVM.cs index d388d761f..8d18e5ce7 100644 --- a/Software/Visual_Studio/Utilities/Tango.Synchronization.UI/ViewModels/MainViewVM.cs +++ b/Software/Visual_Studio/Utilities/Tango.Synchronization.UI/ViewModels/MainViewVM.cs @@ -11,6 +11,7 @@ using System.Windows; using Tango.Logging; using Tango.SharedUI; using Tango.SharedUI.Commands; +using Tango.Synchronization.Local; namespace Tango.Synchronization.UI.ViewModels { @@ -18,7 +19,7 @@ namespace Tango.Synchronization.UI.ViewModels { private String _masterDBFile; private String _slaveDBFile; - private SqlDataBaseComparer _comparer; + private LocalDBComparer _comparer; #region Properties @@ -52,21 +53,21 @@ namespace Tango.Synchronization.UI.ViewModels set { _log = value; RaisePropertyChanged(nameof(Log)); } } - private ObservableCollection<SqlDiff> _differences; + private ObservableCollection<Diff> _differences; /// <summary> /// Gets or sets the differences. /// </summary> - public ObservableCollection<SqlDiff> Differences + public ObservableCollection<Diff> Differences { get { return _differences; } set { _differences = value; RaisePropertyChanged(nameof(Differences)); } } - private SqlDiff _selectedDifference; + private Diff _selectedDifference; /// <summary> /// Gets or sets the selected difference. /// </summary> - public SqlDiff SelectedDifference + public Diff SelectedDifference { get { return _selectedDifference; } set { _selectedDifference = value; RaisePropertyChanged(nameof(SelectedDifference)); InvalidateRelayCommands(); } @@ -140,7 +141,7 @@ namespace Tango.Synchronization.UI.ViewModels LogManager.Log("DB Synchronizer Started!"); - Differences = new ObservableCollection<SqlDiff>(); + Differences = new ObservableCollection<Diff>(); BrowseMasterDBCommand = new RelayCommand(BrowseMasterDB); BrowseSlaveDBCommand = new RelayCommand(BrowseSlaveDB); @@ -162,7 +163,7 @@ namespace Tango.Synchronization.UI.ViewModels private void Compare() { - _comparer = new SqlDataBaseComparer(new SqliteDataBase(_masterDBFile), new SqliteDataBase(_slaveDBFile)); + _comparer = new LocalDBComparer(new SQLiteDataBase(_masterDBFile), new SQLiteDataBase(_slaveDBFile)); OpenStatus("Comparing DataBase..."); @@ -172,7 +173,7 @@ namespace Tango.Synchronization.UI.ViewModels { Thread.Sleep(1500); var diffs = _comparer.Compare(); - Differences = new ObservableCollection<SqlDiff>(diffs); + Differences = new ObservableCollection<Diff>(diffs); } catch (Exception ex) { |