db.js

const sequelize = require('sequelize');

const db = new sequelize ({
    host:"localhost",
    username:"root",
    database:"testdb",
    password:"toor",
    dialect:"mysql"
});

const credit =  db.define('credit',{
    id:{
        type: sequelize.DataTypes.INTEGER,
        primaryKey:true,
        autoIncrement:true
    },
    mode: sequelize.DataTypes.STRING,
    detail:sequelize.DataTypes.BOOLEAN,
    amount:sequelize.DataTypes.INTEGER,
});

const user =  db.define('user',{
    id:{
        type: sequelize.DataTypes.INTEGER,
        primaryKey:true,
        autoIncrement:true
    },
    username:sequelize.DataTypes.STRING,
    email:sequelize.DataTypes.STRING,
    pass:sequelize.DataTypes.STRING,
    name:sequelize.DataTypes.STRING,
    mob:sequelize.DataTypes.STRING,
    Budget:sequelize.DataTypes.INTEGER
});

const spendings =  db.define('spendings',{
    id:{
        type: sequelize.DataTypes.INTEGER,
        primaryKey:true,
        autoIncrement:true
    },
    user:sequelize.DataTypes.STRING,
    detail:sequelize.DataTypes.STRING,
    amount:sequelize.DataTypes.INTEGER,
    Mode:sequelize.DataTypes.STRING
});

const investment =  db.define('investment',{
    id:{
        type: sequelize.DataTypes.INTEGER,
        primaryKey:true,
        autoIncrement:true
    },
    user:sequelize.DataTypes.STRING,
    detail:sequelize.DataTypes.STRING,
    amount:sequelize.DataTypes.INTEGER,
    Mode:sequelize.DataTypes.STRING
});

const reminder =  db.define('reminders',{
    id:{
        type: sequelize.DataTypes.INTEGER,
        primaryKey:true,
        autoIncrement:true
    },
    user:sequelize.DataTypes.STRING,
    detail:sequelize.DataTypes.STRING,
    amount:sequelize.DataTypes.INTEGER,
    date:sequelize.DataTypes.STRING
});
const transaction = db.define('transaction',{
    id:{
        type: sequelize.DataTypes.INTEGER,
        primaryKey:true,
        autoIncrement:true
    },
    user:sequelize.DataTypes.STRING,
    detail:sequelize.DataTypes.STRING,
    amount:sequelize.DataTypes.INTEGER,
    date:sequelize.DataTypes.STRING,
    type:sequelize.DataTypes.STRING,
    Mode:sequelize.DataTypes.STRING
})

db.sync().then(function () {
    console.log("Database is ready");
})

module.exports = {
    user,
    spendings,
    credit,
    reminder,
    investment,
    transaction
}