diff options
| author | nsfisis <nsfisis@gmail.com> | 2025-12-31 14:19:22 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2025-12-31 14:19:22 +0900 |
| commit | b074a4901c630ee5c5f7dcff79fa6ff911a14ded (patch) | |
| tree | a52b738974393e31678c85e37756004d1b547823 /src/server/db/schema.ts | |
| parent | 29caaa7aaf14a41dad3d345cd29b319fff6e1305 (diff) | |
| download | kioku-b074a4901c630ee5c5f7dcff79fa6ff911a14ded.tar.gz kioku-b074a4901c630ee5c5f7dcff79fa6ff911a14ded.tar.zst kioku-b074a4901c630ee5c5f7dcff79fa6ff911a14ded.zip | |
feat(schema): make note_id and is_reversed NOT NULL
All cards now require note association - legacy card support removed.
This aligns with the note-based card architecture introduced in Phase 8.
- Add database migration for NOT NULL constraints
- Update client Dexie schema to version 3
- Remove LegacyCardItem component and legacy card handling
- Update sync schemas and type definitions
- Update all tests to use note-based cards
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
Diffstat (limited to 'src/server/db/schema.ts')
| -rw-r--r-- | src/server/db/schema.ts | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/src/server/db/schema.ts b/src/server/db/schema.ts index bd3d396..0471a92 100644 --- a/src/server/db/schema.ts +++ b/src/server/db/schema.ts @@ -153,8 +153,10 @@ export const cards = pgTable("cards", { deckId: uuid("deck_id") .notNull() .references(() => decks.id), - noteId: uuid("note_id").references(() => notes.id), - isReversed: boolean("is_reversed"), + noteId: uuid("note_id") + .notNull() + .references(() => notes.id), + isReversed: boolean("is_reversed").notNull(), front: text("front").notNull(), back: text("back").notNull(), |