Table attachment
Item attachments

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
type varchar 31
id int8 19
item_navigation_tab.attachment_id fkadc0d996a772c91a R
data text 2147483647  √  null
description varchar 1024  √  null
md5sum varchar 32  √  null
preview bool 1
restricted bool 1
thumbnail varchar 512  √  null
url varchar 1024  √  null
uuid varchar 40
value1 varchar 1024  √  null
value2 varchar 1024  √  null
value3 varchar 1024  √  null
viewer varchar 255  √  null
item_id int8 19
item.id fk8af759236f7f1a9c R
attindex int4 10
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc attachment_pkey
item_id Performance Asc attachmentitem
uuid Performance Asc attachmentuuidindex

Close relationships  within of separation: