From b074a4901c630ee5c5f7dcff79fa6ff911a14ded Mon Sep 17 00:00:00 2001 From: nsfisis Date: Wed, 31 Dec 2025 14:19:22 +0900 Subject: feat(schema): make note_id and is_reversed NOT NULL MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit 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 --- src/server/db/schema.ts | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'src/server/db') 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(), -- cgit v1.2.3-70-g09d2