Last answered:

27 Jan 2023

Posted on:

25 Jan 2023

0

Resolved: customer id data type

why not to make customer_id a char or varchar instead of int as we will not perform operation on the customer_id like summation and so on

1 answers ( 1 marked as helpful)
Instructor
Posted on:

27 Jan 2023

0

Hi Toka!
Thanks for reaching out.

Nice question! There's no right answer to this. Many organizations use alphanumeric sequences for customer id's, so that would need to be a VARCHAR. But in some cases they use INT for such columns. So, for the purposes of the lecture INT is used but it may be used VARCHAR.

Hope this helps.
Best,
Tsvetelin

Submit an answer