dw_report_inf.sql 556 B

12345678910
  1. CREATE TABLE dw_report_inf (
  2. DRI_ID varchar(20) NOT NULL COMMENT '编号',
  3. DRI_UPLOAD_DATE varchar(8) COMMENT '上传时间',
  4. DRI_FILE_NAME varchar(200) COMMENT '文件名称',
  5. DRI_CREAT_USER varchar(20) COMMENT '导入人员',
  6. DRI_BRANCH varchar(20) COMMENT '所属结构(班组)',
  7. DRI_TYPE varchar(20) COMMENT '00台区停电01低电压',
  8. DRI_STATE varchar(2) default '0' COMMENT '0正常1删除',
  9. PRIMARY KEY (DRI_ID)
  10. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='报表数据';