Is there one table per item category | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Is there one table per item category

In eshops item dont have same attributes . Do they make a new table for each category or there is a flex cloumn?

9th Sep 2019, 4:32 PM
mortza bahjat
mortza bahjat - avatar
5 Answers
+ 1
Can you give an example about how items don't have same attributes?
9th Sep 2019, 5:43 PM
Ipang
+ 1
A phone has android version while a air conditionar has output volume
9th Sep 2019, 5:48 PM
mortza bahjat
mortza bahjat - avatar
+ 1
You can create a 'notes' column to contain such data, use TINYTEXT or something compatible for the field type
9th Sep 2019, 6:05 PM
Ipang
+ 1
It's one of the SQL data types, allows storing text data up to 255 characters. You can add a column of TINYTEXT type in your table to store product details. https://www.w3schools.com/sql/sql_datatypes.asp
10th Sep 2019, 1:24 PM
Ipang
0
I searched for tiny text what was your point its a text formating site
10th Sep 2019, 11:06 AM
mortza bahjat
mortza bahjat - avatar