Table ad204225.users_password_link Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id char 36
bean_id char 36  √  null
bean_type varchar 36  √  User
username varchar 36  √  null
date_generated datetime 19  √  null
deleted bit 1  √  0
platform varchar 36  √  base

Analyzed at Fri Mar 26 07:32 UTC 2021

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
bean_id Performance Asc idx_bean_id_users_password_link
id + deleted + platform Performance Asc/Asc/Asc idx_id_deleted_platform
username Performance Asc idx_username