新闻管理系统数据库表

-- 新闻表
CREATE TABLE News (
    NewsID INT PRIMARY KEY AUTO_INCREMENT,
    Title VARCHAR(255) NOT NULL,
    Content TEXT NOT NULL,
    CategoryID INT,
    PublishTime DATETIME NOT NULL,
    AuthorID INT,
    Status ENUM('Draft', 'Published', 'Archived') DEFAULT 'Draft',
    FOREIGN KEY (CategoryID) REFERENCES Category(CategoryID),
    FOREIGN KEY (AuthorID) REFERENCES User(UserID)
);

-- 分类表
CREATE TABLE Category (
    CategoryID INT PRIMARY KEY AUTO_INCREMENT,
    Name VARCHAR(100) NOT NULL UNIQUE,
    Description TEXT
);

-- 用户表
CREATE TABLE User (
    UserID INT PRIMARY KEY AUTO_INCREMENT,
    Username VARCHAR(50) NOT NULL UNIQUE,
    Password VARCHAR(255) NOT NULL,
    Role ENUM('Admin', 'Editor', 'User') DEFAULT 'User'
);

-- 审核表
CREATE TABLE Audit (
    AuditID INT PRIMARY KEY AUTO_INCREMENT,
    NewsID INT,
    AuditorID INT,
    AuditTime DATETIME NOT NULL,
    Result ENUM('Approved', 'Rejected') NOT NULL,
    FOREIGN KEY (NewsID) REFERENCES News(NewsID),
    FOREIGN KEY (AuditorID) REFERENCES User(UserID)
);