aaaa

Tables (5)

Comment

  • commentId — INT — Primary key — NOT NULL
  • commentContent — TEXT
  • commentCreate — TIMESTAMP
  • pageId — INT — Foreign key → WikiPage.pageId — NOT NULL
  • userId — INT — Foreign key → User.userId — NOT NULL

Revision

  • revisionId — INT — Primary key — NOT NULL
  • content — TEXT
  • revisionUpdate — TIMESTAMP
  • pageId — INT — Foreign key → WikiPage.pageId — NOT NULL
  • userId — INT — Foreign key → User.userId — NOT NULL

User

  • userId — INT — Primary key — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(100)
  • email — VARCHAR(100)
  • userCreate — TIMESTAMP
  • role — INT — NOT NULL — 1: Admin, 2: Moderator, 3: Regular User

Vote

  • voteId — INT — Primary key — NOT NULL
  • userId — INT — Foreign key → User.userId — NOT NULL
  • pageId — INT — Foreign key → WikiPage.pageId — NOT NULL
  • voteType — ENUM('upvote', 'downvote')

WikiPage

  • pageId — INT — Primary key — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT
  • pageCreate — TIMESTAMP
  • pageUpdate — TIMESTAMP
  • userId — INT — Foreign key → User.userId — NOT NULL