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

1.

[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-incrementwww.2cto.com[Additional data type flags, depend on used datatype]
-Bin:binary (if DT is a blob or similar, this indicates 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