...
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 relationships created in a transaction that have 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 created but operations not yet committed to the 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.
reference
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' |