userjuris-service/app/model/marketuser.js

'use strict';
const Schema = require('mongoose').Schema;
const metaPlugin = require('naf-framework-mongoose/lib/model/meta-plugin');
const { Secret } = require('naf-framework-mongoose/lib/model/schema');

// 科技超市用户表
const MarketuserSchema = {
  name: { type: String, required: true, maxLength: 200 }, // 用户名
  password: { type: Secret, required: true, select: false }, // 登录密码
  phone: { type: String, required: false, maxLength: 200 }, // 电话号码
  email: { type: String, required: false, maxLength: 200 }, // 邮箱
  addr: { type: String, required: false, maxLength: 500 }, // 地址
  img_path: { type: String, required: false }, // 头像图片
  resume: { type: String, required: false }, // 个人简介
  major: { type: String, required: false }, // 专业领域
  institution_code: { type: String, required: false, maxLength: 500 }, // 机构代码
  office_phone: { type: String, required: false, maxLength: 500 }, // 办公电话
  profession: { type: String, required: false, maxLength: 500 }, // 所属行业
  status: { type: String, required: false, default: '0', maxLength: 200 }, // 审核状态,0-注册,1-通过,2-拒绝
  is_del: { type: String, required: false, maxLength: 200 }, // 是否删除,0-否,1-是
  role: { type: String, required: false, maxLength: 200 }, // 1-管理员,2-个人,3-企业管理员,4-子管理员
  token: { type: String, required: false, maxLength: 500 }, // 令牌
  columnid: [ String ],
  pid: { type: String, required: false }, // 父id
  deptname: { type: String, required: false }, // 机构名称
  code: { type: String, required: false }, // 邀请码
  openid: { type: String, required: false }, // 微信openid
  companytype: { type: String, required: false, maxLength: 300 }, // 注册类型
  companydate: { type: String, required: false, maxLength: 300 }, // 注册时间
  companycapital: { type: String, required: false, maxLength: 300 }, // 注册资金
  companyperson: { type: String, required: false, maxLength: 300 }, // 企业法人
  sndqyzsr: { type: String, required: false, maxLength: 300 }, // 上年度企业总收入
  sndyffy: { type: String, required: false, maxLength: 300 }, // 上年度研发费用
  companytotal: { type: String, required: false, maxLength: 300 }, // 企业总人数
  zjzyfrs: { type: String, required: false, maxLength: 300 }, // 专&兼职研发人数
  companybrief: { type: String, required: false }, // 企业简介
  mainproduct: { type: String, required: false, maxLength: 300 }, // 主要产品
  qualifications: { type: String, required: false, maxLength: 300 }, // 企业资质&荣誉
  isdel: { type: String, required: false, default: '0' }, // 0=>未删除;1=>已删除
};


const schema = new Schema(MarketuserSchema, { toJSON: { virtuals: true } });
schema.index({ id: 1 });
schema.plugin(metaPlugin);

module.exports = app => {
  const { mongoose } = app;
  return mongoose.model('Marketuser', schema, 'marketuser');
};