Naming tables
plural namescarscarlower case table namesvendorsVendorsEnglish table namesIf you are targeting international market or may need help from other developers around the world, consider using English names. This will help developers and this will decrease time and cost.carsշարժական_կազմavoid concatenationvendorsvehicle_vendor_listVehicleVendorsavoid special chracterscarsfahrzeugefahrzeug_verträgeuse underscore _ if necessarycar_notescar_documentscarnotescardocuments Next: Naming detail tables (1:n)
Detail tables (Master-Detail)
If records of a detail-table always (!) belong to exactly one record of a master-table (1:n relation), you can already show the relation between master-table and details-table in the name of the detail-table so that every developer who can see the tablename already knows the relation to the master table. use singular of master-table, then underscore _, then plural of...
Many to many relation tables
In business applications you often need many-to-many relations for storing relations between business objects. Example Imagine a library software in which we want to store books. A single book may have one or multiple authors. On the other hand one author may have written one or multiple books. In this case, next to the tables books and authors,...