sql_merge/src/dao_old/ReportRecord.js

/*
 * @Author: fuyu
 * @Date: 2021-03-22 19:10:00
 * @LastEditors: fuyu
 * @LastEditTime: 2021-03-23 10:28:13
 * @FilePath: /202103/code/test/tmp/ReportRecord.js
 */

const Sequelize = require('sequelize');
import sequelize from './db/sequelize';
/**
* 患者信息
*/
// primaryKey: true
// defaultValue: null
const ReportRecord = sequelize.define('report_record', {
  id: {type: Sequelize.STRING(32), allowNull: false, primaryKey: true}, // id,
  impression: {type: Sequelize.STRING(2000), allowNull: true, defaultValue: null}, // impression, 检查所见
  description: {type: Sequelize.STRING(2000), allowNull: true, defaultValue: null}, // description, 意见建议
  report_id: {type: Sequelize.STRING(50), allowNull: true, defaultValue: null}, // report_id, 检查表id
  doctor_id: {type: Sequelize.STRING(50), allowNull: true, defaultValue: null}, // doctor_id, 医生id
  type: {type: Sequelize.STRING(255), allowNull: true, defaultValue: null}, // type, 操作类型 1报告 2审核 3确认 4驳回
  report_result: {type: Sequelize.STRING(255), allowNull: true, defaultValue: '1'}, // report_result, 阴阳性 1阴性  2阳性
}, {
  freezeTableName: true,
  charset: 'utf8',
  indexes:[
    {fields : ['report_id']}
  ],
});
ReportRecord.sync({ force: false }).then(function() {});
export default ReportRecord;