Exercise SQL: Creating Customer table
When creating the customer table, the answer was the following:
CREATE TABLE customers
My script included "primary key" after customer_id INT.
Also, I put "unsigned" after number_of_complaints int
Shouldn't the customer_id be a Primary Key and the number of complaints be unsigned since we can't have a negative number of complaints?
CREATE TABLE Customers
customer_id INT PRIMARY KEY,
number_of_complaints INT unsigned
Thank you for taking the time to read my question.
- You've taken the task a step ahead by specifying the primary key at this stage. Congratulations on that! Moreover, this complies with our tasks and the purpose of having the Customers table in general, therefore, this is addition of your works great.
- Yes, your intuition is absolutely correct. We've relied on simplicity to teach the syntax that has been relevant for the given video. However, your remark is spot on!