Data: Design and implement DynamoDB tables

[cuevaio]

Description

Design and implement DynamoDB tables for API keys and usage logs.

Tables

API Keys Table

• Validate existing schema
• Ensure proper partition/sort key design

Usage Logs Table

• Design partition/sort keys for efficient per-project and per-key queries
• Include fields:
  • Execution time
  • Billed time
  • Cost
  • Machine type
  • Status
  • Input/output metadata
• Add TTL column (default 6 months)
• Configure TTL on the table

Tasks

• Document table schemas
• Implement table definitions in SST/CDK
• Set up TTL configuration
• Create access patterns documentation
• Add indexes for common query patterns

Acceptance Criteria

• Tables support all required query patterns efficiently
• TTL is properly configured for automatic data expiration
• Schema is documented and version controlled