diff options
Diffstat (limited to 'Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx')
| -rw-r--r-- | Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx | 152 |
1 files changed, 152 insertions, 0 deletions
diff --git a/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx b/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx index b9dccd261..d52f40cab 100644 --- a/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx +++ b/Software/Visual_Studio/Tango.DAL.Remote/DB/RemoteADO.edmx @@ -456,6 +456,18 @@ <Property Name="COMMENTS" Type="nvarchar(max)" Nullable="false" /> <Property Name="USER_GUID" Type="varchar" MaxLength="36" Nullable="false" /> </EntityType> + <EntityType Name="GBDS"> + <Key> + <PropertyRef Name="GUID" /> + </Key> + <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="100" /> + <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="200" /> + <Property Name="FILE_NAME" Type="nvarchar" MaxLength="100" /> + <Property Name="DATA" Type="image" /> + </EntityType> <EntityType Name="GLOBAL_DATA_STORE_ITEMS"> <Key> <PropertyRef Name="GUID" /> @@ -854,6 +866,18 @@ <Property Name="MAX_NL_PER_CM" Type="float" Nullable="false" /> <Property Name="DEFAULT_CAT_DATA" Type="image" /> </EntityType> + <EntityType Name="LUBS"> + <Key> + <PropertyRef Name="GUID" /> + </Key> + <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> + <Property Name="GUID" Type="varchar" MaxLength="36" Nullable="false" /> + <Property Name="LAST_UPDATED" Type="datetime2" Precision="3" Nullable="false" /> + <Property Name="NAME" Type="nvarchar" MaxLength="100" /> + <Property Name="DESCRIPTION" Type="nvarchar" MaxLength="200" /> + <Property Name="FILE_NAME" Type="nvarchar" MaxLength="100" /> + <Property Name="DATA" Type="image" /> + </EntityType> <EntityType Name="MACHINE_PROTOTYPES"> <Key> <PropertyRef Name="GUID" /> @@ -1280,6 +1304,8 @@ <Property Name="RANK" Type="int" Nullable="false" /> <Property Name="THUMBNAIL" Type="image" /> <Property Name="CCT_GUID" Type="varchar" MaxLength="36" /> + <Property Name="GBD_GUID" Type="varchar" MaxLength="36" /> + <Property Name="LUB_GUID" Type="varchar" MaxLength="36" /> <Property Name="COLOR_CONVERSION_VERSION" Type="int" Nullable="false" /> <Property Name="USE_COLOR_LIB_GRADIENTS" Type="bit" Nullable="false" /> <Property Name="USE_LIGHT_INKS" Type="bit" Nullable="false" /> @@ -3162,6 +3188,30 @@ </Dependent> </ReferentialConstraint> </Association> + <Association Name="FK_RMLS_GBDS"> + <End Role="GBDS" Type="Self.GBDS" Multiplicity="0..1" /> + <End Role="RMLS" Type="Self.RMLS" Multiplicity="*" /> + <ReferentialConstraint> + <Principal Role="GBDS"> + <PropertyRef Name="GUID" /> + </Principal> + <Dependent Role="RMLS"> + <PropertyRef Name="GBD_GUID" /> + </Dependent> + </ReferentialConstraint> + </Association> + <Association Name="FK_RMLS_LUBS"> + <End Role="LUBS" Type="Self.LUBS" Multiplicity="0..1" /> + <End Role="RMLS" Type="Self.RMLS" Multiplicity="*" /> + <ReferentialConstraint> + <Principal Role="LUBS"> + <PropertyRef Name="GUID" /> + </Principal> + <Dependent Role="RMLS"> + <PropertyRef Name="LUB_GUID" /> + </Dependent> + </ReferentialConstraint> + </Association> <Association Name="FK_RMLS_SPOOLS_RMLS"> <End Role="RMLS" Type="Self.RMLS" Multiplicity="1"> <OnDelete Action="Cascade" /> @@ -3531,6 +3581,7 @@ <EntitySet Name="FIBER_SHAPES" EntityType="Self.FIBER_SHAPES" Schema="dbo" store:Type="Tables" /> <EntitySet Name="FIBER_SYNTHS" EntityType="Self.FIBER_SYNTHS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="FSE_VERSIONS" EntityType="Self.FSE_VERSIONS" Schema="dbo" store:Type="Tables" /> + <EntitySet Name="GBDS" EntityType="Self.GBDS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="GLOBAL_DATA_STORE_ITEMS" EntityType="Self.GLOBAL_DATA_STORE_ITEMS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="HARDWARE_BLOWER_TYPES" EntityType="Self.HARDWARE_BLOWER_TYPES" Schema="dbo" store:Type="Tables" /> <EntitySet Name="HARDWARE_BLOWERS" EntityType="Self.HARDWARE_BLOWERS" Schema="dbo" store:Type="Tables" /> @@ -3554,6 +3605,7 @@ <EntitySet Name="LINEAR_MASS_DENSITY_UNITS" EntityType="Self.LINEAR_MASS_DENSITY_UNITS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="LIQUID_TYPES" EntityType="Self.LIQUID_TYPES" Schema="dbo" store:Type="Tables" /> <EntitySet Name="LIQUID_TYPES_RMLS" EntityType="Self.LIQUID_TYPES_RMLS" Schema="dbo" store:Type="Tables" /> + <EntitySet Name="LUBS" EntityType="Self.LUBS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="MACHINE_PROTOTYPES" EntityType="Self.MACHINE_PROTOTYPES" Schema="dbo" store:Type="Tables" /> <EntitySet Name="MACHINE_STUDIO_VERSIONS" EntityType="Self.MACHINE_STUDIO_VERSIONS" Schema="dbo" store:Type="Tables" /> <EntitySet Name="MACHINE_VERSIONS" EntityType="Self.MACHINE_VERSIONS" Schema="dbo" store:Type="Tables" /> @@ -4039,6 +4091,14 @@ <End Role="YARN_WHITE_SHADES" EntitySet="YARN_WHITE_SHADES" /> <End Role="RMLS_EXTENSIONS" EntitySet="RMLS_EXTENSIONS" /> </AssociationSet> + <AssociationSet Name="FK_RMLS_GBDS" Association="Self.FK_RMLS_GBDS"> + <End Role="GBDS" EntitySet="GBDS" /> + <End Role="RMLS" EntitySet="RMLS" /> + </AssociationSet> + <AssociationSet Name="FK_RMLS_LUBS" Association="Self.FK_RMLS_LUBS"> + <End Role="LUBS" EntitySet="LUBS" /> + <End Role="RMLS" EntitySet="RMLS" /> + </AssociationSet> <AssociationSet Name="FK_RMLS_SPOOLS_RMLS" Association="Self.FK_RMLS_SPOOLS_RMLS"> <End Role="RMLS" EntitySet="RMLS" /> <End Role="RMLS_SPOOLS" EntitySet="RMLS_SPOOLS" /> @@ -4292,6 +4352,7 @@ <EntitySet Name="FIBER_SHAPES" EntityType="RemoteModel.FIBER_SHAPES" /> <EntitySet Name="FIBER_SYNTHS" EntityType="RemoteModel.FIBER_SYNTHS" /> <EntitySet Name="FSE_VERSIONS" EntityType="RemoteModel.FSE_VERSIONS" /> + <EntitySet Name="GBDS" EntityType="RemoteModel.GBD" /> <EntitySet Name="GLOBAL_DATA_STORE_ITEMS" EntityType="RemoteModel.GLOBAL_DATA_STORE_ITEMS" /> <EntitySet Name="HARDWARE_BLOWER_TYPES" EntityType="RemoteModel.HARDWARE_BLOWER_TYPES" /> <EntitySet Name="HARDWARE_BLOWERS" EntityType="RemoteModel.HARDWARE_BLOWERS" /> @@ -4315,6 +4376,7 @@ <EntitySet Name="LINEAR_MASS_DENSITY_UNITS" EntityType="RemoteModel.LINEAR_MASS_DENSITY_UNITS" /> <EntitySet Name="LIQUID_TYPES" EntityType="RemoteModel.LIQUID_TYPES" /> <EntitySet Name="LIQUID_TYPES_RMLS" EntityType="RemoteModel.LIQUID_TYPES_RMLS" /> + <EntitySet Name="LUBS" EntityType="RemoteModel.LUB" /> <EntitySet Name="MACHINE_PROTOTYPES" EntityType="RemoteModel.MACHINE_PROTOTYPES" /> <EntitySet Name="MACHINE_STUDIO_VERSIONS" EntityType="RemoteModel.MACHINE_STUDIO_VERSIONS" /> <EntitySet Name="MACHINE_VERSIONS" EntityType="RemoteModel.MACHINE_VERSIONS" /> @@ -4529,6 +4591,10 @@ <End Role="USER" EntitySet="USERS" /> <End Role="FSE_VERSIONS" EntitySet="FSE_VERSIONS" /> </AssociationSet> + <AssociationSet Name="FK_RMLS_GBDS" Association="RemoteModel.FK_RMLS_GBDS"> + <End Role="GBD" EntitySet="GBDS" /> + <End Role="RML" EntitySet="RMLS" /> + </AssociationSet> <AssociationSet Name="FK_HARDWARE_BLOWERS_HARDWARE_BLOWER_TYPES" Association="RemoteModel.FK_HARDWARE_BLOWERS_HARDWARE_BLOWER_TYPES"> <End Role="HARDWARE_BLOWER_TYPES" EntitySet="HARDWARE_BLOWER_TYPES" /> <End Role="HARDWARE_BLOWERS" EntitySet="HARDWARE_BLOWERS" /> @@ -4641,6 +4707,10 @@ <End Role="RML" EntitySet="RMLS" /> <End Role="LIQUID_TYPES_RMLS" EntitySet="LIQUID_TYPES_RMLS" /> </AssociationSet> + <AssociationSet Name="FK_RMLS_LUBS" Association="RemoteModel.FK_RMLS_LUBS"> + <End Role="LUB" EntitySet="LUBS" /> + <End Role="RML" EntitySet="RMLS" /> + </AssociationSet> <AssociationSet Name="FK_MACHINE_STUDIO_VERSIONS_USERS" Association="RemoteModel.FK_MACHINE_STUDIO_VERSIONS_USERS"> <End Role="USER" EntitySet="USERS" /> <End Role="MACHINE_STUDIO_VERSIONS" EntitySet="MACHINE_STUDIO_VERSIONS" /> @@ -5949,6 +6019,19 @@ <Property Name="USER_GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> <NavigationProperty Name="USER" Relationship="RemoteModel.FK_FSE_VERSIONS_USERS" FromRole="FSE_VERSIONS" ToRole="USER" /> </EntityType> + <EntityType Name="GBD"> + <Key> + <PropertyRef Name="GUID" /> + </Key> + <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> + <Property Name="NAME" Type="String" MaxLength="100" FixedLength="false" Unicode="true" /> + <Property Name="DESCRIPTION" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> + <Property Name="FILE_NAME" Type="String" MaxLength="100" FixedLength="false" Unicode="true" /> + <Property Name="DATA" Type="Binary" MaxLength="Max" FixedLength="false" /> + <NavigationProperty Name="RMLS" Relationship="RemoteModel.FK_RMLS_GBDS" FromRole="GBD" ToRole="RML" /> + </EntityType> <EntityType Name="GLOBAL_DATA_STORE_ITEMS"> <Key> <PropertyRef Name="GUID" /> @@ -6400,6 +6483,19 @@ <NavigationProperty Name="LIQUID_TYPES" Relationship="RemoteModel.FK_LIQUID_TYPES_RMLS_LIQUID_TYPES" FromRole="LIQUID_TYPES_RMLS" ToRole="LIQUID_TYPES" /> <NavigationProperty Name="RML" Relationship="RemoteModel.FK_LIQUID_TYPES_RMLS_RMLS" FromRole="LIQUID_TYPES_RMLS" ToRole="RML" /> </EntityType> + <EntityType Name="LUB"> + <Key> + <PropertyRef Name="GUID" /> + </Key> + <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> + <Property Name="GUID" Type="String" Nullable="false" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" Precision="3" /> + <Property Name="NAME" Type="String" MaxLength="100" FixedLength="false" Unicode="true" /> + <Property Name="DESCRIPTION" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> + <Property Name="FILE_NAME" Type="String" MaxLength="100" FixedLength="false" Unicode="true" /> + <Property Name="DATA" Type="Binary" MaxLength="Max" FixedLength="false" /> + <NavigationProperty Name="RMLS" Relationship="RemoteModel.FK_RMLS_LUBS" FromRole="LUB" ToRole="RML" /> + </EntityType> <EntityType Name="MACHINE_PROTOTYPES"> <Key> <PropertyRef Name="GUID" /> @@ -6722,6 +6818,8 @@ <Property Name="RANK" Type="Int32" Nullable="false" /> <Property Name="THUMBNAIL" Type="Binary" MaxLength="Max" FixedLength="false" /> <Property Name="CCT_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="GBD_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" /> + <Property Name="LUB_GUID" Type="String" MaxLength="36" FixedLength="false" Unicode="false" /> <Property Name="COLOR_CONVERSION_VERSION" Type="Int32" Nullable="false" /> <Property Name="USE_COLOR_LIB_GRADIENTS" Type="Boolean" Nullable="false" /> <Property Name="USE_LIGHT_INKS" Type="Boolean" Nullable="false" /> @@ -6752,9 +6850,11 @@ <NavigationProperty Name="COLOR_CATALOGS_ITEMS_RECIPES" Relationship="RemoteModel.FK_COLOR_CATALOGS_ITEMS_RECIPES_RMLS" FromRole="RML" ToRole="COLOR_CATALOGS_ITEMS_RECIPES" /> <NavigationProperty Name="FIBER_SHAPES" Relationship="RemoteModel.FK_RML_FIBER_SHAPES" FromRole="RML" ToRole="FIBER_SHAPES" /> <NavigationProperty Name="FIBER_SYNTHS" Relationship="RemoteModel.FK_RML_FIBER_SYNTHESIS" FromRole="RML" ToRole="FIBER_SYNTHS" /> + <NavigationProperty Name="GBD" Relationship="RemoteModel.FK_RMLS_GBDS" FromRole="RML" ToRole="GBD" /> <NavigationProperty Name="JOBS" Relationship="RemoteModel.FK_JOBS_RMLS" FromRole="RML" ToRole="JOB" /> <NavigationProperty Name="LINEAR_MASS_DENSITY_UNITS" Relationship="RemoteModel.FK_RML_LINEAR_MASS_DENSITY_UNITS" FromRole="RML" ToRole="LINEAR_MASS_DENSITY_UNITS" /> <NavigationProperty Name="LIQUID_TYPES_RMLS" Relationship="RemoteModel.FK_LIQUID_TYPES_RMLS_RMLS" FromRole="RML" ToRole="LIQUID_TYPES_RMLS" /> + <NavigationProperty Name="LUB" Relationship="RemoteModel.FK_RMLS_LUBS" FromRole="RML" ToRole="LUB" /> <NavigationProperty Name="MEDIA_CONDITIONS" Relationship="RemoteModel.FK_RML_MEDIA_CONDITIONS" FromRole="RML" ToRole="MEDIA_CONDITIONS" /> <NavigationProperty Name="MEDIA_MATERIALS" Relationship="RemoteModel.FK_RML_MEDIA_MATERIALS" FromRole="RML" ToRole="MEDIA_MATERIALS" /> <NavigationProperty Name="MEDIA_PURPOSES" Relationship="RemoteModel.FK_RML_MEDIA_PURPOSES" FromRole="RML" ToRole="MEDIA_PURPOSES" /> @@ -7685,6 +7785,18 @@ </Dependent> </ReferentialConstraint> </Association> + <Association Name="FK_RMLS_GBDS"> + <End Type="RemoteModel.GBD" Role="GBD" Multiplicity="0..1" /> + <End Type="RemoteModel.RML" Role="RML" Multiplicity="*" /> + <ReferentialConstraint> + <Principal Role="GBD"> + <PropertyRef Name="GUID" /> + </Principal> + <Dependent Role="RML"> + <PropertyRef Name="GBD_GUID" /> + </Dependent> + </ReferentialConstraint> + </Association> <Association Name="FK_HARDWARE_BLOWERS_HARDWARE_BLOWER_TYPES"> <End Type="RemoteModel.HARDWARE_BLOWER_TYPES" Role="HARDWARE_BLOWER_TYPES" Multiplicity="1"> <OnDelete Action="Cascade" /> @@ -8057,6 +8169,18 @@ </Dependent> </ReferentialConstraint> </Association> + <Association Name="FK_RMLS_LUBS"> + <End Type="RemoteModel.LUB" Role="LUB" Multiplicity="0..1" /> + <End Type="RemoteModel.RML" Role="RML" Multiplicity="*" /> + <ReferentialConstraint> + <Principal Role="LUB"> + <PropertyRef Name="GUID" /> + </Principal> + <Dependent Role="RML"> + <PropertyRef Name="LUB_GUID" /> + </Dependent> + </ReferentialConstraint> + </Association> <Association Name="FK_MACHINE_STUDIO_VERSIONS_USERS"> <End Type="RemoteModel.USER" Role="USER" Multiplicity="1" /> <End Type="RemoteModel.MACHINE_STUDIO_VERSIONS" Role="MACHINE_STUDIO_VERSIONS" Multiplicity="*" /> @@ -9351,6 +9475,19 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> + <EntitySetMapping Name="GBDS"> + <EntityTypeMapping TypeName="RemoteModel.GBD"> + <MappingFragment StoreEntitySet="GBDS"> + <ScalarProperty Name="DATA" ColumnName="DATA" /> + <ScalarProperty Name="FILE_NAME" ColumnName="FILE_NAME" /> + <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> + </MappingFragment> + </EntityTypeMapping> + </EntitySetMapping> <EntitySetMapping Name="GLOBAL_DATA_STORE_ITEMS"> <EntityTypeMapping TypeName="RemoteModel.GLOBAL_DATA_STORE_ITEMS"> <MappingFragment StoreEntitySet="GLOBAL_DATA_STORE_ITEMS"> @@ -9772,6 +9909,19 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> + <EntitySetMapping Name="LUBS"> + <EntityTypeMapping TypeName="RemoteModel.LUB"> + <MappingFragment StoreEntitySet="LUBS"> + <ScalarProperty Name="DATA" ColumnName="DATA" /> + <ScalarProperty Name="FILE_NAME" ColumnName="FILE_NAME" /> + <ScalarProperty Name="DESCRIPTION" ColumnName="DESCRIPTION" /> + <ScalarProperty Name="NAME" ColumnName="NAME" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> + </MappingFragment> + </EntityTypeMapping> + </EntitySetMapping> <EntitySetMapping Name="MACHINE_PROTOTYPES"> <EntityTypeMapping TypeName="RemoteModel.MACHINE_PROTOTYPES"> <MappingFragment StoreEntitySet="MACHINE_PROTOTYPES"> @@ -10067,6 +10217,8 @@ <ScalarProperty Name="USE_LIGHT_INKS" ColumnName="USE_LIGHT_INKS" /> <ScalarProperty Name="USE_COLOR_LIB_GRADIENTS" ColumnName="USE_COLOR_LIB_GRADIENTS" /> <ScalarProperty Name="COLOR_CONVERSION_VERSION" ColumnName="COLOR_CONVERSION_VERSION" /> + <ScalarProperty Name="LUB_GUID" ColumnName="LUB_GUID" /> + <ScalarProperty Name="GBD_GUID" ColumnName="GBD_GUID" /> <ScalarProperty Name="CCT_GUID" ColumnName="CCT_GUID" /> <ScalarProperty Name="THUMBNAIL" ColumnName="THUMBNAIL" /> <ScalarProperty Name="RANK" ColumnName="RANK" /> |