Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

FieldTypeConstraintsDescription

subject_id

varchar(503)NOT NULLThe internal ID of the resource initiating the relationship (ie. the subject)
propertyvarchar(503)NOT NULLThe predicate of the relationship
object_idvarchar(503)NOT NULLThe internal ID of the resource which is the target of the relationship (ie. the object)
source_idvarchar(503)NOT NULLThe internal ID of the direct or indirect container containing the resource that created the relationship.
proxy_idvarchar(503)NOT NULLThe internal ID of the resource that created the relationship. This is contained within the source_id
start_timedatetime
The datetime the relationship started.
end_timedatetime
The datetime the relationship ended.
last_updateddatetime
The datetime the relationship was last updated. (used for eTags)
tx_idvarchar(36)NOT NULLThe transaction id this record belongs to
operationvarchar(10)NOT NULLThe type of operation this is, one of 'add' or 'delete'
force_flagvarchar(10)
??? (seems to always be NULL)

...

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.

...