[{"name":"categories","columns":[{"Field":"id","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},{"Field":"name","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"image_url","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"parent_id","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"created_at","Type":"timestamp","Null":"YES","Key":"","Default":"CURRENT_TIMESTAMP","Extra":"DEFAULT_GENERATED"}]},{"name":"companies","columns":[{"Field":"id","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},{"Field":"name","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"logo","Type":"text","Null":"NO","Key":"","Default":null,"Extra":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"address","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"latitude","Type":"decimal(10,6)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"longitude","Type":"decimal(10,6)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"address_url","Type":"varchar(300)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"created_at","Type":"timestamp","Null":"YES","Key":"","Default":"CURRENT_TIMESTAMP","Extra":"DEFAULT_GENERATED"},{"Field":"owner_id","Type":"varchar(10)","Null":"YES","Key":"","Default":null,"Extra":""}]},{"name":"delivery_info","columns":[{"Field":"id","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},{"Field":"base_delivery_price","Type":"decimal(10,2)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"price_per_km","Type":"decimal(10,2)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"distance_threshold","Type":"decimal(10,2)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"created_at","Type":"timestamp","Null":"YES","Key":"","Default":"CURRENT_TIMESTAMP","Extra":"DEFAULT_GENERATED"}]},{"name":"markup_ranges","columns":[{"Field":"id","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},{"Field":"min_price","Type":"varchar(20)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"max_price","Type":"varchar(20)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"markup_percentage","Type":"varchar(10)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"created_at","Type":"timestamp","Null":"YES","Key":"","Default":"CURRENT_TIMESTAMP","Extra":"DEFAULT_GENERATED"},{"Field":"type","Type":"varchar(20)","Null":"NO","Key":"","Default":null,"Extra":""}]},{"name":"order_item_options","columns":[{"Field":"id","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},{"Field":"order_item_id","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"name","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"value","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"price","Type":"decimal(10,2)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"parent_option_id","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"created_at","Type":"timestamp","Null":"YES","Key":"","Default":"CURRENT_TIMESTAMP","Extra":"DEFAULT_GENERATED"}]},{"name":"order_items","columns":[{"Field":"id","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},{"Field":"order_id","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"item_id","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"item_name","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"item_image","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"quantity","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"subtotal","Type":"decimal(10,2)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"created_at","Type":"timestamp","Null":"YES","Key":"","Default":"CURRENT_TIMESTAMP","Extra":"DEFAULT_GENERATED"}]},{"name":"orders","columns":[{"Field":"id","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},{"Field":"customer_id","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"company_id","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"status","Type":"varchar(50)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"total_price","Type":"decimal(10,2)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"order_date","Type":"varchar(100)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"payment_method","Type":"varchar(50)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"payment_status","Type":"varchar(50)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"payment_date_time","Type":"varchar(100)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"payment_confirmed_by","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"created_at","Type":"timestamp","Null":"YES","Key":"","Default":"CURRENT_TIMESTAMP","Extra":"DEFAULT_GENERATED"},{"Field":"slug","Type":"varchar(200)","Null":"NO","Key":"","Default":null,"Extra":""},{"Field":"items","Type":"text","Null":"NO","Key":"","Default":null,"Extra":""},{"Field":"metadata","Type":"text","Null":"NO","Key":"","Default":null,"Extra":""}]},{"name":"products","columns":[{"Field":"id","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},{"Field":"campany_id","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"category_id","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"name","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"description","Type":"text","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"price","Type":"decimal(10,2)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"availability","Type":"tinyint(1)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"image_url","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"created_at","Type":"timestamp","Null":"YES","Key":"","Default":"CURRENT_TIMESTAMP","Extra":"DEFAULT_GENERATED"},{"Field":"metadata","Type":"text","Null":"NO","Key":"","Default":null,"Extra":""}]},{"name":"tokens","columns":[{"Field":"id","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},{"Field":"user_id","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"token","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"created_at","Type":"timestamp","Null":"YES","Key":"","Default":"CURRENT_TIMESTAMP","Extra":"DEFAULT_GENERATED"}]},{"name":"tybo_page","columns":[{"Field":"pageId","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},{"Field":"websiteId","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"path","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"title","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"slug","Type":"varchar(200)","Null":"NO","Key":"","Default":null,"Extra":""}]},{"name":"tybo_section","columns":[{"Field":"sectionId","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},{"Field":"pageId","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"type","Type":"varchar(50)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"metadata","Type":"text","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"position","Type":"int","Null":"NO","Key":"","Default":null,"Extra":""}]},{"name":"tybo_website","columns":[{"Field":"websiteId","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},{"Field":"name","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"baseUrl","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"apiUrl","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""}]},{"name":"users","columns":[{"Field":"id","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},{"Field":"username","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"email","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"password","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"role","Type":"varchar(50)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"phone_number","Type":"varchar(20)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"address_line_1","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"address_line_2","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"city","Type":"varchar(100)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"dob","Type":"varchar(50)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"address","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"latitude","Type":"decimal(10,6)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"longitude","Type":"decimal(10,6)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"url","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"created_at","Type":"timestamp","Null":"YES","Key":"","Default":"CURRENT_TIMESTAMP","Extra":"DEFAULT_GENERATED"},{"Field":"metadata","Type":"text","Null":"NO","Key":"","Default":null,"Extra":""}]},{"name":"variation_options","columns":[{"Field":"id","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},{"Field":"variation_id","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"value","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"price","Type":"decimal(10,2)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"parent_option_id","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"created_at","Type":"timestamp","Null":"YES","Key":"","Default":"CURRENT_TIMESTAMP","Extra":"DEFAULT_GENERATED"}]},{"name":"variations","columns":[{"Field":"id","Type":"int","Null":"NO","Key":"PRI","Default":null,"Extra":"auto_increment"},{"Field":"item_id","Type":"int","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"name","Type":"varchar(255)","Null":"YES","Key":"","Default":null,"Extra":""},{"Field":"created_at","Type":"timestamp","Null":"YES","Key":"","Default":"CURRENT_TIMESTAMP","Extra":"DEFAULT_GENERATED"}]}]