verify_email


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
pid_holder BIGINT 19 √ NULL
email VARCHAR 255 √ NULL
language VARCHAR 100 √ NULL
fname VARCHAR 255 √ NULL
mname VARCHAR 255 √ NULL
lname VARCHAR 255 √ NULL
dob DATE 10 √ NULL
token_onetime VARCHAR 255 √ NULL
active TINYINT 3 1

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
email Must be unique Asc email

Relationships

Close relationships within degrees of separation