const { boolean } = require("joi");
const sequelize = require("./config");

const generateQuotations = sequelize.define("generatequotations", {
  customerName: {
    type: String,
    required: true,
  },
  projectName: {
    type: String,
    required: true,
  },
  plotNo: {
    type: String,
    required: true,
  },
  plotSize: {
    type: String,
    required: true,
  },
  rate: {
    type: String,
    required: true,
  },
  totalAmount: {
    type: String,
    required: true,
  },
  bookingAmount: {
    type: String,
    required: true,
  },
  downPayment: {
    type: String,
    required: true,
  },
  loanAmount: {
    type: String,
    required: true,
  },
  stampDuty: {
    type: String,
    required: true,
  },
  registration: {
    type: String,
    required: true,
  },
  totalStamReg: {
    type: String,
    required: true,
  },
  legalFees: {
    type: String,
    required: true,
  },
  mutation: {
    type: String,
    required: true,
  },
  agreement: {
    type: String,
    required: true,
  },
  dataEntry: {
    type: String,
    required: true,
  },
  society: {
    type: String,
    required: true,
  },
  total: {
    type: String,
    required: true,
  },
  corpusFund: {
    type: String,
    required: true,
  },
  plot_id: {
    type: Number,
    required: true,
  },
  broker_id: {
    type: Number,
    required: true,
  },
});

module.exports = generateQuotations;
