CREATE DATABASE '<путь_к_БД>'
USER 'SYSDBA' PASSWORD 'masterke'
PAGE_SIZE 4096
DEFAULT CHARACTER SET UTF8;

CREATE DOMAIN ID99 AS SMALLINT
  CHECK (NOT(VALUE IS NOT NULL AND (VALUE < 1 OR VALUE > 99)));
CREATE DOMAIN ID0099 AS SMALLINT
  CHECK (NOT(VALUE IS NOT NULL AND (VALUE < 1 OR VALUE > 9999)));
CREATE DOMAIN NAME AS VARCHAR(158) CHARACTER SET UTF8 COLLATE UNICODE_CI_AI;
COMMIT WORK;

CREATE TABLE "range"
(
    "id"    ID0099  NOT NULL,
    "rr_id" ID99    DEFAULT NULL,
    "name"  NAME    NOT NULL,
  CONSTRAINT "range__pk" PRIMARY KEY ("id"),
  CONSTRAINT "range__fk__rr" FOREIGN KEY ("rr_id")
    REFERENCES "rr" ("id") ON UPDATE CASCADE ON DELETE SET NULL,
  CONSTRAINT "range__uq" UNIQUE ("rr_id", "name")
);
COMMIT WORK;

Cast(Coalesce(Right('000000' || Cast("rr_id" AS VARCHAR(6)), 6), '') || "name" AS VARCHAR(5) CHARACTER SET UTF8)

Cast(Coalesce(Right('000000' || Cast("rr_id" AS VARCHAR(6)), 6), '') || "name" AS VARCHAR(224) CHARACTER SET UTF8)

CONSTRAINT "range__pk" PRIMARY KEY ("id"),