mm_toy

Tables (4)

Board (게시글)

  • board_id (PK) — Long — Primary key — NOT NULL
  • user_id (PK2) — Long — Foreign key → User.user_id — NOT NULL
  • title (제목) — String
  • content (내용) — String
  • author (저자) — String
  • imgUrl (이미지) — String

Comment (댓글)

  • comment_id (PK) — Long — Primary key
  • content (Field) — String
  • user_id (PK2) — Long — Foreign key → User.user_id — NOT NULL
  • board_id (PK3) — Long — Foreign key → Board.board_id — NOT NULL

Like (좋아요)

  • like_id (PK) — Long
  • board_id (PK2) — Long — Foreign key → Board.board_id — NOT NULL
  • user_id (PK3) — Long — Foreign key → User.user_id — NOT NULL

User (유저)

  • user_id (PK) — Long — Primary key — NOT NULL
  • username (유저네임) — String
  • password (비밀번호) — String
  • email (이메일) — String
  • role (역할) — String
  • name (이름) — String
  • Field