#72 DB Migration: API Keys Table

Create database migration for API keys table. Migration File: engine/migrations/sql/XXX_api_keys_table.sql Table: api_keys Columns: - id: uuid primary key - user_id: uuid (foreign key to users) - tenant_id: varchar(100) - name: varchar(100) - key_hash: varchar(64) unique (SHA256 of API key) - key_prefix: varchar(8) (for identification, e.g., 'hw_live_') - permissions: text[] (array of permissions) - created_at: timestamp - expires_at: timestamp - last_used_at: timestamp - last_used_ip: inet - is_active: boolean default true - revoked_at: timestamp - revoked_by: uuid Indexes: - idx_api_keys_user_id - idx_api_keys_tenant_active - idx_api_keys_key_hash - idx_api_keys_expires_at With ultra attention to details and correctness. Before closing: write comment summarizing implementation with screenshot.