#
# Table name: notes
#
-# id :bigint(8) not null, primary key
-# latitude :integer not null
-# longitude :integer not null
-# tile :bigint(8) not null
-# updated_at :datetime not null
-# created_at :datetime not null
-# status :enum not null
-# closed_at :datetime
+# id :bigint(8) not null, primary key
+# latitude :integer not null
+# longitude :integer not null
+# tile :bigint(8) 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_ip :inet
#
# Indexes
#
# notes_tile_status_idx (tile,status)
# notes_updated_at_idx (updated_at)
#
+# Foreign Keys
+#
+# notes_user_id_fkey (user_id => users.id)
+#
class Note < ApplicationRecord
include GeoRecord
closed_at + DEFAULT_FRESHLY_CLOSED_LIMIT
end
- # Return the author object, derived from the first comment
+ # Return the note's description, derived from the first comment
+ def description
+ comments.first.body
+ end
+
+ # Return the note's author object, derived from the first comment
def author
comments.first.author
end
- # Return the author IP address, derived from the first comment
+ # Return the note's author ID, derived from the first comment
+ def author_id
+ comments.first.author_id
+ end
+
+ # Return the note's author IP address, derived from the first comment
def author_ip
comments.first.author_ip
end