share.sql 640 B

123456789101112131415161718
  1. create table `form_share`
  2. (
  3. id varchar(64) primary key not null,
  4. company_id int unsigned not null,
  5. biz_id int unsigned not null comment '业务单据ID',
  6. biz_code varchar(100) comment '业务单据编号',
  7. biz_type varchar(100) comment '业务类型',
  8. view_type varchar(100) comment '视图类型',
  9. send_to varchar(30) comment '转发到的地方',
  10. title varchar(100) comment '标题',
  11. app_id varchar(30) comment 'saas应用',
  12. creator_id int unsigned,
  13. creator_name varchar(100),
  14. create_time datetime,
  15. updater_id int unsigned,
  16. updater_name varchar(100),
  17. update_time datetime
  18. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='表单分享记录';