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

Untitled