user_batches_v2


Description

Batches of users that were created (replaces user_batches which has been broken by a MySQL update)

Columns

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

Authorized (first) part of the full login prefix
custom_prefix VARCHAR 14 null

Second part of the full login prefix, given by the user that created the batch
size MEDIUMINT UNSIGNED 8 null

Number of users created in this batch
creator_id BIGINT 19 √ null
users.group_id fk_user_batches_v2_creator_id_users_group_id N
created_at DATETIME 19 CURRENT_TIMESTAMP

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc group_prefix + custom_prefix
fk_user_batches_v2_creator_id_users_group_id Performance Asc creator_id

Relationships

Close relationships within degrees of separation