LostAndFound

Tables (5)

CATEGORY (Untitled4)

  • 카테고리id (category_id) — Long — Primary key — NOT NULL
  • 카테고리이름 (name) — String — NOT NULL

IMAGE (Untitled3)

  • 이미지id (image_id) — Long — Primary key — NOT NULL
  • 게시글id (post_id) — Long — Foreign key → POST.게시글id — NOT NULL
  • url — String — NOT NULL

MEMBER (Untitled)

  • 아이디 (member_id) — Long — Primary key — NOT NULL
  • 이메일 (email) — String — NOT NULL
  • 닉네임 (nickname) — String

POST (Untitled2)

  • 게시글id (post_id) — Long — Primary key — NOT NULL
  • 제목 (title) — String — NOT NULL
  • 설명 (description) — String
  • 장소 (location) — String
  • 아이디 (member_id) — Long — Foreign key → MEMBER.아이디 — NOT NULL
  • 게시물 유형 (lost_type) — Enum — NOT NULL
  • 찾음여부 (is_found) — Boolean — NOT NULL
  • CreateTime (create_time) — TimeStamp — NOT NULL

POSTCATEGORY (Untitled5)

  • 게시굴카테고리id (post_category_id) — Long — Primary key — NOT NULL
  • 게시글id (post_id) — Long — Foreign key → POST.게시글id — NOT NULL
  • 카테고리id (category_id) — Long — Foreign key → CATEGORY.카테고리id — NOT NULL