Class AuditChainModel

src/orgkernel/models.py:165–199

Stores AuditChain metadata. One chain per Mission. Entries are stored in AuditEntryModel.

class AuditChainModel(BaseModel):
    """
    Stores AuditChain metadata. One chain per Mission.
    Entries are stored in AuditEntryModel.
    """

    __tablename__: str = "sys_orgkernel_audit_chain"
    __table_args__ = (
        Index("idx_chain_mission_id", "mission_id", unique=True),
        {"comment": "OrgKernel AuditChain — append-only hash-chained audit log header"},
    )

    chain_id: Mapped[str] = mapped_column(
        String(32), primary_key=True, comment="ac_ prefixed global ID"
    )
    mission_id: Mapped[str] = mapped_column(
        String(32), nullable=False, unique=True, index=True,
        comment="FK -> Mission (one chain per mission)",
    )
    agent_id: Mapped[str] = mapped_column(
        String(32), nullable=False,
        comment="FK -> sys_orgkernel_agent_identity.agent_id",
    )
    initialized_at: Mapped[datetime] = mapped_column(
        DateTime, nullable=False,
        comment="UTC chain initialization timestamp",
    )
    closed_at: Mapped[datetime | None] = mapped_column(
        DateTime, nullable=True,
        comment="UTC chain closure timestamp",
    )
    head_hash: Mapped[str | None] = mapped_column(
        String(64), nullable=True,
        comment="SHA-256 hash of the most recent entry",
    )


class AuditEntryModel(BaseModel):