board_api

Tables (4)

board

  • board_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.user_id — NOT NULL
  • title — VARCHAR(30) — NOT NULL
  • content — TEXT — NOT NULL
  • views — INT — NOT NULL
  • createAt — timestamp — NOT NULL
  • modifyAt — timestamp — NOT NULL
  • isDeleted — boolean — NOT NULL

commnet

  • commnet_id (comment_id) — INT — Primary key — NOT NULL
  • board_id — INT — Foreign key → board.board_id — NOT NULL
  • user_id — INT — Foreign key → user.user_id — NOT NULL
  • content — VARCHAR(100) — NOT NULL
  • createAt — timestamp — NOT NULL
  • modifyAt — timestamp — NOT NULL

image

  • image — INT — Primary key — NOT NULL
  • board_id — INT — Foreign key → board.board_id — NOT NULL
  • user_id — INT — Foreign key → board.user_id — NOT NULL
  • originName — VARCHAR(100) — NOT NULL
  • saveName — VARCHAR(100) — NOT NULL
  • imagePath — VARCHAR(100) — NOT NULL
  • imageSize — INT — NOT NULL

user

  • user_id — INT — Primary key — NOT NULL
  • email — VARCHAR(30) — NOT NULL
  • password — VARCHAR(50) — NOT NULL