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