数据库存储双十二优惠活动

CREATE TABLE promotions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    description TEXT,
    start_date DATETIME NOT NULL,
    end_date DATETIME NOT NULL,
    discount_rate DECIMAL(5, 2) NOT NULL,
    status ENUM('active', 'inactive') NOT NULL DEFAULT 'inactive'
);

CREATE TABLE promotion_items (
    id INT AUTO_INCREMENT PRIMARY KEY,
    promotion_id INT,
    product_id INT,
    quantity INT NOT NULL,
    FOREIGN KEY (promotion_id) REFERENCES promotions(id)
);

CREATE TABLE user_promotions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT,
    promotion_id INT,
    redeemed BOOLEAN DEFAULT FALSE,
    redeemed_at DATETIME,
    FOREIGN KEY (promotion_id) REFERENCES promotions(id)
);