datasetaccesslogs


Description

If enabled, tracks which user accessed which datasets.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null

Primary id for this table. This uniquely identifies the row.

user_id INT 10 null
user_name VARCHAR 255 null
user_email VARCHAR 255 null
user_institution VARCHAR 255 null
dataset_id INT 10 null
datasets.id datasetaccesslogs_ibfk_1C
reason MEDIUMTEXT 16777215 null
created_on DATETIME 26 CURRENT_TIMESTAMP

When the record was created.

updated_on TIMESTAMP 26 CURRENT_TIMESTAMP

When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
dataset_id Performance Asc dataset_id

Relationships