#
# Table name: notes
#
-# id :bigint(8) not null, primary key
+# id :bigint not null, primary key
# latitude :integer not null
# longitude :integer not null
-# tile :bigint(8) not null
+# tile :bigint not null
# updated_at :datetime not null
# created_at :datetime not null
# status :enum not null
# closed_at :datetime
# description :text default(""), not null
-# user_id :bigint(8)
+# user_id :bigint
# user_ip :inet
#
# Indexes
#
-# notes_created_at_idx (created_at)
-# notes_tile_status_idx (tile,status)
-# notes_updated_at_idx (updated_at)
+# index_notes_on_description (to_tsvector('english'::regconfig, description)) USING gin
+# notes_created_at_idx (created_at)
+# notes_tile_status_idx (tile,status)
+# notes_updated_at_idx (updated_at)
#
# Foreign Keys
#
# Return the note's description, derived from the first comment
def description
if user_ip.nil? && user_id.nil?
- comments.first.body
+ all_comments.first.body if all_comments.first&.event == "opened"
else
RichText.new("text", super)
end
# Return the note's author object, derived from the first comment
def author
if user_ip.nil? && user_id.nil?
- comments.first.author
+ all_comments.first.author if all_comments.first&.event == "opened"
else
super
end