Assume we need a column called "zip_code" in a table called "addresses". We want zip_code to be a character string type with a maximum length of 7, but zip codes of less than 7 should be permitted...

Extracted text: Assume we need a column called "zip_code" in a table called "addresses". We want zip_code to be a character string type with a maximum length of 7, but zip codes of less than 7 should be permitted too. What is the correct type of "zip_code"? SQL keywords and logical operators (AND, OR, NOT) should be UPPERCASE. Column names should be unquoted. Type names should be lowercase, and with no spaces if there are parentheses. Add spaces around comparison and numeric operators (val1 + val2) if writing out expression; otherwise write in only the operator without any other characters.