PHASE 9 • SYSTEM ARCHITECTURE
CATALOG & DOCUMENT DATA MODEL
A scalable foundation for future validated compound records, lot traceability, analytical documents, and publication controls.
CATALOG
Catalog Records
Stable catalog codes, research areas, record categories, publication status, document slots, and future lot relationships.
OPEN CATALOG →LOTS
Lot Registry
Future lot numbers are designed to link only to a matching catalog record and reviewed source documents.
OPEN COA LIBRARY →DOCUMENTS
Document Registry
COA, identity, and purity records use review-gated states before anything becomes publishable.
OPEN REGISTRY →Phase 9 rule: the site now includes machine-readable JSON data structures, but no real technical values or analytical results are populated without validated source documentation.
| OBJECT | PRIMARY IDENTIFIER | KEY RELATIONSHIP | PUBLICATION GATE |
|---|---|---|---|
| Catalog record | catalog_code | Links to compound page and future lots | Template may be public; technical data review-gated |
| Lot record | lot_number | Must match exactly one catalog code | Validated source record required |
| COA | catalog_code + lot_number | Must match lot and catalog record | Validated |
| Identity record | catalog_code + lot_number | Must match lot and catalog record | Validated |
| Purity record | catalog_code + lot_number | Must match lot and catalog record | Validated |