SQL Queries
New_Network
DatabaseCreation.zipschema.mwb
document.mwb.xml
{728278C5-55F1-45E6-AC76-93E40750D3FD} 0 0 0 1 -1 -1 -1 com.mysql.rdbms.mysql.datatype.int idinventory idinventory {0BCC4F17-4A7A-44DB-AE4E-8BCF8DEF9FF9} 0 0 0 45 -1 -1 com.mysql.rdbms.mysql.datatype.varchar item_name item_name {0BCC4F17-4A7A-44DB-AE4E-8BCF8DEF9FF9} 0 0 0 -1 -1 -1 com.mysql.rdbms.mysql.datatype.double buy_price buy_price {0BCC4F17-4A7A-44DB-AE4E-8BCF8DEF9FF9} 0 0 0 -1 -1 -1 com.mysql.rdbms.mysql.datatype.double sell_price sell_price {0BCC4F17-4A7A-44DB-AE4E-8BCF8DEF9FF9} 0 0 0 -1 -1 -1 com.mysql.rdbms.mysql.datatype.int quantity quantity {0BCC4F17-4A7A-44DB-AE4E-8BCF8DEF9FF9} 0 0 0 {8F41BC05-77A1-4410-813E-E6768C6BA26B} {EDC892A8-78A8-4A7B-BFFD-B5415B40C979} 0 0 PRIMARY 1 PRIMARY 0 PRIMARY {0BCC4F17-4A7A-44DB-AE4E-8BCF8DEF9FF9} 0 {EDC892A8-78A8-4A7B-BFFD-B5415B40C979} 0 InnoDB 0 0 0 0 2017-08-21 09:01 2017-08-21 09:01 0 inventory {8FC16886-12DD-4889-93C0-A3677E73CE3D} inventory 0 0 0 1 -1 -1 -1 com.mysql.rdbms.mysql.datatype.int idcustomer idcustomer {7ADE4993-6DD3-445A-99FC-6944259F49B7} 0 0 0 45 -1 -1 com.mysql.rdbms.mysql.datatype.varchar cust_name cust_name {7ADE4993-6DD3-445A-99FC-6944259F49B7} 0 0 0 45 -1 -1 com.mysql.rdbms.mysql.datatype.varchar city city {7ADE4993-6DD3-445A-99FC-6944259F49B7} 0 0 0 45 -1 -1 com.mysql.rdbms.mysql.datatype.varchar state state {7ADE4993-6DD3-445A-99FC-6944259F49B7} 0 0 0 45 -1 -1 com.mysql.rdbms.mysql.datatype.varchar mobile_numb mobile_numb {7ADE4993-6DD3-445A-99FC-6944259F49B7} 0 0 0 {613A78F9-F91C-4F44-8F11-7AFA88B76E94} {5A17A4E3-70C1-491A-A284-74AE392983A4} 0 0 PRIMARY 1 PRIMARY 0 PRIMARY {7ADE4993-6DD3-445A-99FC-6944259F49B7} 0 {5A17A4E3-70C1-491A-A284-74AE392983A4} 0 InnoDB 0 0 0 0 2017-08-21 09:02 2017-08-21 09:02 0 customer {8FC16886-12DD-4889-93C0-A3677E73CE3D} customer 0 0 0 1 -1 -1 -1 com.mysql.rdbms.mysql.datatype.int idsale idsale {CF52D2FD-1554-4B77-83F6-AC503F267046} 0 0 0 -1 -1 -1 com.mysql.rdbms.mysql.datatype.int quantity quantity {CF52D2FD-1554-4B77-83F6-AC503F267046} 0 0 0 -1 -1 -1 com.mysql.rdbms.mysql.datatype.date date_sale date_sale {CF52D2FD-1554-4B77-83F6-AC503F267046} 0 0 1 -1 -1 -1 com.mysql.rdbms.mysql.datatype.int customer customer {CF52D2FD-1554-4B77-83F6-AC503F267046} 0 0 1 -1 -1 -1 com.mysql.rdbms.mysql.datatype.int item item {CF52D2FD-1554-4B77-83F6-AC503F267046} 0 {7ADE4993-6DD3-445A-99FC-6944259F49B7} {9E02E15A-3FE4-489A-A464-5BFB72A52A11} 0 NO ACTION {91006021-CF14-451A-90B7-70EB37C96EA1} 1 1 0 {CF52D2FD-1554-4B77-83F6-AC503F267046} {613A78F9-F91C-4F44-8F11-7AFA88B76E94} 1 NO ACTION fk_sale_customer1 fk_sale_customer1 {0BCC4F17-4A7A-44DB-AE4E-8BCF8DEF9FF9} {D16DE0A0-5D97-4AD8-AC7B-A8D7EDE3854E} 0 NO ACTION {36753318-8FD1-40CC-BEE2-F6B608167926} 1 1 0 {CF52D2FD-1554-4B77-83F6-AC503F267046} {8F41BC05-77A1-4410-813E-E6768C6BA26B} 1 NO ACTION fk_sale_inventory1 fk_sale_inventory1 0 0 {714C1CA0-1BEC-4E57-A7A8-7318BE5E1020} {457CB25A-68D4-41FB-B605-FC3BE08692F7} 0 0 PRIMARY 1 PRIMARY 0 PRIMARY {CF52D2FD-1554-4B77-83F6-AC503F267046} 0 0 {9E02E15A-3FE4-489A-A464-5BFB72A52A11} {91006021-CF14-451A-90B7-70EB37C96EA1} 0 0 INDEX 0 fk_sale_customer1_idx 0 fk_sale_customer1_idx {CF52D2FD-1554-4B77-83F6-AC503F267046} 0 0 {D16DE0A0-5D97-4AD8-AC7B-A8D7EDE3854E} {36753318-8FD1-40CC-BEE2-F6B608167926} 0 0 INDEX 0 fk_sale_inventory1_idx 0 fk_sale_inventory1_idx {CF52D2FD-1554-4B77-83F6-AC503F267046} 0 {457CB25A-68D4-41FB-B605-FC3BE08692F7} 0 InnoDB 0 0 0 0 2017-08-21 09:02 2017-08-21 10:03 0 sale {8FC16886-12DD-4889-93C0-A3677E73CE3D} sale 0 0 0 1 -1 -1 -1 com.mysql.rdbms.mysql.datatype.int idsupplier idsupplier {06D530FC-069B-4C29-A690-1E92AA15CE28} 0 0 0 45 -1 -1 com.mysql.rdbms.mysql.datatype.varchar sup_name sup_name {06D530FC-069B-4C29-A690-1E92AA15CE28} 0 0 0 45 -1 -1 com.mysql.rdbms.mysql.datatype.varchar mobile_number mobile_number {06D530FC-069B-4C29-A690-1E92AA15CE28} 0 0 0 45 -1 -1 com.mysql.rdbms.mysql.datatype.varchar Address Address {06D530FC-069B-4C29-A690-1E92AA15CE28} 0 0 1 -1 -1 -1 com.mysql.rdbms.mysql.datatype.int item item {06D530FC-069B-4C29-A690-1E92AA15CE28} 0 {0BCC4F17-4A7A-44DB-AE4E-8BCF8DEF9FF9} {D9C4E123-A890-4F6A-90B4-E00AE3BADA55} 0 NO ACTION {32A760D5-249C-4825-90A4-B5373CCE9DA0} 1 1 0 {06D530FC-069B-4C29-A690-1E92AA15CE28} {8F41BC05-77A1-4410-813E-E6768C6BA26B} 1 NO ACTION fk_supplier_inventory1 fk_supplier_inventory1 0 0 {1DF916EE-C4FF-46BA-850D-80219309670C} {C4E96C9B-4887-4588-B8D8-E757413EE5D9} 0 0 PRIMARY 1 PRIMARY 0 PRIMARY {06D530FC-069B-4C29-A690-1E92AA15CE28} 0 0 {D9C4E123-A890-4F6A-90B4-E00AE3BADA55} {32A760D5-249C-4825-90A4-B5373CCE9DA0} 0 0 INDEX 0 fk_supplier_inventory1_idx 0 fk_supplier_inventory1_idx {06D530FC-069B-4C29-A690-1E92AA15CE28} 0 {C4E96C9B-4887-4588-B8D8-E757413EE5D9} 0 InnoDB 0 0 0 0 2017-08-21 09:04 2017-09-12 07:39 0 supplier {8FC16886-12DD-4889-93C0-A3677E73CE3D} supplier 0 0 0 1 -1 -1 -1 com.mysql.rdbms.mysql.datatype.int idpurchase_order idpurchase_order {C8A00FCD-11FE-4BB3-90E6-C07600A2BE14} 0 0 0 -1 -1 -1 com.mysql.rdbms.mysql.datatype.date date_pur date_pur {C8A00FCD-11FE-4BB3-90E6-C07600A2BE14} 0 0 0 -1 -1 -1 com.mysql.rdbms.mysql.datatype.int quantity quantity {C8A00FCD-11FE-4BB3-90E6-C07600A2BE14} 0 0 0 -1 -1 -1 com.mysql.rdbms.mysql.datatype.double buy_price buy_price {C8A00FCD-11FE-4BB3-90E6-C07600A2BE14} 0 0 1 -1 -1 -1 com.mysql.rdbms.mysql.datatype.int supplier supplier {C8A00FCD-11FE-4BB3-90E6-C07600A2BE14} 0 0 1 -1 -1 -1 com.mysql.rdbms.mysql.datatype.int item item {C8A00FCD-11FE-4BB3-90E6-C07600A2BE14} 0 {06D530FC-069B-4C29-A690-1E92AA15CE28} {831140F7-B44D-471F-B574-B4A09A0B79E7} 0 NO ACTION {D1562DE8-F824-498C-9FD3-34E54105F511} 1 1 0 {C8A00FCD-11FE-4BB3-90E6-C07600A2BE14} {1DF916EE-C4FF-46BA-850D-80219309670C} 1 NO ACTION fk_purchase_order_supplier fk_purchase_order_supplier {0BCC4F17-4A7A-44DB-AE4E-8BCF8DEF9FF9} {FC575109-B482-4E89-BDF9-C3B124E564B3} 0 NO ACTION {42365AC5-78FD-425E-B4C7-EBD3EC39CE9C} 1 1 0 {C8A00FCD-11FE-4BB3-90E6-C07600A2BE14} {8F41BC05-77A1-4410-813E-E6768C6BA26B} 1 NO ACTION fk_purchase_order_inventory1 fk_purchase_order_inventory1 0 0 {336A922D-12F4-4CA9-888E-37177C0AC7C3} {9887698E-75D9-4DE2-8AED-565186E425F4} 0 0 PRIMARY 1 PRIMARY 0 PRIMARY {C8A00FCD-11FE-4BB3-90E6-C07600A2BE14} 0 0 {831140F7-B44D-471F-B574-B4A09A0B79E7} {D1562DE8-F824-498C-9FD3-34E54105F511} 0 0 INDEX 0 fk_purchase_order_supplier_idx 0 fk_purchase_order_supplier_idx {C8A00FCD-11FE-4BB3-90E6-C07600A2BE14} 0 0 {FC575109-B482-4E89-BDF9-C3B124E564B3} {42365AC5-78FD-425E-B4C7-EBD3EC39CE9C} 0 0 INDEX 0 fk_purchase_order_inventory1_idx 0 fk_purchase_order_inventory1_idx {C8A00FCD-11FE-4BB3-90E6-C07600A2BE14} 0 {9887698E-75D9-4DE2-8AED-565186E425F4} 0 InnoDB 0 0 0 0 2017-08-21 09:08 2017-08-21 10:02 0 purchase_order {8FC16886-12DD-4889-93C0-A3677E73CE3D} purchase_order utf8 utf8_general_ci 0 0 mydb {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} mydb com.mysql.rdbms.mysql.charset.big5 com.mysql.rdbms.mysql.charset.dec8 com.mysql.rdbms.mysql.charset.cp850 com.mysql.rdbms.mysql.charset.hp8 com.mysql.rdbms.mysql.charset.koi8r com.mysql.rdbms.mysql.charset.latin1 com.mysql.rdbms.mysql.charset.latin2 com.mysql.rdbms.mysql.charset.swe7 com.mysql.rdbms.mysql.charset.ascii com.mysql.rdbms.mysql.charset.ujis com.mysql.rdbms.mysql.charset.sjis com.mysql.rdbms.mysql.charset.hebrew com.mysql.rdbms.mysql.charset.tis620 com.mysql.rdbms.mysql.charset.euckr com.mysql.rdbms.mysql.charset.koi8u com.mysql.rdbms.mysql.charset.gb2312 com.mysql.rdbms.mysql.charset.greek com.mysql.rdbms.mysql.charset.cp1250 com.mysql.rdbms.mysql.charset.gbk com.mysql.rdbms.mysql.charset.latin5 com.mysql.rdbms.mysql.charset.asmscii8 com.mysql.rdbms.mysql.charset.utf8 com.mysql.rdbms.mysql.charset.ucs2 com.mysql.rdbms.mysql.charset.cp866 com.mysql.rdbms.mysql.charset.keybcs2 com.mysql.rdbms.mysql.charset.macce com.mysql.rdbms.mysql.charset.macroman com.mysql.rdbms.mysql.charset.cp852 com.mysql.rdbms.mysql.charset.latin7 com.mysql.rdbms.mysql.charset.cp1251 com.mysql.rdbms.mysql.charset.cp1256 com.mysql.rdbms.mysql.charset.cp1257 com.mysql.rdbms.mysql.charset.binary com.mysql.rdbms.mysql.charset.geostd8 com.mysql.rdbms.mysql.charset.cp932 com.mysql.rdbms.mysql.charset.eucjpms com.mysql.rdbms.mysql.charset.utf8mb4 com.mysql.rdbms.mysql.charset.utf16 com.mysql.rdbms.mysql.charset.utf32 {8FC16886-12DD-4889-93C0-A3677E73CE3D} **.* SCHEMA ALL {171E5018-759F-406B-AF8B-F9BBE262A89C} 0 0 owner {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} **.* TABLE SELECT {E5302897-D0A4-4C55-B054-86DD014242AF} 0 0 table.readonly {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} **.* TABLE SELECT INSERT TRIGGER {D50791CD-DE9F-4290-AED9-1A18FDB37CA8} 0 0 table.insert {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} **.* TABLE SELECT INSERT TRIGGER UPDATE DELETE {69DA1F8D-370B-4054-B4E3-78270CC19B93} 0 0 table.modify {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} **.* ROUTINE EXECUTE {94266D92-5DA2-4DAE-8EA8-9441DC6DDD75} 0 0 routine.execute {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} com.mysql.rdbms.mysql.datatype.tinyint com.mysql.rdbms.mysql.datatype.smallint com.mysql.rdbms.mysql.datatype.mediumint com.mysql.rdbms.mysql.datatype.int com.mysql.rdbms.mysql.datatype.bigint com.mysql.rdbms.mysql.datatype.float com.mysql.rdbms.mysql.datatype.double com.mysql.rdbms.mysql.datatype.decimal com.mysql.rdbms.mysql.datatype.char com.mysql.rdbms.mysql.datatype.varchar com.mysql.rdbms.mysql.datatype.binary com.mysql.rdbms.mysql.datatype.varbinary com.mysql.rdbms.mysql.datatype.tinytext com.mysql.rdbms.mysql.datatype.text com.mysql.rdbms.mysql.datatype.mediumtext com.mysql.rdbms.mysql.datatype.longtext com.mysql.rdbms.mysql.datatype.tinyblob com.mysql.rdbms.mysql.datatype.blob com.mysql.rdbms.mysql.datatype.mediumblob com.mysql.rdbms.mysql.datatype.longblob com.mysql.rdbms.mysql.datatype.datetime com.mysql.rdbms.mysql.datatype.datetime_f com.mysql.rdbms.mysql.datatype.date com.mysql.rdbms.mysql.datatype.time com.mysql.rdbms.mysql.datatype.time_f com.mysql.rdbms.mysql.datatype.year com.mysql.rdbms.mysql.datatype.timestamp com.mysql.rdbms.mysql.datatype.timestamp_f com.mysql.rdbms.mysql.datatype.geometry com.mysql.rdbms.mysql.datatype.point com.mysql.rdbms.mysql.datatype.curve com.mysql.rdbms.mysql.datatype.linestring com.mysql.rdbms.mysql.datatype.line com.mysql.rdbms.mysql.datatype.linearring com.mysql.rdbms.mysql.datatype.surface com.mysql.rdbms.mysql.datatype.polygon com.mysql.rdbms.mysql.datatype.geometrycollection com.mysql.rdbms.mysql.datatype.multipoint com.mysql.rdbms.mysql.datatype.multicurve com.mysql.rdbms.mysql.datatype.multilinestring com.mysql.rdbms.mysql.datatype.multisurface com.mysql.rdbms.mysql.datatype.multipolygon com.mysql.rdbms.mysql.datatype.bit com.mysql.rdbms.mysql.datatype.enum com.mysql.rdbms.mysql.datatype.set com.mysql.rdbms.mysql.datatype.tinyint TINYINT(1) BOOL {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} com.mysql.rdbms.mysql.datatype.tinyint TINYINT(1) BOOLEAN {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} com.mysql.rdbms.mysql.datatype.decimal DECIMAL(10,0) FIXED {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} com.mysql.rdbms.mysql.datatype.float FLOAT FLOAT4 {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} com.mysql.rdbms.mysql.datatype.double DOUBLE FLOAT8 {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} com.mysql.rdbms.mysql.datatype.tinyint TINYINT(4) INT1 {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} com.mysql.rdbms.mysql.datatype.smallint SMALLINT(6) INT2 {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} com.mysql.rdbms.mysql.datatype.mediumint MEDIUMINT(9) INT3 {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} com.mysql.rdbms.mysql.datatype.int INT(11) INT4 {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} com.mysql.rdbms.mysql.datatype.bigint BIGINT(20) INT8 {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} com.mysql.rdbms.mysql.datatype.int INT(11) INTEGER {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} com.mysql.rdbms.mysql.datatype.mediumblob MEDIUMBLOB LONG VARBINARY {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} com.mysql.rdbms.mysql.datatype.mediumtext MEDIUMTEXT LONG VARCHAR {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} com.mysql.rdbms.mysql.datatype.mediumtext MEDIUMTEXT LONG {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} com.mysql.rdbms.mysql.datatype.mediumint MEDIUMINT(9) MIDDLEINT {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} com.mysql.rdbms.mysql.datatype.decimal DECIMAL(10,0) NUMERIC {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} com.mysql.rdbms.mysql.datatype.decimal DECIMAL(10,0) DEC {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} com.mysql.rdbms.mysql.datatype.char CHAR(1) CHARACTER {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} -1 5 5 -1 0 Version {359DA060-0C52-4C7D-80C0-65FF8EC80EFF} default default {3023A9F7-206E-427E-B7D3-637B9190B992} crowsfoot 0 fk_purchase_order_supplier 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 {B5FC3299-435B-4405-85DA-2C3014FD5823} 0.e+000 0.e+000 0.e+000 0 {954422EB-1BC2-4E94-B5A3-84F63B564789} {7BCC3BDA-E825-4D92-8E01-1A30C32B21E5} {5211BE5B-9563-4F61-B78C-012F8C5177AD} 1 fk_sale_customer1 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 {06A45B85-D47F-49BF-B705-B34D46E22E0F} 0.e+000 0.e+000 0.e+000 0 {1D793951-458D-4EA4-BDB6-D7DB579AEADA} {9A6738AC-05CE-429F-99C5-FE344BAD591A} {5211BE5B-9563-4F61-B78C-012F8C5177AD} 1 fk_sale_inventory1 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 {61EB58DA-B275-4CA0-B804-E5E1312D7FD5} 0.e+000 0.e+000 0.e+000 0 {6851AA92-4CFB-4194-99D1-867C904706EF} {9A6738AC-05CE-429F-99C5-FE344BAD591A} {5211BE5B-9563-4F61-B78C-012F8C5177AD} 1 fk_supplier_inventory1 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 {454493D2-1553-4FF6-AB74-2F6642900F86} 0.e+000 0.e+000 0.e+000 0 {6851AA92-4CFB-4194-99D1-867C904706EF} {954422EB-1BC2-4E94-B5A3-84F63B564789} {5211BE5B-9563-4F61-B78C-012F8C5177AD} 1 fk_purchase_order_inventory1 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 {6C89E3F7-EB57-4980-9C1E-620CC839A8C0} 0.e+000 0.e+000 0.e+000 0 {6851AA92-4CFB-4194-99D1-867C904706EF} {7BCC3BDA-E825-4D92-8E01-1A30C32B21E5} {5211BE5B-9563-4F61-B78C-012F8C5177AD} 1 1 0 0 -1 {0BCC4F17-4A7A-44DB-AE4E-8BCF8DEF9FF9} 0 #98BFDA 1 1.62e+002 {8E5D0A5C-F852-45E0-B0EE-8158AD9CAA23} 2.54e+002 0 0 2.01e+002 1.47e+002 {5211BE5B-9563-4F61-B78C-012F8C5177AD} 1 inventory 1 0 0 -1 {7ADE4993-6DD3-445A-99FC-6944259F49B7} 0 #98BFDA 1 1.62e+002 {8E5D0A5C-F852-45E0-B0EE-8158AD9CAA23} 1.45e+002 0 0 3.89e+002 1.59e+002 {5211BE5B-9563-4F61-B78C-012F8C5177AD} 1 customer 1 0 0 -1 {CF52D2FD-1554-4B77-83F6-AC503F267046} 0 #98BFDA 1 1.62e+002 {8E5D0A5C-F852-45E0-B0EE-8158AD9CAA23} 3.9e+001 0 0 2.1e+002 9.8e+001 {5211BE5B-9563-4F61-B78C-012F8C5177AD} 1 sale 1 0 0 -1 {06D530FC-069B-4C29-A690-1E92AA15CE28} 0 #98BFDA 1 1.62e+002 {8E5D0A5C-F852-45E0-B0EE-8158AD9CAA23} 3.65e+002 0 0 5.52e+002 1.68e+002 {5211BE5B-9563-4F61-B78C-012F8C5177AD} 1 supplier 1 0 0 -1 {C8A00FCD-11FE-4BB3-90E6-C07600A2BE14} 0 #98BFDA 1 2.22e+002 {8E5D0A5C-F852-45E0-B0EE-8158AD9CAA23} 6.93e+002 0 1 2.99e+002 1.45e+002 {5211BE5B-9563-4F61-B78C-012F8C5177AD} 1 purchase_order 1.38095e+003 EER Diagram {3023A9F7-206E-427E-B7D3-637B9190B992} {6851AA92-4CFB-4194-99D1-867C904706EF} {1D793951-458D-4EA4-BDB6-D7DB579AEADA} {9A6738AC-05CE-429F-99C5-FE344BAD591A} {954422EB-1BC2-4E94-B5A3-84F63B564789} {7BCC3BDA-E825-4D92-8E01-1A30C32B21E5} 1.38095e+003 0.e+000 0.e+000 1.9720000000000002e+003 {5211BE5B-9563-4F61-B78C-012F8C5177AD} 1 0 1.9720000000000002e+003 0.e+000 0.e+000 1.e+000 workbench/default com.mysql.rdbms.mysql Business Rule {3023A9F7-206E-427E-B7D3-637B9190B992} {5211BE5B-9563-4F61-B78C-012F8C5177AD} {728278C5-55F1-45E6-AC76-93E40750D3FD} 0 0 0 0 0 0 0 0 0 0 rtracy New Model 2017-09-12 08:12 2017-08-21 09:00 Name of the project 1.0 Properties {728278C5-55F1-45E6-AC76-93E40750D3FD} 1.4460000000000001e+001 6.3499999999999996e+000 6.3499999999999996e+000 6.3499999999999996e+000 portrait com.mysql.wb.papertype.a4 5.e+000 {728278C5-55F1-45E6-AC76-93E40750D3FD}
lock
6408
@db/data.db
Database Creation.docx
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
USE `mydb` ;
-- -----------------------------------------------------
-- Table `mydb`.`inventory`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`inventory` (
`item_number` INT NOT NULL ,
`title` VARCHAR(45) NULL ,
`price` DOUBLE NULL ,
`timestamp` TIMESTAMP NULL ,
PRIMARY KEY (`item_number`) )
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`cart_detail`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`cart_detail` (
`cart_id` INT NOT NULL ,
`timestamp` TIMESTAMP NULL ,
`quantity` INT NULL ,
`inventory_item_number` INT NOT NULL ,
PRIMARY KEY (`cart_id`) ,
INDEX `fk_cart_detail_inventory_idx` (`inventory_item_number` ASC) ,
CONSTRAINT `fk_cart_detail_inventory`
FOREIGN KEY (`inventory_item_number` )
REFERENCES `mydb`.`inventory` (`item_number` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`order`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`order` (
`order_id` INT NOT NULL ,
`quantity` INT NULL ,
`item_number` INT NULL ,
`inventory_item_number` INT NOT NULL ,
PRIMARY KEY (`order_id`) ,
INDEX `fk_order_inventory1_idx` (`inventory_item_number` ASC) ,
CONSTRAINT `fk_order_inventory1`
FOREIGN KEY (`inventory_item_number` )
REFERENCES `mydb`.`inventory` (`item_number` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`user_account`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`user_account` (
`account_number` INT NOT NULL ,
`user_id` INT NULL ,
`timestamp` TIMESTAMP NULL ,
`visits` INT NULL ,
`transaction_number` INT NULL ,
PRIMARY KEY (`account_number`) )
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`address`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`address` (
`address_number` INT NOT NULL ,
`name` VARCHAR(45) NULL ,
`address_1` VARCHAR(45) NULL ,
`address_2` VARCHAR(45) NULL ,
`city` VARCHAR(45) NULL ,
`state` VARCHAR(45) NULL ,
`zipcode` INT NULL ,
PRIMARY KEY (`address_number`) )
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`credit_card`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`credit_card` (
`card_id` INT NOT NULL ,
`card_number` INT NULL ,
`holder_name` VARCHAR(45) NULL ,
`expiring_date` DATE NULL ,
PRIMARY KEY (`card_id`) )
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`user_session`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`user_session` (
`session_number` INT NOT NULL ,
`ip_address` VARCHAR(45) NULL ,
`number_of_clicks` INT NULL ,
`timestamp` INT NULL ,
`address_address_number` INT NOT NULL ,
`credit_card_card_id` INT NOT NULL ,
PRIMARY KEY (`session_number`) ,
INDEX `fk_user_session_address1_idx` (`address_address_number` ASC) ,
INDEX `fk_user_session_credit_card1_idx` (`credit_card_card_id` ASC) ,
CONSTRAINT `fk_user_session_address1`
FOREIGN KEY (`address_address_number` )
REFERENCES `mydb`.`address` (`address_number` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_user_session_credit_card1`
FOREIGN KEY (`credit_card_card_id` )
REFERENCES `mydb`.`credit_card` (`card_id` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`payment`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`payment` (
`payment_number` INT NOT NULL ,
`amount` DOUBLE NULL ,
`state` VARCHAR(45) NULL ,
`timestamp` TIMESTAMP NULL ,
`user_account_account_number` INT NOT NULL ,
PRIMARY KEY (`payment_number`) ,
INDEX `fk_payment_user_account1_idx` (`user_account_account_number` ASC) ,
CONSTRAINT `fk_payment_user_account1`
FOREIGN KEY (`user_account_account_number` )
REFERENCES `mydb`.`user_account` (`account_number` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`shopping_cart`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`shopping_cart` (
`cart_number` INT NOT NULL ,
`active_status` BIT NULL ,
`expiring_date` DATE NULL ,
`user_account_account_number` INT NOT NULL ,
`inventory_item_number` INT NOT NULL ,
PRIMARY KEY (`cart_number`) ,
INDEX `fk_shopping_cart_user_account1_idx` (`user_account_account_number` ASC) ,
INDEX `fk_shopping_cart_inventory1_idx` (`inventory_item_number` ASC) ,
CONSTRAINT `fk_shopping_cart_user_account1`
FOREIGN KEY (`user_account_account_number` )
REFERENCES `mydb`.`user_account` (`account_number` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_shopping_cart_inventory1`
FOREIGN KEY (`inventory_item_number` )
REFERENCES `mydb`.`inventory` (`item_number` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
USE `mydb` ;
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
SQL TO INSERT RECORDS IN user_account table
INSERT INTO `mydb`.`user_account` (`account_number`, `user_id`, `timestamp`, `visits`, `transaction_number`) VALUES ('1', '1', '2017-09-11 13:23:44', '5', '1');
INSERT INTO `mydb`.`user_account` (`account_number`, `user_id`, `timestamp`, `visits`) VALUES ('2', '2', '2017-08-11 12:20:00', '1');
INSERT INTO `mydb`.`user_account` (`account_number`, `user_id`, `timestamp`, `visits`) VALUES ('3', '3', '2017-09-10 13:23:44', '2');
INSERT INTO `mydb`.`user_account` (`account_number`, `user_id`, `timestamp`, `visits`) VALUES ('4', '4', '2017-09-09 13:23:44', '37');
INSERT INTO `mydb`.`user_account` (`account_number`, `user_id`, `timestamp`, `visits`) VALUES ('5', '5', '2017-09-11 10:23:44', '1');
INSERT INTO `mydb`.`user_account` (`account_number`, `user_id`, `timestamp`, `visits`) VALUES ('6', '6', '2017-09-15 07:13:01', '3');
INSERT INTO `mydb`.`user_account` (`account_number`, `user_id`, `timestamp`, `visits`) VALUES ('7', '7', '2017-07-04 02:02:44', '2');
INSERT INTO `mydb`.`user_account` (`account_number`, `user_id`, `timestamp`, `visits`) VALUES ('8', '8', '2017-09-11 13:23:44', '1');
INSERT INTO `mydb`.`user_account` (`account_number`, `user_id`, `timestamp`, `visits`) VALUES ('9', '9', '2017-05-11 07:23:44', '4');
INSERT INTO `mydb`.`user_account` (`account_number`, `user_id`, `timestamp`, `visits`) VALUES ('10', '10', '2017-09-11 13:13:44', '5');
INSERTING DATA IN user_session
INSERT INTO `mydb`.`user_session` (`session_number`, `ip_address`, `number_of_clicks`, `timestamp`) VALUES ('1', '3.255.255.255 ', '2', '2017-08-11 12:20:00');
INSERT INTO `mydb`.`user_session` (`session_number`, `ip_address`, `number_of_clicks`, `timestamp`) VALUES ('2', '4.255.255.255 ', '4', '2017-09-15 07:13:01');
INSERT INTO `mydb`.`user_session` (`session_number`, `ip_address`, `number_of_clicks`, `timestamp`) VALUES ('3', ' 6.255.255.255', '2', '2017-07-04 02:02:44');
INSERT INTO `mydb`.`user_session` (`session_number`, `ip_address`, `number_of_clicks`, `timestamp`) VALUES ('4', '7.255.255.255 ', '7', '2017-09-15 07:13:01');
INSERT INTO `mydb`.`user_session` (`session_number`, `ip_address`, `number_of_clicks`, `timestamp`) VALUES ('5', ' 8.255.255.255', '8', '2017-07-04 02:02:44');
INSERT INTO `mydb`.`user_session` (`session_number`, `ip_address`, `number_of_clicks`, `timestamp`) VALUES ('6', '9.255.255.255 ', '5', '2017-08-11 12:20:00');
INSERT INTO `mydb`.`user_session` (`session_number`, `ip_address`, `number_of_clicks`, `timestamp`) VALUES ('7', '11.255.255.255', '6', '2017-07-04 02:02:44');
INSERT INTO `mydb`.`user_session` (`session_number`, `ip_address`, `number_of_clicks`, `timestamp`) VALUES ('8', '12.255.255.255 ', '2', '2017-09-15 07:13:01');
INSERT INTO `mydb`.`user_session` (`session_number`, `ip_address`, `number_of_clicks`, `timestamp`) VALUES ('9', '13.63.255.255 ', '1', '2017-08-11 12:20:00');
INSERT INTO `mydb`.`user_session` (`session_number`, `ip_address`, `number_of_clicks`, `timestamp`) VALUES ('10', '13.95.255.255 ', '1', '2017-07-04 02:02:44');
INVENTORY DATA
INSERT INTO `mydb`.`inventory` (`idinventory`, `item_name`, `buy_price`, `sell_price`, `quantity`) VALUES ('3', 'ASUS ZenBook ', '699.00', '759.99', '10');
INSERT INTO `mydb`.`inventory` (`idinventory`, `item_name`, `buy_price`, `sell_price`, `quantity`) VALUES ('4', 'HP - 17.3\" Laptop - Intel Core i5 ', '300', '420', '20');
INSERT INTO `mydb`.`inventory` (`idinventory`, `item_name`, `buy_price`, `sell_price`, `quantity`) VALUES ('5', 'HP Omen', '799', '1000', '15');
INSERT INTO `mydb`.`inventory` (`idinventory`, `item_name`, `buy_price`, `sell_price`, `quantity`) VALUES ('6', 'ASUS VR', '800', '1190', '5');
INSERT INTO `mydb`.`inventory` (`idinventory`, `item_name`, `buy_price`, `sell_price`, `quantity`) VALUES ('7', 'HP Pavilion', '849', '949', '3');
INSERT INTO `mydb`.`inventory` (`idinventory`, `item_name`, `buy_price`, `sell_price`, `quantity`) VALUES ('8', 'HP Stream Lapto', '174', '219', '6');
INSERT INTO `mydb`.`inventory` (`idinventory`, `item_name`, `buy_price`, `sell_price`, `quantity`) VALUES ('9', 'Think center 3-in-1', '300', '443', '7');
INSERT INTO `mydb`.`inventory` (`idinventory`, `item_name`, `buy_price`, `sell_price`, `quantity`) VALUES ('10', 'HP Pavilion ', '500', '699', '3');
CUSTOMERS
INSERT INTO `mydb`.`customer` (`idcustomer`, `city`, `state`, `mobile_numb`) VALUES ('3', 'Fort Worth', 'Texas', '817-428-8744');
INSERT INTO `mydb`.`customer` (`idcustomer`, `city`, `state`, `mobile_numb`) VALUES ('4', 'Washington', 'dc', '817-624-1736');
INSERT INTO `mydb`.`customer` (`idcustomer`, `city`, `mobile_numb`) VALUES ('5', 'Athens', '682-286-0114');
INSERT INTO `mydb`.`customer` (`idcustomer`, `mobile_numb`) VALUES ('6', '903-675-8112');
INSERT INTO `mydb`.`customer` (`idcustomer`) VALUES ('7');
INSERT INTO `mydb`.`customer` (`idcustomer`) VALUES ('8');
INSERT INTO `mydb`.`customer` (`idcustomer`) VALUES ('9');
INSERT INTO `mydb`.`customer` (`idcustomer`) VALUES ('10');
