Timeline for Is it Considered Good SQL practice to use GUID to link multiple tables to same Id field?
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 13, 2012 at 20:57 | comment | added | NoChance | In reading an association between two tables in an ERD (for example, Customer and Order) you must prefix the statement with the word "Each", so you read the association as "Each Customer places 0,1, or more Order(s)). If you name your table Customers then Each would be odd. Also in some cases your table name becomes your class name and finally, it is stated that you should use singular nouns in IDEF1X - December 21, 1993 - Section:3.1.2: Entity Syntax3.1.2. Having said that, its still a choice. | |
| Nov 13, 2012 at 16:10 | comment | added | kevin cline | Why no plural table names? Ruby's ActiveRecord also uses plural table names. Is it the irregularity of English plurals, e.g. person / people ? | |
| Nov 13, 2012 at 13:15 | comment | added | NoChance | "but wouldn't that be the point of using GUID", using GUID will not prevent cascade effects. One way is to have all FKs optional and ensure that only 1 is filled in any row. This way cascade delete will not affect more than 1 child row of m-m side. The most clean way I see to solve the 4 tables problem is go with #5 with any choice of Primary Key datatype. | |
| Nov 13, 2012 at 4:28 | comment | added | Mallow | Lots to think about. I can answer number 4 with the most confidence in that yes it is m-m. One picture might be located in two different locations. (Back up, original, "customer's" computer) and a location (aka most probably a folder) can harbor many pictures. #5 would solve that problem easily. As for my question #1 indicates that if I combined the fk then cascading would delete things that I wouldn't want deleted, but wouldn't that be the point of using GUID. I guess I wanted to solve having four tables vs one and it seems that either I use GUID or put a type (#5) on my original table. | |
| Nov 13, 2012 at 3:12 | history | edited | NoChance | CC BY-SA 3.0 | added 618 characters in body |
| Nov 13, 2012 at 3:00 | history | answered | NoChance | CC BY-SA 3.0 |