회원

테이블 (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