pet

테이블 (16)

로그 (Log)

  • id — bigint — 기본 키 — NOT NULL
  • datetime — datetime
  • type — json — type : 건강 수첩 카테고리 사료 = FEED 간식/영양제 = TREAT 산책 = WALK 건강 = HEALTH 위생/미용 = GROOMING 기타 = CUSTOM
  • created at (created_at) — datetime
  • modified at (modified_at) — datetime
  • is deleted (is_deleted) — bit
  • is important (is_important) — bit
  • is_complete — bit
  • memo — blob
  • manager id (manager_id) — varchar(100) — 외래 키 → 유저.id — NOT NULL
  • pet id (pet_id) — bigint — 외래 키 → 반려동물.id — NOT NULL

일기 (Diary)

  • id — bigint — 기본 키 — NOT NULL
  • title — varchar(255)
  • content (contents) — blob
  • date — date
  • modified at (modified_at) — datetime
  • created at (created_at) — datetime
  • is deleted (is_deleted) — bit
  • pet id (pet_id) — bigint — 외래 키 → 반려동물.id — NOT NULL
  • user id (user_id) — varchar(100) — 외래 키 → 유저.id — NOT NULL
  • thumbnail path (thumbnauil_path) — varchar(255)

Notifications

  • id — bigint — 기본 키 — NOT NULL
  • type — enum
  • subtype — enum
  • user_id — varchar(100)
  • pet_id — bigint
  • message — varchar(100)
  • status — bit 1

공동집사 (guardian)

  • id — bigint — 기본 키 — NOT NULL
  • pet id (pet_id) — bigint — 외래 키 → 반려동물.id — NOT NULL
  • userId (user_id) — varchar(100) — 외래 키 → 유저.id — NOT NULL
  • 멤버역할 (guardian_role)
  • 대표여부 (rep_status) — varchar(20)
  • created at (created_at) — datetime
  • modified at (modified_at) — datetime

구독 (Subscription)

  • id — bigint — 기본 키 — NOT NULL
  • created at (created_at) — datetime
  • modified at (modified_at) — datetime
  • user id (user_id) — varchar(100) — 외래 키 → 유저.id — NOT NULL
  • pet id (pet_id) — bigint — 외래 키 → 반려동물.id — NOT NULL

로그 장소 (Log Location)

  • id — bigint — 기본 키 — NOT NULL
  • created at (created_at) — datetime
  • modified at (modified_at) — datetime
  • log id (log_id) — bigint — 외래 키 → 로그.id — NOT NULL
  • type — enum
  • map_id — bigint

반려동물 (Pet)

  • id — bigint — 기본 키 — NOT NULL
  • userId (user_id) — varchar(100) — 외래 키 → 유저.id — NOT NULL
  • invite code (invite_code) — varchar(20)
  • name — varchar(100)
  • type (Type) — varchar(50)
  • breed(품종) (breed) — varchar(100)
  • gender — varchar(6)
  • is neutered (is_neutered) — boolean
  • birth — datetime
  • firstMeetDate (first_meet_date) — dateTime
  • 동물등록번호 (registered_number) — varchar(50)
  • XXX (rep_status) — varchar(20)
  • is deleted (is_deleted) — bit
  • created at (created_at) — datetime
  • modified at (modified_at) — datetime
  • weight — double

반려동물 이미지 (pet_image)

  • id — bigint — 기본 키 — NOT NULL
  • pet id (pet_id) — bigint — 외래 키 → 반려동물.id — NOT NULL
  • url
  • thumbnailUrl (thumbnail_url)

유저 (User)

  • id — varchar(100) — 기본 키 — NOT NULL
  • email — varchar(255)
  • nickname — varchar(20)
  • username — varchar(20)
  • password — varchar(255)
  • is deleted — bit
  • email_verified — bit
  • role
  • profile_path
  • created at (created_at) — datetime
  • modified at (modified_at) — datetime

일기 댓글 (Diary Comment)

  • id — bigint — 기본 키 — NOT NULL
  • content (contents) — blob
  • created at (created_at) — datetime
  • modified at (modified_at) — datetime
  • is deleted (is_deleted) — bit
  • diary id (diary_id) — bigint — 외래 키 → 일기.id — NOT NULL
  • user id (user_id) — varchar(100) — 외래 키 → 유저.id — NOT NULL
  • tagged users (tagged_users) — json

일기 댓글 이미지 (Diary Comment Image)

  • id — bigint — 기본 키 — NOT NULL
  • url — varchar(255)
  • thumbnail url (thumbnail_url) — varchar(255)
  • created at (created_at) — datetime
  • modified at (modified_at) — datetime
  • diary comment id (diary_commint_id) — bigint — 외래 키 → 일기 댓글.id — NOT NULL

일기 댓글 좋아요 (Diary Comment Like)

  • post id (post_id) — string
  • user id (user_id) — string

일기 미디어 (Diary Media)

  • id — bigint — 기본 키 — NOT NULL
  • path — varchar(255)
  • created at (created_at) — datetime
  • modified at (modified_at) — datetime
  • diary id (diary_id) — bigint — 외래 키 → 일기.id — NOT NULL
  • type — varchar(5) — 미디어 타입 VIDEO IMAGE

일기 좋아요 (Diary Like)

  • post id (post_id) — string
  • user id (user_id) — string

초대 (invitation)

  • id — bigint — 기본 키 — NOT NULL
  • petId (pet_id) — bigint — 외래 키 → 반려동물.id — NOT NULL
  • inviteCode (invite_code) — varchar(20)
  • inviteStatus — varchar(20)
  • created at — datetime
  • modified at — datetime
  • invitee_id — varchar(100)
  • inviter_id — varchar(100)

프로필이미지 (profile_image)

  • id — bigint — 기본 키 — NOT NULL
  • userId (user_id) — varchar(100) — 외래 키 → 유저.id — NOT NULL
  • url
  • thumbnailUrl (thumbnail_url)