//根据部门编号 分区
Table table = service.metadata().table("user_master", false);
if(null != table){
	service.ddl().drop(table);
}
MasterTable master = new MasterTable("user_master");
master.addColumn("ID", "INT");
master.addColumn("NAME", "VARCHAR(10)").setComment("姓名");
master.addColumn("DEPT_CODE", "VARCHAR(10)").setComment("部门ID");

//或者
master.setPartition(Partition.TYPE.LIST, "DEPT_CODE");
service.ddl().create(master);

PartitionTable sd = new PartitionTable("USER_SD_PP");
sd.setMaster(master);
sd.setPartition(new Partition(Partition.TYPE.LIST).addList("SD").addList("PP"));
service.ddl().create(sd);
PartitionTable fi = new PartitionTable("USER_FI_CO");
fi.setMaster(master);
fi.setPartition(new Partition(Partition.TYPE.LIST).addList("FI").addList("CO"));
service.ddl().create(fi);

DataRow user = new DataRow();
user.put("DEPT_CODE", "FI");//部门编号必须是子表 分区依据中出现的 并 操持大小写一致
user.put("NAME","ZH_FI");
//通过主表插入
service.insert("user_master", user);


//从主表或相就的分区表中可以查到
service.querys("user_master");
service.querys("USER_FI_CO");