test

Tables (3)

Board (게시글)

  • ID (글번호) — BIGINT — Primary key — NOT NULL
  • User_Id (회원번호) — BIGINT — Foreign key → User.ID — NOT NULL
  • Title (제목) — VARCHAR
  • Content (내용) — VARCHAR
  • Username (이름) — VARCHAR

Comment (댓글)

  • ID (댓글번호) — BIGINT — Primary key — NOT NULL
  • Board_Id (게시글번호) — BIGINT — Foreign key → User.ID — NOT NULL
  • User_Id (회원번호) — BIGINT — Foreign key → Board.User_Id — NOT NULL
  • Content (댓글내용) — VARCHAR

User (회원)

  • ID (번호) — BIGINT — Primary key — NOT NULL
  • Username (이름) — VARCHAR
  • Password (비밀번호) — VARCHAR
  • Role (권한) — ENUM