...
The main source of inbound/outbound referenced information. Accessible to all requests.
| Field | Type | Constraints | Description |
|---|---|---|---|
| fedora_id | varchar(503) | NOT NULL | The internal ID of the resource creating the relationship |
| subject_id | varchar(503) | NOT NULL | The internal ID of the resource which is the subject of the relationship. |
| property | varchar(503) | NOT NULL | The predicate of the relationship. |
| object_id | varchar(503) | NOT NULL | The internal ID of the resource which is the object of the relationship. |
reference_transaction_operations
The reference operations being performed in a transaction. Only accessible to the same transaction.
| Field | Type | Constraints | Description |
|---|---|---|---|
| fedora_id | varchar(503) | NOT NULL | The internal ID of the resource creating the relationship |
| subject_id | varchar(503) | NOT NULL | The internal ID of the resource which is the subject of the relationship. |
| property | varchar(503) | NOT NULL | The predicate of the relationship. |
| object_id | varchar(503) | NOT NULL | The internal ID of the resource which is the object of the relationship. |
| transaction_id | varchar(255) | NOT NULL | The transaction ID this relationship operation is part of |
| operation | varchar(10) | NOT NULL | The operation being performed. One of 'add' or 'delete' |
...
OCFL Index
The OCFL index provides a mapping between a Fedora URI its base URI (which is different in the case of an Archival Group) and its OCFL ID.
...
The main source of OCFL mappings. Accessible to all requests.
| Field | Type | Constraints | Description |
|---|---|---|---|
| fedora_id | varchar(503) | NOT NULL, PRIMARY KEY | The internal ID of the resource creating the relationship |
| fedora_root_id | varchar(503) | NOT NULL | The internal ID of the archival group of the resource in fedora_id. These fields are the same for self contained resources. |
| ocfl_id | varchar(503) | NOT NULL | The OCFL id of the resource containing this Fedora resource. |
ocfl_id_map_session_operations
The OCFL ID mapping operations being persisted in a transaction.
| Field | Type | Constraints | Description |
|---|---|---|---|
| fedora_id | varchar(503) | NOT NULL, PRIMARY KEY | The internal ID of the resource creating the relationship |
| fedora_root_id | varchar(503) | NOT NULL | The internal ID of the archival group of the resource in fedora_id. These fields are the same for self contained resources. |
| ocfl_id | varchar(503) | NOT NULL | The OCFL id of the resource containing this Fedora resource. |
| session_id | varchar(255) | NOT NULL | The session ID this operation is from. |
| operation | varchar(10) | NOT NULL | The type of operation to be persisted. One of 'add' or 'delete' |
...
Simple Search Indexes
The simple search indexes provide support for the various search features now available in Fedora.
simple_search
This index contains basic information about all the resources in the repository.
| Field | Type | Constraints | Description |
|---|---|---|---|
id | bigint | PRIMARY KEY, AUTO INCREMENT | A unique numeric id for this resource. |
| fedora_id | varchar(503) | NOT NULL, UNIQUE KEY | The internal ID of the resource. |
| created | datetime | NOT NULL | The datetime the resource was created. |
| modified | datetime | NOT NULL | The datetime the resource was last modified. |
| content_size | bigint | The size of the content. | |
| mime_type | varchar(255) | The mime-type of the resource |
search_rdf_type
This index contains rdf types that exist in the repository.
| Field | Type | Constraints | Description |
|---|---|---|---|
id | bigint | PRIMARY KEY, AUTO INCREMENT | A unique numeric id for this rdf type. |
| rdf_type_uri | varchar(255) | NOT NULL, UNIQUE KEY | The URI of the RDF type |
search_resource_rdf_type
This index links resources from the simple_search table to rdf types in the search_rdf_types table.
| Field | Type | Constraints | Description |
|---|---|---|---|
resource_id | bigint | NOT NULL, FOREIGN KEY REFERENCES simple_search (id) | ID from the simple_search table |
| rdf_type_id | bigint | NOT NULL, FOREIGN KEY REFERENCES rdf_type_uri (id) | ID from the search_rdf_type table |