...
The table of committed containment relationships. Accessible to all requests.
Field | Type | Constraints | Description |
---|---|---|---|
fedora_id | varchar(503) | NOT NULL, PRIMARY KEY | The internal ID of the resource |
parent | varchar(503) | NOT NULL | The internal ID of the containing resource |
start_time | datetime | NOT NULL | The datetime when the resource was created |
end_time | datetime | The datetime when the resource was deleted (but still has a tombstone) | |
updated | datetime | The datetime when any contained resources were updated (used for eTags) |
containment_transactions
The table of containment relationship operations that not been committed to the containment table yet. These are only accessible to the indicated transaction.
Field | Type | Constraints | Description |
---|---|---|---|
fedora_id | varchar(503) | NOT NULL | The internal ID of the resource |
parent | varchar(503) | NOT NULL | The internal ID of the containing resource |
start_time | datetime | The datetime when the resource was created | |
end_time | datetime | The datetime when the resource was deleted (but still has a tombstone) | |
transaction_id | varchar(255) | NOT NULL | The transaction id this record belongs to |
operation | varchar(10) | NOT NULL | The type of operation this is, one of 'add', 'delete' or 'purge' |
...
Membership Index
The membership index contains relationships generated by ldp:DirectContainer and ldp:IndirectContainer resources.
...
The main table of membership relationships. Accessible to all requests.
Field | Type | Constraints | Description |
---|---|---|---|
subject_id | varchar(503) | NOT NULL | The internal ID of the resource initiating the relationship (ie. the subject) |
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 target of the relationship (ie. the object) |
source_id | varchar(503) | NOT NULL | The internal ID of the direct or indirect container containing the resource that created the relationship. |
proxy_id | varchar(503) | NOT NULL | The internal ID of the resource that created the relationship. This is contained within the source_id |
start_time | datetime | The datetime the relationship started. | |
end_time | datetime | The datetime the relationship ended. |
membership_tx_operations
The table of membership relationships operations not yet committed to the membership table. These are only accessible to the specified transaction.
Field | Type | Constraints | Description |
---|---|---|---|
subject_id | varchar(503) | NOT NULL | The internal ID of the resource initiating the relationship (ie. the subject) |
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 target of the relationship (ie. the object) |
source_id | varchar(503) | NOT NULL | The internal ID of the direct or indirect container containing the resource that created the relationship. |
proxy_id | varchar(503) | NOT NULL | The internal ID of the resource that created the relationship. This is contained within the source_id |
start_time | datetime | The datetime the relationship started. | |
end_time | datetime | The datetime the relationship ended. | |
last_updated | datetime | The datetime the relationship was last updated. (used for eTags) | |
tx_id | varchar(36) | NOT NULL | The transaction id this record belongs to |
operation | varchar(10) | NOT NULL | The type of operation this is, one of 'add' or 'delete' |
force_flag | varchar(10) | ?? |
...
Inbound Reference Index
The inbound reference tables hold relationships between two resources in the repository, due to there being no single subject restriction it is possible for a 3rd resource to generate an inbound reference from a 1st resource to a 2nd resource. This relationship will persist even if the 2nd resource was deleted.
...
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' |