RelationalDBDesign RelationalDBDesign 


Petstore Database  

PRODUCT_OBJ_TABLE

RODUCT_ID PRODUCT_NAME PACKAGE_ID CURRENT_INVENTORY_COUNT STORE_COST SALE_PRICE LAST_UPDATE_DATE UPDATED_BY_USER PET_FLAG ITEM_DESCRIPTION ITEM_CATEGORY
2 Box Turtle   5 5.98 15.5   JANET Y Land turtle with large, square back. OTHER
3Fish Tank 1118.7524.9511-JUN-2009MARKNTen gallon tank with gravel, filter, and light.FISH
4 Dog Food 21 50 3.45 5.15 10-MAY-2009 JANET N    
5 Rabbit   10 2.5 3.2009 21-SEP-2009 JANET Y   OTHER
6 Cat 20 8 25 45 15-SEP-2009 MARK Y   CAT
7 Cat Food 20 33 4.22 6.5 01-JUL-2009 JANET N   CAT
8 Canary   4 12.5 29 30-OCT-2009 MARK Y   BIRD
9 Cocketiel   5 35 95 28-FEB-2009 JANET Y   BIRD
10 Bird Food   15 2.25 3.5 15-APR-2009 MARK N   BIRD
11 Fish   150 .25 .2009 23-OCT-2009 JANET Y   FISH
12Fish Food 251.252.2524-NOV-2009MARKN FISH
13 Air Filter   3 15 20 01-JAN-00 JANET N   FISH
14 Chew Toy 21 23 3.5 6.5 22-FEB-00 HENRY N   DOG
15 Catnip 20 6 1.12 1.2009 15-DEC-2009 MARK N   CAT
16Bird Treat 23.14.519-NOV-2009JANETN BIRD
17Bunny Food 103.56.7530-MAY-2009MARTINN OTHER
18 Dog Collar 21 12 2.43 5.65 14-JUL-2009 MARTIN N   DOG
19 Cat Collar 20 15 2.24 4.2009 14-JUL-2009 MARTIN N   CAT
20 Kitty Package   5 32.58 55 11-JUN-2009 HENRY N Starter kit. CAT
21 Puppy Package   5 52.38 78 14-OCT-2009 JANET N   DOG
22 Puppy 21 5 40 65 15-JUL-2009 JANET Y   DOG
39 Guinea Pig Package   4 23.2 31.35 29-AUG-2009 MARTIN N   OTHER
33 Guinea Pig Food Package 39 35 1.15 1.35 25-AUG-2009 MARTIN N   OTHER
34 Guinea Pig Vitamins 33 15 3.12 9.95 05-AUG-2009 MARTIN N   OTHER
35 Guinea Pig Pellets 33 15 2.45 4.95 05-AUG-2009 MARTIN N   OTHER
36 Guinea Pig Cage 39 11 22.45 34.95 05-AUG-2009 MARTIN N   OTHER