user.js 2.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117
  1. /**
  2. * 用户数据结构
  3. *
  4. * @author CaiAoLin
  5. * @date 2017/6/28
  6. * @version
  7. */
  8. let mongoose = require("mongoose");
  9. let Schema = mongoose.Schema;
  10. // 表名
  11. let collectionName = 'user';
  12. const invalidSchema = new Schema({
  13. invalid: Boolean,
  14. invalidDate: String,
  15. invalidBy: String //管理者名
  16. });
  17. const versionSchema = new Schema({
  18. compilationId: String,
  19. activateCode: String,
  20. activatedDate: String,
  21. activatedBy: String,
  22. invalidInfo: [invalidSchema]
  23. });
  24. let upgrade = mongoose.Schema({
  25. compilationID:String,//编办ID
  26. upgrade_time:Number,
  27. isUpgrade:Boolean,
  28. remark:String//描述:广东办刘飞 2018-06-17 启用/关闭
  29. }, { _id: false })
  30. const userdList = mongoose.Schema({
  31. compilationId: String
  32. }, {_id: false});
  33. // 表结构
  34. let schema = {
  35. ssoId: {
  36. type: Number,
  37. unique: true,
  38. },
  39. username: String,
  40. email: String,
  41. mobile: {
  42. type: String,
  43. // unique: true,
  44. },
  45. qq: {
  46. type: String,
  47. default: ''
  48. },
  49. real_name: {
  50. type: String,
  51. default: ''
  52. },
  53. company: {
  54. type: String,
  55. default: ''
  56. },
  57. province: {
  58. type: Number,
  59. default: -1
  60. },
  61. version: {
  62. type: [versionSchema],
  63. default: []
  64. },
  65. company_type: {
  66. type: Number,
  67. default: -1,
  68. },
  69. company_scale: {
  70. type: Number,
  71. default: -1
  72. },
  73. // 最后登录时间
  74. latest_login: {
  75. type: Number,
  76. default: 0
  77. },
  78. //最近使用编办
  79. latest_used:String,
  80. create_time: Number,
  81. upgrade_list:[upgrade],
  82. user_type:{
  83. type:String,
  84. default:'normal'// normal : 普通用户,test:测试用户
  85. },
  86. //使用过的费用定额,主要目的拷贝用户在该费用定额下的一些数据模板 eg:用户第一次进入该费用定额的补充定额库时,拷贝补充定额的章节树
  87. used_list: {
  88. type: [userdList],
  89. default: []
  90. },
  91. // 联系人
  92. contacts: {
  93. type: Array,
  94. default: []
  95. },
  96. // 是否邮箱已通过验证
  97. isUserActive: Number,
  98. // 是否只允许短信登录
  99. isSmsLogin: {
  100. type: Number,
  101. default: 0
  102. },
  103. // 登录异常短信通知
  104. isLoginValid: {
  105. type: Number,
  106. default: 0
  107. },
  108. welcomeShowTime:String
  109. };
  110. mongoose.model(collectionName, new Schema(schema, {versionKey: false}));