Table comments
Comments and ratings on items

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int8 19
anonymous bool 1
comment text 2147483647  √  null
date_created timestamp 29,6  √  null
owner varchar 255  √  null
rating int4 10
uuid varchar 40
item_id int8 19
item.id fkdc17ddf46f7f1a9c R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc comments_pkey
item_id Performance Asc commentitem
item_id + uuid Must be unique Asc/Asc comments_item_id_uuid_key
uuid Performance Asc commentuuidindex

Close relationships  within of separation: