ERD
Tables (6)
Auth
- authId — BIGINT — Primary key — NOT NULL
- challengerId — BIGINT — Foreign key → Challenger.challengerId — NOT NULL
- authContents — VARCHAR
- authImageUrl — VARCHAR
- authVideoUrl — VARCHAR
- authStatus — ENUM("WAITING","DENIED","APPROVED")
- createdAt — DATETIME
- modifiedAt — DATETIME
Challenge
- challengeId — BIGINT — Primary key — NOT NULL
- title — VARCHAR
- category — VARCHAR
- description — VARCHAR
- startDate — DATETIME
- dueDate — DATETIME
- frequency — VARCHAR
- currentAttendance — BIGINT
- limitAttendance — BIGINT
- thumnailImageUrl — VARCHAR
- authExplanation — VARCHAR
Challenger
- challengerId — BIGINT — Primary key — NOT NULL
- challengeId — BIGINT — Foreign key → Challenge.challengeId — NOT NULL
- memberId — BIGINT — Foreign key → Member.memberId — NOT NULL
Character
- characterId — BIGINT — Primary key — NOT NULL
- memberId — BIGINT — Foreign key → Member.memberId — NOT NULL
- name — VARCHAR
- level — BIGINT
- point — BIGINT
Member
- memberId — BIGINT — Primary key — NOT NULL
- email — VARCHAR
- password — VARCHAR
- nickname — VARCHAR
- role — ENUM("USER","ADMIN")
- profileImageUrl — VARCHAR