Please enable / Bitte aktiviere JavaScript!
Veuillez activer / Por favor activa el Javascript![ ? ]
Does it make sense to store the size of the product in three different fields (l x W x h)? - bug-code.com Q&A

Does it make sense to store the size of the product in three different fields (l x W x h)?

0 like 0 dislike
10 views
Think about the future and expansion project (online store, POS, control panel for staff, etc. all in one), therefore the question arose:
How best to keep the dimensions of the product? To have three separate fields? Sizes or just one?

And Yes, advise, please, any primitive book about database (Mysql) in Russian, after reading that, I'm not going to ask such questions
asked by | 10 views

2 Answers

0 like 0 dislike
To muscle this question is not directly related - you need to look for a book on designing database

Can be stored in a single field, in several, in Jane - depends on what we need to do with this field
answered by
0 like 0 dislike
If you think about the future - definitely 3-dimensional. Three sizes to collect the line 150*25*120 - the operation is much easier than parsing in and of itself no guarantee that there will not bulge 15смх25ммх1.2m
answered by
Welcome to Bug-code Q&A, where you can ask questions and receive answers from other members of the community.

24.8k questions

46.2k answers

0 comments

13.3k users

24,788 questions
46,220 answers
0 comments
13,322 users