public.operations_log¶

Description¶

Audit trail of all HTM operations for debugging and replay

Name	Type	Default	Nullable	Parents	Comment
id	bigint	nextval('operations_log_id_seq'::regclass)	false
timestamp	timestamp with time zone	CURRENT_TIMESTAMP	true		When this operation occurred
operation	text		false		Operation type: add, retrieve, remove, evict, recall
node_id	bigint		true	public.nodes	ID of the node affected by this operation (if applicable)
robot_id	text		false	public.robots	ID of the robot that performed this operation
details	jsonb		true		Additional operation details and context

Name	Type	Definition
fk_rails_8df7440180	FOREIGN KEY	FOREIGN KEY (robot_id) REFERENCES robots(id) ON DELETE CASCADE
fk_rails_f1b5294e6b	FOREIGN KEY	FOREIGN KEY (node_id) REFERENCES nodes(id) ON DELETE CASCADE
operations_log_pkey	PRIMARY KEY	PRIMARY KEY (id)

Name	Definition
operations_log_pkey	CREATE UNIQUE INDEX operations_log_pkey ON public.operations_log USING btree (id)
idx_operations_log_timestamp	CREATE INDEX idx_operations_log_timestamp ON public.operations_log USING btree ("timestamp")
idx_operations_log_robot_id	CREATE INDEX idx_operations_log_robot_id ON public.operations_log USING btree (robot_id)
idx_operations_log_node_id	CREATE INDEX idx_operations_log_node_id ON public.operations_log USING btree (node_id)
idx_operations_log_operation	CREATE INDEX idx_operations_log_operation ON public.operations_log USING btree (operation)

Generated by tbls