Mysql – column options

Options MySQL Server 5.7

• PK: PRIMARY KEY
• NN: NOT NULL
• UQ: UNIQUE INDEX
• BIN: BINARY
• UN: UNSIGNED
• ZF: ZEROFILL
• AI: AUTO_INCREMENT
• G: Generated Column