FBPR

Tables (3)

Comment (댓글)

  • id (댓글_id) — Primary key — NOT NULL
  • comment (내용)
  • createdDate (생성날짜)
  • modifiedDate (수정날짜)
  • id (사용자_id) — Foreign key → Member.id — NOT NULL
  • id (게시판_id) — Foreign key → FreeBoard.id — NOT NULL

FreeBoard (게시판)

  • id (게시판_id) — Primary key — NOT NULL
  • content (내용)
  • title (제목)
  • createdDate (생성날짜)
  • modifiedDate (수정날짜)
  • id (사용자_id) — Foreign key → Member.id — NOT NULL

Member (멤버)

  • id (사용자_id) — Primary key — NOT NULL
  • name (이름)
  • email (이메일)
  • password (비밀번호)
  • memberRole (사용자/관리자)