Skip to content
Snippets Groups Projects

Feature/xueyawei

Merged Feature/xueyawei
feature/xueyawei into develop
Merged 班迪 requested to merge feature/xueyawei into develop
Compare
and
39 files
+ 205
− 189
Compare changes
  • Side-by-side
  • Inline
Files
39
Document/2.设计/5.数据库设计/表设计模板.md
+ 21
− 15
# 绩效指标表(project_target)
| 字段 | 类型 | 允许空 | 默认值 | 描述 |
| ------------ | ------------ | ------ | -------------------- | -------------- |
| id | bigint | NO | - | - |
| year | int | NO | | 年份 |
| targetName | varchar | NO | | 绩效指标名称 |
| targetCode | varchar | NO | | 绩效指标编号 |
| parent | bigint | YES | | 上级绩效指标id |
| | | | | |
| creator | bigint | YES | - | 创建者 |
| updator | bigint | YES | - | 更新者 |
| remark | varchar(128) | YES | - | 备注 |
| available | varchar(32) | NO | YES | 是否可用 |
| create_date | datetime | NO | CURRENT_TIMESTAMP | 创建时间 |
| update_date | datetime | NO | CURRENT_TIMESTAMP | 更新时间 |
| version_date | timestamp(3) | NO | CURRENT_TIMESTAMP(3) | 版本时间戳 |
| 字段 | 类型 | 允许空 | 默认值 | 描述 |
| -------------- | ------------ | ------ | -------------------- | -------------- |
| id | bigint | NO | - | - |
| year | int | YES | | 年份 |
| projectName | varchar | YES | | |
| departmentName | varchar | YES | | 绩效指标编号 |
| departmentCode | varchar | YES | | 上级绩效指标id |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| creator | bigint | YES | - | 创建者 |
| updator | bigint | YES | - | 更新者 |
| remark | varchar(128) | YES | - | 备注 |
| available | varchar(32) | NO | YES | 是否可用 |
| create_date | datetime | NO | CURRENT_TIMESTAMP | 创建时间 |
| update_date | datetime | NO | CURRENT_TIMESTAMP | 更新时间 |
| version_date | timestamp(3) | NO | CURRENT_TIMESTAMP(3) | 版本时间戳 |