tenten

Tables (4)

Category (카테고리)

  • RoutineId (FK) — int — Foreign key → MyRoutine.RoutineId — NOT NULL
  • dailyRecordId (FK2) — int — Foreign key → DailyRecord.dailyRecordId — NOT NULL
  • arm (팔) — boolean — NOT NULL
  • leg (하체) — boolean — NOT NULL
  • back (등) — boolean — NOT NULL
  • chest (가슴) — boolean — NOT NULL
  • shoulder (어깨) — boolean — NOT NULL

DailyRecord (일일기록)

  • dailyRecordId (PK) — int — Primary key — NOT NULL
  • userKey (FK) — Long — Foreign key → User.userKey — NOT NULL
  • year (년도(YYYY)) — DATE — NOT NULL
  • month (월(MM)) — DATE — NOT NULL
  • day (일(DD)) — DATE — NOT NULL
  • types (운동종류) — int — NOT NULL
  • totalWeightOfType (해당운동의총무게(kg)) — double — NOT NULL
  • totalSetsOfType (해당운동의총세트수) — int — NOT NULL
  • sets (세트수) — int — NOT NULL
  • reps (반복횟수) — int — NOT NULL
  • weight (무게) — double — NOT NULL
  • totalWeightOfDay (해당날의총무게(kg)) — double — NOT NULL

MyRoutine (나의루틴)

  • RoutineId (PK) — int — Primary key — NOT NULL
  • userKey (FK) — Long — Foreign key → User.userKey — NOT NULL
  • routineName (루틴명) — VARCHAR(30) — NOT NULL
  • totalWeightOfRoutine (루틴총무게(kg)) — double — NOT NULL
  • category (카테고리) — List<Category> — NOT NULL
  • types (운동종류) — int — NOT NULL
  • totalWeightOfType (해당운동의총무게(kg)) — double — NOT NULL
  • sets (세트수) — int — NOT NULL
  • reps (반복횟수) — int — NOT NULL
  • weight (무게(kg)) — double — NOT NULL

User (유저)

  • userKey (PK) — Long — Primary key — NOT NULL
  • userId (유저아이디) — VARCHAR(30) — NOT NULL
  • userTotalKg (유저누적무게(kg)) — double — NOT NULL