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)
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