diff options
Diffstat (limited to 'Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx')
| -rw-r--r-- | Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx | 1162 |
1 files changed, 806 insertions, 356 deletions
diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx index 9fb01760a..23fbed26c 100644 --- a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx @@ -9,147 +9,181 @@ <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="100" Nullable="false" /> </EntityType> <EntityType Name="ADDRESSES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> - <Property Name="ADDRESS_STRING" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="LOCALITY" Type="nvarchar" MaxLength="2147483647" /> - <Property Name="COUNTRY" Type="nvarchar" MaxLength="2147483647" /> - <Property Name="CITY" Type="nvarchar" MaxLength="2147483647" /> - <Property Name="STATE" Type="nvarchar" MaxLength="2147483647" /> - <Property Name="COUNTRY_CODE" Type="nvarchar" MaxLength="2147483647" /> - <Property Name="POSTAL_CODE" Type="nvarchar" MaxLength="2147483647" /> + <Property Name="ADDRESS_STRING" Type="nvarchar" MaxLength="100" Nullable="false" /> + <Property Name="LOCALITY" Type="nvarchar" MaxLength="56" /> + <Property Name="COUNTRY" Type="nvarchar" MaxLength="50" /> + <Property Name="CITY" Type="nvarchar" MaxLength="30" /> + <Property Name="STATE" Type="nvarchar" MaxLength="30" /> + <Property Name="COUNTRY_CODE" Type="nvarchar" MaxLength="2" /> + <Property Name="POSTAL_CODE" Type="nvarchar" MaxLength="15" /> </EntityType> <EntityType Name="APPLICATION_DISPLAY_PANEL_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="VERSION" Type="real" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> </EntityType> <EntityType Name="APPLICATION_FIRMWARE_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="VERSION" Type="real" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> </EntityType> <EntityType Name="APPLICATION_OS_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="VERSION" Type="real" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> </EntityType> <EntityType Name="APPLICATION_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="VERSION" Type="real" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + </EntityType> + <EntityType Name="BRUSH_STOPS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="SEGMENT_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="COLOR_SPACE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="OFFSET_PERCENT" Type="real" Nullable="false" /> + <Property Name="CYAN" Type="real" Nullable="false" /> + <Property Name="MAGENTA" Type="real" Nullable="false" /> + <Property Name="YELLOW" Type="real" Nullable="false" /> + <Property Name="BLACK" Type="real" Nullable="false" /> + <Property Name="RED" Type="integer" Nullable="false" /> + <Property Name="GREEN" Type="integer" Nullable="false" /> + <Property Name="BLUE" Type="integer" Nullable="false" /> + <Property Name="L" Type="integer" Nullable="false" /> + <Property Name="A" Type="integer" Nullable="false" /> + <Property Name="B" Type="integer" Nullable="false" /> + <Property Name="PANTON_GUID" Type="varchar" MaxLength="36" /> </EntityType> <EntityType Name="CARTRIDGE_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> </EntityType> <EntityType Name="CATS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="LIQUID_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="MACHINE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="LIQUID_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="RML_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="DATA" Type="blob" Nullable="false" /> </EntityType> <EntityType Name="CCTS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="FORWARD_FILE_NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="INVERSE_FILE_NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="100" Nullable="false" /> + <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="200" Nullable="false" /> + <Property Name="FORWARD_FILE_NAME" Type="nvarchar" MaxLength="100" Nullable="false" /> + <Property Name="INVERSE_FILE_NAME" Type="nvarchar" MaxLength="100" Nullable="false" /> <Property Name="FORWARD_DATA" Type="blob" Nullable="false" /> <Property Name="INVERSE_DATA" Type="blob" Nullable="false" /> <Property Name="VERSION" Type="real" Nullable="false" /> - <Property Name="RML_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="RML_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + </EntityType> + <EntityType Name="COLOR_SPACES"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="CODE" Type="integer" Nullable="false" /> + <Property Name="NAME" Type="varchar" MaxLength="50" Nullable="false" /> + <Property Name="DESCRIPTION" Type="varchar" MaxLength="100" Nullable="false" /> </EntityType> <EntityType Name="CONFIGURATIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="CREATION_DATE" Type="datetime" Nullable="false" /> - <Property Name="APPLICATION_VERSION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="APPLICATION_OS_VERSION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="APPLICATION_FIRMWARE_VERSION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="EMBEDDED_FIRMWARE_VERSION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="EMBEDDED_SOFTWARE_VERSION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="HARDWARE_VERSION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="APPLICATION_VERSION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="APPLICATION_OS_VERSION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="APPLICATION_FIRMWARE_VERSION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="EMBEDDED_FIRMWARE_VERSION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="EMBEDDED_SOFTWARE_VERSION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="HARDWARE_VERSION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> </EntityType> <EntityType Name="CONTACTS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> - <Property Name="FIRST_NAME" Type="nvarchar" MaxLength="2147483647" /> - <Property Name="LAST_NAME" Type="nvarchar" MaxLength="2147483647" /> - <Property Name="FULL_NAME" Type="nvarchar" MaxLength="2147483647" /> - <Property Name="EMAIL" Type="nvarchar" MaxLength="2147483647" /> - <Property Name="PHONE_NUMBER" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="FAX" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="FIRST_NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="LAST_NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="FULL_NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="EMAIL" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="PHONE_NUMBER" Type="nvarchar" MaxLength="50" /> + <Property Name="FAX" Type="nvarchar" MaxLength="50" /> </EntityType> <EntityType Name="DISPENSER_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="NL_PER_PULSE" Type="real" Nullable="false" /> <Property Name="CAPACITY" Type="real" Nullable="false" /> </EntityType> @@ -157,107 +191,136 @@ <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="VERSION" Type="real" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> </EntityType> <EntityType Name="EMBEDDED_SOFTWARE_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="VERSION" Type="real" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> </EntityType> <EntityType Name="EVENT_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="100" Nullable="false" /> </EntityType> <EntityType Name="EVENT_TYPES_ACTIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="EVENT_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="ACTION_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="EVENT_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="ACTION_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> </EntityType> <EntityType Name="FIBER_SHAPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> </EntityType> <EntityType Name="FIBER_SYNTHS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> </EntityType> <EntityType Name="HARDWARE_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="VERSION" Type="real" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> </EntityType> <EntityType Name="IDS_PACKS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="CONFIGURATION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="DISPENSER_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="LIQUID_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="CARTRIDGE_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="MID_TANK_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="CONFIGURATION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="DISPENSER_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LIQUID_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="CARTRIDGE_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="MID_TANK_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="PACK_INDEX" Type="integer" Nullable="false" /> </EntityType> + <EntityType Name="JOB_RUNS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="JOB_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="START_DATE" Type="datetime" Nullable="false" /> + <Property Name="END_DATE" Type="datetime" Nullable="false" /> + <Property Name="SUCCESSFUL" Type="bit" Nullable="false" /> + </EntityType> + <EntityType Name="JOBS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="CREATION_DATE" Type="datetime" Nullable="false" /> + <Property Name="MACHINE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="RML_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="WINDING_METHOD_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="100" Nullable="false" /> + <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="200" /> + <Property Name="INTER_SEGMENT_LENGTH" Type="real" Nullable="false" /> + <Property Name="ENABLE_INTER_SEGMENT" Type="bit" Nullable="false" /> + <Property Name="ENABLE_LUBRICATION" Type="bit" Nullable="false" /> + </EntityType> <EntityType Name="LINEAR_MASS_DENSITY_UNITS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> </EntityType> <EntityType Name="LIQUID_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="VERSION" Type="real" Nullable="false" /> <Property Name="COLOR" Type="integer" Nullable="false" /> </EntityType> @@ -265,67 +328,67 @@ <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="LIQUID_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="RML_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="LIQUID_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="RML_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="MAX_NL_PER_CM" Type="real" Nullable="false" /> </EntityType> <EntityType Name="MACHINE_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="VERSION" Type="real" Nullable="false" /> - <Property Name="DEFAULT_CONFIGURATION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="DEFAULT_CONFIGURATION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> </EntityType> <EntityType Name="MACHINES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="SERIAL_NUMBER" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" /> + <Property Name="SERIAL_NUMBER" Type="varchar" MaxLength="50" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" /> <Property Name="PRODUCTION_DATE" Type="datetime" Nullable="false" /> - <Property Name="ORGANIZATION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="MACHINE_VERSION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="CONFIGURATION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ORGANIZATION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="MACHINE_VERSION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="CONFIGURATION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> </EntityType> <EntityType Name="MACHINES_CONFIGURATIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="MACHINE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="CONFIGURATION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="MACHINE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="CONFIGURATION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> </EntityType> <EntityType Name="MACHINES_EVENTS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="MACHINE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="EVENT_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="USER_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="MACHINE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="EVENT_TYPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="USER_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="DATE_TIME" Type="datetime" Nullable="false" /> - <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="200" /> </EntityType> <EntityType Name="MEDIA_COLORS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="COLOR" Type="integer" Nullable="false" /> </EntityType> @@ -333,81 +396,120 @@ <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> </EntityType> <EntityType Name="MEDIA_MATERIALS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> </EntityType> <EntityType Name="MEDIA_PURPOSES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> </EntityType> <EntityType Name="MID_TANK_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> <Property Name="LITER_CAPACITY" Type="real" Nullable="false" /> </EntityType> <EntityType Name="ORGANIZATIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="CONTACT_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="ADDRESS_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="CONTACT_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="ADDRESS_GUID" Type="varchar" MaxLength="36" Nullable="false" /> </EntityType> <EntityType Name="PERMISSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="30" Nullable="false" /> + <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="100" Nullable="false" /> + </EntityType> + <EntityType Name="PROCESS_PARAMETERS_TABLES"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="DYEING_SPEED" Type="real" Nullable="false" /> + <Property Name="MIN_INK_UPTAKE" Type="real" Nullable="false" /> + <Property Name="MIXER_TEMP" Type="real" Nullable="false" /> + <Property Name="HEAD_ZONE1_TEMP" Type="real" Nullable="false" /> + <Property Name="HEAD_ZONE2_TEMP" Type="real" Nullable="false" /> + <Property Name="HEAD_ZONE3_TEMP" Type="real" Nullable="false" /> + <Property Name="HEAD_AIR_FLOW" Type="real" Nullable="false" /> + <Property Name="FEEDER_TENSION" Type="real" Nullable="false" /> + <Property Name="PULLER_TENSION" Type="real" Nullable="false" /> + <Property Name="DRYER_BUFFER_LENGTH" Type="real" Nullable="false" /> + <Property Name="DRYER_ZONE1_TEMP" Type="real" Nullable="false" /> + <Property Name="DRYER_ZONE2_TEMP" Type="real" Nullable="false" /> + <Property Name="DRYER_ZONE3_TEMP" Type="real" Nullable="false" /> + <Property Name="DRYER_AIR_FLOW" Type="real" Nullable="false" /> + <Property Name="WINDER_TENSION" Type="real" Nullable="false" /> + <Property Name="PROCESS_PARAMETERS_TABLES_GROUP_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="TABLE_INDEX" Type="integer" Nullable="false" /> + </EntityType> + <EntityType Name="PROCESS_PARAMETERS_TABLES_GROUPS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="RML_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="NAME" Type="varchar" MaxLength="50" Nullable="false" /> + <Property Name="ACTIVE" Type="bit" Nullable="false" /> + <Property Name="SAVE_DATE" Type="datetime" Nullable="false" /> </EntityType> <EntityType Name="RMLS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="MANUFACTURER" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="MATERIAL_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="COLOR_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="PURPOSE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="CONDITION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="LINEAR_MASS_DENSITY_UNIT_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="FIBER_SHAPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="FIBER_SYNTH_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="MANUFACTURER" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="CODE" Type="integer" Nullable="false" /> + <Property Name="MATERIAL_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="COLOR_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="PURPOSE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="CONDITION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LINEAR_MASS_DENSITY_UNIT_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="FIBER_SHAPE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="FIBER_SYNTH_GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="FIBER_SIZE" Type="real" Nullable="false" /> <Property Name="NUMBER_OF_FIBERS" Type="integer" Nullable="false" /> <Property Name="PLIES_PER_FIBER" Type="integer" Nullable="false" /> @@ -423,55 +525,94 @@ <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="CODE" Type="integer" Nullable="false" /> - <Property Name="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="30" Nullable="false" /> + <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="100" Nullable="false" /> </EntityType> <EntityType Name="ROLES_PERMISSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="ROLE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="PERMISSION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + </EntityType> + <EntityType Name="SEGMENTS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> - <Property Name="ROLE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="PERMISSION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="JOB_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LENGTH" Type="real" Nullable="false" /> + </EntityType> + <EntityType Name="SENSORS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="CODE" Type="integer" Nullable="false" /> + <Property Name="NAME" Type="varchar" MaxLength="100" Nullable="false" /> + <Property Name="DESCRIPTION" Type="varchar" MaxLength="100" Nullable="false" /> + <Property Name="MIN" Type="real" Nullable="false" /> + <Property Name="MAX" Type="real" Nullable="false" /> + <Property Name="UNITS" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="POINTS_PER_FRAME" Type="integer" Nullable="false" /> + <Property Name="MULTI_CHANNEL" Type="bit" Nullable="false" /> + <Property Name="CHANNEL_COUNT" Type="integer" Nullable="false" /> </EntityType> <EntityType Name="SYNC_CONFIGURATIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="TABLE_NAME" Type="varchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="TABLE_NAME" Type="varchar" MaxLength="100" Nullable="false" /> <Property Name="SYNC_TYPE" Type="integer" Nullable="false" /> </EntityType> <EntityType Name="USERS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> - <Property Name="EMAIL" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="PASSWORD" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="ORGANIZATION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="CONTACT_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="ADDRESS_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="EMAIL" Type="nvarchar" MaxLength="50" Nullable="false" /> + <Property Name="PASSWORD" Type="nvarchar" MaxLength="200" Nullable="false" /> + <Property Name="ORGANIZATION_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="CONTACT_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="ADDRESS_GUID" Type="varchar" MaxLength="36" Nullable="false" /> </EntityType> <EntityType Name="USERS_ROLES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="integer" Nullable="false" /> - <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> - <Property Name="USER_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> - <Property Name="ROLE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> + <Property Name="USER_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="ROLE_GUID" Type="varchar" MaxLength="36" Nullable="false" /> + </EntityType> + <EntityType Name="WINDING_METHODS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="CODE" Type="integer" Nullable="false" /> + <Property Name="NAME" Type="varchar" MaxLength="50" Nullable="false" /> + <Property Name="DESCRIPTION" Type="varchar" MaxLength="100" Nullable="false" /> </EntityType> <EntityContainer Name="LocalModelStoreContainer"> <EntitySet Name="ACTION_TYPES" EntityType="Self.ACTION_TYPES" store:Type="Tables" /> @@ -480,9 +621,11 @@ <EntitySet Name="APPLICATION_FIRMWARE_VERSIONS" EntityType="Self.APPLICATION_FIRMWARE_VERSIONS" store:Type="Tables" /> <EntitySet Name="APPLICATION_OS_VERSIONS" EntityType="Self.APPLICATION_OS_VERSIONS" store:Type="Tables" /> <EntitySet Name="APPLICATION_VERSIONS" EntityType="Self.APPLICATION_VERSIONS" store:Type="Tables" /> + <EntitySet Name="BRUSH_STOPS" EntityType="Self.BRUSH_STOPS" store:Type="Tables" /> <EntitySet Name="CARTRIDGE_TYPES" EntityType="Self.CARTRIDGE_TYPES" store:Type="Tables" /> <EntitySet Name="CATS" EntityType="Self.CATS" store:Type="Tables" /> <EntitySet Name="CCTS" EntityType="Self.CCTS" store:Type="Tables" /> + <EntitySet Name="COLOR_SPACES" EntityType="Self.COLOR_SPACES" store:Type="Tables" /> <EntitySet Name="CONFIGURATIONS" EntityType="Self.CONFIGURATIONS" store:Type="Tables" /> <EntitySet Name="CONTACTS" EntityType="Self.CONTACTS" store:Type="Tables" /> <EntitySet Name="DISPENSER_TYPES" EntityType="Self.DISPENSER_TYPES" store:Type="Tables" /> @@ -494,6 +637,8 @@ <EntitySet Name="FIBER_SYNTHS" EntityType="Self.FIBER_SYNTHS" store:Type="Tables" /> <EntitySet Name="HARDWARE_VERSIONS" EntityType="Self.HARDWARE_VERSIONS" store:Type="Tables" /> <EntitySet Name="IDS_PACKS" EntityType="Self.IDS_PACKS" store:Type="Tables" /> + <EntitySet Name="JOB_RUNS" EntityType="Self.JOB_RUNS" store:Type="Tables" /> + <EntitySet Name="JOBS" EntityType="Self.JOBS" store:Type="Tables" /> <EntitySet Name="LINEAR_MASS_DENSITY_UNITS" EntityType="Self.LINEAR_MASS_DENSITY_UNITS" store:Type="Tables" /> <EntitySet Name="LIQUID_TYPES" EntityType="Self.LIQUID_TYPES" store:Type="Tables" /> <EntitySet Name="LIQUID_TYPES_RMLS" EntityType="Self.LIQUID_TYPES_RMLS" store:Type="Tables" /> @@ -508,12 +653,17 @@ <EntitySet Name="MID_TANK_TYPES" EntityType="Self.MID_TANK_TYPES" store:Type="Tables" /> <EntitySet Name="ORGANIZATIONS" EntityType="Self.ORGANIZATIONS" store:Type="Tables" /> <EntitySet Name="PERMISSIONS" EntityType="Self.PERMISSIONS" store:Type="Tables" /> + <EntitySet Name="PROCESS_PARAMETERS_TABLES" EntityType="Self.PROCESS_PARAMETERS_TABLES" store:Type="Tables" /> + <EntitySet Name="PROCESS_PARAMETERS_TABLES_GROUPS" EntityType="Self.PROCESS_PARAMETERS_TABLES_GROUPS" store:Type="Tables" /> <EntitySet Name="RMLS" EntityType="Self.RMLS" store:Type="Tables" /> <EntitySet Name="ROLES" EntityType="Self.ROLES" store:Type="Tables" /> <EntitySet Name="ROLES_PERMISSIONS" EntityType="Self.ROLES_PERMISSIONS" store:Type="Tables" /> + <EntitySet Name="SEGMENTS" EntityType="Self.SEGMENTS" store:Type="Tables" /> + <EntitySet Name="SENSORS" EntityType="Self.SENSORS" store:Type="Tables" /> <EntitySet Name="SYNC_CONFIGURATIONS" EntityType="Self.SYNC_CONFIGURATIONS" store:Type="Tables" /> <EntitySet Name="USERS" EntityType="Self.USERS" store:Type="Tables" /> <EntitySet Name="USERS_ROLES" EntityType="Self.USERS_ROLES" store:Type="Tables" /> + <EntitySet Name="WINDING_METHODS" EntityType="Self.WINDING_METHODS" store:Type="Tables" /> </EntityContainer> </Schema></edmx:StorageModels> <!-- CSDL content --> @@ -526,9 +676,11 @@ <EntitySet Name="APPLICATION_FIRMWARE_VERSIONS" EntityType="LocalModel.APPLICATION_FIRMWARE_VERSIONS" /> <EntitySet Name="APPLICATION_OS_VERSIONS" EntityType="LocalModel.APPLICATION_OS_VERSIONS" /> <EntitySet Name="APPLICATION_VERSIONS" EntityType="LocalModel.APPLICATION_VERSIONS" /> + <EntitySet Name="BRUSH_STOPS" EntityType="LocalModel.BRUSH_STOPS" /> <EntitySet Name="CARTRIDGE_TYPES" EntityType="LocalModel.CARTRIDGE_TYPES" /> <EntitySet Name="CATS" EntityType="LocalModel.CAT" /> <EntitySet Name="CCTS" EntityType="LocalModel.CCT" /> + <EntitySet Name="COLOR_SPACES" EntityType="LocalModel.COLOR_SPACES" /> <EntitySet Name="CONFIGURATIONS" EntityType="LocalModel.CONFIGURATION" /> <EntitySet Name="CONTACTS" EntityType="LocalModel.CONTACT" /> <EntitySet Name="DISPENSER_TYPES" EntityType="LocalModel.DISPENSER_TYPES" /> @@ -540,6 +692,8 @@ <EntitySet Name="FIBER_SYNTHS" EntityType="LocalModel.FIBER_SYNTHS" /> <EntitySet Name="HARDWARE_VERSIONS" EntityType="LocalModel.HARDWARE_VERSIONS" /> <EntitySet Name="IDS_PACKS" EntityType="LocalModel.IDS_PACKS" /> + <EntitySet Name="JOB_RUNS" EntityType="LocalModel.JOB_RUNS" /> + <EntitySet Name="JOBS" EntityType="LocalModel.JOB" /> <EntitySet Name="LINEAR_MASS_DENSITY_UNITS" EntityType="LocalModel.LINEAR_MASS_DENSITY_UNITS" /> <EntitySet Name="LIQUID_TYPES" EntityType="LocalModel.LIQUID_TYPES" /> <EntitySet Name="LIQUID_TYPES_RMLS" EntityType="LocalModel.LIQUID_TYPES_RMLS" /> @@ -554,158 +708,197 @@ <EntitySet Name="MID_TANK_TYPES" EntityType="LocalModel.MID_TANK_TYPES" /> <EntitySet Name="ORGANIZATIONS" EntityType="LocalModel.ORGANIZATION" /> <EntitySet Name="PERMISSIONS" EntityType="LocalModel.PERMISSION" /> + <EntitySet Name="PROCESS_PARAMETERS_TABLES" EntityType="LocalModel.PROCESS_PARAMETERS_TABLES" /> + <EntitySet Name="PROCESS_PARAMETERS_TABLES_GROUPS" EntityType="LocalModel.PROCESS_PARAMETERS_TABLES_GROUPS" /> <EntitySet Name="RMLS" EntityType="LocalModel.RML" /> <EntitySet Name="ROLES" EntityType="LocalModel.ROLE" /> <EntitySet Name="ROLES_PERMISSIONS" EntityType="LocalModel.ROLES_PERMISSIONS" /> + <EntitySet Name="SEGMENTS" EntityType="LocalModel.SEGMENT" /> + <EntitySet Name="SENSORS" EntityType="LocalModel.SENSOR" /> <EntitySet Name="SYNC_CONFIGURATIONS" EntityType="LocalModel.SYNC_CONFIGURATIONS" /> <EntitySet Name="USERS" EntityType="LocalModel.USER" /> <EntitySet Name="USERS_ROLES" EntityType="LocalModel.USERS_ROLES" /> + <EntitySet Name="WINDING_METHODS" EntityType="LocalModel.WINDING_METHODS" /> </EntityContainer> <EntityType Name="ACTION_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="CODE" Type="Int64" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="ADDRESS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="ADDRESS_STRING" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="LOCALITY" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="COUNTRY" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="CITY" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="STATE" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="COUNTRY_CODE" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="POSTAL_CODE" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ADDRESS_STRING" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> + <Property Name="LOCALITY" Type="String" MaxLength="56" FixedLength="false" Unicode="true" /> + <Property Name="COUNTRY" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="CITY" Type="String" MaxLength="30" FixedLength="false" Unicode="true" /> + <Property Name="STATE" Type="String" MaxLength="30" FixedLength="false" Unicode="true" /> + <Property Name="COUNTRY_CODE" Type="String" MaxLength="2" FixedLength="false" Unicode="true" /> + <Property Name="POSTAL_CODE" Type="String" MaxLength="15" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="APPLICATION_DISPLAY_PANEL_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="VERSION" Type="Double" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="APPLICATION_FIRMWARE_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="VERSION" Type="Double" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="APPLICATION_OS_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="VERSION" Type="Double" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="APPLICATION_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="VERSION" Type="Double" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + </EntityType> + <EntityType Name="BRUSH_STOPS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> + <Property Name="SEGMENT_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="COLOR_SPACE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="OFFSET_PERCENT" Type="Double" Nullable="false" /> + <Property Name="CYAN" Type="Double" Nullable="false" /> + <Property Name="MAGENTA" Type="Double" Nullable="false" /> + <Property Name="YELLOW" Type="Double" Nullable="false" /> + <Property Name="BLACK" Type="Double" Nullable="false" /> + <Property Name="RED" Type="Int64" Nullable="false" /> + <Property Name="GREEN" Type="Int64" Nullable="false" /> + <Property Name="BLUE" Type="Int64" Nullable="false" /> + <Property Name="L" Type="Int64" Nullable="false" /> + <Property Name="A" Type="Int64" Nullable="false" /> + <Property Name="B" Type="Int64" Nullable="false" /> + <Property Name="PANTON_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" /> </EntityType> <EntityType Name="CARTRIDGE_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="CODE" Type="Int64" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="CAT"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> - <Property Name="LIQUID_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="MACHINE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="LIQUID_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="RML_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="DATA" Type="Binary" Nullable="false" MaxLength="2147483647" FixedLength="false" /> </EntityType> <EntityType Name="CCT"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="FORWARD_FILE_NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="INVERSE_FILE_NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> + <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="true" /> + <Property Name="FORWARD_FILE_NAME" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> + <Property Name="INVERSE_FILE_NAME" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> <Property Name="FORWARD_DATA" Type="Binary" Nullable="false" MaxLength="2147483647" FixedLength="false" /> <Property Name="INVERSE_DATA" Type="Binary" Nullable="false" MaxLength="2147483647" FixedLength="false" /> <Property Name="VERSION" Type="Double" Nullable="false" /> - <Property Name="RML_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="RML_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + </EntityType> + <EntityType Name="COLOR_SPACES"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> + <Property Name="CODE" Type="Int64" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" /> + <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" /> </EntityType> <EntityType Name="CONFIGURATION"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> - <Property Name="NAME" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="CREATION_DATE" Type="DateTime" Nullable="false" /> - <Property Name="APPLICATION_VERSION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="APPLICATION_OS_VERSION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="APPLICATION_FIRMWARE_VERSION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="EMBEDDED_FIRMWARE_VERSION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="EMBEDDED_SOFTWARE_VERSION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="HARDWARE_VERSION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="APPLICATION_VERSION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="APPLICATION_OS_VERSION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="APPLICATION_FIRMWARE_VERSION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="EMBEDDED_FIRMWARE_VERSION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="EMBEDDED_SOFTWARE_VERSION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="HARDWARE_VERSION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> </EntityType> <EntityType Name="CONTACT"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="FIRST_NAME" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="LAST_NAME" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="FULL_NAME" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="EMAIL" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="PHONE_NUMBER" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="FAX" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="FIRST_NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="LAST_NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="FULL_NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="EMAIL" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="PHONE_NUMBER" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="FAX" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="DISPENSER_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="CODE" Type="Int64" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="NL_PER_PULSE" Type="Double" Nullable="false" /> <Property Name="CAPACITY" Type="Double" Nullable="false" /> </EntityType> @@ -713,107 +906,136 @@ <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="VERSION" Type="Double" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="EMBEDDED_SOFTWARE_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="VERSION" Type="Double" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="EVENT_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="CODE" Type="Int64" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="EVENT_TYPES_ACTIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> - <Property Name="EVENT_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="ACTION_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="EVENT_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="ACTION_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> </EntityType> <EntityType Name="FIBER_SHAPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="CODE" Type="Int64" Nullable="false" /> </EntityType> <EntityType Name="FIBER_SYNTHS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="CODE" Type="Int64" Nullable="false" /> </EntityType> <EntityType Name="HARDWARE_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="VERSION" Type="Double" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="IDS_PACKS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> - <Property Name="CONFIGURATION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="DISPENSER_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="LIQUID_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="CARTRIDGE_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="MID_TANK_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="CONFIGURATION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="DISPENSER_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="LIQUID_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="CARTRIDGE_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="MID_TANK_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="PACK_INDEX" Type="Int64" Nullable="false" /> </EntityType> + <EntityType Name="JOB_RUNS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> + <Property Name="JOB_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="START_DATE" Type="DateTime" Nullable="false" /> + <Property Name="END_DATE" Type="DateTime" Nullable="false" /> + <Property Name="SUCCESSFUL" Type="Boolean" Nullable="false" /> + </EntityType> + <EntityType Name="JOB"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> + <Property Name="CREATION_DATE" Type="DateTime" Nullable="false" /> + <Property Name="MACHINE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="RML_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="WINDING_METHOD_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> + <Property Name="DESCRIPTION" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> + <Property Name="INTER_SEGMENT_LENGTH" Type="Double" Nullable="false" /> + <Property Name="ENABLE_INTER_SEGMENT" Type="Boolean" Nullable="false" /> + <Property Name="ENABLE_LUBRICATION" Type="Boolean" Nullable="false" /> + </EntityType> <EntityType Name="LINEAR_MASS_DENSITY_UNITS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="CODE" Type="Int64" Nullable="false" /> </EntityType> <EntityType Name="LIQUID_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="CODE" Type="Int64" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="VERSION" Type="Double" Nullable="false" /> <Property Name="COLOR" Type="Int64" Nullable="false" /> </EntityType> @@ -821,67 +1043,67 @@ <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> - <Property Name="LIQUID_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="RML_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="LIQUID_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="RML_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="MAX_NL_PER_CM" Type="Double" Nullable="false" /> </EntityType> <EntityType Name="MACHINE_VERSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="VERSION" Type="Double" Nullable="false" /> - <Property Name="DEFAULT_CONFIGURATION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="DEFAULT_CONFIGURATION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> </EntityType> <EntityType Name="MACHINE"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> - <Property Name="SERIAL_NUMBER" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="NAME" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="SERIAL_NUMBER" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" /> + <Property Name="NAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="PRODUCTION_DATE" Type="DateTime" Nullable="false" /> - <Property Name="ORGANIZATION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="MACHINE_VERSION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="CONFIGURATION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ORGANIZATION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="MACHINE_VERSION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="CONFIGURATION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> </EntityType> <EntityType Name="MACHINES_CONFIGURATIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> - <Property Name="MACHINE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="CONFIGURATION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="MACHINE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="CONFIGURATION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> </EntityType> <EntityType Name="MACHINES_EVENTS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> - <Property Name="MACHINE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="EVENT_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="USER_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="MACHINE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="EVENT_TYPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="USER_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="DATE_TIME" Type="DateTime" Nullable="false" /> - <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="DESCRIPTION" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="MEDIA_COLORS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="COLOR" Type="Int64" Nullable="false" /> </EntityType> @@ -889,81 +1111,120 @@ <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="CODE" Type="Int64" Nullable="false" /> </EntityType> <EntityType Name="MEDIA_MATERIALS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="CODE" Type="Int64" Nullable="false" /> </EntityType> <EntityType Name="MEDIA_PURPOSES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="CODE" Type="Int64" Nullable="false" /> </EntityType> <EntityType Name="MID_TANK_TYPES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="CODE" Type="Int64" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="LITER_CAPACITY" Type="Double" Nullable="false" /> </EntityType> <EntityType Name="ORGANIZATION"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="CONTACT_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="ADDRESS_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="CONTACT_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="ADDRESS_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> </EntityType> <EntityType Name="PERMISSION"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="CODE" Type="Int64" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="30" FixedLength="false" Unicode="true" /> + <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> + </EntityType> + <EntityType Name="PROCESS_PARAMETERS_TABLES"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="DYEING_SPEED" Type="Double" Nullable="false" /> + <Property Name="MIN_INK_UPTAKE" Type="Double" Nullable="false" /> + <Property Name="MIXER_TEMP" Type="Double" Nullable="false" /> + <Property Name="HEAD_ZONE1_TEMP" Type="Double" Nullable="false" /> + <Property Name="HEAD_ZONE2_TEMP" Type="Double" Nullable="false" /> + <Property Name="HEAD_ZONE3_TEMP" Type="Double" Nullable="false" /> + <Property Name="HEAD_AIR_FLOW" Type="Double" Nullable="false" /> + <Property Name="FEEDER_TENSION" Type="Double" Nullable="false" /> + <Property Name="PULLER_TENSION" Type="Double" Nullable="false" /> + <Property Name="DRYER_BUFFER_LENGTH" Type="Double" Nullable="false" /> + <Property Name="DRYER_ZONE1_TEMP" Type="Double" Nullable="false" /> + <Property Name="DRYER_ZONE2_TEMP" Type="Double" Nullable="false" /> + <Property Name="DRYER_ZONE3_TEMP" Type="Double" Nullable="false" /> + <Property Name="DRYER_AIR_FLOW" Type="Double" Nullable="false" /> + <Property Name="WINDER_TENSION" Type="Double" Nullable="false" /> + <Property Name="PROCESS_PARAMETERS_TABLES_GROUP_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="TABLE_INDEX" Type="Int64" Nullable="false" /> + </EntityType> + <EntityType Name="PROCESS_PARAMETERS_TABLES_GROUPS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> + <Property Name="RML_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" /> + <Property Name="ACTIVE" Type="Boolean" Nullable="false" /> + <Property Name="SAVE_DATE" Type="DateTime" Nullable="false" /> </EntityType> <EntityType Name="RML"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="MANUFACTURER" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="MATERIAL_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="COLOR_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="PURPOSE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="CONDITION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="LINEAR_MASS_DENSITY_UNIT_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="FIBER_SHAPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="FIBER_SYNTH_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="MANUFACTURER" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="CODE" Type="Int64" Nullable="false" /> + <Property Name="MATERIAL_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="COLOR_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="PURPOSE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="CONDITION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="LINEAR_MASS_DENSITY_UNIT_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="FIBER_SHAPE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="FIBER_SYNTH_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="FIBER_SIZE" Type="Double" Nullable="false" /> <Property Name="NUMBER_OF_FIBERS" Type="Int64" Nullable="false" /> <Property Name="PLIES_PER_FIBER" Type="Int64" Nullable="false" /> @@ -979,55 +1240,94 @@ <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="CODE" Type="Int64" Nullable="false" /> - <Property Name="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="30" FixedLength="false" Unicode="true" /> + <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="ROLES_PERMISSIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> + <Property Name="ROLE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="PERMISSION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + </EntityType> + <EntityType Name="SEGMENT"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="JOB_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="LENGTH" Type="Double" Nullable="false" /> + </EntityType> + <EntityType Name="SENSOR"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> - <Property Name="ROLE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="PERMISSION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="CODE" Type="Int64" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" /> + <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" /> + <Property Name="MIN" Type="Double" Nullable="false" /> + <Property Name="MAX" Type="Double" Nullable="false" /> + <Property Name="UNITS" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="POINTS_PER_FRAME" Type="Int64" Nullable="false" /> + <Property Name="MULTI_CHANNEL" Type="Boolean" Nullable="false" /> + <Property Name="CHANNEL_COUNT" Type="Int64" Nullable="false" /> </EntityType> <EntityType Name="SYNC_CONFIGURATIONS"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="TABLE_NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="false" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="TABLE_NAME" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="SYNC_TYPE" Type="Int64" Nullable="false" /> </EntityType> <EntityType Name="USER"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="EMAIL" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="PASSWORD" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="ORGANIZATION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="CONTACT_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="ADDRESS_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="EMAIL" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" /> + <Property Name="PASSWORD" Type="String" Nullable="false" MaxLength="200" FixedLength="false" Unicode="true" /> + <Property Name="ORGANIZATION_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="CONTACT_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="ADDRESS_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> </EntityType> <EntityType Name="USERS_ROLES"> <Key> <PropertyRef Name="ID" /> </Key> - <Property Name="ID" Type="Int64" Nullable="false" /> - <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="USER_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> - <Property Name="ROLE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <Property Name="USER_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="ROLE_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + </EntityType> + <EntityType Name="WINDING_METHODS"> + <Key> + <PropertyRef Name="ID" /> + </Key> + <Property Name="ID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> + <Property Name="CODE" Type="Int64" Nullable="false" /> + <Property Name="NAME" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" /> + <Property Name="DESCRIPTION" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" /> </EntityType> </Schema> </edmx:ConceptualModels> @@ -1108,6 +1408,29 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> + <EntitySetMapping Name="BRUSH_STOPS"> + <EntityTypeMapping TypeName="LocalModel.BRUSH_STOPS"> + <MappingFragment StoreEntitySet="BRUSH_STOPS"> + <ScalarProperty Name="PANTON_GUID" ColumnName="PANTON_GUID" /> + <ScalarProperty Name="B" ColumnName="B" /> + <ScalarProperty Name="A" ColumnName="A" /> + <ScalarProperty Name="L" ColumnName="L" /> + <ScalarProperty Name="BLUE" ColumnName="BLUE" /> + <ScalarProperty Name="GREEN" ColumnName="GREEN" /> + <ScalarProperty Name="RED" ColumnName="RED" /> + <ScalarProperty Name="BLACK" ColumnName="BLACK" /> + <ScalarProperty Name="YELLOW" ColumnName="YELLOW" /> + <ScalarProperty Name="MAGENTA" ColumnName="MAGENTA" /> + <ScalarProperty Name="CYAN" ColumnName="CYAN" /> + <ScalarProperty Name="OFFSET_PERCENT" ColumnName="OFFSET_PERCENT" /> + <ScalarProperty Name="COLOR_SPACE_GUID" ColumnName="COLOR_SPACE_GUID" /> + <ScalarProperty Name="SEGMENT_GUID" ColumnName="SEGMENT_GUID" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> + </MappingFragment> + </EntityTypeMapping> + </EntitySetMapping> <EntitySetMapping Name="CARTRIDGE_TYPES"> <EntityTypeMapping TypeName="LocalModel.CARTRIDGE_TYPES"> <MappingFragment StoreEntitySet="CARTRIDGE_TYPES"> @@ -1123,8 +1446,9 @@ <EntityTypeMapping TypeName="LocalModel.CAT"> <MappingFragment StoreEntitySet="CATS"> <ScalarProperty Name="DATA" ColumnName="DATA" /> - <ScalarProperty Name="MACHINE_GUID" ColumnName="MACHINE_GUID" /> + <ScalarProperty Name="RML_GUID" ColumnName="RML_GUID" /> <ScalarProperty Name="LIQUID_TYPE_GUID" ColumnName="LIQUID_TYPE_GUID" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="GUID" ColumnName="GUID" /> <ScalarProperty Name="ID" ColumnName="ID" /> @@ -1148,6 +1472,18 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> + <EntitySetMapping Name="COLOR_SPACES"> + <EntityTypeMapping TypeName="LocalModel.COLOR_SPACES"> + <MappingFragment StoreEntitySet="COLOR_SPACES"> + <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="CODE" ColumnName="CODE" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> + </MappingFragment> + </EntityTypeMapping> + </EntitySetMapping> <EntitySetMapping Name="CONFIGURATIONS"> <EntityTypeMapping TypeName="LocalModel.CONFIGURATION"> <MappingFragment StoreEntitySet="CONFIGURATIONS"> @@ -1289,6 +1625,37 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> + <EntitySetMapping Name="JOB_RUNS"> + <EntityTypeMapping TypeName="LocalModel.JOB_RUNS"> + <MappingFragment StoreEntitySet="JOB_RUNS"> + <ScalarProperty Name="SUCCESSFUL" ColumnName="SUCCESSFUL" /> + <ScalarProperty Name="END_DATE" ColumnName="END_DATE" /> + <ScalarProperty Name="START_DATE" ColumnName="START_DATE" /> + <ScalarProperty Name="JOB_GUID" ColumnName="JOB_GUID" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> + </MappingFragment> + </EntityTypeMapping> + </EntitySetMapping> + <EntitySetMapping Name="JOBS"> + <EntityTypeMapping TypeName="LocalModel.JOB"> + <MappingFragment StoreEntitySet="JOBS"> + <ScalarProperty Name="ENABLE_LUBRICATION" ColumnName="ENABLE_LUBRICATION" /> + <ScalarProperty Name="ENABLE_INTER_SEGMENT" ColumnName="ENABLE_INTER_SEGMENT" /> + <ScalarProperty Name="INTER_SEGMENT_LENGTH" ColumnName="INTER_SEGMENT_LENGTH" /> + <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="WINDING_METHOD_GUID" ColumnName="WINDING_METHOD_GUID" /> + <ScalarProperty Name="RML_GUID" ColumnName="RML_GUID" /> + <ScalarProperty Name="MACHINE_GUID" ColumnName="MACHINE_GUID" /> + <ScalarProperty Name="CREATION_DATE" ColumnName="CREATION_DATE" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> + </MappingFragment> + </EntityTypeMapping> + </EntitySetMapping> <EntitySetMapping Name="LINEAR_MASS_DENSITY_UNITS"> <EntityTypeMapping TypeName="LocalModel.LINEAR_MASS_DENSITY_UNITS"> <MappingFragment StoreEntitySet="LINEAR_MASS_DENSITY_UNITS"> @@ -1329,8 +1696,8 @@ <EntityTypeMapping TypeName="LocalModel.MACHINE_VERSIONS"> <MappingFragment StoreEntitySet="MACHINE_VERSIONS"> <ScalarProperty Name="DEFAULT_CONFIGURATION_GUID" ColumnName="DEFAULT_CONFIGURATION_GUID" /> - <ScalarProperty Name="VERSION" ColumnName="VERSION" /> <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="VERSION" ColumnName="VERSION" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="GUID" ColumnName="GUID" /> <ScalarProperty Name="ID" ColumnName="ID" /> @@ -1456,6 +1823,46 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> + <EntitySetMapping Name="PROCESS_PARAMETERS_TABLES"> + <EntityTypeMapping TypeName="LocalModel.PROCESS_PARAMETERS_TABLES"> + <MappingFragment StoreEntitySet="PROCESS_PARAMETERS_TABLES"> + <ScalarProperty Name="TABLE_INDEX" ColumnName="TABLE_INDEX" /> + <ScalarProperty Name="PROCESS_PARAMETERS_TABLES_GROUP_GUID" ColumnName="PROCESS_PARAMETERS_TABLES_GROUP_GUID" /> + <ScalarProperty Name="WINDER_TENSION" ColumnName="WINDER_TENSION" /> + <ScalarProperty Name="DRYER_AIR_FLOW" ColumnName="DRYER_AIR_FLOW" /> + <ScalarProperty Name="DRYER_ZONE3_TEMP" ColumnName="DRYER_ZONE3_TEMP" /> + <ScalarProperty Name="DRYER_ZONE2_TEMP" ColumnName="DRYER_ZONE2_TEMP" /> + <ScalarProperty Name="DRYER_ZONE1_TEMP" ColumnName="DRYER_ZONE1_TEMP" /> + <ScalarProperty Name="DRYER_BUFFER_LENGTH" ColumnName="DRYER_BUFFER_LENGTH" /> + <ScalarProperty Name="PULLER_TENSION" ColumnName="PULLER_TENSION" /> + <ScalarProperty Name="FEEDER_TENSION" ColumnName="FEEDER_TENSION" /> + <ScalarProperty Name="HEAD_AIR_FLOW" ColumnName="HEAD_AIR_FLOW" /> + <ScalarProperty Name="HEAD_ZONE3_TEMP" ColumnName="HEAD_ZONE3_TEMP" /> + <ScalarProperty Name="HEAD_ZONE2_TEMP" ColumnName="HEAD_ZONE2_TEMP" /> + <ScalarProperty Name="HEAD_ZONE1_TEMP" ColumnName="HEAD_ZONE1_TEMP" /> + <ScalarProperty Name="MIXER_TEMP" ColumnName="MIXER_TEMP" /> + <ScalarProperty Name="MIN_INK_UPTAKE" ColumnName="MIN_INK_UPTAKE" /> + <ScalarProperty Name="DYEING_SPEED" ColumnName="DYEING_SPEED" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> + </MappingFragment> + </EntityTypeMapping> + </EntitySetMapping> + <EntitySetMapping Name="PROCESS_PARAMETERS_TABLES_GROUPS"> + <EntityTypeMapping TypeName="LocalModel.PROCESS_PARAMETERS_TABLES_GROUPS"> + <MappingFragment StoreEntitySet="PROCESS_PARAMETERS_TABLES_GROUPS"> + <ScalarProperty Name="SAVE_DATE" ColumnName="SAVE_DATE" /> + <ScalarProperty Name="ACTIVE" ColumnName="ACTIVE" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="RML_GUID" ColumnName="RML_GUID" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> + </MappingFragment> + </EntityTypeMapping> + </EntitySetMapping> <EntitySetMapping Name="RMLS"> <EntityTypeMapping TypeName="LocalModel.RML"> <MappingFragment StoreEntitySet="RMLS"> @@ -1476,6 +1883,7 @@ <ScalarProperty Name="PURPOSE_GUID" ColumnName="PURPOSE_GUID" /> <ScalarProperty Name="COLOR_GUID" ColumnName="COLOR_GUID" /> <ScalarProperty Name="MATERIAL_GUID" ColumnName="MATERIAL_GUID" /> + <ScalarProperty Name="CODE" ColumnName="CODE" /> <ScalarProperty Name="MANUFACTURER" ColumnName="MANUFACTURER" /> <ScalarProperty Name="NAME" ColumnName="NAME" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> @@ -1507,6 +1915,36 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> + <EntitySetMapping Name="SEGMENTS"> + <EntityTypeMapping TypeName="LocalModel.SEGMENT"> + <MappingFragment StoreEntitySet="SEGMENTS"> + <ScalarProperty Name="LENGTH" ColumnName="LENGTH" /> + <ScalarProperty Name="JOB_GUID" ColumnName="JOB_GUID" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> + </MappingFragment> + </EntityTypeMapping> + </EntitySetMapping> + <EntitySetMapping Name="SENSORS"> + <EntityTypeMapping TypeName="LocalModel.SENSOR"> + <MappingFragment StoreEntitySet="SENSORS"> + <ScalarProperty Name="CHANNEL_COUNT" ColumnName="CHANNEL_COUNT" /> + <ScalarProperty Name="MULTI_CHANNEL" ColumnName="MULTI_CHANNEL" /> + <ScalarProperty Name="POINTS_PER_FRAME" ColumnName="POINTS_PER_FRAME" /> + <ScalarProperty Name="UNITS" ColumnName="UNITS" /> + <ScalarProperty Name="MAX" ColumnName="MAX" /> + <ScalarProperty Name="MIN" ColumnName="MIN" /> + <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="CODE" ColumnName="CODE" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> + </MappingFragment> + </EntityTypeMapping> + </EntitySetMapping> <EntitySetMapping Name="SYNC_CONFIGURATIONS"> <EntityTypeMapping TypeName="LocalModel.SYNC_CONFIGURATIONS"> <MappingFragment StoreEntitySet="SYNC_CONFIGURATIONS"> @@ -1543,6 +1981,18 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> + <EntitySetMapping Name="WINDING_METHODS"> + <EntityTypeMapping TypeName="LocalModel.WINDING_METHODS"> + <MappingFragment StoreEntitySet="WINDING_METHODS"> + <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="CODE" ColumnName="CODE" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> + </MappingFragment> + </EntityTypeMapping> + </EntitySetMapping> </EntityContainerMapping> </Mapping> </edmx:Mappings> |