Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Enum userRole {
- children
- curator
- mentor
- psychologist
- }
- Enum city {
- stPeter
- moscow
- }
- Enum messageType {
- user
- system
- }
- Enum studyPlace {
- school1
- school2
- }
- Enum interest {
- gaming
- walkin
- }
- Enum childrenReportType {
- complaint
- praise
- }
- Enum userState {
- notConfirmed
- active
- blocked
- deleted
- }
- Enum tokenType {
- confirm
- inviteMentor
- invitePsychologist
- inviteCurator
- }
- Enum meetingState {
- planned
- canceled
- done
- }
- Table users as U {
- id objectId
- role userRole
- email string
- firstName string
- lastName string
- city city
- age number
- sex boolean
- password string
- about string
- state userState
- }
- Table childrens as C {
- id objectId
- user objectId [ref: > U.id]
- studyPlace studyPlace
- interests interest [note: "Array"]
- curator objectId [ref: > CU.id]
- }
- Table curator as CU {
- id objectId [ref: > U.id]
- user objectId
- }
- Table mentor as M {
- id objectId
- user objectId [ref: > U.id]
- attachedChildrens objectId [ref: > C.id, note: "Array"]
- }
- Table psychologist as P {
- id objectId
- user objectId [ref: > U.id]
- }
- Table userTokens as T {
- id objectId
- user objectId [ref: > U.id]
- token string
- type tokenType
- dieTime date
- }
- Table messages as M {
- id objectId
- from objectId [ref: > U.id]
- to objectId [ref: > U.id]
- message string
- image string
- type messageType
- timestamp number
- }
- Table curatorReport as R {
- id objectId
- curator objectId [ref: > CU.id]
- children objectId [ref: > C.id]
- report string
- timestamp number
- images string [note:"Array"]
- }
- Table consulation as CO {
- id objectId
- children objectId [ref: > C.id]
- psychologist objectId [ref: > P.id]
- timestamp number
- recomendations string
- }
- Table meeting {
- id objectId
- curator objectId [ref: > CU.id]
- children objectId [ref: > C.id]
- latitude number
- longitude number
- cancelReason string
- state meetingState
- timestamp number
- }
- Table childrenReport {
- id objectId
- children objectId [ref: > C.id]
- curator objectId [ref: > CU.id]
- reportType childrenReportType
- report string
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement