pub_column_settings_inf.sql 559 B

123456789
  1. CREATE TABLE `pub_column_settings_inf` (
  2. `psf_company_id` varchar(64) NOT NULL COMMENT '公司编号',
  3. `psf_user_id` varchar(64) NOT NULL COMMENT '用户编号',
  4. `psf_page_path` varchar(200) NOT NULL COMMENT '页面路径',
  5. `psf_table_name` varchar(100) NOT NULL COMMENT '页面表格名称',
  6. `psf_show_data` text COMMENT '显示的列',
  7. `psf_hide_data` text COMMENT '隐藏的列',
  8. PRIMARY KEY (`psf_company_id`,`psf_user_id`,`psf_page_path`,`psf_table_name`)
  9. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='前台列隐藏显示配置信息表';