...
grouper_members
Existing table
- id (012)
- subject_id (12345678)
grouper_data_field
Types of data fields for user or rows
...
Type of data field rows available for users
- id (123)
- system_name (affiliation)
- display_name (Affiliation)
- description
grouper_data_row_field
Which fields are in which rows
- id (538)
- grouper_data_row_id (012)
- grouper_data_field_id (567)
grouper_data_field_row_sec
Row level security for data
- id (941)
- grouper_data_field_id (234)
- group_id_of_result_member pcm428
- viewable_by_group_id rst567
grouper_member_data_field
Assignment of a data field to an entity
- id (480)
- member_id (012)
- grouper_data_field_id (234)
- value_id (789)
- created_on 1/2/3
- updated_on 2/3/
- 2021
grouper_member_data_row
Assignment of a row of data to an entity
- id (321)
- member_id (012)
- grouper_data_row_id (123)
- created_on 4/5/2021
grouper_member_data_row_field
Assignment of a field to a row assignment
- id (637)
- grouper_member_data_row_id (321)
- grouper_data_field_id (567)
- value_id (654)
- created_on 4/5/2021
- updated_on 2/3/2021
grouper_dictionary
Keep data field values here to reduce data redundancy
...