Naming Conventions - tables

[nathcast]

A few sites with naming conventions:

• [Laravel Naming Conventions.md]
• Laravel Guidelines - Naming conventions

These conventions make a difference bettween proterty tables (like identifier_types) and pivot tables which are in singular, alphabetic order.

At the moment, all the tables are plural and the pivot tables are not names according to these guidelines. Shall we rename them?

So according to guidelines, these tables need to be renamed (new name)

• document_dates >> data_document
• document_formats >> document_format
• document_subjects >> document_subject
• experiment_factors >> experiment_factor
• organisation_creators >> creator_organisation
• person_creators >> creator_person
• person_roles >> metadata_document_person_role (this one is a triple!!) - person_role

[richardostler]

Unless I'm missing the meaning of pivot tables, none of these are pivot tables so I don't think they need renaming. Most of these tables I would understand as resolution tables to resolve many-many relationships