Fedora uses several database tables and indexes to provide fast retrieval of some information. This page will document the various tables Fedora creates. Because of differences in databases some datatypes might not match the implemented type in your database exactly (ie. datetime versus timestamp).
For more information on configuring which database to use, see the Properties page.
When a Fedora repository is started with an empty database it begins a reindex process to recreate these indexes from the content on disk. You can force this rebuild to occur by setting the fcrepo.rebuild.on.start JVM property to true. For more information again visit the Properties page (linked above).
...
Containment Index
The containment index is a series of tables/indexes used to track the ldp:contains relationships of containers in Fedora.
...
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 |