MySQL Workbench Pk,nn,uq,bin,un,zf,ai explained when building tables

MySQL Workbench when you build 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 uniqu E key) Unique-Ai:auto increment (the column is auto incremented when rows is 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 do CS: "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.

　

MySQL Workbench Pk,nn,uq,bin,un,zf,ai explained when building tables