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