user_bk_15nov24


Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id INT 10 0
alias VARCHAR 70 √ null
first_name VARCHAR 20 null
last_name VARCHAR 20 √ null
email VARCHAR 70 √ null
password_timestamp DATETIME 19 √ null
password_salt CHAR 32 √ null
password_hash CHAR 32 √ null
password_expired INT 10 1
locked INT 10 0
disabled INT 10 0
created DATETIME 19 √ null
expires DATETIME 19 √ null
last_login DATETIME 19 √ null
last_ip_id INT 10 √ null
phone VARCHAR 20 √ null
title VARCHAR 100 √ null
address VARCHAR 50 √ null
address2 VARCHAR 50 √ null
city VARCHAR 30 √ null
state CHAR 2 √ null
zip VARCHAR 10 √ null
fax VARCHAR 20 √ null
last_reactivated_on DATETIME 19 √ null
last_validated_on DATETIME 19 √ null
INT 10 √ null
archived BIT 1 b'0'
cell_phone VARCHAR 20 √ null
contact_id INT 10 √ null
token VARCHAR 512 √ null
token_create_date DATETIME 23 √ null
token_created_by_user_id INT 10 √ null
token_expiration_date DATETIME 23 √ null
token_last_used_date DATETIME 23 √ null
subcontractor BIT 1 √ null
inactive BIT 1 √ null
api_user BIT 1 √ null

Indexes

Constraint Name Type Sort Column(s)
idx_user_idtmp Performance Asc user_id

Relationships

Close relationships within degrees of separation