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