db

Tables (23)

attendancerequests

  • id — ObjectId — Primary key — NOT NULL
  • confirmed — Int32
  • type — String
  • image — null
  • parent — String
  • phone — String
  • note — String
  • requestDateTime — Int32
  • date — Int32
  • createdAt — Date
  • updatedAt — Date
  • kid — ObjectId — Foreign key → schoolmembers.id — NOT NULL
  • teacher — ObjectId — Foreign key → schoolmembers.id — NOT NULL
  • class — ObjectId — Foreign key → classes.id — NOT NULL

bookmarks

  • id (Key) — ObjectId — Primary key — NOT NULL
  • title — String
  • bookmarkedTime — Int32
  • createdAt — Date
  • updatedAt — Date
  • member (id) — ObjectId — Foreign key → schoolmembers.id — NOT NULL
  • post (id2) — ObjectId — Foreign key → posts.id — NOT NULL

chatcontacts

  • id (Key) — ObjectId — Primary key — NOT NULL
  • type — String
  • lastActvity — Int32
  • status — Int32
  • title — String
  • members — ObjectId — Foreign key → schoolmembers.id — NOT NULL
  • school — ObjectId — Foreign key → schools.id — NOT NULL
  • class — ObjectId — Foreign key → classes.id — NOT NULL

chatmessages

  • id (Key) — ObjectId — Primary key — NOT NULL
  • type — String
  • receivedTime — Int32
  • seenTime — Int32
  • date — Int32
  • timestamp — Int32
  • content — String
  • createdAt — Date
  • updatedAt — Date
  • speaker (id) — ObjectId — Foreign key → schoolmembers.id — NOT NULL
  • chatContact (Key2) — ObjectId — Foreign key → chatcontacts.id — NOT NULL

cities

  • id (Key) — ObjectId — Primary key — NOT NULL
  • code — String
  • name — String
  • createdAt — Date
  • updatedAt — Date

classes

  • id (Key) — ObjectId — Primary key — NOT NULL
  • name — String
  • startDate — Int32
  • endDate — Int32
  • description — String
  • createdAt — Date
  • updatedAt — Date
  • school — ObjectId — Foreign key → schools.id — NOT NULL

comments

  • id — ObjectId — Primary key — NOT NULL
  • textContent — String
  • commentedTime — Int32
  • createdAt — Date
  • updatedAt — Date
  • post — ObjectId — Foreign key → posts.id — NOT NULL
  • member — ObjectId — Foreign key → schoolmembers.id — NOT NULL

districts

  • id (Key) — ObjectId — Primary key — NOT NULL
  • code — String
  • name — String
  • createdAt — Date
  • updatedAt — Date
  • city — ObjectId — Foreign key → cities.id — NOT NULL

i18ns

  • id (Key) — ObjectId — Primary key — NOT NULL
  • code (Field) — String
  • en (Field2) — String
  • kr (Field3) — String

images.chunks

  • id (Key) — ObjectId — Primary key — NOT NULL
  • n (Field) — Int32
  • bin (Field2) — Binary
  • id (Key2) — ObjectId — Foreign key → images.files.id — NOT NULL

images.files

  • id (Key) — ObjectId — Primary key — NOT NULL
  • length (Field) — Int32
  • chunkSize (Field2) — Int32
  • uploadDate (Field3) — Date
  • filename (Field4) — String
  • md5 (Field5) — String
  • contentType (Field6) — String
  • metadata (Field7) — object

likes

  • id (Key) — ObjectId — Primary key — NOT NULL
  • likedTime (Field) — Int32
  • createdAt — Date
  • updatedAt — Date
  • post — ObjectId — Foreign key → posts.id — NOT NULL
  • member — ObjectId — Foreign key → schoolmembers.id — NOT NULL

logintokens

  • id — ObjectId — Primary key — NOT NULL
  • value — String
  • app — String
  • createdAt — Date
  • updatedAt — Date
  • user (id2) — ObjectId — Foreign key → users.id — NOT NULL

medicalrequests

  • id — ObjectId — Primary key — NOT NULL
  • kid (id2) — ObjectId — Foreign key → schoolmembers.id — NOT NULL
  • confirmed — Int32
  • image (imgae) — String
  • note — String
  • requestDateTime — Int32
  • date — Int32
  • symptom — String
  • storageMethod — String
  • medicalType — String
  • dosage — String
  • schedule — String
  • personInCharge — String
  • createdAt — Date
  • updatedAt — Date

memberfamilycontacts

  • id — ObjectId — Primary key — NOT NULL
  • member (id2) — ObjectId — Foreign key → schoolmembers.id — NOT NULL
  • name — String
  • phone — String
  • createdAt — Date
  • updatedAt — Date

otp (Untitled2)

  • id (Key) — ObjectId — Primary key — NOT NULL
  • otpType (Field) — Int32
  • code (Field2) — String
  • createdAt (Field3) — Date
  • updatedAt (Field4) — Date
  • expires (Field5) — String
  • user (id) — ObjectId — Foreign key → users.id — NOT NULL

posts

  • id — ObjectId — Primary key — NOT NULL
  • postType — String
  • images — Array
  • attachments — Array
  • isImportant — Int32
  • isSchool — Int32
  • classes — Array
  • allowMembers — Array
  • likes — Int32
  • comments — Int32
  • textContent — String
  • title — String
  • publishTime — Int32
  • createdAt — Date
  • updatedAt — Date
  • school (id2) — ObjectId — Foreign key → schools.id — NOT NULL
  • author (id3) — ObjectId — Foreign key → schoolmembers.id — NOT NULL

roles

  • id — ObjectId — Primary key — NOT NULL
  • code — String
  • name — String
  • description — String
  • createdAt — Date
  • updatedAt — Date

schoolholidays

  • id — ObjectId — Primary key — NOT NULL
  • school (id2) — ObjectId — Foreign key → schools.id — NOT NULL
  • name — String
  • startDate — Int32
  • endDate — Int32
  • createdAt — Date
  • updatedAt — Date

schoolmembers

  • id — ObjectId — Primary key — NOT NULL
  • status — Int32
  • user (id2) — ObjectId — Foreign key → users.id — NOT NULL
  • role (id3) — ObjectId — Foreign key → schoolroles.id — NOT NULL
  • school (id4) — ObjectId — Foreign key → schools.id — NOT NULL
  • createdAt — Date
  • updatedAt — Date

schoolroles

  • id — ObjectId — Primary key — NOT NULL
  • code — String
  • name — String
  • description — String
  • createdAt — Date
  • updatedAt — Date
  • i18n — ObjectId — Foreign key → i18ns.id — NOT NULL

schools (Untitled)

  • id — ObjectId — Primary key — NOT NULL
  • name — String
  • phone — String
  • address — String
  • description — String
  • createdAt — Date
  • updatedAt — Date
  • city — ObjectId — Foreign key → cities.id — NOT NULL

users

  • id — ObjectId — Primary key — NOT NULL
  • role (id2) — ObjectId — Foreign key → roles.id — NOT NULL
  • avatar (Key) — ObjectId — Foreign key → images.files.id — NOT NULL
  • gender — Int32
  • activated — Int32
  • status — Int32
  • isSystem — Int32
  • username — String
  • password — String
  • firstname — String
  • lastname — String
  • email — String
  • phone — String
  • createdAt — Date
  • updatedAt — Date