bizmoim

Tables (20)

AppMeta (Untitled20)

  • badge (Field) — ObjectId()[]
  • pass (Field2) — ObjectId()[]
  • faq (Field3) — ObjectId()[]

Badge (Untitled13)

  • id (Key) — ObjectId() — Primary key — NOT NULL
  • name (Field) — string
  • color (Field2) — string
  • priority (Field3) — number

Faq (Untitled19)

  • id (Key) — ObjectId — Primary key — NOT NULL
  • title (Field) — string
  • content (Field2) — string

FreeBoard (Untitled10)

  • id (Key) — ObjectId() — Primary key — NOT NULL
  • isImportant (Field) — boolean
  • category (Field2) — string
  • title (Field3) — string
  • content (Field4) — string
  • author (Field5) — ObjectId()
  • comment (Field6) — string[]

FreeTicketLecture (Untitled8)

  • id (Key) — ObjectId() — Primary key — NOT NULL
  • name (Field) — string
  • mediaKey (Field2) — string
  • thumbnail (Field3) — string
  • disabled (Field4) — boolean

Homework (Untitled12)

  • id (Key) — ObjectId() — Primary key — NOT NULL
  • lectureId (Field2) — ObjectId()
  • lectureVideoId (Field) — ObjectId()
  • title (Field3) — string
  • content (Field4) — string
  • disabled (Field5) — boolean

HomeworkBoard (Untitled15)

  • id (Key) — ObjectId() — Primary key — NOT NULL
  • isImportant (Field) — boolean
  • homework (Field2) — ObjectId()
  • author (Field3) — ObjectId()

Inquiry (Untitled16)

  • id (Key) — ObjectId() — Primary key — NOT NULL
  • kind (Field) — ObjectId()
  • author (Field2) — string
  • phone (Field3) — string
  • content (Field4) — string
  • typeOfBusiness (Field5) — string
  • career (Field6) — string
  • salesMethod (Field7) — string

InquiryKind (Untitled17)

  • id (Key) — ObjectId() — Primary key — NOT NULL
  • disabled (Field) — boolean
  • name (Field2) — string

LectureCategory (Untitled4)

  • id (Key) — ObjectId() — Primary key — NOT NULL
  • name (Field) — string
  • type (Field2) — 'ONLINE' | 'REGULAR'
  • disabled (Field3) — boolean

LectureTag (Untitled5)

  • id (Key) — ObjectId() — Primary key — NOT NULL
  • name (Field) — string

LectureVideo (Untitled2)

  • id (Key) — objectId() — Primary key — NOT NULL
  • name (Field) — string
  • homework (Field2) — ObjectId()[]
  • mediaKey (Field3) — string
  • thumbnail (Field4) — string
  • playtime (Field5) — string
  • pdfList (Field6) — S3File[]

Notice (Untitled18)

  • id (Key) — ObjectId() — Primary key — NOT NULL
  • isImportant (Field) — boolean
  • title (Field2) — string
  • content (Field3) — string
  • author (Field4) — ObjectId()

OfflineLecture (Untitled6)

  • id (Key) — ObjectId() — Primary key — NOT NULL
  • name (Field) — string
  • description (Field2) — string
  • thumbnail (Field9) — string
  • reservationAt (Field4) — string
  • reservationExpireAt (Field3) — string
  • limit (Field5) — number
  • count (Field10) — number
  • pirce (Field6) — number
  • salePrice (Field7) — number
  • disabled (Field8) — boolean
  • startedAt (Field11) — string
  • endedAt (Field12) — string
  • place (Field13) — string

OnlineLecture (Untitled3)

  • id (Key) — ObjectId() — Primary key — NOT NULL
  • type (Field) — 'ONLINE' | 'REGULAR'
  • name (Field2) — string
  • introduce (Field7) — string
  • thumbnail (Field4) — string
  • categoryList (Field5) — ObjectId()[]
  • accessAblePassList (Field6) — string[]
  • tagList (Field12) — string[]
  • videoList (Field8) — ObjectId()[]
  • price (Field9) — number
  • salePrice (Field10) — undefined | number
  • disabled (Field11) — boolean
  • expirationPeriod (Field3) — number

Pass (Untitled14)

  • id (Key) — ObjectId() — Primary key — NOT NULL
  • name (Field) — string
  • color (Field2) — string
  • priority (Field3) — number

Review (Untitled7)

  • id (Key) — ObjectId() — Primary key — NOT NULL
  • isImportant (Field6) — boolean
  • flag (Field4) — string
  • type (Field) — 'ONLINE' | 'REGULAR' | 'CONSURTING' | 'STUDENT'
  • author (Field2) — ObjectId()
  • title (Field7) — string
  • content (Field3) — string
  • comment (Field5) — string[]

StudyBoard (Untitled11)

  • id (Key) — ObjectId() — Primary key — NOT NULL
  • isImportant (Field) — boolean
  • category (Field2) — undefined | string
  • title (Field3) — string
  • content (Field4) — string
  • author (Field5) — ObjectId()
  • comment (Field6) — string[]

User (Untitled)

  • id (Field) — ObjectId() — Primary key
  • type (Key) — 'NORMAL' | 'MANAGER' | 'ADMIN' — NOT NULL
  • name (Field2) — string
  • phone (Field3) — string
  • password (Field4) — string
  • email (Field5) — string
  • recommendationCode (Field6) — string
  • freeTicketCount (Field7) — number
  • loginMethod (Field9) — 'KAKAO' | 'NAVER' | 'GOOGLE'
  • kakaoKey (Field10) — undefined | string
  • naverKey (Field11) — undefined | string
  • googleKey (Field12) — undefined | string
  • marketingAgree (Field13) — boolean
  • managerId (Field8) — undefined | null | ObjectId()
  • badgeList (Field15) — string[]
  • passList (Field14) — undefined | ObjectId()[]
  • courseTicketList (Field16) — string[]
  • disabled (Field17) — boolean
  • memo (Field18) — string
  • isBlack (Field19) — undefined | boolean
  • managerExpireAt (Field20) — undefined | null | string

YoutubeLecture (Untitled9)

  • id (Key) — ObjectId() — Primary key — NOT NULL
  • name (Field) — string
  • yotubeLink (Field2) — string
  • disabled (Field3) — boolean