Modeling considerations for lookup values
Lookup values are a set of predetermined valid values or a rule-based list of valid values for a particular attribute.
Lookup values can be shown as values list in the UI. For example,
lookup values might provide a the list of valid countries, suppliers,
or brands. Use the following scenarios to determine the correct approach
to modelling lookup values:
| Scenario | Data modeling main points |
|---|---|
Scenario 1:
< 20 values No search by primary key Single attribute value selection |
Use a string enumeration or a string enumeration rule. |
Scenario 2: > 20 values Search by primary key Before you make a selection, refer to other attribute values. |
|