Omolle ERD 수정

테이블 (6)

BLEAddresses

  • id — int — 기본 키 — NOT NULL
  • ex_id — varchar(16) — 외래 키 → ExInfos.ex_id — NOT NULL
  • mac_address — varchar(32) — NOT NULL

ExHistories

  • id — bigint — 기본 키 — NOT NULL
  • user_name — varchar(32) — 외래 키 → UserProfiles.user_name — NOT NULL
  • ex_id — varchar(16) — 외래 키 → ExInfos.ex_id — NOT NULL
  • gym_code (gym_code2) — varchar(16) — 외래 키 → ExInfos.gym_code — NOT NULL
  • start_date — datetime — NOT NULL
  • end_date — datetime — NOT NULL
  • weight — float
  • set_count — int
  • ex_count — int
  • training_volume — bigint
  • ex_data — MEDIUMTEXT
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • Field (calorie) — bigint

ExInfos

  • ex_id — varchar(16) — 기본 키 — NOT NULL
  • gym_code — varchar(16) — 외래 키 → Gyms.gym_code — NOT NULL
  • ex_name — varchar(128)
  • ex_code — varchar(8) — NOT NULL
  • ex_kor_name — varchar(128)
  • ex_part — varchar(32)

Gyms

  • gym_code — varchar(16) — 기본 키 — NOT NULL
  • gym_name — varchar(64) — NOT NULL
  • location — varchar(32) — NOT NULL
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL

UserProfiles

  • user_name — varchar(32) — 기본 키 — NOT NULL
  • birth — vachar(16)
  • height — float
  • weight — float
  • image — LONGTEXT
  • gender — varchar(8)
  • mobile — varchar(16)
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL

Users

  • user_id — varchar(64) — 기본 키 — NOT NULL — email kakao id
  • user_name — varchar(32) — 외래 키 → UserProfiles.user_name — NOT NULL
  • password — varchar(128)
  • is_email — tinyint — NOT NULL
  • update_pw_date — datetime — NOT NULL
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • Field (is_auth) — tinyint — NOT NULL
  • Field (is_deleted) — tinyint — NOT NULL