23 lines
943 B
SQL
23 lines
943 B
SQL
CREATE TABLE `ai_grade_log` (
|
|
`id` bigint AUTO_INCREMENT NOT NULL,
|
|
`child_user_id` bigint NOT NULL,
|
|
`paper_id` varchar(191) NOT NULL,
|
|
`question_index` int NOT NULL,
|
|
`oss_key` varchar(300) NOT NULL,
|
|
`status` varchar(20) NOT NULL,
|
|
`earned` int NOT NULL DEFAULT 0,
|
|
`points` int NOT NULL DEFAULT 0,
|
|
`verdict` text,
|
|
`mock` boolean NOT NULL DEFAULT false,
|
|
`model` varchar(60),
|
|
`ms` int,
|
|
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
CONSTRAINT `ai_grade_log_id` PRIMARY KEY(`id`)
|
|
);
|
|
--> statement-breakpoint
|
|
ALTER TABLE `ai_grade_log` ADD CONSTRAINT `ai_grade_log_child_user_id_user_id_fk` FOREIGN KEY (`child_user_id`) REFERENCES `user`(`id`) ON DELETE cascade ON UPDATE no action;
|
|
--> statement-breakpoint
|
|
CREATE INDEX `idx_ai_grade_child_date` ON `ai_grade_log` (`child_user_id`,`created_at`);
|
|
--> statement-breakpoint
|
|
CREATE INDEX `idx_ai_grade_paper_q` ON `ai_grade_log` (`child_user_id`,`paper_id`,`question_index`);
|