We are good
client_id first_name last_name full_name cur_trans
1PapaPapa Johns0
2McDonald0
3TacoTaco Bell0
id itemIDitemName unitCount product_tag
status_id status_name status
1customer transaction0
2client transaction0
customer_idfirst_namelast_namecur_trans
1JohnDoe0
2JaneDoe0
3RichardRoe0
inventory_idproduct_idproduct_taginstockinstock_timetrans_timecustomer_idcur_trans
1100000000000000000000011702017-05-14 16:22:352017-05-14 16:33:330
2200000000000000000000011812017-05-14 17:30:412017-05-14 17:13:550
3300000000000000000000011912017-05-14 17:30:412017-05-14 17:13:550
4400000000000000000000012012017-05-14 17:30:412017-05-14 17:13:550
product_idproduct_nameproduct_tagproduct_priceproduct_descriptionproduct_unitproduct_vendorproduct_image
1Coconut Water0000000000000000000001172.00The Best Water Ever1 QuartVita Cocofood/coconut_water.jpg
2TexMex Taco0000000000000000000001182.00Spicy Chicken Taco1 TacoThe Taco Housefood/fresh_taco.jpg
3Vegetarian Pasta0000000000000000000001196.00Homemade Spaghetti8 OuncesFresh Pastafood/pasta.jpg
4Banana 0000000000000000000001201.00Organic Banana1 BananaColiman Banana Supplyfood/banana.jpg
5Chicken Drummette0000000000000000000001217.00Honey Barbecue Chicken6 PiecesChicken Shackfood/spicy_wings.jpg
6Trail Mix5.00Pecans, Raisins, Cashews, and Granola 12 OuncesWellsley Farmsfood/trail_mix.jpg
7Citrus Tangerine1.00Fresh Florida Mandarin Tangerine1 TangerineColumbia Gorge Organicfood/oranges.jpg
8Fresh Vegetables3.00Local Organic In Season Vegetables16 OuncesReedy Fork Farmfood/veggies.jpg
9Oatmeal Raisin Cookies4.00Locally Baked Cookies3 CookiesAppalachia Cookie Companyfood/raisin_cookies.jpg
10Asian Boat8.00Vegetarian Only Asian Meal10 OuncesHutchens Bakeryfood/snack_boat.jpg
11Pomegranate2.00Healthy Anti-Oxidant Loaded Pomegranate1 PomegranateGreen Field Co-opfood/pomegranate.jpg
12Blackberries5.00Local Farm Fresh Blueberries10 OuncesThe Blackberry Covefood/black_berries.jpg
tag_code
000000000000000000000120
000000000000000000000119
000000000000000000000118
violation_idproduct_tagclient_idcustomer_idisviolation
iditemIDitemNameunitPriceunitCount