edition_editor_request

0 rows


Description

This table stores the data for a request for a user to become an editor of an edition. It contains details about the permissions associated with the request.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
token CHAR 36 null
user_email_token.token edition_editor_request_to_tokenR

Unique token the user will provide to verify the requested action.
admin_user_id INT UNSIGNED 10 null
user.user_id edition_editor_request_to_admin_user_idR

User id of the admin who requested the editor.
editor_user_id INT UNSIGNED 10 null
user.user_id edition_editor_request_to_editor_user_idR

User id of the editor who was invited to join the edition.
edition_id INT UNSIGNED 10 null
edition.edition_id edition_editor_request_to_edition_idR

The id of the edition to be shared.
is_admin TINYINT UNSIGNED 3 0

Offering admin rights.
may_lock TINYINT UNSIGNED 3 0

Offering locking rights.
may_write TINYINT UNSIGNED 3 0

Offering write rights.
date DATETIME 19 current_timestamp()

Date the editor request was sent.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc editor_user_id + edition_id
edition_editor_request_to_admin_user_id Performance Asc admin_user_id
edition_editor_request_to_edition_id Performance Asc edition_id
edition_editor_request_to_token Performance Asc token

Relationships

Close relationships within degrees of separation