I find my parts in a relational database. Why a DB? Well I have a lot of parts, everything from hardware, printed parts, and electronics, to avionics. Now, this is a pain. So there are a few tables that need to be created Info, Manufac, Category, and a few others First, let us get a Manufac table created. Now we can create the master Category table. Net you need a Category Table for each Category you use. The most important table here is the Info table it brings it all together. If you want to keep info on costs etc and where something really is use the History table. If you wish to use my category list I have included it below. Please feel free to modify my list. You could add pneumatics or hydraulics, as well as something called rotables1. Some folks define this as any part that the serial number is recorded, others take the word rotables as "rotating" like wheels, tires, breaks, some engine parts, etc. So if you have a part that has to be replaced every so many hours or cycles, in short, that's a rotable.
Oh, one note on your location each one of your shelves should have a number. First I use a letter to denote where the shelf is: Lab, Garage, Storage, or even a Hanger. So if you have 5 shelving units use Letters A to Z, now about the shelf itself use numbers 1 (bottom) to the top. Then what space on the shelf the box is again letters are you fiend on a 4' shelf you can have 2 18" wide bins (A, B) and a little room left over for C. So the stock location of LB4B is the L = Lab, B = the second shelving unit, 4 = the fourth shelf from the bottom and B= would be the second box from the left. If one shelf had 8" bin boxes, so I get five bins on one shelf then you end up with A, B, C, D, E.
One more thing I noticed that some folks stack several boxes on top of another so let us say you had two boxes on that shelf LB4B1 and LB4B2 (top). Oh, Blue Bin Boxes most of mine are 10x5 or fifty bins. you have your choice LB4B(a number 1 -50) or LB4B5A (first bin on the top left)
One more thing LABEL EVERYTHING.
~~ Cris
Notes:
- skybrary.aero Rotables means those Spare Parts that can be repeatedly and economically restored to a serviceable condition over a period approximating the life of the flight equipment to which they are related.
- Updated and Added to: Oct 5, 22 First I use a letter to denote where the shelf is Lab, Garage, Storage, or even a Hanger.
| Manufac | Categories | CAT100 or any other number** |
|
|
CREATE TABLE `Category` ( `CatID` bigint(20) DEFAULT NULL, `CatName` varchar(50) DEFAULT NULL ); |
CREATE TABLE `CAT100` ( `CatID` int(11) DEFAULT 100, `Base` int(11) NOT NULL AUTO_INCREMENT, `MLID` int(11) DEFAULT NULL, `Rev` int(11) DEFAULT NULL, `InfoID` bigint(20) DEFAULT NULL, `Revision` varchar(256) DEFAULT NULL, KEY `idx` (`Base`)) ** beshure us change the DEFAULT number! |
| Info | History | |
|
CREATE TABLE `Info` ( `CatID` bigint(20) DEFAULT NULL, `InfoID` bigint(20) NOT NULL AUTO_INCREMENT, `ManID` bigint(20) DEFAULT NULL, `Part` varchar(50) DEFAULT NULL, `AltNum` varchar(50) DEFAULT NULL, `Serial` varchar(20) DEFAULT NULL, `Type` varchar(20) DEFAULT NULL, `Spec` varchar(50) DEFAULT NULL, `NSN` varchar(20) DEFAULT NULL, `Discription` varchar(100) DEFAULT NULL, `Notes` varchar(100) DEFAULT NULL, `Picture` tinyint(4) DEFAULT NULL, KEY `idx` (`InfoID`)) |
CREATE TABLE `History` ( `CatID` int(11) NOT NULL, `InfoID` int(11) NOT NULL, `Part` varchar(100) DEFAULT NULL, `Ser` varchar(50) DEFAULT NULL, `CCode` char(4) DEFAULT NULL, `DateIn` date DEFAULT NULL, `Cost` decimal(15,3) DEFAULT NULL, `DateOut` date DEFAULT NULL, `Notes` varchar(500) DEFAULT NULL ) |
INSERT INTO `Categorys` VALUES
(1,'Avionics, Instruments'), (3,'Avionics, Radios'), (5,'Avionics, Other'),
(17,'Wire and Cable'), (18,'Hardware, Basic'), (19,'Integrated Circuits, Digital'), (21,'Restors'),(22,'Capitors'), (23,'Doides'), (24,'Switches / Indicators'), (25,'Printed Circuit Boards'), (26,'Connectors'), (27,'Cable Harnesses'), (29,'Manuals'), (30,'Coils, Chokes, Transformers'), (33,'Switches'),
(34,'Power Supplies'), (35,'PCB, Assembled'), (36,'Electro-Mechanical Devices'),(37,'Integrated Circuits, Analog'), (38,'Electro-Optical'), (39,'Expansion Units'), (59,'Devices, Circuit Protection'), (60,'Solenoids/Relays'), (63,'Meters '), (64,'Sensors'), (65,'Fans'),
(100,'Sheet Metal Parts'), (103,'Mechanical Assemblies, Main'),
(111,'Structral Members'), (106,'Mechanical Asseblies, Sub'), (105,'Mechanical Castings'), (107,'Mechanical 3D Printed'), (109,'Panels, Utimately Painted or lettered'), (113,'PCB Bare (Unassembled)'), (115,'PCB, Layers, Drawing'), (117,'PCB, Silkscreen, Drawing'), (117,'PCB, Silkscreen, Drawing');
Top Comments