-- CreateTable
CREATE TABLE `users` (
`id` VARCHAR(191) NOT NULL,
`email` VARCHAR(191) NOT NULL,
`name` VARCHAR(20) NOT NULL,
`password` VARCHAR(80) NOT NULL,
`college` VARCHAR(20) NOT NULL,
`created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
`updated_at` DATETIME(3) NOT NULL,
`roles` JSON NOT NULL,
UNIQUE INDEX `users_email_key`(`email`),
PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- CreateTable
CREATE TABLE `papers` (
`id` VARCHAR(191) NOT NULL,
`course` VARCHAR(20) NOT NULL,
`college` VARCHAR(24) NOT NULL,
`teacher_id` VARCHAR(191) NOT NULL,
`remark` VARCHAR(191) NULL,
`status` ENUM('PENDING', 'PASSED', 'REJECTED', 'REVIEW_PASSED', 'REVIEW_REJECTED', 'PRINT') NOT NULL,
`a_name` VARCHAR(50) NOT NULL,
`b_name` VARCHAR(50) NOT NULL,
`created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
`updated_at` DATETIME(3) NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- CreateTable
CREATE TABLE `paper_lifes` (
`id` VARCHAR(191) NOT NULL,
`paper_id` VARCHAR(191) NOT NULL,
`user_id` VARCHAR(191) NOT NULL,
`status` ENUM('CREATE', 'UPDATE', 'PENDING', 'PASSED', 'REJECTED', 'REVIEW_PASSED', 'REVIEW_REJECTED', 'PRINT') NOT NULL,
`content` VARCHAR(191) NULL,
`images` JSON NULL,
`created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
`a_name` VARCHAR(50) NULL,
`b_name` VARCHAR(50) NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- CreateTable
CREATE TABLE `manager_notices` (
`id` VARCHAR(191) NOT NULL,
`title` VARCHAR(40) NOT NULL,
`content` VARCHAR(191) NULL,
`user_id` VARCHAR(191) NOT NULL,
`created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- CreateTable
CREATE TABLE `user_notices` (
`id` VARCHAR(191) NOT NULL,
`user_id` VARCHAR(191) NOT NULL,
`notice_id` VARCHAR(191) NOT NULL,
`read` BOOLEAN NOT NULL DEFAULT false,
`readAt` DATETIME(3) NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- CreateTable
CREATE TABLE `refresh_tokens` (
`token` VARCHAR(32) NOT NULL,
`user_id` VARCHAR(191) NOT NULL,
`created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
`os` JSON NOT NULL,
`device` JSON NOT NULL,
`browser` JSON NOT NULL,
UNIQUE INDEX `refresh_tokens_token_key`(`token`),
PRIMARY KEY (`token`, `user_id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- CreateTable
CREATE TABLE `colleges` (
`id` INTEGER NOT NULL,
`name` VARCHAR(20) NOT NULL,
UNIQUE INDEX `colleges_name_key`(`name`),
PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- AddForeignKey
ALTER TABLE `users` ADD CONSTRAINT `users_college_fkey` FOREIGN KEY (`college`) REFERENCES `colleges`(`name`) ON DELETE RESTRICT ON UPDATE CASCADE;
-- AddForeignKey
ALTER TABLE `papers` ADD CONSTRAINT `papers_teacher_id_fkey` FOREIGN KEY (`teacher_id`) REFERENCES `users`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
-- AddForeignKey
ALTER TABLE `paper_lifes` ADD CONSTRAINT `paper_lifes_paper_id_fkey` FOREIGN KEY (`paper_id`) REFERENCES `papers`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
-- AddForeignKey
ALTER TABLE `user_notices` ADD CONSTRAINT `user_notices_notice_id_fkey` FOREIGN KEY (`notice_id`) REFERENCES `manager_notices`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
基于Node.js实现的试卷管理系统源码+使用说明(课程大作业).zip （260个子文件） 
nginx.conf 2KB schema.dbml 2KB .env.development 94B .editorconfig 245B .editorconfig 202B document.ejs 7KB validate-code.ejs 770B change-email.ejs 749B notice.ejs 464B .eslintignore 70B .eslintignore 56B .gitignore 431B .gitkeep 0B .gitkeep 0B favicon.ico 4KB service-worker.js 2KB .eslintrc.js 712B commitlint.config.js 678B .eslintrc.js 438B .stylelintrc.js 246B jest.config.js 226B .prettierrc.js 86B package.json 4KB package.json 3KB tsconfig.json 1KB tsconfig.json 709B manifest.json 454B settings.json 428B settings.json 308B jsconfig.json 192B extensions.json 149B nest-cli.json 139B tsconfig.build.json 97B extensions.json 64B style.less 4KB NoticeList.less 2KB style.less 2KB index.less 1KB index.less 870B global.less 830B index.less 474B index.less 461B index.less 306B index.less 304B index.less 293B index.less 249B index.less 188B index.less 169B index.less 169B index.less 109B index.less 109B index.less 100B index.less 36B yarn.lock 780KB index.md 8KB 使用说明.md 3KB 使用说明.md 27B ryans-key.pem 2KB abels-key.pem 2KB abels-cert.pem 1KB ryans-cert.pem 1KB abels-csr.pem 1021B ryans-csr.pem 956B
icon-512x512.png 5KB icon-192x192.png 2KB icon-128x128.png 1KB .prettierignore 232B .prettierignore 54B .prettierrc 52B schema.prisma 3KB migration.sql 4KB
logo.svg 11KB pro_icon.svg 677B migration_lock.toml 121B _mock.ts 9KB paper.service.ts 8KB auth.service.ts 6KB users.service.ts 5KB user.ts 5KB listTableList.ts 5KB typings.d.ts 4KB upload.controller.ts 4KB notices.ts 3KB routes.ts 3KB user.controller.ts 3KB main.ts 3KB is.ts 3KB is.ts 3KB app.module.ts 3KB email.service.ts 2KB check.service.ts 2KB local.strategy.ts 2KB paper.controller.ts 2KB upload.service.ts 2KB request.ts 2KB upload.ts 2KB pdf-render.ts 2KB notice.service.ts 2KB auth.guard.ts 2KB utils.ts 2KB共 260 条
- 1
- 2
- 3
资源评论
���4322024-05-11这个资源总结的也太全面了吧，内容详实，对我帮助很大。
