SpringBootWiki

Tables (4)

ChangeRequest (Revision)

  • Key (revisionId) — int — Primary key — NOT NULL
  • Field (content) — Text
  • Field (revisionUpdate) — DateTime
  • 페이지ID (pageId) — int — Foreign key → WikiPage.페이지ID — NOT NULL
  • UserId (userId) — varchar(50) — Foreign key → User.UserId — NOT NULL — auto increase

Comment

  • Key (commentId) — int — Primary key — NOT NULL
  • Field (commentContent) — Text
  • Field (commentCreate) — DateTime
  • 페이지ID (pageId) — int — Foreign key → WikiPage.페이지ID — NOT NULL
  • UserId (userId) — varchar(50) — Foreign key → User.UserId — NOT NULL — auto increase

User

  • UserId (userId) — varchar(50) — Primary key — NOT NULL — auto increase
  • 유저명 (username) — varchar(50) — NOT NULL
  • 패스워드 (password) — varchar(100)
  • 이메일 (email) — varchar(100)
  • 가입일 (userCreate) — DateTime

WikiPage

  • 페이지ID (pageId) — int — Primary key — NOT NULL
  • 제목 (title) — varchar(255)
  • 내용 (content) — Text
  • 생성일 (pageCreate) — DateTime
  • 수정일 (pageUpdate) — DateTime
  • UserId (userId) — varchar(50) — Foreign key → User.UserId — NOT NULL — auto increase
  • 카테고리 (category) — varchar(50)
  • 조회수 (views) — int
  • Field