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