var fileSchema = new mongoose.Schema ({
    type: {type: String, required: true, lowercase: true},
    year: { type: Number, required: true, min: 2016, get: v => Math.round(v), set: v => Math.round(v) },
    value: {type: Number, min: 0.01 },
    lastFile: { type: mongoose.Schema.Types.ObjectId, ref: 'File' },
    remarks: String,
    createdby: { type: mongoose.Schema.Types.ObjectId, ref: 'User' },
    created: {type: Date, default: Date.now},
    company: { type: mongoose.Schema.Types.ObjectId, ref: 'Company' },
    status: {type: String, required: true},
    emailedby: { type: mongoose.Schema.Types.ObjectId, ref: 'User' },
    emailed: {type: Date},
    updatedby: { type: mongoose.Schema.Types.ObjectId, ref: 'User' },
    updated: {type: Date, default: Date.now},
    confirmedby: { type: mongoose.Schema.Types.ObjectId, ref: 'User' },
    confirmed: {type: Date},
    comments: [{ type: mongoose.Schema.Types.ObjectId, ref: 'Comment' }]
});

var userSchema = new mongoose.Schema ({
    username: {type: String, required: true},
    password: {type: String},
    role: {type: String, required: true},
    confirmed: {type: Boolean, required: true, default: false},
    active: {type: Boolean, required: true, default: true},
    name: String,
    created: {type: Date, default: Date.now},
    admin: {type: Boolean, default: false, required: true}
});

var companySchema = new mongoose.Schema ({
    name: {type: String, required: true, unique: true},
    bizreg: {type: String, required: true, unique: true},
    created: {type: Date, default: Date.now},
    month: {type: Number, required: true, min: 1, max: 12},
    active: {type: Boolean, required: true, default: true},
    clients: [{ type: mongoose.Schema.Types.ObjectId, ref: 'User' }]
});