>_
.issue.db
/highway-workflow-engine
Dashboard
Issues
Memory
Lessons
Audit Log
New Issue
Edit Issue #71
Update issue details
Title *
Description
Create database migration for sessions tracking table. Migration File: engine/migrations/sql/XXX_sessions_table.sql Table: sessions Columns: - id: uuid primary key - user_id: uuid (foreign key to users) - tenant_id: varchar(100) - token_hash: varchar(64) unique (SHA256 of JWT) - ip_address: inet - user_agent: text - created_at: timestamp - last_activity_at: timestamp - expires_at: timestamp - is_active: boolean default true - terminated_at: timestamp - terminated_by: uuid (foreign key to users) - termination_reason: varchar(100) Indexes: - idx_sessions_user_id - idx_sessions_tenant_active - idx_sessions_expires_at - idx_sessions_token_hash 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