mog

Tables (9)

Bios (Untitled2)

  • BioId (Key) — number — Primary key — NOT NULL
  • age (Field) — number(3)
  • gender (Field2) — number(1)
  • height (Field3) — number
  • weight (Field4) — number
  • muscleMass (Field5) — number
  • bodyFat (Field6) — number

Friend (Untitled7)

  • FriendId (Key2) — number — Primary key — NOT NULL
  • SocialId (Key) — number — Foreign key → Social.SocialId — NOT NULL

Posts (Untitled4)

  • postId (Key2) — number — Primary key — NOT NULL
  • Id (Key) — number — Foreign key → User.Id — NOT NULL
  • title (Field) — varchar
  • content (Field2) — varchar
  • image (Field3) — string
  • likes (Field4) — number
  • postDate (Field5) — Date
  • comment (Field6) — string

Record (Untitled8)

  • recordId (Key4) — number — Primary key — NOT NULL
  • routineId (Key) — number — Foreign key → Routine.routineId — NOT NULL
  • Id (Key2) — number — Foreign key → Routine.Id — NOT NULL
  • BioId (Key22) — number — Foreign key → Routine.BioId — NOT NULL
  • workoutId (Key3) — number — Foreign key → Routine.workoutId — NOT NULL
  • startTime (Field) — DateTime
  • endTime (Field2) — DateTime
  • muscleUsage (Field3) — Object
  • calories (Field4) — number
  • sets (Field5) — number
  • workoutCount (Field6) — number
  • workoutVolume (Field7) — number
  • workHour (Field8) — number

Routine (Untitled5)

  • routineId (Key) — number — Primary key — NOT NULL
  • Id (Key2) — number — Foreign key → User.Id — NOT NULL
  • BioId (Key22) — number — Foreign key → User.BioId — NOT NULL
  • workoutId (Key3) — number — Foreign key → Workout.workoutId — NOT NULL

SeparateWorkout (Untitled9)

  • sepWorkoutId (Key5) — number — Primary key — NOT NULL
  • recordId (Key4) — number — Foreign key → Record.recordId — NOT NULL
  • routineId (Key) — number — Foreign key → Record.routineId — NOT NULL
  • Id (Key2) — number — Foreign key → Record.Id — NOT NULL
  • BioId (Key22) — number — Foreign key → Record.BioId — NOT NULL
  • workoutId (Key3) — number — Foreign key → Record.workoutId — NOT NULL
  • sepWorkoutTime (Field) — number

Social (Untitled3)

  • SocialId (Key) — number — Primary key — NOT NULL

User (Untitled)

  • Id (Key) — number — Primary key — NOT NULL
  • BioId (Key2) — number — Foreign key → Bios.BioId — NOT NULL
  • name (Field) — char
  • regiDate (Field4) — DATE
  • SocialId (Key3) — number — Foreign key → Social.SocialId — NOT NULL

Workout (Untitled6)

  • workoutId (Key) — number — Primary key — NOT NULL
  • name (Field) — varchar
  • category (Field2) — varchar
  • machine (Field3) — varchar
  • instructions (Field4) — varchar
  • primaryMuscles (Field5) — varchar
  • secondaryMuscles (Field6) — varchar
  • imageUrl (Field7) — varchar