>_
.issue.db
/highway-workflow-engine
Dashboard
Issues
Memory
Lessons
Audit Log
New Issue
Edit Issue #74
Update issue details
Title *
Description
Enhance existing audit logs table for comprehensive tracking. Migration File: engine/migrations/sql/XXX_audit_logs_enhancement.sql Ensure Table Has: - id: uuid primary key - tenant_id: varchar(100) - user_id: uuid - action_type: varchar(50) - resource_type: varchar(50) - resource_id: varchar(255) - ip_address: inet - user_agent: text - request_id: uuid (for request tracing) - old_values: jsonb - new_values: jsonb - metadata: jsonb - created_at: timestamp - success: boolean - error_message: text Indexes: - idx_audit_tenant_created (tenant_id, created_at DESC) - idx_audit_user (user_id, created_at DESC) - idx_audit_resource (resource_type, resource_id) - idx_audit_action (action_type, created_at DESC) Partitioning: - Consider monthly partitioning for large installations - Retention policy: 2 years default With ultra attention to details and correctness. Before closing: write comment summarizing implementation with screenshot.
Priority
Low
Medium
High
Critical
Status
Open
In Progress
Closed
Due Date (YYYY-MM-DD)
Tags (comma separated)
Related Issues (IDs)
Enter IDs of issues related to this one. They will be linked as 'related'.
Update Issue
Cancel