[Koha-bugs] [Bug 31150] _on or _date for DB date columns?

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31150

--- Comment #1 from Jonathan Druart <jonathan.druart+koha at gmail.com> ---
IRC log, 20200723

<ashimema> remind me of our policy on db column name consistency
<Joubu> There_isNoCon_sistency!
<caroline> lol!
<caroline> maybe this?
https://wiki.koha-community.org/wiki/DBIC_naming_conventions
<Joubu> for a date, should end with _on 
<Joubu> or _date, apparently
<caroline> if above link is not good, let me know and I'll add a warning saying
this is not accurate
<caroline> I don't know for you, but I feel like no column should ever be
called just "id", but somethingid, so that it's the same in all tables
<ashimema> I wrote that guideline I think.
<ashimema> oh.. maybe not.. maybe I wrote the corresponding api one 
<ashimema> I prefer _on.. but don't really like inconsistency within a table
<ashimema> but I also don't want to update other fields in the table.

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.