_schema_out.txt 3.0 KB

1234567891011121314151617181920212223242526272829303132333435363738
  1. === main_post_candidate_review NOT FOUND ===
  2. === main_student_education ===
  3. `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  4. `student_id` bigint NOT NULL COMMENT '学员ID (关联 main_student.id)',
  5. `school` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学校名称',
  6. `education` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学历',
  7. `start_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开始时间 (如 2022.9)',
  8. `end_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '结束时间 (如 2026.7)',
  9. `major` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '专业',
  10. `campus_experience` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '在校经历描述',
  11. `tenant_id` bigint NULL DEFAULT 0 COMMENT '租户ID',
  12. `create_dept` bigint NULL DEFAULT NULL COMMENT '创建部门',
  13. `create_by` bigint NULL DEFAULT NULL COMMENT '创建者',
  14. `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  15. `update_by` bigint NULL DEFAULT NULL COMMENT '更新者',
  16. `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  17. `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '删除标志',
  18. INDEX `idx_student_id`(`student_id` ASC) USING BTREE
  19. === main_student_experience ===
  20. `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  21. `student_id` bigint NOT NULL COMMENT '学员ID (关联 main_student.id)',
  22. `company` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '公司名称',
  23. `industry` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '所属行业',
  24. `start_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开始时间',
  25. `end_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '结束时间',
  26. `is_internship` tinyint(1) NULL DEFAULT 0 COMMENT '是否实习 (0否 1是)',
  27. `job_title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '职位名称',
  28. `department` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '所属部门',
  29. `work_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '工作内容描述',
  30. `tenant_id` bigint NULL DEFAULT 0 COMMENT '租户ID',
  31. `create_dept` bigint NULL DEFAULT NULL COMMENT '创建部门',
  32. `create_by` bigint NULL DEFAULT NULL COMMENT '创建者',
  33. `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  34. `update_by` bigint NULL DEFAULT NULL COMMENT '更新者',
  35. `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  36. `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '删除标志',
  37. INDEX `idx_student_id`(`student_id` ASC) USING BTREE
  38. === main_back_interview NOT FOUND ===