{"text_format":"3","workbook":"xls","n_sheets":23,"sheets":["Cover","Change Tracking","List of sheets","Diagram","gen_scheme","gen_table","gen_table_column","gen_template","gen_scheme_del_flag","gen_table_name","gen_table_del_flag","gen_table_column_table_id","gen_table_column_name","gen_table_column_sort","gen_table_column_del_flag","gen_template_del_falg","all attributes","Tables in no category","all tables","all indices","all sequences","all view","all trigger"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Cover","index":0,"n_rows":7,"n_cols":3,"rows_kept":7,"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[null,null,"Table definition book"]

{"sheet":"Change Tracking","index":1,"n_rows":3,"n_cols":2,"rows_kept":3,"flags":["formulas_cached_only"]}
["Change Tracking"]
[]
["DATE","Contents of change"]

{"sheet":"List of sheets","index":2,"n_rows":25,"n_cols":3,"rows_kept":25,"flags":["formulas_cached_only"]}
["List of sheets"]
[]
["Type","Name","Description"]
["Other","Cover",""]
["Other","Change Tracking",""]
["Other","sheet_index_template",""]
["Other","Diagram",""]
["Table","gen_scheme","生成方案"]
["Table","gen_table","业务表"]
["Table","gen_table_column","业务表字段"]
["Table","gen_template","代码模板表"]
["Index","gen_scheme_del_flag",""]
["Index","gen_table_name",""]
["Index","gen_table_del_flag",""]
["Index","gen_table_column_table_id",""]
["Index","gen_table_column_name",""]
["Index","gen_table_column_sort",""]
["Index","gen_table_column_del_flag",""]
["Index","gen_template_del_falg",""]
["List","all attributes",""]
["List","all tables",""]
["List","all indices",""]
["List","all sequences",""]
["List","all view",""]
["List","all trigger",""]

{"sheet":"Diagram","index":3,"n_rows":2,"n_cols":2,"rows_kept":2,"flags":["formulas_cached_only"]}
[]
[null,""]

{"sheet":"gen_scheme","index":4,"n_rows":74,"n_cols":13,"rows_kept":74,"merged":[[0,1,0,12],[1,1,1,12],[2,1,2,12],[3,1,3,12],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[23,8,23,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)","生成方案"]
["Table name (physical name)","gen_scheme"]
["Description","生成方案"]
["Constraint",""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["名称","name","nvarchar2(n)",200,""," ","",""," ","","","","名称"]
["分类","category","varchar2(n)",2000,""," ","",""," ","","","","分类"]
["生成包路径","package_name","varchar2(n)",500,""," ","",""," ","","","","生成包路径"]
["生成模块名","module_name","varchar2(n)",30,""," ","",""," ","","","","生成模块名"]
["生成子模块名","sub_module_name","varchar2(n)",30,""," ","",""," ","","","","生成子模块名"]
["生成功能名","function_name","nvarchar2(n)",500,""," ","",""," ","","","","生成功能名"]
["生成功能名（简写）","function_name_simple","nvarchar2(n)",100,""," ","",""," ","","","","生成功能名（简写）"]
["生成功能作者","function_author","nvarchar2(n)",100,""," ","",""," ","","","","生成功能作者"]
["生成表编号","gen_table_id","varchar2(n)",200,""," ","",""," ","","","","生成表编号"]
["创建者","create_by","varchar2(n)",64,""," ","",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"gen_scheme_del_flag"]
["id"]
["name"]
["category"]
["package_name"]
["module_name"]
["sub_module_name"]
["function_name"]
["function_name_simple"]
["function_author"]
["gen_table_id"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",1]
[]
[]
[null,"gen_scheme_del_flag"]
["编号"]
["名称"]
["分类"]
["生成包路径"]
["生成模块名"]
["生成子模块名"]
["生成功能名"]
["生成功能名（简写）"]
["生成功能作者"]
["生成表编号"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]

{"sheet":"gen_table","index":5,"n_rows":62,"n_cols":13,"rows_kept":62,"merged":[[0,1,0,12],[1,1,1,12],[2,1,2,12],[3,1,3,12],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[19,8,19,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)","业务表"]
["Table name (physical name)","gen_table"]
["Description","业务表"]
["Constraint",""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["名称","name","nvarchar2(n)",200,""," ","",""," ","","","","名称"]
["描述","comments","nvarchar2(n)",500,""," ","",""," ","","","","描述"]
["实体类名称","class_name","varchar2(n)",100,""," ","",""," ","","","","实体类名称"]
["关联父表","parent_table","varchar2(n)",200,""," ","",""," ","","","","关联父表"]
["关联父表外键","parent_table_fk","varchar2(n)",100,""," ","",""," ","","","","关联父表外键"]
["创建者","create_by","varchar2(n)",64,""," ","",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"gen_table_name","gen_table_del_flag"]
["id"]
["name",1]
["comments"]
["class_name"]
["parent_table"]
["parent_table_fk"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",null,1]
[]
[]
[null,"gen_table_name","gen_table_del_flag"]
["编号"]
["名称",1]
["描述"]
["实体类名称"]
["关联父表"]
["关联父表外键"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",null,1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]

{"sheet":"gen_table_column","index":6,"n_rows":99,"n_cols":13,"rows_kept":99,"merged":[[0,1,0,12],[1,1,1,12],[2,1,2,12],[3,1,3,12],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[22,8,22,9],[23,8,23,9],[24,8,24,9],[25,8,25,9],[26,8,26,9],[27,8,27,9],[28,8,28,9],[29,8,29,9],[31,8,31,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)","业务表字段"]
["Table name (physical name)","gen_table_column"]
["Description","业务表字段"]
["Constraint",""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["归属表编号","gen_table_id","varchar2(n)",64,""," ","","","-> 业务表.编号","","","","归属表编号"]
["名称","name","nvarchar2(n)",200,""," ","",""," ","","","","名称"]
["描述","comments","nvarchar2(n)",500,""," ","",""," ","","","","描述"]
["JDBC类型","jdbc_type","varchar2(n)",100,""," ","",""," ","","","","列的数据类型的字节长度"]
["JAVA类型","java_type","varchar2(n)",500,""," ","",""," ","","","","JAVA类型"]
["JAVA字段名","java_field","varchar2(n)",200,""," ","",""," ","","","","JAVA字段名"]
["是否主键","is_pk","char(n)",1,""," ","",""," ","","","","是否主键"]
["是否可为空","is_null","char(n)",1,""," ","",""," ","","","","是否可为空"]
["是否为插入字段","is_insert","char(n)",1,""," ","",""," ","","","","是否为插入字段"]
["是否编辑字段","is_edit","char(n)",1,""," ","",""," ","","","","是否编辑字段"]
["是否列表字段","is_list","char(n)",1,""," ","",""," ","","","","是否列表字段"]
["是否查询字段","is_query","char(n)",1,""," ","",""," ","","","","是否查询字段"]
["查询方式","query_type","varchar2(n)",200,""," ","",""," ","","","","查询方式（等于、不等于、大于、小于、范围、左LIKE、右LIKE、左右LIKE）"]
["显示类型","show_type","varchar2(n)",200,""," ","",""," ","","","","字段生成方案（文本框、文本域、下拉框、复选框、单选框、字典选择、人员选择、部门选择、区域选择）"]
["字典类型","dict_type","varchar2(n)",200,""," ","",""," ","","","","字典类型"]
["其它设置","settings","nvarchar2(n)",2000,""," ","",""," ","","","","其它设置（扩展字段JSON）"]
["排序（升序）","sort","number","",""," ","",""," ","","","","排序（升序）"]
["创建者","create_by","varchar2(n)",64,""," ","",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"gen_table_column_table_id","gen_table_column_name","gen_table_column_sort","gen_table_column_del_flag"]
["id"]
["gen_table_id",1]
["name",null,1]
["comments"]
["jdbc_type"]
["java_type"]
["java_field"]
["is_pk"]
["is_null"]
["is_insert"]
["is_edit"]
["is_list"]
["is_query"]
["query_type"]
["show_type"]
["dict_type"]
["settings"]
["sort",null,null,1]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",{"$nulls":3},1]
[]
[]
[null,"gen_table_column_table_id","gen_table_column_name","gen_table_column_sort","gen_table_column_del_flag"]
["编号"]
["归属表编号",1]
["名称",null,1]
["描述"]
["JDBC类型"]
["JAVA类型"]
["JAVA字段名"]
["是否主键"]
["是否可为空"]
["是否为插入字段"]
["是否编辑字段"]
["是否列表字段"]
["是否查询字段"]
["查询方式"]
["显示类型"]
["字典类型"]
["其它设置"]
["排序（升序）",null,null,1]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",{"$nulls":3},1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
["归属表编号","gen_table_id","gen_table","id"]

{"sheet":"gen_template","index":7,"n_rows":62,"n_cols":13,"rows_kept":62,"merged":[[0,1,0,12],[1,1,1,12],[2,1,2,12],[3,1,3,12],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[19,8,19,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)","代码模板表"]
["Table name (physical name)","gen_template"]
["Description","代码模板表"]
["Constraint",""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["名称","name","nvarchar2(n)",200,""," ","",""," ","","","","名称"]
["分类","category","varchar2(n)",2000,""," ","",""," ","","","","分类"]
["生成文件路径","file_path","varchar2(n)",500,""," ","",""," ","","","","生成文件路径"]
["生成文件名","file_name","varchar2(n)",200,""," ","",""," ","","","","生成文件名"]
["内容","content","clob","",""," ","",""," ","","","","内容"]
["创建者","create_by","varchar2(n)",64,""," ","",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"gen_template_del_falg"]
["id"]
["name"]
["category"]
["file_path"]
["file_name"]
["content"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",1]
[]
[]
[null,"gen_template_del_falg"]
["编号"]
["名称"]
["分类"]
["生成文件路径"]
["生成文件名"]
["内容"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]

{"sheet":"gen_scheme_del_flag","index":8,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","gen_scheme_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","gen_scheme"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]

{"sheet":"gen_table_name","index":9,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","gen_table_name"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","gen_table"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"名称","name"]

{"sheet":"gen_table_del_flag","index":10,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","gen_table_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","gen_table"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]

{"sheet":"gen_table_column_table_id","index":11,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","gen_table_column_table_id"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","gen_table_column"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"归属表编号","gen_table_id"]

{"sheet":"gen_table_column_name","index":12,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","gen_table_column_name"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","gen_table_column"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"名称","name"]

{"sheet":"gen_table_column_sort","index":13,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","gen_table_column_sort"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","gen_table_column"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"排序（升序）","sort"]

{"sheet":"gen_table_column_del_flag","index":14,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","gen_table_column_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","gen_table_column"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]

{"sheet":"gen_template_del_falg","index":15,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","gen_template_del_falg"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","gen_template"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]

{"sheet":"all attributes","index":16,"n_rows":65,"n_cols":14,"rows_kept":65,"flags":["formulas_cached_only"]}
["Table name\n(logical name)","Table name\n(physical name)","Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK","Auto increment","Default value","Description"]
["生成方案","gen_scheme","编号","id","varchar2(n)",64,"","* ","*",""," ","","","编号"]
["生成方案","gen_scheme","名称","name","nvarchar2(n)",200,""," ","",""," ","","","名称"]
["生成方案","gen_scheme","分类","category","varchar2(n)",2000,""," ","",""," ","","","分类"]
["生成方案","gen_scheme","生成包路径","package_name","varchar2(n)",500,""," ","",""," ","","","生成包路径"]
["生成方案","gen_scheme","生成模块名","module_name","varchar2(n)",30,""," ","",""," ","","","生成模块名"]
["生成方案","gen_scheme","生成子模块名","sub_module_name","varchar2(n)",30,""," ","",""," ","","","生成子模块名"]
["生成方案","gen_scheme","生成功能名","function_name","nvarchar2(n)",500,""," ","",""," ","","","生成功能名"]
["生成方案","gen_scheme","生成功能名（简写）","function_name_simple","nvarchar2(n)",100,""," ","",""," ","","","生成功能名（简写）"]
["生成方案","gen_scheme","生成功能作者","function_author","nvarchar2(n)",100,""," ","",""," ","","","生成功能作者"]
["生成方案","gen_scheme","生成表编号","gen_table_id","varchar2(n)",200,""," ","",""," ","","","生成表编号"]
["生成方案","gen_scheme","创建者","create_by","varchar2(n)",64,""," ","",""," ","","","创建者"]
["生成方案","gen_scheme","创建时间","create_date","timestamp","",""," ","",""," ","","","创建时间"]
["生成方案","gen_scheme","更新者","update_by","varchar2(n)",64,""," ","",""," ","","","更新者"]
["生成方案","gen_scheme","更新时间","update_date","timestamp","",""," ","",""," ","","","更新时间"]
["生成方案","gen_scheme","备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","备注信息"]
["生成方案","gen_scheme","删除标记","del_flag","char(n)",1,""," ","*",""," ","",0,"删除标记（0：正常；1：删除）"]
["业务表","gen_table","编号","id","varchar2(n)",64,"","* ","*",""," ","","","编号"]
["业务表","gen_table","名称","name","nvarchar2(n)",200,""," ","",""," ","","","名称"]
["业务表","gen_table","描述","comments","nvarchar2(n)",500,""," ","",""," ","","","描述"]
["业务表","gen_table","实体类名称","class_name","varchar2(n)",100,""," ","",""," ","","","实体类名称"]
["业务表","gen_table","关联父表","parent_table","varchar2(n)",200,""," ","",""," ","","","关联父表"]
["业务表","gen_table","关联父表外键","parent_table_fk","varchar2(n)",100,""," ","",""," ","","","关联父表外键"]
["业务表","gen_table","创建者","create_by","varchar2(n)",64,""," ","",""," ","","","创建者"]
["业务表","gen_table","创建时间","create_date","timestamp","",""," ","",""," ","","","创建时间"]
["业务表","gen_table","更新者","update_by","varchar2(n)",64,""," ","",""," ","","","更新者"]
["业务表","gen_table","更新时间","update_date","timestamp","",""," ","",""," ","","","更新时间"]
["业务表","gen_table","备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","备注信息"]
["业务表","gen_table","删除标记","del_flag","char(n)",1,""," ","*",""," ","",0,"删除标记（0：正常；1：删除）"]
["业务表字段","gen_table_column","编号","id","varchar2(n)",64,"","* ","*",""," ","","","编号"]
["业务表字段","gen_table_column","归属表编号","gen_table_id","varchar2(n)",64,""," ","","","-> 业务表.编号","","","归属表编号"]
["业务表字段","gen_table_column","名称","name","nvarchar2(n)",200,""," ","",""," ","","","名称"]
["业务表字段","gen_table_column","描述","comments","nvarchar2(n)",500,""," ","",""," ","","","描述"]
["业务表字段","gen_table_column","JDBC类型","jdbc_type","varchar2(n)",100,""," ","",""," ","","","列的数据类型的字节长度"]
["业务表字段","gen_table_column","JAVA类型","java_type","varchar2(n)",500,""," ","",""," ","","","JAVA类型"]
["业务表字段","gen_table_column","JAVA字段名","java_field","varchar2(n)",200,""," ","",""," ","","","JAVA字段名"]
["业务表字段","gen_table_column","是否主键","is_pk","char(n)",1,""," ","",""," ","","","是否主键"]
["业务表字段","gen_table_column","是否可为空","is_null","char(n)",1,""," ","",""," ","","","是否可为空"]
["业务表字段","gen_table_column","是否为插入字段","is_insert","char(n)",1,""," ","",""," ","","","是否为插入字段"]
["业务表字段","gen_table_column","是否编辑字段","is_edit","char(n)",1,""," ","",""," ","","","是否编辑字段"]
["业务表字段","gen_table_column","是否列表字段","is_list","char(n)",1,""," ","",""," ","","","是否列表字段"]
["业务表字段","gen_table_column","是否查询字段","is_query","char(n)",1,""," ","",""," ","","","是否查询字段"]
["业务表字段","gen_table_column","查询方式","query_type","varchar2(n)",200,""," ","",""," ","","","查询方式（等于、不等于、大于、小于、范围、左LIKE、右LIKE、左右LIKE）"]
["业务表字段","gen_table_column","显示类型","show_type","varchar2(n)",200,""," ","",""," ","","","字段生成方案（文本框、文本域、下拉框、复选框、单选框、字典选择、人员选择、部门选择、区域选择）"]
["业务表字段","gen_table_column","字典类型","dict_type","varchar2(n)",200,""," ","",""," ","","","字典类型"]
["业务表字段","gen_table_column","其它设置","settings","nvarchar2(n)",2000,""," ","",""," ","","","其它设置（扩展字段JSON）"]
["业务表字段","gen_table_column","排序（升序）","sort","number","",""," ","",""," ","","","排序（升序）"]
["业务表字段","gen_table_column","创建者","create_by","varchar2(n)",64,""," ","",""," ","","","创建者"]
["业务表字段","gen_table_column","创建时间","create_date","timestamp","",""," ","",""," ","","","创建时间"]
["业务表字段","gen_table_column","更新者","update_by","varchar2(n)",64,""," ","",""," ","","","更新者"]
["业务表字段","gen_table_column","更新时间","update_date","timestamp","",""," ","",""," ","","","更新时间"]
["业务表字段","gen_table_column","备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","备注信息"]
["业务表字段","gen_table_column","删除标记","del_flag","char(n)",1,""," ","*",""," ","",0,"删除标记（0：正常；1：删除）"]
["代码模板表","gen_template","编号","id","varchar2(n)",64,"","* ","*",""," ","","","编号"]
["代码模板表","gen_template","名称","name","nvarchar2(n)",200,""," ","",""," ","","","名称"]
["代码模板表","gen_template","分类","category","varchar2(n)",2000,""," ","",""," ","","","分类"]
["代码模板表","gen_template","生成文件路径","file_path","varchar2(n)",500,""," ","",""," ","","","生成文件路径"]
["代码模板表","gen_template","生成文件名","file_name","varchar2(n)",200,""," ","",""," ","","","生成文件名"]
["代码模板表","gen_template","内容","content","clob","",""," ","",""," ","","","内容"]
["代码模板表","gen_template","创建者","create_by","varchar2(n)",64,""," ","",""," ","","","创建者"]
["代码模板表","gen_template","创建时间","create_date","timestamp","",""," ","",""," ","","","创建时间"]
["代码模板表","gen_template","更新者","update_by","varchar2(n)",64,""," ","",""," ","","","更新者"]
["代码模板表","gen_template","更新时间","update_date","timestamp","",""," ","",""," ","","","更新时间"]
["代码模板表","gen_template","备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","备注信息"]
["代码模板表","gen_template","删除标记","del_flag","char(n)",1,""," ","*",""," ","",0,"删除标记（0：正常；1：删除）"]

{"sheet":"Tables in no category","index":17,"n_rows":312,"n_cols":13,"rows_kept":312,"merged":[[0,0,0,1],[0,2,0,12],[1,0,1,1],[1,2,1,12],[2,0,2,1],[2,2,2,12],[3,0,3,1],[3,2,3,12],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[23,8,23,9],[79,0,79,1],[79,2,79,12],[80,0,80,1],[80,2,80,12],[81,0,81,1],[81,2,81,12],[82,0,82,1],[82,2,82,12],[84,8,84,9],[85,8,85,9],[86,8,86,9],[87,8,87,9],[88,8,88,9],[89,8,89,9],[90,8,90,9],[91,8,91,9],[92,8,92,9],[93,8,93,9],[94,8,94,9],[95,8,95,9],[96,8,96,9],[98,8,98,9],[146,0,146,1],[146,2,146,12],[147,0,147,1],[147,2,147,12],[148,0,148,1],[148,2,148,12],[149,0,149,1],[149,2,149,12],[151,8,151,9],[152,8,152,9],[153,8,153,9],[154,8,154,9],[155,8,155,9],[156,8,156,9],[157,8,157,9],[158,8,158,9],[159,8,159,9],[160,8,160,9],[161,8,161,9],[162,8,162,9],[163,8,163,9],[164,8,164,9],[165,8,165,9],[166,8,166,9],[167,8,167,9],[168,8,168,9],[169,8,169,9],[170,8,170,9],[171,8,171,9],[172,8,172,9],[173,8,173,9],[174,8,174,9],[175,8,175,9],[177,8,177,9],[250,0,250,1],[250,2,250,12],[251,0,251,1],[251,2,251,12],[252,0,252,1],[252,2,252,12],[253,0,253,1],[253,2,253,12],[255,8,255,9],[256,8,256,9],[257,8,257,9],[258,8,258,9],[259,8,259,9],[260,8,260,9],[261,8,261,9],[262,8,262,9],[263,8,263,9],[264,8,264,9],[265,8,265,9],[266,8,266,9],[267,8,267,9],[269,8,269,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)",null,"生成方案"]
["Table name (physical name)",null,"gen_scheme"]
["Description",null,"生成方案"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["名称","name","nvarchar2(n)",200,""," ","",""," ","","","","名称"]
["分类","category","varchar2(n)",2000,""," ","",""," ","","","","分类"]
["生成包路径","package_name","varchar2(n)",500,""," ","",""," ","","","","生成包路径"]
["生成模块名","module_name","varchar2(n)",30,""," ","",""," ","","","","生成模块名"]
["生成子模块名","sub_module_name","varchar2(n)",30,""," ","",""," ","","","","生成子模块名"]
["生成功能名","function_name","nvarchar2(n)",500,""," ","",""," ","","","","生成功能名"]
["生成功能名（简写）","function_name_simple","nvarchar2(n)",100,""," ","",""," ","","","","生成功能名（简写）"]
["生成功能作者","function_author","nvarchar2(n)",100,""," ","",""," ","","","","生成功能作者"]
["生成表编号","gen_table_id","varchar2(n)",200,""," ","",""," ","","","","生成表编号"]
["创建者","create_by","varchar2(n)",64,""," ","",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"gen_scheme_del_flag"]
["id"]
["name"]
["category"]
["package_name"]
["module_name"]
["sub_module_name"]
["function_name"]
["function_name_simple"]
["function_author"]
["gen_table_id"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",1]
[]
[]
[null,"gen_scheme_del_flag"]
["编号"]
["名称"]
["分类"]
["生成包路径"]
["生成模块名"]
["生成子模块名"]
["生成功能名"]
["生成功能名（简写）"]
["生成功能作者"]
["生成表编号"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"业务表"]
["Table name (physical name)",null,"gen_table"]
["Description",null,"业务表"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["名称","name","nvarchar2(n)",200,""," ","",""," ","","","","名称"]
["描述","comments","nvarchar2(n)",500,""," ","",""," ","","","","描述"]
["实体类名称","class_name","varchar2(n)",100,""," ","",""," ","","","","实体类名称"]
["关联父表","parent_table","varchar2(n)",200,""," ","",""," ","","","","关联父表"]
["关联父表外键","parent_table_fk","varchar2(n)",100,""," ","",""," ","","","","关联父表外键"]
["创建者","create_by","varchar2(n)",64,""," ","",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"gen_table_name","gen_table_del_flag"]
["id"]
["name",1]
["comments"]
["class_name"]
["parent_table"]
["parent_table_fk"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",null,1]
[]
[]
[null,"gen_table_name","gen_table_del_flag"]
["编号"]
["名称",1]
["描述"]
["实体类名称"]
["关联父表"]
["关联父表外键"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",null,1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"业务表字段"]
["Table name (physical name)",null,"gen_table_column"]
["Description",null,"业务表字段"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["归属表编号","gen_table_id","varchar2(n)",64,""," ","","","-> 业务表.编号","","","","归属表编号"]
["名称","name","nvarchar2(n)",200,""," ","",""," ","","","","名称"]
["描述","comments","nvarchar2(n)",500,""," ","",""," ","","","","描述"]
["JDBC类型","jdbc_type","varchar2(n)",100,""," ","",""," ","","","","列的数据类型的字节长度"]
["JAVA类型","java_type","varchar2(n)",500,""," ","",""," ","","","","JAVA类型"]
["JAVA字段名","java_field","varchar2(n)",200,""," ","",""," ","","","","JAVA字段名"]
["是否主键","is_pk","char(n)",1,""," ","",""," ","","","","是否主键"]
["是否可为空","is_null","char(n)",1,""," ","",""," ","","","","是否可为空"]
["是否为插入字段","is_insert","char(n)",1,""," ","",""," ","","","","是否为插入字段"]
["是否编辑字段","is_edit","char(n)",1,""," ","",""," ","","","","是否编辑字段"]
["是否列表字段","is_list","char(n)",1,""," ","",""," ","","","","是否列表字段"]
["是否查询字段","is_query","char(n)",1,""," ","",""," ","","","","是否查询字段"]
["查询方式","query_type","varchar2(n)",200,""," ","",""," ","","","","查询方式（等于、不等于、大于、小于、范围、左LIKE、右LIKE、左右LIKE）"]
["显示类型","show_type","varchar2(n)",200,""," ","",""," ","","","","字段生成方案（文本框、文本域、下拉框、复选框、单选框、字典选择、人员选择、部门选择、区域选择）"]
["字典类型","dict_type","varchar2(n)",200,""," ","",""," ","","","","字典类型"]
["其它设置","settings","nvarchar2(n)",2000,""," ","",""," ","","","","其它设置（扩展字段JSON）"]
["排序（升序）","sort","number","",""," ","",""," ","","","","排序（升序）"]
["创建者","create_by","varchar2(n)",64,""," ","",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"gen_table_column_table_id","gen_table_column_name","gen_table_column_sort","gen_table_column_del_flag"]
["id"]
["gen_table_id",1]
["name",null,1]
["comments"]
["jdbc_type"]
["java_type"]
["java_field"]
["is_pk"]
["is_null"]
["is_insert"]
["is_edit"]
["is_list"]
["is_query"]
["query_type"]
["show_type"]
["dict_type"]
["settings"]
["sort",null,null,1]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",{"$nulls":3},1]
[]
[]
[null,"gen_table_column_table_id","gen_table_column_name","gen_table_column_sort","gen_table_column_del_flag"]
["编号"]
["归属表编号",1]
["名称",null,1]
["描述"]
["JDBC类型"]
["JAVA类型"]
["JAVA字段名"]
["是否主键"]
["是否可为空"]
["是否为插入字段"]
["是否编辑字段"]
["是否列表字段"]
["是否查询字段"]
["查询方式"]
["显示类型"]
["字典类型"]
["其它设置"]
["排序（升序）",null,null,1]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",{"$nulls":3},1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
["归属表编号","gen_table_id","gen_table","id"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"代码模板表"]
["Table name (physical name)",null,"gen_template"]
["Description",null,"代码模板表"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["名称","name","nvarchar2(n)",200,""," ","",""," ","","","","名称"]
["分类","category","varchar2(n)",2000,""," ","",""," ","","","","分类"]
["生成文件路径","file_path","varchar2(n)",500,""," ","",""," ","","","","生成文件路径"]
["生成文件名","file_name","varchar2(n)",200,""," ","",""," ","","","","生成文件名"]
["内容","content","clob","",""," ","",""," ","","","","内容"]
["创建者","create_by","varchar2(n)",64,""," ","",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"gen_template_del_falg"]
["id"]
["name"]
["category"]
["file_path"]
["file_name"]
["content"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",1]
[]
[]
[null,"gen_template_del_falg"]
["编号"]
["名称"]
["分类"]
["生成文件路径"]
["生成文件名"]
["内容"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]

{"sheet":"all tables","index":18,"n_rows":312,"n_cols":13,"rows_kept":312,"merged":[[0,0,0,1],[0,2,0,12],[1,0,1,1],[1,2,1,12],[2,0,2,1],[2,2,2,12],[3,0,3,1],[3,2,3,12],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[23,8,23,9],[79,0,79,1],[79,2,79,12],[80,0,80,1],[80,2,80,12],[81,0,81,1],[81,2,81,12],[82,0,82,1],[82,2,82,12],[84,8,84,9],[85,8,85,9],[86,8,86,9],[87,8,87,9],[88,8,88,9],[89,8,89,9],[90,8,90,9],[91,8,91,9],[92,8,92,9],[93,8,93,9],[94,8,94,9],[95,8,95,9],[96,8,96,9],[98,8,98,9],[146,0,146,1],[146,2,146,12],[147,0,147,1],[147,2,147,12],[148,0,148,1],[148,2,148,12],[149,0,149,1],[149,2,149,12],[151,8,151,9],[152,8,152,9],[153,8,153,9],[154,8,154,9],[155,8,155,9],[156,8,156,9],[157,8,157,9],[158,8,158,9],[159,8,159,9],[160,8,160,9],[161,8,161,9],[162,8,162,9],[163,8,163,9],[164,8,164,9],[165,8,165,9],[166,8,166,9],[167,8,167,9],[168,8,168,9],[169,8,169,9],[170,8,170,9],[171,8,171,9],[172,8,172,9],[173,8,173,9],[174,8,174,9],[175,8,175,9],[177,8,177,9],[250,0,250,1],[250,2,250,12],[251,0,251,1],[251,2,251,12],[252,0,252,1],[252,2,252,12],[253,0,253,1],[253,2,253,12],[255,8,255,9],[256,8,256,9],[257,8,257,9],[258,8,258,9],[259,8,259,9],[260,8,260,9],[261,8,261,9],[262,8,262,9],[263,8,263,9],[264,8,264,9],[265,8,265,9],[266,8,266,9],[267,8,267,9],[269,8,269,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)",null,"生成方案"]
["Table name (physical name)",null,"gen_scheme"]
["Description",null,"生成方案"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["名称","name","nvarchar2(n)",200,""," ","",""," ","","","","名称"]
["分类","category","varchar2(n)",2000,""," ","",""," ","","","","分类"]
["生成包路径","package_name","varchar2(n)",500,""," ","",""," ","","","","生成包路径"]
["生成模块名","module_name","varchar2(n)",30,""," ","",""," ","","","","生成模块名"]
["生成子模块名","sub_module_name","varchar2(n)",30,""," ","",""," ","","","","生成子模块名"]
["生成功能名","function_name","nvarchar2(n)",500,""," ","",""," ","","","","生成功能名"]
["生成功能名（简写）","function_name_simple","nvarchar2(n)",100,""," ","",""," ","","","","生成功能名（简写）"]
["生成功能作者","function_author","nvarchar2(n)",100,""," ","",""," ","","","","生成功能作者"]
["生成表编号","gen_table_id","varchar2(n)",200,""," ","",""," ","","","","生成表编号"]
["创建者","create_by","varchar2(n)",64,""," ","",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"gen_scheme_del_flag"]
["id"]
["name"]
["category"]
["package_name"]
["module_name"]
["sub_module_name"]
["function_name"]
["function_name_simple"]
["function_author"]
["gen_table_id"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",1]
[]
[]
[null,"gen_scheme_del_flag"]
["编号"]
["名称"]
["分类"]
["生成包路径"]
["生成模块名"]
["生成子模块名"]
["生成功能名"]
["生成功能名（简写）"]
["生成功能作者"]
["生成表编号"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"业务表"]
["Table name (physical name)",null,"gen_table"]
["Description",null,"业务表"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["名称","name","nvarchar2(n)",200,""," ","",""," ","","","","名称"]
["描述","comments","nvarchar2(n)",500,""," ","",""," ","","","","描述"]
["实体类名称","class_name","varchar2(n)",100,""," ","",""," ","","","","实体类名称"]
["关联父表","parent_table","varchar2(n)",200,""," ","",""," ","","","","关联父表"]
["关联父表外键","parent_table_fk","varchar2(n)",100,""," ","",""," ","","","","关联父表外键"]
["创建者","create_by","varchar2(n)",64,""," ","",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"gen_table_name","gen_table_del_flag"]
["id"]
["name",1]
["comments"]
["class_name"]
["parent_table"]
["parent_table_fk"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",null,1]
[]
[]
[null,"gen_table_name","gen_table_del_flag"]
["编号"]
["名称",1]
["描述"]
["实体类名称"]
["关联父表"]
["关联父表外键"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",null,1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"业务表字段"]
["Table name (physical name)",null,"gen_table_column"]
["Description",null,"业务表字段"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["归属表编号","gen_table_id","varchar2(n)",64,""," ","","","-> 业务表.编号","","","","归属表编号"]
["名称","name","nvarchar2(n)",200,""," ","",""," ","","","","名称"]
["描述","comments","nvarchar2(n)",500,""," ","",""," ","","","","描述"]
["JDBC类型","jdbc_type","varchar2(n)",100,""," ","",""," ","","","","列的数据类型的字节长度"]
["JAVA类型","java_type","varchar2(n)",500,""," ","",""," ","","","","JAVA类型"]
["JAVA字段名","java_field","varchar2(n)",200,""," ","",""," ","","","","JAVA字段名"]
["是否主键","is_pk","char(n)",1,""," ","",""," ","","","","是否主键"]
["是否可为空","is_null","char(n)",1,""," ","",""," ","","","","是否可为空"]
["是否为插入字段","is_insert","char(n)",1,""," ","",""," ","","","","是否为插入字段"]
["是否编辑字段","is_edit","char(n)",1,""," ","",""," ","","","","是否编辑字段"]
["是否列表字段","is_list","char(n)",1,""," ","",""," ","","","","是否列表字段"]
["是否查询字段","is_query","char(n)",1,""," ","",""," ","","","","是否查询字段"]
["查询方式","query_type","varchar2(n)",200,""," ","",""," ","","","","查询方式（等于、不等于、大于、小于、范围、左LIKE、右LIKE、左右LIKE）"]
["显示类型","show_type","varchar2(n)",200,""," ","",""," ","","","","字段生成方案（文本框、文本域、下拉框、复选框、单选框、字典选择、人员选择、部门选择、区域选择）"]
["字典类型","dict_type","varchar2(n)",200,""," ","",""," ","","","","字典类型"]
["其它设置","settings","nvarchar2(n)",2000,""," ","",""," ","","","","其它设置（扩展字段JSON）"]
["排序（升序）","sort","number","",""," ","",""," ","","","","排序（升序）"]
["创建者","create_by","varchar2(n)",64,""," ","",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"gen_table_column_table_id","gen_table_column_name","gen_table_column_sort","gen_table_column_del_flag"]
["id"]
["gen_table_id",1]
["name",null,1]
["comments"]
["jdbc_type"]
["java_type"]
["java_field"]
["is_pk"]
["is_null"]
["is_insert"]
["is_edit"]
["is_list"]
["is_query"]
["query_type"]
["show_type"]
["dict_type"]
["settings"]
["sort",null,null,1]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",{"$nulls":3},1]
[]
[]
[null,"gen_table_column_table_id","gen_table_column_name","gen_table_column_sort","gen_table_column_del_flag"]
["编号"]
["归属表编号",1]
["名称",null,1]
["描述"]
["JDBC类型"]
["JAVA类型"]
["JAVA字段名"]
["是否主键"]
["是否可为空"]
["是否为插入字段"]
["是否编辑字段"]
["是否列表字段"]
["是否查询字段"]
["查询方式"]
["显示类型"]
["字典类型"]
["其它设置"]
["排序（升序）",null,null,1]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",{"$nulls":3},1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
["归属表编号","gen_table_id","gen_table","id"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"代码模板表"]
["Table name (physical name)",null,"gen_template"]
["Description",null,"代码模板表"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["名称","name","nvarchar2(n)",200,""," ","",""," ","","","","名称"]
["分类","category","varchar2(n)",2000,""," ","",""," ","","","","分类"]
["生成文件路径","file_path","varchar2(n)",500,""," ","",""," ","","","","生成文件路径"]
["生成文件名","file_name","varchar2(n)",200,""," ","",""," ","","","","生成文件名"]
["内容","content","clob","",""," ","",""," ","","","","内容"]
["创建者","create_by","varchar2(n)",64,""," ","",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"gen_template_del_falg"]
["id"]
["name"]
["category"]
["file_path"]
["file_name"]
["content"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",1]
[]
[]
[null,"gen_template_del_falg"]
["编号"]
["名称"]
["分类"]
["生成文件路径"]
["生成文件名"]
["内容"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]

{"sheet":"all indices","index":19,"n_rows":101,"n_cols":3,"rows_kept":101,"merged":[[0,1,0,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[57,1,57,2],[58,1,58,2],[67,1,67,2],[68,1,68,2],[69,1,69,2],[70,1,70,2],[71,1,71,2],[80,1,80,2],[81,1,81,2],[82,1,82,2],[83,1,83,2],[84,1,84,2],[93,1,93,2],[94,1,94,2],[95,1,95,2],[96,1,96,2],[97,1,97,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
[]
["Index Name","gen_scheme_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","gen_scheme"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]
[]
[]
[]
[]
[]
["Index Name","gen_table_name"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","gen_table"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"名称","name"]
[]
[]
[]
[]
[]
["Index Name","gen_table_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","gen_table"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]
[]
[]
[]
[]
[]
["Index Name","gen_table_column_table_id"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","gen_table_column"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"归属表编号","gen_table_id"]
[]
[]
[]
[]
[]
["Index Name","gen_table_column_name"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","gen_table_column"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"名称","name"]
[]
[]
[]
[]
[]
["Index Name","gen_table_column_sort"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","gen_table_column"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"排序（升序）","sort"]
[]
[]
[]
[]
[]
["Index Name","gen_table_column_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","gen_table_column"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]
[]
[]
[]
[]
[]
["Index Name","gen_template_del_falg"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","gen_template"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]

{"sheet":"all sequences","index":20,"n_rows":1,"n_cols":2,"rows_kept":1,"flags":["formulas_cached_only"]}
["Object Type","Sequence"]

{"sheet":"all view","index":21,"n_rows":0,"n_cols":0,"rows_kept":0,"merged":[[0,1,0,12],[1,1,1,12],[2,1,2,12],[3,1,3,12],[5,8,5,9],[6,8,6,9],[7,8,7,9]],"flags":["formulas_cached_only"]}

{"sheet":"all trigger","index":22,"n_rows":0,"n_cols":0,"rows_kept":0,"merged":[[0,1,0,11],[1,1,1,11],[2,1,2,11]],"flags":["formulas_cached_only"]}