Missing NOT NULL and uniqueness constraints in DB

[sam (Sam Saffron)]

@Utsav

validates_uniqueness_of :name, case_sensitive: false

Case insensitive unique constraints are a bit tricky, I am uneasy adding the citext extension for this and we would be forced then to go name_lower and dupe the column just to add the index.

@Utsav

validates :word, presence: true, uniqueness: true, length: { maximum: 50 }

Yeah we should fix this

@Utsav

Finally, WebHookEventType - name . ( app/models/web_hook_event_type.rb ):

Also fine to add an index here.