Table discourse.public.uploads Generated by
SchemaSpy
Legend: SourceForge.net
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 serial 10  √  nextval('uploads_id_seq'::regclass)
user_id int4 10
original_filename varchar 255
filesize int4 10
width int4 10  √  null
height int4 10  √  null
url varchar 255
created_at timestamp 29,6
updated_at timestamp 29,6
sha1 varchar 40  √  null
origin varchar 1000  √  null
retain_hours int4 10  √  null

Table contained 8 rows at Fri Mar 27 12:26 PDT 2015

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc uploads_pkey  
id + url Performance Asc/Asc index_uploads_on_id_and_url  
sha1 Must be unique Asc index_uploads_on_sha1 This unique column is also nullable
url Performance Asc index_uploads_on_url  
user_id Performance Asc index_uploads_on_user_id