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 | 72 |
1 files changed, 69 insertions, 3 deletions
diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx index 1bd77ac1d..67e38b06d 100644 --- a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx +++ b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx @@ -25,7 +25,7 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> - <Property Name="ADDRESS" Type="nvarchar" MaxLength="2147483647" 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" /> @@ -69,6 +69,15 @@ <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> </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="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="DELETED" Type="bit" Nullable="false" /> + </EntityType> <EntityType Name="CARTRIDGES"> <Key> <PropertyRef Name="ID" /> @@ -77,6 +86,7 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="CARTRIDGE_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> </EntityType> <EntityType Name="CONFIGURATIONS"> <Key> @@ -123,6 +133,15 @@ <Property Name="PHONE_NUMBER" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="FAX" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> </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="LAST_UPDATED" Type="datetime" Nullable="false" /> + <Property Name="DELETED" Type="bit" Nullable="false" /> + </EntityType> <EntityType Name="DISPENSERS"> <Key> <PropertyRef Name="ID" /> @@ -131,6 +150,7 @@ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" /> <Property Name="DELETED" Type="bit" Nullable="false" /> + <Property Name="DISPENSER_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" /> </EntityType> <EntityType Name="EMBEDDED_FIRMWARE_VERSIONS"> <Key> @@ -441,10 +461,12 @@ <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="CARTRIDGE_TYPES" EntityType="Self.CARTRIDGE_TYPES" store:Type="Tables" /> <EntitySet Name="CARTRIDGES" EntityType="Self.CARTRIDGES" store:Type="Tables" /> <EntitySet Name="CONFIGURATIONS" EntityType="Self.CONFIGURATIONS" store:Type="Tables" /> <EntitySet Name="CONFIGURATIONS_DISPENSERS" EntityType="Self.CONFIGURATIONS_DISPENSERS" store:Type="Tables" /> <EntitySet Name="CONTACTS" EntityType="Self.CONTACTS" store:Type="Tables" /> + <EntitySet Name="DISPENSER_TYPES" EntityType="Self.DISPENSER_TYPES" store:Type="Tables" /> <EntitySet Name="DISPENSERS" EntityType="Self.DISPENSERS" store:Type="Tables" /> <EntitySet Name="EMBEDDED_FIRMWARE_VERSIONS" EntityType="Self.EMBEDDED_FIRMWARE_VERSIONS" store:Type="Tables" /> <EntitySet Name="EMBEDDED_SOFTWARE_VERSIONS" EntityType="Self.EMBEDDED_SOFTWARE_VERSIONS" store:Type="Tables" /> @@ -485,10 +507,12 @@ <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="CARTRIDGE_TYPES" EntityType="LocalModel.CARTRIDGE_TYPES" /> <EntitySet Name="CARTRIDGES" EntityType="LocalModel.CARTRIDGE" /> <EntitySet Name="CONFIGURATIONS" EntityType="LocalModel.CONFIGURATION" /> <EntitySet Name="CONFIGURATIONS_DISPENSERS" EntityType="LocalModel.CONFIGURATIONS_DISPENSERS" /> <EntitySet Name="CONTACTS" EntityType="LocalModel.CONTACT" /> + <EntitySet Name="DISPENSER_TYPES" EntityType="LocalModel.DISPENSER_TYPES" /> <EntitySet Name="DISPENSERS" EntityType="LocalModel.DISPENSER" /> <EntitySet Name="EMBEDDED_FIRMWARE_VERSIONS" EntityType="LocalModel.EMBEDDED_FIRMWARE_VERSIONS" /> <EntitySet Name="EMBEDDED_SOFTWARE_VERSIONS" EntityType="LocalModel.EMBEDDED_SOFTWARE_VERSIONS" /> @@ -538,7 +562,7 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> - <Property Name="ADDRESS1" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> + <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" /> @@ -582,6 +606,15 @@ <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="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="LAST_UPDATED" Type="DateTime" Nullable="false" /> + <Property Name="DELETED" Type="Boolean" Nullable="false" /> + </EntityType> <EntityType Name="CARTRIDGE"> <Key> <PropertyRef Name="ID" /> @@ -590,6 +623,7 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="CARTRIDGE_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="CONFIGURATION"> <Key> @@ -636,6 +670,15 @@ <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" /> </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="LAST_UPDATED" Type="DateTime" Nullable="false" /> + <Property Name="DELETED" Type="Boolean" Nullable="false" /> + </EntityType> <EntityType Name="DISPENSER"> <Key> <PropertyRef Name="ID" /> @@ -644,6 +687,7 @@ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" /> <Property Name="DELETED" Type="Boolean" Nullable="false" /> + <Property Name="DISPENSER_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="EMBEDDED_FIRMWARE_VERSIONS"> <Key> @@ -975,7 +1019,7 @@ <ScalarProperty Name="CITY" ColumnName="CITY" /> <ScalarProperty Name="COUNTRY" ColumnName="COUNTRY" /> <ScalarProperty Name="LOCALITY" ColumnName="LOCALITY" /> - <ScalarProperty Name="ADDRESS1" ColumnName="ADDRESS" /> + <ScalarProperty Name="ADDRESS_STRING" ColumnName="ADDRESS_STRING" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="GUID" ColumnName="GUID" /> @@ -1023,9 +1067,20 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> + <EntitySetMapping Name="CARTRIDGE_TYPES"> + <EntityTypeMapping TypeName="LocalModel.CARTRIDGE_TYPES"> + <MappingFragment StoreEntitySet="CARTRIDGE_TYPES"> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> + </MappingFragment> + </EntityTypeMapping> + </EntitySetMapping> <EntitySetMapping Name="CARTRIDGES"> <EntityTypeMapping TypeName="LocalModel.CARTRIDGE"> <MappingFragment StoreEntitySet="CARTRIDGES"> + <ScalarProperty Name="CARTRIDGE_TYPE_GUID" ColumnName="CARTRIDGE_TYPE_GUID" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="GUID" ColumnName="GUID" /> @@ -1081,9 +1136,20 @@ </MappingFragment> </EntityTypeMapping> </EntitySetMapping> + <EntitySetMapping Name="DISPENSER_TYPES"> + <EntityTypeMapping TypeName="LocalModel.DISPENSER_TYPES"> + <MappingFragment StoreEntitySet="DISPENSER_TYPES"> + <ScalarProperty Name="DELETED" ColumnName="DELETED" /> + <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> + <ScalarProperty Name="GUID" ColumnName="GUID" /> + <ScalarProperty Name="ID" ColumnName="ID" /> + </MappingFragment> + </EntityTypeMapping> + </EntitySetMapping> <EntitySetMapping Name="DISPENSERS"> <EntityTypeMapping TypeName="LocalModel.DISPENSER"> <MappingFragment StoreEntitySet="DISPENSERS"> + <ScalarProperty Name="DISPENSER_TYPE_GUID" ColumnName="DISPENSER_TYPE_GUID" /> <ScalarProperty Name="DELETED" ColumnName="DELETED" /> <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" /> <ScalarProperty Name="GUID" ColumnName="GUID" /> |
