diff options
Diffstat (limited to 'Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx')
| -rw-r--r-- | Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx | 450 |
1 files changed, 324 insertions, 126 deletions
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx b/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx index b3b1d2a13..7e82dbbe3 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx @@ -5,7 +5,7 @@ <!-- 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"> - <EntityType Name="ACTIONS"> + <EntityType Name="ACTION_TYPES"> <Key> <PropertyRef Name="GUID" /> </Key> @@ -99,6 +99,35 @@ <Property Name="SERIAL_NUMBER" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="CARTRIDGE_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> </EntityType> + <EntityType Name="CATS"> + <Key> + <PropertyRef Name="GUID" /> + </Key> + <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="LIQUID_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="MACHINE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="DATA" Type="image" Nullable="false" /> + </EntityType> + <EntityType Name="CCTS"> + <Key> + <PropertyRef Name="GUID" /> + </Key> + <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="100" Nullable="false" /> + <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="200" Nullable="false" /> + <Property Name="FORWARD_FILE_NAME" Type="nvarchar" MaxLength="100" Nullable="false" /> + <Property Name="INVERSE_FILE_NAME" Type="nvarchar" MaxLength="100" Nullable="false" /> + <Property Name="FORWARD_DATA" Type="image" Nullable="false" /> + <Property Name="INVERSE_DATA" Type="image" Nullable="false" /> + <Property Name="VERSION" Type="float" Nullable="false" /> + <Property Name="RML_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + </EntityType> <EntityType Name="CONFIGURATIONS"> <Key> <PropertyRef Name="GUID" /> @@ -176,7 +205,7 @@ <Property Name="VERSION" Type="float" Nullable="false" /> <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> </EntityType> - <EntityType Name="EVENTS"> + <EntityType Name="EVENT_TYPES"> <Key> <PropertyRef Name="GUID" /> </Key> @@ -188,7 +217,7 @@ <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="100" Nullable="false" /> </EntityType> - <EntityType Name="EVENTS_ACTIONS"> + <EntityType Name="EVENT_TYPES_ACTIONS"> <Key> <PropertyRef Name="GUID" /> </Key> @@ -196,8 +225,8 @@ <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_GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="ACTION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="EVENT_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="ACTION_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> </EntityType> <EntityType Name="FIBER_SHAPES"> <Key> @@ -242,7 +271,7 @@ <Property Name="DELETED" Type="bit" Nullable="false" /> <Property Name="CONFIGURATION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="DISPENSER_GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="LIQUID_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LIQUID_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="CARTRIDGE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> </EntityType> @@ -257,7 +286,7 @@ <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="CODE" Type="int" Nullable="false" /> </EntityType> - <EntityType Name="LIQUIDS"> + <EntityType Name="LIQUID_TYPES"> <Key> <PropertyRef Name="GUID" /> </Key> @@ -270,7 +299,7 @@ <Property Name="VERSION" Type="float" Nullable="false" /> <Property Name="COLOR" Type="int" Nullable="false" /> </EntityType> - <EntityType Name="LIQUIDS_RMLS"> + <EntityType Name="LIQUID_TYPES_RMLS"> <Key> <PropertyRef Name="GUID" /> </Key> @@ -278,7 +307,7 @@ <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_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LIQUID_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="RML_GUID" Type="varchar" MaxLength="36" Nullable="false" /> </EntityType> <EntityType Name="MACHINE_VERSIONS"> @@ -328,7 +357,7 @@ <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> <Property Name="MACHINE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="EVENT_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="EVENT_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="USER_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="DATE_TIME" Type="datetime" Nullable="false" /> <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="200" /> @@ -408,6 +437,7 @@ <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" /> <Property Name="MANUFACTURER" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="MATERIAL_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="COLOR_GUID" Type="varchar" MaxLength="36" Nullable="false" /> @@ -495,6 +525,42 @@ </Dependent> </ReferentialConstraint> </Association> + <Association Name="FK_CATS_LIQUID_TYPES"> + <End Role="LIQUID_TYPES" Type="Self.LIQUID_TYPES" Multiplicity="1" /> + <End Role="CATS" Type="Self.CATS" Multiplicity="*" /> + <ReferentialConstraint> + <Principal Role="LIQUID_TYPES"> + <PropertyRef Name="GUID" /> + </Principal> + <Dependent Role="CATS"> + <PropertyRef Name="LIQUID_TYPE_GUID" /> + </Dependent> + </ReferentialConstraint> + </Association> + <Association Name="FK_CATS_MACHINES"> + <End Role="MACHINES" Type="Self.MACHINES" Multiplicity="1" /> + <End Role="CATS" Type="Self.CATS" Multiplicity="*" /> + <ReferentialConstraint> + <Principal Role="MACHINES"> + <PropertyRef Name="GUID" /> + </Principal> + <Dependent Role="CATS"> + <PropertyRef Name="MACHINE_GUID" /> + </Dependent> + </ReferentialConstraint> + </Association> + <Association Name="FK_CCTS_RMLS"> + <End Role="RMLS" Type="Self.RMLS" Multiplicity="1" /> + <End Role="CCTS" Type="Self.CCTS" Multiplicity="*" /> + <ReferentialConstraint> + <Principal Role="RMLS"> + <PropertyRef Name="GUID" /> + </Principal> + <Dependent Role="CCTS"> + <PropertyRef Name="RML_GUID" /> + </Dependent> + </ReferentialConstraint> + </Association> <Association Name="FK_CONFIGURATIONS_APPLICATION_DISPLAY_PANEL_VERSIONS"> <End Role="APPLICATION_DISPLAY_PANEL_VERSIONS" Type="Self.APPLICATION_DISPLAY_PANEL_VERSIONS" Multiplicity="1" /> <End Role="CONFIGURATIONS" Type="Self.CONFIGURATIONS" Multiplicity="*" /> @@ -568,14 +634,14 @@ </ReferentialConstraint> </Association> <Association Name="FK_CONFIGURATIONS_DISPENSERS_LIQUIDS"> - <End Role="LIQUIDS" Type="Self.LIQUIDS" Multiplicity="1" /> + <End Role="LIQUID_TYPES" Type="Self.LIQUID_TYPES" Multiplicity="1" /> <End Role="IDS_PACKS" Type="Self.IDS_PACKS" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="LIQUIDS"> + <Principal Role="LIQUID_TYPES"> <PropertyRef Name="GUID" /> </Principal> <Dependent Role="IDS_PACKS"> - <PropertyRef Name="LIQUID_GUID" /> + <PropertyRef Name="LIQUID_TYPE_GUID" /> </Dependent> </ReferentialConstraint> </Association> @@ -628,26 +694,26 @@ </ReferentialConstraint> </Association> <Association Name="FK_EVENTS_ACTIONS_ACTIONS"> - <End Role="ACTIONS" Type="Self.ACTIONS" Multiplicity="1" /> - <End Role="EVENTS_ACTIONS" Type="Self.EVENTS_ACTIONS" Multiplicity="*" /> + <End Role="ACTION_TYPES" Type="Self.ACTION_TYPES" Multiplicity="1" /> + <End Role="EVENT_TYPES_ACTIONS" Type="Self.EVENT_TYPES_ACTIONS" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="ACTIONS"> + <Principal Role="ACTION_TYPES"> <PropertyRef Name="GUID" /> </Principal> - <Dependent Role="EVENTS_ACTIONS"> - <PropertyRef Name="ACTION_GUID" /> + <Dependent Role="EVENT_TYPES_ACTIONS"> + <PropertyRef Name="ACTION_TYPE_GUID" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_EVENTS_ACTIONS_EVENTS"> - <End Role="EVENTS" Type="Self.EVENTS" Multiplicity="1" /> - <End Role="EVENTS_ACTIONS" Type="Self.EVENTS_ACTIONS" Multiplicity="*" /> + <End Role="EVENT_TYPES" Type="Self.EVENT_TYPES" Multiplicity="1" /> + <End Role="EVENT_TYPES_ACTIONS" Type="Self.EVENT_TYPES_ACTIONS" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="EVENTS"> + <Principal Role="EVENT_TYPES"> <PropertyRef Name="GUID" /> </Principal> - <Dependent Role="EVENTS_ACTIONS"> - <PropertyRef Name="EVENT_GUID" /> + <Dependent Role="EVENT_TYPES_ACTIONS"> + <PropertyRef Name="EVENT_TYPE_GUID" /> </Dependent> </ReferentialConstraint> </Association> @@ -664,25 +730,25 @@ </ReferentialConstraint> </Association> <Association Name="FK_LIQUIDS_RML_LIQUIDS"> - <End Role="LIQUIDS" Type="Self.LIQUIDS" Multiplicity="1" /> - <End Role="LIQUIDS_RMLS" Type="Self.LIQUIDS_RMLS" Multiplicity="*" /> + <End Role="LIQUID_TYPES" Type="Self.LIQUID_TYPES" Multiplicity="1" /> + <End Role="LIQUID_TYPES_RMLS" Type="Self.LIQUID_TYPES_RMLS" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="LIQUIDS"> + <Principal Role="LIQUID_TYPES"> <PropertyRef Name="GUID" /> </Principal> - <Dependent Role="LIQUIDS_RMLS"> - <PropertyRef Name="LIQUID_GUID" /> + <Dependent Role="LIQUID_TYPES_RMLS"> + <PropertyRef Name="LIQUID_TYPE_GUID" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_LIQUIDS_RML_RML"> <End Role="RMLS" Type="Self.RMLS" Multiplicity="1" /> - <End Role="LIQUIDS_RMLS" Type="Self.LIQUIDS_RMLS" Multiplicity="*" /> + <End Role="LIQUID_TYPES_RMLS" Type="Self.LIQUID_TYPES_RMLS" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="RMLS"> <PropertyRef Name="GUID" /> </Principal> - <Dependent Role="LIQUIDS_RMLS"> + <Dependent Role="LIQUID_TYPES_RMLS"> <PropertyRef Name="RML_GUID" /> </Dependent> </ReferentialConstraint> @@ -738,14 +804,14 @@ </ReferentialConstraint> </Association> <Association Name="FK_MACHINES_EVENTS_EVENTS"> - <End Role="EVENTS" Type="Self.EVENTS" Multiplicity="1" /> + <End Role="EVENT_TYPES" Type="Self.EVENT_TYPES" Multiplicity="1" /> <End Role="MACHINES_EVENTS" Type="Self.MACHINES_EVENTS" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="EVENTS"> + <Principal Role="EVENT_TYPES"> <PropertyRef Name="GUID" /> </Principal> <Dependent Role="MACHINES_EVENTS"> - <PropertyRef Name="EVENT_GUID" /> + <PropertyRef Name="EVENT_TYPE_GUID" /> </Dependent> </ReferentialConstraint> </Association> @@ -998,7 +1064,7 @@ </ReferentialConstraint> </Association> <EntityContainer Name="RemoteModelStoreContainer"> - <EntitySet Name="ACTIONS" EntityType="Self.ACTIONS" Schema="dbo" store:Type="Tables" /> + <EntitySet Name="ACTION_TYPES" EntityType="Self.ACTION_TYPES" Schema="dbo" store:Type="Tables" /> <EntitySet Name="ADDRESSES" EntityType="Self.ADDRESSES" Schema="dbo" store:Type="Tables" /> <EntitySet Name="APPLICATION_DISPLAY_PANEL_VERSIONS" EntityType="Self.APPLICATION_DISPLAY_PANEL_VERSIONS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="APPLICATION_FIRMWARE_VERSIONS" EntityType="Self.APPLICATION_FIRMWARE_VERSIONS" Schema="dbo" store:Type="Tables" /> @@ -1006,21 +1072,23 @@ <EntitySet Name="APPLICATION_VERSIONS" EntityType="Self.APPLICATION_VERSIONS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="CARTRIDGE_TYPES" EntityType="Self.CARTRIDGE_TYPES" Schema="dbo" store:Type="Tables" /> <EntitySet Name="CARTRIDGES" EntityType="Self.CARTRIDGES" Schema="dbo" store:Type="Tables" /> + <EntitySet Name="CATS" EntityType="Self.CATS" Schema="dbo" store:Type="Tables" /> + <EntitySet Name="CCTS" EntityType="Self.CCTS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="CONFIGURATIONS" EntityType="Self.CONFIGURATIONS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="CONTACTS" EntityType="Self.CONTACTS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="DISPENSER_TYPES" EntityType="Self.DISPENSER_TYPES" Schema="dbo" store:Type="Tables" /> <EntitySet Name="DISPENSERS" EntityType="Self.DISPENSERS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="EMBEDDED_FIRMWARE_VERSIONS" EntityType="Self.EMBEDDED_FIRMWARE_VERSIONS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="EMBEDDED_SOFTWARE_VERSIONS" EntityType="Self.EMBEDDED_SOFTWARE_VERSIONS" Schema="dbo" store:Type="Tables" /> - <EntitySet Name="EVENTS" EntityType="Self.EVENTS" Schema="dbo" store:Type="Tables" /> - <EntitySet Name="EVENTS_ACTIONS" EntityType="Self.EVENTS_ACTIONS" Schema="dbo" store:Type="Tables" /> + <EntitySet Name="EVENT_TYPES" EntityType="Self.EVENT_TYPES" Schema="dbo" store:Type="Tables" /> + <EntitySet Name="EVENT_TYPES_ACTIONS" EntityType="Self.EVENT_TYPES_ACTIONS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="FIBER_SHAPES" EntityType="Self.FIBER_SHAPES" Schema="dbo" store:Type="Tables" /> <EntitySet Name="FIBER_SYNTHS" EntityType="Self.FIBER_SYNTHS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="HARDWARE_VERSIONS" EntityType="Self.HARDWARE_VERSIONS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="IDS_PACKS" EntityType="Self.IDS_PACKS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="LINEAR_MASS_DENSITY_UNITS" EntityType="Self.LINEAR_MASS_DENSITY_UNITS" Schema="dbo" store:Type="Tables" /> - <EntitySet Name="LIQUIDS" EntityType="Self.LIQUIDS" Schema="dbo" store:Type="Tables" /> - <EntitySet Name="LIQUIDS_RMLS" EntityType="Self.LIQUIDS_RMLS" Schema="dbo" store:Type="Tables" /> + <EntitySet Name="LIQUID_TYPES" EntityType="Self.LIQUID_TYPES" Schema="dbo" store:Type="Tables" /> + <EntitySet Name="LIQUID_TYPES_RMLS" EntityType="Self.LIQUID_TYPES_RMLS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="MACHINE_VERSIONS" EntityType="Self.MACHINE_VERSIONS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="MACHINES" EntityType="Self.MACHINES" Schema="dbo" store:Type="Tables" /> <EntitySet Name="MACHINES_CONFIGURATIONS" EntityType="Self.MACHINES_CONFIGURATIONS" Schema="dbo" store:Type="Tables" /> @@ -1041,6 +1109,18 @@ <End Role="CARTRIDGE_TYPES" EntitySet="CARTRIDGE_TYPES" /> <End Role="CARTRIDGES" EntitySet="CARTRIDGES" /> </AssociationSet> + <AssociationSet Name="FK_CATS_LIQUID_TYPES" Association="Self.FK_CATS_LIQUID_TYPES"> + <End Role="LIQUID_TYPES" EntitySet="LIQUID_TYPES" /> + <End Role="CATS" EntitySet="CATS" /> + </AssociationSet> + <AssociationSet Name="FK_CATS_MACHINES" Association="Self.FK_CATS_MACHINES"> + <End Role="MACHINES" EntitySet="MACHINES" /> + <End Role="CATS" EntitySet="CATS" /> + </AssociationSet> + <AssociationSet Name="FK_CCTS_RMLS" Association="Self.FK_CCTS_RMLS"> + <End Role="RMLS" EntitySet="RMLS" /> + <End Role="CCTS" EntitySet="CCTS" /> + </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" /> @@ -1066,7 +1146,7 @@ <End Role="IDS_PACKS" EntitySet="IDS_PACKS" /> </AssociationSet> <AssociationSet Name="FK_CONFIGURATIONS_DISPENSERS_LIQUIDS" Association="Self.FK_CONFIGURATIONS_DISPENSERS_LIQUIDS"> - <End Role="LIQUIDS" EntitySet="LIQUIDS" /> + <End Role="LIQUID_TYPES" EntitySet="LIQUID_TYPES" /> <End Role="IDS_PACKS" EntitySet="IDS_PACKS" /> </AssociationSet> <AssociationSet Name="FK_CONFIGURATIONS_EMBEDDED_FIRMWARE_VERSIONS" Association="Self.FK_CONFIGURATIONS_EMBEDDED_FIRMWARE_VERSIONS"> @@ -1086,24 +1166,24 @@ <End Role="DISPENSERS" EntitySet="DISPENSERS" /> </AssociationSet> <AssociationSet Name="FK_EVENTS_ACTIONS_ACTIONS" Association="Self.FK_EVENTS_ACTIONS_ACTIONS"> - <End Role="ACTIONS" EntitySet="ACTIONS" /> - <End Role="EVENTS_ACTIONS" EntitySet="EVENTS_ACTIONS" /> + <End Role="ACTION_TYPES" EntitySet="ACTION_TYPES" /> + <End Role="EVENT_TYPES_ACTIONS" EntitySet="EVENT_TYPES_ACTIONS" /> </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" /> + <End Role="EVENT_TYPES" EntitySet="EVENT_TYPES" /> + <End Role="EVENT_TYPES_ACTIONS" EntitySet="EVENT_TYPES_ACTIONS" /> </AssociationSet> <AssociationSet Name="FK_IDS_PACKS_CONFIGURATIONS" Association="Self.FK_IDS_PACKS_CONFIGURATIONS"> <End Role="CONFIGURATIONS" EntitySet="CONFIGURATIONS" /> <End Role="IDS_PACKS" EntitySet="IDS_PACKS" /> </AssociationSet> <AssociationSet Name="FK_LIQUIDS_RML_LIQUIDS" Association="Self.FK_LIQUIDS_RML_LIQUIDS"> - <End Role="LIQUIDS" EntitySet="LIQUIDS" /> - <End Role="LIQUIDS_RMLS" EntitySet="LIQUIDS_RMLS" /> + <End Role="LIQUID_TYPES" EntitySet="LIQUID_TYPES" /> + <End Role="LIQUID_TYPES_RMLS" EntitySet="LIQUID_TYPES_RMLS" /> </AssociationSet> <AssociationSet Name="FK_LIQUIDS_RML_RML" Association="Self.FK_LIQUIDS_RML_RML"> <End Role="RMLS" EntitySet="RMLS" /> - <End Role="LIQUIDS_RMLS" EntitySet="LIQUIDS_RMLS" /> + <End Role="LIQUID_TYPES_RMLS" EntitySet="LIQUID_TYPES_RMLS" /> </AssociationSet> <AssociationSet Name="FK_MACHINE_VERSIONS_CONFIGURATIONS" Association="Self.FK_MACHINE_VERSIONS_CONFIGURATIONS"> <End Role="CONFIGURATIONS" EntitySet="CONFIGURATIONS" /> @@ -1122,7 +1202,7 @@ <End Role="MACHINES_CONFIGURATIONS" EntitySet="MACHINES_CONFIGURATIONS" /> </AssociationSet> <AssociationSet Name="FK_MACHINES_EVENTS_EVENTS" Association="Self.FK_MACHINES_EVENTS_EVENTS"> - <End Role="EVENTS" EntitySet="EVENTS" /> + <End Role="EVENT_TYPES" EntitySet="EVENT_TYPES" /> <End Role="MACHINES_EVENTS" EntitySet="MACHINES_EVENTS" /> </AssociationSet> <AssociationSet Name="FK_MACHINES_EVENTS_MACHINES" Association="Self.FK_MACHINES_EVENTS_MACHINES"> @@ -1211,7 +1291,7 @@ <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="ACTION_TYPES" EntityType="RemoteModel.ACTION_TYPES" /> <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" /> @@ -1219,21 +1299,23 @@ <EntitySet Name="APPLICATION_VERSIONS" EntityType="RemoteModel.APPLICATION_VERSIONS" /> <EntitySet Name="CARTRIDGE_TYPES" EntityType="RemoteModel.CARTRIDGE_TYPES" /> <EntitySet Name="CARTRIDGES" EntityType="RemoteModel.CARTRIDGE" /> + <EntitySet Name="CATS" EntityType="RemoteModel.CAT" /> + <EntitySet Name="CCTS" EntityType="RemoteModel.CCT" /> <EntitySet Name="CONFIGURATIONS" EntityType="RemoteModel.CONFIGURATION" /> <EntitySet Name="CONTACTS" EntityType="RemoteModel.CONTACT" /> <EntitySet Name="DISPENSER_TYPES" EntityType="RemoteModel.DISPENSER_TYPES" /> <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="EVENT_TYPES" EntityType="RemoteModel.EVENT_TYPES" /> + <EntitySet Name="EVENT_TYPES_ACTIONS" EntityType="RemoteModel.EVENT_TYPES_ACTIONS" /> <EntitySet Name="FIBER_SHAPES" EntityType="RemoteModel.FIBER_SHAPES" /> <EntitySet Name="FIBER_SYNTHS" EntityType="RemoteModel.FIBER_SYNTHS" /> <EntitySet Name="HARDWARE_VERSIONS" EntityType="RemoteModel.HARDWARE_VERSIONS" /> <EntitySet Name="IDS_PACKS" EntityType="RemoteModel.IDS_PACKS" /> <EntitySet Name="LINEAR_MASS_DENSITY_UNITS" EntityType="RemoteModel.LINEAR_MASS_DENSITY_UNITS" /> - <EntitySet Name="LIQUIDS" EntityType="RemoteModel.LIQUID" /> - <EntitySet Name="LIQUIDS_RMLS" EntityType="RemoteModel.LIQUIDS_RMLS" /> + <EntitySet Name="LIQUID_TYPES" EntityType="RemoteModel.LIQUID_TYPES" /> + <EntitySet Name="LIQUID_TYPES_RMLS" EntityType="RemoteModel.LIQUID_TYPES_RMLS" /> <EntitySet Name="MACHINE_VERSIONS" EntityType="RemoteModel.MACHINE_VERSIONS" /> <EntitySet Name="MACHINES" EntityType="RemoteModel.MACHINE" /> <EntitySet Name="MACHINES_CONFIGURATIONS" EntityType="RemoteModel.MACHINES_CONFIGURATIONS" /> @@ -1251,8 +1333,8 @@ <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" /> + <End Role="ACTION_TYPES" EntitySet="ACTION_TYPES" /> + <End Role="EVENT_TYPES_ACTIONS" EntitySet="EVENT_TYPES_ACTIONS" /> </AssociationSet> <AssociationSet Name="FK_ORGANIZATIONS_ADDRESSES" Association="RemoteModel.FK_ORGANIZATIONS_ADDRESSES"> <End Role="ADDRESS" EntitySet="ADDRESSES" /> @@ -1286,6 +1368,18 @@ <End Role="CARTRIDGE" EntitySet="CARTRIDGES" /> <End Role="IDS_PACKS" EntitySet="IDS_PACKS" /> </AssociationSet> + <AssociationSet Name="FK_CATS_LIQUID_TYPES" Association="RemoteModel.FK_CATS_LIQUID_TYPES"> + <End Role="LIQUID_TYPES" EntitySet="LIQUID_TYPES" /> + <End Role="CAT" EntitySet="CATS" /> + </AssociationSet> + <AssociationSet Name="FK_CATS_MACHINES" Association="RemoteModel.FK_CATS_MACHINES"> + <End Role="MACHINE" EntitySet="MACHINES" /> + <End Role="CAT" EntitySet="CATS" /> + </AssociationSet> + <AssociationSet Name="FK_CCTS_RMLS" Association="RemoteModel.FK_CCTS_RMLS"> + <End Role="RML" EntitySet="RMLS" /> + <End Role="CCT" EntitySet="CCTS" /> + </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" /> @@ -1331,11 +1425,11 @@ <End Role="IDS_PACKS" EntitySet="IDS_PACKS" /> </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" /> + <End Role="EVENT_TYPES" EntitySet="EVENT_TYPES" /> + <End Role="EVENT_TYPES_ACTIONS" EntitySet="EVENT_TYPES_ACTIONS" /> </AssociationSet> <AssociationSet Name="FK_MACHINES_EVENTS_EVENTS" Association="RemoteModel.FK_MACHINES_EVENTS_EVENTS"> - <End Role="EVENT" EntitySet="EVENTS" /> + <End Role="EVENT_TYPES" EntitySet="EVENT_TYPES" /> <End Role="MACHINES_EVENTS" EntitySet="MACHINES_EVENTS" /> </AssociationSet> <AssociationSet Name="FK_RML_FIBER_SHAPES" Association="RemoteModel.FK_RML_FIBER_SHAPES"> @@ -1347,7 +1441,7 @@ <End Role="RML" EntitySet="RMLS" /> </AssociationSet> <AssociationSet Name="FK_CONFIGURATIONS_DISPENSERS_LIQUIDS" Association="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_LIQUIDS"> - <End Role="LIQUID" EntitySet="LIQUIDS" /> + <End Role="LIQUID_TYPES" EntitySet="LIQUID_TYPES" /> <End Role="IDS_PACKS" EntitySet="IDS_PACKS" /> </AssociationSet> <AssociationSet Name="FK_RML_LINEAR_MASS_DENSITY_UNITS" Association="RemoteModel.FK_RML_LINEAR_MASS_DENSITY_UNITS"> @@ -1355,12 +1449,12 @@ <End Role="RML" EntitySet="RMLS" /> </AssociationSet> <AssociationSet Name="FK_LIQUIDS_RML_LIQUIDS" Association="RemoteModel.FK_LIQUIDS_RML_LIQUIDS"> - <End Role="LIQUID" EntitySet="LIQUIDS" /> - <End Role="LIQUIDS_RMLS" EntitySet="LIQUIDS_RMLS" /> + <End Role="LIQUID_TYPES" EntitySet="LIQUID_TYPES" /> + <End Role="LIQUID_TYPES_RMLS" EntitySet="LIQUID_TYPES_RMLS" /> </AssociationSet> <AssociationSet Name="FK_LIQUIDS_RML_RML" Association="RemoteModel.FK_LIQUIDS_RML_RML"> <End Role="RML" EntitySet="RMLS" /> - <End Role="LIQUIDS_RMLS" EntitySet="LIQUIDS_RMLS" /> + <End Role="LIQUID_TYPES_RMLS" EntitySet="LIQUID_TYPES_RMLS" /> </AssociationSet> <AssociationSet Name="FK_MACHINES_MACHINE_VERSIONS" Association="RemoteModel.FK_MACHINES_MACHINE_VERSIONS"> <End Role="MACHINE_VERSIONS" EntitySet="MACHINE_VERSIONS" /> @@ -1419,7 +1513,7 @@ <End Role="USERS_ROLES" EntitySet="USERS_ROLES" /> </AssociationSet> </EntityContainer> - <EntityType Name="ACTION"> + <EntityType Name="ACTION_TYPES"> <Key> <PropertyRef Name="GUID" /> </Key> @@ -1430,7 +1524,7 @@ <Property Name="CODE" Type="Int32" Nullable="false" /> <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" /> + <NavigationProperty Name="EVENT_TYPES_ACTIONS" Relationship="RemoteModel.FK_EVENTS_ACTIONS_ACTIONS" FromRole="ACTION_TYPES" ToRole="EVENT_TYPES_ACTIONS" /> </EntityType> <EntityType Name="ADDRESS"> <Key> @@ -1523,6 +1617,38 @@ <NavigationProperty Name="CARTRIDGE_TYPES" Relationship="RemoteModel.FK_CARTRIDGES_CARTRIDGE_TYPES" FromRole="CARTRIDGE" ToRole="CARTRIDGE_TYPES" /> <NavigationProperty Name="IDS_PACKS" Relationship="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_CARTRIDGES" FromRole="CARTRIDGE" ToRole="IDS_PACKS" /> </EntityType> + <EntityType Name="CAT"> + <Key> + <PropertyRef Name="GUID" /> + </Key> + <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> + <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="LIQUID_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="MACHINE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="DATA" Type="Binary" Nullable="false" MaxLength="Max" FixedLength="false" /> + <NavigationProperty Name="LIQUID_TYPES" Relationship="RemoteModel.FK_CATS_LIQUID_TYPES" FromRole="CAT" ToRole="LIQUID_TYPES" /> + <NavigationProperty Name="MACHINE" Relationship="RemoteModel.FK_CATS_MACHINES" FromRole="CAT" ToRole="MACHINE" /> + </EntityType> + <EntityType Name="CCT"> + <Key> + <PropertyRef Name="GUID" /> + </Key> + <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> + <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> + <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="true" /> + <Property Name="FORWARD_FILE_NAME" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> + <Property Name="INVERSE_FILE_NAME" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> + <Property Name="FORWARD_DATA" Type="Binary" Nullable="false" MaxLength="Max" FixedLength="false" /> + <Property Name="INVERSE_DATA" Type="Binary" Nullable="false" MaxLength="Max" FixedLength="false" /> + <Property Name="VERSION" Type="Double" Nullable="false" /> + <Property Name="RML_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <NavigationProperty Name="RML" Relationship="RemoteModel.FK_CCTS_RMLS" FromRole="CCT" ToRole="RML" /> + </EntityType> <EntityType Name="CONFIGURATION"> <Key> <PropertyRef Name="GUID" /> @@ -1618,7 +1744,7 @@ <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <NavigationProperty Name="CONFIGURATIONS" Relationship="RemoteModel.FK_CONFIGURATIONS_EMBEDDED_SOFTWARE_VERSIONS" FromRole="EMBEDDED_SOFTWARE_VERSIONS" ToRole="CONFIGURATION" /> </EntityType> - <EntityType Name="EVENT"> + <EntityType Name="EVENT_TYPES"> <Key> <PropertyRef Name="GUID" /> </Key> @@ -1629,10 +1755,10 @@ <Property Name="CODE" Type="Int32" Nullable="false" /> <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" /> + <NavigationProperty Name="EVENT_TYPES_ACTIONS" Relationship="RemoteModel.FK_EVENTS_ACTIONS_EVENTS" FromRole="EVENT_TYPES" ToRole="EVENT_TYPES_ACTIONS" /> + <NavigationProperty Name="MACHINES_EVENTS" Relationship="RemoteModel.FK_MACHINES_EVENTS_EVENTS" FromRole="EVENT_TYPES" ToRole="MACHINES_EVENTS" /> </EntityType> - <EntityType Name="EVENTS_ACTIONS"> + <EntityType Name="EVENT_TYPES_ACTIONS"> <Key> <PropertyRef Name="GUID" /> </Key> @@ -1640,10 +1766,10 @@ <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_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> - <Property Name="ACTION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> - <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" /> + <Property Name="EVENT_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="ACTION_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <NavigationProperty Name="ACTION_TYPES" Relationship="RemoteModel.FK_EVENTS_ACTIONS_ACTIONS" FromRole="EVENT_TYPES_ACTIONS" ToRole="ACTION_TYPES" /> + <NavigationProperty Name="EVENT_TYPES" Relationship="RemoteModel.FK_EVENTS_ACTIONS_EVENTS" FromRole="EVENT_TYPES_ACTIONS" ToRole="EVENT_TYPES" /> </EntityType> <EntityType Name="FIBER_SHAPES"> <Key> @@ -1691,13 +1817,13 @@ <Property Name="DELETED" Type="Boolean" Nullable="false" /> <Property Name="CONFIGURATION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="DISPENSER_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> - <Property Name="LIQUID_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="LIQUID_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="CARTRIDGE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <NavigationProperty Name="CARTRIDGE" Relationship="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_CARTRIDGES" FromRole="IDS_PACKS" ToRole="CARTRIDGE" /> <NavigationProperty Name="CONFIGURATION" Relationship="RemoteModel.FK_IDS_PACKS_CONFIGURATIONS" FromRole="IDS_PACKS" ToRole="CONFIGURATION" /> <NavigationProperty Name="DISPENSER" Relationship="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_DISPENSERS" FromRole="IDS_PACKS" ToRole="DISPENSER" /> - <NavigationProperty Name="LIQUID" Relationship="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_LIQUIDS" FromRole="IDS_PACKS" ToRole="LIQUID" /> + <NavigationProperty Name="LIQUID_TYPES" Relationship="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_LIQUIDS" FromRole="IDS_PACKS" ToRole="LIQUID_TYPES" /> </EntityType> <EntityType Name="LINEAR_MASS_DENSITY_UNITS"> <Key> @@ -1711,7 +1837,7 @@ <Property Name="CODE" Type="Int32" Nullable="false" /> <NavigationProperty Name="RMLS" Relationship="RemoteModel.FK_RML_LINEAR_MASS_DENSITY_UNITS" FromRole="LINEAR_MASS_DENSITY_UNITS" ToRole="RML" /> </EntityType> - <EntityType Name="LIQUID"> + <EntityType Name="LIQUID_TYPES"> <Key> <PropertyRef Name="GUID" /> </Key> @@ -1723,10 +1849,11 @@ <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="VERSION" Type="Double" Nullable="false" /> <Property Name="COLOR" Type="Int32" Nullable="false" /> - <NavigationProperty Name="IDS_PACKS" Relationship="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_LIQUIDS" FromRole="LIQUID" ToRole="IDS_PACKS" /> - <NavigationProperty Name="LIQUIDS_RMLS" Relationship="RemoteModel.FK_LIQUIDS_RML_LIQUIDS" FromRole="LIQUID" ToRole="LIQUIDS_RMLS" /> + <NavigationProperty Name="CATS" Relationship="RemoteModel.FK_CATS_LIQUID_TYPES" FromRole="LIQUID_TYPES" ToRole="CAT" /> + <NavigationProperty Name="IDS_PACKS" Relationship="RemoteModel.FK_CONFIGURATIONS_DISPENSERS_LIQUIDS" FromRole="LIQUID_TYPES" ToRole="IDS_PACKS" /> + <NavigationProperty Name="LIQUID_TYPES_RMLS" Relationship="RemoteModel.FK_LIQUIDS_RML_LIQUIDS" FromRole="LIQUID_TYPES" ToRole="LIQUID_TYPES_RMLS" /> </EntityType> - <EntityType Name="LIQUIDS_RMLS"> + <EntityType Name="LIQUID_TYPES_RMLS"> <Key> <PropertyRef Name="GUID" /> </Key> @@ -1734,10 +1861,10 @@ <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_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="LIQUID_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="RML_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> - <NavigationProperty Name="LIQUID" Relationship="RemoteModel.FK_LIQUIDS_RML_LIQUIDS" FromRole="LIQUIDS_RMLS" ToRole="LIQUID" /> - <NavigationProperty Name="RML" Relationship="RemoteModel.FK_LIQUIDS_RML_RML" FromRole="LIQUIDS_RMLS" ToRole="RML" /> + <NavigationProperty Name="LIQUID_TYPES" Relationship="RemoteModel.FK_LIQUIDS_RML_LIQUIDS" FromRole="LIQUID_TYPES_RMLS" ToRole="LIQUID_TYPES" /> + <NavigationProperty Name="RML" Relationship="RemoteModel.FK_LIQUIDS_RML_RML" FromRole="LIQUID_TYPES_RMLS" ToRole="RML" /> </EntityType> <EntityType Name="MACHINE_VERSIONS"> <Key> @@ -1767,6 +1894,7 @@ <Property Name="ORGANIZATION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="MACHINE_VERSION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="CONFIGURATION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <NavigationProperty Name="CATS" Relationship="RemoteModel.FK_CATS_MACHINES" FromRole="MACHINE" ToRole="CAT" /> <NavigationProperty Name="CONFIGURATION" Relationship="RemoteModel.FK_MACHINES_CONFIGURATIONS" FromRole="MACHINE" ToRole="CONFIGURATION" /> <NavigationProperty Name="MACHINE_VERSIONS" Relationship="RemoteModel.FK_MACHINES_MACHINE_VERSIONS" FromRole="MACHINE" ToRole="MACHINE_VERSIONS" /> <NavigationProperty Name="MACHINES_CONFIGURATIONS" Relationship="RemoteModel.FK_MACHINES_CONFIGURATIONS_MACHINES" FromRole="MACHINE" ToRole="MACHINES_CONFIGURATIONS" /> @@ -1795,11 +1923,11 @@ <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> <Property Name="MACHINE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> - <Property Name="EVENT_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="EVENT_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="USER_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="DATE_TIME" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DESCRIPTION" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> - <NavigationProperty Name="EVENT" Relationship="RemoteModel.FK_MACHINES_EVENTS_EVENTS" FromRole="MACHINES_EVENTS" ToRole="EVENT" /> + <NavigationProperty Name="EVENT_TYPES" Relationship="RemoteModel.FK_MACHINES_EVENTS_EVENTS" FromRole="MACHINES_EVENTS" ToRole="EVENT_TYPES" /> <NavigationProperty Name="MACHINE" Relationship="RemoteModel.FK_MACHINES_EVENTS_MACHINES" FromRole="MACHINES_EVENTS" ToRole="MACHINE" /> <NavigationProperty Name="USER" Relationship="RemoteModel.FK_MACHINES_EVENTS_USERS" FromRole="MACHINES_EVENTS" ToRole="USER" /> </EntityType> @@ -1887,6 +2015,7 @@ <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" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="MANUFACTURER" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="MATERIAL_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="COLOR_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> @@ -1905,10 +2034,11 @@ <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="CCTS" Relationship="RemoteModel.FK_CCTS_RMLS" FromRole="RML" ToRole="CCT" /> <NavigationProperty Name="FIBER_SHAPES" Relationship="RemoteModel.FK_RML_FIBER_SHAPES" FromRole="RML" ToRole="FIBER_SHAPES" /> <NavigationProperty Name="FIBER_SYNTHS" Relationship="RemoteModel.FK_RML_FIBER_SYNTHESIS" FromRole="RML" ToRole="FIBER_SYNTHS" /> <NavigationProperty Name="LINEAR_MASS_DENSITY_UNITS" Relationship="RemoteModel.FK_RML_LINEAR_MASS_DENSITY_UNITS" FromRole="RML" ToRole="LINEAR_MASS_DENSITY_UNITS" /> - <NavigationProperty Name="LIQUIDS_RMLS" Relationship="RemoteModel.FK_LIQUIDS_RML_RML" FromRole="RML" ToRole="LIQUIDS_RMLS" /> + <NavigationProperty Name="LIQUID_TYPES_RMLS" Relationship="RemoteModel.FK_LIQUIDS_RML_RML" FromRole="RML" ToRole="LIQUID_TYPES_RMLS" /> <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" /> @@ -1982,14 +2112,14 @@ <NavigationProperty Name="USER" Relationship="RemoteModel.FK_USERS_ROLES_USERS" FromRole="USERS_ROLES" ToRole="USER" /> </EntityType> <Association Name="FK_EVENTS_ACTIONS_ACTIONS"> - <End Type="RemoteModel.ACTION" Role="ACTION" Multiplicity="1" /> - <End Type="RemoteModel.EVENTS_ACTIONS" Role="EVENTS_ACTIONS" Multiplicity="*" /> + <End Type="RemoteModel.ACTION_TYPES" Role="ACTION_TYPES" Multiplicity="1" /> + <End Type="RemoteModel.EVENT_TYPES_ACTIONS" Role="EVENT_TYPES_ACTIONS" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="ACTION"> + <Principal Role="ACTION_TYPES"> <PropertyRef Name="GUID" /> </Principal> - <Dependent Role="EVENTS_ACTIONS"> - <PropertyRef Name="ACTION_GUID" /> + <Dependent Role="EVENT_TYPES_ACTIONS"> + <PropertyRef Name="ACTION_TYPE_GUID" /> </Dependent> </ReferentialConstraint> </Association> @@ -2091,6 +2221,42 @@ </Dependent> </ReferentialConstraint> </Association> + <Association Name="FK_CATS_LIQUID_TYPES"> + <End Type="RemoteModel.LIQUID_TYPES" Role="LIQUID_TYPES" Multiplicity="1" /> + <End Type="RemoteModel.CAT" Role="CAT" Multiplicity="*" /> + <ReferentialConstraint> + <Principal Role="LIQUID_TYPES"> + <PropertyRef Name="GUID" /> + </Principal> + <Dependent Role="CAT"> + <PropertyRef Name="LIQUID_TYPE_GUID" /> + </Dependent> + </ReferentialConstraint> + </Association> + <Association Name="FK_CATS_MACHINES"> + <End Type="RemoteModel.MACHINE" Role="MACHINE" Multiplicity="1" /> + <End Type="RemoteModel.CAT" Role="CAT" Multiplicity="*" /> + <ReferentialConstraint> + <Principal Role="MACHINE"> + <PropertyRef Name="GUID" /> + </Principal> + <Dependent Role="CAT"> + <PropertyRef Name="MACHINE_GUID" /> + </Dependent> + </ReferentialConstraint> + </Association> + <Association Name="FK_CCTS_RMLS"> + <End Type="RemoteModel.RML" Role="RML" Multiplicity="1" /> + <End Type="RemoteModel.CCT" Role="CCT" Multiplicity="*" /> + <ReferentialConstraint> + <Principal Role="RML"> + <PropertyRef Name="GUID" /> + </Principal> + <Dependent Role="CCT"> + <PropertyRef Name="RML_GUID" /> + </Dependent> + </ReferentialConstraint> + </Association> <Association Name="FK_CONFIGURATIONS_EMBEDDED_FIRMWARE_VERSIONS"> <End Type="RemoteModel.EMBEDDED_FIRMWARE_VERSIONS" Role="EMBEDDED_FIRMWARE_VERSIONS" Multiplicity="1" /> <End Type="RemoteModel.CONFIGURATION" Role="CONFIGURATION" Multiplicity="*" /> @@ -2226,26 +2392,26 @@ </ReferentialConstraint> </Association> <Association Name="FK_EVENTS_ACTIONS_EVENTS"> - <End Type="RemoteModel.EVENT" Role="EVENT" Multiplicity="1" /> - <End Type="RemoteModel.EVENTS_ACTIONS" Role="EVENTS_ACTIONS" Multiplicity="*" /> + <End Type="RemoteModel.EVENT_TYPES" Role="EVENT_TYPES" Multiplicity="1" /> + <End Type="RemoteModel.EVENT_TYPES_ACTIONS" Role="EVENT_TYPES_ACTIONS" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="EVENT"> + <Principal Role="EVENT_TYPES"> <PropertyRef Name="GUID" /> </Principal> - <Dependent Role="EVENTS_ACTIONS"> - <PropertyRef Name="EVENT_GUID" /> + <Dependent Role="EVENT_TYPES_ACTIONS"> + <PropertyRef Name="EVENT_TYPE_GUID" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_MACHINES_EVENTS_EVENTS"> - <End Type="RemoteModel.EVENT" Role="EVENT" Multiplicity="1" /> + <End Type="RemoteModel.EVENT_TYPES" Role="EVENT_TYPES" Multiplicity="1" /> <End Type="RemoteModel.MACHINES_EVENTS" Role="MACHINES_EVENTS" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="EVENT"> + <Principal Role="EVENT_TYPES"> <PropertyRef Name="GUID" /> </Principal> <Dependent Role="MACHINES_EVENTS"> - <PropertyRef Name="EVENT_GUID" /> + <PropertyRef Name="EVENT_TYPE_GUID" /> </Dependent> </ReferentialConstraint> </Association> @@ -2274,14 +2440,14 @@ </ReferentialConstraint> </Association> <Association Name="FK_CONFIGURATIONS_DISPENSERS_LIQUIDS"> - <End Type="RemoteModel.LIQUID" Role="LIQUID" Multiplicity="1" /> + <End Type="RemoteModel.LIQUID_TYPES" Role="LIQUID_TYPES" Multiplicity="1" /> <End Type="RemoteModel.IDS_PACKS" Role="IDS_PACKS" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="LIQUID"> + <Principal Role="LIQUID_TYPES"> <PropertyRef Name="GUID" /> </Principal> <Dependent Role="IDS_PACKS"> - <PropertyRef Name="LIQUID_GUID" /> + <PropertyRef Name="LIQUID_TYPE_GUID" /> </Dependent> </ReferentialConstraint> </Association> @@ -2298,25 +2464,25 @@ </ReferentialConstraint> </Association> <Association Name="FK_LIQUIDS_RML_LIQUIDS"> - <End Type="RemoteModel.LIQUID" Role="LIQUID" Multiplicity="1" /> - <End Type="RemoteModel.LIQUIDS_RMLS" Role="LIQUIDS_RMLS" Multiplicity="*" /> + <End Type="RemoteModel.LIQUID_TYPES" Role="LIQUID_TYPES" Multiplicity="1" /> + <End Type="RemoteModel.LIQUID_TYPES_RMLS" Role="LIQUID_TYPES_RMLS" Multiplicity="*" /> <ReferentialConstraint> - <Principal Role="LIQUID"> + <Principal Role="LIQUID_TYPES"> <PropertyRef Name="GUID" /> </Principal> - <Dependent Role="LIQUIDS_RMLS"> - <PropertyRef Name="LIQUID_GUID" /> + <Dependent Role="LIQUID_TYPES_RMLS"> + <PropertyRef Name="LIQUID_TYPE_GUID" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_LIQUIDS_RML_RML"> <End Type="RemoteModel.RML" Role="RML" Multiplicity="1" /> - <End Type="RemoteModel.LIQUIDS_RMLS" Role="LIQUIDS_RMLS" Multiplicity="*" /> + <End Type="RemoteModel.LIQUID_TYPES_RMLS" Role="LIQUID_TYPES_RMLS" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="RML"> <PropertyRef Name="GUID" /> </Principal> - <Dependent Role="LIQUIDS_RMLS"> + <Dependent Role="LIQUID_TYPES_RMLS"> <PropertyRef Name="RML_GUID" /> </Dependent> </ReferentialConstraint> @@ -2501,9 +2667,9 @@ <edmx:Mappings> <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs"> <EntityContainerMapping StorageEntityContainer="RemoteModelStoreContainer" CdmEntityContainer="RemoteDB"> - <EntitySetMapping Name="ACTIONS"> - <EntityTypeMapping TypeName="RemoteModel.ACTION"> - <MappingFragment StoreEntitySet="ACTIONS"> + <EntitySetMapping Name="ACTION_TYPES"> + <EntityTypeMapping TypeName="RemoteModel.ACTION_TYPES"> + <MappingFragment StoreEntitySet="ACTION_TYPES"> <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> <ScalarProperty Name="NAME" ColumnName="NAME" /> <ScalarProperty Name="CODE" ColumnName="CODE" /> @@ -2603,6 +2769,37 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> + <EntitySetMapping Name="CATS"> + <EntityTypeMapping TypeName="RemoteModel.CAT"> + <MappingFragment StoreEntitySet="CATS"> + <ScalarProperty Name="DATA" ColumnName="DATA" /> + <ScalarProperty Name="MACHINE_GUID" ColumnName="MACHINE_GUID" /> + <ScalarProperty Name="LIQUID_TYPE_GUID" ColumnName="LIQUID_TYPE_GUID" /> + <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="CCTS"> + <EntityTypeMapping TypeName="RemoteModel.CCT"> + <MappingFragment StoreEntitySet="CCTS"> + <ScalarProperty Name="RML_GUID" ColumnName="RML_GUID" /> + <ScalarProperty Name="VERSION" ColumnName="VERSION" /> + <ScalarProperty Name="INVERSE_DATA" ColumnName="INVERSE_DATA" /> + <ScalarProperty Name="FORWARD_DATA" ColumnName="FORWARD_DATA" /> + <ScalarProperty Name="INVERSE_FILE_NAME" ColumnName="INVERSE_FILE_NAME" /> + <ScalarProperty Name="FORWARD_FILE_NAME" ColumnName="FORWARD_FILE_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="CONFIGURATIONS"> <EntityTypeMapping TypeName="RemoteModel.CONFIGURATION"> <MappingFragment StoreEntitySet="CONFIGURATIONS"> @@ -2686,9 +2883,9 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> - <EntitySetMapping Name="EVENTS"> - <EntityTypeMapping TypeName="RemoteModel.EVENT"> - <MappingFragment StoreEntitySet="EVENTS"> + <EntitySetMapping Name="EVENT_TYPES"> + <EntityTypeMapping TypeName="RemoteModel.EVENT_TYPES"> + <MappingFragment StoreEntitySet="EVENT_TYPES"> <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> <ScalarProperty Name="NAME" ColumnName="NAME" /> <ScalarProperty Name="CODE" ColumnName="CODE" /> @@ -2699,11 +2896,11 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> - <EntitySetMapping Name="EVENTS_ACTIONS"> - <EntityTypeMapping TypeName="RemoteModel.EVENTS_ACTIONS"> - <MappingFragment StoreEntitySet="EVENTS_ACTIONS"> - <ScalarProperty Name="ACTION_GUID" ColumnName="ACTION_GUID" /> - <ScalarProperty Name="EVENT_GUID" ColumnName="EVENT_GUID" /> + <EntitySetMapping Name="EVENT_TYPES_ACTIONS"> + <EntityTypeMapping TypeName="RemoteModel.EVENT_TYPES_ACTIONS"> + <MappingFragment StoreEntitySet="EVENT_TYPES_ACTIONS"> + <ScalarProperty Name="ACTION_TYPE_GUID" ColumnName="ACTION_TYPE_GUID" /> + <ScalarProperty Name="EVENT_TYPE_GUID" ColumnName="EVENT_TYPE_GUID" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="GUID" ColumnName="GUID" /> @@ -2752,7 +2949,7 @@ <MappingFragment StoreEntitySet="IDS_PACKS"> <ScalarProperty Name="NAME" ColumnName="NAME" /> <ScalarProperty Name="CARTRIDGE_GUID" ColumnName="CARTRIDGE_GUID" /> - <ScalarProperty Name="LIQUID_GUID" ColumnName="LIQUID_GUID" /> + <ScalarProperty Name="LIQUID_TYPE_GUID" ColumnName="LIQUID_TYPE_GUID" /> <ScalarProperty Name="DISPENSER_GUID" ColumnName="DISPENSER_GUID" /> <ScalarProperty Name="CONFIGURATION_GUID" ColumnName="CONFIGURATION_GUID" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> @@ -2774,9 +2971,9 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> - <EntitySetMapping Name="LIQUIDS"> - <EntityTypeMapping TypeName="RemoteModel.LIQUID"> - <MappingFragment StoreEntitySet="LIQUIDS"> + <EntitySetMapping Name="LIQUID_TYPES"> + <EntityTypeMapping TypeName="RemoteModel.LIQUID_TYPES"> + <MappingFragment StoreEntitySet="LIQUID_TYPES"> <ScalarProperty Name="COLOR" ColumnName="COLOR" /> <ScalarProperty Name="VERSION" ColumnName="VERSION" /> <ScalarProperty Name="NAME" ColumnName="NAME" /> @@ -2788,11 +2985,11 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> - <EntitySetMapping Name="LIQUIDS_RMLS"> - <EntityTypeMapping TypeName="RemoteModel.LIQUIDS_RMLS"> - <MappingFragment StoreEntitySet="LIQUIDS_RMLS"> + <EntitySetMapping Name="LIQUID_TYPES_RMLS"> + <EntityTypeMapping TypeName="RemoteModel.LIQUID_TYPES_RMLS"> + <MappingFragment StoreEntitySet="LIQUID_TYPES_RMLS"> <ScalarProperty Name="RML_GUID" ColumnName="RML_GUID" /> - <ScalarProperty Name="LIQUID_GUID" ColumnName="LIQUID_GUID" /> + <ScalarProperty Name="LIQUID_TYPE_GUID" ColumnName="LIQUID_TYPE_GUID" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="GUID" ColumnName="GUID" /> @@ -2847,7 +3044,7 @@ <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> <ScalarProperty Name="DATE_TIME" ColumnName="DATE_TIME" /> <ScalarProperty Name="USER_GUID" ColumnName="USER_GUID" /> - <ScalarProperty Name="EVENT_GUID" ColumnName="EVENT_GUID" /> + <ScalarProperty Name="EVENT_TYPE_GUID" ColumnName="EVENT_TYPE_GUID" /> <ScalarProperty Name="MACHINE_GUID" ColumnName="MACHINE_GUID" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> @@ -2950,6 +3147,7 @@ <ScalarProperty Name="COLOR_GUID" ColumnName="COLOR_GUID" /> <ScalarProperty Name="MATERIAL_GUID" ColumnName="MATERIAL_GUID" /> <ScalarProperty Name="MANUFACTURER" ColumnName="MANUFACTURER" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="GUID" ColumnName="GUID" /> |