unique_id_users

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id MEDIUMINT UNSIGNED 8 null
login.id FK_unique_id_users_user_id_to_login R
uniqueid_hash CHAR 32 null
uniqueid.hash FK_user_hash_to_uid R
create_time TIMESTAMP 19 current_timestamp()
update_time TIMESTAMP 19 current_timestamp()

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc user_id + uniqueid_hash
FK_user_hash_to_uid Performance Asc uniqueid_hash

Relationships

Close relationships within degrees of separation