179
Views
2
Comments
Entity attribute of type List?

Is it possible to store a variable of List type on an attribute of a database entity?

UserImage.jpg
Jeffrey Kesselman

Short answer: No.

You have to do filemaker style tricks of packing ids into a string, or create another 1:n table

2025-08-08 18-54-29
Nuno Maurício
Staff

Hi Jeffrey,

As you said, the answer is No.

When you model databases, the way to use "Lists" is have 1:N Entity association, as you said.

The correct way to model databases does not suggest you to have lists in a single field. It is not an "atomic" value, violating the 1NF.

Cheers

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.