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)