var Sequelize = require('sequelize');
var DataTypes = Sequelize.DataTypes;
var sequelize = new Sequelize(
   // ignore configs
  );
var User = sequelize.define("user", {
  username : { type : DataTypes.STRING },
  password : { type : DataTypes.STRING },
  balance : { type : DataTypes.INTEGER }
});

User.belongsToMany(User, {
  through : "user_friends",
  foreignKey: "friend_id",
  as : "Friends"
});

var TransactionRequest = sequelize.define("transaction_request", {
  amount : { type : DataTypes.INTEGER },
  ownner : {
    type: DataTypes.INTEGER,
    references : {
      model : User,
      key : "id"
    },
    allowNull : false
  },
  lender : {
    type: DataTypes.INTEGER,
    references : {
      model : User,
      key : "id"
    },
    allowNull : false
  },
  lendee : {
    type: DataTypes.INTEGER,
    references : {
      model : User,
      key : "id"
    },
    allowNull : false
  },
  state : {
    type : DataTypes.ENUM,
    values : ["PENDING", "ACCEPTED", "DENIED", "DONE"]
  }
});

var Transaction = sequelize.define("transaction", {
  amount : { type : DataTypes.INTEGER },
  from_user_id : {
    type: DataTypes.INTEGER,
    references : {
      model : User,
      key : "id"
    },
    allowNull : false
  },
  to_user_id : {
    type: DataTypes.INTEGER,
    references : {
      model : User,
      key : "id"
    },
    allowNull : false
  },
  request_id : {
    type: DataTypes.INTEGER,
    references : {
      model : TransactionRequest,
      key : "id"
    }
  }
});