When creating a table in mysqlworkbench, PK, NN, UQ, BIN, UN, ZF, AI_MySQL

When creating a table in mysqlworkbench, PK, NN, UQ, BIN, UN, ZF, AI bitsCN.com

[Intrinsic column flags] (basic field Type Identifier)
-PK: primary key (column is part of a pk) primary key
-NN: not null (column is nullable) not empty
-UQ: unique (column is part of a unique key) unique
-AI: auto increment (the column is auto incremented when rows are inserted) auto-increment

[Additional data type flags, depend on used data type] extended data type mark
-BIN: binary (if dt is a blob or similar, this indicates that is binary data, rather than text) binary (larger binary data 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. Numeric Types") indicates that the most meaningful bytes are 0 and are not saved.

Ps: ZF personal understanding refers to data with decimal placeholders equivalent to the amount type.

BitsCN.com