chart-admin/app/model/iviBehaviorRecordModel.js

'use strict';
module.exports = app => {
  const mongoose = app.mongoose;
  const Schema = mongoose.Schema;
  const conn = app.mongooseDB.get('etlDB');
  // IVI用户行为埋点，类似APP行为埋点  联合驾驶行为集合统计听歌，听新闻等行程
  const IviBehaviorRecordSchema = new Schema({
    _id: { type: String }, // vin+behavior_id+ 日月年+序列号
    user_id: { type: String }, // IVI用户ID
    vin: { type: String }, // 车辆VIN
    behavior_id: { type: Number }, // 行为ID  听歌20020001，听电台20010001，看新闻20050001，看视频 20030001
    create_time: { type: Number }, // 行为开始时间

  });

  IviBehaviorRecordSchema.index({ create_time: -1 });
  IviBehaviorRecordSchema.index({ create_time: -1, vin: -1 });
  return conn.model('IviBehaviorRecord', IviBehaviorRecordSchema, 'ivi_behavior_record');
};