submission_comments


Description

Comments on a submission, e.g. peer review comments

Columns

Column Type Size Nulls Auto Default Children Parents Comments
comment_id BIGINT 19 null
comment_type BIGINT 19 NULL
role_id BIGINT 19 null
submission_id BIGINT 19 null
submissions.submission_id submission_comments_submission_idC
assoc_id BIGINT 19 null
author_id BIGINT 19 null
users.user_id submission_comments_author_id_foreignC
comment_title TEXT 65535 null
comments TEXT 65535 NULL
date_posted DATETIME 19 NULL
date_modified DATETIME 19 NULL
viewable SMALLINT 5 NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc comment_id
submission_comments_author_id Performance Asc author_id
submission_comments_submission_id Performance Asc submission_id

Relationships