The meaning of Pk,nn,uq,bin,un,zf,ai when MySQL Workbench builds a table

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 unique key) unique

Ai:auto Increment (the column is auto incremented when rows are inserted) self-increment

Bin:binary (if DT is a blob or similar, this indicates, which is binary data, rather than text) binary (larger binary than text)

un:unsigned (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.

The meaning of Pk,nn,uq,bin,un,zf,ai when MySQL Workbench builds a table