uniform_resource

Column	Type	PK	Required	Default
uniform_resource_id	TEXT	Yes	Yes
device_id	TEXT	No	Yes
ingest_session_id	TEXT	No	Yes
ingest_fs_path_id	TEXT	No	No
ingest_session_imap_acct_folder_message	TEXT	No	No
ingest_issue_acct_project_id	TEXT	No	No
uri	TEXT	No	Yes
content_digest	TEXT	No	Yes
content	BLOB	No	No
nature	TEXT	No	No
size_bytes	INTEGER	No	No
last_modified_at	TIMESTAMPTZ	No	No
content_fm_body_attrs	TEXT	No	No
frontmatter	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
ingest_issue_acct_project_id	ingest_issue_acct_project_id references ur_ingest_session_plm_acct_project.ur_ingest_session_plm_acct_project_id
ingest_session_imap_acct_folder_message	ingest_session_imap_acct_folder_message references ur_ingest_session_imap_acct_folder_message.ur_ingest_session_imap_acct_folder_message_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
device_id	device_id references device.device_id

Indexes

Column Name	Index Name
device_id	uniform_resource_device_id_content_digest_uri_size_bytes_unique
content_digest	uniform_resource_device_id_content_digest_uri_size_bytes_unique
uri	uniform_resource_device_id_content_digest_uri_size_bytes_unique
size_bytes	uniform_resource_device_id_content_digest_uri_size_bytes_unique
device_id	idx_uniform_resource__device_id__uri
uri	idx_uniform_resource__device_id__uri
uniform_resource_id	sqlite_autoindex_uniform_resource_1

SQL DDL

CREATE TABLE `uniform_resource` (
	`uniform_resource_id` text PRIMARY KEY NOT NULL,
	`device_id` text NOT NULL,
	`ingest_session_id` text NOT NULL,
	`ingest_fs_path_id` text,
	`ingest_session_imap_acct_folder_message` text,
	`ingest_issue_acct_project_id` text,
	`uri` text NOT NULL,
	`content_digest` text NOT NULL,
	`content` blob,
	`nature` text,
	`size_bytes` integer,
	`last_modified_at` TIMESTAMPTZ,
	`content_fm_body_attrs` text,
	`frontmatter` 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 (`device_id`) REFERENCES `device`(`device_id`) ON UPDATE no action ON DELETE no action,
	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 (`ingest_session_imap_acct_folder_message`) REFERENCES `ur_ingest_session_imap_acct_folder_message`(`ur_ingest_session_imap_acct_folder_message_id`) ON UPDATE no action ON DELETE no action,
	FOREIGN KEY (`ingest_issue_acct_project_id`) REFERENCES `ur_ingest_session_plm_acct_project`(`ur_ingest_session_plm_acct_project_id`) ON UPDATE no action ON DELETE no action,
	CONSTRAINT "content_fm_body_attrs_check_valid_json" CHECK(json_valid("uniform_resource"."content_fm_body_attrs") OR "uniform_resource"."content_fm_body_attrs" IS NULL),
	CONSTRAINT "frontmatter_check_valid_json" CHECK(json_valid("uniform_resource"."frontmatter") OR "uniform_resource"."frontmatter" IS NULL),
	CONSTRAINT "elaboration_check_valid_json" CHECK(json_valid("uniform_resource"."elaboration") OR "uniform_resource"."elaboration" IS NULL)
)