车型数据库设计 mongodb

直接上代码了

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

// 汽车索引列表
const CarListSchema = new mongoose.Schema({
  // 首字母 A、B、C...
  initial: String,
  // 汽车品牌分类
  category: [{
    // 首字母
    initial: String,
    // 拼音
    pinyin: Array,
    // 汽车大品牌的名称
    name: String,
    logo: String,
    // 具体子品牌
    brand: [{
      // 子品牌名称
      name: String,
      car: [{ name: String, img: String, batch_at: Array }]
    }]
  }]
})

const CarList = mongoose.model('CarList', CarListSchema)
// export
module.exports = CarList;

在数据库中插入字母分类索引

db.carlists.insert({"initial":"A"});
db.carlists.insert({"initial":"B"});
db.carlists.insert({"initial":"C"});
db.carlists.insert({"initial":"D"});
db.carlists.insert({"initial":"E"});
db.carlists.insert({"initial":"F"});
db.carlists.insert({"initial":"G"});
db.carlists.insert({"initial":"H"});
db.carlists.insert({"initial":"I"});
db.carlists.insert({"initial":"J"});
db.carlists.insert({"initial":"K"});
db.carlists.insert({"initial":"L"});
db.carlists.insert({"initial":"M"});
db.carlists.insert({"initial":"N"});
db.carlists.insert({"initial":"O"});
db.carlists.insert({"initial":"P"});
db.carlists.insert({"initial":"Q"});
db.carlists.insert({"initial":"R"});
db.carlists.insert({"initial":"S"});
db.carlists.insert({"initial":"T"});
db.carlists.insert({"initial":"U"});
db.carlists.insert({"initial":"V"});
db.carlists.insert({"initial":"W"});
db.carlists.insert({"initial":"X"});
db.carlists.insert({"initial":"Y"});
db.carlists.insert({"initial":"Z"});