Team-K
Tables (9)
BloodSugarData (혈당데이터)
- id (Key) — long — Primary key — NOT NULL
- device (장치) — varchar(32) — NOT NULL
- code (일련번호) — varchar(100)
- timestamp (타임스탬프) — timestamp
- record_type (기록 유형) — int
- bloodsugar (혈당) — int
- scan_bloodsugar (스캔시점의 혈당) — int
- created_at (생성일시) — timestamp
- updated_at (수정일시) — timestamp
Code (일련번호)
- Key — long — Primary key — NOT NULL
- pet_id (반려동물 id) — long — Foreign key → Pet.id — NOT NULL
- device_code (장치 일련번호) — varchar(32)
Feedback (피드백)
- id (Key) — Primary key — NOT NULL
- content (내용) — varchar(1000)
- created_at (생성일시) — timestamp
- updated_at (수정일시) — timestamp
- is_deleted (삭제여부) — timestamp
- user_id (유저 아이디) — User — Foreign key → User.id — NOT NULL
Meat (육류)
- id (Key) — long — Primary key — NOT NULL
- name (이름) — varchar(32)
- created_at (생성일시) — timestamp
- updated_at (수정일시) — timestamp
- is_deleted (삭제 여부) — timestamp
MixedFeed (맞춤 사료)
- id (Key5) — long — Primary key — NOT NULL
- meat_id (육류 아이디) — int — Foreign key → Meat.id — NOT NULL
- oil_id (지방 아이디) — int — Foreign key → Oil.id — NOT NULL
- supplement_id (영양제 아이디) — int — Foreign key → Supplement.id — NOT NULL
- pet_id (반려동물 아이디) — int — Foreign key → Pet.id — NOT NULL
- created_at (생성일시) — timestamp
- updated_at (수정일시) — timestamp
- is_deleted (삭제 여부) — timestamp
Oil (지방)
- id (Key) — long — Primary key — NOT NULL
- name (이름) — varchar(32)
- created_at (생성일시) — timestamp
- updated_at (수정일시) — timestamp
- is_deleted (삭제 여부) — timestamp
Pet (반려동물)
- id (Key) — long — Primary key — NOT NULL
- name (이름) — varchar(10)
- age (나이) — int
- speicies (종) — varchar(100)
- gender (성별) — enum
- weight (몸무게) — int
- started_date (센서 착용 시작일자) — timestamp
- feed (먹은 사료) — varchar(100)
- sore_spot (아픈 부위) — varchar(10)
- profile_url (프로필 사진) — url
- user_id (유저 아이디) — User — Foreign key → User.id — NOT NULL
- created_at (생성일시) — timestamp
- updated_at (수정일시) — timestamp
- is_deleted (삭제 여부) — boolean
Supplement (보조 영양제)
- id (Key) — long — Primary key — NOT NULL
- name (이름) — varchar(32)
- created_at (생성일시) — timestamp
- updated_at (수정일시) — timestamp
- is_deleted (삭제 여부) — timestamp
User (유저)
- id (Key) — long — Primary key — NOT NULL
- name (이름) — varchar(15)
- email (이메일) — varchar(50)
- password (비밀번호) — smallint
- created_at (생성일시) — timestamp
- updated_at (수정일시) — timestamp
- is_deleted (삭제여부) — timestamp