ur_ingest_resource_path_match_rule

Column	Type	PK	Required	Default
ur_ingest_resource_path_match_rule_id	TEXT	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
include_glob_patterns	TEXT[]	No	No
exclude_glob_patterns	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	unq_path_match_regex
regex	unq_path_match_regex
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` text PRIMARY KEY NOT NULL,
	`namespace` text NOT NULL,
	`regex` text NOT NULL,
	`flags` text NOT NULL,
	`nature` text,
	`priority` text,
	`description` text,
	`include_glob_patterns` TEXT[],
	`exclude_glob_patterns` TEXT[],
	`elaboration` text,
	`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,
	CONSTRAINT "elaboration_check_valid_json" CHECK(json_valid("ur_ingest_resource_path_match_rule"."elaboration") OR "ur_ingest_resource_path_match_rule"."elaboration" IS NULL)
)