Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Fix the naming of contactgroup and contactgroup_member #187

Open
ncosta-ic opened this issue Apr 24, 2024 · 0 comments
Open

Fix the naming of contactgroup and contactgroup_member #187

ncosta-ic opened this issue Apr 24, 2024 · 0 comments
Labels
low priority Might not receive attention any time soon

Comments

@ncosta-ic
Copy link
Member

ncosta-ic commented Apr 24, 2024

Currently, the PostgreSQL schema uses the snake_case notation and distinguishes between basic data and data additions.
Examples:

  • Table contact => Holds the basic information for a contact/user.

  • Table contact_address => Holds additional information about a contact's address data.

  • Table incident => Holds the basic information for an incident.

  • Table incident_contact => Holds additional information about what contacts are associated with the incident.

This notation is used everywhere, with the exception of the contactgroup. As this table holds basic information about the group itself, it's not directly associated with a contact. That only happens if a contact gets its relation assigned in the contactgroup_member table.
Thus I would suggest to either change the table names contactgroup and contactgroup_member to just group and group_member or to add an additional underscore to emphasize their distinctions (contact_group and contact_group_member in that case).

@ncosta-ic ncosta-ic added the low priority Might not receive attention any time soon label Apr 24, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
low priority Might not receive attention any time soon
Projects
None yet
Development

No branches or pull requests

1 participant