?Wi7NdZddlmZmZmZmZmZmZmZm Z m Z m Z m Z m Z ddlmZmZddlmZGddeZGddeZGd d eZGd d eZGd deZGddeZGddeZGddeZGddeZGddeZGddeZy)u9 SQLAlchemy ORM models matching the current Genesis PostgreSQL schema. These models are the single source of truth for Alembic autogenerate. When a new table is added to PostgreSQL, add the model here first, then run `alembic revision --autogenerate -m ""` to generate the migration script. Real schema sourced from: - scripts/rlm_create_tables.sql (public schema RLM tables) - scripts/aiva_rlm_schema.sql (aiva_rlm schema tables) - scripts/alpha_evolve_create_tables.sql (genesis schema tables) Host: postgresql-genesis-u50607.vm.elestio.app:25432 DB: postgres (matches PostgresConfig.database in elestio_config.py) VERIFICATION_STAMP Story: M4.06 — core/models/schema.py — SQLAlchemy ORM schema definitions Verified By: parallel-builder Verified At: 2026-02-25 Tests: 6/6 Coverage: 100% ) BooleanColumnDateTimeFloatIntegerStringTextIndextextCheckConstraintUniqueConstraintARRAY)JSONBUUID)DeclarativeBaseceZdZdZy)Basez3Shared declarative base for all Genesis ORM models.N)__name__ __module__ __qualname____doc__+/mnt/e/genesis-system/core/models/schema.pyrr.s=rrcxeZdZdZdZeeddedZee dded  Z ee dd Z ee d Z eed Zeed Zeed Zeed Zeed Zeed Zeed d Zeed ddZeddfZy)RoyalConversationz Kinan <> AIVA conversation records. Every session with Queen AIVA is persisted here so the RLM bloodstream can extract key facts, decisions, directives, and action items. royal_conversationsTas_uuidzgen_random_uuid()) primary_keyserver_defaulttimezoneFNOW()nullabler!r&2dunknownr&default!ix_royal_conversations_started_at started_atN)rrrr __tablename__rrr conversation_idrr.ended_atr transcript_rawrenriched_entitiesdecisions_made action_items key_factskinan_directives participantsr caller_numberoutcomer __table_args__rrrrr6s*M T/0O $G}J h-=HD40Nut4ED1N%$/Lut,Ied3%$/L6":5MVC[4CG 1<@Nrrc4eZdZdZdZeeddZeedddZ ee dde d  Z ee d Zeed Zeedd Zeed Zeed Zeed Zeed Zeedd Zy)EpochLogz Nightly epoch run records. One row per Alpha Evolve cycle. Tracks phases completed, axioms produced, PR URLs, and shadow pass rates so the system can trend its own evolution. epoch_logTr autoincrementr)F)uniquer&r"r$r%r'rr,ipendingN)rrrrr/rridrepoch_idrr timestamprphases_completed axioms_countpr_url tier1_updatesr week_summaryrshadow_pass_rateduration_secondsstatusrrrr=r=Zs M T >BfSk$?H$G}I ed3'1-L F3K$ /F7A.M$.Led3ed3 F2J 2Frr=c2eZdZdZdZeeddZeeddZee dZ eeddZ ee d Z ed edZeed ed Zeed ed ZeddeddfZy)KnowledgeEntityu Knowledge graph entity records — public schema mirror of KG jsonl files. Written by the RLM bloodstream pipeline when new entities are ingested. Indexed by entity_type and category for fast retrieval by scout agents. knowledge_entitiesTr r)Fr'?rBmetadatar"r$r!ix_knowledge_entities_type entity_typeix_knowledge_entities_categorycategoryN)rrrrr/rrrErYr contentr[r confidencer metadata_rr created_at updated_atr r;rrrrQrQus)M s  .Bu5KTD)GfSkD1Hs+Jz548I$W J$W J *M: . ;NrrQc.eZdZdZdZeeddZeedZ eedZ eedZ eedZ ee dZeed Zed edZeeed  Zeeed  Zed deddeddfZy)PlPreferencePairz Human preference pairs for Bradley-Terry model training. preference values: -1 = output_b preferred 0 = tie +1 = output_a preferred pl_preference_pairsTr?Fr'rUrBkinanrVr$rWzpreference IN (-1, 0, 1)ck_preference_validnameidx_pl_prefs_createdr_idx_pl_prefs_annotator annotator_idN)rrrrr/rrrEr input_textoutput_aoutput_b preferencerr]rjrr^rr r_r`r r r;rrrrbrbs*M T >Bu-JdU+HdU+H%0Js+J$0Lz548Ig?Jg?J 29NO $l3 &7NrrbceZdZdZdZeeddZeedZ eedZ eedZ eedZ ee dZee dZee dZed edZeeed  Zed d eddfZy)RlmPreferencePairz+Preference pairs for reward model training.rlm_preference_pairsTr?r'FrdrBrVr$rWidx_rlm_prefs_createdr_idx_rlm_prefs_marginmarginN)rrrrr/rrrEr rk chosen_outputrejected_outputrjrreward_score_chosenreward_score_rejectedrtrr^rr r_r r;rrrrprps5*M T >Bt,J4%0MTE2O$0L 6"548 ED )Fz548Ig?J %|4 $h/Nrrpc:eZdZdZdZeeddZeedZ eedZ eedZ ee egZ eedd Zeed ZeedZed edZeeed  ZeddeddeddfZy)CaiCritiqueLogz,Constitutional AI critique and revision log.cai_critique_logTr?Fr'rBrCmediumrVr$rWz1severity IN ('low', 'medium', 'high', 'critical')ck_cai_severityrfidx_cai_critiques_createdr_idx_cai_critiques_severityseverityN)rrrrr/rrrEr original_outputcritiquerevised_outputrviolated_principlesrrrevision_countrfinal_harm_scorerr^rr r_r r r;rrrrzrzs6&M T >BTE2OdU+HD40N tb9fRj(3HGQ/Ned3z548Ig?J  ?"  )<8 *J7 NrrzceZdZdZdZeeddZeeddd Z eed d Z eed d Z eed d Z eedd Z eedZeedZeededZeededZeedZeddeddeddeddfZy) RlmTenantaIRLM Neo-Cortex tenant registration. Stores tenant-to-tier mapping for the entitlement ledger. Source of truth for what tier a SubAIVA customer is on. VERIFICATION_STAMP Story: 2.06 Verified By: parallel-builder Verified At: 2026-02-26 Tests: see tests/rlm/test_entitlement.py Coverage: 100% rlm_tenantsTrrTrCFstarterr+r)r'@zau-eastrBrr"r$rWz:tier IN ('starter', 'professional', 'enterprise', 'queen')ck_rlm_tenant_tierrfix_rlm_tenants_stripestripe_customer_idix_rlm_tenants_tiertierix_rlm_tenants_active is_activeN)rrrrr/rr tenant_idrrrstripe_subscription_idencryption_key_hashregionrmemory_usage_mbrtotal_memoriesrr r_r`rrr r r;rrrrrs "M TI &*ui @Ds d;#F3K$? d; F2J 2FUC0OGQ/N$G}J$G}Jw-I  H%  %';< #V, %{3NrrceZdZdZdZeeddZeeddZ ee ddZ ee ddZ ee d ed  Zed d eddfZy)RlmTenantAuditzAudit log for tier changes on RLM tenants. Written by EntitlementLedger.update_tier() for tracking upgrade/downgrade history. rlm_tenants_auditTr?rFr'rCr"r$rWix_rlm_tenants_audit_tenantrix_rlm_tenants_audit_changed changed_atN)rrrrr/rrrErrrold_tiernew_tierrr rr r;rrrrrs (M T >BtD)E:IfRj51HfRj51H$G}J +[9 ,l;Nrrc eZdZdZdZeeddZeeddZ ee dZ ee ddZ ee d dZee d dZee d dd Zeed ZeedZee d dZededZeededZeededZeddeddeddeddeddedddeddd fZy!)" RlmMemoryaIndividual memory record for tenant-partitioned storage. Each memory belongs to exactly one tenant (tenant_id). Deduplication enforced per tenant via (tenant_id, content_hash) unique constraint. Row-Level Security filters rows by app.tenant_id session variable so tenant A never sees tenant B's data. VERIFICATION_STAMP Story: 6.08 Verified By: parallel-builder Verified At: 2026-02-26 Tests: 5/5 Coverage: 100% rlm_memoriesTr?rFr'rr)rCworkingr+rrBrrVr"r$rWz=memory_tier IN ('discard', 'working', 'episodic', 'semantic')ck_rlm_memory_tierrfix_rlm_memories_tenantrix_rlm_memories_hash content_hashix_rlm_memories_tier memory_tierix_rlm_memories_accessed last_accessedix_rlm_memories_tenant_tieruq_rlm_memory_dedupN)rrrrr/rrrErrr r\rrsourcedomainrrsurprise_score access_count vector_idrr^rr r_rr r r r;rrrrr;sJ #M T >BtD)E:ITE*G&*u5L F3K% 0F F3K% 0Fr UIKE3/N'1-Lvc{T2Iz548I$W J$W M  K%  & 4 $n5 $m4 (/: +[-H .C  NrrceZdZdZdZeeddZeeddZ ee dde d  Z eed Z eed Zeed Zeed d Zeed ZeddfZy) RlmShredAuditaAudit log for cryptographic shredding events. Written when a tenant's data is cryptographically shredded (Right to Erasure compliance). VERIFICATION_STAMP Story: 6.08 Verified By: parallel-builder Verified At: 2026-02-26 Tests: 3/3 Coverage: 100% rlm_shred_auditTr?rFr'r"r$r%rrBr)systemright_to_erasureix_rlm_shred_audit_tenantrN)rrrrr/rrrErrrr shredded_atmemories_shreddedvectors_deletedredis_keys_deletedr initiated_byr reasonr r;rrrrrrs &M T >BtD)E:I$G}K w2Wa0O3&+x8L D"4 5F );7NrrN)r sqlalchemyrrrrrrr r r r r rsqlalchemy.dialects.postgresqlrrsqlalchemy.ormrrrr=rQrbrprzrrrrrrrrs.    7*>?>!!H3t36dFt>.T@--`T:44nDr