게시판 ERD AI 활용

테이블 (4)

boards

  • board_id — SERIAL
  • board_name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP

comments

  • comment_id — SERIAL
  • post_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

posts

  • post_id — SERIAL
  • board_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

users

  • user_id — SERIAL
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP