uniform_resource_transform

Column	Type	PK	Required	Default
uniform_resource_transform_id	VARCHAR	Yes	Yes
uniform_resource_id	VARCHAR	No	Yes
uri	TEXT	No	Yes
content_digest	TEXT	No	Yes
content	BLOB	No	No
nature	TEXT	No	No
size_bytes	INTEGER	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

Indexes

Column Name	Index Name
uniform_resource_id	idx_uniform_resource_transform__uniform_resource_id__content_digest
content_digest	idx_uniform_resource_transform__uniform_resource_id__content_digest
uniform_resource_id	sqlite_autoindex_uniform_resource_transform_2
content_digest	sqlite_autoindex_uniform_resource_transform_2
nature	sqlite_autoindex_uniform_resource_transform_2
size_bytes	sqlite_autoindex_uniform_resource_transform_2
uniform_resource_transform_id	sqlite_autoindex_uniform_resource_transform_1

SQL DDL

CREATE TABLE "uniform_resource_transform" (
    "uniform_resource_transform_id" VARCHAR PRIMARY KEY NOT NULL,
    "uniform_resource_id" VARCHAR NOT NULL,
    "uri" TEXT NOT NULL,
    "content_digest" TEXT NOT NULL,
    "content" BLOB,
    "nature" TEXT,
    "size_bytes" INTEGER,
    "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("uniform_resource_id") REFERENCES "uniform_resource"("uniform_resource_id"),
    UNIQUE("uniform_resource_id", "content_digest", "nature", "size_bytes")
)