Advertisement
Guest User

Untitled

a guest
Sep 23rd, 2019
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
JSON 2.17 KB | None | 0 0
  1. Enum userRole {
  2.   children
  3.   curator
  4.   mentor
  5.   psychologist
  6. }
  7.  
  8. Enum city {
  9.   stPeter
  10.   moscow
  11. }
  12.  
  13. Enum messageType {
  14.   user
  15.   system
  16. }
  17.  
  18. Enum studyPlace {
  19.   school1
  20.   school2
  21. }
  22.  
  23. Enum interest {
  24.   gaming
  25.   walkin
  26. }
  27.  
  28. Enum childrenReportType {
  29.   complaint
  30.   praise
  31. }
  32.  
  33. Enum userState {
  34.   notConfirmed
  35.   active
  36.   blocked
  37.   deleted
  38. }
  39.  
  40. Enum tokenType {
  41.   confirm
  42.   inviteMentor
  43.   invitePsychologist
  44.   inviteCurator
  45. }
  46.  
  47. Enum meetingState {
  48.   planned
  49.   canceled
  50.   done
  51. }
  52.  
  53. Table users as U {
  54.   id objectId
  55.   role userRole
  56.   email string
  57.   firstName string
  58.   lastName string
  59.   city city
  60.   age number
  61.   sex boolean
  62.   password string
  63.   about string
  64.   state userState
  65. }
  66.  
  67. Table childrens as C {
  68.   id objectId
  69.   user objectId [ref: > U.id]
  70.   studyPlace studyPlace
  71.   interests interest [note: "Array"]
  72.   curator objectId [ref: > CU.id]
  73. }
  74.  
  75. Table curator as CU {
  76.   id objectId [ref: > U.id]
  77.   user objectId
  78.  
  79. }
  80.  
  81. Table mentor as M {
  82.   id objectId
  83.   user objectId [ref: > U.id]
  84.   attachedChildrens objectId [ref: > C.id, note: "Array"]
  85. }
  86.  
  87. Table psychologist as P {
  88.   id objectId
  89.   user objectId [ref: > U.id]
  90. }
  91.  
  92. Table userTokens as T {
  93.   id objectId
  94.   user objectId [ref: > U.id]
  95.   token string
  96.   type tokenType
  97.   dieTime date
  98. }
  99.  
  100. Table messages as M {
  101.   id objectId
  102.   from objectId [ref: > U.id]
  103.   to objectId [ref: > U.id]
  104.   message string
  105.   image string
  106.   type messageType
  107.   timestamp number
  108. }
  109.  
  110. Table curatorReport as R {
  111.   id objectId
  112.   curator objectId [ref: > CU.id]
  113.   children objectId [ref: > C.id]
  114.   report string
  115.   timestamp number
  116.   images string [note:"Array"]
  117. }
  118.  
  119. Table consulation as CO {
  120.   id objectId
  121.   children objectId [ref: > C.id]
  122.   psychologist objectId [ref: > P.id]
  123.   timestamp number
  124.   recomendations string
  125. }
  126.  
  127. Table meeting {
  128.   id objectId
  129.   curator objectId [ref: > CU.id]
  130.   children objectId [ref: > C.id]
  131.   latitude number
  132.   longitude number
  133.   cancelReason string
  134.   state meetingState
  135.   timestamp number
  136. }
  137.  
  138. Table childrenReport {
  139.   id objectId
  140.   children objectId [ref: > C.id]
  141.   curator objectId [ref: > CU.id]
  142.   reportType childrenReportType
  143.   report string
  144. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement