@startuml

!include db_styling.puml

package "Fitness app" <<Frame>> {
    entity "Training" as training_table {
        PRIMARY_KEY(id): INTEGER
        ---
        date : DATETIME
        tariner: ENUM
    }

    entity "Exercise" as exercise_table {
        PRIMARY_KEY(id): INTEGER
        ---
        FOREIGN_KEY(training_id): INTEGER
        name: VARCHAR(300)
    }

    entity "Approach" as approach_table {
        PRIMARY_KEY(id): INTEGER
        ---
        FOREIGN_KEY(exercise_id): INTEGER
        weight: REAL
        reps: INTEGER
        splitted_weight: BOOL
    }

    ' Monthly Fitness Log table
    entity "MonthlyLog" as monthly_log {
        PRIMARY_KEY(id) : INTEGER
        --
        FOREIGN_KEY(activity_id) : INTEGER
        month_name : VARCHAR(20)
        duration : TIME
        distance : DECIMAL(6,2)
    }

    entity "CardioActivity" as cardio_activity_table {
        PRIMARY_KEY(id) : INTEGER
        ---
        name : VARCHAR(255)
    }
}

approach_table }o--|| exercise_table 
exercise_table }o--|| training_table 

monthly_log ||-|| cardio_activity_table

@enduml