← Back to Safety DB

HQ Safety Database

Architecture Visualizer v2

Our roots. Their receipts.

🆔 HQ ID System

Our classification system. External identifiers (CAS, PubChem, etc.) stored as crossrefs.

Compound hq-c-0001 → CAS, PubChem CID, InChIKey, ECHA EC, UNII
Material hq-m-0001 → Resin codes, ASTM standards
Product hq-p-0001 → None needed (our categories)

Why not CAS?

HQ IDs are free, traceable, and always crossref to established identifiers.

📐 Data Hierarchy

Everything is chemistry. Everything traces to compounds.

Compound
hq-c-XXXX
"What is this at the molecular level?"
↓
Material
hq-m-XXXX
"What's it made of?"
↓
Product
hq-p-XXXX
"What am I holding / wearing / feeding?"
↓
Context
safety.contexts.{key}
"Who's exposed? How? What happens?"

Compound Hierarchy: Glyphosate Family

Parent compounds have children (salts, esters, metabolites). Children inherit safety data but have their own identity.

hq-c-0001 Glyphosate CAS 1071-83-6
parent
hq-c-0002 Glyphosate isopropylamine salt CAS 38641-94-0
salt_form
hq-c-0003 Glyphosate potassium salt CAS 70901-12-1
salt_form
hq-c-0004 Glyphosate ammonium salt CAS 114370-14-8
salt_form
Relationship types: salt_form, ester_form, metabolite, degradation_product, isomer, hydrate, prodrug, conjugate, analog

🔗 Data Flow: "Dog Harness" Query

How apps traverse the hierarchy to build safety profiles.

hq-p-0042 Dog Harness Category
→ materials.concerning includes →
hq-m-0003 PVC Vinyl
→ composition.additives[].compound_id →
hq-c-0047 DEHP (CAS 117-81-7)
→ safety.contexts.dog →
{ risk_level, summary, symptoms, action, source_refs }
App presents: "This harness may contain PVC vinyl. According to [source], PVC often contains phthalate plasticizers. Per veterinary literature, DEHP can leach when exposed to saliva..."

Compounds

Next available: hq-c-1226
888 active compounds
hq-c-0001 → hq-c-1225 (with gaps)
active
295 alias records
salt forms, metabolites, synonyms
alias
1,183 total files
schema v3.2.0 • ALCOA+ compliant
active
100% hazard_profile · 100% found_in · 95% regulatory classifications · 80% GHS · 68% LD50

Materials

Next available: hq-m-0263
262 materials
hq-m-0001 → hq-m-0262
active
Plastics, metals, textiles, finishes
schema v3.2.0
active
100% thermal · 100% additives · 100% safety_summary · 70% compound_id resolved

Products

Next available: hq-p-0362
237 active products
hq-p-0001 → hq-p-0361 (with gaps)
active
Consumer categories
schema v3.2.0
active
15 fields at 100% coverage · 98% compound_composition resolved

Standard Context Keys

Populations

human_adult
human_child
human_infant
human_pregnant
human_nursing
human_immunocompromised
dog
cat
bird
fish
horse

Exposure Routes

exposure_dermal
exposure_inhalation
exposure_ingestion
exposure_ocular

Environment

soil
water
aquatic_life

Risk Levels

minimal
low
moderate
high
toxic
unknown
context_dependent

✓ Resolved Nomenclature Decisions

resolved Should filenames include CAS numbers?
No. Filenames use HQ IDs: hq-c-0001.json
Human-readable name and CAS live inside the file as crossrefs.
resolved How to handle salts/variants of same compound?
Separate HQ IDs with hierarchy. Parent compound gets canonical ID.
Children reference parent via hierarchy.parent and hierarchy.relationship.
inherits_safety: true indicates safety data flows from parent.
resolved What's the unique identifier for materials?
HQ IDs. hq-m-0001 for PVC vinyl, etc.
Crossrefs include resin codes and ASTM standards where applicable.
resolved Products — brand-specific or generic categories?
Generic categories only. "Dog harness" not "Kong Model X".
Brand-specific data is maintenance nightmare + liability risk.
resolved Version tracking — in filename or metadata?
Metadata only. meta.version and meta.revision_history.
Filename stays stable: hq-c-0001.json

📁 Directory Structure

hq-safety-db/
├── README.md                  ← Overview + contributing guide
├── ARCHITECTURE.html          ← This file
├── RESEARCH-SUMMARY.html      ← Identifier landscape analysis
├── index.html                 ← Interactive viewer
│
├── data/
│   ├── compounds/
│   │   ├── hq-c-0001.json     ← Glyphosate (parent)
│   │   ├── hq-c-0002.json     ← IPA salt (child)
│   │   └── ...                ← 1,183 files (888 active + 295 aliases)
│   ├── materials/
│   │   └── ...                ← 262 material files
│   ├── products/
│   │   └── ...                ← 237 product files
│   ├── schemas/
│   │   ├── compound.schema.json
│   │   ├── material.schema.json
│   │   ├── product.schema.json
│   │   ├── compound-v2-extended.json
│   │   └── material-v2-extended.json
│   └── registry.json
│
├── templates/
│   └── compound.template.json
│
└── pages/
    ├── disclaimer.html
    └── data-policy.html

#FTP — For The People, Always

HQ Safety DB Architecture Visualizer v2

Holistic Quality LLC • 2026