...
| 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 |
...
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 |