SpringProejct

Tables (4)

Board (Untitled2)

  • id (게시물번호) — number — Primary key — NOT NULL
  • member (작성 유저) — EmbedMember — Foreign key → EmbedMember.id — NOT NULL
  • title (제목) — varchar2(300)
  • content (내용) — varchar2(3000)
  • thumbnail (썸네일) — varchar2(500)
  • postdate (게시일자) — LocalDate

Comment (Untitled3)

  • id (댓글번호) — number — Primary key — NOT NULL
  • boardid (게시물번호) — number — Foreign key → Board.id — NOT NULL
  • member (작성 유저) — Member — Foreign key → Member.id — NOT NULL
  • content (내용) — varchar2(100)
  • postdate (게시일자) — date

EmbedMember (CopyOfUntitled)

  • id (아이디값) — number — Primary key — NOT NULL
  • name (이름) — varchar2(100)
  • email (이메일) — varchar2(100)
  • userid (아이디) — varchar2(100)
  • password (비밀번호) — varchar2(100)
  • githublink (깃허브링크) — varchar2(100)

Member (Untitled)

  • id (아이디값) — number — Primary key — NOT NULL
  • name (이름) — varchar2(100)
  • email (이메일) — varchar2(100)
  • userid (아이디) — varchar2(100)
  • password (비밀번호) — varchar2(100)
  • image (프로필 사진) — varchar2(100)
  • githublink (깃허브링크) — varchar2(100)
  • introduce (자기소개) — varchar2(100)