ur_ingest_session_attachment

Column	Type	PK	Required	Default
ur_ingest_session_attachment_id	TEXT	Yes	Yes
uniform_resource_id	TEXT	No	No
name	TEXT	No	No
uri	TEXT	No	Yes
content	BLOB	No	No
nature	TEXT	No	No
size	INTEGER	No	No
checksum	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

Indexes

Column Name	Index Name
uniform_resource_id	ur_ingest_session_attachment_uniform_resource_id_checksum_nature_size_unique
checksum	ur_ingest_session_attachment_uniform_resource_id_checksum_nature_size_unique
nature	ur_ingest_session_attachment_uniform_resource_id_checksum_nature_size_unique
size	ur_ingest_session_attachment_uniform_resource_id_checksum_nature_size_unique
uniform_resource_id	idx_ur_ingest_session_attachment__uniform_resource_id__content
content	idx_ur_ingest_session_attachment__uniform_resource_id__content
ur_ingest_session_attachment_id	sqlite_autoindex_ur_ingest_session_attachment_1

SQL DDL

CREATE TABLE `ur_ingest_session_attachment` (
	`ur_ingest_session_attachment_id` text PRIMARY KEY NOT NULL,
	`uniform_resource_id` text,
	`name` text,
	`uri` text NOT NULL,
	`content` blob,
	`nature` text,
	`size` integer,
	`checksum` 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 (`uniform_resource_id`) REFERENCES `uniform_resource`(`uniform_resource_id`) ON UPDATE no action ON DELETE no action
)