test
Tables (8)
Date Routine Record (Untitled7)
Exercise Item (Untitled4)
- id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar
Exercise Record (Untitled5)
- id (Key) — int — Primary key — NOT NULL
- set_no (Field) — int
- repeat (Field2) — int
- weight (Field3) — int
- id (Key2) — int — Foreign key → Exercise Item.id — NOT NULL
Exercise Routine (Untitled2)
- id (Key) — int — Primary key — NOT NULL
- id (Key2) — int — Foreign key → User.id — NOT NULL
- name (Field) — varchar
- start_date (Field2) — date
- end_date (Field3) — date
Exercise Standard (Untitled3)
- id (Key) — int — Primary key — NOT NULL
- max_set (Field) — int
- max_repeat (Field2) — int
- weight (Field3) — int
- id (Key2) — int — Foreign key → Exercise Item.id — NOT NULL
Routine Record (Untitled8)
- id (Key) — int — Foreign key → Exercise Routine.id — NOT NULL
- id (Key2) — int — Foreign key → Exercise Routine.id — NOT NULL
- id (Key3) — int — Foreign key → Exercise Record.id — NOT NULL
Routine Standard (Untitled6)
- id (Key) — int — Foreign key → Exercise Routine.id — NOT NULL
- id (Key2) — int — Foreign key → Exercise Standard.id — NOT NULL
- id (Key22) — int — Foreign key → Exercise Routine.id — NOT NULL
User (Untitled)
- id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar