数据结构图:
1.1工程系统:
1.1.1工程:
表名:Projects
Field Name | Field Type | Size | Key | Index | Description | Default Source |
ID | BIGINT |
| PK |
| 工程ID | 0 |
VARCHAR | 100 |
| IDX | 工程名称 | '' | |
VARCHAR | 100 |
|
| 合同编号 | '' | |
MANAGER | VARCHAR | 30 |
|
| 工程负责人 | '' |
WORK_TIME | BIGINT |
|
|
| 工时(天) | 0 |
DELIVERYTIME |
|
|
| 报交日期 | ' NOW' | |
CUSTOMERID |
|
|
| 客户编号 | 0 | |
VARCHAR | 50 |
|
| 客户名称 | '' | |
VARCHAR | 254 |
|
| 备注 | '' |
1.1.2子系统:
表名:Subsystems
Field Name | Field Type | Size | Key | Index | Description | Default Source |
ID | BIGINT |
| PK |
| 子系统ID | 0 |
PRO_ID | BIGINT |
|
|
| 工程ID | 0 |
VARCHAR | 100 |
| IDX | 子系统名字 | '' | |
MANAGER | VARCHAR | 50 |
|
| 子系统负责人 | '' |
REMARKS | VARCHAR | 254 |
|
| 备注 | '' |
1.2.1模块:
表名:Modules
Id | Field Name | Field Type | Size | Key | Index | Description | Default Source |
1 | ID | BIGINT |
| PK |
| 模块ID | 0 |
2 | PRO_ID | BIGINT |
|
|
| 工程ID | 0 |
3 | SYS_ID | BIGINT |
|
|
| 子系统ID | 0 |
4 | MOD_NAME | VARCHAR | 100 |
| IDX | 模块名字 | '' |
5 | MANAGER | VARCHAR | 30 |
|
| 模块负责人 | '' |
6 | REMARKS | VARCHAR | 254 |
|
| 备注 | '' |
1.2.3模块类别:
表名:ModuleTypes
Field Name | Field Type | Size | Key | Index | Default Source | |
ID | BIGINT |
| PK |
| 分类ID | 0 |
PRO_ID | BIGINT |
|
|
| 工程ID | 0 |
SYS_ID | BIGINT |
|
|
| 子系统ID | 0 |
MOD_ID | BIGINT |
|
|
| 模块ID | 0 |
Type_NAME | VARCHAR | 100 |
| IDX | 类型名 | '' |
REMARKS | VARCHAR | 254 |
|
| 备注 | '' |
1.2.4 字典中表的分类:
表名:DictionaryTypes
Field Name | Field Type | Size | Key | Index | Description | Default Source |
ID | BIGINT |
| PK |
| 表ID | 0 |
PRO_ID | BIGINT |
|
|
| 工程ID | 0 |
SYS_ID | BIGINT |
|
|
| 子系统ID | 0 |
MOD_ID | BIGINT |
|
|
| 模块ID | 0 |
Type_NAME | VARVHAR | 100 |
| IDX | 表名 | '' |
REMARKS | VARCHAR | 254 |
|
| 备注 | '' |
1.2.4字典中各类表的
表名: Dictionaries
Field Name | Field Type | Size | Key | Index | Description | Default Source |
ID | BIGINT |
| PK |
| 表ID | 0 |
PRO_ID | BIGINT |
|
|
| 工程ID | 0 |
SYS_ID | BIGINT |
|
|
| 子系统ID | 0 |
MOD_ID | BIGINT |
|
|
| 模块ID | 0 |
DIC_TYPE_ID | BIGINT |
|
|
| 0 | |
DIC_NAME | VARVHAR | 100 |
| IDX | 表名 | '' |
REMARKS | VARCHAR | 254 |
|
| 备注 | '' |
1.2.5字典
ID | Field Name | Field Type | Size | Key | Description | Default Source |
1 | ID |
| PK | 数据id | 0 | |
2 | PRO_ID | BIGINT |
|
| 工程ID | 0 |
3 | SYS_ID | BIGINT |
|
| 子系统ID | 0 |
4 | MOD_ID | BIGINT |
|
| 模块ID | 0 |
5 | DIC_ID | BIGINT |
|
| 表ID | 0 |
6 | FLD_NAME | 100 |
| 数据名字 | '' | |
7 | FLD _DATATYPE | VARCHAR | 32 |
| 数据类型 | '' |
8 | FLD _SIZE | INTEGER |
|
| 数据尺寸 | 0 |
9 | FLD _INDEX | INTEGER |
|
| Boolean | 0 0=false, 1=true |
10 | FLD _NULL | INTEGER |
|
| Boolean | 0 0=false, 1=true |
11 | FLD _DEFAILT | VARCHAR | 100 |
|
| 0 |
12 | FLD _UNIQUE | INTEGER |
|
| 0 0=false, 1=true | |
13 | FLD _DESCRIPTION | VARCHAR | 254 |
| 描述 | '' |
14 | REMARKS | VARCHAR | 254 |
| 注释 | '' |
表名:DictionaryFields