Summary

部门主子关系扩展表

Remark

总共15级id,code,name ,columns这里就不对每级做特殊说明

Columns

	Column Name	Description	Datatype	Length	Allow Nulls
	departmentname_lev10 (T+12.1)	部门10级name	nvarchar	200	True
	departmentcode_lev6 (T+12.1)	部门6级code	nvarchar	32	True
	departmentid_lev12 (T+12.1)	部门12级id	int	4	True
	departmentid_lev14 (T+12.1)	部门14级id	int	4	True
	departmentid_lev9 (T+12.1)	部门9级id	int	4	True
	departmentcode_lev7 (T+12.1)	部门7级code	nvarchar	32	True
	departmentname_lev4 (T+12.1)	部门4级name	nvarchar	200	True
	departmentid_lev8 (T+12.1)	部门8级id	int	4	True
	departmentcode_lev4 (T+12.1)	部门4级code	nvarchar	32	True
	departmentname_lev1 (T+12.1)	部门1级name	nvarchar	200	True
	departmentcode_lev1 (T+12.1)	部门1级code	nvarchar	32	True
	departmentid_lev4 (T+12.1)	部门4级id	int	4	True
	departmentname_lev15 (T+12.1)	部门15级name	nvarchar	200	True
	departmentname_lev2 (T+12.1)	部门2级name	nvarchar	200	True
	departmentid_lev2 (T+12.1)	部门2级id	int	4	True
	departmentname_lev3 (T+12.1)	部门3级name	nvarchar	200	True
	id (T+12.1)	主键	int	4	True
	departmentname_lev13 (T+12.1)	部门13级name	nvarchar	200	True
	departmentcode_lev2 (T+12.1)	部门2级code	nvarchar	32	True
	departmentcode_lev14 (T+12.1)	部门14级code	nvarchar	32	True
	depth (T+12.1)	级次	nvarchar	10	True
	departmentname_lev7 (T+12.1)	部门7级name	nvarchar	200	True
	departmentcode_lev3 (T+12.1)	部门3级code	nvarchar	32	True
	departmentid_lev5 (T+12.1)	部门5级id	int	4	True
	departmentcode_lev12 (T+12.1)	部门12级code	nvarchar	32	True
	departmentname_lev11 (T+12.1)	部门11级name	nvarchar	200	True
	departmentcode_lev10 (T+12.1)	部门10级code	nvarchar	32	True
	departmentcode_lev11 (T+12.1)	部门11级code	nvarchar	32	True
	departmentcode_lev5 (T+12.1)	部门5级code	nvarchar	32	True
	departmentid_lev1 (T+12.1)	部门1级id	int	4	True
	departmentname_lev14 (T+12.1)	部门14级name	nvarchar	200	True
	departmentname_lev5 (T+12.1)	部门5级name	nvarchar	200	True
	departmentid_lev6 (T+12.1)	部门6级id	int	4	True
	departmentname_lev8 (T+12.1)	部门8级name	nvarchar	200	True
	departmentname_lev6 (T+12.1)	部门6级name	nvarchar	200	True
	departmentid_lev13 (T+12.1)	部门13级id	int	4	True
	departmentname_lev9 (T+12.1)	部门9级name	nvarchar	200	True
	departmentcode_lev9 (T+12.1)	部门9级code	nvarchar	32	True
	departmentid_lev15 (T+12.1)	部门15级id	int	4	True
	departmentname_lev12 (T+12.1)	部门12级name	nvarchar	200	True
	departmentcode_lev15 (T+12.1)	部门15级code	nvarchar	32	True
	ts (T+12.1)	分布时间戳	timestamp	8	True
	departmentid_lev7 (T+12.1)	部门7级id	int	4	True
	departmentid_lev11 (T+12.1)	部门11级id	int	4	True
	departmentcode_lev13 (T+12.1)	部门13级code	nvarchar	32	True
	departmentid_lev3 (T+12.1)	部门3级id	int	4	True
	departmentid_lev10 (T+12.1)	部门10级id	int	4	True
	createTime (T+12.1)	createtime	datetime	8	True
	departmentcode_lev8 (T+12.1)	部门8级code	nvarchar	32	True

---

Send feedback

Copyright 2019 Chanjet Inc.