반쪽이
테이블 (8)
Untitled (PET)
- Field (pet_id) — Long — 기본 키
- Field (user_id) — Long — 외래 키 → Untitled.Field
- Field (goal) — int
- Field (created_time) — timestamp
- Field (modified_time) — timestamp
Untitled (USER)
- Field (user_id) — Long — 기본 키
- Field (uuid) — VARCHAR()
- Field (nickname) — VARCHAR()
- Field (email) — VARCHAR()
- Field (password) — VARCHAR()
- Field (like) — int
- Field (created_time) — timestamp
- Field (modified_time) — timestamp
Untitled (APPOINTMENT)
- Field (appointment_id) — Long — 기본 키
- Field (pet_id) — Long — 외래 키 → Untitled.Field
- Field (type) — VARCHAR()
- Field (date) — timestamp
- Field (create_time) — timestamp
- Field (modified_time) — timestamp
Untitled (WALK)
- Field (walk_id) — Long — 기본 키
- Field (pet_id) — Long — 외래 키 → Untitled.Field
- Field (title) — VARCHAR()
- Field (amount) — int
- Field (created_time) — timestamp
- Field (modified_time) — timestamp
게시글 (POST)
- Field (post_id) — Long — 기본 키
- Field (user_id) — Long — 외래 키 → Untitled.Field
- Field (member_id) — Long
- Field (content) — text
- Field (like) — int
- Field (created_time) — timestamp
- Field (modified_time) — timestamp
댓글 (COMMENT)
- Field (comment_id) — Long — 기본 키
- Field (post_id) — Long — 외래 키 → 게시글.Field
- Field (user_id) — Long — 외래 키 → Untitled.Field
- Field (content) — text
- Field (created_time) — timestamp
- Field (modified_time) — timestamp
- Field (parent_id) — Long — 외래 키 → 댓글.Field
이미지 (IMAGE)
- Field (img_id) — Long — 기본 키
- Field (pet_id) — Long — 외래 키 → Untitled.Field
- Field (post_id) — Long — 외래 키 → 게시글.Field
- Field (dtype) — VARCHAR()
- Field (dtype_id) — Long
- Field (img_url) — VARCHAR()
- Field (created_time) — timestamp
- Field (modified_time) — timestamp
장소 (LOCATION)
- Field (location_id) — Long — 기본 키
- Field (user_id) — Long — 외래 키 → Untitled.Field
- Field (latitude) — Double
- Field (longitude) — Double
- Field (tag) — VARCHAR()
- Field (created_time) — timestamp
- Field (modified_time) — timestamp