ur_ingest_resource_path_match_rule

Column	Type	PK	Required	Default
ur_ingest_resource_path_match_rule_id	VARCHAR	Yes	Yes
namespace	TEXT	No	Yes
regex	TEXT	No	Yes
flags	TEXT	No	Yes
nature	TEXT	No	No
priority	TEXT	No	No
description	TEXT	No	No
elaboration	TEXT	No	No
created_at	TIMESTAMPTZ	No	No	CURRENT_TIMESTAMP
created_by	TEXT	No	No	'UNKNOWN'
updated_at	TIMESTAMPTZ	No	No
updated_by	TEXT	No	No
deleted_at	TIMESTAMPTZ	No	No
deleted_by	TEXT	No	No
activity_log	TEXT	No	No

Foreign Keys

No data

Indexes

Column Name	Index Name
namespace	sqlite_autoindex_ur_ingest_resource_path_match_rule_2
regex	sqlite_autoindex_ur_ingest_resource_path_match_rule_2
ur_ingest_resource_path_match_rule_id	sqlite_autoindex_ur_ingest_resource_path_match_rule_1

SQL DDL

CREATE TABLE "ur_ingest_resource_path_match_rule" (
    "ur_ingest_resource_path_match_rule_id" VARCHAR PRIMARY KEY NOT NULL,
    "namespace" TEXT NOT NULL,
    "regex" TEXT NOT NULL,
    "flags" TEXT NOT NULL,
    "nature" TEXT,
    "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")
)