CheckFit DB
테이블 (4)
Untitled (EXERCISE_RECORD_TB)
- Key (er_id) — INTEGER — 기본 키 — NOT NULL
- Field (er_date) — TEXT
- Field (er_start_date) — TEXT
- Field (er_round) — INTEGER
- Field (er_total_set) — INTEGER
- Field (er_total_weight) — REAL
- Field (er_total_time) — TEXT
- Field (er_smile_tag) — TEXT
- Field (er_total_memo) — TEXT
- Field (er_exercise_list) — TEXT
Untitled (EXERCISE_TB)
- Key (ex_id) — INTEGER — 기본 키 — NOT NULL
- Field (ex_name) — TEXT
- Field (ex_bodypart) — TEXT
- Field (ex_equipment) — TEXT
- Field (ex_weight_unit) — TEXT
- Field (ex_image_url) — TEXT
- Field (ex_total_set) — INTEGER
- Field (ex_total_weight) — REAL
- Field (ex_total_days) — INTEGER
- Field (ex_frequency) — INTEGER
- Field (ex_rest_time) — INTEGER
- Field (ex_favorite) — INTEGER
- Field (ex_type) — TEXT
Untitled (ROUTINE_TB)
- Key (ro_id) — INTEGER — 기본 키 — NOT NULL
- Field (ro_name) — TEXT
- Field (ro_info) — TEXT
- Field (ro_creation_date) — TEXT
- Field (ro_exercise_list) — TEXT
- Field (ro_favorite) — INTEGER
- Field (ro_used_count) — INTEGER
- Field (ro_latest_time) — TEXT
운동메모 (EXERCISE_MEMO_TB)
- Key (ex_id) — INTEGER — 기본 키 — NOT NULL
- Key (erim_write_time) — TEXT — 기본 키 — NOT NULL
- Key (ex_id2) — INTEGER — 외래 키 → Untitled.Key — NOT NULL
- Field2 (erim_title) — TEXT
- Field (erim_content) — TEXT