Caps Supply
Introduction to the CAP database
The CAP database is a database of all cars and technical details sold in the UK maintained by CAP Motor Research Ltd. The database is an invaluable source of information on UK Cars and contains a wealth of technical information for each model of car, optional extras for new cars, standard features, pricing data and stock images. At present the database holds some 46,000 car details and the average release from CAP weighs in at around 6GB.
Updates to the database are fairly regular with price data updated on the first of every month.
At first glance the database is a giant maze and, even after reading the documentation supplied by CAP, finding your entry point and understanding the structure of the database can take several confusing hours.
The key to the database is a CAP ID, this value uniquely identifies a Car within the database and almost all information in the database on this car references this ID. The best place to start when locating the CAP ID for a car are the tables CapDer and CAPVehicles.Often CAPVehicles is the easiest table to use when receiving input from a user as it contains the Manufacturer, (Short) Model and (Short) Derivative text for each record. In the CAPVehicles table the field Cvehicle_ID contains the value of the CAP ID for the record. CapDer is not as user friendly as CAPVehicles but it does reference the manufacturer, model and derivative text in other tables and contains information on the number of doors, drive train, fuel delivery, transmission and fuel type for the car. The CAP ID in this table can be found in the field cap_ID. Joining these two tables in an SQL query produces a powerful result set for use in search results or basic car details forms / pages.
Once you have the CAP ID for a vehicle almost every other table uses this value in a one to one or many to one relationship. NVDTechnical for example references the CAPVehicles / CapDer table by holding the CAP ID value in TECH_Id and NVDOptions does the same with the field OPT_Id. The manual available form CAP has more detailed information on how the tables reference one another.
The only exceptions to this rule is NVDImage which holds the stock images of the cars and the dictionaries which describe technical and options data. The dictionary data is often referenced by a field similar to TECH_TechCode or OPT_OptionCode, again check the manual for more details, image data however is different.
To keep the size of the database to a minimum and because many variants of a car share the same stock photo to access the appropriate stock image of the car you must first obtain the Image ID from the NVDModelYear table. The NVDModelYear table is likely to have multiple rows for a single CAP ID and may have different images depending on when the car in question was manufactured. In the new vehicle database whenever an effective from / to or introduction date can be found you should expect to find multiple records for one CAP ID. CAP Motor Research add rows to these tables as the details of a car are changed by the manufacturer.
You should query the NVDModelYear table using your CAP ID and the date the vehicle was manufactured. Images for cars which can still be ordered from the manufacturer will have the value of NULL in the MY_EffectiveTo field. The ID of the image can be found in the MY_ImageID.
Once you have the ID it is simply a case of retrieving the image data from the NVDImage table by selecting the record with ima_imageid having the same value you found in MY_ImageID. Image data found in the CAP database is always in a JPEG format and has a resolution of 1024x768.
About the Author
Article by tc software and Car Arena
Philco 38-116 Repair, Part 6, Power Supply filter caps, Things to watch for.
 |
 Aguaje Caps 1 month supply $25.00 Time Remaining: 10d 20h 21m Buy It Now for only: $25.00 Buy It Now |
 24 DESERT IRONWOOD BURL CAP RESAW KNIFE SCALES MUSEUM QUALITY LIMITED SUPPLY $109.50 (2 Bids) Time Remaining: 8h 25m |
 28 DESERT IRONWOOD BURL CAP RESAW KNIFE SCALES MUSEUM QUALITY LIMITED SUPPLY $199.50 Time Remaining: 8h 25m |
 540 caps Pantogar Pantovigar Capsules anti hair loss Alopecia 6 months supply $129.99 Time Remaining: 8d 22h 30m Buy It Now for only: $129.99 Buy It Now |
 SUPREME BLACK SUPPLY BAG THE NORTHFACE SAFARI KERMIT CAMP CAP BOX TEE $37.00 Time Remaining: 3h 47m Buy It Now for only: $47.00 Buy It Now |
 Align Digestive Care Probiotic Supplement 63 Caps 9 Week Supply NEW Bifantis $46.79 Time Remaining: 21d 12h 45m Buy It Now for only: $46.79 Buy It Now |
 3 Bottles of Bee Propolis 60x3180 caps 9mos supply $17.95 Time Remaining: 7h 43m |
 4 Bottles of Bee Propolis 60x4240 caps 9mos supply $15.95 Time Remaining: 7h 54m |
 OMEPRAZOLE GENERIC PRILOSEC OTC CAPS 90 DAY SUPPLY SHIPS FROM USA $29.95 Time Remaining: 28d 2h 24m Buy It Now for only: $29.95 Buy It Now |
 MOSSIMO SUPPLY CO Lightweight Cap Sleeve Top XL $6.00 Time Remaining: 1h 27m |
 300 Plastic Tattoo Ink Cups Caps Supplies Large + Medium + Small $1.00 Time Remaining: 26d 4h 39m Buy It Now for only: $1.00 Buy It Now |
 2x SheeplambPlacenta100mg 200caps 3 months supply $14.95 Time Remaining: 7h 54m |
 SIBU Beauty Cellular Support Sea Buckthorn 60 Softgel caps 1 Month Supply $19.00 Time Remaining: 1d 5h 3m |
 17HD 1 MONTH Supply 30 Caps Testosterone Boost $29.99 Time Remaining: 19d 20h 37m Buy It Now for only: $29.99 Buy It Now |
 6 x American Ginseng Concentrate 360 Capsules 500mg cap 6 Months Supply $24.95 Time Remaining: 7h 43m |
 1 RASPBERRY KETONE Lean Weight Loss 1200 mg 120 Caps Dr Oz 2 Month Supply $12.99 Time Remaining: 11d 3h 24m Buy It Now for only: $12.99 Buy It Now |
 7 Bottles Spirulina 500mg x100 caps 6 months supply $29.95 Time Remaining: 7h 43m |
 1000 Pcs 6mm Silver Plated Flower Shape Bead Caps 1 $2.81 Time Remaining: 28d 15h 3m Buy It Now for only: $2.81 Buy It Now |
 6 x American Ginseng Concentrate 360 Capsules 500mg cap 6 Months Supply $24.95 Time Remaining: 7h 54m |
 6 x American Ginseng Concentrate 360capsules 500mg cap 6 Months Supply $24.95 Time Remaining: 7h 54m |
 Lot of 144 Pencil Cap Erasers Funny Face Bulk School Office Supply Wholesale $4.39 Time Remaining: 29d 6h 6m Buy It Now for only: $4.39 Buy It Now |
 American Ginseng Concentrate 60 Capsules 500mg cap 1 Month Supply $2.99 Time Remaining: 7h 43m |
 Lot of 400 Pencil Cap Erasers Bulk School Office Supply NEW FAST SHIP Wholesale $9.98 Time Remaining: 17d 4h 38m Buy It Now for only: $9.98 Buy It Now |
 DENIM SUPPLY by RALPH LAUREN mens cap USA FLAG $19.85 Time Remaining: 6h 52m |
 American Ginseng Concentrate 200 capsule 500mg cap 3 Months Supply $12.95 Time Remaining: 7h 54m |
 Graduation Party Supplies BLACK GRAD CAP MORTARBOARD CARD HOLDER BOX $6.99 Time Remaining: 12d 4h 11m Buy It Now for only: $6.99 Buy It Now |
 4 x American Ginseng Concentrate 240capsules 500mg cap 4 Months Supply $15.95 Time Remaining: 7h 54m |
 1000 Pcs 6mm Gold Plated Flower Shape Bead Caps 1 $2.81 Time Remaining: 15h 19m Buy It Now for only: $2.81 Buy It Now |
 American Ginseng Concentrate 60 Capsules 500mg cap 1 Month Supply $6.99 Time Remaining: 7h 54m |
 Speaker Dust Caps Re Cone Supplies Cloth Felt 30+ Pcs $12.00 (1 Bid) Time Remaining: 2d 8h 41m |
 Graduation Party Supplies BLACK PINK CAP GRAD DIVA TIARA $3.50 Time Remaining: 14d 4h 55m Buy It Now for only: $3.50 Buy It Now |
 Lot of 400 Pencil Cap Erasers Bulk School Office Supply NEW FAST SHIP Wholesale $9.98 Time Remaining: 7h 20m |
 LM317 based variable AC DC to DC power supply DIY electronics kit + Large caps $8.99 Time Remaining: 20d 18h 25m Buy It Now for only: $8.99 Buy It Now |
 H350 vintage trucker hat cap Walts Safety Construction Supply Redding CA $12.99 Time Remaining: 6h 59m |
 1000 PCS Ink Caps Small Plastic Cups Tattoo Supplies 9 USA $9.99 Time Remaining: 22d 11h 13m Buy It Now for only: $9.99 Buy It Now |
 Lot of 1500 Pencil Cap Erasers Bulk School Office Supply NEW FAST SHIP Wholesale $29.95 Time Remaining: 7h 37m |
 Dr Garys Dog Glucosamine Joint Caps Rebuild Formula 3Bottles 45 Month Supply $58.99 Time Remaining: 9h 49m |
 Lot Of 300 PCS Small Size 9mm Yellow Plastic Tattoo Ink Cap Cups Supply YIC9 300 $4.39 Time Remaining: 29d 18h 4m Buy It Now for only: $4.39 Buy It Now |
 RALPH LAUREN DENIM SUPPLY BLACK with USA FLAG 1 SIZE ADJ BASEBALL CAP HAT NWT $29.99 Time Remaining: 10h 42m |
 Lot Of 1000 PCS Medium Size 13mm Plastic Tattoo Ink Cap Cups Supply IC13 1000 $13.88 Time Remaining: 7h 45m Buy It Now for only: $13.88 Buy It Now |
 BRAND NEW Sea Veg ONE MONTH SUPPLY 90caps IS BACK Original Super SeaVeg Vegg $39.95 Time Remaining: 23h 46m Buy It Now for only: $43.95 Buy It Now |
 2 Bally power supply dist boards AS 3099 P 8110 M645 435 11000uf 20v cap $0.99 Time Remaining: 2d 18h 39m Buy It Now for only: $1.99 Buy It Now |
 FEMINELLE 120 CAPS 2 MONTH SUPPLY MENOPAUSE RELIEF $24.24 Time Remaining: 19d 9h 31m Buy It Now for only: $24.24 Buy It Now |
 TOSTERALL MENS FORMULA 60CAPS A 30 DAY SUPPLY EXP 10 2014 $9.55 Time Remaining: 1d 7h 11m Buy It Now for only: $19.55 Buy It Now |
 WHITE KIDNEY BEAN 500mg DR OZ BEST CARB BLOCKER PILLS 120 CAPS 4 MONTH SUPPLY $13.99 Time Remaining: 12d 23h 21m Buy It Now for only: $13.99 Buy It Now |
 RALPH LAUREN DENIM AND SUPPLY USA FLAG LOGO BALL CAP $15.95 Time Remaining: 22h 3m |
 RALPH LAUREN DENIM AND SUPPLY USA FLAG LOGO BALL CAP $15.95 Time Remaining: 22h 7m Buy It Now for only: $17.95 Buy It Now |
 Lot Of 1000 PCS Bag Small Size 8mm Plastic Tattoo Ink Cap Cups Supply IC9 1000 $10.79 Time Remaining: 29d 15h 48m Buy It Now for only: $10.79 Buy It Now |
 Diamond Supply co snap back hat cap $18.50 (8 Bids) Time Remaining: 1d 6h 6m |
 OMEPRAZOLE GENERIC PRILOSEC OTC CAPS 30 DAY SUPPLY SHIPS FROM USA $9.95 Time Remaining: 28d 2h 24m Buy It Now for only: $9.95 Buy It Now |
 Sea Veg TWO YEAR SUPPLY 12x180caps NEWEST 2012 Label Original Super SeaVeg Vegg $540.00 Time Remaining: 1d 20h 46m Buy It Now for only: $594.00 Buy It Now |
 Dispensing Syringe tip cap pack of 50 Sale Price: $4.00  Eligible for free shipping!Availability: Usually ships in 1-2 business days See Reviews For This Product Description* Non-Sterile, not for medical use* For industrial Use Only* User assumes all responsibility for application  |
 Gladiator GarageWorks GAACGE4PPM Geartrack End Caps, 4-Pack List Price: Sale Price: $11.73 You save: $0.76 (6%) Eligible for free shipping!Availability: Usually ships in 24 hours See Reviews For This Product Description"GLADIATOR" GEARTRACK END CAPS Geartrack End Caps Snaps Onto End Of Geartrack Channels To Create A Finished Look 4 Pack |
 Speedo Silicone Swim Cap (Black) List Price: Sale Price: $7.99 You save: $4.01 (33%) Eligible for free shipping!Availability: Usually ships in 24 hours See Reviews For This Product DescriptionLightweight and durable cap that is designed to hold dome shape and rounded fit with no wrinkles, which reduces drag. The silicone allows the head to breath for a more comfortable fit and can be stretched to over double its original size... |
 MOMS quality #9 ink cups TRUST THE BEST!!! 100 pcs Sale Price: $4.44 Eligible for free shipping!Availability: Usually ships in 1-2 business days See Reviews For This Product DescriptionMOMS Small Tattoo Ink cups. #9 stands for the width on top 9mm |
 Loop N Loom Refill 108/Pkg-Multi C List Price: Sale Price: $9.87 You save: $2.12 (18%) Eligible for free shipping!Availability: Usually ships in 24 hours See Reviews For This Product DescriptionAssorted colors of loops for the Loop N Loom (sold separately). Includes 108 soft chunky stretchy loops in 9 different colors. Enough for 3 pot-holders! 108/Pkg, Multi Colors. |
 Valterra Products, Inc. T1020 3" Black Termination Cap with Bayonet Hook Sale Price: $2.55 Eligible for free shipping!Availability: Usually ships in 24 hours See Reviews For This Product Description3" termination cap with bayonet hooks. Fit Valterra and Grentec values. |
 Paper Mate Arrowhead Pink Cap Erasers (73015), Pack of 144 List Price: Sale Price: $7.99 You save: $4.00 (33%) Eligible for free shipping!Availability: Usually ships in 24 hours See Reviews For This Product DescriptionPerfect when you run out of eraser before you run out of pencil. |
 Cap Barbell Fitness FID Bench List Price: Sale Price: $49.00 You save: $30.99 (39%) Eligible for free shipping!Availability: Usually ships in 24 hours See Reviews For This Product DescriptionGet the most out of your home dumbbell set with this Cap Barbell fitness bench. Offering four adjustable positions--upright, flat, incline, and decline--the bench supports a variety of upper body exercises, including dumbbell presses, chest flies, shoulder presses, bicep curls, and more... |
 Tattoo Ink Cups 500 #9 Caps Tattoo Supplies Sale Price: $7.24 Eligible for free shipping!Availability: Usually ships in 1-2 business days See Reviews For This Product Description500 count of the best ink cups on the market. These are Mom's brand cups and as every artist know mom's is the top selling brand of tattoo supplies on the market today! |
 Betty Dain Stylish Design Mold Resistant Shower Cap, The Fashionista Collection, "diva" List Price: Sale Price: $6.55 You save: $0.40 (6%) Eligible for free shipping!Availability: Usually ships in 24 hours See Reviews For This Product DescriptionThe Betty Dain Fashionista Collection of Stylish Shower Caps shown here in the pattern "Diva" offers a soft waterproof nylon exterior with a mold-resistant eco-friendly PEVA lining. It's the perfect combination of style, comfort, and quality... |
