Council entity
table
councils
· pk idFields
| Field | Type | Description | |
|---|---|---|---|
| id | string | ≤8 regex ^[abcdefghijkmnopqrstuvwxyzABCDEFGHJKLMNPQRSTUVWXYZ23456789]{8}$ | |
| visitorId | string | required ≤64 | |
| question | string | required | |
| status | enum | required enum | |
| pendingpartialcompleteerror | |||
| verdictStance | enum | enum | |
| yesnoit_dependsunanswerable | |||
| verdictConfidence | float | ||
| verdictMarkdown | string | ||
| verdictEvidenceQuality | enum | enum | |
| strongmixedthinnone | |||
| dissents[] | object | ⊃ Dissent @column=dissents_json @storage=jsonb | |
| verdictAgreements[] | string | @column=verdict_agreements_json | |
| verdictSplits[] | string | @column=verdict_splits_json | |
| verdictVerifyNote | string | @column=verdict_verify_note | |
| createdAt | long | required | |
| completedAt | long | ||
Indexes & keys
| Name | Kind | Fields | Detail |
|---|---|---|---|
| primary | primary | id |
Neighborhood
%%{init: {'theme':'base','themeVariables':{'darkMode':true,'background':'#0b1220','primaryColor':'#1e2a3a','primaryTextColor':'#cbd5e1','primaryBorderColor':'#4a7fa5','lineColor':'#64748b','secondaryColor':'#1a2535','tertiaryColor':'#0f1826','fontSize':'13px'}}}%%
erDiagram
Council["▭ Council"] {
string id PK ""
enum status "enum"
enum verdictStance "enum"
enum verdictEvidenceQuality "enum"
string visitorId "req"
string question "req"
_ plus "+1 more"
}
CouncilTurn["▭ CouncilTurn"] {
string councilId PK ""
int ordinal PK ""
enum kind "enum"
enum stance "enum"
int round "req"
string wizardId "req"
_ plus "+5 more"
}
Dissent["⬭ Dissent"] {
string wizardId "req"
string reason "req"
}
Council ||--o{ CouncilTurn : "council · cascade"
Dissent ||--o{ Council : "dissents"
Council:::c_Council
classDef c_Council fill:#14342b,stroke:#60a5fa,color:#cbd5e1
CouncilTurn:::c_CouncilTurn
classDef c_CouncilTurn fill:#14342b,stroke:#3b5170,color:#cbd5e1
Dissent:::c_Dissent
classDef c_Dissent fill:#14342b,stroke:#3b5170,color:#cbd5e1,stroke-dasharray:5 3▭ entity · ⬭ value object · ▱ view (ER boxes: dashed = value, dotted = view)
meta-council.yaml