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