wh33t — 2012-09-18T19:24:41-04:00 — #1
Just a quick question here from a self taught do-it-yourself.
I'd like to know if there is a specific names for tables which describe their purpose.
For example if we have table A like item_categories, and table B like items and then we have table C item_category_relationship which would hold two columns category_id and item_id which houses the data of which items are in which category.
Is there an name or term that describes A & B, and C?
cpradio — 2012-09-18T19:32:22-04:00 — #2
The biggest hindrance most people have is not naming their tables descriptive names to begin with, so kudos on that, you are doing it right.
Typically in this situation, I would refer to the group of tables as the "item tables". Then anyone within the conversation would have some idea of what tables I would be referring to and when looking through phpmyadmin or SSMS would be able to quickly see which tables my generalization likely related to.
If I meant to specify a specific table, I would usually try to reference it by name or use a phrase that I know is very close/similar to the actual table name.
wh33t — 2012-09-18T19:38:22-04:00 — #3
So does that mean there isn't actually an official name A, B or C? I'm trying to really wrap my head around what specific purpose these tables represent as I need to make an effective MySQL generator that accompanies a PHP Code generator. I see table A as a object_type, table B as an object and table C as a relationship but I'd like to know their actual names (if such exists)
r937 — 2012-09-18T20:31:55-04:00 — #4
the name given to the table that implements a many-to-many relationship (e.g. item_categories, between items and categories) is relationship or association or linking or junction table
wh33t — 2012-09-18T21:30:24-04:00 — #5
Awesome. Thank you for clarifying. I swear one of these days I'm going to buy your book.
mittineague — 2014-09-18T22:41:13-04:00 — #6
This topic is now archived. It is frozen and cannot be changed in any way.