CREATE TABLE items (
    id INTEGER NOT NULL PRIMARY KEY,
    name TEXT NOT NULL,
    durability INTEGER DEFAULT NULL,
    description TEXT DEFAULT NULL
);

CREATE TABLE effects (
    id INTEGER NOT NULL PRIMARY KEY,
    name TEXT NOT NULL,
    power INTEGER NOT NULL DEFAULT 1
);

CREATE TABLE character_has_item (
    id INTEGER NOT NULL PRIMARY KEY,
    character_id INTEGER NOT NULL,
    item_id INTEGER NOT NULL,
    usage INTEGER DEFAULT NULL,
    source TEXT DEFAULT NULL
);