2017-06-09.sql 468 B

1234567891011121314
  1. CREATE TABLE `value_evaluation` (
  2. `id` BIGINT(18) NOT NULL,
  3. `uid` VARCHAR(36) NULL COMMENT '用户id',
  4. `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  5. `name` VARCHAR(128) NULL COMMENT '技术名称',
  6. `value` BIGINT(18) NULL COMMENT '评估值',
  7. `step` INT(2) NULL COMMENT '当前步骤',
  8. `log` JSON NULL COMMENT '步骤记录',
  9. PRIMARY KEY (`id`)
  10. );
  11. ALTER TABLE `value_evaluation`
  12. ADD INDEX `uid_index` (`uid` ASC);