Associative table X Object type field

mauromequelussi

I have the following question.

I have a Contacts table and I want to be able to add various types of data (email and phone numbers) to the contact. The phone field ("value") will have many lookups.

"contactId": 1
"type" : "phone"
"value" : "+55891278917"

"contactId": 1
"type" : "phone"
"value" : "+55082738233"

"contactId": 1
"type" : "email"
"value" : test@gmail.com"

"contactId": 1
"type" : "phone"
"value" : "+551271892121"

What better way, create an associative table to register a contact's contact list or use an object type (type, telephone).

Field of type object cannot create index. For performance reasons what is the best option?

Michael Udinski

Hey @Mauro Mequelussi-40201 the GIN index can be leveraged to run indexed queries on objects and arrays… (Here's more info in our documentation)