ConstructionCost/modules/all_models/calc_program_model.js

/**
 * Created by CSL on 2017-10-22.
 */
let mongoose = require('mongoose');
let Schema = mongoose.Schema;

let calcItemSchema = new Schema({
    ID: Number,
    code: String,
    name: String,
    fieldName: String,
    dispExpr: String,
    dispExprUser: String,
    expression: String,
    compiledExpr: String,
    statement: String,
    feeRateID: Number,
    feeRate: String,
    labourCoeID: Number,
    memo: String,
    custom: Boolean
},{versionKey:false, _id: false});

let templateSchema = new Schema({
    ID: Number,
    name: String,
    calcItems: [calcItemSchema],
    custom: Boolean
},{versionKey:false, _id: false});

let stdCalcPrograms = new Schema({
    ID: Number,
    region: String,
    libName: String,
    templates: [templateSchema]
},{versionKey:false, _id: false});

let projectCalcPrograms = new Schema({
    ID: {type: String, index: true},
    projectID: {type: Number, index: true},
    name: String,
    libID: Number,
    libName: String,
    templates: [templateSchema]
},{versionKey:false});

let gatherCalcItemSchema = new Schema({
  ID: Number,
  code: String,
  dispExprUser: String,
  displayFieldName: String,
  fieldName: String,
  name: String,
  statement: String,
  totalFee: String,
  unitFee: String,
  feeRate: String,
  memo: String
},{versionKey:false, _id: false});

let gatherCalcProgramSchema = new Schema({
  ID: Number,
  name: String,
  totalFee: String,
  calcItems: [gatherCalcItemSchema],
},{versionKey:false, _id: false});

let gatherCalcPrograms = new Schema({
  projectID: {type: Number, index: true},
  totalFee: String,
  calcPrograms: [gatherCalcProgramSchema]
},{versionKey:false});

mongoose.model('std_calc_programs', stdCalcPrograms, 'std_calc_programs');
mongoose.model('calc_programs', projectCalcPrograms, 'calc_programs');
mongoose.model('gather_calc_programs', gatherCalcPrograms, 'gather_calc_programs');