资产分类级次表
资产分类级次表
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| assetClasscode_lev15 (T+12.1) | 15级资产分类编码 | nvarchar | 40 | True | |
| assetClassid_lev8 (T+12.1) | 8级资产分类ID | int | 4 | True | |
| assetClassid_lev5 (T+12.1) | 5级资产分类ID | int | 4 | True | |
| assetClassid_lev14 (T+12.1) | 14级资产分类ID | int | 4 | True | |
| ts (T+12.1) | 分布时间戳 | timestamp | 8 | True | |
| assetClasscode_lev4 (T+12.1) | 4级资产分类编码 | nvarchar | 40 | True | |
| assetClassid_lev15 (T+12.1) | 15级资产分类ID | int | 4 | True | |
| assetClassid_lev3 (T+12.1) | 3级资产分类ID | int | 4 | True | |
| assetClassid_lev7 (T+12.1) | 7级资产分类ID | int | 4 | True | |
| assetClassname_lev15 (T+12.1) | 15级资产分类名称 | nvarchar | 400 | True | |
| assetClasscode_lev13 (T+12.1) | 13级资产分类编码 | nvarchar | 40 | True | |
| assetClassid_lev13 (T+12.1) | 13级资产分类ID | int | 4 | True | |
| assetClassid_lev1 (T+12.1) | 1级资产分类ID | int | 4 | True | |
| assetClassname_lev4 (T+12.1) | 4级资产分类名称 | nvarchar | 400 | True | |
| assetClassname_lev12 (T+12.1) | 12级资产分类名称 | nvarchar | 400 | True | |
| assetClassname_lev10 (T+12.1) | 10级资产分类名称 | nvarchar | 400 | True | |
| assetClasscode_lev1 (T+12.1) | 1级资产分类编码 | nvarchar | 40 | True | |
| assetClasscode_lev9 (T+12.1) | 9级资产分类编码 | nvarchar | 40 | True | |
| assetClasscode_lev6 (T+12.1) | 6级资产分类编码 | nvarchar | 40 | True | |
| assetClassname_lev3 (T+12.1) | 3级资产分类名称 | nvarchar | 400 | True | |
| assetClasscode_lev11 (T+12.1) | 11级资产分类编码 | nvarchar | 40 | True | |
| assetClassname_lev13 (T+12.1) | 13级资产分类名称 | nvarchar | 400 | True | |
| assetClassname_lev9 (T+12.1) | 9级资产分类名称 | nvarchar | 400 | True | |
| assetClassname_lev1 (T+12.1) | 1级资产分类名称 | nvarchar | 400 | True | |
| depth (T+12.1) | 级次 | nvarchar | 10 | True | |
| assetClassid_lev9 (T+12.1) | 9级资产分类ID | int | 4 | True | |
| assetClasscode_lev12 (T+12.1) | 12级资产分类编码 | nvarchar | 40 | True | |
| assetClasscode_lev7 (T+12.1) | 7级资产分类编码 | nvarchar | 40 | True | |
| assetClasscode_lev8 (T+12.1) | 8级资产分类编码 | nvarchar | 40 | True | |
| assetClassid_lev12 (T+12.1) | 12级资产分类ID | int | 4 | True | |
| assetClasscode_lev5 (T+12.1) | 5级资产分类编码 | nvarchar | 40 | True | |
| assetClassid_lev4 (T+12.1) | 4级资产分类ID | int | 4 | True | |
| assetClassid_lev11 (T+12.1) | 11级资产分类ID | int | 4 | True | |
| assetClassid_lev6 (T+12.1) | 6级资产分类ID | int | 4 | True | |
| id (T+12.1) | 主键 | int | 4 | False | |
| createTime (T+12.1) | createtime | datetime | 8 | True | |
| assetClassname_lev14 (T+12.1) | 14级资产分类名称 | nvarchar | 400 | True | |
| assetClassname_lev2 (T+12.1) | 2级资产分类名称 | nvarchar | 400 | True | |
| assetClassid_lev10 (T+12.1) | 10级资产分类ID | int | 4 | True | |
| assetClassname_lev6 (T+12.1) | 6级资产分类名称 | nvarchar | 400 | True | |
| assetClasscode_lev3 (T+12.1) | 3级资产分类编码 | nvarchar | 40 | True | |
| assetClassname_lev5 (T+12.1) | 5级资产分类名称 | nvarchar | 400 | True | |
| assetClasscode_lev14 (T+12.1) | 14级资产分类编码 | nvarchar | 40 | True | |
| assetClasscode_lev2 (T+12.1) | 2级资产分类编码 | nvarchar | 40 | True | |
| assetClassid_lev2 (T+12.1) | 2级资产分类ID | int | 4 | True | |
| assetClassname_lev7 (T+12.1) | 7级资产分类名称 | nvarchar | 400 | True | |
| assetClassname_lev11 (T+12.1) | 11级资产分类名称 | nvarchar | 400 | True | |
| assetClasscode_lev10 (T+12.1) | 10级资产分类编码 | nvarchar | 40 | True | |
| assetClassname_lev8 (T+12.1) | 8级资产分类名称 | nvarchar | 400 | True |
Copyright 2019 Chanjet Inc.