/**
 * 批发市场检验信息表
 */
var mongoose = require("./mongodb");
var Schema = mongoose.Schema;
var moment=require('moment');

var  marketDetectionSchema = new Schema(
    {
        CITY_CODE:{type: String,default:''},//城市编码
        MARKET_ID:{type: String,default:''},//批发市场编码
        MARKET_NAME:{type: String,default:''},//批发市场名称
        WHOLESALER_ID:{type: String,default:''},//批发商编码
        WHOLESALER_NAME:{type: String,default:''},//批发商姓名
        BATCH_ID:{type: String,default:''},//批次码
        VOUCHER_TYPE:{type: Number,default:0},//凭证类型  1.食用农产品合格证编号   2.自产生批次码
        VARIETY_CODE:{type: String,default:''},//品种编码
        VARIETY_NAME:{type: String,default:''},//品种名称
        SAMPLE_ID:{type: String,default:''},//样品编码
        DETECTOR:{type: String,default:''},//检验员
        DETECTION_DATE:{type: Date},//抽检日期
        DETECTION_RESULT:{type: Number},//检验结果
        RESULT_EXPL:{type: String,default:''},//检验结果说明

    },{
        strict: true,
        toObject: {
            virtuals: true
        },
        toJSON: {
            virtuals: true
        }
    });

var marketDetection = mongoose.model('marketDetection',
    marketDetectionSchema,'t_marketDetection');

module.exports = marketDetection;