user.js

/**
 * Created by itsx02 on 2016/8/8.
 */
module.exports = function (sequelize, DataTypes) {
    return sequelize.define('User',
        {
          id: {type: DataTypes.BIGINT(11), autoIncrement: true, primaryKey: true, unique: true, comment: '用户Id'},
          //id:{type:DataTypes.UUID, defaultValue:DataTypes.UUIDV1, primaryKey : true},//使用uuid
          username: { type: DataTypes.STRING, allowNull: false, comment:'用户名' },
          password: { type: DataTypes.STRING, allowNull: false, comment:'用户密码' },
          active: { type: DataTypes.BOOLEAN, allowNull: false, defaultValue: true, comment:'是否正常状态'
          } 
        }, 
        { 
            timestamps: true, 
            underscored: true, 
            paranoid: true, 
            freezeTableName: true, 
            tableName: 'user', 
            charset: 'utf8', 
            collate: 'utf8_general_ci'
        }
    );
}