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