calories

Tables (4)

Challenge (챌린지)

  • challengeId — Long — Primary key — NOT NULL
  • creatorId — Long — Foreign key → Members.userId — NOT NULL
  • goalType — VARCHAR
  • goalValue — Integer
  • startTime — DateTime
  • endTime — DateTime
  • description — VARCHAR
  • title — VARCHAR
  • isVisible — Boolean
  • exerciseType — ExerciseType

Members (사용자)

  • userId — Long — Primary key — NOT NULL
  • username — VARCHAR
  • password — VARCHAR
  • gender — VARCHAR
  • height — DOUBLE
  • weight — DOUBLE
  • nickname — VARCHAR
  • email — VARCHAR

Participants (멤버)

  • participantId — Long — Primary key — NOT NULL
  • userId — Long — Foreign key → Members.userId — NOT NULL
  • challengeId — Long — Foreign key → Challenge.challengeId — NOT NULL
  • myValue — Double
  • percent — Double
  • joinedAt — DateTime

Records (운동기록)

  • Key — Primary key — NOT NULL
  • userId — Long — Foreign key → Members.userId
  • startTime — DateTime
  • endTime — DateTime
  • exerciseType — VARCHAR
  • duration — DOUBLE
  • calories — DOUBLE
  • Field