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