A quick question (maybe the answer won't be so simple) about the node key constraint:
According that I have a node with a property that must be unique and must exists (eg: social security number). Do I need to create a NODE KEY constraint for that one property
CREATE CONSTRAINT ON (p:Person) ASSERT (p.ssn) IS NODE KEY
or do I need to create to constraints (EXISTS + UNIQUE) ?
CREATE CONSTRAINT ON (p:Person) ASSERT EXISTS(p.ssn) CREATE CONSTRAINT ON (p:Person) ASSERT p.ssn IS UNIQUE
Is there a difference between the two solution in the core engine ?
Note that the question is about one property only and not a list of property.