Define SurrealDB schema for all entities #11

Open
opened 2026-10-30 20:57:24 -06:00 by west · 0 comments
Owner

📋 Create the SurrealDB schema matching the data model.

🎯 Acceptance Criteria:

  • Tables defined: transaction, recurring_transaction, distributed_transaction, expense_source, tag, sync_outbox
  • Indexes created for efficient querying (date, tags, sourceId, lastModified)
  • Sync metadata fields on all entities (lastModified, device_id, version)
  • Sequence counter table for sync_outbox
  • Schema migration strategy defined

📝 Notes: This mirrors the iOS data model but on the server side. All DM issues must be complete before this.

📋 **Create the SurrealDB schema matching the data model.** 🎯 **Acceptance Criteria:** - [ ] Tables defined: transaction, recurring_transaction, distributed_transaction, expense_source, tag, sync_outbox - [ ] Indexes created for efficient querying (date, tags, sourceId, lastModified) - [ ] Sync metadata fields on all entities (lastModified, device_id, version) - [ ] Sequence counter table for sync_outbox - [ ] Schema migration strategy defined 📝 **Notes:** This mirrors the iOS data model but on the server side. All DM issues must be complete before this.
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Reference
west/waterline#11
No description provided.