{"text_format":"3","workbook":"xls","n_sheets":22,"sheets":["Cover","Change Tracking","List of sheets","Diagram","test_data","test_data_child","test_data_main","test_tree","test_data_del_flag","test_data_child_del_flag","test_data_main_del_flag","test_tree_del_flag","test_data_parent_id","test_data_parent_ids","SEQ_sys_dict_id","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":24,"n_cols":3,"rows_kept":24,"flags":["formulas_cached_only"]}
["List of sheets"]
[]
["Type","Name","Description"]
["Other","Cover",""]
["Other","Change Tracking",""]
["Other","sheet_index_template",""]
["Other","Diagram",""]
["Table","test_data","业务数据表"]
["Table","test_data_child","业务数据子表"]
["Table","test_data_main","业务数据表"]
["Table","test_tree","树结构表"]
["Index","test_data_del_flag",""]
["Index","test_data_child_del_flag",""]
["Index","test_data_main_del_flag",""]
["Index","test_tree_del_flag",""]
["Index","test_data_parent_id",""]
["Index","test_data_parent_ids",""]
["Sequence","SEQ_sys_dict_id",""]
["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":"test_data","index":4,"n_rows":65,"n_cols":13,"rows_kept":65,"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],[20,8,20,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)","业务数据表"]
["Table name (physical name)","test_data"]
["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,"","* ","*",""," ","","","","编号"]
["归属用户","user_id","varchar2(n)",64,""," ","",""," ","","","","归属用户"]
["归属部门","office_id","varchar2(n)",64,""," ","",""," ","","","","归属部门"]
["归属区域","area_id","nvarchar2(n)",64,""," ","",""," ","","","","归属区域"]
["名称","name","nvarchar2(n)",100,""," ","",""," ","","","","名称"]
["性别","sex","char(n)",1,""," ","",""," ","","","","性别（字典类型：sex）"]
["加入日期","in_date","date","",""," ","",""," ","","","","加入日期"]
["创建者","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,"test_data_del_flag"]
["id"]
["user_id"]
["office_id"]
["area_id"]
["name"]
["sex"]
["in_date"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",1]
[]
[]
[null,"test_data_del_flag"]
["编号"]
["归属用户"]
["归属部门"]
["归属区域"]
["名称"]
["性别"]
["加入日期"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]

{"sheet":"test_data_child","index":5,"n_rows":54,"n_cols":13,"rows_kept":54,"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],[16,8,16,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)","业务数据子表"]
["Table name (physical name)","test_data_child"]
["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,"","* ","*",""," ","","","","编号"]
["业务主表ID","test_data_main_id","varchar2(n)",64,""," ","","","-> 业务数据表.编号","","","","业务主表ID"]
["名称","name","nvarchar2(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,"test_data_child_del_flag"]
["id"]
["test_data_main_id"]
["name"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",1]
[]
[]
[null,"test_data_child_del_flag"]
["编号"]
["业务主表ID"]
["名称"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
["业务主表ID","test_data_main_id","test_data_main","id"]

{"sheet":"test_data_main","index":6,"n_rows":65,"n_cols":13,"rows_kept":65,"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],[20,8,20,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)","业务数据表"]
["Table name (physical name)","test_data_main"]
["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,"","* ","*",""," ","","","","编号"]
["归属用户","user_id","varchar2(n)",64,""," ","",""," ","","","","归属用户"]
["归属部门","office_id","varchar2(n)",64,""," ","",""," ","","","","归属部门"]
["归属区域","area_id","nvarchar2(n)",64,""," ","",""," ","","","","归属区域"]
["名称","name","nvarchar2(n)",100,""," ","",""," ","","","","名称"]
["性别","sex","char(n)",1,""," ","",""," ","","","","性别（字典类型：sex）"]
["加入日期","in_date","date","",""," ","",""," ","","","","加入日期"]
["创建者","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,"test_data_main_del_flag"]
["id"]
["user_id"]
["office_id"]
["area_id"]
["name"]
["sex"]
["in_date"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",1]
[]
[]
[null,"test_data_main_del_flag"]
["编号"]
["归属用户"]
["归属部门"]
["归属区域"]
["名称"]
["性别"]
["加入日期"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]

{"sheet":"test_tree","index":7,"n_rows":59,"n_cols":13,"rows_kept":59,"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],[18,8,18,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)","树结构表"]
["Table name (physical name)","test_tree"]
["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,"","* ","*",""," ","","","","编号"]
["父级编号","parent_id","varchar2(n)",64,""," ","*",""," ","","","","父级编号"]
["所有父级编号","parent_ids","varchar2(n)",2000,""," ","*",""," ","","","","所有父级编号"]
["名称","name","nvarchar2(n)",100,""," ","*",""," ","","","","名称"]
["排序","sort","number(p,s)",10,0," ","*",""," ","","","","排序"]
["创建者","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,"test_tree_del_flag","test_data_parent_id","test_data_parent_ids"]
["id"]
["parent_id",null,1]
["parent_ids",null,null,1]
["name"]
["sort"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",1]
[]
[]
[null,"test_tree_del_flag","test_data_parent_id","test_data_parent_ids"]
["编号"]
["父级编号",null,1]
["所有父级编号",null,null,1]
["名称"]
["排序"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]

{"sheet":"test_data_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","test_data_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","test_data"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]

{"sheet":"test_data_child_del_flag","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","test_data_child_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","test_data_child"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]

{"sheet":"test_data_main_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","test_data_main_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","test_data_main"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]

{"sheet":"test_tree_del_flag","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","test_tree_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","test_tree"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]

{"sheet":"test_data_parent_id","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","test_data_parent_id"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","test_tree"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"父级编号","parent_id"]

{"sheet":"test_data_parent_ids","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","test_data_parent_ids"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","test_tree"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"所有父级编号","parent_ids"]

{"sheet":"SEQ_sys_dict_id","index":14,"n_rows":9,"n_cols":2,"rows_kept":9,"flags":["formulas_cached_only"]}
["Object Type","Sequence"]
["Sequence Name","SEQ_sys_dict_id"]
["Description",""]
["Increment","1"]
["Min Value",""]
["Max Value",""]
["Start Value","1"]
["Cache",""]
["Cycle",""]

{"sheet":"all attributes","index":15,"n_rows":47,"n_cols":14,"rows_kept":47,"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"]
["业务数据表","test_data","编号","id","varchar2(n)",64,"","* ","*",""," ","","","编号"]
["业务数据表","test_data","归属用户","user_id","varchar2(n)",64,""," ","",""," ","","","归属用户"]
["业务数据表","test_data","归属部门","office_id","varchar2(n)",64,""," ","",""," ","","","归属部门"]
["业务数据表","test_data","归属区域","area_id","nvarchar2(n)",64,""," ","",""," ","","","归属区域"]
["业务数据表","test_data","名称","name","nvarchar2(n)",100,""," ","",""," ","","","名称"]
["业务数据表","test_data","性别","sex","char(n)",1,""," ","",""," ","","","性别（字典类型：sex）"]
["业务数据表","test_data","加入日期","in_date","date","",""," ","",""," ","","","加入日期"]
["业务数据表","test_data","创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","创建者"]
["业务数据表","test_data","创建时间","create_date","timestamp","",""," ","*",""," ","","","创建时间"]
["业务数据表","test_data","更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","更新者"]
["业务数据表","test_data","更新时间","update_date","timestamp","",""," ","*",""," ","","","更新时间"]
["业务数据表","test_data","备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","备注信息"]
["业务数据表","test_data","删除标记","del_flag","char(n)",1,""," ","*",""," ","",0,"删除标记（0：正常；1：删除）"]
["业务数据子表","test_data_child","编号","id","varchar2(n)",64,"","* ","*",""," ","","","编号"]
["业务数据子表","test_data_child","业务主表ID","test_data_main_id","varchar2(n)",64,""," ","","","-> 业务数据表.编号","","","业务主表ID"]
["业务数据子表","test_data_child","名称","name","nvarchar2(n)",100,""," ","",""," ","","","名称"]
["业务数据子表","test_data_child","创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","创建者"]
["业务数据子表","test_data_child","创建时间","create_date","timestamp","",""," ","*",""," ","","","创建时间"]
["业务数据子表","test_data_child","更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","更新者"]
["业务数据子表","test_data_child","更新时间","update_date","timestamp","",""," ","*",""," ","","","更新时间"]
["业务数据子表","test_data_child","备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","备注信息"]
["业务数据子表","test_data_child","删除标记","del_flag","char(n)",1,""," ","*",""," ","",0,"删除标记（0：正常；1：删除）"]
["业务数据表","test_data_main","编号","id","varchar2(n)",64,"","* ","*",""," ","","","编号"]
["业务数据表","test_data_main","归属用户","user_id","varchar2(n)",64,""," ","",""," ","","","归属用户"]
["业务数据表","test_data_main","归属部门","office_id","varchar2(n)",64,""," ","",""," ","","","归属部门"]
["业务数据表","test_data_main","归属区域","area_id","nvarchar2(n)",64,""," ","",""," ","","","归属区域"]
["业务数据表","test_data_main","名称","name","nvarchar2(n)",100,""," ","",""," ","","","名称"]
["业务数据表","test_data_main","性别","sex","char(n)",1,""," ","",""," ","","","性别（字典类型：sex）"]
["业务数据表","test_data_main","加入日期","in_date","date","",""," ","",""," ","","","加入日期"]
["业务数据表","test_data_main","创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","创建者"]
["业务数据表","test_data_main","创建时间","create_date","timestamp","",""," ","*",""," ","","","创建时间"]
["业务数据表","test_data_main","更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","更新者"]
["业务数据表","test_data_main","更新时间","update_date","timestamp","",""," ","*",""," ","","","更新时间"]
["业务数据表","test_data_main","备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","备注信息"]
["业务数据表","test_data_main","删除标记","del_flag","char(n)",1,""," ","*",""," ","",0,"删除标记（0：正常；1：删除）"]
["树结构表","test_tree","编号","id","varchar2(n)",64,"","* ","*",""," ","","","编号"]
["树结构表","test_tree","父级编号","parent_id","varchar2(n)",64,""," ","*",""," ","","","父级编号"]
["树结构表","test_tree","所有父级编号","parent_ids","varchar2(n)",2000,""," ","*",""," ","","","所有父级编号"]
["树结构表","test_tree","名称","name","nvarchar2(n)",100,""," ","*",""," ","","","名称"]
["树结构表","test_tree","排序","sort","number(p,s)",10,0," ","*",""," ","","","排序"]
["树结构表","test_tree","创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","创建者"]
["树结构表","test_tree","创建时间","create_date","timestamp","",""," ","*",""," ","","","创建时间"]
["树结构表","test_tree","更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","更新者"]
["树结构表","test_tree","更新时间","update_date","timestamp","",""," ","*",""," ","","","更新时间"]
["树结构表","test_tree","备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","备注信息"]
["树结构表","test_tree","删除标记","del_flag","char(n)",1,""," ","*",""," ","",0,"删除标记（0：正常；1：删除）"]

{"sheet":"Tables in no category","index":16,"n_rows":258,"n_cols":13,"rows_kept":258,"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],[20,8,20,9],[70,0,70,1],[70,2,70,12],[71,0,71,1],[71,2,71,12],[72,0,72,1],[72,2,72,12],[73,0,73,1],[73,2,73,12],[75,8,75,9],[76,8,76,9],[77,8,77,9],[78,8,78,9],[79,8,79,9],[80,8,80,9],[81,8,81,9],[82,8,82,9],[83,8,83,9],[84,8,84,9],[86,8,86,9],[129,0,129,1],[129,2,129,12],[130,0,130,1],[130,2,130,12],[131,0,131,1],[131,2,131,12],[132,0,132,1],[132,2,132,12],[134,8,134,9],[135,8,135,9],[136,8,136,9],[137,8,137,9],[138,8,138,9],[139,8,139,9],[140,8,140,9],[141,8,141,9],[142,8,142,9],[143,8,143,9],[144,8,144,9],[145,8,145,9],[146,8,146,9],[147,8,147,9],[149,8,149,9],[199,0,199,1],[199,2,199,12],[200,0,200,1],[200,2,200,12],[201,0,201,1],[201,2,201,12],[202,0,202,1],[202,2,202,12],[204,8,204,9],[205,8,205,9],[206,8,206,9],[207,8,207,9],[208,8,208,9],[209,8,209,9],[210,8,210,9],[211,8,211,9],[212,8,212,9],[213,8,213,9],[214,8,214,9],[215,8,215,9],[217,8,217,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)",null,"业务数据表"]
["Table name (physical name)",null,"test_data"]
["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,"","* ","*",""," ","","","","编号"]
["归属用户","user_id","varchar2(n)",64,""," ","",""," ","","","","归属用户"]
["归属部门","office_id","varchar2(n)",64,""," ","",""," ","","","","归属部门"]
["归属区域","area_id","nvarchar2(n)",64,""," ","",""," ","","","","归属区域"]
["名称","name","nvarchar2(n)",100,""," ","",""," ","","","","名称"]
["性别","sex","char(n)",1,""," ","",""," ","","","","性别（字典类型：sex）"]
["加入日期","in_date","date","",""," ","",""," ","","","","加入日期"]
["创建者","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,"test_data_del_flag"]
["id"]
["user_id"]
["office_id"]
["area_id"]
["name"]
["sex"]
["in_date"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",1]
[]
[]
[null,"test_data_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,"test_data_child"]
["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,"","* ","*",""," ","","","","编号"]
["业务主表ID","test_data_main_id","varchar2(n)",64,""," ","","","-> 业务数据表.编号","","","","业务主表ID"]
["名称","name","nvarchar2(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,"test_data_child_del_flag"]
["id"]
["test_data_main_id"]
["name"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",1]
[]
[]
[null,"test_data_child_del_flag"]
["编号"]
["业务主表ID"]
["名称"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
["业务主表ID","test_data_main_id","test_data_main","id"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"业务数据表"]
["Table name (physical name)",null,"test_data_main"]
["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,"","* ","*",""," ","","","","编号"]
["归属用户","user_id","varchar2(n)",64,""," ","",""," ","","","","归属用户"]
["归属部门","office_id","varchar2(n)",64,""," ","",""," ","","","","归属部门"]
["归属区域","area_id","nvarchar2(n)",64,""," ","",""," ","","","","归属区域"]
["名称","name","nvarchar2(n)",100,""," ","",""," ","","","","名称"]
["性别","sex","char(n)",1,""," ","",""," ","","","","性别（字典类型：sex）"]
["加入日期","in_date","date","",""," ","",""," ","","","","加入日期"]
["创建者","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,"test_data_main_del_flag"]
["id"]
["user_id"]
["office_id"]
["area_id"]
["name"]
["sex"]
["in_date"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",1]
[]
[]
[null,"test_data_main_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,"test_tree"]
["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,"","* ","*",""," ","","","","编号"]
["父级编号","parent_id","varchar2(n)",64,""," ","*",""," ","","","","父级编号"]
["所有父级编号","parent_ids","varchar2(n)",2000,""," ","*",""," ","","","","所有父级编号"]
["名称","name","nvarchar2(n)",100,""," ","*",""," ","","","","名称"]
["排序","sort","number(p,s)",10,0," ","*",""," ","","","","排序"]
["创建者","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,"test_tree_del_flag","test_data_parent_id","test_data_parent_ids"]
["id"]
["parent_id",null,1]
["parent_ids",null,null,1]
["name"]
["sort"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",1]
[]
[]
[null,"test_tree_del_flag","test_data_parent_id","test_data_parent_ids"]
["编号"]
["父级编号",null,1]
["所有父级编号",null,null,1]
["名称"]
["排序"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]

{"sheet":"all tables","index":17,"n_rows":258,"n_cols":13,"rows_kept":258,"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],[20,8,20,9],[70,0,70,1],[70,2,70,12],[71,0,71,1],[71,2,71,12],[72,0,72,1],[72,2,72,12],[73,0,73,1],[73,2,73,12],[75,8,75,9],[76,8,76,9],[77,8,77,9],[78,8,78,9],[79,8,79,9],[80,8,80,9],[81,8,81,9],[82,8,82,9],[83,8,83,9],[84,8,84,9],[86,8,86,9],[129,0,129,1],[129,2,129,12],[130,0,130,1],[130,2,130,12],[131,0,131,1],[131,2,131,12],[132,0,132,1],[132,2,132,12],[134,8,134,9],[135,8,135,9],[136,8,136,9],[137,8,137,9],[138,8,138,9],[139,8,139,9],[140,8,140,9],[141,8,141,9],[142,8,142,9],[143,8,143,9],[144,8,144,9],[145,8,145,9],[146,8,146,9],[147,8,147,9],[149,8,149,9],[199,0,199,1],[199,2,199,12],[200,0,200,1],[200,2,200,12],[201,0,201,1],[201,2,201,12],[202,0,202,1],[202,2,202,12],[204,8,204,9],[205,8,205,9],[206,8,206,9],[207,8,207,9],[208,8,208,9],[209,8,209,9],[210,8,210,9],[211,8,211,9],[212,8,212,9],[213,8,213,9],[214,8,214,9],[215,8,215,9],[217,8,217,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)",null,"业务数据表"]
["Table name (physical name)",null,"test_data"]
["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,"","* ","*",""," ","","","","编号"]
["归属用户","user_id","varchar2(n)",64,""," ","",""," ","","","","归属用户"]
["归属部门","office_id","varchar2(n)",64,""," ","",""," ","","","","归属部门"]
["归属区域","area_id","nvarchar2(n)",64,""," ","",""," ","","","","归属区域"]
["名称","name","nvarchar2(n)",100,""," ","",""," ","","","","名称"]
["性别","sex","char(n)",1,""," ","",""," ","","","","性别（字典类型：sex）"]
["加入日期","in_date","date","",""," ","",""," ","","","","加入日期"]
["创建者","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,"test_data_del_flag"]
["id"]
["user_id"]
["office_id"]
["area_id"]
["name"]
["sex"]
["in_date"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",1]
[]
[]
[null,"test_data_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,"test_data_child"]
["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,"","* ","*",""," ","","","","编号"]
["业务主表ID","test_data_main_id","varchar2(n)",64,""," ","","","-> 业务数据表.编号","","","","业务主表ID"]
["名称","name","nvarchar2(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,"test_data_child_del_flag"]
["id"]
["test_data_main_id"]
["name"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",1]
[]
[]
[null,"test_data_child_del_flag"]
["编号"]
["业务主表ID"]
["名称"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
["业务主表ID","test_data_main_id","test_data_main","id"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"业务数据表"]
["Table name (physical name)",null,"test_data_main"]
["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,"","* ","*",""," ","","","","编号"]
["归属用户","user_id","varchar2(n)",64,""," ","",""," ","","","","归属用户"]
["归属部门","office_id","varchar2(n)",64,""," ","",""," ","","","","归属部门"]
["归属区域","area_id","nvarchar2(n)",64,""," ","",""," ","","","","归属区域"]
["名称","name","nvarchar2(n)",100,""," ","",""," ","","","","名称"]
["性别","sex","char(n)",1,""," ","",""," ","","","","性别（字典类型：sex）"]
["加入日期","in_date","date","",""," ","",""," ","","","","加入日期"]
["创建者","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,"test_data_main_del_flag"]
["id"]
["user_id"]
["office_id"]
["area_id"]
["name"]
["sex"]
["in_date"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",1]
[]
[]
[null,"test_data_main_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,"test_tree"]
["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,"","* ","*",""," ","","","","编号"]
["父级编号","parent_id","varchar2(n)",64,""," ","*",""," ","","","","父级编号"]
["所有父级编号","parent_ids","varchar2(n)",2000,""," ","*",""," ","","","","所有父级编号"]
["名称","name","nvarchar2(n)",100,""," ","*",""," ","","","","名称"]
["排序","sort","number(p,s)",10,0," ","*",""," ","","","","排序"]
["创建者","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,"test_tree_del_flag","test_data_parent_id","test_data_parent_ids"]
["id"]
["parent_id",null,1]
["parent_ids",null,null,1]
["name"]
["sort"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",1]
[]
[]
[null,"test_tree_del_flag","test_data_parent_id","test_data_parent_ids"]
["编号"]
["父级编号",null,1]
["所有父级编号",null,null,1]
["名称"]
["排序"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]

{"sheet":"all indices","index":18,"n_rows":75,"n_cols":3,"rows_kept":75,"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]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
[]
["Index Name","test_data_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","test_data"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]
[]
[]
[]
[]
[]
["Index Name","test_data_child_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","test_data_child"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]
[]
[]
[]
[]
[]
["Index Name","test_data_main_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","test_data_main"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]
[]
[]
[]
[]
[]
["Index Name","test_tree_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","test_tree"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]
[]
[]
[]
[]
[]
["Index Name","test_data_parent_id"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","test_tree"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"父级编号","parent_id"]
[]
[]
[]
[]
[]
["Index Name","test_data_parent_ids"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","test_tree"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"所有父级编号","parent_ids"]

{"sheet":"all sequences","index":19,"n_rows":10,"n_cols":2,"rows_kept":10,"flags":["formulas_cached_only"]}
["Object Type","Sequence"]
[]
["Sequence Name","SEQ_sys_dict_id"]
["Description",""]
["Increment","1"]
["Min Value",""]
["Max Value",""]
["Start Value","1"]
["Cache",""]
["Cycle",""]

{"sheet":"all view","index":20,"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":21,"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"]}