kaspiana / mage

A command-line tool for cataloguing images (particularly digital art), styled after Git.
0 stars 0 forks source link

Better naming convention in SQL database #31

Closed kaspiana closed 3 months ago

kaspiana commented 3 months ago

The naming convention used in the setup script and SQL fragments at present is Pascal case, e.g. DocumentTag, with nouns always in the singular. The latter is likely fine, but the former is somewhat distasteful. I would prefer names like document and document_id in all code.

Current

select DocumentID, TagID from DocumentTag;

Suggestion

select document_id, tag_id from document_tag;

Alternative

select document_id, tag_id from document_tags;