{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["数据库表结构设计"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"数据库表结构设计","index":0,"n_rows":114,"n_cols":11,"rows_kept":114,"cut":false,"hidden":false,"merged":[[1,0,1,3],[1,7,1,10],[16,7,16,10],[28,0,28,3],[37,7,37,10],[44,0,44,3],[55,7,55,10],[65,0,65,3],[65,7,65,10],[74,7,74,10],[80,0,80,3],[85,7,85,10],[97,0,97,3],[100,7,100,10],[107,7,107,10]]}
[]
["服务器：MySQL:表名：SAAS_ACCOUNT，作用：运维管理平台账号表",{"$nulls":6},"服务器：MySQL:表名：SAAS_ROLE，作用：功能菜单权限管理-角色（角色属于集团，级联删除）"]
["字段","类型","主键","说明",null,null,null,"字段","类型","主键","说明"]
["ID","varchar(64)","是","AC+雪花",null,null,null,"ID","varchar(64)","是","RO+雪花"]
["GROUP_CODE","varchar(20)",null,"集团编码",null,null,null,"GROUP_CODE","varchar(20)",null,"集团编码"]
["TERMINAL","varchar(100)",null,"应用ID， PC-电脑端，APP-手机应用端",null,null,null,"ROLE_CODE","varchar(50)",null,"角色编码"]
["USERNAME","varchar(50)",null,"登录用户名",null,null,null,"ROLE_NAME","varchar(100)",null,"角色名称"]
["PASSWORD","varchar(128)",null,"登录密码",null,null,null,"ROLE_TYPE","varchar(1)",null,"角色类型，0-系统角色，1-业务角色，默认0"]
["PHONE_NUM","varchar(20)",null,"手机号",null,null,null,"CREATE_TIME","datetime",null,"创建时间"]
["MAIL","varchar(50)",null,"邮箱",null,null,null,"UPDATE_TIME","datetime",null,"更新时间"]
["HEAD_PORTRAIT","varchar(500)",null,"头像，图片URL",null,null,null,"UPDATE_USER","varchar(64)",null,"最后一次更新者ID"]
["LAST_LOGIN_TIME","datetime",null,"账号上一次登录时间",null,null,null,"REMARK","varchar(255)",null,"备注"]
["LAST_LOGIN_IP","varchar(100)",null,"账号上一次登录IP",null,null,null,"VALID","tinyint",null,"0-不可用，1-可用"]
["VALID_START_TIME","datetime",null,"账号有效期的开始时间"]
["END_START_TIME","datetime",null,"账号有效期的结束时间"]
["ACCOUNT_SOURCE","varchar(100)",null,"账号来源,默认 persagy"]
["ACCOUNT_BELONG","varchar(1)",null,"账号所属, 0-运维系统账号，1-业务账号",null,null,null,"服务器：MySQL:表名：SAAS_MENU，作用：功能菜单权限管理-菜单（全局，并不属于集团）"]
["ACCOUNT_TYPE","varchar(1)",null,"账号类型, 0-超级管理员(所有集团)，1-单集团管理员，2-普通账号",null,null,null,"字段","类型","主键","说明"]
["VALID_START_TIME","datetime",null,"账号有效期的开始时间",null,null,null,"ID","varchar(64)","是","ME+雪花"]
["VALID_END_TIME","datetime",null,"账号有效期的结束时间",null,null,null,"PARENT_ID","varchar(64)",null,"上级菜单ID"]
["VALID_LAST","varchar(1)",null,"账号有效期，0-期内有效，1-永久有效",null,null,null,"PRODUCT_ID","varchar(64)",null,"产品ID"]
["CREATE_TIME","datetime",null,"创建时间",null,null,null,"APP_ID","varchar(64)",null,"应用ID， PC-电脑端，APP-手机应用端"]
["UPDATE_TIME","datetime",null,"更新时间",null,null,null,"MENU_CODE","varchar(50)",null,"菜单编码"]
["UPDATE_USER","varchar(64)",null,"最后一次更新者ID",null,null,null,"MENU_NAME","varchar(50)",null,"菜单名称"]
["REMARK","varchar(255)",null,"备注",null,null,null,"MENU_URL","varchar(500)",null,"菜单URL"]
["VALID","tinyint",null,"0-不可用，1-可用",null,null,null,"URL_TYPE","varchar(1)",null,"URL类型，0-相对路径，1-绝对路径"]
[{"$nulls":7},"MENU_ICON","varchar(50)",null,"菜单图标"]
[{"$nulls":7},"MENU_SORT","int",null,"菜单顺序"]
["服务器：MySQL:表名：SAAS_GROUP，作用：集团信息",{"$nulls":6},"MENU_TYPE","varchar(1)",null,"菜单类型，0-系统菜单，1-标准业务菜单，2-IBMS菜单"]
["字段","类型","主键","说明",null,null,null,"MENU_ANGLE","varchar(1)",null,"菜单视角，0-集团项目视角，1-集团视角，2-项目视角"]
["GROUP_CODE","varchar(20)","是","集团编码",null,null,null,"CREATE_TIME","datetime",null,"创建时间"]
["GROUP_NAME","varchar(64)",null,"集团名称，唯一",null,null,null,"UPDATE_TIME","datetime",null,"更新时间"]
["GROUP_ICON","varchar(100)",null,"集团图标",null,null,null,"UPDATE_USER","varchar(64)",null,"最后一次更新者ID"]
["GROUP_DESC","varchar(100)",null,"集团描述",null,null,null,"REMARK","varchar(255)",null,"备注"]
["DEPLOY_MODEL","varchar(1)",null,"集团部署方式，0-公有云，1-私有云",null,null,null,"VALID","tinyint",null,"0-不可用，1-可用"]
["SYNC_STATE","varchar(1)",null,"数据同步状态,0-数据同步失败，1-数据同步成功，2-未同步"]
["SYNC_TIME","datetime",null,"上次数据同步时间"]
["CREATE_TIME","datetime",null,"创建时间",null,null,null,"服务器：MySQL:表名：SAAS_FUNCTION，作用：功能菜单权限管理-功能点"]
["UPDATE_TIME","datetime",null,"更新时间",null,null,null,"字段","类型","主键","说明"]
["UPDATE_USER","varchar(64)",null,"最后一次更新者ID",null,null,null,"ID","varchar(64)","是","FU+雪花"]
["REMARK","varchar(255)",null,"备注",null,null,null,"MENU_ID","varchar(64)",null,"菜单ID，这里的菜单ID仅做列表展示使用"]
["VALID","tinyint",null,"0-不可用，1-可用",null,null,null,"PAGE_ID","varchar(64)",null,"页面ID"]
[{"$nulls":7},"FUN_CODE","varchar(100)",null,"功能编码,字典值定义"]
[{"$nulls":7},"FUN_NAME","varchar(100)",null,"功能名称"]
["服务器：MySQL:表名：SAAS_PROJECT，作用：项目信息",{"$nulls":6},"FUN_URL","varchar(500)",null,"功能URL"]
["字段","类型","主键","说明",null,null,null,"FUN_SORT","int",null,"功能顺序"]
["ID","varchar(64)","是","PR+雪花",null,null,null,"CREATE_TIME","datetime",null,"创建时间"]
["GROUP_CODE","varchar(20)",null,"集团编码",null,null,null,"UPDATE_TIME","datetime",null,"更新时间"]
["PROJECT_ID","varchar(25)",null,"项目ID",null,null,null,"UPDATE_USER","varchar(64)",null,"最后一次更新者ID"]
["AREA_ID","varchar(64)",null,"项目所属区域，必须为最底层的区域",null,null,null,"REMARK","varchar(255)",null,"备注"]
["PROJECT_LOCAL_ID","varchar(64)",null,"项目本地编码"]
["PROJECT_NAME","varchar(50)",null,"项目名称"]
["PROVINCE_CODE","varchar(30)",null,"项目所在省"]
["CITY_CODE","varchar(30)",null,"项目所在市"]
["ZONE_CODE","varchar(30)",null,"项目所在区"]
["LOCATION","varchar(500)",null,"项目详细地址",null,null,null,"服务器：MySQL:表名：SAAS_ROLE_MENU，作用：功能菜单权限管理-角色菜单关联（实际的菜单所拥有的功能权限）"]
["OPEN_TIME","datetime",null,"项目开业时间",null,null,null,"字段","类型","主键","说明"]
["CREATE_TIME","datetime",null,"创建时间",null,null,null,"GROUP_CODE","varchar(20)",null,"集团编码"]
["UPDATE_TIME","datetime",null,"更新时间",null,null,null,"ROLE_ID","varchar(64)",null,"角色ID"]
["UPDATE_USER","varchar(64)",null,"最后一次更新者ID",null,null,null,"MENU_ID","varchar(64)",null,"菜单ID"]
["REMARK","varchar(255)",null,"备注",null,null,null,"FUNCTION_ID","varchar(64)",null,"功能ID"]
["VALID","tinyint",null,"0-不可用，1-可用"]
[]
[]
[]
["服务器：MySQL:表名：SAAS_AREA，作用：区域信息（不允许挂载了项目的区域及其父区域被删除）",{"$nulls":6},"服务器：MySQL:表名：SAAS_ACCOUNT_PROJECT，作用：账号-集团项目表（一对多，账号表中scope为3时，此表配置）"]
["字段","类型","主键","说明",null,null,null,"字段","类型","主键","说明"]
["ID","varchar(64)","是","AR+雪花",null,null,null,"ACCOUNT_ID","varchar(64)",null,"账号ID"]
["GROUP_CODE","varchar(20)",null,"集团编码",null,null,null,"GROUP_CODE","varchar(20)",null,"集团编码"]
["PARENT_ID","varchar(64)",null,"上级区域ID",null,null,null,"AREA_ID","varchar(64)",null,"区域ID"]
["AREA_CODE","varchar(50)",null,"区域编码",null,null,null,"PROJECT_ID","varchar(20)",null,"项目ID"]
["AREA_NAME","varchar(50)",null,"区域名称"]
["AREA_TYPE","varchar(1)",null,"区域类型，0-非最底层区域，1-最底层区域"]
["CREATE_TIME","datetime",null,"创建时间"]
["UPDATE_TIME","datetime",null,"更新时间",null,null,null,"服务器：MySQL:表名：SAAS_ACCOUNT_ROLE，作用：账号-角色关联表"]
["UPDATE_USER","varchar(64)",null,"最后一次更新者ID",null,null,null,"字段","类型","主键","说明"]
["REMARK","varchar(255)",null,"备注",null,null,null,"GROUP_CODE","varchar(20)",null,"集团编码"]
[{"$nulls":7},"ACCOUNT_ID","varchar(64)",null,"账号ID"]
[{"$nulls":7},"ROLE_ID","varchar(64)",null,"角色ID"]
[{"$nulls":7},"CAS_TYPE","varchar(1)",null,"关联类型，0-主岗，1-副岗"]
["服务器：MySQL:表名：SAAS_PRODUCT，作用：产品信息"]
["字段","类型","主键","说明"]
["ID","varchar(64)","是","PD+雪花"]
["APP_ID","varchar(64)",null,"应用ID， PC-电脑端，APP-手机应用端"]
["PRODUCT_CODE","varchar(50)",null,"产品编码"]
["PRODUCT_NAME","varchar(50)",null,"产品名称",null,null,null,"服务器：MySQL:表名：SAAS_GROUP_PRODUCT，作用：集团签约产品"]
["PRODUCT_ICON","varchar(100)",null,"产品图标",null,null,null,"字段","类型","主键","说明"]
["PRODUCT_STATE","varchar(1)",null,"产品状态，0-建设中，1-已完成，2-已关联",null,null,null,"ID","varchar(64)","是","GP+雪花"]
["PRODUCT_MENU","varchar(1)",null,"产品菜单，0-未关联，1-已关联",null,null,null,"GROUP_CODE","varchar(20)",null,"集团编码"]
["CREATE_TIME","datetime",null,"创建时间",null,null,null,"PRODUCT_ID","varchar(64)",null,"产品ID"]
["UPDATE_TIME","datetime",null,"更新时间",null,null,null,"PRODUCT_CODE","varchar(50)",null,"产品编码"]
["UPDATE_USER","varchar(64)",null,"最后一次更新者ID",null,null,null,"PRODUCT_RANGE","varchar(1)",null,"产品使用范围，0-全部项目，1-部分项目"]
["REMARK","varchar(255)",null,"备注",null,null,null,"PRODUCT_CONTRACT","datetime",null,"签约时间"]
[{"$nulls":7},"VALID_START_TIME","datetime",null,"签约有效期的开始时间"]
[{"$nulls":7},"VALID_END_TIME","datetime",null,"签约有效期的结束时间"]
[{"$nulls":7},"VALID_LAST","varchar(1)",null,"签约有效期，0-期内有效，1-永久有效"]
[{"$nulls":7},"REMARK","varchar(255)",null,"备注"]
["服务器：MySQL:表名：SAAS_PRODUCT_PAGE，作用：产品页面"]
["字段","类型","主键","说明"]
["ID","varchar(64)","是","PA+雪花"]
["PRODUCT_ID","varchar(64)",null,"产品ID",null,null,null,"服务器：MySQL:表名：SAAS_GROUP_PRODUCT_DETAIL，作用：集团签约产品详情"]
["PAGE_NAME","varchar(50)",null,"页面名称",null,null,null,"字段","类型","主键","说明"]
["PAGE_ICON","varchar(100)",null,"页面图标",null,null,null,"CONTRACT_ID","varchar(64)",null,"签约ID"]
["PAGE_URL","varchar(100)",null,"页面URL",null,null,null,"PAGE_ID","varchar(64)",null,"页面ID"]
["PAGE_ANGLE","varchar(1)",null,"页面视角，0-集团项目页，1-集团独有页，2-项目独有页"]
["PAGE_FLOOR","varchar(1)",null,"是否为落地页，0-非落地页，1-集团落地页，2-项目落地页，3-集团项目落地页"]
["CREATE_TIME","datetime",null,"创建时间"]
["UPDATE_TIME","datetime",null,"更新时间",null,null,null,"服务器：MySQL:表名：SAAS_PROJECT_PRODUCT，作用：项目签约产品"]
["UPDATE_USER","varchar(64)",null,"最后一次更新者ID",null,null,null,"字段","类型","主键","说明"]
["REMARK","varchar(255)",null,"备注",null,null,null,"GROUP_CODE","varchar(20)",null,"集团编码"]
[{"$nulls":7},"PROJECT_ID","varchar(25)",null,"项目ID"]
[{"$nulls":7},"PRODUCT_ID","varchar(64)",null,"产品ID"]
[{"$nulls":7},"PRODUCT_CONTRACT","datetime",null,"签约时间"]
[{"$nulls":7},"REMARK","varchar(255)",null,"备注"]