MySQL Workbench's Pk,nn,uq,bin,un,zf,ai

MySQL Workbench Build table when PK, NN, UQ, BIN, UN, ZF, Ai meaning, behind a few old confused, with the record in this convenient for later check.

[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 unique 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, 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.

Ps:zf personal understanding refers to data that is equivalent to the amount type of data with a decimal placeholder.

Note: The content is from the network reference .

MySQL Workbench's Pk,nn,uq,bin,un,zf,ai