DB Item Table Missing Column

[keremgure]

The Item table is missing a type column which is necessary for categorization.

Please add the feature ASAP!

Column should be type of int starting with 0.

Please do ask about requirements if you feel the need.

[Dheeraj1998]

Hey,

A column with an integer type would not allow any leading zeros, right? How about we add the zero with the use of left-padding command later on?

Thanks!

[keremgure]

Hi @Dheeraj1998,
First of all, Thank you! for your interest in this project. We are basically doing a CS Course Project but we wanted it to be a bit advanced that we can refer to later on. Any help is welcomed and very much appreciated.

To answer your comment,
I actually did not mean that 0 should be leading. I thought like we could have categories as numbers(maybe as a foreign key from the Categories Table which does not exist yet 🤦‍♂️) starting from 0?

I would love to hear any suggestions you may have!

Thank You!