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