Card deck db schema for PostgreSQL

card-deck.data.sql

INSERT INTO "ranks" VALUES
('A'), ('K'), ('Q'), ('J'), ('1'), ('2'), ('3'), ('4'), ('5'), ('6'), ('7'), ('8'), ('9'), ('10');

INSERT INTO "suits" VALUES
('♥️'), ('♠️'), ('♣️'), ('♦️');

INSERT INTO "brands" VALUES
('b1'), ('b2');

card-deck.schema.sql

CREATE TABLE "ranks" (
  "name" TEXT PRIMARY KEY
);

CREATE TABLE "suits" (
  "name" TEXT PRIMARY KEY
);

CREATE TABLE "brands" (
  "name" TEXT PRIMARY KEY
);

cartesian-product.query.sql

SELECT * FROM "ranks"
CROSS JOIN "suits"
CROSS JOIN "brands";

DBFiddle:
https://www.db-fiddle.com/f/eo9h9Dd3AGEEVhrHG5S595/3