반쪽이

테이블 (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