Handling Multi-Valued Attributes
Some attributes, like groups, support the ability to have multiple values, and are stored as a list. In order to model this, you will put each value on a separate row for that field. All additional values should be repeated.
Example:
|
id |
name |
... |
groups |
... |
This header row will be skipped |
|---|---|---|---|---|---|
|
1 |
jdoe |
... |
Admins |
... |
This is the first account |
|
2 |
jdoe |
... |
Employee |
... |
This is a continuation of the first account. Notice how values repeat, except for the multi-valued column |
|
3 |
msmith |
... |
Employee |
... |
This is the second account |
Note
The name is a single-valued attribute.
This will yield jdoe with Admins and Employee groups, and msmith with a single Employee group.