점메추 ERD
테이블 (3)
Comment (Untitled3)
- comment_id (Key) — Id — 기본 키 — NOT NULL
- post_id (Key2) — Id — 외래 키 → Post.post_id — NOT NULL
- user_id (Key3) — Id — 외래 키 → User.user_id — NOT NULL
- content (Field2) — String
- createdAt (Field3) — LocalDateTime
- modifiedAt (Field4) — LocalDateTime
- like (Field5) — Integer
Post (Untitled2)
- post_id (Key) — Id — 기본 키 — NOT NULL
- user_id (Key2) — Id — 외래 키 → User.user_id — NOT NULL
- content (Field) — String
- title (Field2) — String
- createdAt (Field3) — LocalDateTime
- modifiedAt (Field4) — LocalDateTime
- like (Field5) — Integer
- multimedia (Field6) — String(link)
User (Untitled)
- user_id (Key) — Id — 기본 키 — NOT NULL
- username (Field) — String
- introduction (Field2) — String
- password (Field3) — String
- email (Field4) — Email
- photo (Field5) — String
- follow (Field6) — Folder