spring_advanced_board-ERD

Tables (4)

board

  • id — BIGINT — Primary key
  • name — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255)
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • Field — VARCHAR(20)

comment

  • id — BIGINT — Primary key
  • post_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • status — VARCHAR(20)
  • id (id2) — BIGINT — Foreign key → user.id — NOT NULL
  • id (id3) — BIGINT — Foreign key → post.id

post

  • id — BIGINT — Primary key
  • board_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • status — VARCHAR(20)
  • id (id2) — BIGINT — Foreign key → user.id — NOT NULL
  • board_id (id3) — BIGINT — Foreign key → board.id

user

  • id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • role — VARCHAR(50) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL