ERD 명세서

테이블 (9)

Bookmark (Untitled7)

  • id (PK) — BIGINT — 기본 키 — NOT NULL
  • post_id (FK) — BIGINT — 외래 키 → Post.id — NOT NULL
  • user_id (FK2) — BIGINT — 외래 키 → User.id — NOT NULL
  • created_at (Field) — DATETIME
  • modified_at (Field2) — DATETIME

Comment (Untitled3)

  • id (PK) — BIGINT — 기본 키 — NOT NULL
  • post_id (FK) — BIGINT — 외래 키 → Post.id — NOT NULL
  • user_id (FK2) — BIGINT — 외래 키 → User.id — NOT NULL
  • content (Field) — VARCHAR
  • created_at (Field2) — DATETIME
  • modified_at (Field3) — DATETIME

Follow (Untitled6)

  • id (PK) — BIGINT — 기본 키 — NOT NULL
  • user_id (FK) — BIGINT — 외래 키 → User.id — NOT NULL
  • following_user_id (Field) — BIGINT

Hashtag (Untitled4)

  • id (PK) — BIGINT — 기본 키 — NOT NULL
  • post_id (FK) — BIGINT — 외래 키 → Post.user_id — NOT NULL
  • tag_name (Field) — VARCHAR
  • createdAt (Field2) — DATETIME
  • modifiedAt (Field3) — DATETIME

Hashtag (Untitled9)

  • id (PK) — BIGINT — 기본 키 — NOT NULL
  • name (Field) — VARCHAR

Like (Untitled5)

  • id (PK) — BIGINT — 기본 키 — NOT NULL
  • post_id (Key2) — BIGINT — 외래 키 → Post.user_id — NOT NULL
  • user_id (Key3) — BIGINT — 외래 키 → User.id — NOT NULL
  • created_at (Field) — DATETIME
  • modified_at (Field2) — DATETIME

Post (Untitled)

  • id (PK) — BIGINT — 기본 키 — NOT NULL
  • user_id (FK) — BIGINT — 외래 키 → User.id — NOT NULL
  • title (Field) — VARCHAR
  • content (Field2) — VARCHAR
  • created_at (Field3) — DateTime
  • modified_at (Field4) — DateTime
  • version (Field5) — BIGINT
  • likes_count (Field6) — BIGINT

PostHashtag (Untitled8)

  • id (PK) — BIGINT — 기본 키 — NOT NULL
  • post_id (FK) — BIGINT — 외래 키 → Post.id — NOT NULL
  • hashtag_id (FK2) — BIGINT — 외래 키 → Hashtag.id — NOT NULL
  • created_at (Field) — DATETIME
  • modified_at (Field2) — DATETIME

User (Untitled2)

  • id (PK) — BIGINT — 기본 키 — NOT NULL
  • name (Field) — VARCHAR
  • age (Field2) — INT
  • email (Field3) — VARCHAR
  • password (Field4) — VARCHAR
  • created_at (Field5) — DATETIMEe
  • modified_at (Field6) — DATETIME
  • is_usable (Field7) — BIT