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