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