HAS_CLIENT_COMPANY Party-to-Party

Description

The HAS_CLIENT_COMPANY relationship connects client parties to the organization parties that they probably own.

We will call these organization parties client companies. Client companies are often the entities that are paid directly by the agency, rather than the client directly. These client companies are one of two types:

• Loanouts
• Production companies

Label

:HAS_CLIENT_COMPANY

Valid nodes

From	Relationship	To	Cardinality
Client Parties with a :HAS_ROLE relationship to a :Role {name: "Client"}	:HAS_CLIENT_COMPANY	Client Company A node with the :Party label and property {type: "organization"}	0..n

Properties

The HAS_CLIENT_COMPANY relationship requires the standard relationship properties but makes use of the subType property to distinguish between the two types of client companies as follows:

subType	Description
Loanout	The client company is a loanout
Production Company	The client company is a production company

CREATE

UPDATE

DELETE

Examples

Retrieve all client companies owned by a specific client

// Assuming the client's partyId is provided as a parameter
MATCH  (client:Party {id: $clientId})-[:HAS_CLIENT_COMPANY {active: true}]->(company:Party)
RETURN company.name, company.id

Show all loanout companies owned by a specific client

// Assuming the client's partyId is provided as a parameter
MATCH  (client:Party {id: $clientId})-[:HAS_CLIENT_COMPANY {subType: "Loanout", active: true}]->(company:Party)
RETURN company.name, company.id

What type of client company is a specific organization

// Assuming the organization's partyId is provided as a parameter
MATCH  (client)-[r:HAS_CLIENT_COMPANY {active: true}]->(company:Party {id: $companyId})
RETURN r.subType