ur_ingest_session_fs_path_entry

Column	Type	PK	Required	Default
ur_ingest_session_fs_path_entry_id	TEXT	Yes	Yes
ingest_session_id	TEXT	No	Yes
ingest_fs_path_id	TEXT	No	Yes
uniform_resource_id	TEXT	No	No
file_path_abs	TEXT	No	Yes
file_path_rel_parent	TEXT	No	Yes
file_path_rel	TEXT	No	Yes
file_basename	TEXT	No	Yes
file_extn	TEXT	No	No
captured_executable	TEXT	No	No
ur_status	TEXT	No	No
ur_diagnostics	TEXT	No	No
ur_transformations	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

Column Name	Foreign Key
uniform_resource_id	uniform_resource_id references uniform_resource.uniform_resource_id
ingest_fs_path_id	ingest_fs_path_id references ur_ingest_session_fs_path.ur_ingest_session_fs_path_id
ingest_session_id	ingest_session_id references ur_ingest_session.ur_ingest_session_id

Indexes

Column Name	Index Name
ingest_session_id	uq_ur_ingest_session_fs_path_entry__ingest_session_id__ingest_fs_path_id__file_path_abs
ingest_fs_path_id	uq_ur_ingest_session_fs_path_entry__ingest_session_id__ingest_fs_path_id__file_path_abs
file_path_abs	uq_ur_ingest_session_fs_path_entry__ingest_session_id__ingest_fs_path_id__file_path_abs
ingest_session_id	idx_ur_ingest_session_fs_path_entry__ingest_session_id__file_path_abs
file_path_abs	idx_ur_ingest_session_fs_path_entry__ingest_session_id__file_path_abs
ur_ingest_session_fs_path_entry_id	sqlite_autoindex_ur_ingest_session_fs_path_entry_1

SQL DDL

CREATE TABLE `ur_ingest_session_fs_path_entry` (
	`ur_ingest_session_fs_path_entry_id` text PRIMARY KEY NOT NULL,
	`ingest_session_id` text NOT NULL,
	`ingest_fs_path_id` text NOT NULL,
	`uniform_resource_id` text,
	`file_path_abs` text NOT NULL,
	`file_path_rel_parent` text NOT NULL,
	`file_path_rel` text NOT NULL,
	`file_basename` text NOT NULL,
	`file_extn` text,
	`captured_executable` text,
	`ur_status` text,
	`ur_diagnostics` text,
	`ur_transformations` 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,
	FOREIGN KEY (`ingest_session_id`) REFERENCES `ur_ingest_session`(`ur_ingest_session_id`) ON UPDATE no action ON DELETE no action,
	FOREIGN KEY (`ingest_fs_path_id`) REFERENCES `ur_ingest_session_fs_path`(`ur_ingest_session_fs_path_id`) ON UPDATE no action ON DELETE no action,
	FOREIGN KEY (`uniform_resource_id`) REFERENCES `uniform_resource`(`uniform_resource_id`) ON UPDATE no action ON DELETE no action,
	CONSTRAINT "captured_executable_check_valid_json" CHECK(json_valid("ur_ingest_session_fs_path_entry"."captured_executable") OR "ur_ingest_session_fs_path_entry"."captured_executable" IS NULL),
	CONSTRAINT "ur_diagnostics_check_valid_json" CHECK(json_valid("ur_ingest_session_fs_path_entry"."ur_diagnostics") OR "ur_ingest_session_fs_path_entry"."ur_diagnostics" IS NULL),
	CONSTRAINT "ur_transformations_check_valid_json" CHECK(json_valid("ur_ingest_session_fs_path_entry"."ur_transformations") OR "ur_ingest_session_fs_path_entry"."ur_transformations" IS NULL),
	CONSTRAINT "elaboration_check_valid_json" CHECK(json_valid("ur_ingest_session_fs_path_entry"."elaboration") OR "ur_ingest_session_fs_path_entry"."elaboration" IS NULL)
)