ss

Tables (5)

BOARD

  • board_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → MEMBER.member_id — NOT NULL
  • category_id — BIGINT — Foreign key → CATEGORY.category_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INT
  • created_at — DATETIME — NOT NULL

BOARD_LIKE

  • board_id — BIGINT — Foreign key → BOARD.board_id — NOT NULL
  • member_id — BIGINT — Foreign key → MEMBER.member_id — NOT NULL
  • created_at — DATETIME — NOT NULL

CATEGORY

  • category_id — BIGINT — Primary key — NOT NULL
  • category_name — VARCHAR(50) — NOT NULL

COMMENT

  • comment_id — BIGINT — Primary key — NOT NULL
  • board_id — BIGINT — Foreign key → BOARD.board_id — NOT NULL
  • member_id — BIGINT — Foreign key → MEMBER.member_id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

MEMBER

  • member_id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL