CREATE TABLE Post (
id INT,
published BOOL CHECK(published IN(TRUE,FALSE))
);
INSERT INTO Post (id, published)
VALUES
(1, true),
(2, true),
(3, false),
(4, true),
(5, true),
(6, false),
(7, true);
CREATE TABLE Pages (
id INT,
published BOOL CHECK(published IN(TRUE,FALSE))
);
INSERT INTO Pages (id, published)
VALUES
(1, false),
(2, true),
(3, true);
CREATE TABLE Products (
id INT,
published BOOL CHECK(published IN(TRUE,FALSE))
);
SELECT * FROM Post;
SELECT * FROM Pages;
SELECT * FROM Products;