Uniform Resource Ingest Resource Path Rewrite Rule

Description

A regular expression can determine whether certain paths should be
rewritten before ur_ingest_resource_path_match_rule matches occur.

Table Definition

CREATE TABLE "ur_ingest_resource_path_rewrite_rule" (
    "ur_ingest_resource_path_rewrite_rule_id" VARCHAR PRIMARY KEY NOT NULL,
    "namespace" TEXT NOT NULL,
    "regex" TEXT NOT NULL,
    "replace" TEXT NOT NULL,
    "priority" TEXT,
    "description" TEXT,
    "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL),
    "created_at" TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP,
    "created_by" TEXT DEFAULT 'UNKNOWN',
    "updated_at" TIMESTAMPTZ,
    "updated_by" TEXT,
    "deleted_at" TIMESTAMPTZ,
    "deleted_by" TEXT,
    "activity_log" TEXT,
    UNIQUE("namespace", "regex", "replace")
)

Columns

Name	Type	Default	Nullable	Comment
ur_ingest_resource_path_rewrite_rule_id	VARCHAR		false	{“isSqlDomainZodDescrMeta”:true,“isVarChar”:true}
namespace	TEXT		false
regex	TEXT		false
replace	TEXT		false
priority	TEXT		true
description	TEXT		true
elaboration	TEXT		true	{“isSqlDomainZodDescrMeta”:true,“isJsonText”:true}
created_at	TIMESTAMPTZ	CURRENT_TIMESTAMP	true
created_by	TEXT	’UNKNOWN’	true
updated_at	TIMESTAMPTZ		true
updated_by	TEXT		true
deleted_at	TIMESTAMPTZ		true
deleted_by	TEXT		true
activity_log	TEXT		true	{“isSqlDomainZodDescrMeta”:true,“isJsonSqlDomain”:true}

Constraints

Name	Type	Definition
ur_ingest_resource_path_rewrite_rule_id	PRIMARY KEY	PRIMARY KEY (ur_ingest_resource_path_rewrite_rule_id)
sqlite_autoindex_ur_ingest_resource_path_rewrite_rule_2	UNIQUE	UNIQUE (namespace, regex, replace)
sqlite_autoindex_ur_ingest_resource_path_rewrite_rule_1	PRIMARY KEY	PRIMARY KEY (ur_ingest_resource_path_rewrite_rule_id)
-	CHECK	CHECK(json_valid(elaboration) OR elaboration IS NULL)

Indexes

Name	Definition
sqlite_autoindex_ur_ingest_resource_path_rewrite_rule_2	UNIQUE (namespace, regex, replace)
sqlite_autoindex_ur_ingest_resource_path_rewrite_rule_1	PRIMARY KEY (ur_ingest_resource_path_rewrite_rule_id)

Relations