ssu-ai

테이블 (4)

게시글 (post)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (board_id) — bigint — NOT NULL
  • Field (title)
  • Field (content)
  • Field (category_id)
  • Field (view_count)
  • Field (created_at)
  • Field2 (updated_at)
  • Field

게시판 (boards)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar(255) — NOT NULL
  • Field (created_at) — datetime(6) — NOT NULL

사용자 (users)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (username) — varchar(255) — NOT NULL
  • Field (password) — varchar(255) — NOT NULL
  • Field (name) — varchar(255) — NOT NULL
  • Field (role) — enum — NOT NULL
  • Field (refresh_token) — varchar(255) — NOT NULL
  • Field (created_at) — datetime(6) — NOT NULL
  • Field (updated_at) — datetime(6) — NOT NULL

첨부파일 (files)

  • Key (id) — 기본 키 — NOT NULL
  • Field (post_id)
  • Field2 (original_file_name)
  • Field (stored_file_name)
  • Field (file_path)
  • Field (file_size)
  • Field (content_type)
  • Field (created_at)