omolle ERD
Tables (6)
BLEAddresses
- id — int — Primary key — NOT NULL
- ex_id — varchar(16) — Foreign key → ExInfos.ex_id — NOT NULL
- mac_address — varchar(32) — NOT NULL
ExHistories
- id — bigint — Primary key — NOT NULL
- user_name — varchar(32) — Foreign key → UserProfiles.user_name — NOT NULL
- ex_id — varchar(16) — Foreign key → ExInfos.ex_id — NOT NULL
- gym_code (gym_code2) — varchar(16) — Foreign key → 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
ExInfos
- ex_id — varchar(16) — Primary key — NOT NULL
- gym_code — varchar(16) — Foreign key → 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) — Primary key — 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) — Primary key — 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) — Primary key — NOT NULL — email kakao id
- user_name — varchar(32) — Foreign key → 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