NAMING DATABASE ELEMENTSCHOOSING YOUR COLUMN TYPES<p> 
CHAR[length] - fixed field up to 350 characters

VAR[length] - variable length field up to 65,000 characters long

TINYTEXT - String with max length of 255 characters

TEXT - String with max length of 65,000 character

MEDUIMTEXT - String with max length of 16,777,000 characters

LONGTEXT - String with length of 4,300,000,000 characters

TINYINT[length] - range of -128 to 127
OR 0 to 255 unsigned

SMALLINT[length] - range of -32,000 to 32,700
OR 0 to 65,500 unsigned

INT[length] - Range of -2,000,000,000 to 2,000,000,000 
OR 0 to 4,200,000,000 unsigned

BIGINT[length] - Range of -9,200,000,000,000 to 9,200,000,000,000
OR 0 to 18,400,000,000,000 unsigned

FLOAT[length, decimals] - small number with floating decimal point

DOUBLE[length, decimals] - large number with floating decimal point

DECIMAL[length, decimals] - large number with fixed floating decimal point

DATE - YYYY-MM-DD

DATETIME - YYYY-MM-DD   HH:MM:SS

TIMESTAMP - YYYYMMDDHHMMSS starting 1970 to 2038

TIME - HH:MM:SS

ENUM - means enumeration, can only have one of several possible values

SET - like ENUM but can have several possible values </p>OTHER COLUMN PROPERTIES