2017-06-09.sql 477 B

12345678910111213
  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. ALTER TABLE `aft_dev`.`value_evaluation`
  11. ADD INDEX `uid_index` (`uid` ASC);