HAS_EXTERNAL_RECORD Party Data
Description
Connects a :Party, :EventSeries, :EventInstance, :Venue, :Address, :Location, :OnlineAddress, :Phone to an :ExternalRecord.
Label
:HAS_EXTERNAL_RECORD
Valid nodes
| From | Relationship | To | Cardinality |
|---|---|---|---|
| Party A node with the :Party label | :HAS_EXTERNAL_RECORD | External Record A node with the :ExternalRecord label | 0..n |
| EventSeries A node with the :EventSeries label | :HAS_EXTERNAL_RECORD | External Record A node with the :ExternalRecord label | 0..n |
| EventInstance A node with the :EventInstance label | :HAS_EXTERNAL_RECORD | External Record A node with the :ExternalRecord label | 0..n |
| Venue A node with the :Venue label | :HAS_EXTERNAL_RECORD | External Record A node with the :ExternalRecord label | 0..n |
| Address A node with the :Address label | :HAS_EXTERNAL_RECORD | External Record A node with the :ExternalRecord label | 0..n |
| OnlineAddress A node with the :OnlineAddress label | :HAS_EXTERNAL_RECORD | External Record A node with the :ExternalRecord label | 0..n |
| Phone A node with the :Phone label | :HAS_EXTERNAL_RECORD | External Record A node with the :ExternalRecord label | 0..n |
| Location A node with the :Location label | :HAS_EXTERNAL_RECORD | External Record A node with the :ExternalRecord label | 0..n |
Properties
HAS_EXTERNAL_RECORD uses the standard relationship properties.
CREATE
A :Party, :EventSeries, :Venue, :Address, :OnlineAddress or :Phone can have between 0 and unlimited external records of each type, and more than one external record of the same type can be active.
Creation of external Records is limited to DMO personnel.
UPDATE
Updates to an :ExternalRecord node or its relationship are not allowed. To update a record, deactivate the existing relationship using DELETE and create a new :ExternalRecord node and relationship.
DELETE
Deleting an :ExternalRecord node relationship is a deactivation. No physical deletes will happen.
Examples
MATCH (p:Party { id: $id })
- [r:HAS_EXTERNAL_RECORD {active: true}]
-> (e:ExternalRecord)
RETURN p.id as partyId,
e.type as idType,
e.id as id