index / wizardsofodd / CouncilTurn

CouncilTurn entity

table council_turns · pk councilId, ordinal

Fields

Field	Type
councilId	string	required ≤16
ordinal	int	required
round	int	required deprecated default 0
wizardId	string	required ≤32
wizardName	string	required ≤128
kind	enum	required enum
	wizarderror
stance	enum	required default abstains enum
	supportsopposescomplicatesreframesabstains ★
takeMarkdown	string	required
oneLineSummary	string	required ≤140
confidence	float	required default 0 min=0 max=1
keyClaims[]	string	required default [] @column=key_claims_json
citations[]	object	⊃ SourceLens @column=citations_json @storage=jsonb

Indexes & keys

Name	Kind	Fields	Detail
fk_council	fk	councilId	→ wizardsofodd::Council
primary	primary	councilId, ordinal

Relationships

council

one

Council

@onDelete=cascade

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"
  }
  SourceLens["⬭ SourceLens"] {
    string title "req"
    string url "req"
    string snippet "req"
  }
  Council ||--o{ CouncilTurn : "council · cascade"
  SourceLens ||--o{ CouncilTurn : "citations"
  Council:::c_Council
  classDef c_Council fill:#14342b,stroke:#3b5170,color:#cbd5e1
  CouncilTurn:::c_CouncilTurn
  classDef c_CouncilTurn fill:#14342b,stroke:#60a5fa,color:#cbd5e1
  SourceLens:::c_SourceLens
  classDef c_SourceLens fill:#14342b,stroke:#3b5170,color:#cbd5e1,stroke-dasharray:5 3

▭ entity · ⬭ value object · ▱ view (ER boxes: dashed = value, dotted = view)

meta-council-turn.yaml