search

AdaHeads / call-flow-control

Call-information flow server.
Other
6 stars 8 forks source link

Database field naming #84

Closed sparre closed 10 years ago

sparre commented 10 years ago

Remove the uninformative (and not very beautiful) "_id" suffix from "organization" and "contact" reference fields in the database schema.

rostgaard commented 10 years ago

What is your suggestion for a better name? Something like "references"? Anyway, I think the entire database schema should probably be revised at some point - so maybe this should rather be part of a more general database-cleanup task?

PedersenThomas commented 10 years ago

I think the suggestion was, for instance in organization_contacts it has the fields organization_id and contact_id, they should just be called organization and contact.

rostgaard commented 10 years ago

In that case, I think that organization_id is more appropriate, as this is what it is. But then again, I'm no database design expert.

sparre commented 10 years ago

But "id" is the type. It represents an organization/contact.

BTW: PedersenThomas is working on an overhaul of the entire database schema.