JJelly

Tables (3)

Challenge (Untitled3)

  • Key (routineId) — uuid — Foreign key → Routine.Key — NOT NULL
  • Field (challengeId) — uuid
  • Field (isPublic) — boolean
  • Field (challengePeriod) — Enum
  • Field (challengeStartDate) — Date
  • Field (challengeEndDate) — Date
  • Field (participatedDates) — String

Routine (Untitled2)

  • Key (routineId) — uuid — Primary key — NOT NULL
  • Field (routineName) — String(10)
  • Field (routineDescription) — String(50)
  • Field (routineTemplateType) — Enum
  • Field (routineList) — json
  • Field (routineLevel) — number
  • Field (category) — Enum
  • Field (tag) — String
  • Field (isPublic) — boolean
  • Field (challengePeriod) — Enum
  • Field (viewCount) — Number
  • Field (bookmackCount) — Number
  • Field (isBookmark) — boolean
  • Field (particcipationCount) — number

User (Untitled)

  • Key (id) — uuid — Primary key — NOT NULL
  • Key (routineId) — uuid — Foreign key → Routine.Key — NOT NULL
  • userId (Field) — String(10)
  • userPassword (Field2) — String(20)
  • nickName (Field3) — String(10)
  • profileImageType (Field4) — Enum
  • memberGrade (Field5) — Enum
  • myRoutine (Field6) — uuid