backend/migrations/004-create_wishlist_entry.sql

   1 CREATE TABLE WISHLIST_ENTRY(
   2     WISHLIST_ID TEXT NOT NULL REFERENCES WISHLIST(ID),
   3     ITEM_ID INTEGER NOT NULL REFERENCES ITEM(ID),
   4     NAME TEXT NOT NULL,
   5     DESCRIPTION TEXT,
   6     PRIMARY KEY(WISHLIST_ID, ITEM_ID)
   7 );