const Mongoose  = require('mongoose');
const Schema    = Mongoose.Schema;


const UserSchema = new Schema({
    username : {
        type: String,
        required: true,
    },
    email : {
        type: String,
        required: true,
        unique: true ,
        match: /^\w+([\.-]?\w+)*@\w+([\.-]?\w+)*(\.\w{2,3})+$/
    },
    password : {
        type: String,
        required: true
    }
}, {
    timestamps: true
});


const VisitSchema = new Schema({
    client: {
        type: Schema.Types.ObjectId,
        ref:  'Client'
    },
    user: {
        type: Schema.Types.ObjectId,
        ref: 'User'
    },
    visit_date : {
        type : Date,
        required: true
    },
    sales_quantity : {
        type: Number,
        required: true
    },
    value_received : {
        type: Number,
        required: true
    }
});

module.exports = {
    UserModel:  Mongoose.model('User', UserSchema),
    VisitModel: Mongoose.model('Visit', VisitSchema)
}