submission_comments

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
comment_id bigserial 19 nextval('submission_comments_comment_id_seq'::regclass)
comment_type int8 19 null
role_id int8 19 null
submission_id int8 19 null
submissions.submission_id submission_comments_submission_idC
assoc_id int8 19 null
author_id int8 19 null
users.user_id submission_comments_author_id_foreignC
comment_title text 2147483647 null
comments text 2147483647 null
date_posted timestamp 22 null
date_modified timestamp 22 null
viewable int2 5 null

Indexes

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

Relationships