RiC / Fuseki

Records in Context (RiC-O) triplestore integration with Apache Jena Fuseki.

ahgRicExplorerPlugin

0

ric_orphan_tracking

0

ric_sync_config

79

ric_sync_log

0

ric_sync_queue

0

ric_sync_status

Entity Relationship Diagram

RiC / Fuseki ERD

`ric_orphan_tracking`

12 columns 0 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	int	NOT NULL	-	auto_increment
UQ	`ric_uri`	varchar(500)	NOT NULL	-
	`ric_type`	varchar(100)	NULL	-
	`expected_entity_type`	varchar(50)	NULL	-
	`expected_entity_id`	int	NULL	-
	`detected_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`detection_method`	varchar(45)	NOT NULL	-		integrity_check, sync_failure, manual
FK	`status`	varchar(53)	NOT NULL	`detected`		detected, reviewed, cleaned, retained, restored
	`resolved_at`	datetime	NULL	-
	`resolved_by`	int	NULL	-
	`resolution_notes`	text	NULL	-
	`triple_count`	int	NULL	-

`ric_sync_config`

5 columns 0 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	int	NOT NULL	-	auto_increment
UQ	`config_key`	varchar(100)	NOT NULL	-
	`config_value`	text	NULL	-
	`description`	text	NULL	-
	`updated_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

`ric_sync_log`

14 columns 79 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint	NOT NULL	-	auto_increment
	`operation`	varchar(66)	NOT NULL	-		create, update, delete, move, resync, cleanup, integrity_check
FK	`entity_type`	varchar(50)	NOT NULL	-
	`entity_id`	int	NULL	-
	`ric_uri`	varchar(500)	NULL	-
	`status`	varchar(41)	NOT NULL	-		success, failure, partial, skipped
	`triples_affected`	int	NULL	-
	`details`	json	NULL	-
	`error_message`	text	NULL	-
	`execution_time_ms`	int	NULL	-
	`triggered_by`	varchar(34)	NOT NULL	`system`		user, system, cron, api, cli
	`user_id`	int	NULL	-
	`batch_id`	varchar(36)	NULL	-
FK	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED

`ric_sync_queue`

16 columns 0 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint	NOT NULL	-	auto_increment
	`entity_type`	varchar(50)	NOT NULL	-
	`entity_id`	int	NOT NULL	-
	`operation`	varchar(35)	NOT NULL	-		create, update, delete, move
	`priority`	tinyint	NOT NULL	`5`
FK	`status`	varchar(54)	NOT NULL	`queued`		queued, processing, completed, failed, cancelled
	`attempts`	int	NOT NULL	`0`
	`max_attempts`	int	NOT NULL	`3`
	`old_parent_id`	int	NULL	-
	`new_parent_id`	int	NULL	-
	`scheduled_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`started_at`	datetime	NULL	-
	`completed_at`	datetime	NULL	-
	`last_error`	text	NULL	-
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`updated_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

`ric_sync_status`

16 columns 0 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	int	NOT NULL	-	auto_increment
FK	`entity_type`	varchar(50)	NOT NULL	-
	`entity_id`	int	NOT NULL	-
FK	`ric_uri`	varchar(500)	NOT NULL	-
	`ric_type`	varchar(100)	NULL	-
FK	`sync_status`	varchar(48)	NOT NULL	`pending`		synced, pending, failed, deleted, orphaned
	`last_synced_at`	datetime	NULL	-
	`last_sync_attempt`	datetime	NULL	-
	`sync_error`	text	NULL	-
	`retry_count`	int	NOT NULL	`0`
	`content_hash`	varchar(64)	NULL	-
	`atom_updated_at`	datetime	NULL	-
	`parent_id`	int	NULL	-
	`hierarchy_path`	text	NULL	-
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`updated_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Notes

Log in to add notes.

Legend

PK Primary Key FK Foreign Key / Index UQ Unique Constraint

Table structures are read live from the database. Row counts reflect current data.