MySQL Workbench Build table when PK NN UQ BIN UN ZF AI meaning

Known as one of the most popular open source database, MySQL is widely used in various scenarios, Alibaba Cloud provides high available ApsaraDB RDS for MySQL with enhanced MySQL service reduced enterprise’s database expenses, and helped enterprises utilize technology to fight against novel coronavirus.

pk== "PRIMARY key = =" PRIMARY key
nn== "NOT NULL = =" cannot be empty
uq== "unique = =" The only
al== "Auto INCREMENT = =" Automatically added
Binary bin== "binary = ="
un== "UNSIGNED = =" unsigned bit
zf== "ZERO fill = =" Complement 0


PK belongs to primary key as primary key

NN NOT NULL non-null

UQ Unique index cannot be duplicated

BIN is binary column holds the columns of the binary data

UN Unsigned Data type unsigned datatype (integer data required)

ZF fill up the values for this column with 0 's if it is numeric fill 0 bits (for example specify 3 decimal places, Integer 18 will become 18.000)

AI Auto Incremental self-growth

MySQL Workbench Build table when PK NN UQ BIN UN ZF AI meaning.