ModelRailroadForums.com is a free Model Railroad Discussion Forum
and photo gallery
. We cover all scales and sizes of model railroads. Whether you're a master model railroader or just getting started, you'll find something of interest here.
I know that many of you have fine programs for inventorying and tracking your stuff. I would like to put together either a spreadsheet or database for myself and I was looking for a comprehensive list for useful fields. I thought that I would add them to this post and we can see what others do. Once we get past the obvious, it might be a good idea to tell why you include certain fields that others don't use. Certainly if you wonder why someone includes something you don't you should ask about it. Maybe we can come up with something really useful.
Coupler type/brand. Metal wheel brand. Color scheme.
I also add the manufacturer stock number, especially handy for those 'multi-packs'.
Here's what I would add to the Rolling Stock schema:
- Prototype Mfgr
(if known - example, "American Car & Foundry")
- Prototype Model#
(if known - example, "PS-1")
- Prototype Length
(identify potential clearance problems - for example, to screen-out 89-foot auto racks from being run on a sharp-curved branch line)
- Commodity Type
(example: Grain vs. cement
in covered hoppers)
Give me time, I'll think of many more!
Affiliate Disclosure: We may receive a commision from some of the links and ads shown on this website (Learn More Here)
ModelRailroadForums.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to amazon.com
RailroadBookstore.com - An online railroad bookstore featuring a curated selection of new and used railroad books. Railroad pictorials, railroad history, steam locomotives, passenger trains, modern railroading. Hundreds of titles available, most at discount prices! We also have a video and children's book section.
ModelRailroadBookstore.com - An online model railroad bookstore featuring a curated selection of new and used books. Layout design, track plans, scenery and structure building, wiring, DCC, Tinplate, Toy Trains, Price Guides and more.