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