Push-Up Quest
Tables (3)
ExerciseRecord (Untitled2)
- recordId (Key) — Int — Primary key — NOT NULL
- userId (Key2) — Int — Foreign key → User.userId — NOT NULL
- exerciseDate (Field2) — DATE
- exerciseCount (Field3) — Int
- calories (Field4) — Int
- feedbackContent (Field) — VARCHAR(255)
RewardHistory (Untitled3)
- rewardId (Key) — Int — Primary key — NOT NULL
- userId (Key2) — Int — Foreign key → User.userId — NOT NULL
- rewardDate (Field) — DATE
- rewardType (Field2) — VARCHAR(50)
User (Untitled)
- userId (Key) — Int — Primary key — NOT NULL
- username (Field) — VARCHAR(50)
- password (Field2) — VARCHAR(50)
- email (Field3) — VARCHAR(100)
- joinDate (Field4) — DATE