MySQL Workbench build table when Pk,nn,uq,bin,un,zf,ai

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

MySQL Workbench build table when Pk,nn,uq,bin,un,zf,ai