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