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