diff options
| author | Mirta <mirta@twine-s.com> | 2020-12-30 16:39:52 +0200 |
|---|---|---|
| committer | Mirta <mirta@twine-s.com> | 2020-12-30 16:39:52 +0200 |
| commit | 00a491d93733d4625ad329b2ba8237f445364b3f (patch) | |
| tree | 4b24c6fa78d7648f4bb7cefafa464bb0b063fec4 /Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx | |
| parent | 124ad4150f80c6846fdee41dbbda9848c105f6e5 (diff) | |
| download | Tango-00a491d9.tar.gz Tango-00a491d9.zip | |
merge
Diffstat (limited to 'Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx')
| -rw-r--r-- | Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx | 1283 |
1 files changed, 166 insertions, 1117 deletions
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx b/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx index af3179379..19fb2c9fc 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx @@ -5,20 +5,6 @@ <!-- 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="ACTION_LOGS"> - <Key> - <PropertyRef Name="GUID" /> - </Key> - <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" /> - <Property Name="TYPE" Type="int" Nullable="false" /> - <Property Name="USER_GUID" Type="varchar" MaxLength="36" /> - <Property Name="RELATED_OBJECT_NAME" Type="nvarchar" MaxLength="200" /> - <Property Name="RELATED_OBJECT_GUID" Type="varchar" MaxLength="36" /> - <Property Name="MESSAGE" Type="nvarchar(max)" /> - <Property Name="DIFFERENCE" Type="nvarchar(max)" /> - </EntityType> <EntityType Name="ADDRESSES"> <Key> <PropertyRef Name="GUID" /> @@ -104,7 +90,6 @@ <Property Name="CORRECTED" Type="bit" Nullable="false" /> <Property Name="COLOR_CATALOG_GUID" Type="varchar" MaxLength="36" /> <Property Name="COLOR_CATALOGS_ITEM_GUID" Type="varchar" MaxLength="36" /> - <Property Name="IS_TRANSPARENT" Type="bit" Nullable="false" /> </EntityType> <EntityType Name="CARTRIDGE_TYPES"> <Key> @@ -254,21 +239,6 @@ <Property Name="ORGANIZATION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="NAME" Type="nvarchar" MaxLength="100" Nullable="false" /> </EntityType> - <EntityType Name="DATA_STORE_ITEMS"> - <Key> - <PropertyRef Name="GUID" /> - </Key> - <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" /> - <Property Name="MACHINE_GUID" Type="varchar" MaxLength="36" /> - <Property Name="COLLECTION_NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> - <Property Name="KEY" Type="nvarchar" MaxLength="50" Nullable="false" /> - <Property Name="DATA_TYPE" Type="int" Nullable="false" /> - <Property Name="VALUE" Type="image" Nullable="false" /> - <Property Name="IS_DELETED" Type="bit" Nullable="false" /> - <Property Name="IS_SYNCHRONIZED" Type="bit" Nullable="false" /> - </EntityType> <EntityType Name="DISPENSER_TYPES"> <Key> <PropertyRef Name="GUID" /> @@ -325,7 +295,6 @@ <Property Name="EVENT_ACTIONS" Type="varchar" MaxLength="50" /> <Property Name="REQUIRES_USER_INTERVENTION" Type="bit" Nullable="false" /> <Property Name="GUIDANCE" Type="nvarchar(max)" /> - <Property Name="PERSISTENT" Type="bit" Nullable="false" /> </EntityType> <EntityType Name="FIBER_SHAPES"> <Key> @@ -347,31 +316,6 @@ <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="CODE" Type="int" Nullable="false" /> </EntityType> - <EntityType Name="FSE_VERSIONS"> - <Key> - <PropertyRef Name="GUID" /> - </Key> - <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" /> - <Property Name="VERSION" Type="varchar" MaxLength="50" Nullable="false" /> - <Property Name="BLOB_NAME" Type="varchar" MaxLength="200" Nullable="false" /> - <Property Name="INSTALLER_BLOB_NAME" Type="varchar" MaxLength="200" /> - <Property Name="COMMENTS" Type="nvarchar(max)" Nullable="false" /> - <Property Name="USER_GUID" Type="varchar" MaxLength="36" Nullable="false" /> - </EntityType> - <EntityType Name="GLOBAL_DATA_STORE_ITEMS"> - <Key> - <PropertyRef Name="GUID" /> - </Key> - <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" /> - <Property Name="COLLECTION_NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> - <Property Name="KEY" Type="nvarchar" MaxLength="50" Nullable="false" /> - <Property Name="DATA_TYPE" Type="int" Nullable="false" /> - <Property Name="VALUE" Type="image" Nullable="false" /> - </EntityType> <EntityType Name="HARDWARE_BLOWER_TYPES"> <Key> <PropertyRef Name="GUID" /> @@ -508,7 +452,6 @@ <Property Name="T_ON_MIN" Type="int" Nullable="false" /> <Property Name="T_OFF_MIN" Type="int" Nullable="false" /> <Property Name="ACTIVE" Type="bit" Nullable="false" /> - <Property Name="P01_CONFIG_WORD" Type="int" Nullable="false" /> </EntityType> <EntityType Name="HARDWARE_PID_CONTROL_TYPES"> <Key> @@ -643,35 +586,12 @@ <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" /> - <Property Name="MACHINE_GUID" Type="varchar" MaxLength="36" /> - <Property Name="JOB_GUID" Type="varchar" MaxLength="36" /> - <Property Name="RML_GUID" Type="varchar" MaxLength="36" /> - <Property Name="USER_GUID" Type="varchar" MaxLength="36" /> - <Property Name="JOB_NAME" Type="nvarchar" MaxLength="100" /> - <Property Name="JOB_DESIGNATION" Type="int" Nullable="false" /> - <Property Name="JOB_SOURCE" Type="int" Nullable="false" /> - <Property Name="JOB_STRING" Type="nvarchar(max)" /> + <Property Name="JOB_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="START_DATE" Type="datetime2" Precision="3" Nullable="false" /> - <Property Name="UPLOADING_START_DATE" Type="datetime2" Precision="3" /> - <Property Name="HEATING_START_DATE" Type="datetime2" Precision="3" /> - <Property Name="ACTUAL_START_DATE" Type="datetime2" Precision="3" /> <Property Name="END_DATE" Type="datetime2" Precision="3" Nullable="false" /> <Property Name="STATUS" Type="int" Nullable="false" /> - <Property Name="JOB_LENGTH" Type="float" Nullable="false" /> - <Property Name="IS_GRADIENT" Type="bit" Nullable="false" /> - <Property Name="GRADIENT_RESOLUTION_CM" Type="int" Nullable="false" /> - <Property Name="LIQUID_QUANTITY_STRING" Type="nvarchar(max)" /> - <Property Name="CYAN_QUANTITY" Type="int" Nullable="false" /> - <Property Name="MAGENTA_QUANTITY" Type="int" Nullable="false" /> - <Property Name="YELLOW_QUANTITY" Type="int" Nullable="false" /> - <Property Name="BLACK_QUANTITY" Type="int" Nullable="false" /> - <Property Name="TRANSPARENT_QUANTITY" Type="int" Nullable="false" /> - <Property Name="LUBRICANT_QUANTITY" Type="int" Nullable="false" /> - <Property Name="CLEANER_QUANTITY" Type="int" Nullable="false" /> <Property Name="END_POSITION" Type="float" Nullable="false" /> <Property Name="FAILED_MESSAGE" Type="nvarchar" MaxLength="300" /> - <Property Name="IS_HEAD_CLEANING" Type="bit" Nullable="false" /> - <Property Name="IS_SYNCHRONIZED" Type="bit" Nullable="false" /> </EntityType> <EntityType Name="JOBS"> <Key> @@ -683,7 +603,7 @@ <Property Name="CREATION_DATE" Type="datetime2" Precision="3" Nullable="false" /> <Property Name="LAST_RUN" Type="datetime2" Precision="3" /> <Property Name="MACHINE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="USER_GUID" Type="varchar" MaxLength="36" /> + <Property Name="USER_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="RML_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="WINDING_METHOD_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="SPOOL_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> @@ -713,8 +633,6 @@ <Property Name="SAMPLE_DYE_APPROVE_DATE" Type="datetime2" Precision="3" /> <Property Name="EDITING_STATE" Type="int" Nullable="false" /> <Property Name="LENGTH_PERCENTAGE_FACTOR" Type="float" Nullable="false" /> - <Property Name="IS_SYNCHRONIZED" Type="bit" Nullable="false" /> - <Property Name="SOURCE" Type="int" Nullable="false" /> </EntityType> <EntityType Name="LINEAR_MASS_DENSITY_UNITS"> <Key> @@ -739,7 +657,6 @@ <Property Name="COLOR" Type="int" Nullable="false" /> <Property Name="PREFERRED_INDEX" Type="int" Nullable="false" /> <Property Name="HAS_PIGMENT" Type="bit" Nullable="false" /> - <Property Name="SHORT_NAME" Type="nvarchar" MaxLength="4" /> </EntityType> <EntityType Name="LIQUID_TYPES_RMLS"> <Key> @@ -788,7 +705,6 @@ <Property Name="NAME" Type="nvarchar" MaxLength="50" /> <Property Name="PRODUCTION_DATE" Type="datetime" Nullable="false" /> <Property Name="ORGANIZATION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="SITE_GUID" Type="varchar" MaxLength="36" /> <Property Name="MACHINE_VERSION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="CONFIGURATION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="DEFAULT_RML_GUID" Type="varchar" MaxLength="36" /> @@ -814,8 +730,6 @@ <Property Name="IS_DEVICE_REGISTERED" Type="bit" Nullable="false" /> <Property Name="DEVICE_ID" Type="nvarchar(max)" /> <Property Name="DEVICE_NAME" Type="nvarchar" MaxLength="200" /> - <Property Name="HEAD_TYPE" Type="int" Nullable="false" /> - <Property Name="ACTIVATION_KEY" Type="varchar" MaxLength="8" /> </EntityType> <EntityType Name="MACHINES_EVENTS"> <Key> @@ -830,7 +744,6 @@ <Property Name="USER_GUID" Type="varchar" MaxLength="36" /> <Property Name="DATE_TIME" Type="datetime2" Precision="3" Nullable="false" /> <Property Name="DESCRIPTION" Type="nvarchar(max)" /> - <Property Name="IS_SYNCHRONIZED" Type="bit" Nullable="false" /> </EntityType> <EntityType Name="MEDIA_CONDITIONS"> <Key> @@ -892,7 +805,7 @@ <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" /> <Property Name="CODE" Type="int" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="60" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="40" Nullable="false" /> <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="100" Nullable="false" /> </EntityType> <EntityType Name="PROCESS_PARAMETERS_TABLES"> @@ -924,17 +837,6 @@ <Property Name="HEAD_AIR_FLOW" Type="float" Nullable="false" /> <Property Name="PROCESS_PARAMETERS_TABLES_GROUP_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="TABLE_INDEX" Type="int" Nullable="false" /> - <Property Name="HEAD_ZONE7_TEMP" Type="float" Nullable="false" /> - <Property Name="HEAD_ZONE8_TEMP" Type="float" Nullable="false" /> - <Property Name="HEAD_ZONE9_TEMP" Type="float" Nullable="false" /> - <Property Name="HEAD_ZONE10_TEMP" Type="float" Nullable="false" /> - <Property Name="HEAD_ZONE11_TEMP" Type="float" Nullable="false" /> - <Property Name="HEAD_ZONE12_TEMP" Type="float" Nullable="false" /> - <Property Name="R_BLOWER_FLOW" Type="float" Nullable="false" /> - <Property Name="R_BLOWER_TEMP" Type="float" Nullable="false" /> - <Property Name="L_BLOWER_FLOW" Type="float" Nullable="false" /> - <Property Name="L_BLOWER_TEMP" Type="float" Nullable="false" /> - <Property Name="PRESSURE_BUILD_UP" Type="float" Nullable="false" /> </EntityType> <EntityType Name="PROCESS_PARAMETERS_TABLES_GROUPS"> <Key> @@ -948,32 +850,6 @@ <Property Name="ACTIVE" Type="bit" Nullable="false" /> <Property Name="SAVE_DATE" Type="datetime2" Precision="3" Nullable="false" /> </EntityType> - <EntityType Name="PUBLISHED_PROCEDURE_PROJECTS"> - <Key> - <PropertyRef Name="GUID" /> - </Key> - <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="100" Nullable="false" /> - <Property Name="DESCRIPTION" Type="nvarchar(max)" /> - <Property Name="PUBLISH_DATE" Type="datetime2" Precision="3" Nullable="false" /> - <Property Name="SORTING_INDEX" Type="int" Nullable="false" /> - <Property Name="IS_VISIBLE" Type="bit" Nullable="false" /> - <Property Name="VISIBILITY" Type="int" Nullable="false" /> - </EntityType> - <EntityType Name="PUBLISHED_PROCEDURE_PROJECTS_VERSIONS"> - <Key> - <PropertyRef Name="GUID" /> - </Key> - <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" /> - <Property Name="PUBLISHED_PROCEDURE_PROJECT_GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="VERSION" Type="int" Nullable="false" /> - <Property Name="AUTHOR" Type="nvarchar" MaxLength="200" Nullable="false" /> - <Property Name="PROJECT_JSON_STRING" Type="nvarchar(max)" Nullable="false" /> - </EntityType> <EntityType Name="RMLS"> <Key> <PropertyRef Name="GUID" /> @@ -982,7 +858,6 @@ <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" /> <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> - <Property Name="DISPLAY_NAME" Type="nvarchar" MaxLength="200" /> <Property Name="MANUFACTURER" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="CODE" Type="int" Nullable="false" /> <Property Name="WHITE_POINT_L" Type="float" Nullable="false" /> @@ -1008,37 +883,6 @@ <Property Name="THUMBNAIL" Type="image" /> <Property Name="CCT_GUID" Type="varchar" MaxLength="36" /> <Property Name="COLOR_CONVERSION_VERSION" Type="int" Nullable="false" /> - <Property Name="USE_COLOR_LIB_GRADIENTS" Type="bit" Nullable="false" /> - <Property Name="HEAD_TYPE" Type="int" Nullable="false" /> - <Property Name="QUALIFICATION_LEVEL" Type="int" Nullable="false" /> - <Property Name="QUALIFICATION_DATE" Type="datetime2" Precision="3" /> - <Property Name="SPOOLS_CALIBRATIONS_STRING" Type="nvarchar(max)" /> - <Property Name="FEEDER_P" Type="int" Nullable="false" /> - <Property Name="FEEDER_I" Type="int" Nullable="false" /> - <Property Name="FEEDER_D" Type="int" Nullable="false" /> - <Property Name="PULLER_P" Type="int" Nullable="false" /> - <Property Name="PULLER_I" Type="int" Nullable="false" /> - <Property Name="PULLER_D" Type="int" Nullable="false" /> - <Property Name="WINDER_P" Type="int" Nullable="false" /> - <Property Name="WINDER_I" Type="int" Nullable="false" /> - <Property Name="WINDER_D" Type="int" Nullable="false" /> - <Property Name="BYPASS_ROCKERS" Type="bit" Nullable="false" /> - <Property Name="CLEANER_FLOW" Type="int" Nullable="false" /> - <Property Name="ARC_HEAD_CLEANING_MOTOR_SPEED" Type="float" Nullable="false" /> - </EntityType> - <EntityType Name="RMLS_SPOOLS"> - <Key> - <PropertyRef Name="GUID" /> - </Key> - <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" /> - <Property Name="SPOOL_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="RML_GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="ROTATIONS_PER_PASSAGE" Type="float" /> - <Property Name="LENGTH" Type="float" /> - <Property Name="BACKING_RATE" Type="int" /> - <Property Name="BOTTOM_BACKING_RATE" Type="int" /> </EntityType> <EntityType Name="ROLES"> <Key> @@ -1073,37 +917,6 @@ <Property Name="LENGTH" Type="float" Nullable="false" /> <Property Name="SEGMENT_INDEX" Type="int" Nullable="false" /> </EntityType> - <EntityType Name="SITES"> - <Key> - <PropertyRef Name="GUID" /> - </Key> - <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" /> - <Property Name="ORGANIZATION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="100" Nullable="false" /> - <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="200" /> - </EntityType> - <EntityType Name="SITES_CATALOGS"> - <Key> - <PropertyRef Name="GUID" /> - </Key> - <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" /> - <Property Name="SITE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="COLOR_CATALOG_GUID" Type="varchar" MaxLength="36" Nullable="false" /> - </EntityType> - <EntityType Name="SITES_RMLS"> - <Key> - <PropertyRef Name="GUID" /> - </Key> - <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" /> - <Property Name="SITE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="RML_GUID" Type="varchar" MaxLength="36" Nullable="false" /> - </EntityType> <EntityType Name="SPOOL_TYPES"> <Key> <PropertyRef Name="GUID" /> @@ -1117,11 +930,6 @@ <Property Name="WEIGHT" Type="float" Nullable="false" /> <Property Name="DIAMETER" Type="float" Nullable="false" /> <Property Name="ROTATIONS_PER_PASSAGE" Type="float" Nullable="false" /> - <Property Name="START_OFFSET_PULSES" Type="int" Nullable="false" /> - <Property Name="BACKING_RATE" Type="int" Nullable="false" /> - <Property Name="SEGMENT_OFFSET_PULSES" Type="int" Nullable="false" /> - <Property Name="BOTTOM_BACKING_RATE" Type="int" Nullable="false" /> - <Property Name="LIMIT_SWITCH_START_POINT_OFFSET" Type="int" Nullable="false" /> </EntityType> <EntityType Name="SPOOLS"> <Key> @@ -1132,11 +940,10 @@ <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" /> <Property Name="SPOOL_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="MACHINE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="START_OFFSET_PULSES" Type="int" /> - <Property Name="BACKING_RATE" Type="int" /> - <Property Name="SEGMENT_OFFSET_PULSES" Type="int" /> - <Property Name="BOTTOM_BACKING_RATE" Type="int" /> - <Property Name="LIMIT_SWITCH_START_POINT_OFFSET" Type="int" /> + <Property Name="START_OFFSET_PULSES" Type="int" Nullable="false" /> + <Property Name="BACKING_RATE" Type="int" Nullable="false" /> + <Property Name="SEGMENT_OFFSET_PULSES" Type="int" Nullable="false" /> + <Property Name="BOTTOM_BACKING_RATE" Type="int" Nullable="false" /> </EntityType> <EntityType Name="SYNC_CONFIGURATIONS"> <Key> @@ -1156,23 +963,6 @@ <Property Name="version" Type="int" /> <Property Name="definition" Type="varbinary(max)" /> </EntityType> - <EntityType Name="TANGO_UPDATES"> - <Key> - <PropertyRef Name="GUID" /> - </Key> - <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> - <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" /> - <Property Name="APPLICATION_VERSION" Type="varchar" MaxLength="50" /> - <Property Name="FIRMWARE_VERSION" Type="varchar" MaxLength="50" /> - <Property Name="MACHINE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="STATUS" Type="int" Nullable="false" /> - <Property Name="FAILED_REASON" Type="nvarchar(max)" /> - <Property Name="FAILED_LOG" Type="nvarchar(max)" /> - <Property Name="START_DATE" Type="datetime2" Precision="3" Nullable="false" /> - <Property Name="END_DATE" Type="datetime2" Precision="3" /> - <Property Name="IS_SYNCHRONIZED" Type="bit" Nullable="false" /> - </EntityType> <EntityType Name="TANGO_VERSIONS"> <Key> <PropertyRef Name="GUID" /> @@ -1181,13 +971,12 @@ <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" /> <Property Name="VERSION" Type="varchar" MaxLength="50" Nullable="false" /> - <Property Name="FIRMWARE_VERSION" Type="varchar" MaxLength="50" /> + <Property Name="FIRMWARE_VERSION" Type="varchar" MaxLength="50" Nullable="false" /> <Property Name="BLOB_NAME" Type="varchar" MaxLength="200" Nullable="false" /> <Property Name="INSTALLER_BLOB_NAME" Type="varchar" MaxLength="200" /> <Property Name="COMMENTS" Type="nvarchar(max)" Nullable="false" /> <Property Name="USER_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="MACHINE_VERSION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> - <Property Name="DISABLED" Type="bit" Nullable="false" /> </EntityType> <EntityType Name="TECH_CONTROLLERS"> <Key> @@ -1289,7 +1078,6 @@ <Property Name="CONTACT_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="ADDRESS_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_LOGIN" Type="datetime2" Precision="3" /> - <Property Name="PASSWORD_CHANGE_REQUIRED" Type="bit" Nullable="false" /> </EntityType> <EntityType Name="USERS_ROLES"> <Key> @@ -1312,18 +1100,6 @@ <Property Name="NAME" Type="varchar" MaxLength="50" Nullable="false" /> <Property Name="DESCRIPTION" Type="varchar" MaxLength="100" Nullable="false" /> </EntityType> - <Association Name="FK_ACTION_LOGS_USERS"> - <End Role="USERS" Type="Self.USERS" Multiplicity="0..1" /> - <End Role="ACTION_LOGS" Type="Self.ACTION_LOGS" Multiplicity="*" /> - <ReferentialConstraint> - <Principal Role="USERS"> - <PropertyRef Name="GUID" /> - </Principal> - <Dependent Role="ACTION_LOGS"> - <PropertyRef Name="USER_GUID" /> - </Dependent> - </ReferentialConstraint> - </Association> <Association Name="FK_BRUSH_STOPS_COLOR_CATALOGS"> <End Role="COLOR_CATALOGS" Type="Self.COLOR_CATALOGS" Multiplicity="0..1" /> <End Role="BRUSH_STOPS" Type="Self.BRUSH_STOPS" Multiplicity="*" /> @@ -1558,20 +1334,6 @@ </Dependent> </ReferentialConstraint> </Association> - <Association Name="FK_DATA_STORES_MACHINES"> - <End Role="MACHINES" Type="Self.MACHINES" Multiplicity="0..1"> - <OnDelete Action="Cascade" /> - </End> - <End Role="DATA_STORE_ITEMS" Type="Self.DATA_STORE_ITEMS" Multiplicity="*" /> - <ReferentialConstraint> - <Principal Role="MACHINES"> - <PropertyRef Name="GUID" /> - </Principal> - <Dependent Role="DATA_STORE_ITEMS"> - <PropertyRef Name="MACHINE_GUID" /> - </Dependent> - </ReferentialConstraint> - </Association> <Association Name="FK_DISPENSERS_DISPENSER_TYPES"> <End Role="DISPENSER_TYPES" Type="Self.DISPENSER_TYPES" Multiplicity="1" /> <End Role="DISPENSERS" Type="Self.DISPENSERS" Multiplicity="*" /> @@ -1584,18 +1346,6 @@ </Dependent> </ReferentialConstraint> </Association> - <Association Name="FK_FSE_VERSIONS_USERS"> - <End Role="USERS" Type="Self.USERS" Multiplicity="1" /> - <End Role="FSE_VERSIONS" Type="Self.FSE_VERSIONS" Multiplicity="*" /> - <ReferentialConstraint> - <Principal Role="USERS"> - <PropertyRef Name="GUID" /> - </Principal> - <Dependent Role="FSE_VERSIONS"> - <PropertyRef Name="USER_GUID" /> - </Dependent> - </ReferentialConstraint> - </Association> <Association Name="FK_HARDWARE_BLOWERS_HARDWARE_BLOWER_TYPES"> <End Role="HARDWARE_BLOWER_TYPES" Type="Self.HARDWARE_BLOWER_TYPES" Multiplicity="1"> <OnDelete Action="Cascade" /> @@ -1848,6 +1598,20 @@ </Dependent> </ReferentialConstraint> </Association> + <Association Name="FK_JOB_RUNS_JOBS"> + <End Role="JOBS" Type="Self.JOBS" Multiplicity="1"> + <OnDelete Action="Cascade" /> + </End> + <End Role="JOB_RUNS" Type="Self.JOB_RUNS" Multiplicity="*" /> + <ReferentialConstraint> + <Principal Role="JOBS"> + <PropertyRef Name="GUID" /> + </Principal> + <Dependent Role="JOB_RUNS"> + <PropertyRef Name="JOB_GUID" /> + </Dependent> + </ReferentialConstraint> + </Association> <Association Name="FK_JOBS_COLOR_CATALOGS"> <End Role="COLOR_CATALOGS" Type="Self.COLOR_CATALOGS" Multiplicity="0..1" /> <End Role="JOBS" Type="Self.JOBS" Multiplicity="*" /> @@ -1899,9 +1663,7 @@ </ReferentialConstraint> </Association> <Association Name="FK_JOBS_RMLS"> - <End Role="RMLS" Type="Self.RMLS" Multiplicity="1"> - <OnDelete Action="Cascade" /> - </End> + <End Role="RMLS" Type="Self.RMLS" Multiplicity="1" /> <End Role="JOBS" Type="Self.JOBS" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="RMLS"> @@ -1925,7 +1687,7 @@ </ReferentialConstraint> </Association> <Association Name="FK_JOBS_USERS"> - <End Role="USERS" Type="Self.USERS" Multiplicity="0..1" /> + <End Role="USERS" Type="Self.USERS" Multiplicity="1" /> <End Role="JOBS" Type="Self.JOBS" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="USERS"> @@ -1988,6 +1750,18 @@ </Dependent> </ReferentialConstraint> </Association> + <Association Name="FK_MACHINES_COLOR_SPACES"> + <End Role="COLOR_SPACES" Type="Self.COLOR_SPACES" Multiplicity="0..1" /> + <End Role="MACHINES" Type="Self.MACHINES" Multiplicity="*" /> + <ReferentialConstraint> + <Principal Role="COLOR_SPACES"> + <PropertyRef Name="GUID" /> + </Principal> + <Dependent Role="MACHINES"> + <PropertyRef Name="DEFAULT_COLOR_SPACE_GUID" /> + </Dependent> + </ReferentialConstraint> + </Association> <Association Name="FK_MACHINES_CONFIGURATIONS"> <End Role="CONFIGURATIONS" Type="Self.CONFIGURATIONS" Multiplicity="1"> <OnDelete Action="Cascade" /> @@ -2017,9 +1791,7 @@ </ReferentialConstraint> </Association> <Association Name="FK_MACHINES_EVENTS_MACHINES"> - <End Role="MACHINES" Type="Self.MACHINES" Multiplicity="0..1"> - <OnDelete Action="Cascade" /> - </End> + <End Role="MACHINES" Type="Self.MACHINES" Multiplicity="0..1" /> <End Role="MACHINES_EVENTS" Type="Self.MACHINES_EVENTS" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="MACHINES"> @@ -2068,6 +1840,30 @@ </Dependent> </ReferentialConstraint> </Association> + <Association Name="FK_MACHINES_RMLS2"> + <End Role="RMLS" Type="Self.RMLS" Multiplicity="0..1" /> + <End Role="MACHINES" Type="Self.MACHINES" Multiplicity="*" /> + <ReferentialConstraint> + <Principal Role="RMLS"> + <PropertyRef Name="GUID" /> + </Principal> + <Dependent Role="MACHINES"> + <PropertyRef Name="DEFAULT_RML_GUID" /> + </Dependent> + </ReferentialConstraint> + </Association> + <Association Name="FK_MACHINES_SPOOL_TYPES"> + <End Role="SPOOL_TYPES" Type="Self.SPOOL_TYPES" Multiplicity="0..1" /> + <End Role="MACHINES" Type="Self.MACHINES" Multiplicity="*" /> + <ReferentialConstraint> + <Principal Role="SPOOL_TYPES"> + <PropertyRef Name="GUID" /> + </Principal> + <Dependent Role="MACHINES"> + <PropertyRef Name="DEFAULT_SPOOL_TYPE_GUID" /> + </Dependent> + </ReferentialConstraint> + </Association> <Association Name="FK_ORGANIZATIONS_ADDRESSES"> <End Role="ADDRESSES" Type="Self.ADDRESSES" Multiplicity="1"> <OnDelete Action="Cascade" /> @@ -2124,20 +1920,6 @@ </Dependent> </ReferentialConstraint> </Association> - <Association Name="FK_PUBLISHED_TEST_PROJECTS_VERSIONS_PUBLISHED_TEST_PROJECTS"> - <End Role="PUBLISHED_PROCEDURE_PROJECTS" Type="Self.PUBLISHED_PROCEDURE_PROJECTS" Multiplicity="1"> - <OnDelete Action="Cascade" /> - </End> - <End Role="PUBLISHED_PROCEDURE_PROJECTS_VERSIONS" Type="Self.PUBLISHED_PROCEDURE_PROJECTS_VERSIONS" Multiplicity="*" /> - <ReferentialConstraint> - <Principal Role="PUBLISHED_PROCEDURE_PROJECTS"> - <PropertyRef Name="GUID" /> - </Principal> - <Dependent Role="PUBLISHED_PROCEDURE_PROJECTS_VERSIONS"> - <PropertyRef Name="PUBLISHED_PROCEDURE_PROJECT_GUID" /> - </Dependent> - </ReferentialConstraint> - </Association> <Association Name="FK_RML_FIBER_SHAPES"> <End Role="FIBER_SHAPES" Type="Self.FIBER_SHAPES" Multiplicity="1" /> <End Role="RMLS" Type="Self.RMLS" Multiplicity="*" /> @@ -2222,34 +2004,6 @@ </Dependent> </ReferentialConstraint> </Association> - <Association Name="FK_RMLS_SPOOLS_RMLS"> - <End Role="RMLS" Type="Self.RMLS" Multiplicity="1"> - <OnDelete Action="Cascade" /> - </End> - <End Role="RMLS_SPOOLS" Type="Self.RMLS_SPOOLS" Multiplicity="*" /> - <ReferentialConstraint> - <Principal Role="RMLS"> - <PropertyRef Name="GUID" /> - </Principal> - <Dependent Role="RMLS_SPOOLS"> - <PropertyRef Name="RML_GUID" /> - </Dependent> - </ReferentialConstraint> - </Association> - <Association Name="FK_RMLS_SPOOLS_SPOOL_TYPES"> - <End Role="SPOOL_TYPES" Type="Self.SPOOL_TYPES" Multiplicity="1"> - <OnDelete Action="Cascade" /> - </End> - <End Role="RMLS_SPOOLS" Type="Self.RMLS_SPOOLS" Multiplicity="*" /> - <ReferentialConstraint> - <Principal Role="SPOOL_TYPES"> - <PropertyRef Name="GUID" /> - </Principal> - <Dependent Role="RMLS_SPOOLS"> - <PropertyRef Name="SPOOL_TYPE_GUID" /> - </Dependent> - </ReferentialConstraint> - </Association> <Association Name="FK_ROLES_PERMISSIONS_PERMISSIONS"> <End Role="PERMISSIONS" Type="Self.PERMISSIONS" Multiplicity="1"> <OnDelete Action="Cascade" /> @@ -2292,74 +2046,6 @@ </Dependent> </ReferentialConstraint> </Association> - <Association Name="FK_SITES_CATALOGS_COLOR_CATALOGS"> - <End Role="COLOR_CATALOGS" Type="Self.COLOR_CATALOGS" Multiplicity="1"> - <OnDelete Action="Cascade" /> - </End> - <End Role="SITES_CATALOGS" Type="Self.SITES_CATALOGS" Multiplicity="*" /> - <ReferentialConstraint> - <Principal Role="COLOR_CATALOGS"> - <PropertyRef Name="GUID" /> - </Principal> - <Dependent Role="SITES_CATALOGS"> - <PropertyRef Name="COLOR_CATALOG_GUID" /> - </Dependent> - </ReferentialConstraint> - </Association> - <Association Name="FK_SITES_CATALOGS_SITES"> - <End Role="SITES" Type="Self.SITES" Multiplicity="1"> - <OnDelete Action="Cascade" /> - </End> - <End Role="SITES_CATALOGS" Type="Self.SITES_CATALOGS" Multiplicity="*" /> - <ReferentialConstraint> - <Principal Role="SITES"> - <PropertyRef Name="GUID" /> - </Principal> - <Dependent Role="SITES_CATALOGS"> - <PropertyRef Name="SITE_GUID" /> - </Dependent> - </ReferentialConstraint> - </Association> - <Association Name="FK_SITES_ORGANIZATIONS"> - <End Role="ORGANIZATIONS" Type="Self.ORGANIZATIONS" Multiplicity="1" /> - <End Role="SITES" Type="Self.SITES" Multiplicity="*" /> - <ReferentialConstraint> - <Principal Role="ORGANIZATIONS"> - <PropertyRef Name="GUID" /> - </Principal> - <Dependent Role="SITES"> - <PropertyRef Name="ORGANIZATION_GUID" /> - </Dependent> - </ReferentialConstraint> - </Association> - <Association Name="FK_SITES_RMLS_RMLS"> - <End Role="RMLS" Type="Self.RMLS" Multiplicity="1"> - <OnDelete Action="Cascade" /> - </End> - <End Role="SITES_RMLS" Type="Self.SITES_RMLS" Multiplicity="*" /> - <ReferentialConstraint> - <Principal Role="RMLS"> - <PropertyRef Name="GUID" /> - </Principal> - <Dependent Role="SITES_RMLS"> - <PropertyRef Name="RML_GUID" /> - </Dependent> - </ReferentialConstraint> - </Association> - <Association Name="FK_SITES_RMLS_SITES"> - <End Role="SITES" Type="Self.SITES" Multiplicity="1"> - <OnDelete Action="Cascade" /> - </End> - <End Role="SITES_RMLS" Type="Self.SITES_RMLS" Multiplicity="*" /> - <ReferentialConstraint> - <Principal Role="SITES"> - <PropertyRef Name="GUID" /> - </Principal> - <Dependent Role="SITES_RMLS"> - <PropertyRef Name="SITE_GUID" /> - </Dependent> - </ReferentialConstraint> - </Association> <Association Name="FK_SPOOLS_MACHINES"> <End Role="MACHINES" Type="Self.MACHINES" Multiplicity="1"> <OnDelete Action="Cascade" /> @@ -2375,9 +2061,7 @@ </ReferentialConstraint> </Association> <Association Name="FK_SPOOLS_SPOOL_TYPES"> - <End Role="SPOOL_TYPES" Type="Self.SPOOL_TYPES" Multiplicity="1"> - <OnDelete Action="Cascade" /> - </End> + <End Role="SPOOL_TYPES" Type="Self.SPOOL_TYPES" Multiplicity="1" /> <End Role="SPOOLS" Type="Self.SPOOLS" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="SPOOL_TYPES"> @@ -2463,9 +2147,7 @@ </ReferentialConstraint> </Association> <Association Name="FK_USERS_ROLES_USERS"> - <End Role="USERS" Type="Self.USERS" Multiplicity="1"> - <OnDelete Action="Cascade" /> - </End> + <End Role="USERS" Type="Self.USERS" Multiplicity="1" /> <End Role="USERS_ROLES" Type="Self.USERS_ROLES" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="USERS"> @@ -2477,7 +2159,6 @@ </ReferentialConstraint> </Association> <EntityContainer Name="RemoteModelStoreContainer"> - <EntitySet Name="ACTION_LOGS" EntityType="Self.ACTION_LOGS" 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" /> @@ -2494,15 +2175,12 @@ <EntitySet Name="CONFIGURATIONS" EntityType="Self.CONFIGURATIONS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="CONTACTS" EntityType="Self.CONTACTS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="CUSTOMERS" EntityType="Self.CUSTOMERS" Schema="dbo" store:Type="Tables" /> - <EntitySet Name="DATA_STORE_ITEMS" EntityType="Self.DATA_STORE_ITEMS" 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="EVENT_TYPES" EntityType="Self.EVENT_TYPES" 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="FSE_VERSIONS" EntityType="Self.FSE_VERSIONS" Schema="dbo" store:Type="Tables" /> - <EntitySet Name="GLOBAL_DATA_STORE_ITEMS" EntityType="Self.GLOBAL_DATA_STORE_ITEMS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="HARDWARE_BLOWER_TYPES" EntityType="Self.HARDWARE_BLOWER_TYPES" Schema="dbo" store:Type="Tables" /> <EntitySet Name="HARDWARE_BLOWERS" EntityType="Self.HARDWARE_BLOWERS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="HARDWARE_BREAK_SENSOR_TYPES" EntityType="Self.HARDWARE_BREAK_SENSOR_TYPES" Schema="dbo" store:Type="Tables" /> @@ -2537,21 +2215,14 @@ <EntitySet Name="PERMISSIONS" EntityType="Self.PERMISSIONS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="PROCESS_PARAMETERS_TABLES" EntityType="Self.PROCESS_PARAMETERS_TABLES" Schema="dbo" store:Type="Tables" /> <EntitySet Name="PROCESS_PARAMETERS_TABLES_GROUPS" EntityType="Self.PROCESS_PARAMETERS_TABLES_GROUPS" Schema="dbo" store:Type="Tables" /> - <EntitySet Name="PUBLISHED_PROCEDURE_PROJECTS" EntityType="Self.PUBLISHED_PROCEDURE_PROJECTS" Schema="dbo" store:Type="Tables" /> - <EntitySet Name="PUBLISHED_PROCEDURE_PROJECTS_VERSIONS" EntityType="Self.PUBLISHED_PROCEDURE_PROJECTS_VERSIONS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="RMLS" EntityType="Self.RMLS" Schema="dbo" store:Type="Tables" /> - <EntitySet Name="RMLS_SPOOLS" EntityType="Self.RMLS_SPOOLS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="ROLES" EntityType="Self.ROLES" Schema="dbo" store:Type="Tables" /> <EntitySet Name="ROLES_PERMISSIONS" EntityType="Self.ROLES_PERMISSIONS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="SEGMENTS" EntityType="Self.SEGMENTS" Schema="dbo" store:Type="Tables" /> - <EntitySet Name="SITES" EntityType="Self.SITES" Schema="dbo" store:Type="Tables" /> - <EntitySet Name="SITES_CATALOGS" EntityType="Self.SITES_CATALOGS" Schema="dbo" store:Type="Tables" /> - <EntitySet Name="SITES_RMLS" EntityType="Self.SITES_RMLS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="SPOOL_TYPES" EntityType="Self.SPOOL_TYPES" Schema="dbo" store:Type="Tables" /> <EntitySet Name="SPOOLS" EntityType="Self.SPOOLS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="SYNC_CONFIGURATIONS" EntityType="Self.SYNC_CONFIGURATIONS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="sysdiagrams" EntityType="Self.sysdiagrams" Schema="dbo" store:Type="Tables" /> - <EntitySet Name="TANGO_UPDATES" EntityType="Self.TANGO_UPDATES" Schema="dbo" store:Type="Tables" /> <EntitySet Name="TANGO_VERSIONS" EntityType="Self.TANGO_VERSIONS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="TECH_CONTROLLERS" EntityType="Self.TECH_CONTROLLERS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="TECH_DISPENSERS" EntityType="Self.TECH_DISPENSERS" Schema="dbo" store:Type="Tables" /> @@ -2562,10 +2233,6 @@ <EntitySet Name="USERS" EntityType="Self.USERS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="USERS_ROLES" EntityType="Self.USERS_ROLES" Schema="dbo" store:Type="Tables" /> <EntitySet Name="WINDING_METHODS" EntityType="Self.WINDING_METHODS" Schema="dbo" store:Type="Tables" /> - <AssociationSet Name="FK_ACTION_LOGS_USERS" Association="Self.FK_ACTION_LOGS_USERS"> - <End Role="USERS" EntitySet="USERS" /> - <End Role="ACTION_LOGS" EntitySet="ACTION_LOGS" /> - </AssociationSet> <AssociationSet Name="FK_BRUSH_STOPS_COLOR_CATALOGS" Association="Self.FK_BRUSH_STOPS_COLOR_CATALOGS"> <End Role="COLOR_CATALOGS" EntitySet="COLOR_CATALOGS" /> <End Role="BRUSH_STOPS" EntitySet="BRUSH_STOPS" /> @@ -2638,18 +2305,10 @@ <End Role="ORGANIZATIONS" EntitySet="ORGANIZATIONS" /> <End Role="CUSTOMERS" EntitySet="CUSTOMERS" /> </AssociationSet> - <AssociationSet Name="FK_DATA_STORES_MACHINES" Association="Self.FK_DATA_STORES_MACHINES"> - <End Role="MACHINES" EntitySet="MACHINES" /> - <End Role="DATA_STORE_ITEMS" EntitySet="DATA_STORE_ITEMS" /> - </AssociationSet> <AssociationSet Name="FK_DISPENSERS_DISPENSER_TYPES" Association="Self.FK_DISPENSERS_DISPENSER_TYPES"> <End Role="DISPENSER_TYPES" EntitySet="DISPENSER_TYPES" /> <End Role="DISPENSERS" EntitySet="DISPENSERS" /> </AssociationSet> - <AssociationSet Name="FK_FSE_VERSIONS_USERS" Association="Self.FK_FSE_VERSIONS_USERS"> - <End Role="USERS" EntitySet="USERS" /> - <End Role="FSE_VERSIONS" EntitySet="FSE_VERSIONS" /> - </AssociationSet> <AssociationSet Name="FK_HARDWARE_BLOWERS_HARDWARE_BLOWER_TYPES" Association="Self.FK_HARDWARE_BLOWERS_HARDWARE_BLOWER_TYPES"> <End Role="HARDWARE_BLOWER_TYPES" EntitySet="HARDWARE_BLOWER_TYPES" /> <End Role="HARDWARE_BLOWERS" EntitySet="HARDWARE_BLOWERS" /> @@ -2726,6 +2385,10 @@ <End Role="MID_TANK_TYPES" EntitySet="MID_TANK_TYPES" /> <End Role="IDS_PACKS" EntitySet="IDS_PACKS" /> </AssociationSet> + <AssociationSet Name="FK_JOB_RUNS_JOBS" Association="Self.FK_JOB_RUNS_JOBS"> + <End Role="JOBS" EntitySet="JOBS" /> + <End Role="JOB_RUNS" EntitySet="JOB_RUNS" /> + </AssociationSet> <AssociationSet Name="FK_JOBS_COLOR_CATALOGS" Association="Self.FK_JOBS_COLOR_CATALOGS"> <End Role="COLOR_CATALOGS" EntitySet="COLOR_CATALOGS" /> <End Role="JOBS" EntitySet="JOBS" /> @@ -2770,6 +2433,10 @@ <End Role="USERS" EntitySet="USERS" /> <End Role="MACHINE_STUDIO_VERSIONS" EntitySet="MACHINE_STUDIO_VERSIONS" /> </AssociationSet> + <AssociationSet Name="FK_MACHINES_COLOR_SPACES" Association="Self.FK_MACHINES_COLOR_SPACES"> + <End Role="COLOR_SPACES" EntitySet="COLOR_SPACES" /> + <End Role="MACHINES" EntitySet="MACHINES" /> + </AssociationSet> <AssociationSet Name="FK_MACHINES_CONFIGURATIONS" Association="Self.FK_MACHINES_CONFIGURATIONS"> <End Role="CONFIGURATIONS" EntitySet="CONFIGURATIONS" /> <End Role="MACHINES" EntitySet="MACHINES" /> @@ -2794,6 +2461,14 @@ <End Role="ORGANIZATIONS" EntitySet="ORGANIZATIONS" /> <End Role="MACHINES" EntitySet="MACHINES" /> </AssociationSet> + <AssociationSet Name="FK_MACHINES_RMLS2" Association="Self.FK_MACHINES_RMLS2"> + <End Role="RMLS" EntitySet="RMLS" /> + <End Role="MACHINES" EntitySet="MACHINES" /> + </AssociationSet> + <AssociationSet Name="FK_MACHINES_SPOOL_TYPES" Association="Self.FK_MACHINES_SPOOL_TYPES"> + <End Role="SPOOL_TYPES" EntitySet="SPOOL_TYPES" /> + <End Role="MACHINES" EntitySet="MACHINES" /> + </AssociationSet> <AssociationSet Name="FK_ORGANIZATIONS_ADDRESSES" Association="Self.FK_ORGANIZATIONS_ADDRESSES"> <End Role="ADDRESSES" EntitySet="ADDRESSES" /> <End Role="ORGANIZATIONS" EntitySet="ORGANIZATIONS" /> @@ -2810,10 +2485,6 @@ <End Role="PROCESS_PARAMETERS_TABLES_GROUPS" EntitySet="PROCESS_PARAMETERS_TABLES_GROUPS" /> <End Role="PROCESS_PARAMETERS_TABLES" EntitySet="PROCESS_PARAMETERS_TABLES" /> </AssociationSet> - <AssociationSet Name="FK_PUBLISHED_TEST_PROJECTS_VERSIONS_PUBLISHED_TEST_PROJECTS" Association="Self.FK_PUBLISHED_TEST_PROJECTS_VERSIONS_PUBLISHED_TEST_PROJECTS"> - <End Role="PUBLISHED_PROCEDURE_PROJECTS" EntitySet="PUBLISHED_PROCEDURE_PROJECTS" /> - <End Role="PUBLISHED_PROCEDURE_PROJECTS_VERSIONS" EntitySet="PUBLISHED_PROCEDURE_PROJECTS_VERSIONS" /> - </AssociationSet> <AssociationSet Name="FK_RML_FIBER_SHAPES" Association="Self.FK_RML_FIBER_SHAPES"> <End Role="FIBER_SHAPES" EntitySet="FIBER_SHAPES" /> <End Role="RMLS" EntitySet="RMLS" /> @@ -2842,14 +2513,6 @@ <End Role="CCTS" EntitySet="CCTS" /> <End Role="RMLS" EntitySet="RMLS" /> </AssociationSet> - <AssociationSet Name="FK_RMLS_SPOOLS_RMLS" Association="Self.FK_RMLS_SPOOLS_RMLS"> - <End Role="RMLS" EntitySet="RMLS" /> - <End Role="RMLS_SPOOLS" EntitySet="RMLS_SPOOLS" /> - </AssociationSet> - <AssociationSet Name="FK_RMLS_SPOOLS_SPOOL_TYPES" Association="Self.FK_RMLS_SPOOLS_SPOOL_TYPES"> - <End Role="SPOOL_TYPES" EntitySet="SPOOL_TYPES" /> - <End Role="RMLS_SPOOLS" EntitySet="RMLS_SPOOLS" /> - </AssociationSet> <AssociationSet Name="FK_ROLES_PERMISSIONS_PERMISSIONS" Association="Self.FK_ROLES_PERMISSIONS_PERMISSIONS"> <End Role="PERMISSIONS" EntitySet="PERMISSIONS" /> <End Role="ROLES_PERMISSIONS" EntitySet="ROLES_PERMISSIONS" /> @@ -2862,26 +2525,6 @@ <End Role="JOBS" EntitySet="JOBS" /> <End Role="SEGMENTS" EntitySet="SEGMENTS" /> </AssociationSet> - <AssociationSet Name="FK_SITES_CATALOGS_COLOR_CATALOGS" Association="Self.FK_SITES_CATALOGS_COLOR_CATALOGS"> - <End Role="COLOR_CATALOGS" EntitySet="COLOR_CATALOGS" /> - <End Role="SITES_CATALOGS" EntitySet="SITES_CATALOGS" /> - </AssociationSet> - <AssociationSet Name="FK_SITES_CATALOGS_SITES" Association="Self.FK_SITES_CATALOGS_SITES"> - <End Role="SITES" EntitySet="SITES" /> - <End Role="SITES_CATALOGS" EntitySet="SITES_CATALOGS" /> - </AssociationSet> - <AssociationSet Name="FK_SITES_ORGANIZATIONS" Association="Self.FK_SITES_ORGANIZATIONS"> - <End Role="ORGANIZATIONS" EntitySet="ORGANIZATIONS" /> - <End Role="SITES" EntitySet="SITES" /> - </AssociationSet> - <AssociationSet Name="FK_SITES_RMLS_RMLS" Association="Self.FK_SITES_RMLS_RMLS"> - <End Role="RMLS" EntitySet="RMLS" /> - <End Role="SITES_RMLS" EntitySet="SITES_RMLS" /> - </AssociationSet> - <AssociationSet Name="FK_SITES_RMLS_SITES" Association="Self.FK_SITES_RMLS_SITES"> - <End Role="SITES" EntitySet="SITES" /> - <End Role="SITES_RMLS" EntitySet="SITES_RMLS" /> - </AssociationSet> <AssociationSet Name="FK_SPOOLS_MACHINES" Association="Self.FK_SPOOLS_MACHINES"> <End Role="MACHINES" EntitySet="MACHINES" /> <End Role="SPOOLS" EntitySet="SPOOLS" /> @@ -2925,7 +2568,6 @@ <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="SYNC_CONFIGURATIONS" EntityType="RemoteModel.SYNC_CONFIGURATIONS" /> - <EntitySet Name="ACTION_LOGS" EntityType="RemoteModel.ACTION_LOGS" /> <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" /> @@ -2942,15 +2584,12 @@ <EntitySet Name="CONFIGURATIONS" EntityType="RemoteModel.CONFIGURATION" /> <EntitySet Name="CONTACTS" EntityType="RemoteModel.CONTACT" /> <EntitySet Name="CUSTOMERS" EntityType="RemoteModel.CUSTOMER" /> - <EntitySet Name="DATA_STORE_ITEMS" EntityType="RemoteModel.DATA_STORE_ITEMS" /> <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="EVENT_TYPES" EntityType="RemoteModel.EVENT_TYPES" /> <EntitySet Name="FIBER_SHAPES" EntityType="RemoteModel.FIBER_SHAPES" /> <EntitySet Name="FIBER_SYNTHS" EntityType="RemoteModel.FIBER_SYNTHS" /> - <EntitySet Name="FSE_VERSIONS" EntityType="RemoteModel.FSE_VERSIONS" /> - <EntitySet Name="GLOBAL_DATA_STORE_ITEMS" EntityType="RemoteModel.GLOBAL_DATA_STORE_ITEMS" /> <EntitySet Name="HARDWARE_BLOWER_TYPES" EntityType="RemoteModel.HARDWARE_BLOWER_TYPES" /> <EntitySet Name="HARDWARE_BLOWERS" EntityType="RemoteModel.HARDWARE_BLOWERS" /> <EntitySet Name="HARDWARE_BREAK_SENSOR_TYPES" EntityType="RemoteModel.HARDWARE_BREAK_SENSOR_TYPES" /> @@ -2985,20 +2624,13 @@ <EntitySet Name="PERMISSIONS" EntityType="RemoteModel.PERMISSION" /> <EntitySet Name="PROCESS_PARAMETERS_TABLES" EntityType="RemoteModel.PROCESS_PARAMETERS_TABLES" /> <EntitySet Name="PROCESS_PARAMETERS_TABLES_GROUPS" EntityType="RemoteModel.PROCESS_PARAMETERS_TABLES_GROUPS" /> - <EntitySet Name="PUBLISHED_PROCEDURE_PROJECTS" EntityType="RemoteModel.PUBLISHED_PROCEDURE_PROJECTS" /> - <EntitySet Name="PUBLISHED_PROCEDURE_PROJECTS_VERSIONS" EntityType="RemoteModel.PUBLISHED_PROCEDURE_PROJECTS_VERSIONS" /> <EntitySet Name="RMLS" EntityType="RemoteModel.RML" /> - <EntitySet Name="RMLS_SPOOLS" EntityType="RemoteModel.RMLS_SPOOLS" /> <EntitySet Name="ROLES" EntityType="RemoteModel.ROLE" /> <EntitySet Name="ROLES_PERMISSIONS" EntityType="RemoteModel.ROLES_PERMISSIONS" /> <EntitySet Name="SEGMENTS" EntityType="RemoteModel.SEGMENT" /> - <EntitySet Name="SITES" EntityType="RemoteModel.SITE" /> - <EntitySet Name="SITES_CATALOGS" EntityType="RemoteModel.SITES_CATALOGS" /> - <EntitySet Name="SITES_RMLS" EntityType="RemoteModel.SITES_RMLS" /> <EntitySet Name="SPOOL_TYPES" EntityType="RemoteModel.SPOOL_TYPES" /> <EntitySet Name="SPOOLS" EntityType="RemoteModel.SPOOL" /> <EntitySet Name="sysdiagrams" EntityType="RemoteModel.sysdiagram" /> - <EntitySet Name="TANGO_UPDATES" EntityType="RemoteModel.TANGO_UPDATES" /> <EntitySet Name="TANGO_VERSIONS" EntityType="RemoteModel.TANGO_VERSIONS" /> <EntitySet Name="TECH_CONTROLLERS" EntityType="RemoteModel.TECH_CONTROLLERS" /> <EntitySet Name="TECH_DISPENSERS" EntityType="RemoteModel.TECH_DISPENSERS" /> @@ -3009,10 +2641,6 @@ <EntitySet Name="USERS" EntityType="RemoteModel.USER" /> <EntitySet Name="USERS_ROLES" EntityType="RemoteModel.USERS_ROLES" /> <EntitySet Name="WINDING_METHODS" EntityType="RemoteModel.WINDING_METHODS" /> - <AssociationSet Name="FK_ACTION_LOGS_USERS" Association="RemoteModel.FK_ACTION_LOGS_USERS"> - <End Role="USER" EntitySet="USERS" /> - <End Role="ACTION_LOGS" EntitySet="ACTION_LOGS" /> - </AssociationSet> <AssociationSet Name="FK_ORGANIZATIONS_ADDRESSES" Association="RemoteModel.FK_ORGANIZATIONS_ADDRESSES"> <End Role="ADDRESS" EntitySet="ADDRESSES" /> <End Role="ORGANIZATION" EntitySet="ORGANIZATIONS" /> @@ -3077,10 +2705,6 @@ <End Role="COLOR_CATALOGS" EntitySet="COLOR_CATALOGS" /> <End Role="JOB" EntitySet="JOBS" /> </AssociationSet> - <AssociationSet Name="FK_SITES_CATALOGS_COLOR_CATALOGS" Association="RemoteModel.FK_SITES_CATALOGS_COLOR_CATALOGS"> - <End Role="COLOR_CATALOGS" EntitySet="COLOR_CATALOGS" /> - <End Role="SITES_CATALOGS" EntitySet="SITES_CATALOGS" /> - </AssociationSet> <AssociationSet Name="FK_COLOR_CATALOGS_ITEMS_COLOR_CATALOGS_GROUPS" Association="RemoteModel.FK_COLOR_CATALOGS_ITEMS_COLOR_CATALOGS_GROUPS"> <End Role="COLOR_CATALOGS_GROUPS" EntitySet="COLOR_CATALOGS_GROUPS" /> <End Role="COLOR_CATALOGS_ITEMS" EntitySet="COLOR_CATALOGS_ITEMS" /> @@ -3097,6 +2721,10 @@ <End Role="COLOR_SPACES" EntitySet="COLOR_SPACES" /> <End Role="JOB" EntitySet="JOBS" /> </AssociationSet> + <AssociationSet Name="FK_MACHINES_COLOR_SPACES" Association="RemoteModel.FK_MACHINES_COLOR_SPACES"> + <End Role="COLOR_SPACES" EntitySet="COLOR_SPACES" /> + <End Role="MACHINE" EntitySet="MACHINES" /> + </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" /> @@ -3129,10 +2757,6 @@ <End Role="CUSTOMER" EntitySet="CUSTOMERS" /> <End Role="JOB" EntitySet="JOBS" /> </AssociationSet> - <AssociationSet Name="FK_DATA_STORES_MACHINES" Association="RemoteModel.FK_DATA_STORES_MACHINES"> - <End Role="MACHINE" EntitySet="MACHINES" /> - <End Role="DATA_STORE_ITEMS" EntitySet="DATA_STORE_ITEMS" /> - </AssociationSet> <AssociationSet Name="FK_DISPENSERS_DISPENSER_TYPES" Association="RemoteModel.FK_DISPENSERS_DISPENSER_TYPES"> <End Role="DISPENSER_TYPES" EntitySet="DISPENSER_TYPES" /> <End Role="DISPENSER" EntitySet="DISPENSERS" /> @@ -3153,10 +2777,6 @@ <End Role="FIBER_SYNTHS" EntitySet="FIBER_SYNTHS" /> <End Role="RML" EntitySet="RMLS" /> </AssociationSet> - <AssociationSet Name="FK_FSE_VERSIONS_USERS" Association="RemoteModel.FK_FSE_VERSIONS_USERS"> - <End Role="USER" EntitySet="USERS" /> - <End Role="FSE_VERSIONS" EntitySet="FSE_VERSIONS" /> - </AssociationSet> <AssociationSet Name="FK_HARDWARE_BLOWERS_HARDWARE_BLOWER_TYPES" Association="RemoteModel.FK_HARDWARE_BLOWERS_HARDWARE_BLOWER_TYPES"> <End Role="HARDWARE_BLOWER_TYPES" EntitySet="HARDWARE_BLOWER_TYPES" /> <End Role="HARDWARE_BLOWERS" EntitySet="HARDWARE_BLOWERS" /> @@ -3225,6 +2845,10 @@ <End Role="MID_TANK_TYPES" EntitySet="MID_TANK_TYPES" /> <End Role="IDS_PACKS" EntitySet="IDS_PACKS" /> </AssociationSet> + <AssociationSet Name="FK_JOB_RUNS_JOBS" Association="RemoteModel.FK_JOB_RUNS_JOBS"> + <End Role="JOB" EntitySet="JOBS" /> + <End Role="JOB_RUNS" EntitySet="JOB_RUNS" /> + </AssociationSet> <AssociationSet Name="FK_JOBS_MACHINES" Association="RemoteModel.FK_JOBS_MACHINES"> <End Role="MACHINE" EntitySet="MACHINES" /> <End Role="JOB" EntitySet="JOBS" /> @@ -3281,6 +2905,14 @@ <End Role="ORGANIZATION" EntitySet="ORGANIZATIONS" /> <End Role="MACHINE" EntitySet="MACHINES" /> </AssociationSet> + <AssociationSet Name="FK_MACHINES_RMLS2" Association="RemoteModel.FK_MACHINES_RMLS2"> + <End Role="RML" EntitySet="RMLS" /> + <End Role="MACHINE" EntitySet="MACHINES" /> + </AssociationSet> + <AssociationSet Name="FK_MACHINES_SPOOL_TYPES" Association="RemoteModel.FK_MACHINES_SPOOL_TYPES"> + <End Role="SPOOL_TYPES" EntitySet="SPOOL_TYPES" /> + <End Role="MACHINE" EntitySet="MACHINES" /> + </AssociationSet> <AssociationSet Name="FK_SPOOLS_MACHINES" Association="RemoteModel.FK_SPOOLS_MACHINES"> <End Role="MACHINE" EntitySet="MACHINES" /> <End Role="SPOOL" EntitySet="SPOOLS" /> @@ -3301,10 +2933,6 @@ <End Role="MEDIA_PURPOSES" EntitySet="MEDIA_PURPOSES" /> <End Role="RML" EntitySet="RMLS" /> </AssociationSet> - <AssociationSet Name="FK_SITES_ORGANIZATIONS" Association="RemoteModel.FK_SITES_ORGANIZATIONS"> - <End Role="ORGANIZATION" EntitySet="ORGANIZATIONS" /> - <End Role="SITE" EntitySet="SITES" /> - </AssociationSet> <AssociationSet Name="FK_USERS_ORGANIZATIONS" Association="RemoteModel.FK_USERS_ORGANIZATIONS"> <End Role="ORGANIZATION" EntitySet="ORGANIZATIONS" /> <End Role="USER" EntitySet="USERS" /> @@ -3321,22 +2949,6 @@ <End Role="RML" EntitySet="RMLS" /> <End Role="PROCESS_PARAMETERS_TABLES_GROUPS" EntitySet="PROCESS_PARAMETERS_TABLES_GROUPS" /> </AssociationSet> - <AssociationSet Name="FK_PUBLISHED_TEST_PROJECTS_VERSIONS_PUBLISHED_TEST_PROJECTS" Association="RemoteModel.FK_PUBLISHED_TEST_PROJECTS_VERSIONS_PUBLISHED_TEST_PROJECTS"> - <End Role="PUBLISHED_PROCEDURE_PROJECTS" EntitySet="PUBLISHED_PROCEDURE_PROJECTS" /> - <End Role="PUBLISHED_PROCEDURE_PROJECTS_VERSIONS" EntitySet="PUBLISHED_PROCEDURE_PROJECTS_VERSIONS" /> - </AssociationSet> - <AssociationSet Name="FK_RMLS_SPOOLS_RMLS" Association="RemoteModel.FK_RMLS_SPOOLS_RMLS"> - <End Role="RML" EntitySet="RMLS" /> - <End Role="RMLS_SPOOLS" EntitySet="RMLS_SPOOLS" /> - </AssociationSet> - <AssociationSet Name="FK_SITES_RMLS_RMLS" Association="RemoteModel.FK_SITES_RMLS_RMLS"> - <End Role="RML" EntitySet="RMLS" /> - <End Role="SITES_RMLS" EntitySet="SITES_RMLS" /> - </AssociationSet> - <AssociationSet Name="FK_RMLS_SPOOLS_SPOOL_TYPES" Association="RemoteModel.FK_RMLS_SPOOLS_SPOOL_TYPES"> - <End Role="SPOOL_TYPES" EntitySet="SPOOL_TYPES" /> - <End Role="RMLS_SPOOLS" EntitySet="RMLS_SPOOLS" /> - </AssociationSet> <AssociationSet Name="FK_ROLES_PERMISSIONS_ROLES" Association="RemoteModel.FK_ROLES_PERMISSIONS_ROLES"> <End Role="ROLE" EntitySet="ROLES" /> <End Role="ROLES_PERMISSIONS" EntitySet="ROLES_PERMISSIONS" /> @@ -3345,14 +2957,6 @@ <End Role="ROLE" EntitySet="ROLES" /> <End Role="USERS_ROLES" EntitySet="USERS_ROLES" /> </AssociationSet> - <AssociationSet Name="FK_SITES_CATALOGS_SITES" Association="RemoteModel.FK_SITES_CATALOGS_SITES"> - <End Role="SITE" EntitySet="SITES" /> - <End Role="SITES_CATALOGS" EntitySet="SITES_CATALOGS" /> - </AssociationSet> - <AssociationSet Name="FK_SITES_RMLS_SITES" Association="RemoteModel.FK_SITES_RMLS_SITES"> - <End Role="SITE" EntitySet="SITES" /> - <End Role="SITES_RMLS" EntitySet="SITES_RMLS" /> - </AssociationSet> <AssociationSet Name="FK_SPOOLS_SPOOL_TYPES" Association="RemoteModel.FK_SPOOLS_SPOOL_TYPES"> <End Role="SPOOL_TYPES" EntitySet="SPOOL_TYPES" /> <End Role="SPOOL" EntitySet="SPOOLS" /> @@ -3374,21 +2978,6 @@ <Property Name="TABLE_NAME" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="SYNC_TYPE" Type="Int32" Nullable="false" /> </EntityType> - <EntityType Name="ACTION_LOGS"> - <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="TYPE" Type="Int32" Nullable="false" /> - <Property Name="USER_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" /> - <Property Name="RELATED_OBJECT_NAME" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> - <Property Name="RELATED_OBJECT_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" /> - <Property Name="MESSAGE" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> - <Property Name="DIFFERENCE" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> - <NavigationProperty Name="USER" Relationship="RemoteModel.FK_ACTION_LOGS_USERS" FromRole="ACTION_LOGS" ToRole="USER" /> - </EntityType> <EntityType Name="ADDRESS"> <Key> <PropertyRef Name="GUID" /> @@ -3479,7 +3068,6 @@ <Property Name="CORRECTED" Type="Boolean" Nullable="false" /> <Property Name="COLOR_CATALOG_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="COLOR_CATALOGS_ITEM_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" /> - <Property Name="IS_TRANSPARENT" Type="Boolean" Nullable="false" /> <NavigationProperty Name="COLOR_CATALOGS" Relationship="RemoteModel.FK_BRUSH_STOPS_COLOR_CATALOGS" FromRole="BRUSH_STOPS" ToRole="COLOR_CATALOGS" /> <NavigationProperty Name="COLOR_CATALOGS_ITEMS" Relationship="RemoteModel.FK_BRUSH_STOPS_COLOR_CATALOGS_ITEMS" FromRole="BRUSH_STOPS" ToRole="COLOR_CATALOGS_ITEMS" /> <NavigationProperty Name="COLOR_SPACES" Relationship="RemoteModel.FK_BRUSH_STOPS_COLOR_SPACES" FromRole="BRUSH_STOPS" ToRole="COLOR_SPACES" /> @@ -3541,7 +3129,6 @@ <NavigationProperty Name="BRUSH_STOPS" Relationship="RemoteModel.FK_BRUSH_STOPS_COLOR_CATALOGS" FromRole="COLOR_CATALOGS" ToRole="BRUSH_STOPS" /> <NavigationProperty Name="COLOR_CATALOGS_GROUPS" Relationship="RemoteModel.FK_COLOR_CATALOGS_GROUPS_COLOR_CATALOGS" FromRole="COLOR_CATALOGS" ToRole="COLOR_CATALOGS_GROUPS" /> <NavigationProperty Name="JOBS" Relationship="RemoteModel.FK_JOBS_COLOR_CATALOGS" FromRole="COLOR_CATALOGS" ToRole="JOB" /> - <NavigationProperty Name="SITES_CATALOGS" Relationship="RemoteModel.FK_SITES_CATALOGS_COLOR_CATALOGS" FromRole="COLOR_CATALOGS" ToRole="SITES_CATALOGS" /> </EntityType> <EntityType Name="COLOR_CATALOGS_GROUPS"> <Key> @@ -3612,6 +3199,7 @@ <Property Name="THUMBNAIL" Type="Binary" MaxLength="Max" FixedLength="false" /> <NavigationProperty Name="BRUSH_STOPS" Relationship="RemoteModel.FK_BRUSH_STOPS_COLOR_SPACES" FromRole="COLOR_SPACES" ToRole="BRUSH_STOPS" /> <NavigationProperty Name="JOBS" Relationship="RemoteModel.FK_JOBS_COLOR_SPACES" FromRole="COLOR_SPACES" ToRole="JOB" /> + <NavigationProperty Name="MACHINES" Relationship="RemoteModel.FK_MACHINES_COLOR_SPACES" FromRole="COLOR_SPACES" ToRole="MACHINE" /> </EntityType> <EntityType Name="CONFIGURATION"> <Key> @@ -3662,22 +3250,6 @@ <NavigationProperty Name="ORGANIZATION" Relationship="RemoteModel.FK_CUSTOMERS_ORGANIZATIONS" FromRole="CUSTOMER" ToRole="ORGANIZATION" /> <NavigationProperty Name="JOBS" Relationship="RemoteModel.FK_JOBS_CUSTOMERS" FromRole="CUSTOMER" ToRole="JOB" /> </EntityType> - <EntityType Name="DATA_STORE_ITEMS"> - <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="MACHINE_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" /> - <Property Name="COLLECTION_NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> - <Property Name="KEY" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> - <Property Name="DATA_TYPE" Type="Int32" Nullable="false" /> - <Property Name="VALUE" Type="Binary" Nullable="false" MaxLength="Max" FixedLength="false" /> - <Property Name="IS_DELETED" Type="Boolean" Nullable="false" /> - <Property Name="IS_SYNCHRONIZED" Type="Boolean" Nullable="false" /> - <NavigationProperty Name="MACHINE" Relationship="RemoteModel.FK_DATA_STORES_MACHINES" FromRole="DATA_STORE_ITEMS" ToRole="MACHINE" /> - </EntityType> <EntityType Name="DISPENSER_TYPES"> <Key> <PropertyRef Name="GUID" /> @@ -3738,7 +3310,6 @@ <Property Name="EVENT_ACTIONS" Type="String" MaxLength="50" FixedLength="false" Unicode="false" /> <Property Name="REQUIRES_USER_INTERVENTION" Type="Boolean" Nullable="false" /> <Property Name="GUIDANCE" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> - <Property Name="PERSISTENT" Type="Boolean" Nullable="false" /> <NavigationProperty Name="MACHINES_EVENTS" Relationship="RemoteModel.FK_MACHINES_EVENTS_EVENTS" FromRole="EVENT_TYPES" ToRole="MACHINES_EVENTS" /> </EntityType> <EntityType Name="FIBER_SHAPES"> @@ -3763,32 +3334,6 @@ <Property Name="CODE" Type="Int32" Nullable="false" /> <NavigationProperty Name="RMLS" Relationship="RemoteModel.FK_RML_FIBER_SYNTHESIS" FromRole="FIBER_SYNTHS" ToRole="RML" /> </EntityType> - <EntityType Name="FSE_VERSIONS"> - <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="VERSION" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" /> - <Property Name="BLOB_NAME" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="false" /> - <Property Name="INSTALLER_BLOB_NAME" Type="String" MaxLength="200" FixedLength="false" Unicode="false" /> - <Property Name="COMMENTS" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" /> - <Property Name="USER_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> - <NavigationProperty Name="USER" Relationship="RemoteModel.FK_FSE_VERSIONS_USERS" FromRole="FSE_VERSIONS" ToRole="USER" /> - </EntityType> - <EntityType Name="GLOBAL_DATA_STORE_ITEMS"> - <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="COLLECTION_NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> - <Property Name="KEY" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> - <Property Name="DATA_TYPE" Type="Int32" Nullable="false" /> - <Property Name="VALUE" Type="Binary" Nullable="false" MaxLength="Max" FixedLength="false" /> - </EntityType> <EntityType Name="HARDWARE_BLOWER_TYPES"> <Key> <PropertyRef Name="GUID" /> @@ -3935,7 +3480,6 @@ <Property Name="T_ON_MIN" Type="Int32" Nullable="false" /> <Property Name="T_OFF_MIN" Type="Int32" Nullable="false" /> <Property Name="ACTIVE" Type="Boolean" Nullable="false" /> - <Property Name="P01_CONFIG_WORD" Type="Int32" Nullable="false" /> <NavigationProperty Name="HARDWARE_MOTOR_TYPES" Relationship="RemoteModel.FK_HARDWARE_MOTORS_HARDWARE_MOTOR_TYPES" FromRole="HARDWARE_MOTORS" ToRole="HARDWARE_MOTOR_TYPES" /> <NavigationProperty Name="HARDWARE_VERSIONS" Relationship="RemoteModel.FK_HARDWARE_MOTORS_HARDWARE_VERSIONS" FromRole="HARDWARE_MOTORS" ToRole="HARDWARE_VERSIONS" /> </EntityType> @@ -4096,35 +3640,13 @@ <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="MACHINE_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" /> - <Property Name="JOB_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" /> - <Property Name="RML_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" /> - <Property Name="USER_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" /> - <Property Name="JOB_NAME" Type="String" MaxLength="100" FixedLength="false" Unicode="true" /> - <Property Name="JOB_DESIGNATION" Type="Int32" Nullable="false" /> - <Property Name="JOB_SOURCE" Type="Int32" Nullable="false" /> - <Property Name="JOB_STRING" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> + <Property Name="JOB_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="START_DATE" Type="DateTime" Nullable="false" Precision="3" /> - <Property Name="UPLOADING_START_DATE" Type="DateTime" Precision="3" /> - <Property Name="HEATING_START_DATE" Type="DateTime" Precision="3" /> - <Property Name="ACTUAL_START_DATE" Type="DateTime" Precision="3" /> <Property Name="END_DATE" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="STATUS" Type="Int32" Nullable="false" /> - <Property Name="JOB_LENGTH" Type="Double" Nullable="false" /> - <Property Name="IS_GRADIENT" Type="Boolean" Nullable="false" /> - <Property Name="GRADIENT_RESOLUTION_CM" Type="Int32" Nullable="false" /> - <Property Name="LIQUID_QUANTITY_STRING" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> - <Property Name="CYAN_QUANTITY" Type="Int32" Nullable="false" /> - <Property Name="MAGENTA_QUANTITY" Type="Int32" Nullable="false" /> - <Property Name="YELLOW_QUANTITY" Type="Int32" Nullable="false" /> - <Property Name="BLACK_QUANTITY" Type="Int32" Nullable="false" /> - <Property Name="TRANSPARENT_QUANTITY" Type="Int32" Nullable="false" /> - <Property Name="LUBRICANT_QUANTITY" Type="Int32" Nullable="false" /> - <Property Name="CLEANER_QUANTITY" Type="Int32" Nullable="false" /> <Property Name="END_POSITION" Type="Double" Nullable="false" /> <Property Name="FAILED_MESSAGE" Type="String" MaxLength="300" FixedLength="false" Unicode="true" /> - <Property Name="IS_HEAD_CLEANING" Type="Boolean" Nullable="false" /> - <Property Name="IS_SYNCHRONIZED" Type="Boolean" Nullable="false" /> + <NavigationProperty Name="JOB" Relationship="RemoteModel.FK_JOB_RUNS_JOBS" FromRole="JOB_RUNS" ToRole="JOB" /> </EntityType> <EntityType Name="JOB"> <Key> @@ -4136,7 +3658,7 @@ <Property Name="CREATION_DATE" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="LAST_RUN" Type="DateTime" Precision="3" /> <Property Name="MACHINE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> - <Property Name="USER_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="USER_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="RML_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="WINDING_METHOD_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="SPOOL_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> @@ -4166,11 +3688,10 @@ <Property Name="SAMPLE_DYE_APPROVE_DATE" Type="DateTime" Precision="3" /> <Property Name="EDITING_STATE" Type="Int32" Nullable="false" /> <Property Name="LENGTH_PERCENTAGE_FACTOR" Type="Double" Nullable="false" /> - <Property Name="IS_SYNCHRONIZED" Type="Boolean" Nullable="false" /> - <Property Name="SOURCE" Type="Int32" Nullable="false" /> <NavigationProperty Name="COLOR_CATALOGS" Relationship="RemoteModel.FK_JOBS_COLOR_CATALOGS" FromRole="JOB" ToRole="COLOR_CATALOGS" /> <NavigationProperty Name="COLOR_SPACES" Relationship="RemoteModel.FK_JOBS_COLOR_SPACES" FromRole="JOB" ToRole="COLOR_SPACES" /> <NavigationProperty Name="CUSTOMER" Relationship="RemoteModel.FK_JOBS_CUSTOMERS" FromRole="JOB" ToRole="CUSTOMER" /> + <NavigationProperty Name="JOB_RUNS" Relationship="RemoteModel.FK_JOB_RUNS_JOBS" FromRole="JOB" ToRole="JOB_RUNS" /> <NavigationProperty Name="MACHINE" Relationship="RemoteModel.FK_JOBS_MACHINES" FromRole="JOB" ToRole="MACHINE" /> <NavigationProperty Name="RML" Relationship="RemoteModel.FK_JOBS_RMLS" FromRole="JOB" ToRole="RML" /> <NavigationProperty Name="SPOOL_TYPES" Relationship="RemoteModel.FK_JOBS_SPOOL_TYPES" FromRole="JOB" ToRole="SPOOL_TYPES" /> @@ -4202,7 +3723,6 @@ <Property Name="COLOR" Type="Int32" Nullable="false" /> <Property Name="PREFERRED_INDEX" Type="Int32" Nullable="false" /> <Property Name="HAS_PIGMENT" Type="Boolean" Nullable="false" /> - <Property Name="SHORT_NAME" Type="String" MaxLength="4" FixedLength="false" Unicode="true" /> <NavigationProperty Name="CATS" Relationship="RemoteModel.FK_CATS_LIQUID_TYPES1" 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_LIQUID_TYPES_RMLS_LIQUID_TYPES" FromRole="LIQUID_TYPES" ToRole="LIQUID_TYPES_RMLS" /> @@ -4259,7 +3779,6 @@ <Property Name="NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="PRODUCTION_DATE" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="ORGANIZATION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> - <Property Name="SITE_GUID" Type="String" 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" /> <Property Name="DEFAULT_RML_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" /> @@ -4285,15 +3804,15 @@ <Property Name="IS_DEVICE_REGISTERED" Type="Boolean" Nullable="false" /> <Property Name="DEVICE_ID" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> <Property Name="DEVICE_NAME" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> - <Property Name="HEAD_TYPE" Type="Int32" Nullable="false" /> - <Property Name="ACTIVATION_KEY" Type="String" MaxLength="8" FixedLength="false" Unicode="false" /> <NavigationProperty Name="CATS" Relationship="RemoteModel.FK_CATS_MACHINES" FromRole="MACHINE" ToRole="CAT" /> + <NavigationProperty Name="COLOR_SPACES" Relationship="RemoteModel.FK_MACHINES_COLOR_SPACES" FromRole="MACHINE" ToRole="COLOR_SPACES" /> <NavigationProperty Name="CONFIGURATION" Relationship="RemoteModel.FK_MACHINES_CONFIGURATIONS" FromRole="MACHINE" ToRole="CONFIGURATION" /> - <NavigationProperty Name="DATA_STORE_ITEMS" Relationship="RemoteModel.FK_DATA_STORES_MACHINES" FromRole="MACHINE" ToRole="DATA_STORE_ITEMS" /> <NavigationProperty Name="JOBS" Relationship="RemoteModel.FK_JOBS_MACHINES" FromRole="MACHINE" ToRole="JOB" /> <NavigationProperty Name="MACHINE_VERSIONS" Relationship="RemoteModel.FK_MACHINES_MACHINE_VERSIONS" FromRole="MACHINE" ToRole="MACHINE_VERSIONS" /> <NavigationProperty Name="MACHINES_EVENTS" Relationship="RemoteModel.FK_MACHINES_EVENTS_MACHINES" FromRole="MACHINE" ToRole="MACHINES_EVENTS" /> <NavigationProperty Name="ORGANIZATION" Relationship="RemoteModel.FK_MACHINES_ORGANIZATIONS" FromRole="MACHINE" ToRole="ORGANIZATION" /> + <NavigationProperty Name="RML" Relationship="RemoteModel.FK_MACHINES_RMLS2" FromRole="MACHINE" ToRole="RML" /> + <NavigationProperty Name="SPOOL_TYPES" Relationship="RemoteModel.FK_MACHINES_SPOOL_TYPES" FromRole="MACHINE" ToRole="SPOOL_TYPES" /> <NavigationProperty Name="SPOOLS" Relationship="RemoteModel.FK_SPOOLS_MACHINES" FromRole="MACHINE" ToRole="SPOOL" /> </EntityType> <EntityType Name="MACHINES_EVENTS"> @@ -4309,7 +3828,6 @@ <Property Name="USER_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="DATE_TIME" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="DESCRIPTION" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> - <Property Name="IS_SYNCHRONIZED" Type="Boolean" Nullable="false" /> <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" /> @@ -4373,7 +3891,6 @@ <NavigationProperty Name="CONTACT" Relationship="RemoteModel.FK_ORGANIZATIONS_CONTACTS" FromRole="ORGANIZATION" ToRole="CONTACT" /> <NavigationProperty Name="CUSTOMERS" Relationship="RemoteModel.FK_CUSTOMERS_ORGANIZATIONS" FromRole="ORGANIZATION" ToRole="CUSTOMER" /> <NavigationProperty Name="MACHINES" Relationship="RemoteModel.FK_MACHINES_ORGANIZATIONS" FromRole="ORGANIZATION" ToRole="MACHINE" /> - <NavigationProperty Name="SITES" Relationship="RemoteModel.FK_SITES_ORGANIZATIONS" FromRole="ORGANIZATION" ToRole="SITE" /> <NavigationProperty Name="USERS" Relationship="RemoteModel.FK_USERS_ORGANIZATIONS" FromRole="ORGANIZATION" ToRole="USER" /> </EntityType> <EntityType Name="PERMISSION"> @@ -4384,7 +3901,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="CODE" Type="Int32" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="60" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="40" FixedLength="false" Unicode="true" /> <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> <NavigationProperty Name="ROLES_PERMISSIONS" Relationship="RemoteModel.FK_ROLES_PERMISSIONS_PERMISSIONS" FromRole="PERMISSION" ToRole="ROLES_PERMISSIONS" /> </EntityType> @@ -4417,17 +3934,6 @@ <Property Name="HEAD_AIR_FLOW" Type="Double" Nullable="false" /> <Property Name="PROCESS_PARAMETERS_TABLES_GROUP_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="TABLE_INDEX" Type="Int32" Nullable="false" /> - <Property Name="HEAD_ZONE7_TEMP" Type="Double" Nullable="false" /> - <Property Name="HEAD_ZONE8_TEMP" Type="Double" Nullable="false" /> - <Property Name="HEAD_ZONE9_TEMP" Type="Double" Nullable="false" /> - <Property Name="HEAD_ZONE10_TEMP" Type="Double" Nullable="false" /> - <Property Name="HEAD_ZONE11_TEMP" Type="Double" Nullable="false" /> - <Property Name="HEAD_ZONE12_TEMP" Type="Double" Nullable="false" /> - <Property Name="R_BLOWER_FLOW" Type="Double" Nullable="false" /> - <Property Name="R_BLOWER_TEMP" Type="Double" Nullable="false" /> - <Property Name="L_BLOWER_FLOW" Type="Double" Nullable="false" /> - <Property Name="L_BLOWER_TEMP" Type="Double" Nullable="false" /> - <Property Name="PRESSURE_BUILD_UP" Type="Double" Nullable="false" /> <NavigationProperty Name="PROCESS_PARAMETERS_TABLES_GROUPS" Relationship="RemoteModel.FK_PROCESS_PARAMETERS_TABLES_PROCESS_PARAMETERS_TABLES_GROUPS" FromRole="PROCESS_PARAMETERS_TABLES" ToRole="PROCESS_PARAMETERS_TABLES_GROUPS" /> </EntityType> <EntityType Name="PROCESS_PARAMETERS_TABLES_GROUPS"> @@ -4444,34 +3950,6 @@ <NavigationProperty Name="PROCESS_PARAMETERS_TABLES" Relationship="RemoteModel.FK_PROCESS_PARAMETERS_TABLES_PROCESS_PARAMETERS_TABLES_GROUPS" FromRole="PROCESS_PARAMETERS_TABLES_GROUPS" ToRole="PROCESS_PARAMETERS_TABLES" /> <NavigationProperty Name="RML" Relationship="RemoteModel.FK_PROCESS_PARAMETERS_TABLES_GROUPS_RMLS" FromRole="PROCESS_PARAMETERS_TABLES_GROUPS" ToRole="RML" /> </EntityType> - <EntityType Name="PUBLISHED_PROCEDURE_PROJECTS"> - <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="NAME" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> - <Property Name="DESCRIPTION" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> - <Property Name="PUBLISH_DATE" Type="DateTime" Nullable="false" Precision="3" /> - <Property Name="SORTING_INDEX" Type="Int32" Nullable="false" /> - <Property Name="IS_VISIBLE" Type="Boolean" Nullable="false" /> - <Property Name="VISIBILITY" Type="Int32" Nullable="false" /> - <NavigationProperty Name="PUBLISHED_PROCEDURE_PROJECTS_VERSIONS" Relationship="RemoteModel.FK_PUBLISHED_TEST_PROJECTS_VERSIONS_PUBLISHED_TEST_PROJECTS" FromRole="PUBLISHED_PROCEDURE_PROJECTS" ToRole="PUBLISHED_PROCEDURE_PROJECTS_VERSIONS" /> - </EntityType> - <EntityType Name="PUBLISHED_PROCEDURE_PROJECTS_VERSIONS"> - <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="PUBLISHED_PROCEDURE_PROJECT_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> - <Property Name="VERSION" Type="Int32" Nullable="false" /> - <Property Name="AUTHOR" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="true" /> - <Property Name="PROJECT_JSON_STRING" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" /> - <NavigationProperty Name="PUBLISHED_PROCEDURE_PROJECTS" Relationship="RemoteModel.FK_PUBLISHED_TEST_PROJECTS_VERSIONS_PUBLISHED_TEST_PROJECTS" FromRole="PUBLISHED_PROCEDURE_PROJECTS_VERSIONS" ToRole="PUBLISHED_PROCEDURE_PROJECTS" /> - </EntityType> <EntityType Name="RML"> <Key> <PropertyRef Name="GUID" /> @@ -4480,7 +3958,6 @@ <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="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> - <Property Name="DISPLAY_NAME" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> <Property Name="MANUFACTURER" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="CODE" Type="Int32" Nullable="false" /> <Property Name="WHITE_POINT_L" Type="Double" Nullable="false" /> @@ -4506,23 +3983,6 @@ <Property Name="THUMBNAIL" Type="Binary" MaxLength="Max" FixedLength="false" /> <Property Name="CCT_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="COLOR_CONVERSION_VERSION" Type="Int32" Nullable="false" /> - <Property Name="USE_COLOR_LIB_GRADIENTS" Type="Boolean" Nullable="false" /> - <Property Name="HEAD_TYPE" Type="Int32" Nullable="false" /> - <Property Name="QUALIFICATION_LEVEL" Type="Int32" Nullable="false" /> - <Property Name="QUALIFICATION_DATE" Type="DateTime" Precision="3" /> - <Property Name="SPOOLS_CALIBRATIONS_STRING" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> - <Property Name="FEEDER_P" Type="Int32" Nullable="false" /> - <Property Name="FEEDER_I" Type="Int32" Nullable="false" /> - <Property Name="FEEDER_D" Type="Int32" Nullable="false" /> - <Property Name="PULLER_P" Type="Int32" Nullable="false" /> - <Property Name="PULLER_I" Type="Int32" Nullable="false" /> - <Property Name="PULLER_D" Type="Int32" Nullable="false" /> - <Property Name="WINDER_P" Type="Int32" Nullable="false" /> - <Property Name="WINDER_I" Type="Int32" Nullable="false" /> - <Property Name="WINDER_D" Type="Int32" Nullable="false" /> - <Property Name="BYPASS_ROCKERS" Type="Boolean" Nullable="false" /> - <Property Name="CLEANER_FLOW" Type="Int32" Nullable="false" /> - <Property Name="ARC_HEAD_CLEANING_MOTOR_SPEED" Type="Double" Nullable="false" /> <NavigationProperty Name="CATS" Relationship="RemoteModel.FK_CATS_RMLS" FromRole="RML" ToRole="CAT" /> <NavigationProperty Name="CCT" Relationship="RemoteModel.FK_RMLS_CCTS" FromRole="RML" ToRole="CCT" /> <NavigationProperty Name="COLOR_CATALOGS_ITEMS_RECIPES" Relationship="RemoteModel.FK_COLOR_CATALOGS_ITEMS_RECIPES_RMLS" FromRole="RML" ToRole="COLOR_CATALOGS_ITEMS_RECIPES" /> @@ -4531,28 +3991,11 @@ <NavigationProperty Name="JOBS" Relationship="RemoteModel.FK_JOBS_RMLS" FromRole="RML" ToRole="JOB" /> <NavigationProperty Name="LINEAR_MASS_DENSITY_UNITS" Relationship="RemoteModel.FK_RML_LINEAR_MASS_DENSITY_UNITS" FromRole="RML" ToRole="LINEAR_MASS_DENSITY_UNITS" /> <NavigationProperty Name="LIQUID_TYPES_RMLS" Relationship="RemoteModel.FK_LIQUID_TYPES_RMLS_RMLS" FromRole="RML" ToRole="LIQUID_TYPES_RMLS" /> + <NavigationProperty Name="MACHINES" Relationship="RemoteModel.FK_MACHINES_RMLS2" FromRole="RML" ToRole="MACHINE" /> <NavigationProperty Name="MEDIA_CONDITIONS" Relationship="RemoteModel.FK_RML_MEDIA_CONDITIONS" FromRole="RML" ToRole="MEDIA_CONDITIONS" /> <NavigationProperty Name="MEDIA_MATERIALS" Relationship="RemoteModel.FK_RML_MEDIA_MATERIALS" FromRole="RML" ToRole="MEDIA_MATERIALS" /> <NavigationProperty Name="MEDIA_PURPOSES" Relationship="RemoteModel.FK_RML_MEDIA_PURPOSES" FromRole="RML" ToRole="MEDIA_PURPOSES" /> <NavigationProperty Name="PROCESS_PARAMETERS_TABLES_GROUPS" Relationship="RemoteModel.FK_PROCESS_PARAMETERS_TABLES_GROUPS_RMLS" FromRole="RML" ToRole="PROCESS_PARAMETERS_TABLES_GROUPS" /> - <NavigationProperty Name="RMLS_SPOOLS" Relationship="RemoteModel.FK_RMLS_SPOOLS_RMLS" FromRole="RML" ToRole="RMLS_SPOOLS" /> - <NavigationProperty Name="SITES_RMLS" Relationship="RemoteModel.FK_SITES_RMLS_RMLS" FromRole="RML" ToRole="SITES_RMLS" /> - </EntityType> - <EntityType Name="RMLS_SPOOLS"> - <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="SPOOL_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> - <Property Name="RML_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> - <Property Name="ROTATIONS_PER_PASSAGE" Type="Double" /> - <Property Name="LENGTH" Type="Double" /> - <Property Name="BACKING_RATE" Type="Int32" /> - <Property Name="BOTTOM_BACKING_RATE" Type="Int32" /> - <NavigationProperty Name="RML" Relationship="RemoteModel.FK_RMLS_SPOOLS_RMLS" FromRole="RMLS_SPOOLS" ToRole="RML" /> - <NavigationProperty Name="SPOOL_TYPES" Relationship="RemoteModel.FK_RMLS_SPOOLS_SPOOL_TYPES" FromRole="RMLS_SPOOLS" ToRole="SPOOL_TYPES" /> </EntityType> <EntityType Name="ROLE"> <Key> @@ -4593,44 +4036,6 @@ <NavigationProperty Name="BRUSH_STOPS" Relationship="RemoteModel.FK_BRUSH_STOPS_SEGMENTS" FromRole="SEGMENT" ToRole="BRUSH_STOPS" /> <NavigationProperty Name="JOB" Relationship="RemoteModel.FK_SEGMENTS_JOBS" FromRole="SEGMENT" ToRole="JOB" /> </EntityType> - <EntityType Name="SITE"> - <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="ORGANIZATION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> - <Property Name="DESCRIPTION" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> - <NavigationProperty Name="ORGANIZATION" Relationship="RemoteModel.FK_SITES_ORGANIZATIONS" FromRole="SITE" ToRole="ORGANIZATION" /> - <NavigationProperty Name="SITES_CATALOGS" Relationship="RemoteModel.FK_SITES_CATALOGS_SITES" FromRole="SITE" ToRole="SITES_CATALOGS" /> - <NavigationProperty Name="SITES_RMLS" Relationship="RemoteModel.FK_SITES_RMLS_SITES" FromRole="SITE" ToRole="SITES_RMLS" /> - </EntityType> - <EntityType Name="SITES_CATALOGS"> - <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="SITE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> - <Property Name="COLOR_CATALOG_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> - <NavigationProperty Name="COLOR_CATALOGS" Relationship="RemoteModel.FK_SITES_CATALOGS_COLOR_CATALOGS" FromRole="SITES_CATALOGS" ToRole="COLOR_CATALOGS" /> - <NavigationProperty Name="SITE" Relationship="RemoteModel.FK_SITES_CATALOGS_SITES" FromRole="SITES_CATALOGS" ToRole="SITE" /> - </EntityType> - <EntityType Name="SITES_RMLS"> - <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="SITE_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="RML" Relationship="RemoteModel.FK_SITES_RMLS_RMLS" FromRole="SITES_RMLS" ToRole="RML" /> - <NavigationProperty Name="SITE" Relationship="RemoteModel.FK_SITES_RMLS_SITES" FromRole="SITES_RMLS" ToRole="SITE" /> - </EntityType> <EntityType Name="SPOOL_TYPES"> <Key> <PropertyRef Name="GUID" /> @@ -4644,13 +4049,8 @@ <Property Name="WEIGHT" Type="Double" Nullable="false" /> <Property Name="DIAMETER" Type="Double" Nullable="false" /> <Property Name="ROTATIONS_PER_PASSAGE" Type="Double" Nullable="false" /> - <Property Name="START_OFFSET_PULSES" Type="Int32" Nullable="false" /> - <Property Name="BACKING_RATE" Type="Int32" Nullable="false" /> - <Property Name="SEGMENT_OFFSET_PULSES" Type="Int32" Nullable="false" /> - <Property Name="BOTTOM_BACKING_RATE" Type="Int32" Nullable="false" /> - <Property Name="LIMIT_SWITCH_START_POINT_OFFSET" Type="Int32" Nullable="false" /> <NavigationProperty Name="JOBS" Relationship="RemoteModel.FK_JOBS_SPOOL_TYPES" FromRole="SPOOL_TYPES" ToRole="JOB" /> - <NavigationProperty Name="RMLS_SPOOLS" Relationship="RemoteModel.FK_RMLS_SPOOLS_SPOOL_TYPES" FromRole="SPOOL_TYPES" ToRole="RMLS_SPOOLS" /> + <NavigationProperty Name="MACHINES" Relationship="RemoteModel.FK_MACHINES_SPOOL_TYPES" FromRole="SPOOL_TYPES" ToRole="MACHINE" /> <NavigationProperty Name="SPOOLS" Relationship="RemoteModel.FK_SPOOLS_SPOOL_TYPES" FromRole="SPOOL_TYPES" ToRole="SPOOL" /> </EntityType> <EntityType Name="SPOOL"> @@ -4662,11 +4062,10 @@ <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> <Property Name="SPOOL_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="START_OFFSET_PULSES" Type="Int32" /> - <Property Name="BACKING_RATE" Type="Int32" /> - <Property Name="SEGMENT_OFFSET_PULSES" Type="Int32" /> - <Property Name="BOTTOM_BACKING_RATE" Type="Int32" /> - <Property Name="LIMIT_SWITCH_START_POINT_OFFSET" Type="Int32" /> + <Property Name="START_OFFSET_PULSES" Type="Int32" Nullable="false" /> + <Property Name="BACKING_RATE" Type="Int32" Nullable="false" /> + <Property Name="SEGMENT_OFFSET_PULSES" Type="Int32" Nullable="false" /> + <Property Name="BOTTOM_BACKING_RATE" Type="Int32" Nullable="false" /> <NavigationProperty Name="MACHINE" Relationship="RemoteModel.FK_SPOOLS_MACHINES" FromRole="SPOOL" ToRole="MACHINE" /> <NavigationProperty Name="SPOOL_TYPES" Relationship="RemoteModel.FK_SPOOLS_SPOOL_TYPES" FromRole="SPOOL" ToRole="SPOOL_TYPES" /> </EntityType> @@ -4680,23 +4079,6 @@ <Property Name="version" Type="Int32" /> <Property Name="definition" Type="Binary" MaxLength="Max" FixedLength="false" /> </EntityType> - <EntityType Name="TANGO_UPDATES"> - <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="APPLICATION_VERSION" Type="String" MaxLength="50" FixedLength="false" Unicode="false" /> - <Property Name="FIRMWARE_VERSION" Type="String" MaxLength="50" FixedLength="false" Unicode="false" /> - <Property Name="MACHINE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> - <Property Name="STATUS" Type="Int32" Nullable="false" /> - <Property Name="FAILED_REASON" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> - <Property Name="FAILED_LOG" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> - <Property Name="START_DATE" Type="DateTime" Nullable="false" Precision="3" /> - <Property Name="END_DATE" Type="DateTime" Precision="3" /> - <Property Name="IS_SYNCHRONIZED" Type="Boolean" Nullable="false" /> - </EntityType> <EntityType Name="TANGO_VERSIONS"> <Key> <PropertyRef Name="GUID" /> @@ -4705,13 +4087,12 @@ <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="VERSION" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" /> - <Property Name="FIRMWARE_VERSION" Type="String" MaxLength="50" FixedLength="false" Unicode="false" /> + <Property Name="FIRMWARE_VERSION" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" /> <Property Name="BLOB_NAME" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="false" /> <Property Name="INSTALLER_BLOB_NAME" Type="String" MaxLength="200" FixedLength="false" Unicode="false" /> <Property Name="COMMENTS" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" /> <Property Name="USER_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="DISABLED" Type="Boolean" Nullable="false" /> <NavigationProperty Name="MACHINE_VERSIONS" Relationship="RemoteModel.FK_TANGO_VERSIONS_MACHINE_VERSIONS" FromRole="TANGO_VERSIONS" ToRole="MACHINE_VERSIONS" /> <NavigationProperty Name="USER" Relationship="RemoteModel.FK_TANGO_VERSIONS_USERS" FromRole="TANGO_VERSIONS" ToRole="USER" /> </EntityType> @@ -4815,11 +4196,8 @@ <Property Name="CONTACT_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="ADDRESS_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_LOGIN" Type="DateTime" Precision="3" /> - <Property Name="PASSWORD_CHANGE_REQUIRED" Type="Boolean" Nullable="false" /> - <NavigationProperty Name="ACTION_LOGS" Relationship="RemoteModel.FK_ACTION_LOGS_USERS" FromRole="USER" ToRole="ACTION_LOGS" /> <NavigationProperty Name="ADDRESS" Relationship="RemoteModel.FK_USERS_ADDRESSES" FromRole="USER" ToRole="ADDRESS" /> <NavigationProperty Name="CONTACT" Relationship="RemoteModel.FK_USERS_CONTACTS" FromRole="USER" ToRole="CONTACT" /> - <NavigationProperty Name="FSE_VERSIONS" Relationship="RemoteModel.FK_FSE_VERSIONS_USERS" FromRole="USER" ToRole="FSE_VERSIONS" /> <NavigationProperty Name="JOBS" Relationship="RemoteModel.FK_JOBS_USERS" FromRole="USER" ToRole="JOB" /> <NavigationProperty Name="MACHINE_STUDIO_VERSIONS" Relationship="RemoteModel.FK_MACHINE_STUDIO_VERSIONS_USERS" FromRole="USER" ToRole="MACHINE_STUDIO_VERSIONS" /> <NavigationProperty Name="MACHINES_EVENTS" Relationship="RemoteModel.FK_MACHINES_EVENTS_USERS" FromRole="USER" ToRole="MACHINES_EVENTS" /> @@ -4851,18 +4229,6 @@ <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" /> <NavigationProperty Name="JOBS" Relationship="RemoteModel.FK_JOBS_WINDING_METHODS" FromRole="WINDING_METHODS" ToRole="JOB" /> </EntityType> - <Association Name="FK_ACTION_LOGS_USERS"> - <End Type="RemoteModel.USER" Role="USER" Multiplicity="0..1" /> - <End Type="RemoteModel.ACTION_LOGS" Role="ACTION_LOGS" Multiplicity="*" /> - <ReferentialConstraint> - <Principal Role="USER"> - <PropertyRef Name="GUID" /> - </Principal> - <Dependent Role="ACTION_LOGS"> - <PropertyRef Name="USER_GUID" /> - </Dependent> - </ReferentialConstraint> - </Association> <Association Name="FK_ORGANIZATIONS_ADDRESSES"> <End Type="RemoteModel.ADDRESS" Role="ADDRESS" Multiplicity="1"> <OnDelete Action="Cascade" /> @@ -5067,20 +4433,6 @@ </Dependent> </ReferentialConstraint> </Association> - <Association Name="FK_SITES_CATALOGS_COLOR_CATALOGS"> - <End Type="RemoteModel.COLOR_CATALOGS" Role="COLOR_CATALOGS" Multiplicity="1"> - <OnDelete Action="Cascade" /> - </End> - <End Type="RemoteModel.SITES_CATALOGS" Role="SITES_CATALOGS" Multiplicity="*" /> - <ReferentialConstraint> - <Principal Role="COLOR_CATALOGS"> - <PropertyRef Name="GUID" /> - </Principal> - <Dependent Role="SITES_CATALOGS"> - <PropertyRef Name="COLOR_CATALOG_GUID" /> - </Dependent> - </ReferentialConstraint> - </Association> <Association Name="FK_COLOR_CATALOGS_ITEMS_COLOR_CATALOGS_GROUPS"> <End Type="RemoteModel.COLOR_CATALOGS_GROUPS" Role="COLOR_CATALOGS_GROUPS" Multiplicity="1"> <OnDelete Action="Cascade" /> @@ -5135,6 +4487,18 @@ </Dependent> </ReferentialConstraint> </Association> + <Association Name="FK_MACHINES_COLOR_SPACES"> + <End Type="RemoteModel.COLOR_SPACES" Role="COLOR_SPACES" Multiplicity="0..1" /> + <End Type="RemoteModel.MACHINE" Role="MACHINE" Multiplicity="*" /> + <ReferentialConstraint> + <Principal Role="COLOR_SPACES"> + <PropertyRef Name="GUID" /> + </Principal> + <Dependent Role="MACHINE"> + <PropertyRef Name="DEFAULT_COLOR_SPACE_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="*" /> @@ -5239,20 +4603,6 @@ </Dependent> </ReferentialConstraint> </Association> - <Association Name="FK_DATA_STORES_MACHINES"> - <End Type="RemoteModel.MACHINE" Role="MACHINE" Multiplicity="0..1"> - <OnDelete Action="Cascade" /> - </End> - <End Type="RemoteModel.DATA_STORE_ITEMS" Role="DATA_STORE_ITEMS" Multiplicity="*" /> - <ReferentialConstraint> - <Principal Role="MACHINE"> - <PropertyRef Name="GUID" /> - </Principal> - <Dependent Role="DATA_STORE_ITEMS"> - <PropertyRef Name="MACHINE_GUID" /> - </Dependent> - </ReferentialConstraint> - </Association> <Association Name="FK_DISPENSERS_DISPENSER_TYPES"> <End Type="RemoteModel.DISPENSER_TYPES" Role="DISPENSER_TYPES" Multiplicity="1" /> <End Type="RemoteModel.DISPENSER" Role="DISPENSER" Multiplicity="*" /> @@ -5315,18 +4665,6 @@ </Dependent> </ReferentialConstraint> </Association> - <Association Name="FK_FSE_VERSIONS_USERS"> - <End Type="RemoteModel.USER" Role="USER" Multiplicity="1" /> - <End Type="RemoteModel.FSE_VERSIONS" Role="FSE_VERSIONS" Multiplicity="*" /> - <ReferentialConstraint> - <Principal Role="USER"> - <PropertyRef Name="GUID" /> - </Principal> - <Dependent Role="FSE_VERSIONS"> - <PropertyRef Name="USER_GUID" /> - </Dependent> - </ReferentialConstraint> - </Association> <Association Name="FK_HARDWARE_BLOWERS_HARDWARE_BLOWER_TYPES"> <End Type="RemoteModel.HARDWARE_BLOWER_TYPES" Role="HARDWARE_BLOWER_TYPES" Multiplicity="1"> <OnDelete Action="Cascade" /> @@ -5553,6 +4891,20 @@ </Dependent> </ReferentialConstraint> </Association> + <Association Name="FK_JOB_RUNS_JOBS"> + <End Type="RemoteModel.JOB" Role="JOB" Multiplicity="1"> + <OnDelete Action="Cascade" /> + </End> + <End Type="RemoteModel.JOB_RUNS" Role="JOB_RUNS" Multiplicity="*" /> + <ReferentialConstraint> + <Principal Role="JOB"> + <PropertyRef Name="GUID" /> + </Principal> + <Dependent Role="JOB_RUNS"> + <PropertyRef Name="JOB_GUID" /> + </Dependent> + </ReferentialConstraint> + </Association> <Association Name="FK_JOBS_MACHINES"> <End Type="RemoteModel.MACHINE" Role="MACHINE" Multiplicity="1"> <OnDelete Action="Cascade" /> @@ -5568,9 +4920,7 @@ </ReferentialConstraint> </Association> <Association Name="FK_JOBS_RMLS"> - <End Type="RemoteModel.RML" Role="RML" Multiplicity="1"> - <OnDelete Action="Cascade" /> - </End> + <End Type="RemoteModel.RML" Role="RML" Multiplicity="1" /> <End Type="RemoteModel.JOB" Role="JOB" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="RML"> @@ -5594,7 +4944,7 @@ </ReferentialConstraint> </Association> <Association Name="FK_JOBS_USERS"> - <End Type="RemoteModel.USER" Role="USER" Multiplicity="0..1" /> + <End Type="RemoteModel.USER" Role="USER" Multiplicity="1" /> <End Type="RemoteModel.JOB" Role="JOB" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="USER"> @@ -5708,9 +5058,7 @@ </ReferentialConstraint> </Association> <Association Name="FK_MACHINES_EVENTS_MACHINES"> - <End Type="RemoteModel.MACHINE" Role="MACHINE" Multiplicity="0..1"> - <OnDelete Action="Cascade" /> - </End> + <End Type="RemoteModel.MACHINE" Role="MACHINE" Multiplicity="0..1" /> <End Type="RemoteModel.MACHINES_EVENTS" Role="MACHINES_EVENTS" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="MACHINE"> @@ -5735,6 +5083,30 @@ </Dependent> </ReferentialConstraint> </Association> + <Association Name="FK_MACHINES_RMLS2"> + <End Type="RemoteModel.RML" Role="RML" Multiplicity="0..1" /> + <End Type="RemoteModel.MACHINE" Role="MACHINE" Multiplicity="*" /> + <ReferentialConstraint> + <Principal Role="RML"> + <PropertyRef Name="GUID" /> + </Principal> + <Dependent Role="MACHINE"> + <PropertyRef Name="DEFAULT_RML_GUID" /> + </Dependent> + </ReferentialConstraint> + </Association> + <Association Name="FK_MACHINES_SPOOL_TYPES"> + <End Type="RemoteModel.SPOOL_TYPES" Role="SPOOL_TYPES" Multiplicity="0..1" /> + <End Type="RemoteModel.MACHINE" Role="MACHINE" Multiplicity="*" /> + <ReferentialConstraint> + <Principal Role="SPOOL_TYPES"> + <PropertyRef Name="GUID" /> + </Principal> + <Dependent Role="MACHINE"> + <PropertyRef Name="DEFAULT_SPOOL_TYPE_GUID" /> + </Dependent> + </ReferentialConstraint> + </Association> <Association Name="FK_SPOOLS_MACHINES"> <End Type="RemoteModel.MACHINE" Role="MACHINE" Multiplicity="1"> <OnDelete Action="Cascade" /> @@ -5797,18 +5169,6 @@ </Dependent> </ReferentialConstraint> </Association> - <Association Name="FK_SITES_ORGANIZATIONS"> - <End Type="RemoteModel.ORGANIZATION" Role="ORGANIZATION" Multiplicity="1" /> - <End Type="RemoteModel.SITE" Role="SITE" Multiplicity="*" /> - <ReferentialConstraint> - <Principal Role="ORGANIZATION"> - <PropertyRef Name="GUID" /> - </Principal> - <Dependent Role="SITE"> - <PropertyRef Name="ORGANIZATION_GUID" /> - </Dependent> - </ReferentialConstraint> - </Association> <Association Name="FK_USERS_ORGANIZATIONS"> <End Type="RemoteModel.ORGANIZATION" Role="ORGANIZATION" Multiplicity="1" /> <End Type="RemoteModel.USER" Role="USER" Multiplicity="*" /> @@ -5863,62 +5223,6 @@ </Dependent> </ReferentialConstraint> </Association> - <Association Name="FK_PUBLISHED_TEST_PROJECTS_VERSIONS_PUBLISHED_TEST_PROJECTS"> - <End Type="RemoteModel.PUBLISHED_PROCEDURE_PROJECTS" Role="PUBLISHED_PROCEDURE_PROJECTS" Multiplicity="1"> - <OnDelete Action="Cascade" /> - </End> - <End Type="RemoteModel.PUBLISHED_PROCEDURE_PROJECTS_VERSIONS" Role="PUBLISHED_PROCEDURE_PROJECTS_VERSIONS" Multiplicity="*" /> - <ReferentialConstraint> - <Principal Role="PUBLISHED_PROCEDURE_PROJECTS"> - <PropertyRef Name="GUID" /> - </Principal> - <Dependent Role="PUBLISHED_PROCEDURE_PROJECTS_VERSIONS"> - <PropertyRef Name="PUBLISHED_PROCEDURE_PROJECT_GUID" /> - </Dependent> - </ReferentialConstraint> - </Association> - <Association Name="FK_RMLS_SPOOLS_RMLS"> - <End Type="RemoteModel.RML" Role="RML" Multiplicity="1"> - <OnDelete Action="Cascade" /> - </End> - <End Type="RemoteModel.RMLS_SPOOLS" Role="RMLS_SPOOLS" Multiplicity="*" /> - <ReferentialConstraint> - <Principal Role="RML"> - <PropertyRef Name="GUID" /> - </Principal> - <Dependent Role="RMLS_SPOOLS"> - <PropertyRef Name="RML_GUID" /> - </Dependent> - </ReferentialConstraint> - </Association> - <Association Name="FK_SITES_RMLS_RMLS"> - <End Type="RemoteModel.RML" Role="RML" Multiplicity="1"> - <OnDelete Action="Cascade" /> - </End> - <End Type="RemoteModel.SITES_RMLS" Role="SITES_RMLS" Multiplicity="*" /> - <ReferentialConstraint> - <Principal Role="RML"> - <PropertyRef Name="GUID" /> - </Principal> - <Dependent Role="SITES_RMLS"> - <PropertyRef Name="RML_GUID" /> - </Dependent> - </ReferentialConstraint> - </Association> - <Association Name="FK_RMLS_SPOOLS_SPOOL_TYPES"> - <End Type="RemoteModel.SPOOL_TYPES" Role="SPOOL_TYPES" Multiplicity="1"> - <OnDelete Action="Cascade" /> - </End> - <End Type="RemoteModel.RMLS_SPOOLS" Role="RMLS_SPOOLS" Multiplicity="*" /> - <ReferentialConstraint> - <Principal Role="SPOOL_TYPES"> - <PropertyRef Name="GUID" /> - </Principal> - <Dependent Role="RMLS_SPOOLS"> - <PropertyRef Name="SPOOL_TYPE_GUID" /> - </Dependent> - </ReferentialConstraint> - </Association> <Association Name="FK_ROLES_PERMISSIONS_ROLES"> <End Type="RemoteModel.ROLE" Role="ROLE" Multiplicity="1"> <OnDelete Action="Cascade" /> @@ -5947,38 +5251,8 @@ </Dependent> </ReferentialConstraint> </Association> - <Association Name="FK_SITES_CATALOGS_SITES"> - <End Type="RemoteModel.SITE" Role="SITE" Multiplicity="1"> - <OnDelete Action="Cascade" /> - </End> - <End Type="RemoteModel.SITES_CATALOGS" Role="SITES_CATALOGS" Multiplicity="*" /> - <ReferentialConstraint> - <Principal Role="SITE"> - <PropertyRef Name="GUID" /> - </Principal> - <Dependent Role="SITES_CATALOGS"> - <PropertyRef Name="SITE_GUID" /> - </Dependent> - </ReferentialConstraint> - </Association> - <Association Name="FK_SITES_RMLS_SITES"> - <End Type="RemoteModel.SITE" Role="SITE" Multiplicity="1"> - <OnDelete Action="Cascade" /> - </End> - <End Type="RemoteModel.SITES_RMLS" Role="SITES_RMLS" Multiplicity="*" /> - <ReferentialConstraint> - <Principal Role="SITE"> - <PropertyRef Name="GUID" /> - </Principal> - <Dependent Role="SITES_RMLS"> - <PropertyRef Name="SITE_GUID" /> - </Dependent> - </ReferentialConstraint> - </Association> <Association Name="FK_SPOOLS_SPOOL_TYPES"> - <End Type="RemoteModel.SPOOL_TYPES" Role="SPOOL_TYPES" Multiplicity="1"> - <OnDelete Action="Cascade" /> - </End> + <End Type="RemoteModel.SPOOL_TYPES" Role="SPOOL_TYPES" Multiplicity="1" /> <End Type="RemoteModel.SPOOL" Role="SPOOL" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="SPOOL_TYPES"> @@ -6002,9 +5276,7 @@ </ReferentialConstraint> </Association> <Association Name="FK_USERS_ROLES_USERS"> - <End Type="RemoteModel.USER" Role="USER" Multiplicity="1"> - <OnDelete Action="Cascade" /> - </End> + <End Type="RemoteModel.USER" Role="USER" Multiplicity="1" /> <End Type="RemoteModel.USERS_ROLES" Role="USERS_ROLES" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="USER"> @@ -6030,21 +5302,6 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> - <EntitySetMapping Name="ACTION_LOGS"> - <EntityTypeMapping TypeName="RemoteModel.ACTION_LOGS"> - <MappingFragment StoreEntitySet="ACTION_LOGS"> - <ScalarProperty Name="DIFFERENCE" ColumnName="DIFFERENCE" /> - <ScalarProperty Name="MESSAGE" ColumnName="MESSAGE" /> - <ScalarProperty Name="RELATED_OBJECT_GUID" ColumnName="RELATED_OBJECT_GUID" /> - <ScalarProperty Name="RELATED_OBJECT_NAME" ColumnName="RELATED_OBJECT_NAME" /> - <ScalarProperty Name="USER_GUID" ColumnName="USER_GUID" /> - <ScalarProperty Name="TYPE" ColumnName="TYPE" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="ID" ColumnName="ID" /> - </MappingFragment> - </EntityTypeMapping> - </EntitySetMapping> <EntitySetMapping Name="ADDRESSES"> <EntityTypeMapping TypeName="RemoteModel.ADDRESS"> <MappingFragment StoreEntitySet="ADDRESSES"> @@ -6097,7 +5354,6 @@ <EntitySetMapping Name="BRUSH_STOPS"> <EntityTypeMapping TypeName="RemoteModel.BRUSH_STOPS"> <MappingFragment StoreEntitySet="BRUSH_STOPS"> - <ScalarProperty Name="IS_TRANSPARENT" ColumnName="IS_TRANSPARENT" /> <ScalarProperty Name="COLOR_CATALOGS_ITEM_GUID" ColumnName="COLOR_CATALOGS_ITEM_GUID" /> <ScalarProperty Name="COLOR_CATALOG_GUID" ColumnName="COLOR_CATALOG_GUID" /> <ScalarProperty Name="CORRECTED" ColumnName="CORRECTED" /> @@ -6296,22 +5552,6 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> - <EntitySetMapping Name="DATA_STORE_ITEMS"> - <EntityTypeMapping TypeName="RemoteModel.DATA_STORE_ITEMS"> - <MappingFragment StoreEntitySet="DATA_STORE_ITEMS"> - <ScalarProperty Name="IS_SYNCHRONIZED" ColumnName="IS_SYNCHRONIZED" /> - <ScalarProperty Name="IS_DELETED" ColumnName="IS_DELETED" /> - <ScalarProperty Name="VALUE" ColumnName="VALUE" /> - <ScalarProperty Name="DATA_TYPE" ColumnName="DATA_TYPE" /> - <ScalarProperty Name="KEY" ColumnName="KEY" /> - <ScalarProperty Name="COLLECTION_NAME" ColumnName="COLLECTION_NAME" /> - <ScalarProperty Name="MACHINE_GUID" ColumnName="MACHINE_GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="ID" ColumnName="ID" /> - </MappingFragment> - </EntityTypeMapping> - </EntitySetMapping> <EntitySetMapping Name="DISPENSER_TYPES"> <EntityTypeMapping TypeName="RemoteModel.DISPENSER_TYPES"> <MappingFragment StoreEntitySet="DISPENSER_TYPES"> @@ -6355,7 +5595,6 @@ <EntitySetMapping Name="EVENT_TYPES"> <EntityTypeMapping TypeName="RemoteModel.EVENT_TYPES"> <MappingFragment StoreEntitySet="EVENT_TYPES"> - <ScalarProperty Name="PERSISTENT" ColumnName="PERSISTENT" /> <ScalarProperty Name="GUIDANCE" ColumnName="GUIDANCE" /> <ScalarProperty Name="REQUIRES_USER_INTERVENTION" ColumnName="REQUIRES_USER_INTERVENTION" /> <ScalarProperty Name="EVENT_ACTIONS" ColumnName="EVENT_ACTIONS" /> @@ -6396,33 +5635,6 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> - <EntitySetMapping Name="FSE_VERSIONS"> - <EntityTypeMapping TypeName="RemoteModel.FSE_VERSIONS"> - <MappingFragment StoreEntitySet="FSE_VERSIONS"> - <ScalarProperty Name="USER_GUID" ColumnName="USER_GUID" /> - <ScalarProperty Name="COMMENTS" ColumnName="COMMENTS" /> - <ScalarProperty Name="INSTALLER_BLOB_NAME" ColumnName="INSTALLER_BLOB_NAME" /> - <ScalarProperty Name="BLOB_NAME" ColumnName="BLOB_NAME" /> - <ScalarProperty Name="VERSION" ColumnName="VERSION" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="ID" ColumnName="ID" /> - </MappingFragment> - </EntityTypeMapping> - </EntitySetMapping> - <EntitySetMapping Name="GLOBAL_DATA_STORE_ITEMS"> - <EntityTypeMapping TypeName="RemoteModel.GLOBAL_DATA_STORE_ITEMS"> - <MappingFragment StoreEntitySet="GLOBAL_DATA_STORE_ITEMS"> - <ScalarProperty Name="VALUE" ColumnName="VALUE" /> - <ScalarProperty Name="DATA_TYPE" ColumnName="DATA_TYPE" /> - <ScalarProperty Name="KEY" ColumnName="KEY" /> - <ScalarProperty Name="COLLECTION_NAME" ColumnName="COLLECTION_NAME" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="ID" ColumnName="ID" /> - </MappingFragment> - </EntityTypeMapping> - </EntitySetMapping> <EntitySetMapping Name="HARDWARE_BLOWER_TYPES"> <EntityTypeMapping TypeName="RemoteModel.HARDWARE_BLOWER_TYPES"> <MappingFragment StoreEntitySet="HARDWARE_BLOWER_TYPES"> @@ -6526,7 +5738,6 @@ <EntitySetMapping Name="HARDWARE_MOTORS"> <EntityTypeMapping TypeName="RemoteModel.HARDWARE_MOTORS"> <MappingFragment StoreEntitySet="HARDWARE_MOTORS"> - <ScalarProperty Name="P01_CONFIG_WORD" ColumnName="P01_CONFIG_WORD" /> <ScalarProperty Name="ACTIVE" ColumnName="ACTIVE" /> <ScalarProperty Name="T_OFF_MIN" ColumnName="T_OFF_MIN" /> <ScalarProperty Name="T_ON_MIN" ColumnName="T_ON_MIN" /> @@ -6707,35 +5918,12 @@ <EntitySetMapping Name="JOB_RUNS"> <EntityTypeMapping TypeName="RemoteModel.JOB_RUNS"> <MappingFragment StoreEntitySet="JOB_RUNS"> - <ScalarProperty Name="IS_SYNCHRONIZED" ColumnName="IS_SYNCHRONIZED" /> - <ScalarProperty Name="IS_HEAD_CLEANING" ColumnName="IS_HEAD_CLEANING" /> <ScalarProperty Name="FAILED_MESSAGE" ColumnName="FAILED_MESSAGE" /> <ScalarProperty Name="END_POSITION" ColumnName="END_POSITION" /> - <ScalarProperty Name="CLEANER_QUANTITY" ColumnName="CLEANER_QUANTITY" /> - <ScalarProperty Name="LUBRICANT_QUANTITY" ColumnName="LUBRICANT_QUANTITY" /> - <ScalarProperty Name="TRANSPARENT_QUANTITY" ColumnName="TRANSPARENT_QUANTITY" /> - <ScalarProperty Name="BLACK_QUANTITY" ColumnName="BLACK_QUANTITY" /> - <ScalarProperty Name="YELLOW_QUANTITY" ColumnName="YELLOW_QUANTITY" /> - <ScalarProperty Name="MAGENTA_QUANTITY" ColumnName="MAGENTA_QUANTITY" /> - <ScalarProperty Name="CYAN_QUANTITY" ColumnName="CYAN_QUANTITY" /> - <ScalarProperty Name="LIQUID_QUANTITY_STRING" ColumnName="LIQUID_QUANTITY_STRING" /> - <ScalarProperty Name="GRADIENT_RESOLUTION_CM" ColumnName="GRADIENT_RESOLUTION_CM" /> - <ScalarProperty Name="IS_GRADIENT" ColumnName="IS_GRADIENT" /> - <ScalarProperty Name="JOB_LENGTH" ColumnName="JOB_LENGTH" /> <ScalarProperty Name="STATUS" ColumnName="STATUS" /> <ScalarProperty Name="END_DATE" ColumnName="END_DATE" /> - <ScalarProperty Name="ACTUAL_START_DATE" ColumnName="ACTUAL_START_DATE" /> - <ScalarProperty Name="HEATING_START_DATE" ColumnName="HEATING_START_DATE" /> - <ScalarProperty Name="UPLOADING_START_DATE" ColumnName="UPLOADING_START_DATE" /> <ScalarProperty Name="START_DATE" ColumnName="START_DATE" /> - <ScalarProperty Name="JOB_STRING" ColumnName="JOB_STRING" /> - <ScalarProperty Name="JOB_SOURCE" ColumnName="JOB_SOURCE" /> - <ScalarProperty Name="JOB_DESIGNATION" ColumnName="JOB_DESIGNATION" /> - <ScalarProperty Name="JOB_NAME" ColumnName="JOB_NAME" /> - <ScalarProperty Name="USER_GUID" ColumnName="USER_GUID" /> - <ScalarProperty Name="RML_GUID" ColumnName="RML_GUID" /> <ScalarProperty Name="JOB_GUID" ColumnName="JOB_GUID" /> - <ScalarProperty Name="MACHINE_GUID" ColumnName="MACHINE_GUID" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="GUID" ColumnName="GUID" /> <ScalarProperty Name="ID" ColumnName="ID" /> @@ -6745,8 +5933,6 @@ <EntitySetMapping Name="JOBS"> <EntityTypeMapping TypeName="RemoteModel.JOB"> <MappingFragment StoreEntitySet="JOBS"> - <ScalarProperty Name="SOURCE" ColumnName="SOURCE" /> - <ScalarProperty Name="IS_SYNCHRONIZED" ColumnName="IS_SYNCHRONIZED" /> <ScalarProperty Name="LENGTH_PERCENTAGE_FACTOR" ColumnName="LENGTH_PERCENTAGE_FACTOR" /> <ScalarProperty Name="EDITING_STATE" ColumnName="EDITING_STATE" /> <ScalarProperty Name="SAMPLE_DYE_APPROVE_DATE" ColumnName="SAMPLE_DYE_APPROVE_DATE" /> @@ -6800,7 +5986,6 @@ <EntitySetMapping Name="LIQUID_TYPES"> <EntityTypeMapping TypeName="RemoteModel.LIQUID_TYPES"> <MappingFragment StoreEntitySet="LIQUID_TYPES"> - <ScalarProperty Name="SHORT_NAME" ColumnName="SHORT_NAME" /> <ScalarProperty Name="HAS_PIGMENT" ColumnName="HAS_PIGMENT" /> <ScalarProperty Name="PREFERRED_INDEX" ColumnName="PREFERRED_INDEX" /> <ScalarProperty Name="COLOR" ColumnName="COLOR" /> @@ -6855,8 +6040,6 @@ <EntitySetMapping Name="MACHINES"> <EntityTypeMapping TypeName="RemoteModel.MACHINE"> <MappingFragment StoreEntitySet="MACHINES"> - <ScalarProperty Name="ACTIVATION_KEY" ColumnName="ACTIVATION_KEY" /> - <ScalarProperty Name="HEAD_TYPE" ColumnName="HEAD_TYPE" /> <ScalarProperty Name="DEVICE_NAME" ColumnName="DEVICE_NAME" /> <ScalarProperty Name="DEVICE_ID" ColumnName="DEVICE_ID" /> <ScalarProperty Name="IS_DEVICE_REGISTERED" ColumnName="IS_DEVICE_REGISTERED" /> @@ -6882,7 +6065,6 @@ <ScalarProperty Name="DEFAULT_RML_GUID" ColumnName="DEFAULT_RML_GUID" /> <ScalarProperty Name="CONFIGURATION_GUID" ColumnName="CONFIGURATION_GUID" /> <ScalarProperty Name="MACHINE_VERSION_GUID" ColumnName="MACHINE_VERSION_GUID" /> - <ScalarProperty Name="SITE_GUID" ColumnName="SITE_GUID" /> <ScalarProperty Name="ORGANIZATION_GUID" ColumnName="ORGANIZATION_GUID" /> <ScalarProperty Name="PRODUCTION_DATE" ColumnName="PRODUCTION_DATE" /> <ScalarProperty Name="NAME" ColumnName="NAME" /> @@ -6896,7 +6078,6 @@ <EntitySetMapping Name="MACHINES_EVENTS"> <EntityTypeMapping TypeName="RemoteModel.MACHINES_EVENTS"> <MappingFragment StoreEntitySet="MACHINES_EVENTS"> - <ScalarProperty Name="IS_SYNCHRONIZED" ColumnName="IS_SYNCHRONIZED" /> <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> <ScalarProperty Name="DATE_TIME" ColumnName="DATE_TIME" /> <ScalarProperty Name="USER_GUID" ColumnName="USER_GUID" /> @@ -6981,17 +6162,6 @@ <EntitySetMapping Name="PROCESS_PARAMETERS_TABLES"> <EntityTypeMapping TypeName="RemoteModel.PROCESS_PARAMETERS_TABLES"> <MappingFragment StoreEntitySet="PROCESS_PARAMETERS_TABLES"> - <ScalarProperty Name="PRESSURE_BUILD_UP" ColumnName="PRESSURE_BUILD_UP" /> - <ScalarProperty Name="L_BLOWER_TEMP" ColumnName="L_BLOWER_TEMP" /> - <ScalarProperty Name="L_BLOWER_FLOW" ColumnName="L_BLOWER_FLOW" /> - <ScalarProperty Name="R_BLOWER_TEMP" ColumnName="R_BLOWER_TEMP" /> - <ScalarProperty Name="R_BLOWER_FLOW" ColumnName="R_BLOWER_FLOW" /> - <ScalarProperty Name="HEAD_ZONE12_TEMP" ColumnName="HEAD_ZONE12_TEMP" /> - <ScalarProperty Name="HEAD_ZONE11_TEMP" ColumnName="HEAD_ZONE11_TEMP" /> - <ScalarProperty Name="HEAD_ZONE10_TEMP" ColumnName="HEAD_ZONE10_TEMP" /> - <ScalarProperty Name="HEAD_ZONE9_TEMP" ColumnName="HEAD_ZONE9_TEMP" /> - <ScalarProperty Name="HEAD_ZONE8_TEMP" ColumnName="HEAD_ZONE8_TEMP" /> - <ScalarProperty Name="HEAD_ZONE7_TEMP" ColumnName="HEAD_ZONE7_TEMP" /> <ScalarProperty Name="TABLE_INDEX" ColumnName="TABLE_INDEX" /> <ScalarProperty Name="PROCESS_PARAMETERS_TABLES_GROUP_GUID" ColumnName="PROCESS_PARAMETERS_TABLES_GROUP_GUID" /> <ScalarProperty Name="HEAD_AIR_FLOW" ColumnName="HEAD_AIR_FLOW" /> @@ -7033,54 +6203,9 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> - <EntitySetMapping Name="PUBLISHED_PROCEDURE_PROJECTS"> - <EntityTypeMapping TypeName="RemoteModel.PUBLISHED_PROCEDURE_PROJECTS"> - <MappingFragment StoreEntitySet="PUBLISHED_PROCEDURE_PROJECTS"> - <ScalarProperty Name="VISIBILITY" ColumnName="VISIBILITY" /> - <ScalarProperty Name="IS_VISIBLE" ColumnName="IS_VISIBLE" /> - <ScalarProperty Name="SORTING_INDEX" ColumnName="SORTING_INDEX" /> - <ScalarProperty Name="PUBLISH_DATE" ColumnName="PUBLISH_DATE" /> - <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> - <ScalarProperty Name="NAME" ColumnName="NAME" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="ID" ColumnName="ID" /> - </MappingFragment> - </EntityTypeMapping> - </EntitySetMapping> - <EntitySetMapping Name="PUBLISHED_PROCEDURE_PROJECTS_VERSIONS"> - <EntityTypeMapping TypeName="RemoteModel.PUBLISHED_PROCEDURE_PROJECTS_VERSIONS"> - <MappingFragment StoreEntitySet="PUBLISHED_PROCEDURE_PROJECTS_VERSIONS"> - <ScalarProperty Name="PROJECT_JSON_STRING" ColumnName="PROJECT_JSON_STRING" /> - <ScalarProperty Name="AUTHOR" ColumnName="AUTHOR" /> - <ScalarProperty Name="VERSION" ColumnName="VERSION" /> - <ScalarProperty Name="PUBLISHED_PROCEDURE_PROJECT_GUID" ColumnName="PUBLISHED_PROCEDURE_PROJECT_GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="ID" ColumnName="ID" /> - </MappingFragment> - </EntityTypeMapping> - </EntitySetMapping> <EntitySetMapping Name="RMLS"> <EntityTypeMapping TypeName="RemoteModel.RML"> <MappingFragment StoreEntitySet="RMLS"> - <ScalarProperty Name="ARC_HEAD_CLEANING_MOTOR_SPEED" ColumnName="ARC_HEAD_CLEANING_MOTOR_SPEED" /> - <ScalarProperty Name="CLEANER_FLOW" ColumnName="CLEANER_FLOW" /> - <ScalarProperty Name="BYPASS_ROCKERS" ColumnName="BYPASS_ROCKERS" /> - <ScalarProperty Name="WINDER_D" ColumnName="WINDER_D" /> - <ScalarProperty Name="WINDER_I" ColumnName="WINDER_I" /> - <ScalarProperty Name="WINDER_P" ColumnName="WINDER_P" /> - <ScalarProperty Name="PULLER_D" ColumnName="PULLER_D" /> - <ScalarProperty Name="PULLER_I" ColumnName="PULLER_I" /> - <ScalarProperty Name="PULLER_P" ColumnName="PULLER_P" /> - <ScalarProperty Name="FEEDER_D" ColumnName="FEEDER_D" /> - <ScalarProperty Name="FEEDER_I" ColumnName="FEEDER_I" /> - <ScalarProperty Name="FEEDER_P" ColumnName="FEEDER_P" /> - <ScalarProperty Name="SPOOLS_CALIBRATIONS_STRING" ColumnName="SPOOLS_CALIBRATIONS_STRING" /> - <ScalarProperty Name="QUALIFICATION_DATE" ColumnName="QUALIFICATION_DATE" /> - <ScalarProperty Name="QUALIFICATION_LEVEL" ColumnName="QUALIFICATION_LEVEL" /> - <ScalarProperty Name="HEAD_TYPE" ColumnName="HEAD_TYPE" /> - <ScalarProperty Name="USE_COLOR_LIB_GRADIENTS" ColumnName="USE_COLOR_LIB_GRADIENTS" /> <ScalarProperty Name="COLOR_CONVERSION_VERSION" ColumnName="COLOR_CONVERSION_VERSION" /> <ScalarProperty Name="CCT_GUID" ColumnName="CCT_GUID" /> <ScalarProperty Name="THUMBNAIL" ColumnName="THUMBNAIL" /> @@ -7106,7 +6231,6 @@ <ScalarProperty Name="WHITE_POINT_L" ColumnName="WHITE_POINT_L" /> <ScalarProperty Name="CODE" ColumnName="CODE" /> <ScalarProperty Name="MANUFACTURER" ColumnName="MANUFACTURER" /> - <ScalarProperty Name="DISPLAY_NAME" ColumnName="DISPLAY_NAME" /> <ScalarProperty Name="NAME" ColumnName="NAME" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="GUID" ColumnName="GUID" /> @@ -7114,21 +6238,6 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> - <EntitySetMapping Name="RMLS_SPOOLS"> - <EntityTypeMapping TypeName="RemoteModel.RMLS_SPOOLS"> - <MappingFragment StoreEntitySet="RMLS_SPOOLS"> - <ScalarProperty Name="BOTTOM_BACKING_RATE" ColumnName="BOTTOM_BACKING_RATE" /> - <ScalarProperty Name="BACKING_RATE" ColumnName="BACKING_RATE" /> - <ScalarProperty Name="LENGTH" ColumnName="LENGTH" /> - <ScalarProperty Name="ROTATIONS_PER_PASSAGE" ColumnName="ROTATIONS_PER_PASSAGE" /> - <ScalarProperty Name="RML_GUID" ColumnName="RML_GUID" /> - <ScalarProperty Name="SPOOL_TYPE_GUID" ColumnName="SPOOL_TYPE_GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="ID" ColumnName="ID" /> - </MappingFragment> - </EntityTypeMapping> - </EntitySetMapping> <EntitySetMapping Name="ROLES"> <EntityTypeMapping TypeName="RemoteModel.ROLE"> <MappingFragment StoreEntitySet="ROLES"> @@ -7165,48 +6274,9 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> - <EntitySetMapping Name="SITES"> - <EntityTypeMapping TypeName="RemoteModel.SITE"> - <MappingFragment StoreEntitySet="SITES"> - <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> - <ScalarProperty Name="NAME" ColumnName="NAME" /> - <ScalarProperty Name="ORGANIZATION_GUID" ColumnName="ORGANIZATION_GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="ID" ColumnName="ID" /> - </MappingFragment> - </EntityTypeMapping> - </EntitySetMapping> - <EntitySetMapping Name="SITES_CATALOGS"> - <EntityTypeMapping TypeName="RemoteModel.SITES_CATALOGS"> - <MappingFragment StoreEntitySet="SITES_CATALOGS"> - <ScalarProperty Name="COLOR_CATALOG_GUID" ColumnName="COLOR_CATALOG_GUID" /> - <ScalarProperty Name="SITE_GUID" ColumnName="SITE_GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="ID" ColumnName="ID" /> - </MappingFragment> - </EntityTypeMapping> - </EntitySetMapping> - <EntitySetMapping Name="SITES_RMLS"> - <EntityTypeMapping TypeName="RemoteModel.SITES_RMLS"> - <MappingFragment StoreEntitySet="SITES_RMLS"> - <ScalarProperty Name="RML_GUID" ColumnName="RML_GUID" /> - <ScalarProperty Name="SITE_GUID" ColumnName="SITE_GUID" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="ID" ColumnName="ID" /> - </MappingFragment> - </EntityTypeMapping> - </EntitySetMapping> <EntitySetMapping Name="SPOOL_TYPES"> <EntityTypeMapping TypeName="RemoteModel.SPOOL_TYPES"> <MappingFragment StoreEntitySet="SPOOL_TYPES"> - <ScalarProperty Name="LIMIT_SWITCH_START_POINT_OFFSET" ColumnName="LIMIT_SWITCH_START_POINT_OFFSET" /> - <ScalarProperty Name="BOTTOM_BACKING_RATE" ColumnName="BOTTOM_BACKING_RATE" /> - <ScalarProperty Name="SEGMENT_OFFSET_PULSES" ColumnName="SEGMENT_OFFSET_PULSES" /> - <ScalarProperty Name="BACKING_RATE" ColumnName="BACKING_RATE" /> - <ScalarProperty Name="START_OFFSET_PULSES" ColumnName="START_OFFSET_PULSES" /> <ScalarProperty Name="ROTATIONS_PER_PASSAGE" ColumnName="ROTATIONS_PER_PASSAGE" /> <ScalarProperty Name="DIAMETER" ColumnName="DIAMETER" /> <ScalarProperty Name="WEIGHT" ColumnName="WEIGHT" /> @@ -7222,7 +6292,6 @@ <EntitySetMapping Name="SPOOLS"> <EntityTypeMapping TypeName="RemoteModel.SPOOL"> <MappingFragment StoreEntitySet="SPOOLS"> - <ScalarProperty Name="LIMIT_SWITCH_START_POINT_OFFSET" ColumnName="LIMIT_SWITCH_START_POINT_OFFSET" /> <ScalarProperty Name="BOTTOM_BACKING_RATE" ColumnName="BOTTOM_BACKING_RATE" /> <ScalarProperty Name="SEGMENT_OFFSET_PULSES" ColumnName="SEGMENT_OFFSET_PULSES" /> <ScalarProperty Name="BACKING_RATE" ColumnName="BACKING_RATE" /> @@ -7246,28 +6315,9 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> - <EntitySetMapping Name="TANGO_UPDATES"> - <EntityTypeMapping TypeName="RemoteModel.TANGO_UPDATES"> - <MappingFragment StoreEntitySet="TANGO_UPDATES"> - <ScalarProperty Name="IS_SYNCHRONIZED" ColumnName="IS_SYNCHRONIZED" /> - <ScalarProperty Name="END_DATE" ColumnName="END_DATE" /> - <ScalarProperty Name="START_DATE" ColumnName="START_DATE" /> - <ScalarProperty Name="FAILED_LOG" ColumnName="FAILED_LOG" /> - <ScalarProperty Name="FAILED_REASON" ColumnName="FAILED_REASON" /> - <ScalarProperty Name="STATUS" ColumnName="STATUS" /> - <ScalarProperty Name="MACHINE_GUID" ColumnName="MACHINE_GUID" /> - <ScalarProperty Name="FIRMWARE_VERSION" ColumnName="FIRMWARE_VERSION" /> - <ScalarProperty Name="APPLICATION_VERSION" ColumnName="APPLICATION_VERSION" /> - <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> - <ScalarProperty Name="GUID" ColumnName="GUID" /> - <ScalarProperty Name="ID" ColumnName="ID" /> - </MappingFragment> - </EntityTypeMapping> - </EntitySetMapping> <EntitySetMapping Name="TANGO_VERSIONS"> <EntityTypeMapping TypeName="RemoteModel.TANGO_VERSIONS"> <MappingFragment StoreEntitySet="TANGO_VERSIONS"> - <ScalarProperty Name="DISABLED" ColumnName="DISABLED" /> <ScalarProperty Name="MACHINE_VERSION_GUID" ColumnName="MACHINE_VERSION_GUID" /> <ScalarProperty Name="USER_GUID" ColumnName="USER_GUID" /> <ScalarProperty Name="COMMENTS" ColumnName="COMMENTS" /> @@ -7376,7 +6426,6 @@ <EntitySetMapping Name="USERS"> <EntityTypeMapping TypeName="RemoteModel.USER"> <MappingFragment StoreEntitySet="USERS"> - <ScalarProperty Name="PASSWORD_CHANGE_REQUIRED" ColumnName="PASSWORD_CHANGE_REQUIRED" /> <ScalarProperty Name="LAST_LOGIN" ColumnName="LAST_LOGIN" /> <ScalarProperty Name="ADDRESS_GUID" ColumnName="ADDRESS_GUID" /> <ScalarProperty Name="CONTACT_GUID" ColumnName="CONTACT_GUID" /> |