회원
테이블 (12)
Device (디바이스)
- id (device_id) — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → User.id — NOT NULL
- model_id — BIGINT — 외래 키 → Model.id — NOT NULL
- unique_id (device unique_id) — VARCHAR
- mac_id (device mac_id) — VARCHAR
- serial_code (device serial_code) — VARCHAR
- created_at (device created_at) — TIMESTAMP
- updated_at (device updated_at) — TIMESTAMP
FirmwareVersiohn (펌웨어 버전)
- id (version_id) — BIGINT — 기본 키 — NOT NULL
- version (firmware_version) — VARCHAR
- description (change feature description) — TEXT
- detail_description (detail info) — TEXT
- created_at (version created_at) — TIMESTAMP
- updated_at (version updated_at) — TIMESTAMP
- file_location (firmware storage location) — VARCHAR
- file_name — VARCHAR
LoginDeviceInfo (로그인 기기 정보)
- device_ip (access_device_ip) — VARCHAR
- device_os (access_device_os) — VARCHAR
- device_info (access_device_infomation) — VARCHAR
- last_access_time — TIMESTAMP
Model (모델)
- id (model_id) — BIGINT — 기본 키 — NOT NULL
- name (model_name) — VARCHAR
- version (model_version) — VARCHAR
- description (model description) — TEXT
- created_at (model created_at) — TIMESTAMP
- updated_at (model updated_at) — TIMESTAMP
SocialLogin (소셜로그인)
- user_id — BIGINT — 외래 키 → User.id — NOT NULL
- social_id (unique_social_id) — VARCHAR
- social_type (sign_up_social_type) — VARCHAR
- connected _at (connected_time) — TIMESTAMP
User (유저)
- id (user_id) — BIGINT — 기본 키 — NOT NULL
- email (user_email) — VARCHAR — NOT NULL
- password (user_password) — VARCHAR
- created_at (user_created_time) — TIMESTAMP
- is_email_valid (user_email_valid) — TINYINT
UserInfo (사용자 정보)
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → User.id — NOT NULL
- name (user_name) — VARCHAR
- gender (user_gender) — VARCHAR
- birthdate (user_birthdate) — VARCHAR
- relation (user_relation) — VARCHAR
- default_user (is_default_user) — TINYINT
- password_changed_at (user_password_change_date) — TIMESTAMP
- created_at (user_info_created_time) — TIMESTAMP
address (주소)
- user_id — BIGINT — 외래 키 → User.id — NOT NULL
- post_number — VARCHAR
- address (user_address) — VARCHAR
- address_detail — VARCHAR
- default_address (is_default_address) — TINYINT
- created_at (address_info_created_time) — TIMESTAMP
device_log (사용 기록)
- id (device_log_id) — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → User.id — NOT NULL
- created_at (log_created_at) — TIMESTAMP
- detail_data (log data) — JSON
hardware_version (하드웨어 버전)
- id (version _id) — BIGINT — 기본 키 — NOT NULL
- model_id — BIGINT — 외래 키 → Model.id — NOT NULL
- version (hardware_version) — VARCHAR
- description (change feature description) — TEXT
- detail_description (detail info) — TEXT
- created_at (version created_at) — TIMESTAMP
- updated_at (version updated_at) — TIMESTAMP
survey (설문)
- id (survey_id) — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → User.id — NOT NULL
- device_log_id — BIGINT — 외래 키 → device_log.id — NOT NULL
- before_pain (before pain) — INT
- after_pain — INT
- memo — TEXT
- premonitory_symptom (premonitory symptom) — JSON
- residual_symptoms (residual symptoms) — JSON
- pain_area (pain area) — JSON
- medication_taken (medication taken) — JSON
useable_version (사용가능 버전)
- id (useable_version_id) — BIGINT — 기본 키 — NOT NULL
- firmware_id (firmware version_id) — BIGINT — 외래 키 → FirmwareVersiohn.id — NOT NULL
- hardware_id (hardware version _id) — BIGINT — 외래 키 → hardware_version.id — NOT NULL
- model_id — BIGINT — 외래 키 → hardware_version.model_id — NOT NULL