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