Representation

Description

:Representation encapsulates the details of a client's representation agreement in a specific area of expertise and potentially within certain geographic regions. It acts as a nexus connecting clients, representation areas, geographic coverage, and assigned employees on the client team.

Temporal properties on relationships allow tracking of changes over time without cluttering the node with time-bound data.

Label

:Representation

Properties

Property	Description	Type
id	A unique identifier for this Representation node	string (uuid)
createdBy	the person or process that created the node	string
createdDate		dateTime
modifiedBy	the person or process who last modified the node	string
modifiedDate		dateTime

Key

id

Relationships

The HAS_REPRESENTATION relationship connects clients to :Representation nodes.

The REPPED_AS relationship connects :Representation nodes to :RepArea nodes. This is how the area of representation is defined.

The HAS_GEO_AREA relationship connects :Representation nodes to :GeoArea nodes. This is how the geographic scope of the representation is defined.

The ASSIGNED_TO relationship connects :Representation nodes to :Assignment nodes.

Examples

Retrieve all active areas of representation for a specific client

MATCH (client:Client {id: $clientId})-[hr:HAS_REPRESENTATION {active: true}]->(rep:Representation)-[:REPPED_AS]->(repArea:RepArea)
RETURN repArea.name AS areaOfRepresentation
ORDER BY repArea.name;

Add the geo areas

MATCH (client:Client {id: $clientId})-[hr:HAS_REPRESENTATION {active: true}]->(rep:Representation)-[:REPPED_AS]->(repArea:RepArea)
OPTIONAL MATCH (rep)-[:HAS_GEO_AREA]->(geoArea:GeoArea)
RETURN repArea.name AS areaOfRepresentation,
       geoArea.description AS geoAreaDescription
ORDER BY repArea.name;