tamsam

Tables (10)

admin (Untitled3)

  • id (Key) — uuid — Foreign key → defualt.id — NOT NULL
  • email (Field) — string
  • p (Field2) — string
  • name (Field3) — string
  • phone (Field4) — string
  • level (Field5) — number

category (Untitled4)

  • id (Key) — number — Primary key — NOT NULL
  • createdAt (Field) — datetime
  • updateedAt (Field2) — datetime
  • deletedAt (Field3) — datetime
  • name (Field4) — string
  • depth (Field5) — number
  • parentId (Field6) — number
  • sequence (Field7) — number
  • imageId (Field8) — number
  • parent (Field9) — CategoryEntity
  • image (Field10) — ImageEntity
  • children (Field11) — CategoryEntity
  • id (Key2) — number — Foreign key → category.id — NOT NULL

content (Untitled5)

  • id (Key) — uuid — Foreign key → defualt.id — NOT NULL
  • title (Field) — string
  • description (Field2) — string
  • sequence (Field3) — number
  • categoryId (Field4) — number
  • imageId1 (Field5) — string
  • imageId2 (Field6) — string
  • questions (Field7) — QuestionEntity
  • category (Field8) — CategoryEntity
  • image1 (Field9) — ImageEntity
  • image2 (Field10) — ImageEntity
  • id (Key2) — number — Foreign key → category.id — NOT NULL

defualt (Untitled)

  • id (Key) — uuid — Primary key — NOT NULL
  • createdAt (Field) — datetime
  • updatedAt (Field2) — datetime
  • deletedAt (Field3) — datetime
  • memo (Field4) — varchar(nullable)

image (Untitled7)

  • id (Key) — uuid — Foreign key → defualt.id — NOT NULL
  • path (Field) — string
  • path480 (Field2) — string
  • id (Key2) — uuid — Foreign key → user.id — NOT NULL
  • id (Key3) — number — Foreign key → category.id — NOT NULL
  • id (Key4) — uuid — Foreign key → content.id — NOT NULL

question (Untitled8)

  • id (Key) — uuid — Foreign key → defualt.id — NOT NULL
  • Field16 — enum
  • q (Field) — string
  • s1 (Field2) — string
  • s2 (Field3) — string
  • s3 (Field4) — string
  • s4 (Field5) — string
  • a (Field6) — number
  • explain (Field7) — string
  • origin1 (Field8) — string
  • origin2 (Field9) — string
  • subjectId (Field10) — number
  • unitId (Field11) — number
  • contentId (Field12) — string
  • imageId (Field13) — string
  • content (Field14) — ContentEntity
  • image (Field15) — ImageEntity
  • id (Key2) — uuid — Foreign key → content.id — NOT NULL
  • id (Key3) — uuid — Foreign key → image.id — NOT NULL

quizset (Untitled2)

  • id (Key) — uuid — Foreign key → defualt.id — NOT NULL
  • cntQuestion (Field) — number
  • cntAnswered (Field2) — number
  • category2Id (Field3) — number
  • endedAt (Field4) — datetime
  • endCode (Field5) — enum
  • userId (Field6) — string
  • user (Field7) — UserEntity
  • id (Key2) — uuid — Foreign key → user.id — NOT NULL

user (Untitled9)

  • id (Key) — uuid — Foreign key → defualt.id — NOT NULL
  • email (Field) — string
  • p (Field2) — string
  • nickname (Field3) — string
  • phone (Field4) — string
  • socialProvider (Field5) — enum
  • socialId (Field6) — string
  • referrer (Field7) — string
  • lastLoginAt (Field8) — datetime
  • lastPwChangedAt (Field9) — datetime
  • studyStartDate (Field10) — datetime
  • profileImageId (Field11) — string
  • cntTodayQuestion (Field12) — number
  • cntTotalQuestion (Field13) — number
  • cntCorrectQuestion (Field14) — number
  • cntWrongQuestion (Field15) — number
  • profileImage (Field16) — ImageEntity

userLoginHistory (CopyOfUntitled6)

  • id (Key) — uuid — Foreign key → defualt.id — NOT NULL
  • userId (Field) — string
  • loginAt (Field2) — datetime
  • isAuto (Field7)
  • ip (Field3) — string
  • deviceOS (Field4) — string
  • deviceModel (Field5) — string
  • deviceVersion (Field6) — string

userLogoutHistory (Untitled6)

  • id (Key) — uuid — Foreign key → defualt.id — NOT NULL
  • userId (Field) — string
  • logoutAt (Field2) — datetime
  • ip (Field3) — string
  • deviceOS (Field4) — string
  • deviceModel (Field5) — string
  • deviceVersion (Field6) — string