Table Relationships Summary

Cross-plugin relationship map showing how all plugin tables link to AtoM core entities: information_object, repository, actor, digital_object, term/taxonomy, and user.

crossPlugin

All Schemas

705

information_object

repository

393

actor

1,277

digital_object

737

term

taxonomy

user

Entity Relationship Diagram

Open Full Size

Foreign Key Relationships

Constraint	Table	Column	References	Referenced Column
`actor_FK_4`	`actor`	description_detail_id	`term`	id
`actor_FK_3`	`actor`	description_status_id	`term`	id
`actor_FK_2`	`actor`	entity_type_id	`term`	id
`actor_FK_1`	`actor`	id	`object`	id
`actor_FK_5`	`actor`	parent_id	`actor`	id
`digital_object_FK_1`	`digital_object`	id	`object`	id
`digital_object_FK_4`	`digital_object`	media_type_id	`term`	id
`digital_object_FK_2`	`digital_object`	object_id	`object`	id
`digital_object_FK_5`	`digital_object`	parent_id	`digital_object`	id
`digital_object_FK_3`	`digital_object`	usage_id	`term`	id
`information_object_FK_3`	`information_object`	collection_type_id	`term`	id
`information_object_FK_7`	`information_object`	description_detail_id	`term`	id
`information_object_FK_6`	`information_object`	description_status_id	`term`	id
`information_object_FK_8`	`information_object`	display_standard_id	`term`	id
`information_object_FK_1`	`information_object`	id	`object`	id
`information_object_FK_2`	`information_object`	level_of_description_id	`term`	id
`information_object_FK_5`	`information_object`	parent_id	`information_object`	id
`information_object_FK_4`	`information_object`	repository_id	`repository`	id
`repository_FK_3`	`repository`	desc_detail_id	`term`	id
`repository_FK_2`	`repository`	desc_status_id	`term`	id
`repository_FK_1`	`repository`	id	`actor`	id
`taxonomy_FK_1`	`taxonomy`	id	`object`	id
`taxonomy_FK_2`	`taxonomy`	parent_id	`taxonomy`	id
`term_FK_1`	`term`	id	`object`	id
`term_FK_3`	`term`	parent_id	`term`	id
`term_FK_2`	`term`	taxonomy_id	`taxonomy`	id
`user_FK_1`	`user`	id	`actor`	id

`information_object`

15 columns 705 rows

	Column	Type	Nullable	Default	Extra
PK	`id`	int	NOT NULL	-
	`identifier`	varchar(1024)	NULL	-
UQ	`oai_local_identifier`	int	NOT NULL	-	auto_increment
FK	`level_of_description_id`	int	NULL	-
FK	`collection_type_id`	int	NULL	-
FK	`repository_id`	int	NULL	-
FK	`parent_id`	int	NULL	-
FK	`description_status_id`	int	NULL	-
FK	`description_detail_id`	int	NULL	-
	`description_identifier`	varchar(1024)	NULL	-
	`source_standard`	varchar(1024)	NULL	-
FK	`display_standard_id`	int	NULL	-
FK	`lft`	int	NULL	-
FK	`rgt`	int	NULL	-
	`source_culture`	varchar(16)	NOT NULL	-

`repository`

7 columns 14 rows

	Column	Type	Nullable	Default
PK	`id`	int	NOT NULL	-
	`identifier`	varchar(1024)	NULL	-
FK	`desc_status_id`	int	NULL	-
FK	`desc_detail_id`	int	NULL	-
	`desc_identifier`	varchar(1024)	NULL	-
	`upload_limit`	float	NULL	-
	`source_culture`	varchar(16)	NOT NULL	-

`actor`

9 columns 393 rows

	Column	Type	Nullable	Default
PK	`id`	int	NOT NULL	-
	`corporate_body_identifiers`	varchar(1024)	NULL	-
FK	`entity_type_id`	int	NULL	-
FK	`description_status_id`	int	NULL	-
FK	`description_detail_id`	int	NULL	-
	`description_identifier`	varchar(1024)	NULL	-
	`source_standard`	varchar(1024)	NULL	-
FK	`parent_id`	int	NULL	-
	`source_culture`	varchar(16)	NOT NULL	-

`digital_object`

13 columns 1,277 rows

	Column	Type	Nullable	Default
PK	`id`	int	NOT NULL	-
FK	`object_id`	int	NULL	-
FK	`usage_id`	int	NULL	-
	`language`	varchar(50)	NULL	-
	`mime_type`	varchar(255)	NULL	-
FK	`media_type_id`	int	NULL	-
	`name`	varchar(1024)	NOT NULL	-
FK	`path`	varchar(1024)	NOT NULL	-
	`sequence`	int	NULL	-
	`byte_size`	bigint	NULL	-
	`checksum`	varchar(255)	NULL	-
	`checksum_type`	varchar(50)	NULL	-
FK	`parent_id`	int	NULL	-

`term`

7 columns 737 rows

	Column	Type	Nullable	Default
PK	`id`	int	NOT NULL	-
FK	`taxonomy_id`	int	NOT NULL	-
	`code`	varchar(1024)	NULL	-
FK	`parent_id`	int	NULL	-
FK	`lft`	int	NULL	-
	`rgt`	int	NULL	-
	`source_culture`	varchar(16)	NOT NULL	-

`taxonomy`

4 columns 61 rows

	Column	Type	Nullable	Default
PK	`id`	int	NOT NULL	-
	`usage`	varchar(1024)	NULL	-
FK	`parent_id`	int	NULL	-
	`source_culture`	varchar(16)	NOT NULL	-

`user`

6 columns 30 rows

	Column	Type	Nullable	Default
PK	`id`	int	NOT NULL	-
	`username`	varchar(255)	NULL	-
	`email`	varchar(255)	NULL	-
	`password_hash`	varchar(255)	NULL	-
	`salt`	varchar(255)	NULL	-
	`active`	tinyint	NULL	`1`

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.