MySQL Basics In Pictures

Here are the datatypes and properties for these fields: