badge_user

41917639 rows


Description

Keeps User Badges

Columns

Column Type Size Nulls Auto Default Children Parents Comments
old_data_id INT 10 √ null
user_id VARCHAR 36 √ null
centre_id VARCHAR 36 √ null
badge_id VARCHAR 36 √ null
badge_category_id VARCHAR 36 √ null
tenant_id VARCHAR 36 null
created_at DATETIME 19 null
updated_at DATETIME 19 √ null
deleted_at DATETIME 19 √ null
point_user_id VARCHAR 36 √ null
event_year TINYINT 3 √ 0

Indexes

Constraint Name Type Sort Column(s)
badge_category_id Performance Asc badge_category_id
badge_id Performance Asc badge_id
fk_badge_user_1_idx Performance Asc user_id
fk_badge_user_2_idx Performance Asc centre_id
idx_badge_user_user_badge_year Performance Asc/Asc/Asc user_id + badge_id + event_year
tenant_id Performance Asc tenant_id

Relationships