MySQL Workbench build table when Pk,nn,uq,bin,un,zf,ai

[Intrinsic column Flags] (basic field type identification)
-pk:primary Key (column is part of a PK) primary key-Nn:not null (column is nullable) non-null-uq:unique (column is part of a uniqu E key) Unique-Ai:auto increment (the column is auto incremented if rows are inserted) self-increment
[Additional data type flags, depend on used datatype]
-Bin:binary (if DT is a blob or similar, this indicates is binary data, rather than text) binary (larger binary than text)-Un:u nsigned (for-integer types, see docs: "10.2.) Numeric Types ") integer-Zf:zero fill (rather a display related flag, see docs:" 10.2.  The most significant byte in the Numeric Types ") value is always 0, and is not saved. Ps:zf personal understanding refers to data that is equivalent to the amount type of data with a decimal placeholder.

MySQL Workbench build table when Pk,nn,uq,bin,un,zf,ai