Add list or map to field

[clem]

Yes, but it's harder to search for the roles.... if they are in a list...

I posted this about a real situation from the movies (but not in the sample Movie DB...): Alec Guinness and his 9 roles in "Kind Hearts and Coronets". I'm not sure what the schema choice should be:

How to search in properties of a relationship which has an array of values?

Here's a twisted question.... What if the movie is Kind Hearts and Coronets where Alec Guinness plays nine different roles at once? Here, a person creating the ACTED_IN relationship might decide (badly?) that the roles property should be in a list instead of creating multiple relationships with a single string for each role. (They might decide have nine relationships of the same type with different properties clutters things up.) CREATE (p:Person {name:'Alec Guinness', born : 1914}) CREATE…