submission_comments

5 rows


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 Implied Constraint R
assoc_id BIGINT 19 null
author_id BIGINT 19 null
authors.author_id Implied Constraint R
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_submission_id Performance Asc submission_id

Relationships

Close relationships within degrees of separation