~bigbes/sr-ht-spec · tree

• Overview
• Tables
• Beads
• Milestones
• Memory

Tables at e7fjp8nscjqg9qn2s063vvrqcntk4v3l

child_counters 2 rows rows

Column	Type	Key	Null
parent_id	varchar(255)	PK	no
last_child	int		no

comments 0 rows rows

Column	Type	Key	Null
id	char(36)	PK	no
issue_id	varchar(255)		no
author	varchar(255)		no
text	longtext		no
created_at	datetime		no

compaction_snapshots 0 rows rows

Column	Type	Key	Null
id	char(36)	PK	no
issue_id	varchar(255)		no
compaction_level	int		no
snapshot_json	blob		no
created_at	datetime		no

config 11 rows rows

Column	Type	Key	Null
key	varchar(255)	PK	no
value	text		no

custom_statuses 0 rows rows

Column	Type	Key	Null
name	varchar(64)	PK	no
category	varchar(32)		no

custom_types 0 rows rows

Column	Type	Key	Null
name	varchar(64)	PK	no

dependencies 16 rows rows

Column	Type	Key	Null
id	char(36)	PK	no
issue_id	varchar(255)		no
type	varchar(32)		no
created_at	datetime		no
created_by	varchar(255)		no
metadata	json		yes
thread_id	varchar(255)		yes
depends_on_issue_id	varchar(255)		yes
depends_on_wisp_id	varchar(255)		yes
depends_on_external	varchar(255)		yes

dolt_ignore 5 rows rows

Column	Type	Key	Null
pattern	text	PK	no
ignored	tinyint(1)		no

dolt_nonlocal_tables 0 rows rows

Column	Type	Key	Null
table_name	varchar(65535)	PK	no
target_ref	varchar(65535)		yes
ref_table	varchar(65535)		yes
options	varchar(65535)		yes

dolt_schemas 2 rows rows

Column	Type	Key	Null
type	varchar(64) COLLATE utf8mb4_0900_ai_ci	PK	no
name	varchar(64) COLLATE utf8mb4_0900_ai_ci	PK	no
fragment	longtext		yes
extra	json		yes
sql_mode	varchar(256) COLLATE utf8mb4_0900_ai_ci		yes

events 34 rows rows

Column	Type	Key	Null
id	char(36)	PK	no
issue_id	varchar(255)		no
event_type	varchar(32)		no
actor	varchar(255)		no
old_value	longtext		yes
new_value	longtext		yes
comment	text		yes
created_at	datetime		no

federation_peers 0 rows rows

Column	Type	Key	Null
name	varchar(255)	PK	no
remote_url	varchar(1024)		no
username	varchar(255)		yes
password_encrypted	blob		yes
sovereignty	varchar(8)		yes
last_sync	datetime		yes
created_at	datetime		no
updated_at	datetime		no

interactions 0 rows rows

Column	Type	Key	Null
id	varchar(32)	PK	no
kind	varchar(64)		no
created_at	datetime		no
actor	varchar(255)		yes
issue_id	varchar(255)		yes
model	varchar(255)		yes
prompt	text		yes
response	text		yes
error	text		yes
tool_name	varchar(255)		yes
exit_code	int		yes
parent_id	varchar(32)		yes
label	varchar(64)		yes
reason	text		yes
extra	json		yes

issue_counter 0 rows rows

Column	Type	Key	Null
prefix	varchar(255)	PK	no
last_id	int		no

issue_snapshots 0 rows rows

Column	Type	Key	Null
id	char(36)	PK	no
issue_id	varchar(255)		no
snapshot_time	datetime		no
compaction_level	int		no
original_size	int		no
compressed_size	int		no
original_content	text		no
archived_events	text		yes

issues 15 rows rows

Column	Type	Key	Null
id	varchar(255)	PK	no
content_hash	varchar(64)		yes
title	varchar(500)		no
description	longtext		no
design	longtext		no
acceptance_criteria	longtext		no
notes	longtext		no
status	varchar(32)		no
priority	int		no
issue_type	varchar(32)		no
assignee	varchar(255)		yes
estimated_minutes	int		yes
created_at	datetime		no
created_by	varchar(255)		yes
owner	varchar(255)		yes
updated_at	datetime		no
closed_at	datetime		yes
closed_by_session	varchar(255)		yes
external_ref	varchar(255)		yes
spec_id	varchar(1024)		yes
compaction_level	int		yes
compacted_at	datetime		yes
compacted_at_commit	varchar(64)		yes
original_size	int		yes
sender	varchar(255)		yes
ephemeral	tinyint(1)		yes
wisp_type	varchar(32)		yes
pinned	tinyint(1)		yes
is_template	tinyint(1)		yes
mol_type	varchar(32)		yes
work_type	varchar(32)		yes
source_system	varchar(255)		yes
metadata	json		yes
source_repo	varchar(512)		yes
close_reason	longtext		yes
event_kind	varchar(32)		yes
actor	varchar(255)		yes
target	varchar(255)		yes
payload	text		yes
await_type	varchar(32)		yes
await_id	varchar(255)		yes
timeout_ns	bigint		yes
waiters	text		yes
hook_bead	varchar(255)		yes
role_bead	varchar(255)		yes
agent_state	varchar(32)		yes
last_activity	datetime		yes
role_type	varchar(32)		yes
rig	varchar(255)		yes
due_at	datetime		yes
defer_until	datetime		yes
no_history	tinyint(1)		yes
started_at	datetime		yes
is_blocked	tinyint(1)		no

labels 0 rows rows

Column	Type	Key	Null
issue_id	varchar(255)	PK	no
label	varchar(255)	PK	no

metadata 4 rows rows

Column	Type	Key	Null
key	varchar(255)	PK	no
value	text		no

routes 0 rows rows

Column	Type	Key	Null
prefix	varchar(32)	PK	no
path	varchar(512)		no
created_at	datetime		no
updated_at	datetime		no

schema_migrations 53 rows rows

Column	Type	Key	Null
version	int	PK	no
content_hash	char(64)		yes