The following abbreviations are the column properties when creating column by MySQL Workbench:
- PK: Belongs to primary key
- NN: Not null
- UQ: Unique index
- BIN: Is binary column
- UN: Unsigned data type
- ZF: Fill up values for that column with 0's if it is numeric.
- AI: Auto Incremental.

沒有留言:
張貼留言