uu-platform/db/home-schema.sql

create table if not exists `home_config`
(
id int unsigned primary key not null auto_increment,
order_num int comment '顺序',
name varchar(100) comment '名称',
icon varchar(100) comment '图标',
view_type int default 0 comment '视图类型 0 - widget, 1 - web',
android_widget varchar(100) comment 'android控件',
ios_widget varchar(100) comment 'ios控件',
web_url varchar(300) comment '网页',
scope_platform int default 0 comment '专属平台的应用 0 - ALL',
scope_company_id bigint comment '专属企业的应用',
company_relate int comment '与公司相关的类型 0 - COMPANY_OR_PERSONAL'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='个人主页配置';

create table if not exists `home_company`
(
config_id int not null,
company_id bigint not null
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='企业绑定个人主页配置';