CREATE TABLE Products (
    id INT NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
    name VARCHAR(64) NOT NULL,
    UNIQUE(name)
);

CREATE TABLE Tags (
    id INT NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
    tagName VARCHAR(64) NOT NULL,
    tagValue VARCHAR(64) NOT NULL,
    UNIQUE(tagName, tagValue)
);

CREATE TABLE ProductsTags (
    productId INT NOT NULL,
    tagId INT NOT NULL,
    FOREIGN KEY(productId) REFERENCES Products(id) ON DELETE CASCADE,
    FOREIGN KEY(tagId ) REFERENCES Tags(id) ON DELETE CASCADE
);