USER

524 rows


Description

User Information

Columns

Column Type Size Nulls Auto Default Children Parents Comments
USER_ID INT UNSIGNED 10 √ null
LAB.USER_ID LAB_ibfk_1R
LAB_PROGRAM_USER.USER_ID LAB_PROGRAM_USER_ibfk_2C
OBSC.USER_ID OBSC_ibfk_1C
OBSM.USER_ID OBSM_ibfk_1C
OBSR.USER_ID OBSR_ibfk_2C
PERM.USER_ID PERM_ibfk_1C
SITC.USER_ID SITC_ibfk_1C
SITM.USER_ID SITM_ibfk_1R
SITR.USER_ID SITR_ibfk_2C
TESC.USER_ID TESC_ibfk_1C
TESM.USER_ID TESM_ibfk_1R
TESR.USER_ID TESR_ibfk_2C

Unique ID (primary key) for entries in the USER table
user_name VARCHAR 30 √ null

User name
first_name VARCHAR 30 √ null

First name
last_name VARCHAR 30 √ null

Last name
email VARCHAR 300 √ null

E-mail address
reg_date DATETIME 19 √ null

Registration date
organ VARCHAR 30 √ null

Organization
country VARCHAR 30 √ null

Country
region VARCHAR 30 √ null

Region
zip VARCHAR 10 √ null

Postal code
user_pass VARCHAR 100 √ null

Password (encrypted)
num_visit INT 10 √ null

Number of visits
num_download INT 10 √ null

Number of downloads
num_upload INT 10 √ null

Number of uploads
token VARCHAR 64 √ null
is_active TINYINT 3 1
is_verified TINYINT 3 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc USER_ID

Relationships

Close relationships within degrees of separation