PuranOS Schema Catalog

legal

In-house-counsel contract twin — contracts, governing clauses, flowdown links, LD/legal facts, scenario runs, document attachments. 7 tables, introspected live from the deployed database. Lifecycle: All phases.

Entity-relationship diagram

Overview below — open the full-resolution SVG to pan and zoom, or paste the DBML source into dbdiagram.io for an interactive view.

Entity-relationship diagram of the legal database (7 tables)

Table schemas

Each table has a JSON Schema (2020-12) with a canonical $id, generated by live introspection.

clause 13 cols

PK: clause_id · 2 FKs

PK: document_id · 1 FK

PK: attachment_id

PK: link_id · 3 FKs

PK: fact_id · 3 FKs

PK: review_id · 1 FK

PK: run_id

← Back to the schema catalog