ple_day_streak_user

274069 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
user_id CHAR 36 null
users.id day_streak_user_user_id_foreign R
start_date DATETIME 19 null
end_date DATETIME 19 null
streak_length INT 10 null
created_by CHAR 36 null
users.id day_streak_user_created_by_foreign R
tenant_id CHAR 36 null
tenants.id day_streak_user_tenant_id_foreign R
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null
deleted_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
day_streak_user_created_by_foreign Performance Asc created_by
day_streak_user_tenant_id_foreign Performance Asc tenant_id
day_streak_user_user_id_foreign Performance Asc user_id

Relationships

Close relationships within degrees of separation