Mysql workbench table creation PK, NN, UQ, BIN, UN, ZF, AI, workbenchuq

Mysql workbench table creation PK, NN, UQ, BIN, UN, ZF, AI, workbenchuq
[Intrinsic column flags] (basic field type identifier)
-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) 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 (binary data larger 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 ") 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.