SQL Naming conventions | Smarter Dev | Page 1

soft kernel Jul 9, 2024, 9:08 AM

#

Hey i need some outside input here. Cuz i dont like my thoughts i get here 😄

Im creating a database for saving questions, answers and tests taken.

There is a questions table, a answers table and a taken_tests table

the question table has id, type_id and "content"
the answers table has id, question_id and "content"

im curious how to name this "content" column properly...
i was thinking about "text" or simple "question" or "answer",
but... anyhow using questions.question feels wrong, same as questions.content

Any other ideas on this? How you do that? and why?

tulip panther Jul 9, 2024, 9:16 AM

#

questions.content seems fine to me

#

Idk about text

#

Btw, check out this https://dbdiagram.io/home

A Free Database Designer for Developers and Analysts

Quick and simple free tool to help you draw your database relationship diagrams and flow quickly using just keyboard

#

It pretty cool, and it's easier to show an er diagram instead of trying to explain your tables and attributes haha

soft kernel Jul 9, 2024, 9:19 AM

#

yeah i know, just wanted not use much time on asking this question sorry 😄 (i thought woud be enough to udnerstand my question)
Ima chekc that out in a few

#SQL Naming conventions