This may not display real well, I pulled it from my spreadsheet, but here are my two main files (it isn't a database structure -- just Excel lists & that is good enough for me). PS: It didn't on 1st try, so I'll try to pretty it up. It didn't 2nd time, so you get ..... to get spacing -- aaarrgh !!!!
Stash&Pending....worksheet format
... Things I buy, collect, etc, go in here as a stash inventory usually grouped by end item. As I have ideas also known as projects, I start to tag and organize them. This way I can manage the inventory & control random use of aftermarket.
WorkingProjects....worksheet format
... These are projects on the workbench
Both sheets use same format to facilitate cut & paste as I move from stash -> project and move left-over pieces from a project back to stash (ie partial use becomes "parts")
Col...Col Hdg..........Explanation
A-F...Kit Info.............where "Kit" is a very generic word meaning Kit, Part Set, Accessory, Detailing, etc
A.......kMfgr..............who made the kit, decal, aftermarket, etc
B.......kMfgr#.............the mfgr part number
C......kName............the mfgr name for the kit, or something close that fits
D......kType...............Inj, PE, Rsn, Wire, Sheet, Strip, etc -- usually abbreviations
E.......kScale............35, 48, 72, etc
F.......Qty...................# available in stash if not on project, else # allocated to a project
G-J...End Item.........info to identify basic information of the end item
G......iName.............name used to group items by common end item
H......iEra..................abbrev: ww1, ww2, kw, btw='TweenWars, acw=AmCivilWar, etc
I........iNatl.................abbrev: Country (stash usually original, project usually specific) of the End Item
J.......iType................air, sea, gnd, etc
K-L...Project.............used to allocate items to a specific project
K.......pName...........name or code for the project
L.......pSeq................seq# to keep items within a project ordered (basic kit #1, A/M 2..n)
M......Notes
References....work sheet format
... List of references strongly tied to models that I have pretty much organized into one area in my room. Does not include the 1500 or so books in my "other" library, many of which provide historical background or supplemental information. I am working to reorganize my big library and merge both as appropriate, but that will take a big commitment because I must build full-wall shelving.
Col....Col Hdg.........Explanation
A-B....Ref Info
A........Ref Title.........The full title; plus volume info if a series
B.......Author/Pub.....Author and/or Publisher
C-F...Subject...........info to identify basic information of the subject (end item, battle, etc)
C.......iName............name used to group items by common subject
D.......iEra.................abbrev: ww1, ww2, kw, btw='TweenWars, acw=AmCivilWar, etc
E.......iNatl................abbrev: Country of the Subject
F.......iType...............air, sea, gnd, etc
G......Notes
I also have some simple sheets, matrices, etc, to keep track of sizes of styrene, basswood, & brass that I keep around.
John