점메추 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