Skip to content

ur_ingest_session_fs_path_entry

Description

Contains entries related to file system content ingestion paths. On multiple executions, unlike uniform_resource, ur_ingest_session_fs_path_entry rows are always inserted and references the uniform_resource primary key of its related content. This method allows for a more efficient query of file version differences across sessions. With SQL queries, you can detect which sessions have a file added or modified, which sessions have a file deleted, and what the differences are in file contents if they were modified across sessions.

Table Definition
CREATE TABLE "ur_ingest_session_fs_path_entry" (
"ur_ingest_session_fs_path_entry_id" VARCHAR PRIMARY KEY NOT NULL,
"ingest_session_id" VARCHAR NOT NULL,
"ingest_fs_path_id" VARCHAR NOT NULL,
"uniform_resource_id" VARCHAR,
"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 CHECK(json_valid(captured_executable) OR captured_executable IS NULL),
"ur_status" TEXT,
"ur_diagnostics" TEXT CHECK(json_valid(ur_diagnostics) OR ur_diagnostics IS NULL),
"ur_transformations" TEXT CHECK(json_valid(ur_transformations) OR ur_transformations IS NULL),
"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,
FOREIGN KEY("ingest_session_id") REFERENCES "ur_ingest_session"("ur_ingest_session_id"),
FOREIGN KEY("ingest_fs_path_id") REFERENCES "ur_ingest_session_fs_path"("ur_ingest_session_fs_path_id"),
FOREIGN KEY("uniform_resource_id") REFERENCES "uniform_resource"("uniform_resource_id")
)

Columns

NameTypeDefaultNullableParentsComment
ur_ingest_session_fs_path_entry_idVARCHARfalse{“isSqlDomainZodDescrMeta”:true ,“isVarChar”:true }
ingest_session_idVARCHARfalseur_ingest_session{“isSqlDomainZodDescrMeta”:true ,“isVarChar”:true }
ingest_fs_path_idVARCHARfalseur_ingest_session_fs_path{“isSqlDomainZodDescrMeta”:true ,“isVarChar”:true }
uniform_resource_idVARCHARtrueuniform_resource{“isSqlDomainZodDescrMeta”:true ,“isVarChar”:true }
file_path_absTEXTfalse
file_path_rel_parentTEXTfalse
file_path_relTEXTfalse
file_basenameTEXTfalse
file_extnTEXTtrue
captured_executableTEXTtrue{“isSqlDomainZodDescrMeta”:true ,“isJsonText”:true }
ur_statusTEXTtrue
ur_diagnosticsTEXTtrue{“isSqlDomainZodDescrMeta”:true ,“isJsonText”:true }
ur_transformationsTEXTtrue{“isSqlDomainZodDescrMeta”:true ,“isJsonText”:true }
elaborationTEXTtrue{“isSqlDomainZodDescrMeta”:true ,“isJsonText”:true }
created_atTIMESTAMPTZCURRENT_TIMESTAMPtrue
created_byTEXT’UNKNOWN’true
updated_atTIMESTAMPTZtrue
updated_byTEXTtrue
deleted_atTIMESTAMPTZtrue
deleted_byTEXTtrue
activity_logTEXTtrue{“isSqlDomainZodDescrMeta”:true ,“isJsonSqlDomain”:true }

Constraints

NameTypeDefinition
ur_ingest_session_fs_path_entry_idPRIMARY KEYPRIMARY KEY (ur_ingest_session_fs_path_entry_id)
- (Foreign key ID: 0)FOREIGN KEYFOREIGN KEY (uniform_resource_id) REFERENCES uniform_resource (uniform_resource_id) ON UPDATE NO ACTION ON DELETE NO ACTION MATCH NONE
- (Foreign key ID: 1)FOREIGN KEYFOREIGN 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 MATCH NONE
- (Foreign key ID: 2)FOREIGN KEYFOREIGN KEY (ingest_session_id) REFERENCES ur_ingest_session (ur_ingest_session_id) ON UPDATE NO ACTION ON DELETE NO ACTION MATCH NONE
sqlite_autoindex_ur_ingest_session_fs_path_entry_1PRIMARY KEYPRIMARY KEY (ur_ingest_session_fs_path_entry_id)
-CHECKCHECK(json_valid(captured_executable) OR captured_executable IS NULL)
-CHECKCHECK(json_valid(ur_diagnostics) OR ur_diagnostics IS NULL)
-CHECKCHECK(json_valid(ur_transformations) OR ur_transformations IS NULL)
-CHECKCHECK(json_valid(elaboration) OR elaboration IS NULL)

Indexes

NameDefinition
idx_ur_ingest_session_fs_path_entry__ingest_session_id__file_path_absCREATE INDEX “idx_ur_ingest_session_fs_path_entry__ingest_session_id__file_path_abs” ON “ur_ingest_session_fs_path_entry”(“ingest_session_id”, “file_path_abs”)
sqlite_autoindex_ur_ingest_session_fs_path_entry_1PRIMARY KEY (ur_ingest_session_fs_path_entry_id)

Relations

er