news-feed-erd

Tables (3)

board (Untitled2)

  • id (Key) — BIGINT(20) — Primary key — NOT NULL
  • title (Field) — VARCHAR(255)
  • content (Field2) — VARCHAR(255)
  • username (Field3) — VARCHAR(255)
  • created_at (Field4) — DATETIME(6)
  • modified_at (Field5) — DATETIME(6)
  • writer (Key2) — VARCHAR(255) — Foreign key → member.id — NOT NULL

comment (Untitled3)

  • id (Key) — BIGINT(20) — Primary key — NOT NULL
  • content (Field) — VARCHAR(255)
  • writer (Field2) — VARCHAR(255)
  • created_at (Field3) — DATETIME(6)
  • modified_at (Field4) — DATETIME(6)
  • boardId (Key2) — BIGINT(20) — Foreign key → board.id — NOT NULL

member (Untitled)

  • id (Key) — BIGINT(20) — Primary key — NOT NULL
  • password (Field) — VARCHAR(255)
  • email (Field2) — VARCHAR(255)
  • username (Field3) — VARCHAR(255)