Grouper SQL provisioner startWith scaffolding

Start with: Common SQL pattern

First six fields can show one at a time when the previous is filled in

1. SQL external system ID (required)
2. SQL pattern: drop down with options below (show after external system selected)
   1.  entitiesTable
      1. init start with entity table to true
      2. init start with 
   2. entitiesTableWithAttributesTable
      
      1. init start with group organization to flat
      2. init start with membershipDn to false
      3. init start with membershipValue to subjectId
   3. entitiesTableWithAttributesTableAndMemberships
      
      1. init start with membership structure to entityAttributes
      2. init start with group object class to: top,groupOfNames
      3. init start with group membership attribute to: member
      4. init start with membershipDn to true
   4. entitiesTableMembershipsTable
   5. groupsTable
      1. init start with hasGroupsTable to true
      2. init start with hasGroupsAttributesTable to false
      3. init start with hasEntitiesTable to false
      4. init start with hasEntitiesAttributesTable to false
      5. init start with hasMembershipsTable to false
   6. groupsTableWithAttributesTable
      1. init start with membership structure to groupAttributes
      2. init start with group organization to bushy
      3. init start with membershipDn to true
   7. groupsTableWithAttributesTableAndMemberships
      1. init user attribute type: core
      2. init start with membership structure to groupAttributes
      3. init start with group organization to bushy
      4. init start with membershipDn to false
      5. init start with membershipValue to subjectId
   8. groupsTableMembershipsTable
   9. groupsTableEntitiesTableMembershipsTable
   10.  membershipsTable
       1. init start with membership structure to groupAttributes
       2. init start with group object class to: top,posixGroup
       3. init start with group membership attribute to: member
       4. init start with membershipDn to true
       5. init start with idIndex attribute to gidNumber
   11. other
       1. proceed with screen
3. User attributes type: drop down with options, required (show after ldap pattern)
   1. Only uses built in core attributes e.g. subjectId, subjectIdentifier0-2, email, name, description or translations of those (value: core)
   2. Needs other subject source attributes (value: subjectSource)
   3. Needs a SQL or LDAP filter, but not other subject attributes.  If LDAP this is a different LDAP than the LDAP provisioning to (value: entityResolver)
   4. Needs subject source source attributes and SQL or LDAP filter.  If LDAP this is a different LDAP than the LDAP provisioning to (value: subjectSourceAndEntityResolver)
4. Membership structure (default to membershipObjects): entityAttributes, groupAttributes, membershipObjects, notApplicable
5. if (user attribute type is subjectSource or subjectSourceAndEntityResolver)
   1. list those attributes and validate against subject source (textfield, comma separated attributes, required)
6. Ask if has group table (default false)
   1. If has group table, ask for group table name (required, validate on submit)
   2. If has group table, ask for group primary key column (suggest group_id_index) (required, validate on submit)
   3. If has group table, ask for list of other group columns, suggest names: group_uuid, group_name, group_id_index, group_extension, group_display_name, group_display_extension, group_description
   4. Ask if need group link (optional, grouper will try to deduce this)
   5.  If has group table, ask if has group attribute table (to store multi-valued attributes or memberships, not common)
      1. If has group attribute table, ask for group attribute table name (required, validate on submit)
      2. If has group attribute table, ask for column name which is foreign key to group table (suggest group_uuid) (required, validate on submit)
      3. If has group attribute table, ask for column name which is the attribute name (suggest attribute_name)  (required, validate on submit)
      4. If has group attribute table, ask for column name which is the attribute value (suggest attribute_value)  (required, validate on submit)
      5. If groupAttributes membership structure, ask for the membership attribute name (required)
      6. If groupAttributes membership structure, ask for membership value (drop down required) (entityPrimaryKey, other, script, subjectId, subjectIdentifier0, subjectIdentifier1, subjectIdentifier2)
      7. If has group attribute table, ask for other attribute names in attribute table (optional)
7. Ask if has entity table (default false)
   1. If has entity table, ask for entity table name (required, validate on submit)
   2. If has entity table, ask for entity primary key column (suggest entity_id_index) (required, validate on submit)
   3. If has entity table, ask for list of other entity columns, suggest names: email, entity_uuid, entity_name, entity_description, subject_id, subject_identifier0, subject_identifier1, subject_identifier2
   4. Ask if need entity link (boolean optional grouper will try to deduce this)
   5.  If has entity table, ask if has entity attribute table (to store multi-valued attributes or memberships, not common)
      1. If has entity attribute table, ask for entity attribute table name (required, validate on submit)
      2. If has entity attribute table, ask for column name which is foreign key to entity table (suggest entity_uuid) (required, validate on submit)
      3. If has entity attribute table, ask for column name which is the attribute name (suggest attribute_name)  (required, validate on submit)
      4. If has entity attribute table, ask for column name which is the attribute value (suggest attribute_value)  (required, validate on submit)
      5. If entityAttributes membership structure, ask for the membership attribute name (required)
      6. If entityAttributes membership structure, ask for membership value (drop down required) (other, script, groupExtension, groupIdIndex, groupName, groupPrimaryKey, groupUuid)
      7. If has entity attribute table, ask for other attribute names in attribute table (optional)
8. Ask if has membership table (default false)
   1. Ask for group column (required, validate on submit)
   2. Ask for group value (drop down required) (other, script, groupExtension, groupIdIndex, groupName, groupPrimaryKey, groupUuid)
   3. Ask for entity column (required, validate on submit)
   4. Ask for entity value (drop down required) (entityPrimaryKey, other, script, subjectId, subjectIdentifier0, subjectIdentifier1, subjectIdentifier2)
9. Add disabled full sync daemon? boolean default to true
10. Add disabled incremental sync daemon? boolean default to true