D57D7CD9-3F8F-4846-B8C2-3CAC7F9992AA 19C7BD34-F152-4E95-BE64-7E1144ACF124 {43903B6E-F2D0-4529-9B67-E0717BF4EF9F} {3AC6FA9A-82A4-4F7A-98B9-1F12CFB202BF} {9D4131DD-68A4-40BC-9D3F-82B4F7FA17B1} {6ABFE754-D874-49FF-AC49-386F49B841AC} {E2E563B6-7240-4D2B-A665-CE22EBD29E9F} {AEFED982-F313-40D4-ABA9-11583190507F} {A4E5546A-E0F8-4601-9DC3-D39C7DE1FD72} {2F780E59-D0CF-4175-8473-C86D73B33ED6} {E986FF81-4A4E-4A5D-B792-8D70F05A1BDE} {41103BE4-2115-4129-A4F3-0EC70E1A7CA6} {9069C68C-56AA-40EA-9C14-1542D5226355} {A9BCA02E-A707-4832-A9A2-61F0A56F25C2} {091F9B2C-FC20-47D4-B7EC-E31EF07828FF} {FECE8C4D-B95C-4D06-B5E5-7C685B512607} {52DEA621-FBB4-4FC5-88C6-936CC3F53579} {FD0CE66F-4075-48FB-AF79-C75453274791} {AF1906F2-20B5-491C-8450-14F730DBECD8} {2BA9756D-C757-4770-B795-B1A4943359EC} {B5603A47-2936-4144-BA74-5D4B6959F47F} {A50D3C42-2BE0-49C7-A751-59ADDC334F01} {38416973-B84F-48DF-A766-01022A48B7CB} {FEDC8872-11CC-47CA-810A-6CCC2FAC6624} {B37E43B5-C83C-49A6-81FD-21424E22A0CC} {69774387-87EB-4929-95F7-666E7081C341} {EFA25F7E-F252-4083-A7E7-0E0B51D2C7A6} {82133B64-E91A-4EAB-96E7-5211E354E818} {3006DAE4-DDE9-4979-B982-8284D885ED2A} {6C8C05CC-8859-4974-B756-497697DB875F} {99441A25-E2A8-4B71-A311-AA46C216D6A9} {B670A3DE-8FD2-4508-A437-4EE82D3F184A} {EF353851-0BAE-450A-8751-D96E58402C08} {25D735B3-3DBA-4EF7-95C9-B94E5A480D40} {F312E41B-8ECF-4B2D-B084-B22186F114AE} {7A92AB4C-BB3F-47B9-BC98-4F55CF8690A3} {3EE67D94-4290-4A37-A0A3-73E2602C2971} {EF2A81A5-CB47-46E3-9FC5-203D7DA8EA10} default default D57D7CD9-3F8F-4846-B8C2-3CAC7F9992AA CB94695E-BAB0-41BC-8CD4-F41981127AA7 0 latin1 OfficeDirekt OfficeDirekt 19C7BD34-F152-4E95-BE64-7E1144ACF124 BEAC6E4D-2250-4ECF-9556-67FFFCA139F3 C9BC2DA4-8F0A-484B-A967-90C5F516F1F1 0 utf8_general_ci VARCHAR '' 0 0 1 PLZ_Bezirk_ID PLZ_Bezirk_ID {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 5D71D238-E053-4763-9139-B474F190E4D3 0 utf8_general_ci VARCHAR 1 1 50 PLZ_Bezirk PLZ_Bezirk {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} utf8 utf8_general_ci 359A0370-74A1-4838-8160-04CF2E5F5887 E47BAD9B-6060-43F4-9835-DE2EF7D25FD7 0 PLZ_Bezirk_ID 359A0370-74A1-4838-8160-04CF2E5F5887 C9BC2DA4-8F0A-484B-A967-90C5F516F1F1 PRIMARY BTREE 1 PRIMARY PRIMARY BEAC6E4D-2250-4ECF-9556-67FFFCA139F3 1 ED2621B5-6171-44B2-B0F3-4A4F7058A3E1 33AD3F6C-9EDC-4B5C-AD56-0D58E50F628E 0 PLZ_Bezirk_ID ED2621B5-6171-44B2-B0F3-4A4F7058A3E1 C9BC2DA4-8F0A-484B-A967-90C5F516F1F1 BTREE PLZ_Bezirk_ID PLZ_Bezirk_ID BEAC6E4D-2250-4ECF-9556-67FFFCA139F3 0 0 AL_PLZ_Bezirke AL_PLZ_Bezirke CB94695E-BAB0-41BC-8CD4-F41981127AA7 359A0370-74A1-4838-8160-04CF2E5F5887 Dynamic CREATE TABLE `AL_PLZ_Bezirke` ( `PLZ_Bezirk_ID` varchar(1) NOT NULL, `PLZ_Bezirk` varchar(50) default NULL, PRIMARY KEY (`PLZ_Bezirk_ID`), KEY `PLZ_Bezirk_ID` (`PLZ_Bezirk_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM 4990D7F2-CF04-4ABE-8BD2-31253749EC5A B58BE9A1-44FA-489B-9B93-3EE42A96D0C1 1 INT 1 0 Angebotsindex Angebotsindex 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} 95C360BA-C6B6-4CE2-87B7-E17327FACE70 0 INT 1 1 Kundenindex Kundenindex 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} D0A900D5-2D1F-4224-A874-42889AB15F13 0 DATETIME 1 1 AngebotsDatum AngebotsDatum {9A2399C8-F3EA-4B6C-AAB1-830D3BFF164B} 59BE0306-0646-4063-87C0-046542B1F41E 0 TINYINT '' 0 0 Bestellt Bestellt 1 5 {3C75C19F-FCA4-44DE-8881-F477FEA32E62} D3CCE837-0FB1-40C3-83B4-BE2D02303BE2 0 DATETIME 1 1 Rechnungsdatum Rechnungsdatum {9A2399C8-F3EA-4B6C-AAB1-830D3BFF164B} utf8 utf8_general_ci A583A2DA-B829-4F6B-9320-044C6FC860D2 EC4E8B4B-425A-492A-9F63-F8F028A58F13 0 Angebotsindex A583A2DA-B829-4F6B-9320-044C6FC860D2 B58BE9A1-44FA-489B-9B93-3EE42A96D0C1 PRIMARY BTREE 1 PRIMARY PRIMARY 4990D7F2-CF04-4ABE-8BD2-31253749EC5A 1 0 Angebote 1 Angebote CB94695E-BAB0-41BC-8CD4-F41981127AA7 A583A2DA-B829-4F6B-9320-044C6FC860D2 Fixed CREATE TABLE `Angebote` ( `Angebotsindex` int(10) NOT NULL auto_increment, `Kundenindex` int(10) default NULL, `AngebotsDatum` datetime default NULL, `Bestellt` tinyint(1) NOT NULL, `Rechnungsdatum` datetime default NULL, PRIMARY KEY (`Angebotsindex`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM 65CEF4C3-9436-427D-A057-C1AB2DD14512 C340328C-B94A-406E-BF7B-90F5F0FF54EC 1 INT 1 0 Artikel_ID Artikel_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} E68A0D5B-17CA-4915-A92D-4276FA5845A6 0 utf8_general_ci VARCHAR 1 1 50 Artikelname Artikelname {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} AF726771-5ABE-44CF-BDB7-0740E6D4D278 0 INT 1 1 Lieferanten_ID Lieferanten_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} EDD1C537-BE63-451C-8040-65A53E9199C6 0 INT 1 1 Kategorie_ID Kategorie_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} 2DDD5F64-F9D1-49E3-9F56-D0096A066E98 0 DECIMAL 1 1 Preis Preis 19 4 {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} 408E29A5-7F4E-4DAF-97C3-967CB26D8652 0 SMALLINT 1 1 Lagerbestand Lagerbestand 5 5 {B98335A2-603F-4042-9D59-88248D987309} 801BFC77-746D-4BE3-BC4C-46CC2B283BB6 0 SMALLINT 1 1 BestellteEinheiten BestellteEinheiten 5 5 {B98335A2-603F-4042-9D59-88248D987309} 8D60F117-623C-4DDE-B107-C3BF7459439F 0 SMALLINT 1 1 Mindestbestand Mindestbestand 5 5 {B98335A2-603F-4042-9D59-88248D987309} EED07326-F77B-4BA1-8EEE-4420730A05C1 0 TINYINT '' 0 0 Auslaufartikel Auslaufartikel 1 5 {3C75C19F-FCA4-44DE-8881-F477FEA32E62} utf8 utf8_general_ci 5589A57D-40E5-4B8E-B3C9-AB040E21363F 59EC0191-7297-4B16-A230-5152790A94D4 0 Artikel_ID 5589A57D-40E5-4B8E-B3C9-AB040E21363F C340328C-B94A-406E-BF7B-90F5F0FF54EC PRIMARY BTREE 1 PRIMARY PRIMARY 65CEF4C3-9436-427D-A057-C1AB2DD14512 1 F2CE9085-D661-44D1-B886-4411DE567FF5 393F062A-76CB-4FD5-A9A7-2151E0DD8E2A 0 Kategorie_ID F2CE9085-D661-44D1-B886-4411DE567FF5 EDD1C537-BE63-451C-8040-65A53E9199C6 BTREE ArtikelKategorie-Nr ArtikelKategorie-Nr 65CEF4C3-9436-427D-A057-C1AB2DD14512 0 8B670BB0-7B4D-42A4-9A55-BF74A7FDC198 05DE5608-4592-4340-B52A-AB75173CD48F 0 Artikelname 8B670BB0-7B4D-42A4-9A55-BF74A7FDC198 E68A0D5B-17CA-4915-A92D-4276FA5845A6 BTREE Artikelname Artikelname 65CEF4C3-9436-427D-A057-C1AB2DD14512 0 D6D5FE80-546C-4B6A-B1ED-EA26441C79E5 36B68F7B-B812-4D9F-9C18-6CEB8FF885B6 0 Kategorie_ID D6D5FE80-546C-4B6A-B1ED-EA26441C79E5 EDD1C537-BE63-451C-8040-65A53E9199C6 BTREE KategorienArtikel KategorienArtikel 65CEF4C3-9436-427D-A057-C1AB2DD14512 0 91A56F0C-93A2-4076-A3E2-A86F3A6693A6 AB454905-5D2B-4ABD-81FB-7F5A47806C13 0 Kategorie_ID 91A56F0C-93A2-4076-A3E2-A86F3A6693A6 EDD1C537-BE63-451C-8040-65A53E9199C6 BTREE Kategorie-Nr Kategorie-Nr 65CEF4C3-9436-427D-A057-C1AB2DD14512 0 664A860D-0B5F-43DB-A4D7-4B16AAFE584B 546E94BD-C27A-4DB6-97AD-F8887738C4CA 0 Lieferanten_ID 664A860D-0B5F-43DB-A4D7-4B16AAFE584B AF726771-5ABE-44CF-BDB7-0740E6D4D278 BTREE LieferantenArtikel1 LieferantenArtikel1 65CEF4C3-9436-427D-A057-C1AB2DD14512 0 E1ACE88E-1CDD-4C30-8D60-18524EA93EBE EE7095E8-CAAE-409D-8A45-D236FA874D99 0 Lieferanten_ID E1ACE88E-1CDD-4C30-8D60-18524EA93EBE AF726771-5ABE-44CF-BDB7-0740E6D4D278 BTREE Lieferanten-Nr Lieferanten-Nr 65CEF4C3-9436-427D-A057-C1AB2DD14512 0 0 Artikel 1 Artikel CB94695E-BAB0-41BC-8CD4-F41981127AA7 5589A57D-40E5-4B8E-B3C9-AB040E21363F Dynamic CREATE TABLE `Artikel` ( `Artikel_ID` int(10) NOT NULL auto_increment, `Artikelname` varchar(50) default NULL, `Lieferanten_ID` int(10) default NULL, `Kategorie_ID` int(10) default NULL, `Preis` decimal(19,4) default NULL, `Lagerbestand` smallint(5) default NULL, `BestellteEinheiten` smallint(5) default NULL, `Mindestbestand` smallint(5) default NULL, `Auslaufartikel` tinyint(1) NOT NULL, PRIMARY KEY (`Artikel_ID`), KEY `ArtikelKategorie-Nr` (`Kategorie_ID`), KEY `Artikelname` (`Artikelname`), KEY `KategorienArtikel` (`Kategorie_ID`), KEY `Kategorie-Nr` (`Kategorie_ID`), KEY `LieferantenArtikel1` (`Lieferanten_ID`), KEY `Lieferanten-Nr` (`Lieferanten_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM ED7C858C-AAC6-41CA-8792-A8821D8BB0F6 E2F34C9C-62BF-4FF3-845F-9E0B5346DEE8 0 INT '' 0 0 ArtikelNr ArtikelNr 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} AFE54A42-FCD1-4B28-9518-7EE71C57F06B 0 INT '' 0 0 LieferantenNr LieferantenNr 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} 20655A85-12AF-4944-88F4-41B969B333FF 0 utf8_general_ci VARCHAR 1 1 20 LieferArtikelNr LieferArtikelNr {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} A127FCA8-3357-4446-963D-2D7886AC27E7 0 DECIMAL 1 1 EKPreis EKPreis 19 4 {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} 18D51242-064C-4E0F-A824-EB7C6DA47923 0 TINYINT '' 0 0 Auslaufartikel Auslaufartikel 1 5 {3C75C19F-FCA4-44DE-8881-F477FEA32E62} utf8 utf8_general_ci 55DD5751-934A-4114-920D-B0877C9F0E49 850AA0C8-931B-42FB-88BB-00BEC7083B8A 0 ArtikelNr 55DD5751-934A-4114-920D-B0877C9F0E49 E2F34C9C-62BF-4FF3-845F-9E0B5346DEE8 EB7C3F34-6677-4C4B-8156-F0BD8CAF9A50 0 LieferantenNr 55DD5751-934A-4114-920D-B0877C9F0E49 AFE54A42-FCD1-4B28-9518-7EE71C57F06B PRIMARY BTREE 1 PRIMARY PRIMARY ED7C858C-AAC6-41CA-8792-A8821D8BB0F6 1 0 ArtikelUndLieferanten ArtikelUndLieferanten CB94695E-BAB0-41BC-8CD4-F41981127AA7 55DD5751-934A-4114-920D-B0877C9F0E49 Dynamic CREATE TABLE `ArtikelUndLieferanten` ( `ArtikelNr` int(10) NOT NULL, `LieferantenNr` int(10) NOT NULL, `LieferArtikelNr` varchar(20) default NULL, `EKPreis` decimal(19,4) default NULL, `Auslaufartikel` tinyint(1) NOT NULL, PRIMARY KEY (`ArtikelNr`,`LieferantenNr`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM F4359C9E-2D82-44E7-B5D8-441BA298D728 474189C2-5B12-40F4-82FC-C8C13E2AD3D7 0 INT '' 0 0 Bestell_ID Bestell_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} 93B0836E-4D08-47E2-A546-1041731DAB27 0 INT '' 0 0 Artikel_ID Artikel_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} F1A1C2C9-F2FE-4EC9-B43E-230B4D084C02 0 DECIMAL 1 1 Einzelpreis Einzelpreis 19 4 {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} 1E28CE28-EA7A-4128-B221-03D2CB8258D2 0 SMALLINT 1 1 Anzahl Anzahl 5 5 {B98335A2-603F-4042-9D59-88248D987309} 0DF9135D-BF34-4F55-97A6-937F865EFF37 0 (7,2) DOUBLE 1 1 Rabatt Rabatt {3873BD96-9C60-4BB0-90B4-45F4C76485D9} utf8 utf8_general_ci 855C841D-C942-44F5-8D5C-90E28B3CA656 E9E226B1-10C3-4BED-A885-E09FE69B9907 0 Bestell_ID 855C841D-C942-44F5-8D5C-90E28B3CA656 474189C2-5B12-40F4-82FC-C8C13E2AD3D7 2F5DF7F7-B18F-46BC-A330-F9328C3D26D0 0 Artikel_ID 855C841D-C942-44F5-8D5C-90E28B3CA656 93B0836E-4D08-47E2-A546-1041731DAB27 PRIMARY BTREE 1 PRIMARY PRIMARY F4359C9E-2D82-44E7-B5D8-441BA298D728 1 03A08A30-F0EE-4B1C-B93F-3A20E6977428 12DD3979-81E4-499D-A269-3A482D14A76D 0 Artikel_ID 03A08A30-F0EE-4B1C-B93F-3A20E6977428 93B0836E-4D08-47E2-A546-1041731DAB27 BTREE ArtikelAuftragspositionen ArtikelAuftragspositionen F4359C9E-2D82-44E7-B5D8-441BA298D728 0 A1AD99C4-F470-43DE-B625-0520A14A9FCC 5FDFDA4F-B6E3-49AB-B0F2-CA8F93FF777B 0 Artikel_ID A1AD99C4-F470-43DE-B625-0520A14A9FCC 93B0836E-4D08-47E2-A546-1041731DAB27 BTREE Artikel-Nr Artikel-Nr F4359C9E-2D82-44E7-B5D8-441BA298D728 0 97C8CF81-2C8C-46C4-983D-5BA7AD55EB4F FCB08EA2-E029-49D8-A30B-CB9E3EB53C7B 0 Bestell_ID 97C8CF81-2C8C-46C4-983D-5BA7AD55EB4F 474189C2-5B12-40F4-82FC-C8C13E2AD3D7 BTREE AufträgeAuftragspositionen1 AufträgeAuftragspositionen1 F4359C9E-2D82-44E7-B5D8-441BA298D728 0 AE6E9D27-2AD6-483C-B9A6-D5AD7A8BE793 CEA0645A-AFB4-4E40-AC8F-F0769A8689AD 0 Bestell_ID AE6E9D27-2AD6-483C-B9A6-D5AD7A8BE793 474189C2-5B12-40F4-82FC-C8C13E2AD3D7 BTREE Bestell-Nr Bestell-Nr F4359C9E-2D82-44E7-B5D8-441BA298D728 0 0 Auftragspositionen Auftragspositionen CB94695E-BAB0-41BC-8CD4-F41981127AA7 855C841D-C942-44F5-8D5C-90E28B3CA656 Fixed CREATE TABLE `Auftragspositionen` ( `Bestell_ID` int(10) NOT NULL, `Artikel_ID` int(10) NOT NULL, `Einzelpreis` decimal(19,4) default NULL, `Anzahl` smallint(5) default NULL, `Rabatt` double(7,2) default NULL, PRIMARY KEY (`Bestell_ID`,`Artikel_ID`), KEY `ArtikelAuftragspositionen` (`Artikel_ID`), KEY `Artikel-Nr` (`Artikel_ID`), KEY `AufträgeAuftragspositionen1` (`Bestell_ID`), KEY `Bestell-Nr` (`Bestell_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM 6E71CD33-6586-4A1C-A077-1A8781F8BC78 0B464E17-E5F1-4D89-A320-5C7F5729A9ED 1 INT 1 0 Bestell_ID Bestell_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} E8CBD460-80FE-489F-A01E-CE3370455B59 0 INT 1 1 Kunden_ID Kunden_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} 3E4418A8-9F0A-4886-9601-8720EF7CE50F 0 INT 1 1 Mitarbeiter_ID Mitarbeiter_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} FE1ECBF2-7612-40F8-9DE5-4EFBAC91AD5D 0 DATETIME 1 1 Bestelldatum Bestelldatum {9A2399C8-F3EA-4B6C-AAB1-830D3BFF164B} 713D6DFF-8119-4699-9F19-DFF60208B488 0 DATETIME 1 1 Versanddatum Versanddatum {9A2399C8-F3EA-4B6C-AAB1-830D3BFF164B} A1DAEE2A-3452-49D3-A42A-DD811B562217 0 INT 1 1 Spediteur_ID Spediteur_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} 7DCD3E08-0C08-411C-A1B1-698904D4277F 0 DECIMAL 1 1 Frachtkosten Frachtkosten 19 4 {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} utf8 utf8_general_ci EDD4B92E-51A4-4A5D-8D17-9AA2334F22A2 B3CB2677-B866-4342-8692-766CD890C1E7 0 Bestell_ID EDD4B92E-51A4-4A5D-8D17-9AA2334F22A2 0B464E17-E5F1-4D89-A320-5C7F5729A9ED PRIMARY BTREE 1 PRIMARY PRIMARY 6E71CD33-6586-4A1C-A077-1A8781F8BC78 1 D717FBA6-A181-4C4F-82BB-E420DB542644 099FD6E7-FFA4-4585-B1DF-DBF5D1B2C41B 0 Bestelldatum D717FBA6-A181-4C4F-82BB-E420DB542644 FE1ECBF2-7612-40F8-9DE5-4EFBAC91AD5D BTREE Bestelldatum Bestelldatum 6E71CD33-6586-4A1C-A077-1A8781F8BC78 0 CE5C1B1F-4D19-4033-9DA3-823977A91453 37AADE79-4503-4538-BF57-02C53806F681 0 Kunden_ID CE5C1B1F-4D19-4033-9DA3-823977A91453 E8CBD460-80FE-489F-A01E-CE3370455B59 BTREE KundenAufträge KundenAufträge 6E71CD33-6586-4A1C-A077-1A8781F8BC78 0 B59D4C49-44D7-43F7-8E4F-BA76A8BFFECD 46DE9C6A-7629-4BD9-831D-C200C958E22A 0 Kunden_ID B59D4C49-44D7-43F7-8E4F-BA76A8BFFECD E8CBD460-80FE-489F-A01E-CE3370455B59 BTREE KundenID KundenID 6E71CD33-6586-4A1C-A077-1A8781F8BC78 0 0CA43CB6-6148-4F0A-949D-EDDB77BBFA0B 249D6153-A6C9-4AAF-AC6B-4353A466E39A 0 Mitarbeiter_ID 0CA43CB6-6148-4F0A-949D-EDDB77BBFA0B 3E4418A8-9F0A-4886-9601-8720EF7CE50F BTREE MitarbeiterAufträge1 MitarbeiterAufträge1 6E71CD33-6586-4A1C-A077-1A8781F8BC78 0 B4CE504C-A65C-4D5E-B2B2-6F8B4F7399C4 0C7685E8-F22A-4DA2-B8F6-B812CAEBD8D1 0 Mitarbeiter_ID B4CE504C-A65C-4D5E-B2B2-6F8B4F7399C4 3E4418A8-9F0A-4886-9601-8720EF7CE50F BTREE Personal-Nr Personal-Nr 6E71CD33-6586-4A1C-A077-1A8781F8BC78 0 C5EFA2B2-781C-42E3-8803-267BB83FE8D8 755F535C-F095-4AA4-8C7A-CC1128EB5C4B 0 Spediteur_ID C5EFA2B2-781C-42E3-8803-267BB83FE8D8 A1DAEE2A-3452-49D3-A42A-DD811B562217 BTREE SpediteureAufträge1 SpediteureAufträge1 6E71CD33-6586-4A1C-A077-1A8781F8BC78 0 7AAA83E4-FA17-4A61-9EB5-3A9E15DC7C7B 6CBA5B27-8F81-4987-9318-18326DBA2FCA 0 Versanddatum 7AAA83E4-FA17-4A61-9EB5-3A9E15DC7C7B 713D6DFF-8119-4699-9F19-DFF60208B488 BTREE Versanddatum Versanddatum 6E71CD33-6586-4A1C-A077-1A8781F8BC78 0 0 Aufträge 1 Aufträge CB94695E-BAB0-41BC-8CD4-F41981127AA7 EDD4B92E-51A4-4A5D-8D17-9AA2334F22A2 Fixed CREATE TABLE `Aufträge` ( `Bestell_ID` int(10) NOT NULL auto_increment, `Kunden_ID` int(10) default NULL, `Mitarbeiter_ID` int(10) default NULL, `Bestelldatum` datetime default NULL, `Versanddatum` datetime default NULL, `Spediteur_ID` int(10) default NULL, `Frachtkosten` decimal(19,4) default NULL, PRIMARY KEY (`Bestell_ID`), KEY `Bestelldatum` (`Bestelldatum`), KEY `KundenAufträge` (`Kunden_ID`), KEY `KundenID` (`Kunden_ID`), KEY `MitarbeiterAufträge1` (`Mitarbeiter_ID`), KEY `Personal-Nr` (`Mitarbeiter_ID`), KEY `SpediteureAufträge1` (`Spediteur_ID`), KEY `Versanddatum` (`Versanddatum`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM 1F70C96B-BEBF-4CFF-B373-A8D7A771F43B AA4CFD44-CB18-4672-98F1-A0A89B81AD3D 1 INT 1 0 Kategorie_ID Kategorie_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} 8F5625DC-7BEC-4E46-9283-546FC807233F 0 utf8_general_ci VARCHAR 1 1 30 Kategoriename Kategoriename {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} FB2C9F3D-10C0-414E-BFF5-204CEB56420F 0 utf8_general_ci VARCHAR 1 1 255 Beschreibung Beschreibung {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 3C4F50F8-B652-43BE-83C2-BCD5865CF48C 0 utf8_general_ci VARCHAR 1 1 50 Seite Seite {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} utf8 utf8_general_ci 7E04723E-714A-4A17-813A-0735B361EC84 F27DC9E8-293B-4295-AB2D-8B6DA5052DAF 0 Kategorie_ID 7E04723E-714A-4A17-813A-0735B361EC84 AA4CFD44-CB18-4672-98F1-A0A89B81AD3D PRIMARY BTREE 1 PRIMARY PRIMARY 1F70C96B-BEBF-4CFF-B373-A8D7A771F43B 1 F9AD8546-F339-46E4-8173-52698D208FE9 91991435-A943-483E-BC00-3BFE0DD9D297 0 Kategoriename F9AD8546-F339-46E4-8173-52698D208FE9 8F5625DC-7BEC-4E46-9283-546FC807233F UNIQUE BTREE Kategoriename Kategoriename 1F70C96B-BEBF-4CFF-B373-A8D7A771F43B 1 0 Kategorien 1 Kategorien CB94695E-BAB0-41BC-8CD4-F41981127AA7 7E04723E-714A-4A17-813A-0735B361EC84 Dynamic CREATE TABLE `Kategorien` ( `Kategorie_ID` int(10) NOT NULL auto_increment, `Kategoriename` varchar(30) default NULL, `Beschreibung` varchar(255) default NULL, `Seite` varchar(50) default NULL, PRIMARY KEY (`Kategorie_ID`), UNIQUE KEY `Kategoriename` (`Kategoriename`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM 856E358A-1179-41B6-A130-041F8F335B95 6F86F8B9-D178-44B1-BED0-64E8692DD6B2 0 (15,5) DOUBLE 1 1 MwStSatz MwStSatz {3873BD96-9C60-4BB0-90B4-45F4C76485D9} C48A19CD-985B-4525-AC1F-F4A92C0D7507 0 DECIMAL 1 1 Versandpauschale Versandpauschale 19 4 {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} 948F7336-3181-4B87-B761-7C30BA5F35A2 0 DECIMAL 1 1 Installationsstundensatz Installationsstundensatz 19 4 {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} 5C52FDB5-9468-42B9-B218-A39A30D45A9F 0 DECIMAL 1 1 Installationspauschale Installationspauschale 19 4 {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} 4342EEAF-6CF5-43D0-9509-C3D5F3CCF4DB 0 DECIMAL 1 1 SchulungsTagesSatz SchulungsTagesSatz 19 4 {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} 335A9645-28EC-4EEB-9980-F46062DC3C28 0 DECIMAL 1 1 SchulungsFolgeSatz SchulungsFolgeSatz 19 4 {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} 3CA47268-C11B-4A3B-9889-E4820CD39AC8 0 utf8_general_ci VARCHAR 1 1 50 BrfKpfZeile1 BrfKpfZeile1 {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 109495B3-A454-46A5-9BD3-B9994567498B 0 utf8_general_ci VARCHAR 1 1 50 BrfKpfZeile2 BrfKpfZeile2 {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 82FD56C0-DDDC-44E6-8D23-37DC338FAF6D 0 utf8_general_ci VARCHAR 1 1 50 BrfKpfZeile3 BrfKpfZeile3 {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 5E002CB0-6C2A-43D6-B1AC-0A4923CBFF5E 0 utf8_general_ci VARCHAR 1 1 50 BrfAbsender BrfAbsender {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 308CBB43-0534-43D4-8379-FE21DFC75C60 0 utf8_general_ci VARCHAR 1 1 50 BrfStraße BrfStraße {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 1AC81467-C190-4100-9BC2-B76E87243F36 0 utf8_general_ci VARCHAR 1 1 50 BrfOrt BrfOrt {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} utf8 utf8_general_ci 0 Konstanten Konstanten CB94695E-BAB0-41BC-8CD4-F41981127AA7 Dynamic CREATE TABLE `Konstanten` ( `MwStSatz` double(15,5) default NULL, `Versandpauschale` decimal(19,4) default NULL, `Installationsstundensatz` decimal(19,4) default NULL, `Installationspauschale` decimal(19,4) default NULL, `SchulungsTagesSatz` decimal(19,4) default NULL, `SchulungsFolgeSatz` decimal(19,4) default NULL, `BrfKpfZeile1` varchar(50) default NULL, `BrfKpfZeile2` varchar(50) default NULL, `BrfKpfZeile3` varchar(50) default NULL, `BrfAbsender` varchar(50) default NULL, `BrfStraße` varchar(50) default NULL, `BrfOrt` varchar(50) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM F745690A-4DBD-4122-B7D5-408FD75E5C60 F195EBF7-5452-499D-81CC-2213964BAF90 1 INT 1 0 Kunden_ID Kunden_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} CA4E543B-9031-49DB-AA1A-B19FA639364E 0 utf8_general_ci VARCHAR 1 1 100 Kunde Kunde {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 5281BDDC-6A4A-4143-9F99-DEA06ABD956F 0 utf8_general_ci VARCHAR 1 1 50 Kontaktperson_Name Kontaktperson_Name {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} DB6C913C-9873-4DCE-BD72-94AF6E066750 0 utf8_general_ci VARCHAR 1 1 50 Kontaktperson_Vorname Kontaktperson_Vorname {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} B6D75267-FA06-4446-901B-F1308167EBAA 0 utf8_general_ci VARCHAR 1 1 60 Straße Straße {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 5F07CA92-226E-407C-BBC6-8C51401A6643 0 utf8_general_ci VARCHAR 1 1 10 PLZ PLZ {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 851ABA53-26F8-48D3-A13E-E871679ACE3B 0 utf8_general_ci VARCHAR 1 1 30 Ort Ort {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 51E4B75F-D542-41D2-B3AF-3BF92E6DCA22 0 utf8_general_ci VARCHAR 1 1 24 Telefon Telefon {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} utf8 utf8_general_ci DC8A895B-0524-4A44-9A41-5693010BE8EA A72B5120-0240-4870-B5D6-4090777702E5 0 Kunden_ID DC8A895B-0524-4A44-9A41-5693010BE8EA F195EBF7-5452-499D-81CC-2213964BAF90 PRIMARY BTREE 1 PRIMARY PRIMARY F745690A-4DBD-4122-B7D5-408FD75E5C60 1 FF950149-0A86-4852-BE77-F2F014B7C1E6 A6171D2E-7456-478F-AA32-92B2070C5FF3 0 Kunde FF950149-0A86-4852-BE77-F2F014B7C1E6 CA4E543B-9031-49DB-AA1A-B19FA639364E BTREE Firma Firma F745690A-4DBD-4122-B7D5-408FD75E5C60 0 CB79757D-3ED9-4FA7-BE8B-459A01192A01 CE91A954-D293-46D5-A366-372E4DDD02C9 0 Kunden_ID CB79757D-3ED9-4FA7-BE8B-459A01192A01 F195EBF7-5452-499D-81CC-2213964BAF90 BTREE ID ID F745690A-4DBD-4122-B7D5-408FD75E5C60 0 82F080CA-3389-42FB-8E90-D8DDE9C9DDC7 77C7ABF8-421D-49EF-BD1B-89713BA0E0AC 0 Ort 82F080CA-3389-42FB-8E90-D8DDE9C9DDC7 851ABA53-26F8-48D3-A13E-E871679ACE3B BTREE Ort Ort F745690A-4DBD-4122-B7D5-408FD75E5C60 0 0A8C2A40-3D5D-4403-8D5E-ECA505C98A57 14E865A9-7822-436C-9864-C3B159AA64C0 0 PLZ 0A8C2A40-3D5D-4403-8D5E-ECA505C98A57 5F07CA92-226E-407C-BBC6-8C51401A6643 BTREE PLZ PLZ F745690A-4DBD-4122-B7D5-408FD75E5C60 0 0 Kunden 1 Kunden CB94695E-BAB0-41BC-8CD4-F41981127AA7 DC8A895B-0524-4A44-9A41-5693010BE8EA Dynamic CREATE TABLE `Kunden` ( `Kunden_ID` int(10) NOT NULL auto_increment, `Kunde` varchar(100) default NULL, `Kontaktperson_Name` varchar(50) default NULL, `Kontaktperson_Vorname` varchar(50) default NULL, `Straße` varchar(60) default NULL, `PLZ` varchar(10) default NULL, `Ort` varchar(30) default NULL, `Telefon` varchar(24) default NULL, PRIMARY KEY (`Kunden_ID`), KEY `Firma` (`Kunde`), KEY `ID` (`Kunden_ID`), KEY `Ort` (`Ort`), KEY `PLZ` (`PLZ`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM 04E50E4E-6A13-41FB-839C-83B2BA8CC785 13FC6E3D-2393-485F-8027-A54AD7D7F1E2 0 INT '' 0 0 Lieferanten_ID Lieferanten_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} 8F6803F2-0F78-4E96-9C83-2FC002544C96 0 utf8_general_ci VARCHAR 1 1 100 Firma Firma {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} BF87DE6F-580B-4FBC-8FD4-BDD7A315DEE6 0 utf8_general_ci VARCHAR 1 1 100 Kontaktperson Kontaktperson {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} CE4737C2-4407-4080-9167-D58455A1F2A8 0 utf8_general_ci VARCHAR 1 1 60 Straße Straße {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 38C68D42-324E-450D-B937-797ECBD3C71D 0 utf8_general_ci VARCHAR 1 1 10 PLZ PLZ {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 11F4947B-B2C5-4C2A-AF0F-3C1155AF67A5 0 utf8_general_ci VARCHAR 1 1 30 Ort Ort {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} E2B93344-23EC-4F5D-8149-21A090E0925E 0 utf8_general_ci VARCHAR 1 1 24 Telefon Telefon {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} utf8 utf8_general_ci 58BBBD65-ED6D-4DD2-9F76-89FB1ABF7919 E9B9FD18-ACBF-40E8-B442-F47572E54727 0 Lieferanten_ID 58BBBD65-ED6D-4DD2-9F76-89FB1ABF7919 13FC6E3D-2393-485F-8027-A54AD7D7F1E2 PRIMARY BTREE 1 PRIMARY PRIMARY 04E50E4E-6A13-41FB-839C-83B2BA8CC785 1 FC4B619F-27DA-49F0-B330-18EFC7B18AE8 1747513D-7A87-4519-98FA-38B416B74CDE 0 Lieferanten_ID FC4B619F-27DA-49F0-B330-18EFC7B18AE8 13FC6E3D-2393-485F-8027-A54AD7D7F1E2 BTREE Lieferanten_ID Lieferanten_ID 04E50E4E-6A13-41FB-839C-83B2BA8CC785 0 0 Lieferanten Lieferanten CB94695E-BAB0-41BC-8CD4-F41981127AA7 58BBBD65-ED6D-4DD2-9F76-89FB1ABF7919 Dynamic CREATE TABLE `Lieferanten` ( `Lieferanten_ID` int(10) NOT NULL, `Firma` varchar(100) default NULL, `Kontaktperson` varchar(100) default NULL, `Straße` varchar(60) default NULL, `PLZ` varchar(10) default NULL, `Ort` varchar(30) default NULL, `Telefon` varchar(24) default NULL, PRIMARY KEY (`Lieferanten_ID`), KEY `Lieferanten_ID` (`Lieferanten_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM E777E719-A1D1-411D-9A52-222A9D542886 07860CA1-25B9-4603-B9B6-11B8FDE1D5B7 1 INT 1 0 Mitarbeiter_ID Mitarbeiter_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} E1D25E24-19DA-4B85-9AB3-B569D70057B2 0 utf8_general_ci VARCHAR 1 1 20 Nachname Nachname {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 422B9FD1-9AE3-4417-A5E4-BC6F87D52C38 0 utf8_general_ci VARCHAR 1 1 10 Vorname Vorname {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0C7561CF-E978-4D78-BDD5-EB205719B75D 0 utf8_general_ci VARCHAR 1 1 30 Position Position {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 22D0B1A0-C4D9-4034-879B-B71CD1300FE4 0 utf8_general_ci VARCHAR 1 1 25 Anrede Anrede {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 839FA558-EC29-4F9F-AB06-D22EFA7EECE0 0 DATETIME 1 1 Geburtsdatum Geburtsdatum {9A2399C8-F3EA-4B6C-AAB1-830D3BFF164B} 13DE12E2-0A94-47FA-BC69-A17B17D8123F 0 DATETIME 1 1 Einstellungsdatum Einstellungsdatum {9A2399C8-F3EA-4B6C-AAB1-830D3BFF164B} 2933DAA6-F608-479C-A733-E926FF0B3830 0 utf8_general_ci VARCHAR 1 1 60 Straße Straße {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 7BFEE3C7-20DE-4594-B02A-0366B55FFC8F 0 utf8_general_ci VARCHAR 1 1 15 Ort Ort {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 9B41C21D-2230-4140-A716-AB5E7170C8CD 0 utf8_general_ci VARCHAR 1 1 10 PLZ PLZ {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} D8B54C87-097C-4C31-981C-E2993BFE13E9 0 utf8_general_ci VARCHAR 1 1 24 Telefon privat Telefon privat {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 12FD549C-AD81-4DC1-B0D6-DF5DF35FD9C0 0 utf8_general_ci VARCHAR 1 1 4 Telefon Büro Telefon Büro {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 1248CD6E-197E-4978-BC6C-694020BBECD9 0 LONGBLOB 1 1 Foto Foto {6C2E3841-EA8D-48E1-A727-B0B2E71857BF} 23191A09-BB16-459E-B5DF-A8E8038636FA 0 utf8_general_ci LONGTEXT 1 1 Bemerkungen Bemerkungen {BFDB5048-852A-4985-8772-5123FB7C23FE} B77575C0-756A-4DA7-A13B-F60EEDD86210 0 INT 1 1 Vorgesetzte(r) Vorgesetzte(r) 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} utf8 utf8_general_ci 5728060E-F1B6-4A04-988B-704DDD5AEBC9 FFF7C4D2-ABFC-4C1E-A909-E1FD6819D44E 0 Mitarbeiter_ID 5728060E-F1B6-4A04-988B-704DDD5AEBC9 07860CA1-25B9-4603-B9B6-11B8FDE1D5B7 PRIMARY BTREE 1 PRIMARY PRIMARY E777E719-A1D1-411D-9A52-222A9D542886 1 A87C64EB-A943-45C4-83A6-E5E76A58EF36 DE47DBEA-C5F2-41D9-BDA6-0B84E2D8E547 0 Nachname A87C64EB-A943-45C4-83A6-E5E76A58EF36 E1D25E24-19DA-4B85-9AB3-B569D70057B2 BTREE LastName LastName E777E719-A1D1-411D-9A52-222A9D542886 0 47B03796-BA03-4E49-87A4-8C3DC2B63A37 02B5C5B3-3AD0-46C0-9184-8633CA7C769E 0 PLZ 47B03796-BA03-4E49-87A4-8C3DC2B63A37 9B41C21D-2230-4140-A716-AB5E7170C8CD BTREE PostalCode PostalCode E777E719-A1D1-411D-9A52-222A9D542886 0 0 Mitarbeiter 1 Mitarbeiter CB94695E-BAB0-41BC-8CD4-F41981127AA7 5728060E-F1B6-4A04-988B-704DDD5AEBC9 Dynamic CREATE TABLE `Mitarbeiter` ( `Mitarbeiter_ID` int(10) NOT NULL auto_increment, `Nachname` varchar(20) default NULL, `Vorname` varchar(10) default NULL, `Position` varchar(30) default NULL, `Anrede` varchar(25) default NULL, `Geburtsdatum` datetime default NULL, `Einstellungsdatum` datetime default NULL, `Straße` varchar(60) default NULL, `Ort` varchar(15) default NULL, `PLZ` varchar(10) default NULL, `Telefon privat` varchar(24) default NULL, `Telefon Büro` varchar(4) default NULL, `Foto` longblob, `Bemerkungen` longtext, `Vorgesetzte(r)` int(10) default NULL, PRIMARY KEY (`Mitarbeiter_ID`), KEY `LastName` (`Nachname`), KEY `PostalCode` (`PLZ`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM 2AAC722A-58E7-4BB2-A2E7-8A63696380BB 5CBAF439-F581-4364-AD7B-0790FD9FF246 1 INT 1 0 Spediteur_ID Spediteur_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} 9D3BAC35-92D1-46A0-BD0A-B7A5FF695C68 0 utf8_general_ci VARCHAR 1 1 40 Firma Firma {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 644342F1-2C52-47CE-A19D-0B3EC42E22D5 0 utf8_general_ci VARCHAR 1 1 24 Telefon Telefon {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} utf8 utf8_general_ci B7E7F47B-DD7E-4FAC-9542-763B2BC25B65 1B386478-5492-4F98-AA45-2D5F2046C8D7 0 Spediteur_ID B7E7F47B-DD7E-4FAC-9542-763B2BC25B65 5CBAF439-F581-4364-AD7B-0790FD9FF246 PRIMARY BTREE 1 PRIMARY PRIMARY 2AAC722A-58E7-4BB2-A2E7-8A63696380BB 1 0 Spediteure 1 Spediteure CB94695E-BAB0-41BC-8CD4-F41981127AA7 B7E7F47B-DD7E-4FAC-9542-763B2BC25B65 Dynamic CREATE TABLE `Spediteure` ( `Spediteur_ID` int(10) NOT NULL auto_increment, `Firma` varchar(40) default NULL, `Telefon` varchar(24) default NULL, PRIMARY KEY (`Spediteur_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM 12CE4F21-5C5A-43BB-B44C-9EC1DC17744A 0 0 utf8 utf8_general_ci 0 0 0 table_1 table_1 CB94695E-BAB0-41BC-8CD4-F41981127AA7 InnoDB BAD24137-B0D4-4638-B4D9-E7AD4458434B 0 0 utf8 utf8_general_ci 0 0 0 table_2 table_2 CB94695E-BAB0-41BC-8CD4-F41981127AA7 InnoDB 3E570CFC-F8C7-4F5D-B41F-0B083797949C 0 0 utf8 utf8_general_ci 0 0 0 table_3 table_3 CB94695E-BAB0-41BC-8CD4-F41981127AA7 InnoDB {3C75C19F-FCA4-44DE-8881-F477FEA32E62} {B98335A2-603F-4042-9D59-88248D987309} {A5A2A320-DAAD-416E-862C-FAA9AD90DF8C} {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} {B96B522A-48FE-431F-A0B4-D5E1B733FE3F} {BEA67203-20CC-4A53-A4EC-B2F31E84DE1E} {3873BD96-9C60-4BB0-90B4-45F4C76485D9} {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} {4B160881-85B7-4C25-BBD1-36C9CA1A0E80} {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {4159AB8E-78E7-41E7-AAFD-0DE3766C2935} {CD41C6AA-4BAC-42E8-A4FC-655CAE3534D0} {B965148B-8E5B-46E9-999C-252D92B37B2C} {52734DB8-D81D-4593-A74C-891967DFAC63} {7874D9C1-0F91-487C-822C-3ABC407452BE} {BFDB5048-852A-4985-8772-5123FB7C23FE} {D2A508F3-9636-400D-816E-68E0A172204C} {6A28850F-C54C-4722-80A0-6187798B35C0} {EBCCD9D0-1497-4EEE-97FC-0C96DB3D2EBE} {6C2E3841-EA8D-48E1-A727-B0B2E71857BF} {9A2399C8-F3EA-4B6C-AAB1-830D3BFF164B} {E3ACD2FE-A26F-4BB8-ADA6-433F92B0570D} {65642303-376E-4C4A-B200-7E0DFAA47344} {868AC4F9-F4BB-44AD-8512-4EBAD5E5D661} {D8A1FD40-794F-464E-8E4A-E14C38D9C924} {DC0345B1-52D4-497C-AFA1-17A00BCAA7FE} {739D4BC4-0188-46BB-84AB-DB97CE01B67F} {50C760E2-97A4-4BB0-ABA5-E0A2D11E683D} {86A060EB-F367-4890-8FFA-00840F281791} {04006513-2EA3-4785-A541-8C25E68E5E0A} {1D1FE4C9-6A0B-423C-A048-8830C430A93E} {E1609E12-9B2A-4EF7-9265-00D6D3BE0026} {855F4FED-94F7-4E28-812C-6882B28571AF} {F496575F-5F75-4825-A059-7DFC75DB3DFD} {D442887A-6402-4873-ADC5-6F875085C0A6} {D8F350D8-9522-478F-9233-28C52E26A067} 8291B2AF-29BF-406B-85B0-394C33F399B7 5 1 Version 19C7BD34-F152-4E95-BE64-7E1144ACF124 6 62C5683D-9ECC-408B-925C-2ECA7F34944B {D65C7567-0B84-4AC6-A1A4-0A4BB8C9F3F2} MigrationGeneric QueryMysql ReverseEngineeringMysql TransformationMysql 127.0.0.1 3306 0 0 0 root 349B21AE-F85A-44CA-8F3B-9EFC8CA8891D 34FF0DB7-69BA-426F-8FC8-0DB6CE2D9025 D182CA0F-94E2-4901-8588-A2851F3CE386 Dez 11, 2006 Dez 11, 2006 New Model Properties 349B21AE-F85A-44CA-8F3B-9EFC8CA8891D Name of the project 1.0 34FF0DB7-69BA-426F-8FC8-0DB6CE2D9025 7EF1D3E2-0023-4825-B462-40A9F8B008C1 1 0 0 0 50.000000 0 3AD19BF6-7AC1-4983-8DE3-18D57D022B2D 20.000000 0 AL_PLZ_Bezirke BEAC6E4D-2250-4ECF-9556-67FFFCA139F3 20.000000 0 1 160.000000 B4A5BC6A-062F-4174-8CD5-B8990627C705 1 0 0 0 50.000000 0 3AD19BF6-7AC1-4983-8DE3-18D57D022B2D 390.000000 0 Angebote 4990D7F2-CF04-4ABE-8BD2-31253749EC5A 20.000000 0 1 160.000000 97CEFFC2-06C0-4950-A97B-AB1FFD17C448 1 0 0 0 50.000000 0 3AD19BF6-7AC1-4983-8DE3-18D57D022B2D 760.000000 0 Artikel 65CEF4C3-9436-427D-A057-C1AB2DD14512 20.000000 0 1 160.000000 95A38013-5FA1-4EBC-9F78-D658D21F9926 1 0 0 0 50.000000 0 3AD19BF6-7AC1-4983-8DE3-18D57D022B2D 1130.000000 0 ArtikelUndLieferanten ED7C858C-AAC6-41CA-8792-A8821D8BB0F6 20.000000 0 1 160.000000 22210633-6D9C-4840-AA81-A1967318C19A 1 0 0 0 50.000000 0 3AD19BF6-7AC1-4983-8DE3-18D57D022B2D 1500.000000 0 Auftragspositionen F4359C9E-2D82-44E7-B5D8-441BA298D728 20.000000 0 1 160.000000 0F922174-E924-4B49-A56E-EE025F09CEBC 1 0 0 0 50.000000 0 3AD19BF6-7AC1-4983-8DE3-18D57D022B2D 20.000000 0 Aufträge 6E71CD33-6586-4A1C-A077-1A8781F8BC78 290.000000 0 1 160.000000 8FC28F8B-0D53-4424-9D9B-467E72A48C47 1 0 0 0 50.000000 0 3AD19BF6-7AC1-4983-8DE3-18D57D022B2D 390.000000 0 Kategorien 1F70C96B-BEBF-4CFF-B373-A8D7A771F43B 290.000000 0 1 160.000000 4518595D-F8BC-4B97-8CC8-A1CD81544291 1 0 0 0 50.000000 0 3AD19BF6-7AC1-4983-8DE3-18D57D022B2D 760.000000 0 Konstanten 856E358A-1179-41B6-A130-041F8F335B95 290.000000 0 1 160.000000 DED6B7FB-7120-4C87-A0C1-3347F49829B5 1 0 0 0 50.000000 0 3AD19BF6-7AC1-4983-8DE3-18D57D022B2D 1130.000000 0 Kunden F745690A-4DBD-4122-B7D5-408FD75E5C60 290.000000 0 1 160.000000 C167D7FA-B64B-4CEB-9743-2433939C3979 1 0 0 0 50.000000 0 3AD19BF6-7AC1-4983-8DE3-18D57D022B2D 1500.000000 0 Lieferanten 04E50E4E-6A13-41FB-839C-83B2BA8CC785 290.000000 0 1 160.000000 432DBE48-DB78-4139-A82A-747B6954C361 1 0 0 0 50.000000 0 3AD19BF6-7AC1-4983-8DE3-18D57D022B2D 20.000000 0 Mitarbeiter E777E719-A1D1-411D-9A52-222A9D542886 560.000000 0 1 160.000000 4E4910BD-EC73-4163-B85D-D9D5E05D65FD 1 0 0 0 50.000000 0 3AD19BF6-7AC1-4983-8DE3-18D57D022B2D 390.000000 0 Spediteure 2AAC722A-58E7-4BB2-A2E7-8A63696380BB 560.000000 0 1 160.000000 D3B087AF-73F5-46D3-82A6-5327DC23A6F6 blue 1 0 1 0 126.000000 0 3AD19BF6-7AC1-4983-8DE3-18D57D022B2D 314.000000 0 table_1 12CE4F21-5C5A-43BB-B44C-9EC1DC17744A 756.000000 0 1 160.000000 FE02CF3E-D7B9-4D02-9EF7-153FC2B059EE blue 1 0 1 0 126.000000 0 3AD19BF6-7AC1-4983-8DE3-18D57D022B2D 624.000000 0 table_2 BAD24137-B0D4-4638-B4D9-E7AD4458434B 755.000000 0 1 160.000000 20E331EA-5754-4DE9-86BD-5F0AC32869FD blue 1 0 1 0 126.000000 0 3AD19BF6-7AC1-4983-8DE3-18D57D022B2D 875.000000 0 table_3 3E570CFC-F8C7-4F5D-B41F-0B083797949C 756.000000 0 1 160.000000 7000.000000 3AD19BF6-7AC1-4983-8DE3-18D57D022B2D 7EF1D3E2-0023-4825-B462-40A9F8B008C1 B4A5BC6A-062F-4174-8CD5-B8990627C705 97CEFFC2-06C0-4950-A97B-AB1FFD17C448 95A38013-5FA1-4EBC-9F78-D658D21F9926 22210633-6D9C-4840-AA81-A1967318C19A 0F922174-E924-4B49-A56E-EE025F09CEBC 8FC28F8B-0D53-4424-9D9B-467E72A48C47 4518595D-F8BC-4B97-8CC8-A1CD81544291 DED6B7FB-7120-4C87-A0C1-3347F49829B5 C167D7FA-B64B-4CEB-9743-2433939C3979 432DBE48-DB78-4139-A82A-747B6954C361 4E4910BD-EC73-4163-B85D-D9D5E05D65FD D3B087AF-73F5-46D3-82A6-5327DC23A6F6 FE02CF3E-D7B9-4D02-9EF7-153FC2B059EE 20E331EA-5754-4DE9-86BD-5F0AC32869FD 0 0.000000 0.000000 root 349B21AE-F85A-44CA-8F3B-9EFC8CA8891D 0.000000 0 0.000000 Main View 349B21AE-F85A-44CA-8F3B-9EFC8CA8891D 3AD19BF6-7AC1-4983-8DE3-18D57D022B2D 10000.000000 0.000000 0.000000 1.000000 Workbench {6D75781B-52CF-4252-9B3D-9F28B75C09F7} 2