Primary Key: used for sorting or retrieving the field.
Not Null: data shall always be provided
Uniq Index: Create/remove Unique Key
Auto Increment: only for number, like an ID, is automatically incremented for each new data entry.
Unsigned: non-negative numbers only. so if the range is -500 to 500, instead its 0 - 1000, the range is the same but it starts at 0.
Fill with 0: if the length is 5 like INT(5) then every field is filled with 0’s to the 5th value. 12 = 00012, 400 = 00400, etc.
Is Binary: stores data as binary strings. There is no character set so sorting and comparison is based on the numeric values of the bytes in the values.
Refer to mySQL documentation for more information on these flags.
