Monster Market ships parcels. The team describes what the shipments table must hold:
| Column | What it holds |
|---|---|
id | a whole number; the shop will never ship more than a few million parcels |
tracking_code | always exactly 12 characters, such as MM2025000123 |
carrier | the carrier's name, at most 40 characters |
weight_kg | the weight in kilograms, exact to the gram (3 places after the point), always less than 1000 |
shipped_at | the day and the time of day the parcel left |
signed_for | yes or no: did someone sign for the parcel? |
contact_phone | a phone number such as +1 705 555 0142 |
The order of the columns is free. A wrong type? Click Reset lab and create the table again.
- Create
shipmentswith the smallest correct type for each column. - Without running anything: can an
integercolumn hold three billion (3000000000)? Answer yes or no. 2147483647is the largestinteger. RunSELECT 2147483647 + 1;. What are the three words of the error?