accdepart.md
2.46 KB
accdepart
- Rows (estimated): 635
- Data size: 224.0 KB
- Engine: InnoDB
- Collation: utf8mb3_general_ci
- Created: 2026-04-27 18:46:55
- Updated: 2026-04-27 18:46:55
Columns
| # | Name | Type | Null | Key | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| 1 | iIncrement |
int |
NO | 0 | 自增列 | ||
| 2 | sId |
varchar(100) |
YES | ||||
| 3 | sSrcId |
varchar(100) |
YES | ||||
| 4 | sBrandsId |
varchar(100) |
YES | ||||
| 5 | sSubsidiaryId |
varchar(100) |
YES | ||||
| 6 | tCreateDate |
datetime |
NO | CURRENT_TIMESTAMP | DEFAULT_GENERATED | 制单日期 | |
| 7 | sMakePerson |
varchar(255) |
YES | ||||
| 8 | iOrder |
int |
NO | 0 | 排序号 | ||
| 9 | sName |
varchar(255) |
YES | ||||
| 10 | sNo |
varchar(255) |
YES | ||||
| 11 | bInvalid |
bit(1) |
NO | b'0' | 是否作废 | ||
| 12 | sAllId |
text |
YES | ||||
| 13 | sChildren |
varchar(255) |
YES | ||||
| 14 | sParentId |
varchar(100) |
YES | ||||
| 15 | iPeople |
int |
NO | 0 | 总人数(人) | ||
| 16 | dArea |
decimal(18,6) |
NO | 0.000000 | 总面积(平方) | ||
| 17 | iConvert |
int |
NO | 0 | 是否设置转移动(否/是) | ||
| 18 | sCostPeriod |
varchar(255) |
YES | ||||
| 19 | bConfirm |
bit(1) |
NO | b'0' | 是否确认 | ||
| 20 | sConfirmMonth |
varchar(100) |
YES | ||||
| 21 | dPower |
decimal(18,6) |
NO | 0.000000 | 总理论功率（千万时） | ||
| 22 | dMonthHour |
decimal(18,6) |
NO | 0.000000 | 部门月度开机时间（H） | ||
| 23 | iMachine |
int |
NO | 0 | 设备台数 | ||
| 24 | dDepreciation |
decimal(18,6) |
NO | 0.000000 | 折旧总额 | ||
| 25 | dProcessQty |
decimal(18,6) |
NO | 0.000000 | 部门月度产量-作业数量 | ||
| 26 | dMonthArea |
decimal(18,6) |
NO | 0.000000 | 部门月度产量-面积（平米） | ||
| 27 | dColorQty |
decimal(18,6) |
NO | 0.000000 | 部门月度产量-色令 | ||
| 28 | dAveragePower |
decimal(18,6) |
NO | 0.000000 | 平均功率 | ||
| 29 | dAllHourSalary |
decimal(18,6) |
NO | 0.000000 | 平均时薪*工时 | ||
| 30 | dSumPlateQty |
decimal(18,6) |
NO | 0.000000 | 总印版张数 |
Narrative
No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.