TLDR: Database Naming

Credit: Photo by Tobias Fischer on Unsplash

Table names should be plural (ex: users, customers,…)
Use underscore_names (ex: user_id, user_role,…)
Don’t name primary key column id

Don’t make column names unclear (ex: u_role,…)
Name foreign key …


This content originally appeared on DEV Community and was authored by An Pham

Credit: Photo by Tobias Fischer on Unsplash

  • Table names should be plural (ex: users, customers,...)
  • Use underscore_names (ex: user_id, user_role,...)
  • Don't name primary key column id
  • Don't make column names unclear (ex: u_role,...)
  • Name foreign key columns the same as the columns they refer to


This content originally appeared on DEV Community and was authored by An Pham


Print Share Comment Cite Upload Translate Updates
APA

An Pham | Sciencx (2021-08-16T15:16:27+00:00) TLDR: Database Naming. Retrieved from https://www.scien.cx/2021/08/16/tldr-database-naming/

MLA
" » TLDR: Database Naming." An Pham | Sciencx - Monday August 16, 2021, https://www.scien.cx/2021/08/16/tldr-database-naming/
HARVARD
An Pham | Sciencx Monday August 16, 2021 » TLDR: Database Naming., viewed ,<https://www.scien.cx/2021/08/16/tldr-database-naming/>
VANCOUVER
An Pham | Sciencx - » TLDR: Database Naming. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2021/08/16/tldr-database-naming/
CHICAGO
" » TLDR: Database Naming." An Pham | Sciencx - Accessed . https://www.scien.cx/2021/08/16/tldr-database-naming/
IEEE
" » TLDR: Database Naming." An Pham | Sciencx [Online]. Available: https://www.scien.cx/2021/08/16/tldr-database-naming/. [Accessed: ]
rf:citation
» TLDR: Database Naming | An Pham | Sciencx | https://www.scien.cx/2021/08/16/tldr-database-naming/ |

Please log in to upload a file.



There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.

Related Posts