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