{"text_format":"2","workbook":"xlsx","n_sheets":3,"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":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[6,2,6,4],[6,6,6,7],[7,2,7,7],[8,2,8,7],[9,2,9,7],[10,2,10,7],[11,3,11,4],[11,6,11,7],[14,3,14,4],[14,6,14,7],[12,2,13,7]]}
[]
[]
[]
[]
[]
[]
[null,"文档版本","机场野生动物智能管理信息系统V20210512",null,null,"编写人","吴文兴/杨志"]
[null,"编写说明","对产品文档进行规范管理"]
[null,"评审记录"]
[null,"审批记录"]
[]
[null,null,"确认人：",null,null,"确认时间："]
[]
[]
[null,null,"批准人：",null,null,"批准时间："]
[]
[null,"修改版本","修订日期","修改对象","修改内容","申请人","修改人","对应产品","备注"]
[null,"V20210512",20210512,null,null,null,"杨志","机场野生动物智能管理信息系统","人脸识别数据字典初始化"]

{"sheet":"目录","index":1,"n_rows":52,"n_cols":6,"rows_kept":52,"cut":false,"hidden":false,"merged":[[2,1,2,5],[6,1,45,1],[52,1,98,1]]}
[]
[]
[null,"注意：数据库的编码方式为UTF-8(字符集：utf8 -- UTF-8 Unicode ;排序规则：utf8_general_ci）"]
[]
[]
[null,"数据库","编号","表名","中文名","备注"]
[null,"bmp",1,"t_airport_area","机场区域表"]
[null,null,2,"t_airport_area_detail","机场子区域划分详细表"]
[null,null,3,"t_area_device_data","机场子区域内所有设备实时状态汇总表"]
[null,null,4,"t_bird_device_log","驱鸟设备日志"]
[null,null,5,"t_bird_species","鸟种信息表"]
[null,null,6,"t_bird_task","鸟情任务调度计划表"]
[null,null,7,"t_bird_warning","鸟情预警记录"]
[null,null,8,"t_bird_warning_attr","鸟情预警记录附属表"]
[null,null,9,"t_bird_warning_day_data","鸟情预警历史及下阶段预测数据表一天"]
[null,null,10,"t_camera_device_log","摄像机日志"]
[null,null,11,"t_config","系统参数配置"]
[null,null,12,"t_dept","用户部门表"]
[null,null,13,"t_device","设备表"]
[null,null,14,"t_device_data","设备实时状态表"]
[null,null,15,"t_device_use_data","设备使用数据记录表"]
[null,null,16,"t_dict","系统数据字典表"]
[null,null,17,"t_log","系统日志表"]
[null,null,18,"t_menu","系统菜单表"]
[null,null,19,"t_menu_role","菜单与角色关联表"]
[null,null,20,"t_repe_brid_person","驱鸟人员派遣记录表"]
[null,null,21,"t_role","系统角色表"]
[null,null,22,"t_upload_file","上传文件信息日志表"]
[null,null,23,"t_user","系统用户表"]
[null,null,24,"t_user_role","用户与角色关联表"]
[null,null,25]
[null,null,26]
[null,null,27]
[null,null,28]
[null,null,29]
[null,null,30]
[null,null,31]
[null,null,32]
[null,null,33]
[null,null,34]
[null,null,35]
[null,null,36]
[null,null,37]
[null,null,38]
[null,null,39]
[null,null,40]
[]
[]
[]
[]
[]
[null,null,"编号","表名","中文名","备注"]

