user.js 2.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122
  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. deadline: {
  30. type:String,
  31. default: '',
  32. },
  33. }, { _id: false })
  34. const userdList = mongoose.Schema({
  35. compilationId: String
  36. }, {_id: false});
  37. // 表结构
  38. let schema = {
  39. ssoId: {
  40. type: Number,
  41. unique: true,
  42. },
  43. username: String,
  44. email: String,
  45. mobile: {
  46. type: String,
  47. // unique: true,
  48. },
  49. qq: {
  50. type: String,
  51. default: ''
  52. },
  53. real_name: {
  54. type: String,
  55. default: ''
  56. },
  57. company: {
  58. type: String,
  59. default: ''
  60. },
  61. province: {
  62. type: Number,
  63. default: -1
  64. },
  65. version: {
  66. type: [versionSchema],
  67. default: []
  68. },
  69. company_type: {
  70. type: Number,
  71. default: -1,
  72. },
  73. company_scale: {
  74. type: Number,
  75. default: -1
  76. },
  77. // 最后登录时间
  78. latest_login: {
  79. type: Number,
  80. default: 0
  81. },
  82. //最近使用编办
  83. latest_used:String,
  84. create_time: Number,
  85. upgrade_list:[upgrade],
  86. user_type:{
  87. type:String,
  88. default:'normal'// normal : 普通用户,test:测试用户
  89. },
  90. //使用过的费用定额,主要目的拷贝用户在该费用定额下的一些数据模板 eg:用户第一次进入该费用定额的补充定额库时,拷贝补充定额的章节树
  91. used_list: {
  92. type: [userdList],
  93. default: []
  94. },
  95. // 联系人
  96. contacts: {
  97. type: Array,
  98. default: []
  99. },
  100. // 是否邮箱已通过验证
  101. isUserActive: Number,
  102. // 是否只允许短信登录
  103. isSmsLogin: {
  104. type: Number,
  105. default: 0
  106. },
  107. // 登录异常短信通知
  108. isLoginValid: {
  109. type: Number,
  110. default: 0
  111. },
  112. welcomeShowTime:String,
  113. token: String
  114. };
  115. mongoose.model(collectionName, new Schema(schema, {versionKey: false}));