diff options
Diffstat (limited to 'Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx')
| -rw-r--r-- | Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx | 324 |
1 files changed, 264 insertions, 60 deletions
diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx index bd71d7457..bd3f0e69c 100644 --- a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx @@ -5,7 +5,7 @@ <!-- SSDL content --> <edmx:StorageModels> <Schema Namespace="LocalModel.Store" Provider="System.Data.SQLite.EF6" ProviderManifestToken="Data Source=D:\Development\Tango\Software\DB\Tango.db" 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="ID" /> </Key> @@ -41,6 +41,8 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="VERSION" Type="real" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> </EntityType> <EntityType Name="APPLICATION_FIRMWARE_VERSIONS"> <Key> @@ -50,6 +52,8 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="VERSION" Type="real" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> </EntityType> <EntityType Name="APPLICATION_OS_VERSIONS"> <Key> @@ -59,6 +63,8 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="VERSION" Type="real" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> </EntityType> <EntityType Name="APPLICATION_VERSIONS"> <Key> @@ -68,6 +74,8 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="VERSION" Type="real" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> </EntityType> <EntityType Name="CARTRIDGE_TYPES"> <Key> @@ -77,6 +85,8 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="CODE" Type="integer" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> </EntityType> <EntityType Name="CARTRIDGES"> <Key> @@ -88,6 +98,35 @@ <Property Name="DELETED" Type="bit" Nullable="false" /> <Property Name="CARTRIDGE_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> </EntityType> + <EntityType Name="CATS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="integer" Nullable="false" /> + <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="LIQUID_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="MACHINE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="DATA" Type="blob" Nullable="false" /> + </EntityType> + <EntityType Name="CCTS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="integer" Nullable="false" /> + <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="FORWARD_FILE_NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="INVERSE_FILE_NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="FORWARD_DATA" Type="blob" Nullable="false" /> + <Property Name="INVERSE_DATA" Type="blob" Nullable="false" /> + <Property Name="VERSION" Type="real" Nullable="false" /> + <Property Name="RML_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + </EntityType> <EntityType Name="CONFIGURATIONS"> <Key> <PropertyRef Name="ID" /> @@ -129,6 +168,8 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="CODE" Type="integer" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> </EntityType> <EntityType Name="DISPENSERS"> <Key> @@ -138,6 +179,7 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="SERIAL_NUMBER" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="DISPENSER_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> </EntityType> <EntityType Name="EMBEDDED_FIRMWARE_VERSIONS"> @@ -148,6 +190,8 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="VERSION" Type="real" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> </EntityType> <EntityType Name="EMBEDDED_SOFTWARE_VERSIONS"> <Key> @@ -157,8 +201,10 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="VERSION" Type="real" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> </EntityType> - <EntityType Name="EVENTS"> + <EntityType Name="EVENT_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> @@ -166,10 +212,11 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="CODE" Type="integer" Nullable="false" /> <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> </EntityType> - <EntityType Name="EVENTS_ACTIONS"> + <EntityType Name="EVENT_TYPES_ACTIONS"> <Key> <PropertyRef Name="ID" /> </Key> @@ -177,8 +224,8 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> - <Property Name="EVENT_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="ACTION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="EVENT_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ACTION_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> </EntityType> <EntityType Name="FIBER_SHAPES"> <Key> @@ -188,8 +235,10 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="CODE" Type="integer" Nullable="false" /> </EntityType> - <EntityType Name="FIBER_SYNTHESISES"> + <EntityType Name="FIBER_SYNTHS"> <Key> <PropertyRef Name="ID" /> </Key> @@ -197,6 +246,8 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="CODE" Type="integer" Nullable="false" /> </EntityType> <EntityType Name="HARDWARE_VERSIONS"> <Key> @@ -206,6 +257,8 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="VERSION" Type="real" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> </EntityType> <EntityType Name="IDS_PACKS"> <Key> @@ -217,7 +270,7 @@ <Property Name="DELETED" Type="bit" Nullable="false" /> <Property Name="CONFIGURATION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="DISPENSER_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="LIQUID_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="LIQUID_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="CARTRIDGE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> </EntityType> <EntityType Name="LINEAR_MASS_DENSITY_UNITS"> @@ -228,8 +281,10 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="CODE" Type="integer" Nullable="false" /> </EntityType> - <EntityType Name="LIQUIDS"> + <EntityType Name="LIQUID_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> @@ -240,8 +295,9 @@ <Property Name="CODE" Type="integer" Nullable="false" /> <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="VERSION" Type="real" Nullable="false" /> + <Property Name="COLOR" Type="integer" Nullable="false" /> </EntityType> - <EntityType Name="LIQUIDS_RMLS"> + <EntityType Name="LIQUID_TYPES_RMLS"> <Key> <PropertyRef Name="ID" /> </Key> @@ -249,7 +305,7 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> - <Property Name="LIQUID_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="LIQUID_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="RML_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> </EntityType> <EntityType Name="MACHINE_VERSIONS"> @@ -260,7 +316,9 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="VERSION" Type="real" Nullable="false" /> + <Property Name="DEFAULT_CONFIGURATION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> </EntityType> <EntityType Name="MACHINES"> <Key> @@ -275,6 +333,7 @@ <Property Name="PRODUCTION_DATE" Type="datetime" Nullable="false" /> <Property Name="ORGANIZATION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="MACHINE_VERSION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="CONFIGURATION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> </EntityType> <EntityType Name="MACHINES_CONFIGURATIONS"> <Key> @@ -296,7 +355,7 @@ <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> <Property Name="MACHINE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="EVENT_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="EVENT_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="USER_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="DATE_TIME" Type="datetime" Nullable="false" /> <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> @@ -319,6 +378,8 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="CODE" Type="integer" Nullable="false" /> </EntityType> <EntityType Name="MEDIA_MATERIALS"> <Key> @@ -328,6 +389,8 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="CODE" Type="integer" Nullable="false" /> </EntityType> <EntityType Name="MEDIA_PURPOSES"> <Key> @@ -337,6 +400,8 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="CODE" Type="integer" Nullable="false" /> </EntityType> <EntityType Name="ORGANIZATIONS"> <Key> @@ -370,6 +435,7 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="MANUFACTURER" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="MATERIAL_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="COLOR_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> @@ -377,7 +443,7 @@ <Property Name="CONDITION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LINEAR_MASS_DENSITY_UNIT_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="FIBER_SHAPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="FIBER_SYNTHESIS_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="FIBER_SYNTH_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="FIBER_SIZE" Type="real" Nullable="false" /> <Property Name="NUMBER_OF_FIBERS" Type="integer" Nullable="false" /> <Property Name="PLIES_PER_FIBER" Type="integer" Nullable="false" /> @@ -446,7 +512,7 @@ <Property Name="ROLE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> </EntityType> <EntityContainer Name="LocalModelStoreContainer"> - <EntitySet Name="ACTIONS" EntityType="Self.ACTIONS" store:Type="Tables" /> + <EntitySet Name="ACTION_TYPES" EntityType="Self.ACTION_TYPES" store:Type="Tables" /> <EntitySet Name="ADDRESSES" EntityType="Self.ADDRESSES" store:Type="Tables" /> <EntitySet Name="APPLICATION_DISPLAY_PANEL_VERSIONS" EntityType="Self.APPLICATION_DISPLAY_PANEL_VERSIONS" store:Type="Tables" /> <EntitySet Name="APPLICATION_FIRMWARE_VERSIONS" EntityType="Self.APPLICATION_FIRMWARE_VERSIONS" store:Type="Tables" /> @@ -454,21 +520,23 @@ <EntitySet Name="APPLICATION_VERSIONS" EntityType="Self.APPLICATION_VERSIONS" store:Type="Tables" /> <EntitySet Name="CARTRIDGE_TYPES" EntityType="Self.CARTRIDGE_TYPES" store:Type="Tables" /> <EntitySet Name="CARTRIDGES" EntityType="Self.CARTRIDGES" store:Type="Tables" /> + <EntitySet Name="CATS" EntityType="Self.CATS" store:Type="Tables" /> + <EntitySet Name="CCTS" EntityType="Self.CCTS" store:Type="Tables" /> <EntitySet Name="CONFIGURATIONS" EntityType="Self.CONFIGURATIONS" store:Type="Tables" /> <EntitySet Name="CONTACTS" EntityType="Self.CONTACTS" store:Type="Tables" /> <EntitySet Name="DISPENSER_TYPES" EntityType="Self.DISPENSER_TYPES" store:Type="Tables" /> <EntitySet Name="DISPENSERS" EntityType="Self.DISPENSERS" store:Type="Tables" /> <EntitySet Name="EMBEDDED_FIRMWARE_VERSIONS" EntityType="Self.EMBEDDED_FIRMWARE_VERSIONS" store:Type="Tables" /> <EntitySet Name="EMBEDDED_SOFTWARE_VERSIONS" EntityType="Self.EMBEDDED_SOFTWARE_VERSIONS" store:Type="Tables" /> - <EntitySet Name="EVENTS" EntityType="Self.EVENTS" store:Type="Tables" /> - <EntitySet Name="EVENTS_ACTIONS" EntityType="Self.EVENTS_ACTIONS" store:Type="Tables" /> + <EntitySet Name="EVENT_TYPES" EntityType="Self.EVENT_TYPES" store:Type="Tables" /> + <EntitySet Name="EVENT_TYPES_ACTIONS" EntityType="Self.EVENT_TYPES_ACTIONS" store:Type="Tables" /> <EntitySet Name="FIBER_SHAPES" EntityType="Self.FIBER_SHAPES" store:Type="Tables" /> - <EntitySet Name="FIBER_SYNTHESISES" EntityType="Self.FIBER_SYNTHESISES" store:Type="Tables" /> + <EntitySet Name="FIBER_SYNTHS" EntityType="Self.FIBER_SYNTHS" store:Type="Tables" /> <EntitySet Name="HARDWARE_VERSIONS" EntityType="Self.HARDWARE_VERSIONS" store:Type="Tables" /> <EntitySet Name="IDS_PACKS" EntityType="Self.IDS_PACKS" store:Type="Tables" /> <EntitySet Name="LINEAR_MASS_DENSITY_UNITS" EntityType="Self.LINEAR_MASS_DENSITY_UNITS" store:Type="Tables" /> - <EntitySet Name="LIQUIDS" EntityType="Self.LIQUIDS" store:Type="Tables" /> - <EntitySet Name="LIQUIDS_RMLS" EntityType="Self.LIQUIDS_RMLS" store:Type="Tables" /> + <EntitySet Name="LIQUID_TYPES" EntityType="Self.LIQUID_TYPES" store:Type="Tables" /> + <EntitySet Name="LIQUID_TYPES_RMLS" EntityType="Self.LIQUID_TYPES_RMLS" store:Type="Tables" /> <EntitySet Name="MACHINE_VERSIONS" EntityType="Self.MACHINE_VERSIONS" store:Type="Tables" /> <EntitySet Name="MACHINES" EntityType="Self.MACHINES" store:Type="Tables" /> <EntitySet Name="MACHINES_CONFIGURATIONS" EntityType="Self.MACHINES_CONFIGURATIONS" store:Type="Tables" /> @@ -491,7 +559,7 @@ <edmx:ConceptualModels> <Schema Namespace="LocalModel" 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="LocalDB" annotation:LazyLoadingEnabled="true"> - <EntitySet Name="ACTIONS" EntityType="LocalModel.ACTION" /> + <EntitySet Name="ACTION_TYPES" EntityType="LocalModel.ACTION_TYPES" /> <EntitySet Name="ADDRESSES" EntityType="LocalModel.ADDRESS" /> <EntitySet Name="APPLICATION_DISPLAY_PANEL_VERSIONS" EntityType="LocalModel.APPLICATION_DISPLAY_PANEL_VERSIONS" /> <EntitySet Name="APPLICATION_FIRMWARE_VERSIONS" EntityType="LocalModel.APPLICATION_FIRMWARE_VERSIONS" /> @@ -499,21 +567,23 @@ <EntitySet Name="APPLICATION_VERSIONS" EntityType="LocalModel.APPLICATION_VERSIONS" /> <EntitySet Name="CARTRIDGE_TYPES" EntityType="LocalModel.CARTRIDGE_TYPES" /> <EntitySet Name="CARTRIDGES" EntityType="LocalModel.CARTRIDGE" /> + <EntitySet Name="CATS" EntityType="LocalModel.CAT" /> + <EntitySet Name="CCTS" EntityType="LocalModel.CCT" /> <EntitySet Name="CONFIGURATIONS" EntityType="LocalModel.CONFIGURATION" /> <EntitySet Name="CONTACTS" EntityType="LocalModel.CONTACT" /> <EntitySet Name="DISPENSER_TYPES" EntityType="LocalModel.DISPENSER_TYPES" /> <EntitySet Name="DISPENSERS" EntityType="LocalModel.DISPENSER" /> <EntitySet Name="EMBEDDED_FIRMWARE_VERSIONS" EntityType="LocalModel.EMBEDDED_FIRMWARE_VERSIONS" /> <EntitySet Name="EMBEDDED_SOFTWARE_VERSIONS" EntityType="LocalModel.EMBEDDED_SOFTWARE_VERSIONS" /> - <EntitySet Name="EVENTS" EntityType="LocalModel.EVENT" /> - <EntitySet Name="EVENTS_ACTIONS" EntityType="LocalModel.EVENTS_ACTIONS" /> + <EntitySet Name="EVENT_TYPES" EntityType="LocalModel.EVENT_TYPES" /> + <EntitySet Name="EVENT_TYPES_ACTIONS" EntityType="LocalModel.EVENT_TYPES_ACTIONS" /> <EntitySet Name="FIBER_SHAPES" EntityType="LocalModel.FIBER_SHAPES" /> - <EntitySet Name="FIBER_SYNTHESISES" EntityType="LocalModel.FIBER_SYNTHESISES" /> + <EntitySet Name="FIBER_SYNTHS" EntityType="LocalModel.FIBER_SYNTHS" /> <EntitySet Name="HARDWARE_VERSIONS" EntityType="LocalModel.HARDWARE_VERSIONS" /> <EntitySet Name="IDS_PACKS" EntityType="LocalModel.IDS_PACKS" /> <EntitySet Name="LINEAR_MASS_DENSITY_UNITS" EntityType="LocalModel.LINEAR_MASS_DENSITY_UNITS" /> - <EntitySet Name="LIQUIDS" EntityType="LocalModel.LIQUID" /> - <EntitySet Name="LIQUIDS_RMLS" EntityType="LocalModel.LIQUIDS_RMLS" /> + <EntitySet Name="LIQUID_TYPES" EntityType="LocalModel.LIQUID_TYPES" /> + <EntitySet Name="LIQUID_TYPES_RMLS" EntityType="LocalModel.LIQUID_TYPES_RMLS" /> <EntitySet Name="MACHINE_VERSIONS" EntityType="LocalModel.MACHINE_VERSIONS" /> <EntitySet Name="MACHINES" EntityType="LocalModel.MACHINE" /> <EntitySet Name="MACHINES_CONFIGURATIONS" EntityType="LocalModel.MACHINES_CONFIGURATIONS" /> @@ -531,7 +601,7 @@ <EntitySet Name="USERS" EntityType="LocalModel.USER" /> <EntitySet Name="USERS_ROLES" EntityType="LocalModel.USERS_ROLES" /> </EntityContainer> - <EntityType Name="ACTION"> + <EntityType Name="ACTION_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> @@ -567,6 +637,8 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="VERSION" Type="Double" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="APPLICATION_FIRMWARE_VERSIONS"> <Key> @@ -576,6 +648,8 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="VERSION" Type="Double" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="APPLICATION_OS_VERSIONS"> <Key> @@ -585,6 +659,8 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="VERSION" Type="Double" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="APPLICATION_VERSIONS"> <Key> @@ -594,6 +670,8 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="VERSION" Type="Double" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="CARTRIDGE_TYPES"> <Key> @@ -603,6 +681,8 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="CODE" Type="Int64" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="CARTRIDGE"> <Key> @@ -614,6 +694,35 @@ <Property Name="DELETED" Type="Boolean" Nullable="false" /> <Property Name="CARTRIDGE_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> </EntityType> + <EntityType Name="CAT"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="Int64" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> + <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="LIQUID_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="MACHINE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="DATA" Type="Binary" Nullable="false" MaxLength="2147483647" FixedLength="false" /> + </EntityType> + <EntityType Name="CCT"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="Int64" Nullable="false" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> + <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="FORWARD_FILE_NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="INVERSE_FILE_NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="FORWARD_DATA" Type="Binary" Nullable="false" MaxLength="2147483647" FixedLength="false" /> + <Property Name="INVERSE_DATA" Type="Binary" Nullable="false" MaxLength="2147483647" FixedLength="false" /> + <Property Name="VERSION" Type="Double" Nullable="false" /> + <Property Name="RML_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + </EntityType> <EntityType Name="CONFIGURATION"> <Key> <PropertyRef Name="ID" /> @@ -655,6 +764,8 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="CODE" Type="Int64" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="DISPENSER"> <Key> @@ -664,6 +775,7 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="SERIAL_NUMBER" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="DISPENSER_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="EMBEDDED_FIRMWARE_VERSIONS"> @@ -674,6 +786,8 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="VERSION" Type="Double" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="EMBEDDED_SOFTWARE_VERSIONS"> <Key> @@ -683,8 +797,10 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="VERSION" Type="Double" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> </EntityType> - <EntityType Name="EVENT"> + <EntityType Name="EVENT_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> @@ -692,10 +808,11 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="CODE" Type="Int64" Nullable="false" /> <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> </EntityType> - <EntityType Name="EVENTS_ACTIONS"> + <EntityType Name="EVENT_TYPES_ACTIONS"> <Key> <PropertyRef Name="ID" /> </Key> @@ -703,8 +820,8 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="EVENT_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="ACTION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="EVENT_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ACTION_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="FIBER_SHAPES"> <Key> @@ -714,8 +831,10 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="CODE" Type="Int64" Nullable="false" /> </EntityType> - <EntityType Name="FIBER_SYNTHESISES"> + <EntityType Name="FIBER_SYNTHS"> <Key> <PropertyRef Name="ID" /> </Key> @@ -723,6 +842,8 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="CODE" Type="Int64" Nullable="false" /> </EntityType> <EntityType Name="HARDWARE_VERSIONS"> <Key> @@ -732,6 +853,8 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="VERSION" Type="Double" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="IDS_PACKS"> <Key> @@ -743,7 +866,7 @@ <Property Name="DELETED" Type="Boolean" Nullable="false" /> <Property Name="CONFIGURATION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="DISPENSER_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="LIQUID_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="LIQUID_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="CARTRIDGE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="LINEAR_MASS_DENSITY_UNITS"> @@ -754,8 +877,10 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="CODE" Type="Int64" Nullable="false" /> </EntityType> - <EntityType Name="LIQUID"> + <EntityType Name="LIQUID_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> @@ -766,8 +891,9 @@ <Property Name="CODE" Type="Int64" Nullable="false" /> <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="VERSION" Type="Double" Nullable="false" /> + <Property Name="COLOR" Type="Int64" Nullable="false" /> </EntityType> - <EntityType Name="LIQUIDS_RMLS"> + <EntityType Name="LIQUID_TYPES_RMLS"> <Key> <PropertyRef Name="ID" /> </Key> @@ -775,7 +901,7 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="LIQUID_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="LIQUID_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="RML_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="MACHINE_VERSIONS"> @@ -786,7 +912,9 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="VERSION" Type="Double" Nullable="false" /> + <Property Name="DEFAULT_CONFIGURATION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="MACHINE"> <Key> @@ -801,6 +929,7 @@ <Property Name="PRODUCTION_DATE" Type="DateTime" Nullable="false" /> <Property Name="ORGANIZATION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="MACHINE_VERSION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="CONFIGURATION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="MACHINES_CONFIGURATIONS"> <Key> @@ -822,7 +951,7 @@ <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> <Property Name="MACHINE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="EVENT_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="EVENT_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="USER_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="DATE_TIME" Type="DateTime" Nullable="false" /> <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> @@ -845,6 +974,8 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="CODE" Type="Int64" Nullable="false" /> </EntityType> <EntityType Name="MEDIA_MATERIALS"> <Key> @@ -854,6 +985,8 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="CODE" Type="Int64" Nullable="false" /> </EntityType> <EntityType Name="MEDIA_PURPOSES"> <Key> @@ -863,6 +996,8 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="CODE" Type="Int64" Nullable="false" /> </EntityType> <EntityType Name="ORGANIZATION"> <Key> @@ -896,6 +1031,7 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="MANUFACTURER" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="MATERIAL_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="COLOR_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> @@ -903,7 +1039,7 @@ <Property Name="CONDITION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LINEAR_MASS_DENSITY_UNIT_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="FIBER_SHAPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="FIBER_SYNTHESIS_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="FIBER_SYNTH_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="FIBER_SIZE" Type="Double" Nullable="false" /> <Property Name="NUMBER_OF_FIBERS" Type="Int64" Nullable="false" /> <Property Name="PLIES_PER_FIBER" Type="Int64" Nullable="false" /> @@ -977,9 +1113,9 @@ <edmx:Mappings> <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs"> <EntityContainerMapping StorageEntityContainer="LocalModelStoreContainer" CdmEntityContainer="LocalDB"> - <EntitySetMapping Name="ACTIONS"> - <EntityTypeMapping TypeName="LocalModel.ACTION"> - <MappingFragment StoreEntitySet="ACTIONS"> + <EntitySetMapping Name="ACTION_TYPES"> + <EntityTypeMapping TypeName="LocalModel.ACTION_TYPES"> + <MappingFragment StoreEntitySet="ACTION_TYPES"> <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> <ScalarProperty Name="NAME" ColumnName="NAME" /> <ScalarProperty Name="CODE" ColumnName="CODE" /> @@ -1010,6 +1146,8 @@ <EntitySetMapping Name="APPLICATION_DISPLAY_PANEL_VERSIONS"> <EntityTypeMapping TypeName="LocalModel.APPLICATION_DISPLAY_PANEL_VERSIONS"> <MappingFragment StoreEntitySet="APPLICATION_DISPLAY_PANEL_VERSIONS"> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="VERSION" ColumnName="VERSION" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="GUID" ColumnName="GUID" /> @@ -1020,6 +1158,8 @@ <EntitySetMapping Name="APPLICATION_FIRMWARE_VERSIONS"> <EntityTypeMapping TypeName="LocalModel.APPLICATION_FIRMWARE_VERSIONS"> <MappingFragment StoreEntitySet="APPLICATION_FIRMWARE_VERSIONS"> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="VERSION" ColumnName="VERSION" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="GUID" ColumnName="GUID" /> @@ -1030,6 +1170,8 @@ <EntitySetMapping Name="APPLICATION_OS_VERSIONS"> <EntityTypeMapping TypeName="LocalModel.APPLICATION_OS_VERSIONS"> <MappingFragment StoreEntitySet="APPLICATION_OS_VERSIONS"> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="VERSION" ColumnName="VERSION" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="GUID" ColumnName="GUID" /> @@ -1040,6 +1182,8 @@ <EntitySetMapping Name="APPLICATION_VERSIONS"> <EntityTypeMapping TypeName="LocalModel.APPLICATION_VERSIONS"> <MappingFragment StoreEntitySet="APPLICATION_VERSIONS"> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="VERSION" ColumnName="VERSION" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="GUID" ColumnName="GUID" /> @@ -1050,6 +1194,8 @@ <EntitySetMapping Name="CARTRIDGE_TYPES"> <EntityTypeMapping TypeName="LocalModel.CARTRIDGE_TYPES"> <MappingFragment StoreEntitySet="CARTRIDGE_TYPES"> + <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" /> @@ -1068,6 +1214,37 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> + <EntitySetMapping Name="CATS"> + <EntityTypeMapping TypeName="LocalModel.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="LocalModel.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="LocalModel.CONFIGURATION"> <MappingFragment StoreEntitySet="CONFIGURATIONS"> @@ -1106,6 +1283,8 @@ <EntitySetMapping Name="DISPENSER_TYPES"> <EntityTypeMapping TypeName="LocalModel.DISPENSER_TYPES"> <MappingFragment StoreEntitySet="DISPENSER_TYPES"> + <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" /> @@ -1117,6 +1296,7 @@ <EntityTypeMapping TypeName="LocalModel.DISPENSER"> <MappingFragment StoreEntitySet="DISPENSERS"> <ScalarProperty Name="DISPENSER_TYPE_GUID" ColumnName="DISPENSER_TYPE_GUID" /> + <ScalarProperty Name="SERIAL_NUMBER" ColumnName="SERIAL_NUMBER" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="GUID" ColumnName="GUID" /> @@ -1127,6 +1307,8 @@ <EntitySetMapping Name="EMBEDDED_FIRMWARE_VERSIONS"> <EntityTypeMapping TypeName="LocalModel.EMBEDDED_FIRMWARE_VERSIONS"> <MappingFragment StoreEntitySet="EMBEDDED_FIRMWARE_VERSIONS"> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="VERSION" ColumnName="VERSION" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="GUID" ColumnName="GUID" /> @@ -1137,6 +1319,8 @@ <EntitySetMapping Name="EMBEDDED_SOFTWARE_VERSIONS"> <EntityTypeMapping TypeName="LocalModel.EMBEDDED_SOFTWARE_VERSIONS"> <MappingFragment StoreEntitySet="EMBEDDED_SOFTWARE_VERSIONS"> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="VERSION" ColumnName="VERSION" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="GUID" ColumnName="GUID" /> @@ -1144,11 +1328,12 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> - <EntitySetMapping Name="EVENTS"> - <EntityTypeMapping TypeName="LocalModel.EVENT"> - <MappingFragment StoreEntitySet="EVENTS"> + <EntitySetMapping Name="EVENT_TYPES"> + <EntityTypeMapping TypeName="LocalModel.EVENT_TYPES"> + <MappingFragment StoreEntitySet="EVENT_TYPES"> <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" /> @@ -1156,11 +1341,11 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> - <EntitySetMapping Name="EVENTS_ACTIONS"> - <EntityTypeMapping TypeName="LocalModel.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="LocalModel.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" /> @@ -1171,6 +1356,8 @@ <EntitySetMapping Name="FIBER_SHAPES"> <EntityTypeMapping TypeName="LocalModel.FIBER_SHAPES"> <MappingFragment StoreEntitySet="FIBER_SHAPES"> + <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" /> @@ -1178,9 +1365,11 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> - <EntitySetMapping Name="FIBER_SYNTHESISES"> - <EntityTypeMapping TypeName="LocalModel.FIBER_SYNTHESISES"> - <MappingFragment StoreEntitySet="FIBER_SYNTHESISES"> + <EntitySetMapping Name="FIBER_SYNTHS"> + <EntityTypeMapping TypeName="LocalModel.FIBER_SYNTHS"> + <MappingFragment StoreEntitySet="FIBER_SYNTHS"> + <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" /> @@ -1191,6 +1380,8 @@ <EntitySetMapping Name="HARDWARE_VERSIONS"> <EntityTypeMapping TypeName="LocalModel.HARDWARE_VERSIONS"> <MappingFragment StoreEntitySet="HARDWARE_VERSIONS"> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="VERSION" ColumnName="VERSION" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="GUID" ColumnName="GUID" /> @@ -1202,7 +1393,7 @@ <EntityTypeMapping TypeName="LocalModel.IDS_PACKS"> <MappingFragment StoreEntitySet="IDS_PACKS"> <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" /> @@ -1215,6 +1406,8 @@ <EntitySetMapping Name="LINEAR_MASS_DENSITY_UNITS"> <EntityTypeMapping TypeName="LocalModel.LINEAR_MASS_DENSITY_UNITS"> <MappingFragment StoreEntitySet="LINEAR_MASS_DENSITY_UNITS"> + <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" /> @@ -1222,9 +1415,10 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> - <EntitySetMapping Name="LIQUIDS"> - <EntityTypeMapping TypeName="LocalModel.LIQUID"> - <MappingFragment StoreEntitySet="LIQUIDS"> + <EntitySetMapping Name="LIQUID_TYPES"> + <EntityTypeMapping TypeName="LocalModel.LIQUID_TYPES"> + <MappingFragment StoreEntitySet="LIQUID_TYPES"> + <ScalarProperty Name="COLOR" ColumnName="COLOR" /> <ScalarProperty Name="VERSION" ColumnName="VERSION" /> <ScalarProperty Name="NAME" ColumnName="NAME" /> <ScalarProperty Name="CODE" ColumnName="CODE" /> @@ -1235,11 +1429,11 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> - <EntitySetMapping Name="LIQUIDS_RMLS"> - <EntityTypeMapping TypeName="LocalModel.LIQUIDS_RMLS"> - <MappingFragment StoreEntitySet="LIQUIDS_RMLS"> + <EntitySetMapping Name="LIQUID_TYPES_RMLS"> + <EntityTypeMapping TypeName="LocalModel.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" /> @@ -1250,7 +1444,9 @@ <EntitySetMapping Name="MACHINE_VERSIONS"> <EntityTypeMapping TypeName="LocalModel.MACHINE_VERSIONS"> <MappingFragment StoreEntitySet="MACHINE_VERSIONS"> + <ScalarProperty Name="DEFAULT_CONFIGURATION_GUID" ColumnName="DEFAULT_CONFIGURATION_GUID" /> <ScalarProperty Name="VERSION" ColumnName="VERSION" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="GUID" ColumnName="GUID" /> @@ -1261,6 +1457,7 @@ <EntitySetMapping Name="MACHINES"> <EntityTypeMapping TypeName="LocalModel.MACHINE"> <MappingFragment StoreEntitySet="MACHINES"> + <ScalarProperty Name="CONFIGURATION_GUID" ColumnName="CONFIGURATION_GUID" /> <ScalarProperty Name="MACHINE_VERSION_GUID" ColumnName="MACHINE_VERSION_GUID" /> <ScalarProperty Name="ORGANIZATION_GUID" ColumnName="ORGANIZATION_GUID" /> <ScalarProperty Name="PRODUCTION_DATE" ColumnName="PRODUCTION_DATE" /> @@ -1291,7 +1488,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" /> @@ -1314,6 +1511,8 @@ <EntitySetMapping Name="MEDIA_CONDITIONS"> <EntityTypeMapping TypeName="LocalModel.MEDIA_CONDITIONS"> <MappingFragment StoreEntitySet="MEDIA_CONDITIONS"> + <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" /> @@ -1324,6 +1523,8 @@ <EntitySetMapping Name="MEDIA_MATERIALS"> <EntityTypeMapping TypeName="LocalModel.MEDIA_MATERIALS"> <MappingFragment StoreEntitySet="MEDIA_MATERIALS"> + <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" /> @@ -1334,6 +1535,8 @@ <EntitySetMapping Name="MEDIA_PURPOSES"> <EntityTypeMapping TypeName="LocalModel.MEDIA_PURPOSES"> <MappingFragment StoreEntitySet="MEDIA_PURPOSES"> + <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" /> @@ -1380,7 +1583,7 @@ <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_GUID" ColumnName="FIBER_SYNTHESIS_GUID" /> + <ScalarProperty Name="FIBER_SYNTH_GUID" ColumnName="FIBER_SYNTH_GUID" /> <ScalarProperty Name="FIBER_SHAPE_GUID" ColumnName="FIBER_SHAPE_GUID" /> <ScalarProperty Name="LINEAR_MASS_DENSITY_UNIT_GUID" ColumnName="LINEAR_MASS_DENSITY_UNIT_GUID" /> <ScalarProperty Name="CONDITION_GUID" ColumnName="CONDITION_GUID" /> @@ -1388,6 +1591,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" /> |