{"sheet":"驱鸟项目","index":2,"n_rows":936,"n_cols":6,"rows_kept":936,"cut":false,"hidden":false,"merged":[[44,2,44,5],[93,2,93,5],[96,1,96,3],[131,2,131,5],[134,1,134,3],[168,2,168,5],[171,1,171,3],[205,2,205,5],[208,1,208,3],[240,2,240,5],[243,1,243,3],[289,2,289,5],[292,1,292,3],[327,2,327,5],[332,1,332,3],[369,2,369,5],[372,1,372,3],[407,2,407,5],[410,1,410,3],[442,2,442,5],[445,1,445,3],[477,2,477,5],[480,1,480,3],[534,2,534,5],[537,1,537,3],[578,2,578,5],[581,1,581,3],[615,2,615,5],[688,2,688,5],[692,1,692,3],[726,2,726,5],[729,1,729,3],[756,2,756,5],[760,1,760,3],[795,2,795,5],[798,1,798,3],[829,2,829,5],[833,1,833,3],[865,1,865,5],[869,1,869,3],[908,1,908,5],[911,1,911,3],[936,1,936,5],[939,2,939,4],[968,2,968,5],[972,2,972,4],[992,2,992,5],[995,2,995,4],[1019,2,1019,5],[1022,2,1022,4],[1044,2,1044,5],[1047,2,1047,4],[1083,2,1083,5],[1086,2,1086,4],[1106,2,1106,5],[1109,2,1109,4],[1124,2,1124,5],[1127,2,1127,4],[1153,2,1153,5],[1156,2,1156,4],[1185,2,1185,5],[1188,2,1188,4],[1215,2,1215,5],[1218,2,1218,4],[1248,2,1248,5],[1251,2,1251,4],[1272,2,1272,5],[1275,2,1275,4],[1296,2,1296,5],[1299,2,1299,4],[1322,2,1322,5],[1325,2,1325,4],[1348,2,1348,5],[1351,2,1351,4],[1370,2,1370,5],[1373,2,1373,4],[1395,2,1395,5],[1398,2,1398,4],[1438,2,1438,5],[1441,2,1441,4],[1462,2,1462,5],[1465,2,1465,4],[1487,2,1487,5],[1490,2,1490,4],[1517,2,1517,5],[1520,1,1520,3],[1554,2,1554,5],[1557,2,1557,4],[1592,2,1592,5],[947,1,948,1],[980,1,981,1],[1003,1,1004,1],[1030,1,1031,1],[1094,1,1095,1],[1117,1,1118,1],[104,1,105,5],[142,1,143,5],[179,1,180,5],[216,1,217,5],[251,1,252,5],[300,1,301,5],[340,1,341,5],[418,1,419,5],[453,1,454,5],[488,1,489,5],[545,1,546,5],[589,1,590,5],[627,1,628,5],[662,1,663,5],[700,1,701,5],[737,1,738,5],[768,1,769,5],[806,1,807,5],[841,1,842,5],[877,1,878,5],[919,1,920,5],[947,2,948,5],[1003,2,1004,5],[1030,2,1031,5],[1055,1,1056,5],[1135,1,1136,5],[1164,1,1165,5],[1196,1,1197,5],[1226,1,1227,5],[1259,1,1260,5],[1283,1,1284,5],[1307,1,1308,5],[1333,1,1334,5],[1359,1,1360,5],[1381,1,1382,5],[1406,1,1407,5],[1449,1,1450,5],[1473,1,1474,5],[1498,1,1499,5],[1528,1,1529,5],[1565,1,1566,5]]}
[]
[]
[null,1,null,null,"版本号","2021.05.12"]
[null,"t_airport_area","表类型",null,"所在数据库","bmp"]
[null,"机场区域表","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"area_id","主键","bigint(20)","N"]
[null,"name","机场名称","varchar(50)","Y"]
[null,"area_x","区域长度x轴，总米数","int(11)","Y"]
[null,"area_y","区域宽度y轴，总米数","int(11)","Y"]
[null,"area_x_pix","区域长度x轴，总像素数","int(11)","Y"]
[null,"area_y_pix","区域宽度y轴，总像素数","int(11)","Y"]
[null,"col_num","划分区域后x轴总列数","int(11)","Y"]
[null,"row_num","划分区域后y轴总行数","int(11)","Y"]
[null,"spacing_x","划分区域后x轴间距","int(11)","Y"]
[null,"spacing_y","划分区域后y轴间距","int(11)","Y"]
[null,"area_scale","区域比例尺","int(11)","Y"]
[null,"img_base64","机场区域base64码地图，与图片上传字段使用","longtext","Y"]
[null,"upload_id","机场区域上传图片ID","bigint(20)","Y"]
[null,"img_url","机场区域上传图片访问地址","varchar(100)","Y"]
[null,"remark","备注","varchar(500)","Y"]
[null,"order_no","排序顺序号","int(11)","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20)","Y"]
[null,"update_by","更新人","bigint(20)","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"attr1",null,"varchar(3000)","Y"]
[null,"attr2",null,"varchar(3000)","Y"]
[null,"attr3",null,"varchar(3000)","Y"]
[null,"attr4",null,"varchar(3001)","Y"]
[null,"attr5",null,"varchar(3000)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
[]
[null,"索引名称","唯一","聚簇","索引字段","反转"]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","area_id"]
[null,"修改记录"]
[]
[]
[null,2,null,null,"版本号","2021.05.12"]
[null,"t_airport_area_detail","表类型",null,"所在数据库","bmp"]
[null,"机场子区域划分详细表","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[null,"机场子区域划分详细表"]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"area_detail_id","主键","bigint(20)","N","主键"]
[null,"area_id","机场区域主键","bigint(20)","Y"]
[null,"sub_name","机场子区域名称","varchar(50)","Y"]
[null,"upload_id","上传图片ID","bigint(20)","Y"]
[null,"sub_img_url","图片访问地址","varchar(200)","Y"]
[null,"sub_img_base64","机场子区域base64码地图","longtext","Y"]
[null,"start_x","起始坐标x轴","int(11)","Y"]
[null,"start_y","起始坐标y轴","int(11)","Y"]
[null,"end_x","终点坐标x轴","int(11)","Y"]
[null,"end_y","终点坐标y轴","int(11)","Y"]
[null,"sub_col","所在第几列","int(11)","Y"]
[null,"sub_row","所在第几行","int(11)","Y"]
[null,"remark","备注","varchar(500)","Y"]
[null,"order_no","排序顺序号","int(11)","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20)","Y"]
[null,"update_by","更新人","bigint(20)","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"attr1",null,"varchar(200)","Y"]
[null,"attr2",null,"varchar(200)","Y"]
[null,"attr3",null,"varchar(200)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
{"$rows_empty":9}
[null,"索引名称","唯一","聚簇","索引字段","反转"]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","area_detail_id"]
[null,"修改记录"]
[]
[]
[null,3,null,null,"版本号","2021.05.12"]
[null,"t_area_device_data","表类型",null,"所在数据库","bmp"]
[null,"机场子区域内所有设备实时状态汇总表","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[null,"机场子区域内所有设备实时状态汇总表"]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"area_device_data_id","主键","bigint(20)","N","主键"]
[null,"area_id","设备所在区域ID","bigint(20)","Y"]
[null,"area_detail_id","设备所在子区域ID","bigint(20)","Y"]
[null,"monitor_device_status","监控设备状态","int(11)","Y"]
[null,"bird_repe_device_status","驱鸟设备状态","int(11)","Y"]
[null,"bird_warning_num","鸟情报警次数","int(11)","Y"]
[null,"degree","该区域汇总威胁度(0:无威胁，1：小威胁，2：中威胁，3：大威胁)","int(11)","Y"]
[null,"total","同步状态累计计数","int(11)","Y"]
[null,"pre_sync_time","上次实时同步时间","datetime","Y"]
[null,"remark","备注","varchar(200)","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20)","Y"]
[null,"update_by","更新人","bigint(20)","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"attr1",null,"varchar(200)","Y"]
[null,"attr2",null,"varchar(200)","Y"]
[null,"attr3",null,"varchar(200)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
[]
[]
[null,"索引名称",null,"聚簇","索引字段","反转"]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","area_device_data_id"]
[null,"修改记录"]
[]
[]
[null,4,null,null,"版本号","2021.05.12"]
[null,"t_bird_device_log","表类型",null,"所在数据库","bmp"]
[null,"驱鸟设备日志","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[null,"驱鸟设备日志"]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"log_id","主键","bigint(20)","N"]
[null,"device_name","驱鸟设备名称","varchar(50)","Y"]
[null,"device_uuid","驱鸟设备编号","varchar(50)","Y"]
[null,"area_name","所在区域名称","varchar(20)","Y"]
[null,"position","坐标","varchar(50)","Y"]
[null,"status","设备连接状态，（0未连接，1已连接","int(11)","Y"]
[null,"power_status","设备电源状态(0未开启，1已开启)","int(11)","Y"]
[null,"remark","备注","varchar(200)","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20)","Y"]
[null,"update_by","更新人","bigint(20)","Y"]
[null,"enable_flag","启用标志（0,1）","int(11","Y"]
[null,"attr1",null,"varchar(200)","Y"]
[null,"attr2",null,"varchar(200)","Y"]
[null,"attr3",null,"varchar(200)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
[]
[]
[]
[null,"索引名称","唯一","聚簇","索引字段","反转"]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","log_id"]
[null,"修改记录"]
[]
[]
[null,5,null,null,"版本号","2021.05.12"]
[null,"t_bird_species","表类型",null,"所在数据库","bmp"]
[null,"鸟种信息表","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[null,"鸟种信息表"]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"bird_id","主键","bigint(20)","N","主键"]
[null,"bird_name","鸟名称","varchar(20)","Y"]
[null,"bird_type","鸟类型或物种","varchar(20)","Y"]
[null,"bird_habits","鸟生活习性","varchar(50)","Y"]
[null,"degree","威胁度","varchar(20)","Y"]
[null,"upload_id","上传图片ID,多个逗号隔开"," varchar(100)","Y"]
[null,"bird_img_url","鸟样例图片,多个逗号隔开","varchar(1000)","Y"]
[null,"remark","备注-鸟详情","varchar(5000)","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20)","Y"]
[null,"update_by","更新人","bigint(20)","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"attr1",null,"varchar(200)","Y"]
[null,"attr2",null,"varchar(200)","Y"]
[null,"attr3",null,"varchar(200)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
[]
[]
[]
[null,"索引名称","唯一","聚簇","索引字段","反转"]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","bird_id"]
[null,"修改记录"]
[]
[]
[null,6,null,null,"版本号","2021.05.12"]
[null,"t_bird_task","表类型",null,"所在数据库","bmp"]
[null,"鸟情任务调度计划表","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[null,"鸟情任务调度计划表"]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"task_id","主键","bigint(20)","N"]
[null,"ip","调度服务IP","varchar(20)","Y"]
[null,"port","调度服务端口","varchar(20)","Y"]
[null,"dv_ids","调度的设备ID,多个逗号隔开","varchar(200)","Y"]
[null,"job_time","服务启动后，第一次开始调度时间","datetime","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20)","Y"]
[null,"update_by","更新人","bigint(20)","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"attr1",null,"varchar(200)","Y"]
[null,"attr2",null,"varchar(200)","Y"]
[null,"attr3",null,"varchar(200)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
[]
[]
[]
[]
[null,"索引名称","唯一","聚簇","索引字段","反转"]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","task_id"]
[null,"修改记录"]
[]
[]
[null,7,null,null,"版本号","2021.05.12"]
[null,"t_bird_warning","表类型",null,"所在数据库","bmp"]
[null,"鸟情预警记录","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[null,"鸟情预警记录"]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"warning_id","主键","bigint(20)","N","主键"]
[null,"dv_id","设备ID","bigint(20)","Y"]
[null,"device_uuid","抓拍设备标识","varchar(50)","Y"]
[null,"area_id","设备所在区域ID","bigint(20)","Y"]
[null,"area_detail_id","设备所在子区域ID","bigint(20)","Y"]
[null,"bird_type","鸟类别","varchar(20)","Y"]
[null,"bird_behavior","鸟行为","varchar(50)","Y"]
[null,"bird_num","鸟数量","int(11)","Y"]
[null,"bird_num_range","鸟数量范围","varchar(50)","Y"]
[null,"degree","威胁度"," int(11)","Y"]
[null,"repe_status","驱鸟状态"," int(11)","Y"]
[null,"height_range","高度范围","varchar(50)","Y"]
[null,"upload_id","上次图片ID","bigint(20)","Y"]
[null,"bird_img_url","鸟情图片地址","varchar(200)","Y"]
[null,"source","预警来源","int(11)","Y"]
[null,"remark","备注","varchar(500)","Y"]
[null,"warning_time","预警时间","datetime","Y"]
[null,"warning_date","预警日期，yyyy-MM-dd","varchar(20)","Y"]
[null,"warning_month","预警所在月份","varchar(20)","Y"]
[null,"warning_hour","预警小时段","varchar(20)","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20)","Y"]
[null,"update_by","更新人","bigint(20)","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"attr1",null,"varchar(200)","Y"]
[null,"attr2",null,"varchar(200)","Y"]
[null,"attr3",null,"varchar(200)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
[]
[]
[]
[null,"索引名称","唯一","聚簇","索引字段","反转"]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","warning_id"]
[null,"修改记录"]
[]
[]
[null,8,null,null,"版本号","2021.05.12"]
[null,"t_bird_warning_attr","表类型",null,"所在数据库","bmp"]
[null,"鸟情预警记录附属表","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[null,"设备信息"]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"warning_attr_id","主键","bigint(20)","N"]
[null,"warning_id","主库ID","bigint(20)","Y"]
[null,"bird_img_base64","鸟情图片64码","longtext","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20)","Y"]
[null,"update_by","更新人","bigint(20)","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"attr1",null,"varchar(200)","Y"]
[null,"attr2",null,"varchar(200)","Y"]
[null,"attr3",null,"varchar(200)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
{"$rows_empty":10}
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","warning_attr_id"]
[null,"修改记录"]
[]
[]
[]
[]
[null,9,null,null,"版本号","2021.05.12"]
[null,"t_bird_warning_day_data","表类型",null,"所在数据库","bmp"]
[null,"鸟情预警历史及下阶段预测数据表一天","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[null,"鸟情预警历史及下阶段预测数据表一天"]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"warning_day_id","主键","bigint(20)","N"]
[null,"year_str","驱鸟时间-年份","varchar(10)","Y"]
[null,"month_str","驱鸟时间-月份","varchar(10)","Y"]
[null,"week_str","驱鸟时间-当年所在周数","varchar(10)","Y"]
[null,"day_str","驱鸟时间-天","varchar(10)","Y"]
[null,"area_id","区域ID","bigint(20)","Y"]
[null,"area_detail_id","子区域ID","bigint(20)","Y"]
[null,"bird_num","鸟数量","int(11)","Y"]
[null,"degree","威胁度","int(11)","Y"]
[null,"type","驱赶方式","int(11)","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20)","Y"]
[null,"update_by","更新人","bigint(20)","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"attr1",null,"varchar(200)","Y"]
[null,"attr2",null,"varchar(200)","Y"]
[null,"attr3",null,"varchar(200)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
[]
[]
[]
[]
[null,"索引名称","唯一","聚簇","索引字段","反转"]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","warning_day_id"]
[null,"修改记录"]
[]
[]
[null,10,null,null,"版本号","2021.05.12"]
[null,"t_camera_device_log","表类型",null,"所在数据库","bmp"]
[null,"摄像机日志","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[null,"摄像机日志"]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"log_id","主键","bigint(20)","N"]
[null,"device_name","抓拍设备名称","varchar(50)","Y"]
[null,"device_uuid","抓拍设备编号","varchar(50)","Y"]
[null,"local_ip","抓拍设备IP","varchar(50)","Y"]
[null,"area_name","所在区域名称","varchar(50)","Y"]
[null,"position","坐标","varchar(50)","Y"]
[null,"status","设备连接状态，（0未连接，1已连接）","int(11)","Y"]
[null,"remark1","操作记录","varchar(500)","Y"]
[null,"remark2","报警记录","varchar(200)","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20)","Y"]
[null,"update_by","更新人","bigint(20)","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"attr1",null,"varchar(200)","Y"]
[null,"attr2",null,"varchar(200)","Y"]
[null,"attr3",null,"varchar(200)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
[]
[]
[]
[null,"索引名称","唯一","聚簇","索引字段","反转"]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","log_id"]
[null,"修改记录"]
[]
[]
[null,11,null,null,"版本号","2021.05.12"]
[null,"t_config","表类型",null,"所在数据库","bmp"]
[null,"系统参数配置","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[null,"系统参数配置"]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"config_id","主键","bigint(20)","N"]
[null,"con_key","参数key","varchar(100)","Y"]
[null,"con_value","参数value","varchar(500)","Y"]
[null,"active","参数环境标识，1dev 2test 3prod","int(11)","Y"]
[null,"remark","备注","varchar(200)","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20)","Y"]
[null,"update_by","更新人","bigint(20)","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"attr1",null,"varchar(200)","Y"]
[null,"attr2",null,"varchar(200)","Y"]
[null,"attr3",null,"varchar(200)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
[]
[]
[]
[]
[null,"索引名称","唯一","聚簇","索引字段","反转"]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","config_id"]
[null,"修改记录"]
[]
[]
[null,12,null,null,"Y","2021.05.12"]
[null,"t_dept","表类型",null,"所在数据库","bmp"]
[null,"用户部门表","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[null,"用户部门表"]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"dept_id","主键","bigint(20)","N"]
[null,"parent_dept_code","上级部门编号","varchar(50)","Y"]
[null,"dept_code","部门编号","varchar(50)","Y"]
[null,"dept_name","部门名称","varchar(50)","Y"]
[null,"order_no","排序号","int(11)","Y"]
[null,"remark","备注","varchar(200)","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20)","Y"]
[null,"update_by","更新人","bigint(20)","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"attr1",null,"varchar(200)","Y"]
[null,"attr2",null,"varchar(200)","Y"]
[null,"attr3",null,"varchar(200)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
[]
[]
[]
[null,"索引名称","唯一","聚簇","索引字段","反转"]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","dept_id"]
[null,"修改记录"]
[]
[]
[null,13,null,null,"Y","2021.05.12"]
[null,"t_device","表类型",null,"所在数据库","bmp"]
[null,"设备表","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[null,"设备表"]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"dv_id","主键","bigint(20)","N"]
[null,"parent_dv_id","关联上层设备ID","bigint(20)","Y"]
[null,"link_dv_id","关联联动驱鸟设备ID","bigint(20)","Y"]
[null,"area_id","设备所在区域ID","bigint(20)","Y"]
[null,"area_detail_id","设备所在子区域ID","bigint(20)","Y"]
[null,"device_type","设备类型，父类","int(11)","Y"]
[null,"device_sub_type","设备类型，子类","int(11)","Y"]
[null,"device_control_type","设备控制类型-即根据厂商区分","int(11)","Y"]
[null,"device_source","设备来源，用于业务区分使用场景","int(11)","Y"]
[null,"device_uuid","设备唯一标识"," varchar(50)","Y"]
[null,"device_num","设备编号"," varchar(50)","Y"]
[null,"bird_device_code","驱鸟设备标识","varchar(20)","Y"]
[null,"device_name","设备名称","varchar(50)","Y"]
[null,"device_user_name","设备用户名","varchar(20)","Y"]
[null,"device_pass_word","设备密码","varchar(20)","Y"]
[null,"local_ip","设备ip地址","varchar(20)","Y"]
[null,"port","设备HTTP端口","int(11)","Y"]
[null,"device_mac","设备mac地址","varchar(20)","Y"]
[null,"stream","设备码流","varchar(200)","Y"]
[null,"place","设备地点","varchar(200)","Y"]
[null,"longitude","设备地点-经度","varchar(20)","Y"]
[null,"latitude","设备地点-纬度","varchar(20)","Y"]
[null,"co_x","设备坐标x轴","varchar(20)","Y"]
[null,"co_y","设备坐标y轴","varchar(20)","Y"]
[null,"co_z","设备坐标z轴","varchar(20)","Y"]
[null,"upload_id","设备图片上传图片ID","bigint(20)","Y"]
[null,"img_url","机场区域上传图片访问地址","varchar(100)","Y"]
[null,"remark","备注","varchar(500)","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20)","Y"]
[null,"update_by","更新人","bigint(20)","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"attr1",null,"varchar(200)","Y"]
[null,"attr2",null,"varchar(200)","Y"]
[null,"attr3",null,"varchar(200)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
[]
[]
[]
[null,"索引名称","唯一","聚簇","索引字段","反转"]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","dv_id"]
[null,"修改记录"]
[]
[]
[null,14,null,null,"Y","2021.05.12"]
[null,"t_device_data","表类型",null,"所在数据库","bmp"]
[null,"设备实时状态表","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[null,"识别记录信息"]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"data_id","主键","bigint(20)","N"]
[null,"dv_id","设备ID","bigint(20)","Y"]
[null,"area_id","设备所在区域ID","bigint(20)","Y"]
[null,"area_detail_id","设备所在子区域ID","bigint(20)","Y"]
[null,"status","设备连接状态，（0未连接，1已连接）","int(11)","Y"]
[null,"work_status","设备工作状态，（0未工作，1工作中）","int(11)","Y"]
[null,"power_status","设备电源状态(0未开启，1已开启)","int(11)","Y"]
[null,"battery_status","设备电池状态（0异常，1正常）","int(11)","Y"]
[null,"num","可使用次数或剩余弹数","int(11)","Y"]
[null,"oxy_pressure","氧气压力，单位kpa","int(11)","Y"]
[null,"gas_pressure","煤气压力，单位kpa","int(11)","Y"]
[null,"total","实时同步累计计数","int(11)","Y"]
[null,"pre_sync_time","上次实时同步时间","datetime","Y"]
[null,"remark","备注","varchar(200)","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20)","Y"]
[null,"update_by","更新人","bigint(20)","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"attr1",null,"varchar(200)","Y"]
[null,"attr2",null,"varchar(200)","Y"]
[null,"attr3",null,"varchar(200)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
[]
[]
[]
[]
[null,"索引名称","唯一","聚簇","索引字段","反转"]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","data_id"]
[null,"修改记录"]
[]
[]
[null,15,null,null,"Y","2021.05.12"]
[null,"t_device_use_data","表类型",null,"所在数据库","bmp"]
[null,"设备使用数据记录表","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[null,"设备使用数据记录表"]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"use_data_id","主键","bigint(20)","N"]
[null,"dv_id","设备ID","bigint(20)","Y"]
[null,"area_id","设备所在区域ID","bigint(20)","Y"]
[null,"area_detail_id","设备所在子区域ID","bigint(20)","Y"]
[null,"type","使用方式","int(11)","Y"]
[null,"hour","使用时长，单位小时，设备类型为驱鸟音波炮专用字段","int(11)","Y"]
[null,"result","使用结果","int(11)","Y"]
[null,"remark","备注","varchar(200)","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20)","Y"]
[null,"update_by","更新人","bigint(20)","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"attr1",null,"varchar(200)","Y"]
[null,"attr2",null,"varchar(200)","Y"]
[null,"attr3",null,"varchar(200)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
[]
[]
[]
[null,"索引名称","唯一","聚簇","索引字段","反转"]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","use_data_id"]
[null,"修改记录"]
[]
[]
[]
[null,16,null,null,"Y","2021.05.12"]
[null,"t_dict","表类型",null,"所在数据库","bmp"]
[null,"系统数据字典表","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[null,"系统数据字典表"]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"dict_id","主键","bigint(20)","N"]
[null,"dict_type","数据字典类型(1字典分组,2数据字典)","int(11)","Y"]
[null,"dict_name","数据字典名称","varchar(50)","Y"]
[null,"parent_dict_code","上级数据字典编号","varchar(50)","Y"]
[null,"dict_code","数据字典编号","varchar(50)","Y"]
[null,"order_no","序号","int(11)","Y"]
[null,"remark","备注","varchar(200)","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint","Y"]
[null,"update_by","更新人","bigint","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"attr1",null,"varchar(200)","Y"]
[null,"attr2",null,"varchar(200)","Y"]
[null,"attr3",null,"varchar(200)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
[]
[]
[null,"索引名称","唯一","聚簇","索引字段","反转"]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","dict_id"]
[null,"修改记录"]
[]
[]
[null,17,null,null,"版本号","2021.05.12"]
[null,"t_log","表类型",null,"所在数据库","bmp"]
[null,"系统日志表","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[null,"系统日志表"]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"log_id","主键","bigint(20)","N"]
[null,"log_type","日志类型","int(11)","Y"]
[null,"ip",null," varchar(20)","Y"]
[null,"url",null,"varchar(500)","Y"]
[null,"param",null,"varchar(500)","Y"]
[null,"content","日志详情","varchar(500)","Y"]
[null,"remark","备注","varchar(500)","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20)","Y"]
[null,"update_by","更新人","bigint(20)","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"attr1",null,"varchar(200)","Y"]
[null,"attr2",null,"varchar(200)","Y"]
[null,"attr3",null,"varchar(200)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
[]
[]
[]
[]
[]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","log_id"]
[null,"修改记录"]
[]
[]
[]
[null,18,null,null,"版本号","2021.05.12"]
[null,"t_menu","表类型",null,"所在数据库","bmp"]
[null,"系统菜单表","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[null,"系统菜单表"]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"menu_id","主键","bigint(20)","N"]
[null,"menu_type","菜单类型(1代表菜单、2代表功能)","int(11)","Y"]
[null,"menu_name","菜单名称","varchar(50)","Y"]
[null,"parent_menu_code","上级菜单编号","varchar(50)","Y"]
[null,"menu_code","菜单编号","varchar(50)","Y"]
[null,"menu_url","菜单链接","varchar(200)","Y"]
[null,"menu_img_url","菜单图标url","varchar(200)","Y"]
[null,"order_no","菜单排序号","int(11)","Y"]
[null,"remark","备注","varchar(200)","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20)","Y"]
[null,"update_by","更新人","bigint(20)","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"attr1",null,"varchar(200)","Y"]
[null,"attr2",null,"varchar(200)","Y"]
[null,"attr3",null,"varchar(200)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
[]
[]
[null,"索引名称","唯一","聚簇","索引字段","反转"]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","menu_id"]
[null,"修改记录"]
[]
[]
[null,19,null,null,"版本号","2021.05.12"]
[null,"t_menu_role","表类型",null,"所在数据库","bmp"]
[null,"菜单与角色关联表","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[null,"菜单与角色关联表"]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"ref_id","主键","bigint(20)","N"]
[null,"menu_id","菜单ID","bigint(20)","Y"]
[null,"role_id","角色ID","bigint(20)","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20)","Y"]
[null,"update_by","更新人","bigint(20)","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
[]
[]
[]
[]
[null,"索引名称","唯一","聚簇","索引字段","反转"]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","ref_id"]
[null,"修改记录"]
[]
[]
[]
[null,20,null,null,"版本号","2021.05.12"]
[null,"t_repe_brid_person","表类型",null,"所在数据库","bmp"]
[null,"驱鸟人员派遣记录表","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[null,"驱鸟人员派遣记录表"]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"use_data_id","主键","bigint(20)","N"]
[null,"dv_id","报警设备ID","bigint(20)","Y"]
[null,"area_id","设备所在区域ID","bigint(20)","Y"]
[null,"area_detail_id","设备所在子区域ID","bigint(20)","Y"]
[null,"user_id","派遣人员即用户ID","bigint(20)","Y"]
[null,"msg",null,"varchar(200)","Y"]
[null,"dv_exc_type","正常-0，设备连接失败-1，设备未工作-2，设备电源未开启-3，设备电池异常-4，使用次数或剩余弹数不足-5","int(11)","Y"]
[null,"msg_status","派遣消息通知发送状态","int(11)","Y"]
[null,"result","派遣处理结果(0：未处理，1：处理成功，2：处理失败)","int(11)","Y"]
[null,"result_msg","派遣处理结果详细信息","varchar(200)","Y"]
[null,"remark","备注","varchar(200)","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20)","Y"]
[null,"update_by","更新人","bigint(20)","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"attr1",null,"varchar(200)","Y"]
[null,"attr2",null,"varchar(200)","Y"]
[null,"attr3",null,"varchar(200)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
[]
[null,"索引名称","唯一","聚簇","索引字段","反转"]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","use_data_id"]
[null,"修改记录"]
[]
[]
[null,21,null,null,"版本号","2021.05.12"]
[null,"t_role","表类型",null,"所在数据库","bmp"]
[null,"系统角色表","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[null,"系统角色表"]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"role_id","主键","bigint(20)","N"]
[null,"ole_name","用户名","varchar(50)","Y"]
[null,"role_code","用户类型","varchar(50)","Y"]
[null,"remark","备注","varchar(200)","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20)","Y"]
[null,"update_by","更新人","bigint(20)","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"attr1",null,"varchar(200)","Y"]
[null,"attr2",null,"varchar(200)","Y"]
[null,"attr3",null,"varchar(200)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
[]
[]
[]
[]
[null,"索引名称","唯一","聚簇","索引字段","反转"]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","role_id"]
[null,"修改记录"]
[]
[]
[]
[null,22,null,null,"版本号","2021.05.12"]
[null,"t_upload_file","表类型",null,"所在数据库","bmp"]
[null,"上传文件信息日志表","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"upload_id","主键","bigint(20)","N"]
[null,"uuid","文件唯一标识","varchar(50)","Y"]
[null,"file_type","文件类型（1图片2视频）","int(11)","Y"]
[null,"file_url","图片访问地址","varchar(500)","Y"]
[null,"file_path","文件本地路径","varchar(500)","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20)","Y"]
[null,"update_by","更新人","bigint(20)","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"user_id","上传用户Id","bigint(20)","Y"]
[null,"source","上传来源(1前台用户、2后台用户)","int(11)","Y"]
[null,"attr1",null,"varchar(200)","Y"]
[null,"attr2",null,"varchar(200)","Y"]
[null,"attr3",null,"varchar(200)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
[]
[]
[null,"索引名称","唯一","聚簇","索引字段","反转"]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","upload_id"]
[]
[null,"修改记录"]
[]
[]
[null,23,null,null,"版本号","2021.05.12"]
[null,"t_user","表类型",null,"所在数据库","bmp"]
[null,"系统用户表","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[null,"系统用户表"]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"user_id","主键","bigint(20)","N"]
[null,"dept_id","所属部门","bigint(20)","Y"]
[null,"user_name","用户名","varchar(50)","Y"]
[null,"user_type","用户类型","int(11)","Y"]
[null,"name","姓名","varchar(30)","Y"]
[null,"mobile","手机号","varchar(20)","Y"]
[null,"email","邮箱","varchar(50)","Y"]
[null,"img_url","头像","varchar(200)","Y"]
[null,"status","用户状态","int(11)","Y"]
[null,"line_status","在线状态","int(11)","Y"]
[null,"nick_name","昵称","varchar(30)","Y"]
[null,"pwd","密码","varchar(100) ","Y"]
[null,"user_code","工号","varchar(20)","Y"]
[null,"qr_code","专属二维码","varchar(20)","Y"]
[null,"remark","备注","varchar(200)","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20)","Y"]
[null,"update_by","更新人","bigint(20)","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"attr1",null,"varchar(200)","Y"]
[null,"attr2",null,"varchar(200)","Y"]
[null,"attr3",null,"varchar(200)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
[]
[null,"索引名称","唯一","聚簇","索引字段","反转"]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","user_id"]
[]
[]
[]
[null,24,null,null,"版本号","2021.05.12"]
[null,"t_user_role","表类型",null,"所在数据库","bmp"]
[null,"用户与角色关联表","是否自定义表分区"]
[null,null,"分区个数",null,"分区开始日期"]
[null,null,"存在冗余表",null,"存在清算表"]
[null,null,"清算索引表空间",null,"归档表空间"]
[null,null,"索引表空间",null,"归档索引表空间"]
[null,null,"清算表空间"]
[null,"用户与角色关联表"]
[]
[null,"字段名","中文名","字段类型","空值","备注"]
[null,"ref_id","主键","bigint(20)","N"]
[null,"user_id","用户ID","bigint(20)","Y"]
[null,"role_id","角色ID","bigint(20)","Y"]
[null,"add_time","添加时间","datetime","Y"]
[null,"update_time","更新时间","datetime","Y"]
[null,"create_by","创建人","bigint(20","Y"]
[null,"update_by","更新人","bigint(20","Y"]
[null,"enable_flag","启用标志（0,1）","int(11)","Y"]
[null,"app_id","APP应用标志","int(11)","Y"]
[]
[]
[null,"索引名称","唯一","聚簇","索引字段","反转"]
[null,"名称","类型","字段列表","外键参照表","外键参照列"]
[null,null,"主键","ref_id"]