2011年11月11日 星期五

Create table by MySql Workbench - The meaning of abbreviation for column properties

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.
 

沒有留言:

張貼留言