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