comment

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
comment_id INT UNSIGNED 10 √ null
comment.parent_comment_id comment_comment_comment_id_fk C
text VARCHAR 2000 null
created_date DATETIME 19 CURRENT_TIMESTAMP
parent_comment_id INT UNSIGNED 10 √ null
comment.comment_id comment_comment_comment_id_fk C
user_id INT UNSIGNED 10 null
user.user_id comment_user_user_id_fk R
review_id INT UNSIGNED 10 null
review.review_id comment_review_review_id_fk R

ID of review under which comment is found

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc comment_id
comment_comment_comment_id_fk Performance Asc parent_comment_id
comment_review_review_id_fk Performance Asc review_id
comment_user_user_id_fk Performance Asc user_id

Relationships

Close relationships within degrees of separation