ur_ingest_session_fs_path_entry

Column	Type	PK	Required	Default
ur_ingest_session_fs_path_entry_id	VARCHAR	Yes	Yes
ingest_session_id	VARCHAR	No	Yes
ingest_fs_path_id	VARCHAR	No	Yes
uniform_resource_id	VARCHAR	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	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" 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")
)