Description of Pk,nn,uq,bin,un,zf,ai in MySQL Workbench

　　

-pk:primary Key (column is part of a PK) primary key
-Nn:not Null (column is nullable) is empty (non-empty)
-Uq:unique (column is part of a unique key) unique index (foreign key)
-Ai:auto Increment (the column is auto incremented if rows are inserted) automatically increases
-Bin:binary (if DT is a blob or similar, this indicates is binary data, rather than text) binary (larger than text)
-un:unsigned (for integer types, see docs: "10.2. Numeric Types ") unsigned integral type (non-negative)
-Zf:zero fill (rather a display related flag, see docs: "10.2. Numeric Types ") 0 fill 0 For example, the field content is 1 int (4), the content is displayed as 0001

Description of Pk,nn,uq,bin,un,zf,ai in MySQL Workbench