user_batch_prefixes


Description

Authorized login prefixes for user batch creation. A prefix cannot be deleted without deleting batches using it.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
group_prefix VARCHAR 13 null
user_batches_v2.group_prefix fk_user_batches_v2_group_prefix_user_batch_prefixes_group_pref R

Prefix used in front of all batches
group_id BIGINT 19 √ null
groups.id fk_user_batch_prefixes_group_id_groups_id N

Group (and its descendants) in which managers can create users in batch. NULL if the group was deleted, in which case batches should be cleaned manually.
max_users MEDIUMINT UNSIGNED 8 1000

Maximum number of users that can be created under this prefix
allow_new BIT 1 1

Whether this prefix can be used for new user batches

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc group_prefix
fk_user_batch_prefixes_group_id_groups_id Performance Asc group_id

Relationships

Close relationships within degrees of separation