This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi,
What do we mean by cardinality 0..1 for record type location?

for relational databases (like what NS is) cardinality refers to the relationship between two tables/records. The notation "0..1" means the cardinality of "zero or one."
I think you're missing some of the definition. I'd expect something like 'transaction to location has a cardinality of 0..1' (meaning a transaction can have zero location associated with it, or one location)

similarly, a '1..n' or '1..*' cardinality means that the first record has one or more of the second record linked to it (but, importantly, never zero)

Thanks <@UHXHE0684>
Super clear to me now