TogeDog

Tables (15)

AGREEMENT (약관 동의)

  • member_id (회원ID) — INT — Foreign key → MEMBER.member_id — NOT NULL
  • location (위치 정보) — BOOLEAN
  • notification (알림) — BOOLEAN
  • pairing (기기 연결) — BOOLEAN
  • camera (카메라) — BOOLEAN

ALERT (알림)

  • alert_id (알림ID) — INT — Primary key — NOT NULL
  • member_id (회원ID) — INT — Foreign key → MEMBER.member_id — NOT NULL
  • pet_id (반려견ID) — INT — Foreign key → PET.pet_id — NOT NULL
  • alert_type (알림유형) — VARCHAR(50)
  • alert_content (알림내용) — TEXT
  • delivery_method (알림방식) — VARCHAR(30)
  • is_checked (확인여부) — BOOLEAN
  • sent_at (발송시간) — DATETIME

ALERT_TYPE (알림 유형)

  • setting_id (설정ID) — INT — Primary key — NOT NULL
  • member_id (회원ID) — INT — Foreign key → MEMBER.member_id — NOT NULL
  • guide_mode (안내모드) — VARCHAR(30)
  • voice_enabled (음성사용여부) — BOOLEAN
  • vibration_enabled (진동사용여부) — BOOLEAN
  • text_enabled (텍스트사용여부) — BOOLEAN

BEHAVIOR_DATA (행동데이터)

  • behavior_id (행동데이터ID) — INT — Primary key — NOT NULL
  • pet_id (반려견ID) — INT — Foreign key → PET.pet_id — NOT NULL
  • behavior_type (행동유형) — VARCHAR(50)
  • is_abnormal (이상여부) — BOOLEAN
  • analysis_result (분석결과) — TEXT
  • measured_at (측정시간) — DATETIME

BIO_DATA (생체데이터)

  • bio_id (생체데이터ID) — INT — Primary key — NOT NULL
  • pet_id (반려견ID) — INT — Foreign key → PET.pet_id — NOT NULL
  • heart_rate (심박수) — INT
  • activity_level (활동량) — INT
  • measured_at (측정시간) — DATETIME

DAILY_REPORT (데일리리포트)

  • report_id (리포트ID) — INT — Primary key — NOT NULL
  • pet_id (반려견ID) — INT — Foreign key → PET.pet_id — NOT NULL
  • report_date (리포트일자) — DATE
  • health_summary (건강요약) — TEXT
  • behavior_summary (행동요약) — TEXT
  • abnormal_sign (이상징후) — TEXT

DANGER_DETECTION (위험감지)

  • danger_id (위험ID) — INT — Primary key — NOT NULL
  • walk_id (산책ID) — INT — Foreign key → WALK_RECORD.walk_id — NOT NULL
  • pet_id (반려견ID) — INT — Foreign key → PET.pet_id — NOT NULL
  • danger_type (위험유형) — VARCHAR(50)
  • danger_level (위험등급) — VARCHAR(20)
  • detected_at (감지시간) — DATETIME

MEMBER (회원(ThinQ + Togedog))

  • member_id (회원ID) — INT — Primary key — NOT NULL
  • name (이름) — VARCHAR(50)
  • email (이메일) — VARCHAR(100)
  • password (비밀번호) — VARCHAR(255)
  • phone (연락처) — VARCHAR(20)
  • guide_mode (안내 방식) — VARCHAR(30)
  • created_at (가입일) — DATETIME

MY_PAGE (마이페이지)

  • member_id (회원ID) — INT — Foreign key → MEMBER.member_id — NOT NULL

NAVIGATION_GUIDE (이동안내)

  • guide_id (안내ID) — INT — Primary key — NOT NULL
  • walk_id (산책ID) — INT — Foreign key → WALK_RECORD.walk_id — NOT NULL
  • guide_mode (안내방식) — VARCHAR(50)
  • guide_content (안내내용) — TEXT
  • delivery_method (제공방식) — VARCHAR(30)
  • provided_at (제공시간) — DATETIME

PET (반려견)

  • pet_id (반려견ID) — INT — Primary key — NOT NULL
  • member_id (회원ID) — INT — Foreign key → MEMBER.member_id — NOT NULL
  • name (이름) — VARCHAR(50)
  • breed (견종) — VARCHAR(50)
  • gender (성별) — VARCHAR(10)
  • birth_date (생년월일) — DATE
  • note (특이사항) — TEXT
  • neutring (중성화) — BOOLEAN

TOGEDOG_MEMBER (TogeDog전용 회원)

  • guide_mode (안내 방식) — VARCHAR(30)
  • agreement (약관동의)

ThinQ_ MEMBER (CopyOf회원(ThinQ 뇌피셜))

  • member_id (회원ID) — INT — Primary key — NOT NULL
  • name (이름) — VARCHAR(50)
  • email (이메일) — VARCHAR(100)
  • password (비밀번호) — VARCHAR(255)
  • phone (연락처) — VARCHAR(20)
  • created_at (가입일) — DATETIME

WALK_RECORD (산책기록)

  • walk_id (산책ID) — INT — Primary key — NOT NULL
  • member_id (회원ID) — INT — Foreign key → MEMBER.member_id — NOT NULL
  • pet_id (반려견ID) — INT — Foreign key → PET.pet_id — NOT NULL
  • started_at (시작시간) — DATETIME
  • ended_at (종료시간) — DATETIME
  • walk_status (산책상태) — VARCHAR(30)

WEARABLE_DEVICE (웨어러블 디바이스)

  • device_id (기기ID) — INT — Primary key — NOT NULL
  • pet_id (반려견ID) — INT — Foreign key → PET.pet_id — NOT NULL
  • device_name (기기명) — VARCHAR(100)
  • connection_status (연결상태) — VARCHAR(30)
  • battery_level (배터리잔량) — INT
  • last_sync_at (마지막동기화시간) — DATETIME