6.4打卡

python大作业
• 所花时间：4
• 代码行数：189
• 博客容量：1
• 代码如下：

create database if not exists dormitory_management;

CREATE TABLE dormitories (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    floors INT NOT NULL,
    rooms_per_floor INT NOT NULL,
    gender ENUM('��', 'Ů') NOT NULL
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

CREATE TABLE users (
    username VARCHAR(255) PRIMARY KEY,
    name VARCHAR(128),
    password VARCHAR(255) NOT NULL,
    dormitory_id INT,
    room_number INT,
    gender ENUM('��', 'Ů'),
    role ENUM('student', 'admin') NOT NULL,
    position VARCHAR(255),
    FOREIGN KEY (dormitory_id) REFERENCES dormitories(id)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

CREATE TABLE maintenance_requests (
    id INT AUTO_INCREMENT PRIMARY KEY,
    reported_by VARCHAR(255) NOT NULL,
    dormitory_id INT NOT NULL,
    room_number INT NOT NULL,
    description TEXT NOT NULL,
    handled BOOLEAN DEFAULT FALSE,
    FOREIGN KEY (dormitory_id) REFERENCES dormitories(id),
    FOREIGN KEY (reported_by) REFERENCES users(username)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

CREATE TABLE room_swap_requests (
    id INT AUTO_INCREMENT PRIMARY KEY,
    requester_username VARCHAR(255),
    partner_username VARCHAR(255),
    status ENUM('pending', 'approved', 'rejected') DEFAULT 'pending'
)CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;