医院科研管理系统

`id` INT(11) NOT NULL AUTO_INCREMENT,

`username` VARCHAR(255) NOT NULL,

`password` VARCHAR(255) NOT NULL,

`email` VARCHAR(255) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

`id` INT(11) NOT NULL AUTO_INCREMENT,

`name` VARCHAR(255) NOT NULL,

`description` TEXT,

`start_date` DATE,

`end_date` DATE,

`status` ENUM('new', 'in_progress', 'completed') DEFAULT 'new',

`user_id` INT(11),

PRIMARY KEY (`id`),

FOREIGN KEY (`user_id`) REFERENCES `users`(`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

`id` INT(11) NOT NULL AUTO_INCREMENT,

`project_id` INT(11) NOT NULL,

`name` VARCHAR(255) NOT NULL,

在线排课软件

`description` TEXT,

`start_date` DATE,

`end_date` DATE,

`status` ENUM('new', 'in_progress', 'completed') DEFAULT 'new',

PRIMARY KEY (`id`),

FOREIGN KEY (`project_id`) REFERENCES `projects`(`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;