Hazardous Materials Management System

Five fields describe the substance: material (a free-text name), quantity in kilograms, its physical state, a location code, and the intended transportMode. The schema constrains state to solid, liquid, or gas and transportMode to road, rail, air, sea, or internal, so the tables can match on those values safely.

Classification matches keywords against lower(material) using some(...) with contains, first hit wins, so a substance named 'Sulfuric Acid' hits the corrosive row via the 'acid' keyword. Flammable or combustible liquids and gases become 'Class A - Flammable' in the 'red-zone'; corrosives map to 'Class B - Corrosive' and the 'yellow-zone'; toxic materials split on quantity, 'high' hazard above 25kg and 'medium' at or below; radioactive and explosive names rate 'extreme' in the 'black-zone'; oxidizers get the 'blue-zone', and unmatched names fall to 'Unclassified' in the 'grey-zone'.

Keyword-driven classing with a low-severity fallback is a pragmatic first pass for a facility system; the A-F letters and color-coded zones are an internal convention rather than the UN dangerous-goods classes, which is worth knowing before mapping this to shipping paperwork. The quantity split for toxics reflects a real principle, that hazard management scales with the amount on hand, while the 25kg line itself is a site-level choice.

Equipment, procedure, and a storage cap follow from the hazardClassification and hazardLevel pair, one row per class. Flammables call for fire-resistant gloves and non-sparking tools with a 500kg limit; corrosives allow 1000kg but require neutralizing agents on hand; high-hazard toxics get the tightest chemical cap at 250kg with a full protective suit, easing to 500kg and lab-coat-level PPE at 'medium'; radioactive and explosive stock are squeezed to 50kg and 100kg with remote handling tools or blast shields, and 'Unclassified' material runs standard PPE up to 2000kg.

The inverse relationship between hazard and permitted quantity is the realistic backbone here: the storage limit is the lever that bounds worst-case incident size, so the most energetic materials get the smallest allowances. Pairing every limit with named PPE and a written procedure mirrors how safety data sheets translate into site rules, though the specific kilogram caps are policy values a facility would set to match its own containment and ventilation.

Transport checks combine hazardClassification, transportMode, and quantity, first hit ordering the strictest cases on top. Flammables and explosives over 5kg are refused air transport outright; 'Class D - Radioactive' on any mode demands a special permit and mandatory routing; the four chemical classes on road, rail, or sea then tier by quantity, above 1000kg requiring placards, a certified handler, and reporting, 100 to 1000kg requiring placards and safety data sheets without reporting, and up to 100kg needing only the data sheets. Movements marked 'internal' just need a movement log, and 'Unclassified' goods follow standard shipping procedures.

The structure tracks how dangerous-goods transport genuinely works: air freight has far stricter quantity limits than surface modes, placarding and driver certification kick in by quantity bands, and paperwork like safety data sheets travels with even small shipments. The specific 5, 100, and 1000kg breakpoints and the permit strings are simplified stand-ins, so an implementer would swap in the thresholds from the applicable modal regulations rather than treat these as citations.