{B8A939B8-070D-4FCB-A159-C0FB0ECD3F17} {8A6DC5E1-C998-4CA2-B281-ED6FDB723546} {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 {C49BC34D-CE5D-4707-B013-1ECF456E1D5A} {1E7D4DE5-CB30-49B3-94E2-2E08335EA4DE} r2 r2 {CBCF703D-AEA8-4097-82B5-5BC35E1200FB} {06693B08-F38B-4EC2-80F3-91542DEE3C8C} {06872BF5-03AF-4537-8A90-55E91ABC8F43} 0 VARCHAR '' 0 0 36 kAddress_pk kAddress_pk {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {81EE2B1A-1678-4D94-813C-A0BB0B8BA336} 0 VARCHAR '' 0 1 45 cAddr1 cAddr1 {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {4D6113A8-37F5-4A64-8855-29D7CCCD1C67} 0 VARCHAR '' 0 1 45 cAddr2 cAddr2 {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {E38212EC-D573-478B-B338-8BA9A18BDE12} 0 VARCHAR '' 0 1 45 cCity cCity {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {87BB6022-1447-4140-AB01-E2B037AF2A6B} 0 CHAR '' 0 1 2 cState cState {4B160881-85B7-4C25-BBD1-36C9CA1A0E80} 0 {427BB8B9-7B2B-420D-A374-3292C31DD233} 0 VARCHAR '' 0 1 10 cZip cZip {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {4FBFE890-DA7B-4B8C-BF88-E01CC3A2B08C} 0 VARCHAR '' 0 1 20 cPhone cPhone {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {98BF3074-2B80-4EAD-958D-9394E6FCF775} 0 VARCHAR '' 0 1 60 cEmail cEmail {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {A55322B4-7172-4928-8E36-3D3D09639300} 0 VARCHAR '' 0 1 60 cAddrName cAddrName {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {25239DF6-262F-4091-BAD5-3E221C0336B9} 0 CHAR '' 0 1 1 cType cType {4B160881-85B7-4C25-BBD1-36C9CA1A0E80} 0 InnoDB free: 18432 kB {ADB8CF73-5DF4-4AEE-AA00-13EADF5D6D5E} {1D76149D-28BC-4A9E-BCA5-03050B6BFCAC} 0 0 0 kAddress_pk {ADB8CF73-5DF4-4AEE-AA00-13EADF5D6D5E} 0 {06872BF5-03AF-4537-8A90-55E91ABC8F43} 0 0 1 PRIMARY {06693B08-F38B-4EC2-80F3-91542DEE3C8C} 1 0 Address Address {1E7D4DE5-CB30-49B3-94E2-2E08335EA4DE} {ADB8CF73-5DF4-4AEE-AA00-13EADF5D6D5E} Dynamic CREATE TABLE `Address` ( `kAddress_pk` varchar(36) NOT NULL default '', `cAddr1` varchar(45) default '', `cAddr2` varchar(45) default '', `cCity` varchar(45) default '', `cState` char(2) default '', `cZip` varchar(10) default '', `cPhone` varchar(20) default '', `cEmail` varchar(60) default '', `cAddrName` varchar(60) default '', `cType` char(1) default '', PRIMARY KEY (`kAddress_pk`) ) TYPE=InnoDB InnoDB {987336FD-4C19-4790-B68E-DAB2B480C151} {13DF91D4-7287-42F9-A315-340BC205B84C} 0 VARCHAR '' 0 0 36 kProduct_pk kProduct_pk {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {464C073D-1A77-4EE5-B2F3-4077C3413D55} 0 VARCHAR '' 0 1 45 cSku cSku {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {0B4DDE19-E6AF-4D6B-8E1B-B1027D93A626} 0 DECIMAL '0.00' 0 0 yPrice yPrice 10 2 {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} 0 {E6C9739D-0294-4CB7-8885-CEC11B25C6D0} 0 VARCHAR '' 0 1 60 cProductName cProductName {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {7B19F436-3A42-4E6D-AA96-FD07860F3418} 0 MEDIUMBLOB 1 1 bUPC bUPC {EBCCD9D0-1497-4EEE-97FC-0C96DB3D2EBE} 0 {5FE7567D-FB10-4199-808B-E9E27007A938} 0 VARCHAR '' 0 1 12 cUpcNo cUpcNo {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {4536BC35-036C-426B-815E-B390A2A25A6C} 0 VARCHAR '' 0 1 65 cReciptDesc cReciptDesc {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {B971B6B1-A722-4AB3-B0E8-D4BE0D2D23A3} 0 VARCHAR '' 0 1 20 cManufactureID cManufactureID {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 InnoDB free: 18432 kB {1AF0F38E-104B-4901-8D39-B2B5EF0EF6D6} {771CCBFB-8EB1-4BB1-9E6D-AF3D084363F1} 0 0 0 kProduct_pk {1AF0F38E-104B-4901-8D39-B2B5EF0EF6D6} 0 {13DF91D4-7287-42F9-A315-340BC205B84C} 0 {DD2A9BE2-9E6A-4448-99AE-ADABEA650CEB} 0 0 0 yPrice {1AF0F38E-104B-4901-8D39-B2B5EF0EF6D6} 0 {0B4DDE19-E6AF-4D6B-8E1B-B1027D93A626} 0 0 1 PRIMARY {987336FD-4C19-4790-B68E-DAB2B480C151} 1 0 Product Product {1E7D4DE5-CB30-49B3-94E2-2E08335EA4DE} {1AF0F38E-104B-4901-8D39-B2B5EF0EF6D6} Dynamic CREATE TABLE `Product` ( `kProduct_pk` varchar(36) NOT NULL default '', `cSku` varchar(45) default '', `yPrice` decimal(10,2) NOT NULL default '0.00', `cProductName` varchar(60) default '', `bUPC` mediumblob, `cUpcNo` varchar(12) default '', `cReciptDesc` varchar(65) default '', `cManufactureID` varchar(20) default '', PRIMARY KEY (`kProduct_pk`,`yPrice`) ) TYPE=InnoDB InnoDB {5CF59D3B-0782-488F-96E7-7C93BA0195CD} {D67B373A-8314-460E-ADA2-34FE0FAC637C} 0 VARCHAR '' 0 0 36 kRebate_pk kRebate_pk {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {6B6EE456-CA69-4AE6-880E-0CE4A4602E09} 0 VARCHAR 1 1 36 kRebateOffer_fk kRebateOffer_fk {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {0E9F15CF-9826-4337-83A7-D37E9C35B92B} 0 VARCHAR 1 1 36 kReceipt_fk kReceipt_fk {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {98EDF544-AAF3-4496-B60A-FD5B2C6B80EE} 0 DATETIME 1 1 dSent dSent {9A2399C8-F3EA-4B6C-AAB1-830D3BFF164B} 0 {852F6468-C0D7-4349-8DBE-9C2C377C8A97} 0 DATETIME 1 1 dClosed dClosed {9A2399C8-F3EA-4B6C-AAB1-830D3BFF164B} 0 {B29E67B4-B17E-45F5-81DD-1760AA335969} 0 TEXT 1 1 cExtra cExtra {52734DB8-D81D-4593-A74C-891967DFAC63} 0 InnoDB free: 18432 kB {95F52F36-8AB1-4673-8FF9-D2A0CE24B698} {C6CF2695-AB3C-45B0-8A80-9E63B1167D1D} 0 kRebateOffer_fk {95F52F36-8AB1-4673-8FF9-D2A0CE24B698} {6B6EE456-CA69-4AE6-880E-0CE4A4602E09} UNIQUE BTREE kRebateOffer_fk kRebateOffer_fk {5CF59D3B-0782-488F-96E7-7C93BA0195CD} 1 {F3844214-8A49-46A6-8B49-F98D1ECE26AE} {F06FF76F-3E03-4945-BB4A-75CE70CA077C} 0 kReceipt_fk {F3844214-8A49-46A6-8B49-F98D1ECE26AE} {0E9F15CF-9826-4337-83A7-D37E9C35B92B} UNIQUE BTREE kReceipt_fk kReceipt_fk {5CF59D3B-0782-488F-96E7-7C93BA0195CD} 1 {801D6D10-245A-4C68-A048-D429FDCCAFC0} {9384596C-5EA5-4232-A903-A1B43162679C} 0 0 0 kRebate_pk {801D6D10-245A-4C68-A048-D429FDCCAFC0} 0 {D67B373A-8314-460E-ADA2-34FE0FAC637C} 0 0 1 PRIMARY {5CF59D3B-0782-488F-96E7-7C93BA0195CD} 1 0 Rebate Rebate {1E7D4DE5-CB30-49B3-94E2-2E08335EA4DE} {801D6D10-245A-4C68-A048-D429FDCCAFC0} Dynamic CREATE TABLE `Rebate` ( `kRebate_pk` varchar(36) NOT NULL default '', `kRebateOffer_fk` varchar(36) default NULL, `kReceipt_fk` varchar(36) default NULL, `dSent` datetime default NULL, `dClosed` datetime default NULL, `cExtra` text, PRIMARY KEY (`kRebate_pk`), KEY `kRebateOffer_fk` (`kRebateOffer_fk`), KEY `kReceipt_fk` (`kReceipt_fk`) ) TYPE=InnoDB InnoDB {D22439FE-2F44-4602-B6FE-7FD67C05B181} {5C2E8C8B-EC8D-4A83-8BA9-037FF0CA294C} 0 VARCHAR '' 0 0 36 kRebateOffer_pk kRebateOffer_pk {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {256BBD33-ADF1-483C-86C4-682C23E2BD0A} 0 VARCHAR 1 1 36 kAddress_fk kAddress_fk {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {F1F807B1-6E76-4F44-A321-EFB215FF37F6} 0 VARCHAR 1 1 36 kProduct_fk kProduct_fk {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {6E3825B7-1E2E-4080-818D-EB9D4DAA9F0C} 0 TINYINT 1 1 lOriginalUPC lOriginalUPC 1 0 {3C75C19F-FCA4-44DE-8881-F477FEA32E62} 0 {1D731BEE-2353-4D12-A427-02E9548947DE} 0 VARCHAR '' 0 1 65 cAddr1Part2 cAddr1Part2 {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {7114E705-AAE9-4955-8EE4-552B5A627B85} 0 DECIMAL 1 1 yRebateAmount yRebateAmount 10 0 {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} 0 {B699D324-D2CE-451A-A1F2-C57C01064C83} 0 VARCHAR '' 0 1 65 cAddr2Part2 cAddr2Part2 {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {9CC0FC02-DDCA-4B17-807A-06A7C6BBF99E} 0 VARCHAR '' 0 1 65 cAddrNamePart2 cAddrNamePart2 {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {739BAFEA-EFA9-4AD9-8190-CD717D7B0A69} 0 VARCHAR '' 0 1 5 cAddrZipPart2 cAddrZipPart2 {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {F0D13B9B-8F1C-448F-889C-B354AA539897} 0 VARCHAR '' 0 1 30 cOfferID cOfferID {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {7033F5B4-1BC6-48E3-9CD4-8500E3D52DA7} 0 VARCHAR '' 0 1 65 cPromoDesc cPromoDesc {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {2B96F0FE-F047-4285-8A86-6C8411A48830} 0 TEXT 1 1 cExtra cExtra {52734DB8-D81D-4593-A74C-891967DFAC63} 0 InnoDB free: 18432 kB {2DF6C709-CDFB-49CA-9B06-B8F8896BD50E} {18118F5A-2189-4242-8DEC-BA5D10BBC6F4} 0 kProduct_fk {2DF6C709-CDFB-49CA-9B06-B8F8896BD50E} {F1F807B1-6E76-4F44-A321-EFB215FF37F6} UNIQUE BTREE kproduct_fk kproduct_fk {D22439FE-2F44-4602-B6FE-7FD67C05B181} 1 {30B80916-1F45-494C-AA33-61CFE421DC3D} {6ACD795D-AE85-4260-9A83-415450CDA56C} 0 kAddress_fk {30B80916-1F45-494C-AA33-61CFE421DC3D} {256BBD33-ADF1-483C-86C4-682C23E2BD0A} UNIQUE BTREE kaddress_fk kaddress_fk {D22439FE-2F44-4602-B6FE-7FD67C05B181} 1 {13B36BD3-3D94-436D-803B-E36813C776B5} {FFB46A3F-110C-4E37-9622-AE081F57995D} 0 0 0 kRebateOffer_pk {13B36BD3-3D94-436D-803B-E36813C776B5} 0 {5C2E8C8B-EC8D-4A83-8BA9-037FF0CA294C} 0 0 1 PRIMARY {D22439FE-2F44-4602-B6FE-7FD67C05B181} 1 0 RebateOffer RebateOffer {1E7D4DE5-CB30-49B3-94E2-2E08335EA4DE} {13B36BD3-3D94-436D-803B-E36813C776B5} Dynamic CREATE TABLE `RebateOffer` ( `kRebateOffer_pk` varchar(36) NOT NULL default '', `kAddress_fk` varchar(36) default NULL, `kProduct_fk` varchar(36) default NULL, `lOriginalUPC` tinyint(1) default NULL, `cAddr1Part2` varchar(65) default '', `yRebateAmount` decimal(10,0) default NULL, `cAddr2Part2` varchar(65) default '', `cAddrNamePart2` varchar(65) default '', `cAddrZipPart2` varchar(5) default '', `cOfferID` varchar(30) default '', `cPromoDesc` varchar(65) default '', `cExtra` text, PRIMARY KEY (`kRebateOffer_pk`), KEY `kproduct_fk` (`kProduct_fk`), KEY `kaddress_fk` (`kAddress_fk`) ) TYPE=InnoDB InnoDB {81D62003-79E5-4FF0-A8F9-F51EF6AA778D} {C54516AD-0170-4D2F-B314-40E3D37AD399} 0 VARCHAR '' 0 0 36 kReceipt_pk kReceipt_pk {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {477FD1EB-5D65-4573-8347-F865571EC071} 0 VARCHAR 1 1 36 kAddress_fk kAddress_fk {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} 0 {31298BC4-AAB9-4827-A9D2-D0058D310F74} 0 DATETIME 1 1 dPurchaceDate dPurchaceDate {9A2399C8-F3EA-4B6C-AAB1-830D3BFF164B} 0 {26FA996C-9B41-4F63-BD09-D28D33A50777} 0 TEXT 1 1 cOCR cOCR {52734DB8-D81D-4593-A74C-891967DFAC63} 0 {B264C14E-E2D6-42C1-8F78-5EC2A44B6DF3} 0 DECIMAL 1 1 yTotal yTotal 10 2 {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} 0 {B3EFC6D8-779A-4FEF-8360-FE53F941F9BE} 0 MEDIUMBLOB 1 1 bReciptImage bReciptImage {EBCCD9D0-1497-4EEE-97FC-0C96DB3D2EBE} 0 InnoDB free: 18432 kB {D0AC571D-F417-4311-9178-DE46B9C83267} {5DF82E08-2774-407C-8BED-3275EC29AF4A} 0 kAddress_fk {D0AC571D-F417-4311-9178-DE46B9C83267} {477FD1EB-5D65-4573-8347-F865571EC071} UNIQUE BTREE kAddress_fk kAddress_fk {81D62003-79E5-4FF0-A8F9-F51EF6AA778D} 1 {C0ADE801-4237-4D46-BB9D-11CB3C12EE73} {F332ADD3-B1B5-45A9-96D7-D47509606E9C} 0 0 0 kReceipt_pk {C0ADE801-4237-4D46-BB9D-11CB3C12EE73} 0 {C54516AD-0170-4D2F-B314-40E3D37AD399} 0 0 1 PRIMARY {81D62003-79E5-4FF0-A8F9-F51EF6AA778D} 1 0 Receipt Receipt {1E7D4DE5-CB30-49B3-94E2-2E08335EA4DE} {C0ADE801-4237-4D46-BB9D-11CB3C12EE73} Dynamic CREATE TABLE `Receipt` ( `kReceipt_pk` varchar(36) NOT NULL default '', `kAddress_fk` varchar(36) default NULL, `dPurchaceDate` datetime default NULL, `cOCR` text, `yTotal` decimal(10,2) default NULL, `bReciptImage` mediumblob, PRIMARY KEY (`kReceipt_pk`), KEY `kAddress_fk` (`kAddress_fk`) ) TYPE=InnoDB 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} {A10F586A-55DB-4054-91F7-0436E13A1B15} {55A215D5-BEC4-4428-880A-0E7F02503344} {BEE158C0-73AA-44F5-801A-8C3D2D4F7DC8} Marker10 {B7D36A46-8CDD-4238-BBB1-0D0AF9FCF3EA} 0 0 0.750000 {11317F93-73E1-429A-B475-98E7ABB91193} Marker10 {55A215D5-BEC4-4428-880A-0E7F02503344} 0 0 0.750000 {CA433218-25CB-4240-8134-363754C51C16} New Model Properties {A10F586A-55DB-4054-91F7-0436E13A1B15} Name of the project 1.0 Workbench {6D75781B-52CF-4252-9B3D-9F28B75C09F7} 2