# 仪陇表务管理系统 — 数据库设计 V2.0（需求驱动） > **依据**：仅 `../demand/` PRD（01～03、产品功能清单、PRD-04 各模块）；**不参考**存量业务表、存量 Java 实体与接口实现。 > **命名**：`.cursor/rules/db/database-design.mdc` — 表务系统 x1=`wssmet`（供水行业·表务管理系统），业务表后缀 `w`。 > **Oracle 11**；持久层扩展审计列与逻辑删除见 `PROJECT_SKILL.md`、`java6/java-ylsw-bw.md`（列 `deleted`，Java `Boolean deleted`；值对象与库列映射见 §1）。 > **工单**：申请类业务**不建本地工单表**，复用平台 workflow；业务表存 `process_instance_id`、`work_order_code`、`approve_status`。 ## 1. 设计约定 | 项 | 约定 | |----|------| | 表名 | `wssmet_{x2}_w`，x2 段内无下划线（如 `wssmet_purapply_w`） | | 字段名 | 小写蛇形（如 `meter_code`、`create_user`） | | 主键 | `id NUMBER(19) NOT NULL` | | 公共列 | BaseEntity 扩展审计列（§2）；`w` 表含 `create_dept_id`/`create_dept_name` | | 逻辑删除 | `deleted NUMBER(1) DEFAULT 0 NOT NULL`（项目约定，非通用 `is_delete`） | | 字典 | `*_code VARCHAR2` ↔ Java `DictEntry` + `@DictDirectory` | | 组织/用户 | `*_id NUMBER(19)` ↔ Java `OrganizationEntry` / `UserNameEntry`（**仅 ID 列**，不落 name 快照） | | 附件 | **无库列**；Java `FileEntryList`/`FileEntry` + `@TableField(exist = false)`，走平台文件服务 | | 外键 | 逻辑外键，应用层维护；`*_id` 等关联列 COMMENT 须写明「关联{表名}表的{字段}字段」（见 `java6/java-ylsw-bw.md`） | | 字典/枚举 | `DictEntry`/`Enumerable`；COMMENT 须标明 **字典类型**（目录码）或 **枚举类型**（Java 枚举名）；按表清单见 §2.1，取值明细见 [字典与枚举说明-V1.0.md](./字典与枚举说明-V1.0.md) | ## 2. BaseEntity 公共列（`w` 类业务表） | 列名 | 类型 | 说明 | |------|------|------| | id | NUMBER(19) | 主键 | | create_user | NUMBER(19) | 创建人ID，关联 tf_user.id | | create_time | TIMESTAMP | 创建时间 | | update_user | NUMBER(19) | 更新人ID，关联 tf_user.id | | update_time | TIMESTAMP | 更新时间 | | deleted | NUMBER(1) | 删除状态：0未删除 1已删除 | | create_company_id | NUMBER(19) | 创建公司ID，关联 tf_org.id | | create_company_name | VARCHAR2(200) | 创建公司名称 | | create_dept_id | NUMBER(19) | 创建部门ID，关联 tf_org.id | | create_dept_name | VARCHAR2(200) | 创建部门名称 | | create_post_id | NUMBER(19) | 创建岗位ID，关联 tf_post.id | | create_post_name | VARCHAR2(200) | 创建岗位名称 | | create_user_name | VARCHAR2(100) | 创建用户名称 | | cur_company_id | NUMBER(19) | 当前公司ID（数据权限），关联 tf_org.id | | cur_dept_id | NUMBER(19) | 当前部门ID（数据权限），关联 tf_org.id | ## 2.1 非普通字段清单（按表） > **不在此列出**：BaseEntity 公共列、主键 `id`、外键关联列（`*_id`）、普通业务列（单号/编码、名称、数量、日期、备注等）；关联列 COMMENT 见 §1 与 `java6` §逻辑外键列注释。 > **仅列字典与枚举**：类型列填 `字典` / `枚举`；**说明**为字段业务含义；**引用**为目录码或 Java 枚举类名；**取值明细**见 [字典与枚举说明-V1.0.md](./字典与枚举说明-V1.0.md)。 **示例（表 A）** | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | task_status_code | 枚举 | 任务状态 | TaskStatusEnum | | caliber_code | 字典 | 口径 | METER_DIAMETER | ### wssmet_meter_w — 水表主数据（资产档案） | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | caliber_code | 字典 | 口径 | METER_DIAMETER | | meter_type_code | 字典 | 水表类型 | METER_TYPE | | meter_status_code | 枚举 | 水表状态 | MeterStatusEnum | | in_stock_attr_code | 字典 | 入库库存属性 | METER_IN_STOCK_ATTR | ### wssmet_meterlife_w — 水表生命周期事件 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | event_type_code | 枚举 | 事件类型 | MeterLifeEventTypeEnum | ### wssmet_warehouse_w — 仓库（总仓/分仓） | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | warehouse_type_code | 枚举 | 仓库类型 | WarehouseTypeEnum | | status_code | 枚举 | 状态 | CommonStatusEnum | ### wssmet_meterbrand_w — 水表厂家 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | status_code | 枚举 | 状态 | CommonStatusEnum | ### wssmet_brandmodel_w — 水表型号 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | caliber_code | 字典 | 口径 | METER_DIAMETER | | meter_type_code | 字典 | 水表类型 | METER_TYPE | | status_code | 枚举 | 状态 | CommonStatusEnum | ### wssmet_cyclerule_w — 检定/轮换/报废周期规则 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | rule_type_code | 枚举 | 规则类型 | CycleRuleTypeEnum | | caliber_code | 字典 | 口径 | METER_DIAMETER | | meter_type_code | 字典 | 水表类型 | METER_TYPE | | status_code | 枚举 | 状态 | CommonStatusEnum | ### wssmet_invalert_w — 库存预警规则 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | caliber_code | 字典 | 口径 | METER_DIAMETER | | meter_type_code | 字典 | 水表类型 | METER_TYPE | | in_stock_attr_code | 字典 | 入库库存属性 | METER_IN_STOCK_ATTR | | status_code | 枚举 | 状态 | CommonStatusEnum | ### wssmet_purapply_w — 采购申请 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | approve_status | 枚举 | 审批状态 | ApproveStatusEnum | | process_status_code | 枚举 | 流程状态 | ProcessStatusEnum | ### wssmet_purapplylist_w — 采购申请明细 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | caliber_code | 字典 | 口径 | METER_DIAMETER | | meter_type_code | 字典 | 水表类型 | METER_TYPE | ### wssmet_purplan_w — 采购计划 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | caliber_code | 字典 | 口径 | METER_DIAMETER | | meter_type_code | 字典 | 水表类型 | METER_TYPE | | arrive_status_code | 枚举 | 到货状态 | ArriveStatusEnum | ### wssmet_purplanarrlist_w — 采购到货水表明细 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | caliber_code | 字典 | 口径 | METER_DIAMETER | | meter_type_code | 字典 | 水表类型 | METER_TYPE | ### wssmet_landverify_w — 落地检登记 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | verify_result_code | 枚举 | 检定结果 | VerifyResultEnum | ### wssmet_retfactory_w — 不合格返厂登记 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | return_reason_code | 字典 | 退回原因 | METER_RETURN_REASON | ### wssmet_claimapply_w — 领用申请 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | purpose_code | 字典 | 用途 | METER_PURPOSE | | approve_status | 枚举 | 审批状态 | ApproveStatusEnum | | register_status_code | 枚举 | 登记状态 | RegisterStatusEnum | ### wssmet_claimapplylist_w — 领用申请明细 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | caliber_code | 字典 | 口径 | METER_DIAMETER | | meter_type_code | 字典 | 水表类型 | METER_TYPE | ### wssmet_claimreg_w — 领取登记 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | inbound_status_code | 枚举 | 入库状态 | InboundStatusEnum | ### wssmet_transferapply_w — 调拨申请 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | caliber_code | 字典 | 口径 | METER_DIAMETER | | meter_type_code | 字典 | 水表类型 | METER_TYPE | | approve_status | 枚举 | 审批状态 | ApproveStatusEnum | | out_status_code | 枚举 | 出库状态 | OutboundStatusEnum | | in_status_code | 枚举 | 入库状态 | InboundStatusEnum | ### wssmet_transferout_w — 调拨出库登记 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | out_status_code | 枚举 | 出库状态 | OutboundStatusEnum | ### wssmet_expverifytask_w — 到期检定任务 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | task_status_code | 枚举 | 任务状态 | TaskStatusEnum | ### wssmet_expverifytaskmeter_w — 到期检定任务水表明细 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | verify_status_code | 枚举 | 检定状态 | VerifyStatusEnum | | verify_result_code | 枚举 | 检定结果 | VerifyResultEnum | | dispose_type_code | 字典 | 处置类型 | METER_DISPOSE_TYPE | ### wssmet_expverifyexec_w — 到期检定现场执行（App） | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | exec_node_code | 枚举 | 执行节点 | ExecNodeEnum | ### wssmet_disverifyapply_w — 争议检定申请 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | dispute_reason_code | 字典 | 争议原因 | METER_DISPUTE_REASON | | caliber_code | 字典 | 口径 | METER_DIAMETER | | meter_type_code | 字典 | 水表类型 | METER_TYPE | | approve_status | 枚举 | 审批状态 | ApproveStatusEnum | ### wssmet_disverifytask_w — 争议检定任务 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | task_status_code | 枚举 | 任务状态 | TaskStatusEnum | | verify_result_code | 枚举 | 检定结果 | VerifyResultEnum | | exec_progress_code | 枚举 | 执行进度 | ExecProgressEnum | ### wssmet_disverifyexec_w — 争议检定现场执行（App） | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | exec_node_code | 枚举 | 执行节点 | ExecNodeEnum | ### wssmet_otherverify_w — 其他检定登记 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | caliber_code | 字典 | 口径 | METER_DIAMETER | | meter_type_code | 字典 | 水表类型 | METER_TYPE | | verify_reason_code | 字典 | 检定原因 | METER_VERIFY_REASON | | verify_result_code | 枚举 | 检定结果 | VerifyResultEnum | ### wssmet_verifyrecord_w — 检定记录（测量系统对接） | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | verify_result_code | 枚举 | 检定结果 | VerifyResultEnum | | verify_attr_code | 字典 | 检定属性 | METER_VERIFY_ATTR | | record_status_code | 枚举 | 记录状态 | RecordStatusEnum | ### wssmet_invin_w — 入库主单 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | in_type_code | 枚举 | 入库类型 | InboundTypeEnum | | in_stock_attr_code | 字典 | 入库库存属性 | METER_IN_STOCK_ATTR | | status_code | 枚举 | 状态 | CommonStatusEnum | ### wssmet_invinmeter_w — 入库水表明细 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | caliber_code | 字典 | 口径 | METER_DIAMETER | | meter_type_code | 字典 | 水表类型 | METER_TYPE | ### wssmet_invout_w — 出库主单 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | out_type_code | 枚举 | 出库类型 | OutboundTypeEnum | | status_code | 枚举 | 状态 | CommonStatusEnum | ### wssmet_invoutmeter_w — 出库水表明细 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | caliber_code | 字典 | 口径 | METER_DIAMETER | | meter_type_code | 字典 | 水表类型 | METER_TYPE | ### wssmet_invconfirm_w — 总仓入库确认（退返接收） | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | confirm_status_code | 枚举 | 确认状态 | ConfirmStatusEnum | ### wssmet_stnreturnin_w — 营业所退库入库登记 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | return_hq_tag_code | 字典 | 退回总仓标签 | METER_RETURN_HQ_TAG | | status_code | 枚举 | 状态 | CommonStatusEnum | ### wssmet_retstnapply_w — 营业所退库申请 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | return_reason_code | 字典 | 退回原因 | METER_RETURN_REASON | | approve_status | 枚举 | 审批状态 | ApproveStatusEnum | | inbound_status_code | 枚举 | 入库状态 | InboundStatusEnum | ### wssmet_retstnapplymeter_w — 营业所退库申请明细 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | caliber_code | 字典 | 口径 | METER_DIAMETER | | meter_type_code | 字典 | 水表类型 | METER_TYPE | ### wssmet_rethqapply_w — 分公司旧表退回总仓申请 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | return_reason_code | 字典 | 退回原因 | METER_RETURN_REASON | | approve_status | 枚举 | 审批状态 | ApproveStatusEnum | | out_status_code | 枚举 | 出库状态 | OutboundStatusEnum | | hq_in_status_code | 枚举 | 总仓入库状态 | HqInboundStatusEnum | ### wssmet_rethqapplymeter_w — 退回总仓申请明细 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | caliber_code | 字典 | 口径 | METER_DIAMETER | | meter_type_code | 字典 | 水表类型 | METER_TYPE | ### wssmet_installtask_w — 新装安装任务 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | task_source_code | 枚举 | 任务来源 | TaskSourceEnum | | task_status_code | 枚举 | 任务状态 | TaskStatusEnum | ### wssmet_installaccept_w — 新装安装验收 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | accept_result_code | 枚举 | 验收结果 | AcceptResultEnum | ### wssmet_replaceapply_w — 换表申请 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | replace_type_code | 枚举 | 换表类型 | ReplaceTypeEnum | | replace_reason_code | 字典 | 换表原因 | METER_REPLACE_REASON | | approve_status | 枚举 | 审批状态 | ApproveStatusEnum | ### wssmet_replacetask_w — 换表任务 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | replace_type_code | 枚举 | 换表类型 | ReplaceTypeEnum | | task_status_code | 枚举 | 任务状态 | TaskStatusEnum | | old_meter_collect_status_code | 枚举 | 旧表回收状态 | CollectStatusEnum | ### wssmet_relocateapply_w — 迁表申请 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | relocate_reason_code | 字典 | 迁表原因 | METER_RELOCATE_REASON | | approve_status | 枚举 | 审批状态 | ApproveStatusEnum | ### wssmet_relocatetask_w — 迁表任务 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | task_source_code | 枚举 | 任务来源 | TaskSourceEnum | | relocate_reason_code | 字典 | 迁表原因 | METER_RELOCATE_REASON | | task_status_code | 枚举 | 任务状态 | TaskStatusEnum | ### wssmet_removeapply_w — 拆表申请 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | remove_reason_code | 字典 | 拆表原因 | METER_REMOVE_REASON | | approve_status | 枚举 | 审批状态 | ApproveStatusEnum | | return_status_code | 枚举 | 退回状态 | ReturnStatusEnum | ### wssmet_removetask_w — 拆表任务 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | task_source_code | 枚举 | 任务来源 | TaskSourceEnum | | remove_reason_code | 字典 | 拆表原因 | METER_REMOVE_REASON | | task_status_code | 枚举 | 任务状态 | TaskStatusEnum | | old_meter_collect_status_code | 枚举 | 旧表回收状态 | CollectStatusEnum | ### wssmet_removerec_w — 拆表现场记录（App） | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | collect_status_code | 枚举 | 旧表回收状态 | CollectStatusEnum | ### wssmet_rotatetask_w — 到期轮换任务 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | task_status_code | 枚举 | 任务状态 | TaskStatusEnum | ### wssmet_rotatetaskmeter_w — 到期轮换任务水表明细 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | caliber_code | 字典 | 口径 | METER_DIAMETER | | meter_type_code | 字典 | 水表类型 | METER_TYPE | | rotate_status_code | 枚举 | 轮换状态 | RotateStatusEnum | ### wssmet_rotaterec_w — 轮换现场记录（App） | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | old_collect_status_code | 枚举 | 旧归集状态 | CollectStatusEnum | ### wssmet_inspectcfg_w — 周期检查规则配置 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | status_code | 枚举 | 状态 | CommonStatusEnum | ### wssmet_inspecttask_w — 周期检查任务 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | task_status_code | 枚举 | 任务状态 | TaskStatusEnum | | sample_mode_code | 字典 | 抽检方式 | METER_SAMPLE_MODE | ### wssmet_inspecttaskmeter_w — 周期检查任务水表明细 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | inspect_status_code | 枚举 | 检查状态 | InspectStatusEnum | ### wssmet_inspectrec_w — 周期检查现场记录（App） | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | run_status_code | 枚举 | 运行状态 | RunStatusEnum | | body_status_code | 枚举 | 表体状态 | BodyStatusEnum | | seal_status_code | 枚举 | 铅封状态 | SealStatusEnum | | leak_status_code | 枚举 | 漏水状态 | LeakStatusEnum | | illegal_use_code | 字典 | 违规用水 | METER_ILLEGAL_USE | | reading_compare_code | 字典 | 读数比对结果 | METER_READING_COMPARE | ### wssmet_scrapapply_w — 报废申请 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | scrap_reason_code | 字典 | 报废原因 | METER_SCRAP_REASON | | approve_status | 枚举 | 审批状态 | ApproveStatusEnum | | register_status_code | 枚举 | 登记状态 | RegisterStatusEnum | ### wssmet_scrapapplylist_w — 报废申请明细 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | caliber_code | 字典 | 口径 | METER_DIAMETER | | meter_type_code | 字典 | 水表类型 | METER_TYPE | ### wssmet_scrapreg_w — 报废登记 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | approve_status | 枚举 | 审批状态 | ApproveStatusEnum | | scrap_reason_code | 字典 | 报废原因 | METER_SCRAP_REASON | | register_status_code | 枚举 | 登记状态 | RegisterStatusEnum | | dispose_status_code | 枚举 | 处置状态 | DisposeStatusEnum | ### wssmet_scrapreglist_w — 报废登记明细 | 字段 | 类型 | 说明 | 引用 | |------|------|------|------| | caliber_code | 字典 | 口径 | METER_DIAMETER | | meter_type_code | 字典 | 水表类型 | METER_TYPE | ## 3. 表清单（共 65 张，无本地工单表） | 序号 | 表名 | 说明 | |------|------|------| | 1 | `wssmet_meter_w` | 水表主数据（资产档案） | | 2 | `wssmet_meterlife_w` | 水表生命周期事件 | | 3 | `wssmet_warehouse_w` | 仓库（总仓/分仓） | | 4 | `wssmet_meterbrand_w` | 水表厂家 | | 5 | `wssmet_brandmodel_w` | 水表型号 | | 6 | `wssmet_cyclerule_w` | 检定/轮换/报废周期规则 | | 7 | `wssmet_invalert_w` | 库存预警规则 | | 8 | `wssmet_purapply_w` | 采购申请 | | 9 | `wssmet_purapplylist_w` | 采购申请明细 | | 10 | `wssmet_purplan_w` | 采购计划 | | 11 | `wssmet_purplanarr_w` | 采购到货批次 | | 12 | `wssmet_purplanarrlist_w` | 采购到货水表明细 | | 13 | `wssmet_landverify_w` | 落地检登记 | | 14 | `wssmet_retfactory_w` | 不合格返厂登记 | | 15 | `wssmet_claimapply_w` | 领用申请 | | 16 | `wssmet_claimapplylist_w` | 领用申请明细 | | 17 | `wssmet_claimreg_w` | 领取登记 | | 18 | `wssmet_claimregmeter_w` | 领取登记水表明细 | | 19 | `wssmet_transferapply_w` | 调拨申请 | | 20 | `wssmet_transferout_w` | 调拨出库登记 | | 21 | `wssmet_transferoutmeter_w` | 调拨出库水表明细 | | 22 | `wssmet_transferin_w` | 调拨入库确认 | | 23 | `wssmet_transferinmeter_w` | 调拨入库水表明细 | | 24 | `wssmet_expverifytask_w` | 到期检定任务 | | 25 | `wssmet_expverifytaskmeter_w` | 到期检定任务水表明细 | | 26 | `wssmet_expverifyexec_w` | 到期检定现场执行（App） | | 27 | `wssmet_disverifyapply_w` | 争议检定申请 | | 28 | `wssmet_disverifytask_w` | 争议检定任务 | | 29 | `wssmet_disverifyexec_w` | 争议检定现场执行（App） | | 30 | `wssmet_otherverify_w` | 其他检定登记 | | 31 | `wssmet_verifyrecord_w` | 检定记录（测量系统对接） | | 32 | `wssmet_invin_w` | 入库主单 | | 33 | `wssmet_invinmeter_w` | 入库水表明细 | | 34 | `wssmet_invout_w` | 出库主单 | | 35 | `wssmet_invoutmeter_w` | 出库水表明细 | | 36 | `wssmet_invconfirm_w` | 总仓入库确认（退返接收） | | 37 | `wssmet_stnreturnin_w` | 营业所退库入库登记 | | 38 | `wssmet_retstnapply_w` | 营业所退库申请 | | 39 | `wssmet_retstnapplymeter_w` | 营业所退库申请明细 | | 40 | `wssmet_rethqapply_w` | 分公司旧表退回总仓申请 | | 41 | `wssmet_rethqapplymeter_w` | 退回总仓申请明细 | | 42 | `wssmet_installtask_w` | 新装安装任务 | | 43 | `wssmet_installrec_w` | 新装现场记录（App） | | 44 | `wssmet_installaccept_w` | 新装安装验收 | | 45 | `wssmet_replaceapply_w` | 换表申请 | | 46 | `wssmet_replaceapplylist_w` | 换表申请明细 | | 47 | `wssmet_replacetask_w` | 换表任务 | | 48 | `wssmet_replacerec_w` | 换表现场记录（App） | | 49 | `wssmet_relocateapply_w` | 迁表申请 | | 50 | `wssmet_relocatetask_w` | 迁表任务 | | 51 | `wssmet_relocaterec_w` | 迁表现场记录（App） | | 52 | `wssmet_removeapply_w` | 拆表申请 | | 53 | `wssmet_removetask_w` | 拆表任务 | | 54 | `wssmet_removerec_w` | 拆表现场记录（App） | | 55 | `wssmet_rotatetask_w` | 到期轮换任务 | | 56 | `wssmet_rotatetaskmeter_w` | 到期轮换任务水表明细 | | 57 | `wssmet_rotaterec_w` | 轮换现场记录（App） | | 58 | `wssmet_inspectcfg_w` | 周期检查规则配置 | | 59 | `wssmet_inspecttask_w` | 周期检查任务 | | 60 | `wssmet_inspecttaskmeter_w` | 周期检查任务水表明细 | | 61 | `wssmet_inspectrec_w` | 周期检查现场记录（App） | | 62 | `wssmet_scrapapply_w` | 报废申请 | | 63 | `wssmet_scrapapplylist_w` | 报废申请明细 | | 64 | `wssmet_scrapreg_w` | 报废登记 | | 65 | `wssmet_scrapreglist_w` | 报废登记明细 | ## 4. 完整 DDL 与注释 > 以下 DDL 字段自 PRD 业务归纳；列注释为中文。 ### 4.1 wssmet_meter_w — 水表主数据（资产档案） ```sql CREATE TABLE wssmet_meter_w ( id NUMBER(19) NOT NULL, meter_code VARCHAR2(64) , factory_code VARCHAR2(64) , caliber_code VARCHAR2(64) , meter_type_code VARCHAR2(64) , meter_status_code VARCHAR2(64) , in_stock_attr_code VARCHAR2(64) , warehouse_id NUMBER(19) , brand_id NUMBER(19) , brand_model_id NUMBER(19) , seal_no VARCHAR2(64) , user_no VARCHAR2(64) , user_name VARCHAR2(128) , install_address VARCHAR2(512) , meter_position VARCHAR2(256) , first_verify_date DATE , last_verify_date DATE , next_verify_date DATE , rotate_due_date DATE , purchase_plan_id NUMBER(19) , manage_org_id NUMBER(19) , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_meter_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_meter_w IS '水表主数据'; COMMENT ON COLUMN wssmet_meter_w.id IS '主键'; COMMENT ON COLUMN wssmet_meter_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_meter_w.factory_code IS '出厂编码'; COMMENT ON COLUMN wssmet_meter_w.caliber_code IS '口径编号，字典类型，目录码METER_DIAMETER'; COMMENT ON COLUMN wssmet_meter_w.meter_type_code IS '水表类型编号，字典类型，目录码METER_TYPE'; COMMENT ON COLUMN wssmet_meter_w.meter_status_code IS '水表状态，枚举类型，MeterStatusEnum'; COMMENT ON COLUMN wssmet_meter_w.in_stock_attr_code IS '入库库存属性编号，字典类型，目录码METER_IN_STOCK_ATTR'; COMMENT ON COLUMN wssmet_meter_w.warehouse_id IS '仓库ID，关联wssmet_warehouse_w表的id字段'; COMMENT ON COLUMN wssmet_meter_w.brand_id IS '厂家ID，关联wssmet_meterbrand_w表的id字段'; COMMENT ON COLUMN wssmet_meter_w.brand_model_id IS '厂家型号ID，关联wssmet_brandmodel_w表的id字段'; COMMENT ON COLUMN wssmet_meter_w.seal_no IS '铅封'; COMMENT ON COLUMN wssmet_meter_w.user_no IS '用户'; COMMENT ON COLUMN wssmet_meter_w.user_name IS '用户'; COMMENT ON COLUMN wssmet_meter_w.install_address IS '安装地址'; COMMENT ON COLUMN wssmet_meter_w.meter_position IS '水表表位'; COMMENT ON COLUMN wssmet_meter_w.first_verify_date IS '首次检定日期'; COMMENT ON COLUMN wssmet_meter_w.last_verify_date IS '最近检定日期'; COMMENT ON COLUMN wssmet_meter_w.next_verify_date IS '下次检定日期'; COMMENT ON COLUMN wssmet_meter_w.rotate_due_date IS '轮换到期日期'; COMMENT ON COLUMN wssmet_meter_w.purchase_plan_id IS '采购计划ID，关联wssmet_purplan_w表的id字段'; COMMENT ON COLUMN wssmet_meter_w.manage_org_id IS '管辖组织ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_meter_w.remark IS '备注'; COMMENT ON COLUMN wssmet_meter_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_meter_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_meter_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_meter_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_meter_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_meter_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_meter_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_meter_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_meter_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_meter_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_meter_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_meter_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_meter_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_meter_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.2 wssmet_meterlife_w — 水表生命周期事件 ```sql CREATE TABLE wssmet_meterlife_w ( id NUMBER(19) NOT NULL, meter_id NUMBER(19) , event_type_code VARCHAR2(64) , event_time TIMESTAMP , ref_table_name VARCHAR2(64) , ref_table_id NUMBER(19) , ref_biz_code VARCHAR2(64) , event_desc VARCHAR2(512) , operator_id NUMBER(19) , create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_meterlife_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_meterlife_w IS '水表生命周期事件'; COMMENT ON COLUMN wssmet_meterlife_w.id IS '主键'; COMMENT ON COLUMN wssmet_meterlife_w.meter_id IS '水表ID，关联wssmet_meter_w表的id字段'; COMMENT ON COLUMN wssmet_meterlife_w.event_type_code IS '事件类型，枚举类型，MeterLifeEventTypeEnum'; COMMENT ON COLUMN wssmet_meterlife_w.event_time IS '事件时间'; COMMENT ON COLUMN wssmet_meterlife_w.ref_table_name IS '关联表'; COMMENT ON COLUMN wssmet_meterlife_w.ref_table_id IS '关联业务表主键ID，关联（见 ref_table_name）表的id字段'; COMMENT ON COLUMN wssmet_meterlife_w.ref_biz_code IS '关联业务编号'; COMMENT ON COLUMN wssmet_meterlife_w.event_desc IS '事件'; COMMENT ON COLUMN wssmet_meterlife_w.operator_id IS '操作人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_meterlife_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_meterlife_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_meterlife_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_meterlife_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_meterlife_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_meterlife_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_meterlife_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_meterlife_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_meterlife_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_meterlife_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_meterlife_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_meterlife_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_meterlife_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_meterlife_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.3 wssmet_warehouse_w — 仓库（总仓/分仓） ```sql CREATE TABLE wssmet_warehouse_w ( id NUMBER(19) NOT NULL, warehouse_name VARCHAR2(128) , warehouse_type_code VARCHAR2(32) , org_id NUMBER(19) , address VARCHAR2(512) , status_code VARCHAR2(32) , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_warehouse_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_warehouse_w IS '仓库'; COMMENT ON COLUMN wssmet_warehouse_w.id IS '主键'; COMMENT ON COLUMN wssmet_warehouse_w.warehouse_name IS '仓库'; COMMENT ON COLUMN wssmet_warehouse_w.warehouse_type_code IS '仓库类型，枚举类型，WarehouseTypeEnum'; COMMENT ON COLUMN wssmet_warehouse_w.org_id IS '组织ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_warehouse_w.address IS '地址'; COMMENT ON COLUMN wssmet_warehouse_w.status_code IS '状态，枚举类型，CommonStatusEnum'; COMMENT ON COLUMN wssmet_warehouse_w.remark IS '备注'; COMMENT ON COLUMN wssmet_warehouse_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_warehouse_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_warehouse_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_warehouse_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_warehouse_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_warehouse_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_warehouse_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_warehouse_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_warehouse_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_warehouse_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_warehouse_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_warehouse_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_warehouse_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_warehouse_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.4 wssmet_meterbrand_w — 水表厂家 ```sql CREATE TABLE wssmet_meterbrand_w ( id NUMBER(19) NOT NULL, brand_name VARCHAR2(128) , contact VARCHAR2(64) , phone VARCHAR2(32) , status_code VARCHAR2(32) , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_meterbrand_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_meterbrand_w IS '水表厂家'; COMMENT ON COLUMN wssmet_meterbrand_w.id IS '主键'; COMMENT ON COLUMN wssmet_meterbrand_w.brand_name IS '厂家'; COMMENT ON COLUMN wssmet_meterbrand_w.contact IS '联系人'; COMMENT ON COLUMN wssmet_meterbrand_w.phone IS '联系电话'; COMMENT ON COLUMN wssmet_meterbrand_w.status_code IS '状态，枚举类型，CommonStatusEnum'; COMMENT ON COLUMN wssmet_meterbrand_w.remark IS '备注'; COMMENT ON COLUMN wssmet_meterbrand_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_meterbrand_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_meterbrand_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_meterbrand_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_meterbrand_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_meterbrand_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_meterbrand_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_meterbrand_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_meterbrand_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_meterbrand_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_meterbrand_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_meterbrand_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_meterbrand_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_meterbrand_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.5 wssmet_brandmodel_w — 水表型号 ```sql CREATE TABLE wssmet_brandmodel_w ( id NUMBER(19) NOT NULL, brand_id NUMBER(19) , model_name VARCHAR2(128) , caliber_code VARCHAR2(64) , meter_type_code VARCHAR2(64) , spec_desc VARCHAR2(512) , status_code VARCHAR2(32), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_brandmodel_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_brandmodel_w IS '水表型号'; COMMENT ON COLUMN wssmet_brandmodel_w.id IS '主键'; COMMENT ON COLUMN wssmet_brandmodel_w.brand_id IS '厂家ID，关联wssmet_meterbrand_w表的id字段'; COMMENT ON COLUMN wssmet_brandmodel_w.model_name IS '型号'; COMMENT ON COLUMN wssmet_brandmodel_w.caliber_code IS '口径编号，字典类型，目录码METER_DIAMETER'; COMMENT ON COLUMN wssmet_brandmodel_w.meter_type_code IS '水表类型编号，字典类型，目录码METER_TYPE'; COMMENT ON COLUMN wssmet_brandmodel_w.spec_desc IS '规格'; COMMENT ON COLUMN wssmet_brandmodel_w.status_code IS '状态，枚举类型，CommonStatusEnum'; COMMENT ON COLUMN wssmet_brandmodel_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_brandmodel_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_brandmodel_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_brandmodel_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_brandmodel_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_brandmodel_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_brandmodel_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_brandmodel_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_brandmodel_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_brandmodel_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_brandmodel_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_brandmodel_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_brandmodel_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_brandmodel_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.6 wssmet_cyclerule_w — 检定/轮换/报废周期规则 ```sql CREATE TABLE wssmet_cyclerule_w ( id NUMBER(19) NOT NULL, rule_type_code VARCHAR2(64) , caliber_code VARCHAR2(64) , meter_type_code VARCHAR2(64) , cycle_years NUMBER(10) , warn_months_ahead NUMBER(10) , status_code VARCHAR2(32) , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_cyclerule_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_cyclerule_w IS '周期规则配置'; COMMENT ON COLUMN wssmet_cyclerule_w.id IS '主键'; COMMENT ON COLUMN wssmet_cyclerule_w.rule_type_code IS '规则类型，枚举类型，CycleRuleTypeEnum'; COMMENT ON COLUMN wssmet_cyclerule_w.caliber_code IS '口径编号，字典类型，目录码METER_DIAMETER'; COMMENT ON COLUMN wssmet_cyclerule_w.meter_type_code IS '水表类型编号，字典类型，目录码METER_TYPE'; COMMENT ON COLUMN wssmet_cyclerule_w.cycle_years IS '周期'; COMMENT ON COLUMN wssmet_cyclerule_w.warn_months_ahead IS '预警'; COMMENT ON COLUMN wssmet_cyclerule_w.status_code IS '状态，枚举类型，CommonStatusEnum'; COMMENT ON COLUMN wssmet_cyclerule_w.remark IS '备注'; COMMENT ON COLUMN wssmet_cyclerule_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_cyclerule_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_cyclerule_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_cyclerule_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_cyclerule_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_cyclerule_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_cyclerule_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_cyclerule_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_cyclerule_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_cyclerule_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_cyclerule_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_cyclerule_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_cyclerule_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_cyclerule_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.7 wssmet_invalert_w — 库存预警规则 ```sql CREATE TABLE wssmet_invalert_w ( id NUMBER(19) NOT NULL, warehouse_id NUMBER(19) , caliber_code VARCHAR2(64) , meter_type_code VARCHAR2(64) , in_stock_attr_code VARCHAR2(64) , min_qty NUMBER(10) , max_qty NUMBER(10) , warn_lead_days NUMBER(10) , notify_users VARCHAR2(512) , status_code VARCHAR2(32), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_invalert_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_invalert_w IS '库存预警规则（占位）'; COMMENT ON COLUMN wssmet_invalert_w.id IS '主键'; COMMENT ON COLUMN wssmet_invalert_w.warehouse_id IS '仓库ID，关联wssmet_warehouse_w表的id字段'; COMMENT ON COLUMN wssmet_invalert_w.caliber_code IS '口径编号，字典类型，目录码METER_DIAMETER'; COMMENT ON COLUMN wssmet_invalert_w.meter_type_code IS '水表类型编号，字典类型，目录码METER_TYPE'; COMMENT ON COLUMN wssmet_invalert_w.in_stock_attr_code IS '入库库存属性编号，字典类型，目录码METER_IN_STOCK_ATTR'; COMMENT ON COLUMN wssmet_invalert_w.min_qty IS '下限数量'; COMMENT ON COLUMN wssmet_invalert_w.max_qty IS '上限数量'; COMMENT ON COLUMN wssmet_invalert_w.warn_lead_days IS '预警提前'; COMMENT ON COLUMN wssmet_invalert_w.notify_users IS '通知'; COMMENT ON COLUMN wssmet_invalert_w.status_code IS '状态，枚举类型，CommonStatusEnum'; COMMENT ON COLUMN wssmet_invalert_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_invalert_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_invalert_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_invalert_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_invalert_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_invalert_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_invalert_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_invalert_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_invalert_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_invalert_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_invalert_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_invalert_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_invalert_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_invalert_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.8 wssmet_purapply_w — 采购申请 ```sql CREATE TABLE wssmet_purapply_w ( id NUMBER(19) NOT NULL, apply_code VARCHAR2(64) , apply_dept_id NUMBER(19) , apply_user_id NUMBER(19) , apply_date DATE , demand_desc VARCHAR2(512) , process_instance_id VARCHAR2(64) , work_order_code VARCHAR2(64) , approve_status VARCHAR2(32) , process_status_code VARCHAR2(32) , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_purapply_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_purapply_w IS '采购申请'; COMMENT ON COLUMN wssmet_purapply_w.id IS '主键'; COMMENT ON COLUMN wssmet_purapply_w.apply_code IS '申请编号'; COMMENT ON COLUMN wssmet_purapply_w.apply_dept_id IS '申请部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_purapply_w.apply_user_id IS '申请用户ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_purapply_w.apply_date IS '申请日期'; COMMENT ON COLUMN wssmet_purapply_w.demand_desc IS '需求'; COMMENT ON COLUMN wssmet_purapply_w.process_status_code IS '流程状态，枚举类型，ProcessStatusEnum'; COMMENT ON COLUMN wssmet_purapply_w.remark IS '备注'; COMMENT ON COLUMN wssmet_purapply_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_purapply_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_purapply_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_purapply_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_purapply_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_purapply_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_purapply_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_purapply_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_purapply_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_purapply_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_purapply_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_purapply_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_purapply_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_purapply_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_purapply_w.process_instance_id IS 'workflow 流程实例ID（工单中心外挂，不落本地工单表）'; COMMENT ON COLUMN wssmet_purapply_w.work_order_code IS '工单编号（展示/台账查询）'; COMMENT ON COLUMN wssmet_purapply_w.approve_status IS '审批状态：draft/pending/approved/rejected/cancelled 等，枚举类型，ApproveStatusEnum'; ``` ### 4.9 wssmet_purapplylist_w — 采购申请明细 ```sql CREATE TABLE wssmet_purapplylist_w ( id NUMBER(19) NOT NULL, apply_id NUMBER(19) , caliber_code VARCHAR2(64) , meter_type_code VARCHAR2(64) , apply_qty NUMBER(10) , brand_id NUMBER(19) , remark VARCHAR2(256), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_purapplylist_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_purapplylist_w IS '采购申请明细'; COMMENT ON COLUMN wssmet_purapplylist_w.id IS '主键'; COMMENT ON COLUMN wssmet_purapplylist_w.apply_id IS '采购申请ID，关联wssmet_purapply_w表的id字段'; COMMENT ON COLUMN wssmet_purapplylist_w.caliber_code IS '口径编号，字典类型，目录码METER_DIAMETER'; COMMENT ON COLUMN wssmet_purapplylist_w.meter_type_code IS '水表类型编号，字典类型，目录码METER_TYPE'; COMMENT ON COLUMN wssmet_purapplylist_w.apply_qty IS '申请数量'; COMMENT ON COLUMN wssmet_purapplylist_w.brand_id IS '厂家ID，关联wssmet_meterbrand_w表的id字段'; COMMENT ON COLUMN wssmet_purapplylist_w.remark IS '备注'; COMMENT ON COLUMN wssmet_purapplylist_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_purapplylist_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_purapplylist_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_purapplylist_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_purapplylist_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_purapplylist_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_purapplylist_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_purapplylist_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_purapplylist_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_purapplylist_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_purapplylist_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_purapplylist_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_purapplylist_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_purapplylist_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.10 wssmet_purplan_w — 采购计划 ```sql CREATE TABLE wssmet_purplan_w ( id NUMBER(19) NOT NULL, plan_code VARCHAR2(64) , apply_id NUMBER(19) , brand_id NUMBER(19) , caliber_code VARCHAR2(64) , meter_type_code VARCHAR2(64) , plan_qty NUMBER(10) , branch_org_id NUMBER(19) , contract_no VARCHAR2(64) , purchase_date DATE , expect_arrive_date DATE , actual_arrive_date DATE , arrive_status_code VARCHAR2(32) , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_purplan_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_purplan_w IS '采购计划'; COMMENT ON COLUMN wssmet_purplan_w.id IS '主键'; COMMENT ON COLUMN wssmet_purplan_w.plan_code IS '计划编号'; COMMENT ON COLUMN wssmet_purplan_w.apply_id IS '采购申请ID，关联wssmet_purapply_w表的id字段'; COMMENT ON COLUMN wssmet_purplan_w.brand_id IS '厂家ID，关联wssmet_meterbrand_w表的id字段'; COMMENT ON COLUMN wssmet_purplan_w.caliber_code IS '口径编号，字典类型，目录码METER_DIAMETER'; COMMENT ON COLUMN wssmet_purplan_w.meter_type_code IS '水表类型编号，字典类型，目录码METER_TYPE'; COMMENT ON COLUMN wssmet_purplan_w.plan_qty IS '计划数量'; COMMENT ON COLUMN wssmet_purplan_w.branch_org_id IS '分公司组织ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_purplan_w.contract_no IS '合同'; COMMENT ON COLUMN wssmet_purplan_w.purchase_date IS '采购日期'; COMMENT ON COLUMN wssmet_purplan_w.expect_arrive_date IS '到货日期'; COMMENT ON COLUMN wssmet_purplan_w.actual_arrive_date IS '实际到货日期'; COMMENT ON COLUMN wssmet_purplan_w.arrive_status_code IS '到货状态，枚举类型，ArriveStatusEnum'; COMMENT ON COLUMN wssmet_purplan_w.remark IS '备注'; COMMENT ON COLUMN wssmet_purplan_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_purplan_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_purplan_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_purplan_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_purplan_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_purplan_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_purplan_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_purplan_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_purplan_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_purplan_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_purplan_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_purplan_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_purplan_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_purplan_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.11 wssmet_purplanarr_w — 采购到货批次 ```sql CREATE TABLE wssmet_purplanarr_w ( id NUMBER(19) NOT NULL, plan_id NUMBER(19) , arrive_date DATE , arrive_qty NUMBER(10) , sign_user_id NUMBER(19) , verify_deadline DATE , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_purplanarr_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_purplanarr_w IS '采购到货批次'; COMMENT ON COLUMN wssmet_purplanarr_w.id IS '主键'; COMMENT ON COLUMN wssmet_purplanarr_w.plan_id IS '采购计划ID，关联wssmet_purplan_w表的id字段'; COMMENT ON COLUMN wssmet_purplanarr_w.arrive_date IS '到货日期'; COMMENT ON COLUMN wssmet_purplanarr_w.arrive_qty IS '到货数量'; COMMENT ON COLUMN wssmet_purplanarr_w.sign_user_id IS '签收用户ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_purplanarr_w.verify_deadline IS '检定'; COMMENT ON COLUMN wssmet_purplanarr_w.remark IS '备注'; COMMENT ON COLUMN wssmet_purplanarr_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_purplanarr_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_purplanarr_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_purplanarr_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_purplanarr_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_purplanarr_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_purplanarr_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_purplanarr_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_purplanarr_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_purplanarr_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_purplanarr_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_purplanarr_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_purplanarr_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_purplanarr_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.12 wssmet_purplanarrlist_w — 采购到货水表明细 ```sql CREATE TABLE wssmet_purplanarrlist_w ( id NUMBER(19) NOT NULL, arr_id NUMBER(19) , meter_id NUMBER(19) , factory_code VARCHAR2(64) , meter_code VARCHAR2(64) , caliber_code VARCHAR2(64) , meter_type_code VARCHAR2(64), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_purplanarrlist_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_purplanarrlist_w IS '采购到货水表明细'; COMMENT ON COLUMN wssmet_purplanarrlist_w.id IS '主键'; COMMENT ON COLUMN wssmet_purplanarrlist_w.arr_id IS '到货批次ID，关联wssmet_purplanarr_w表的id字段'; COMMENT ON COLUMN wssmet_purplanarrlist_w.meter_id IS '水表ID，关联wssmet_meter_w表的id字段'; COMMENT ON COLUMN wssmet_purplanarrlist_w.factory_code IS '出厂编码'; COMMENT ON COLUMN wssmet_purplanarrlist_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_purplanarrlist_w.caliber_code IS '口径编号，字典类型，目录码METER_DIAMETER'; COMMENT ON COLUMN wssmet_purplanarrlist_w.meter_type_code IS '水表类型编号，字典类型，目录码METER_TYPE'; COMMENT ON COLUMN wssmet_purplanarrlist_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_purplanarrlist_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_purplanarrlist_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_purplanarrlist_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_purplanarrlist_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_purplanarrlist_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_purplanarrlist_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_purplanarrlist_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_purplanarrlist_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_purplanarrlist_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_purplanarrlist_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_purplanarrlist_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_purplanarrlist_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_purplanarrlist_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.13 wssmet_landverify_w — 落地检登记 ```sql CREATE TABLE wssmet_landverify_w ( id NUMBER(19) NOT NULL, meter_id NUMBER(19) , meter_code VARCHAR2(64) , factory_code VARCHAR2(64) , plan_id NUMBER(19) , verify_result_code VARCHAR2(32) , verify_date DATE , verify_user_id NUMBER(19) , verify_record_id VARCHAR2(64) , quality_value VARCHAR2(64) , volume_value VARCHAR2(64) , error_value VARCHAR2(64) , verify_desc VARCHAR2(512) , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_landverify_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_landverify_w IS '落地检登记'; COMMENT ON COLUMN wssmet_landverify_w.id IS '主键'; COMMENT ON COLUMN wssmet_landverify_w.meter_id IS '水表ID，关联wssmet_meter_w表的id字段'; COMMENT ON COLUMN wssmet_landverify_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_landverify_w.factory_code IS '出厂编码'; COMMENT ON COLUMN wssmet_landverify_w.plan_id IS '采购计划ID，关联wssmet_purplan_w表的id字段'; COMMENT ON COLUMN wssmet_landverify_w.verify_result_code IS '检定，枚举类型，VerifyResultEnum'; COMMENT ON COLUMN wssmet_landverify_w.verify_date IS '检定日期'; COMMENT ON COLUMN wssmet_landverify_w.verify_user_id IS '检定用户ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_landverify_w.verify_record_id IS '检定记录编号，关联wssmet_verifyrecord_w表的record_id字段'; COMMENT ON COLUMN wssmet_landverify_w.quality_value IS '质量指标'; COMMENT ON COLUMN wssmet_landverify_w.volume_value IS '体积指标'; COMMENT ON COLUMN wssmet_landverify_w.error_value IS '误差指标'; COMMENT ON COLUMN wssmet_landverify_w.verify_desc IS '检定'; COMMENT ON COLUMN wssmet_landverify_w.remark IS '备注'; COMMENT ON COLUMN wssmet_landverify_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_landverify_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_landverify_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_landverify_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_landverify_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_landverify_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_landverify_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_landverify_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_landverify_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_landverify_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_landverify_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_landverify_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_landverify_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_landverify_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.14 wssmet_retfactory_w — 不合格返厂登记 ```sql CREATE TABLE wssmet_retfactory_w ( id NUMBER(19) NOT NULL, meter_id NUMBER(19) , return_reason_code VARCHAR2(64) , logistics_company VARCHAR2(128) , logistics_no VARCHAR2(64) , return_date DATE , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_retfactory_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_retfactory_w IS '不合格返厂'; COMMENT ON COLUMN wssmet_retfactory_w.id IS '主键'; COMMENT ON COLUMN wssmet_retfactory_w.meter_id IS '水表ID，关联wssmet_meter_w表的id字段'; COMMENT ON COLUMN wssmet_retfactory_w.return_reason_code IS '退回原因编号，字典类型，目录码METER_RETURN_REASON'; COMMENT ON COLUMN wssmet_retfactory_w.logistics_company IS '物流公司'; COMMENT ON COLUMN wssmet_retfactory_w.logistics_no IS '物流'; COMMENT ON COLUMN wssmet_retfactory_w.return_date IS '退回日期'; COMMENT ON COLUMN wssmet_retfactory_w.remark IS '备注'; COMMENT ON COLUMN wssmet_retfactory_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_retfactory_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_retfactory_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_retfactory_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_retfactory_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_retfactory_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_retfactory_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_retfactory_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_retfactory_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_retfactory_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_retfactory_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_retfactory_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_retfactory_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_retfactory_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.15 wssmet_claimapply_w — 领用申请 ```sql CREATE TABLE wssmet_claimapply_w ( id NUMBER(19) NOT NULL, apply_code VARCHAR2(64) , target_warehouse_id NUMBER(19) , purpose_code VARCHAR2(64) , project_name VARCHAR2(128) , process_instance_id VARCHAR2(64) , work_order_code VARCHAR2(64) , approve_status VARCHAR2(32) , register_status_code VARCHAR2(32) , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_claimapply_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_claimapply_w IS '领用申请'; COMMENT ON COLUMN wssmet_claimapply_w.id IS '主键'; COMMENT ON COLUMN wssmet_claimapply_w.apply_code IS '申请编号'; COMMENT ON COLUMN wssmet_claimapply_w.target_warehouse_id IS '目标仓库ID，关联wssmet_warehouse_w表的id字段'; COMMENT ON COLUMN wssmet_claimapply_w.purpose_code IS '用途编号，字典类型，目录码METER_PURPOSE'; COMMENT ON COLUMN wssmet_claimapply_w.project_name IS '项目'; COMMENT ON COLUMN wssmet_claimapply_w.register_status_code IS '登记状态，枚举类型，RegisterStatusEnum'; COMMENT ON COLUMN wssmet_claimapply_w.remark IS '备注'; COMMENT ON COLUMN wssmet_claimapply_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_claimapply_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_claimapply_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_claimapply_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_claimapply_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_claimapply_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_claimapply_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_claimapply_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_claimapply_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_claimapply_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_claimapply_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_claimapply_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_claimapply_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_claimapply_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_claimapply_w.process_instance_id IS 'workflow 流程实例ID（工单中心外挂，不落本地工单表）'; COMMENT ON COLUMN wssmet_claimapply_w.work_order_code IS '工单编号（展示/台账查询）'; COMMENT ON COLUMN wssmet_claimapply_w.approve_status IS '审批状态：draft/pending/approved/rejected/cancelled 等，枚举类型，ApproveStatusEnum'; ``` ### 4.16 wssmet_claimapplylist_w — 领用申请明细 ```sql CREATE TABLE wssmet_claimapplylist_w ( id NUMBER(19) NOT NULL, apply_id NUMBER(19) , caliber_code VARCHAR2(64) , meter_type_code VARCHAR2(64) , apply_qty NUMBER(10), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_claimapplylist_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_claimapplylist_w IS '领用申请明细'; COMMENT ON COLUMN wssmet_claimapplylist_w.id IS '主键'; COMMENT ON COLUMN wssmet_claimapplylist_w.apply_id IS '领用申请ID，关联wssmet_claimapply_w表的id字段'; COMMENT ON COLUMN wssmet_claimapplylist_w.caliber_code IS '口径编号，字典类型，目录码METER_DIAMETER'; COMMENT ON COLUMN wssmet_claimapplylist_w.meter_type_code IS '水表类型编号，字典类型，目录码METER_TYPE'; COMMENT ON COLUMN wssmet_claimapplylist_w.apply_qty IS '申请数量'; COMMENT ON COLUMN wssmet_claimapplylist_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_claimapplylist_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_claimapplylist_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_claimapplylist_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_claimapplylist_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_claimapplylist_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_claimapplylist_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_claimapplylist_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_claimapplylist_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_claimapplylist_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_claimapplylist_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_claimapplylist_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_claimapplylist_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_claimapplylist_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.17 wssmet_claimreg_w — 领取登记 ```sql CREATE TABLE wssmet_claimreg_w ( id NUMBER(19) NOT NULL, register_code VARCHAR2(64) , apply_id NUMBER(19) , target_warehouse_id NUMBER(19) , receiver_id NUMBER(19) , receiver_name VARCHAR2(100) , receive_time TIMESTAMP , inbound_status_code VARCHAR2(32) , registrant_id NUMBER(19) , registrant_name VARCHAR2(100), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_claimreg_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_claimreg_w IS '领取登记'; COMMENT ON COLUMN wssmet_claimreg_w.id IS '主键'; COMMENT ON COLUMN wssmet_claimreg_w.register_code IS '登记编号'; COMMENT ON COLUMN wssmet_claimreg_w.apply_id IS '领用申请ID，关联wssmet_claimapply_w表的id字段'; COMMENT ON COLUMN wssmet_claimreg_w.target_warehouse_id IS '目标仓库ID，关联wssmet_warehouse_w表的id字段'; COMMENT ON COLUMN wssmet_claimreg_w.receiver_id IS '接收人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_claimreg_w.receiver_name IS '领用人'; COMMENT ON COLUMN wssmet_claimreg_w.receive_time IS '领用时间'; COMMENT ON COLUMN wssmet_claimreg_w.inbound_status_code IS '入库状态，枚举类型，InboundStatusEnum'; COMMENT ON COLUMN wssmet_claimreg_w.registrant_id IS '登记人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_claimreg_w.registrant_name IS '登记人'; COMMENT ON COLUMN wssmet_claimreg_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_claimreg_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_claimreg_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_claimreg_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_claimreg_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_claimreg_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_claimreg_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_claimreg_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_claimreg_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_claimreg_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_claimreg_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_claimreg_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_claimreg_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_claimreg_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.18 wssmet_claimregmeter_w — 领取登记水表明细 ```sql CREATE TABLE wssmet_claimregmeter_w ( id NUMBER(19) NOT NULL, register_id NUMBER(19) , meter_id NUMBER(19) , meter_code VARCHAR2(64) , seal_no VARCHAR2(64), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_claimregmeter_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_claimregmeter_w IS '领取登记水表明细'; COMMENT ON COLUMN wssmet_claimregmeter_w.id IS '主键'; COMMENT ON COLUMN wssmet_claimregmeter_w.register_id IS '领取登记ID，关联wssmet_claimreg_w表的id字段'; COMMENT ON COLUMN wssmet_claimregmeter_w.meter_id IS '水表ID，关联wssmet_meter_w表的id字段'; COMMENT ON COLUMN wssmet_claimregmeter_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_claimregmeter_w.seal_no IS '铅封'; COMMENT ON COLUMN wssmet_claimregmeter_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_claimregmeter_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_claimregmeter_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_claimregmeter_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_claimregmeter_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_claimregmeter_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_claimregmeter_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_claimregmeter_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_claimregmeter_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_claimregmeter_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_claimregmeter_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_claimregmeter_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_claimregmeter_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_claimregmeter_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.19 wssmet_transferapply_w — 调拨申请 ```sql CREATE TABLE wssmet_transferapply_w ( id NUMBER(19) NOT NULL, apply_code VARCHAR2(64) , out_org_id NUMBER(19) , in_org_id NUMBER(19) , project_name VARCHAR2(128) , caliber_code VARCHAR2(64) , meter_type_code VARCHAR2(64) , transfer_qty NUMBER(10) , purpose VARCHAR2(256) , stock_snapshot CLOB , process_instance_id VARCHAR2(64) , work_order_code VARCHAR2(64) , approve_status VARCHAR2(32) , out_status_code VARCHAR2(32) , in_status_code VARCHAR2(32) , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_transferapply_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_transferapply_w IS '调拨申请'; COMMENT ON COLUMN wssmet_transferapply_w.id IS '主键'; COMMENT ON COLUMN wssmet_transferapply_w.apply_code IS '申请编号'; COMMENT ON COLUMN wssmet_transferapply_w.out_org_id IS '出库组织ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_transferapply_w.in_org_id IS '入库组织ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_transferapply_w.project_name IS '项目'; COMMENT ON COLUMN wssmet_transferapply_w.caliber_code IS '口径编号，字典类型，目录码METER_DIAMETER'; COMMENT ON COLUMN wssmet_transferapply_w.meter_type_code IS '水表类型编号，字典类型，目录码METER_TYPE'; COMMENT ON COLUMN wssmet_transferapply_w.transfer_qty IS '调拨数量'; COMMENT ON COLUMN wssmet_transferapply_w.purpose IS '用途'; COMMENT ON COLUMN wssmet_transferapply_w.stock_snapshot IS '库存快照'; COMMENT ON COLUMN wssmet_transferapply_w.out_status_code IS '出库状态，枚举类型，OutboundStatusEnum'; COMMENT ON COLUMN wssmet_transferapply_w.in_status_code IS '入库状态，枚举类型，InboundStatusEnum'; COMMENT ON COLUMN wssmet_transferapply_w.remark IS '备注'; COMMENT ON COLUMN wssmet_transferapply_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_transferapply_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_transferapply_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_transferapply_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_transferapply_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_transferapply_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_transferapply_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_transferapply_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_transferapply_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_transferapply_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_transferapply_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_transferapply_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_transferapply_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_transferapply_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_transferapply_w.process_instance_id IS 'workflow 流程实例ID（工单中心外挂，不落本地工单表）'; COMMENT ON COLUMN wssmet_transferapply_w.work_order_code IS '工单编号（展示/台账查询）'; COMMENT ON COLUMN wssmet_transferapply_w.approve_status IS '审批状态：draft/pending/approved/rejected/cancelled 等，枚举类型，ApproveStatusEnum'; ``` ### 4.20 wssmet_transferout_w — 调拨出库登记 ```sql CREATE TABLE wssmet_transferout_w ( id NUMBER(19) NOT NULL, apply_id NUMBER(19) , out_code VARCHAR2(64) , receiver_id NUMBER(19) , receiver_name VARCHAR2(100) , receive_time TIMESTAMP , out_status_code VARCHAR2(32), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_transferout_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_transferout_w IS '调拨出库登记'; COMMENT ON COLUMN wssmet_transferout_w.id IS '主键'; COMMENT ON COLUMN wssmet_transferout_w.apply_id IS '调拨申请ID，关联wssmet_transferapply_w表的id字段'; COMMENT ON COLUMN wssmet_transferout_w.out_code IS '出库编号'; COMMENT ON COLUMN wssmet_transferout_w.receiver_id IS '接收人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_transferout_w.receiver_name IS '领用人'; COMMENT ON COLUMN wssmet_transferout_w.receive_time IS '领用时间'; COMMENT ON COLUMN wssmet_transferout_w.out_status_code IS '出库状态，枚举类型，OutboundStatusEnum'; COMMENT ON COLUMN wssmet_transferout_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_transferout_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_transferout_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_transferout_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_transferout_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_transferout_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_transferout_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_transferout_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_transferout_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_transferout_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_transferout_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_transferout_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_transferout_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_transferout_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.21 wssmet_transferoutmeter_w — 调拨出库水表明细 ```sql CREATE TABLE wssmet_transferoutmeter_w ( id NUMBER(19) NOT NULL, out_id NUMBER(19) , meter_id NUMBER(19) , meter_code VARCHAR2(64), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_transferoutmeter_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_transferoutmeter_w IS '调拨出库水表明细'; COMMENT ON COLUMN wssmet_transferoutmeter_w.id IS '主键'; COMMENT ON COLUMN wssmet_transferoutmeter_w.out_id IS '调拨出库登记ID，关联wssmet_transferout_w表的id字段'; COMMENT ON COLUMN wssmet_transferoutmeter_w.meter_id IS '水表ID，关联wssmet_meter_w表的id字段'; COMMENT ON COLUMN wssmet_transferoutmeter_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_transferoutmeter_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_transferoutmeter_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_transferoutmeter_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_transferoutmeter_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_transferoutmeter_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_transferoutmeter_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_transferoutmeter_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_transferoutmeter_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_transferoutmeter_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_transferoutmeter_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_transferoutmeter_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_transferoutmeter_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_transferoutmeter_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_transferoutmeter_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.22 wssmet_transferin_w — 调拨入库确认 ```sql CREATE TABLE wssmet_transferin_w ( id NUMBER(19) NOT NULL, apply_id NUMBER(19) , out_id NUMBER(19) , in_code VARCHAR2(64) , confirm_user_id NUMBER(19) , confirm_user_name VARCHAR2(100) , confirm_time TIMESTAMP , reject_reason VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_transferin_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_transferin_w IS '调拨入库确认'; COMMENT ON COLUMN wssmet_transferin_w.id IS '主键'; COMMENT ON COLUMN wssmet_transferin_w.apply_id IS '调拨申请ID，关联wssmet_transferapply_w表的id字段'; COMMENT ON COLUMN wssmet_transferin_w.out_id IS '调拨出库登记ID，关联wssmet_transferout_w表的id字段'; COMMENT ON COLUMN wssmet_transferin_w.in_code IS '入库编号'; COMMENT ON COLUMN wssmet_transferin_w.confirm_user_id IS '确认用户ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_transferin_w.confirm_user_name IS '确认用户'; COMMENT ON COLUMN wssmet_transferin_w.confirm_time IS '确认时间'; COMMENT ON COLUMN wssmet_transferin_w.reject_reason IS '驳回原因'; COMMENT ON COLUMN wssmet_transferin_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_transferin_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_transferin_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_transferin_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_transferin_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_transferin_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_transferin_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_transferin_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_transferin_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_transferin_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_transferin_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_transferin_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_transferin_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_transferin_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.23 wssmet_transferinmeter_w — 调拨入库水表明细 ```sql CREATE TABLE wssmet_transferinmeter_w ( id NUMBER(19) NOT NULL, in_id NUMBER(19) , meter_id NUMBER(19) , meter_code VARCHAR2(64), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_transferinmeter_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_transferinmeter_w IS '调拨入库水表明细'; COMMENT ON COLUMN wssmet_transferinmeter_w.id IS '主键'; COMMENT ON COLUMN wssmet_transferinmeter_w.in_id IS '调拨入库确认ID，关联wssmet_transferin_w表的id字段'; COMMENT ON COLUMN wssmet_transferinmeter_w.meter_id IS '水表ID，关联wssmet_meter_w表的id字段'; COMMENT ON COLUMN wssmet_transferinmeter_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_transferinmeter_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_transferinmeter_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_transferinmeter_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_transferinmeter_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_transferinmeter_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_transferinmeter_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_transferinmeter_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_transferinmeter_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_transferinmeter_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_transferinmeter_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_transferinmeter_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_transferinmeter_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_transferinmeter_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_transferinmeter_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.24 wssmet_expverifytask_w — 到期检定任务 ```sql CREATE TABLE wssmet_expverifytask_w ( id NUMBER(19) NOT NULL, task_code VARCHAR2(64) , task_name VARCHAR2(128) , task_deadline DATE , executor_id NUMBER(19) , meter_qty NUMBER(10) , task_status_code VARCHAR2(32) , creator_id NUMBER(19) , creator_name VARCHAR2(100) , dispatch_time TIMESTAMP , task_desc VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_expverifytask_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_expverifytask_w IS '到期检定任务'; COMMENT ON COLUMN wssmet_expverifytask_w.id IS '主键'; COMMENT ON COLUMN wssmet_expverifytask_w.task_code IS '任务编号'; COMMENT ON COLUMN wssmet_expverifytask_w.task_name IS '任务'; COMMENT ON COLUMN wssmet_expverifytask_w.task_deadline IS '任务'; COMMENT ON COLUMN wssmet_expverifytask_w.executor_id IS '执行人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_expverifytask_w.meter_qty IS '水表数量'; COMMENT ON COLUMN wssmet_expverifytask_w.task_status_code IS '任务状态，枚举类型，TaskStatusEnum'; COMMENT ON COLUMN wssmet_expverifytask_w.creator_id IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_expverifytask_w.creator_name IS '创建人'; COMMENT ON COLUMN wssmet_expverifytask_w.dispatch_time IS '分派时间'; COMMENT ON COLUMN wssmet_expverifytask_w.task_desc IS '任务'; COMMENT ON COLUMN wssmet_expverifytask_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_expverifytask_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_expverifytask_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_expverifytask_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_expverifytask_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_expverifytask_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_expverifytask_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_expverifytask_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_expverifytask_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_expverifytask_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_expverifytask_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_expverifytask_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_expverifytask_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_expverifytask_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.25 wssmet_expverifytaskmeter_w — 到期检定任务水表明细 ```sql CREATE TABLE wssmet_expverifytaskmeter_w ( id NUMBER(19) NOT NULL, task_id NUMBER(19) , meter_id NUMBER(19) , user_no VARCHAR2(64) , install_address VARCHAR2(512) , verify_status_code VARCHAR2(32) , verify_result_code VARCHAR2(32) , dispose_type_code VARCHAR2(32) , create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_expverifytaskmeter_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_expverifytaskmeter_w IS '到期检定任务水表明细'; COMMENT ON COLUMN wssmet_expverifytaskmeter_w.id IS '主键'; COMMENT ON COLUMN wssmet_expverifytaskmeter_w.task_id IS '到期检定任务ID，关联wssmet_expverifytask_w表的id字段'; COMMENT ON COLUMN wssmet_expverifytaskmeter_w.meter_id IS '水表ID，关联wssmet_meter_w表的id字段'; COMMENT ON COLUMN wssmet_expverifytaskmeter_w.user_no IS '用户'; COMMENT ON COLUMN wssmet_expverifytaskmeter_w.install_address IS '安装地址'; COMMENT ON COLUMN wssmet_expverifytaskmeter_w.verify_status_code IS '检定状态，枚举类型，VerifyStatusEnum'; COMMENT ON COLUMN wssmet_expverifytaskmeter_w.verify_result_code IS '检定，枚举类型，VerifyResultEnum'; COMMENT ON COLUMN wssmet_expverifytaskmeter_w.dispose_type_code IS '处置类型编号，字典类型，目录码METER_DISPOSE_TYPE'; COMMENT ON COLUMN wssmet_expverifytaskmeter_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_expverifytaskmeter_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_expverifytaskmeter_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_expverifytaskmeter_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_expverifytaskmeter_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_expverifytaskmeter_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_expverifytaskmeter_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_expverifytaskmeter_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_expverifytaskmeter_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_expverifytaskmeter_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_expverifytaskmeter_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_expverifytaskmeter_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_expverifytaskmeter_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_expverifytaskmeter_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.26 wssmet_expverifyexec_w — 到期检定现场执行（App） ```sql CREATE TABLE wssmet_expverifyexec_w ( id NUMBER(19) NOT NULL, task_meter_id NUMBER(19) , exec_node_code VARCHAR2(32) , exec_time TIMESTAMP , temp_meter_code VARCHAR2(64) , new_meter_code VARCHAR2(64) , remark VARCHAR2(512) , create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_expverifyexec_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_expverifyexec_w IS '到期检定执行记录(App)'; COMMENT ON COLUMN wssmet_expverifyexec_w.id IS '主键'; COMMENT ON COLUMN wssmet_expverifyexec_w.task_meter_id IS '到期检定任务水表明细ID，关联wssmet_expverifytaskmeter_w表的id字段'; COMMENT ON COLUMN wssmet_expverifyexec_w.exec_node_code IS '执行节点，枚举类型，ExecNodeEnum'; COMMENT ON COLUMN wssmet_expverifyexec_w.exec_time IS '执行时间'; COMMENT ON COLUMN wssmet_expverifyexec_w.temp_meter_code IS '临时水表编号'; COMMENT ON COLUMN wssmet_expverifyexec_w.new_meter_code IS '新水表编号'; COMMENT ON COLUMN wssmet_expverifyexec_w.remark IS '备注'; COMMENT ON COLUMN wssmet_expverifyexec_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_expverifyexec_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_expverifyexec_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_expverifyexec_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_expverifyexec_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_expverifyexec_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_expverifyexec_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_expverifyexec_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_expverifyexec_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_expverifyexec_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_expverifyexec_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_expverifyexec_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_expverifyexec_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_expverifyexec_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.27 wssmet_disverifyapply_w — 争议检定申请 ```sql CREATE TABLE wssmet_disverifyapply_w ( id NUMBER(19) NOT NULL, apply_code VARCHAR2(64) , dispute_reason_code VARCHAR2(64) , user_no VARCHAR2(64) , user_name VARCHAR2(128) , install_address VARCHAR2(512) , meter_id NUMBER(19) , meter_code VARCHAR2(64) , caliber_code VARCHAR2(64) , meter_type_code VARCHAR2(64) , dispute_desc VARCHAR2(500) , process_instance_id VARCHAR2(64) , work_order_code VARCHAR2(64) , approve_status VARCHAR2(32) , task_id NUMBER(19) , remark VARCHAR2(200), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_disverifyapply_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_disverifyapply_w IS '争议检定申请'; COMMENT ON COLUMN wssmet_disverifyapply_w.id IS '主键'; COMMENT ON COLUMN wssmet_disverifyapply_w.apply_code IS '申请编号'; COMMENT ON COLUMN wssmet_disverifyapply_w.dispute_reason_code IS '争议原因编号，字典类型，目录码METER_DISPUTE_REASON'; COMMENT ON COLUMN wssmet_disverifyapply_w.user_no IS '用户'; COMMENT ON COLUMN wssmet_disverifyapply_w.user_name IS '用户'; COMMENT ON COLUMN wssmet_disverifyapply_w.install_address IS '安装地址'; COMMENT ON COLUMN wssmet_disverifyapply_w.meter_id IS '水表ID，关联wssmet_meter_w表的id字段'; COMMENT ON COLUMN wssmet_disverifyapply_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_disverifyapply_w.caliber_code IS '口径编号，字典类型，目录码METER_DIAMETER'; COMMENT ON COLUMN wssmet_disverifyapply_w.meter_type_code IS '水表类型编号，字典类型，目录码METER_TYPE'; COMMENT ON COLUMN wssmet_disverifyapply_w.dispute_desc IS '争议'; COMMENT ON COLUMN wssmet_disverifyapply_w.task_id IS '争议检定任务ID，关联wssmet_disverifytask_w表的id字段'; COMMENT ON COLUMN wssmet_disverifyapply_w.remark IS '备注'; COMMENT ON COLUMN wssmet_disverifyapply_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_disverifyapply_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_disverifyapply_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_disverifyapply_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_disverifyapply_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_disverifyapply_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_disverifyapply_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_disverifyapply_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_disverifyapply_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_disverifyapply_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_disverifyapply_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_disverifyapply_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_disverifyapply_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_disverifyapply_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_disverifyapply_w.process_instance_id IS 'workflow 流程实例ID（工单中心外挂，不落本地工单表）'; COMMENT ON COLUMN wssmet_disverifyapply_w.work_order_code IS '工单编号（展示/台账查询）'; COMMENT ON COLUMN wssmet_disverifyapply_w.approve_status IS '审批状态：draft/pending/approved/rejected/cancelled 等，枚举类型，ApproveStatusEnum'; ``` ### 4.28 wssmet_disverifytask_w — 争议检定任务 ```sql CREATE TABLE wssmet_disverifytask_w ( id NUMBER(19) NOT NULL, task_code VARCHAR2(64) , apply_id NUMBER(19) , task_name VARCHAR2(100) , meter_id NUMBER(19) , user_no VARCHAR2(64) , user_name VARCHAR2(128) , executor_id NUMBER(19) , task_deadline DATE , task_status_code VARCHAR2(32) , verify_result_code VARCHAR2(32) , verify_date DATE , verify_user_id NUMBER(19) , verify_record_id VARCHAR2(64) , exec_progress_code VARCHAR2(32), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_disverifytask_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_disverifytask_w IS '争议检定任务'; COMMENT ON COLUMN wssmet_disverifytask_w.id IS '主键'; COMMENT ON COLUMN wssmet_disverifytask_w.task_code IS '任务编号'; COMMENT ON COLUMN wssmet_disverifytask_w.apply_id IS '争议检定申请ID，关联wssmet_disverifyapply_w表的id字段'; COMMENT ON COLUMN wssmet_disverifytask_w.task_name IS '任务'; COMMENT ON COLUMN wssmet_disverifytask_w.meter_id IS '水表ID，关联wssmet_meter_w表的id字段'; COMMENT ON COLUMN wssmet_disverifytask_w.user_no IS '用户'; COMMENT ON COLUMN wssmet_disverifytask_w.user_name IS '用户'; COMMENT ON COLUMN wssmet_disverifytask_w.executor_id IS '执行人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_disverifytask_w.task_deadline IS '任务'; COMMENT ON COLUMN wssmet_disverifytask_w.task_status_code IS '任务状态，枚举类型，TaskStatusEnum'; COMMENT ON COLUMN wssmet_disverifytask_w.verify_result_code IS '检定，枚举类型，VerifyResultEnum'; COMMENT ON COLUMN wssmet_disverifytask_w.verify_date IS '检定日期'; COMMENT ON COLUMN wssmet_disverifytask_w.verify_user_id IS '检定用户ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_disverifytask_w.verify_record_id IS '检定记录编号，关联wssmet_verifyrecord_w表的record_id字段'; COMMENT ON COLUMN wssmet_disverifytask_w.exec_progress_code IS '执行进度，枚举类型，ExecProgressEnum'; COMMENT ON COLUMN wssmet_disverifytask_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_disverifytask_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_disverifytask_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_disverifytask_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_disverifytask_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_disverifytask_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_disverifytask_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_disverifytask_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_disverifytask_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_disverifytask_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_disverifytask_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_disverifytask_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_disverifytask_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_disverifytask_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.29 wssmet_disverifyexec_w — 争议检定现场执行（App） ```sql CREATE TABLE wssmet_disverifyexec_w ( id NUMBER(19) NOT NULL, task_id NUMBER(19) , exec_node_code VARCHAR2(32) , temp_meter_code VARCHAR2(64) , new_meter_code VARCHAR2(64) , exec_time TIMESTAMP , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_disverifyexec_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_disverifyexec_w IS '争议检定执行记录(App)'; COMMENT ON COLUMN wssmet_disverifyexec_w.id IS '主键'; COMMENT ON COLUMN wssmet_disverifyexec_w.task_id IS '争议检定任务ID，关联wssmet_disverifytask_w表的id字段'; COMMENT ON COLUMN wssmet_disverifyexec_w.exec_node_code IS '执行节点，枚举类型，ExecNodeEnum'; COMMENT ON COLUMN wssmet_disverifyexec_w.temp_meter_code IS '临时水表编号'; COMMENT ON COLUMN wssmet_disverifyexec_w.new_meter_code IS '新水表编号'; COMMENT ON COLUMN wssmet_disverifyexec_w.exec_time IS '执行时间'; COMMENT ON COLUMN wssmet_disverifyexec_w.remark IS '备注'; COMMENT ON COLUMN wssmet_disverifyexec_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_disverifyexec_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_disverifyexec_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_disverifyexec_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_disverifyexec_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_disverifyexec_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_disverifyexec_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_disverifyexec_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_disverifyexec_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_disverifyexec_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_disverifyexec_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_disverifyexec_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_disverifyexec_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_disverifyexec_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.30 wssmet_otherverify_w — 其他检定登记 ```sql CREATE TABLE wssmet_otherverify_w ( id NUMBER(19) NOT NULL, register_code VARCHAR2(64) , meter_id NUMBER(19) , meter_code VARCHAR2(64) , caliber_code VARCHAR2(64) , meter_type_code VARCHAR2(64) , verify_reason_code VARCHAR2(64) , reason_desc VARCHAR2(200) , verify_result_code VARCHAR2(32) , verify_date DATE , verify_user_id NUMBER(19) , verify_record_id VARCHAR2(64) , verify_summary VARCHAR2(512) , remark VARCHAR2(500), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_otherverify_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_otherverify_w IS '其他检定登记'; COMMENT ON COLUMN wssmet_otherverify_w.id IS '主键'; COMMENT ON COLUMN wssmet_otherverify_w.register_code IS '登记编号'; COMMENT ON COLUMN wssmet_otherverify_w.meter_id IS '水表ID，关联wssmet_meter_w表的id字段'; COMMENT ON COLUMN wssmet_otherverify_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_otherverify_w.caliber_code IS '口径编号，字典类型，目录码METER_DIAMETER'; COMMENT ON COLUMN wssmet_otherverify_w.meter_type_code IS '水表类型编号，字典类型，目录码METER_TYPE'; COMMENT ON COLUMN wssmet_otherverify_w.verify_reason_code IS '检定原因编号，字典类型，目录码METER_VERIFY_REASON'; COMMENT ON COLUMN wssmet_otherverify_w.reason_desc IS '原因'; COMMENT ON COLUMN wssmet_otherverify_w.verify_result_code IS '检定，枚举类型，VerifyResultEnum'; COMMENT ON COLUMN wssmet_otherverify_w.verify_date IS '检定日期'; COMMENT ON COLUMN wssmet_otherverify_w.verify_user_id IS '检定用户ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_otherverify_w.verify_record_id IS '检定记录编号，关联wssmet_verifyrecord_w表的record_id字段'; COMMENT ON COLUMN wssmet_otherverify_w.verify_summary IS '检定摘要'; COMMENT ON COLUMN wssmet_otherverify_w.remark IS '备注'; COMMENT ON COLUMN wssmet_otherverify_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_otherverify_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_otherverify_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_otherverify_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_otherverify_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_otherverify_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_otherverify_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_otherverify_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_otherverify_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_otherverify_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_otherverify_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_otherverify_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_otherverify_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_otherverify_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.31 wssmet_verifyrecord_w — 检定记录（测量系统对接） ```sql CREATE TABLE wssmet_verifyrecord_w ( id NUMBER(19) NOT NULL, record_id VARCHAR2(64) , meter_code VARCHAR2(64) , verify_date DATE , verify_result_code VARCHAR2(32) , verify_user_id NUMBER(19) , source_system VARCHAR2(64) , verify_data CLOB , verify_attr_code VARCHAR2(64) , ref_table_name VARCHAR2(64) , ref_table_id NUMBER(19) , ref_biz_code VARCHAR2(64) , record_status_code VARCHAR2(32) , void_reason VARCHAR2(512) , sync_time TIMESTAMP, create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_verifyrecord_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_verifyrecord_w IS '检定记录(测量系统)'; COMMENT ON COLUMN wssmet_verifyrecord_w.id IS '主键'; COMMENT ON COLUMN wssmet_verifyrecord_w.record_id IS '记录'; COMMENT ON COLUMN wssmet_verifyrecord_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_verifyrecord_w.verify_date IS '检定日期'; COMMENT ON COLUMN wssmet_verifyrecord_w.verify_result_code IS '检定，枚举类型，VerifyResultEnum'; COMMENT ON COLUMN wssmet_verifyrecord_w.verify_user_id IS '检定用户ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_verifyrecord_w.source_system IS '来源'; COMMENT ON COLUMN wssmet_verifyrecord_w.verify_data IS '检定数据'; COMMENT ON COLUMN wssmet_verifyrecord_w.verify_attr_code IS '检定属性编号，字典类型，目录码METER_VERIFY_ATTR'; COMMENT ON COLUMN wssmet_verifyrecord_w.ref_table_name IS '关联表'; COMMENT ON COLUMN wssmet_verifyrecord_w.ref_table_id IS 'ref_tableID，关联（待补充）表的id字段'; COMMENT ON COLUMN wssmet_verifyrecord_w.ref_biz_code IS '关联业务编号'; COMMENT ON COLUMN wssmet_verifyrecord_w.record_status_code IS '记录状态，枚举类型，RecordStatusEnum'; COMMENT ON COLUMN wssmet_verifyrecord_w.void_reason IS '作废原因'; COMMENT ON COLUMN wssmet_verifyrecord_w.sync_time IS '同步时间'; COMMENT ON COLUMN wssmet_verifyrecord_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_verifyrecord_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_verifyrecord_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_verifyrecord_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_verifyrecord_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_verifyrecord_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_verifyrecord_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_verifyrecord_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_verifyrecord_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_verifyrecord_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_verifyrecord_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_verifyrecord_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_verifyrecord_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_verifyrecord_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.32 wssmet_invin_w — 入库主单 ```sql CREATE TABLE wssmet_invin_w ( id NUMBER(19) NOT NULL, in_code VARCHAR2(64) , warehouse_id NUMBER(19) , in_type_code VARCHAR2(64) , in_date DATE , in_stock_attr_code VARCHAR2(64) , ref_table_name VARCHAR2(64) , ref_table_id NUMBER(19) , ref_biz_code VARCHAR2(64) , registrant_id NUMBER(19) , registrant_name VARCHAR2(100) , status_code VARCHAR2(32) , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_invin_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_invin_w IS '入库主表'; COMMENT ON COLUMN wssmet_invin_w.id IS '主键'; COMMENT ON COLUMN wssmet_invin_w.in_code IS '入库编号'; COMMENT ON COLUMN wssmet_invin_w.warehouse_id IS '仓库ID，关联wssmet_warehouse_w表的id字段'; COMMENT ON COLUMN wssmet_invin_w.in_type_code IS '入库类型，枚举类型，InboundTypeEnum'; COMMENT ON COLUMN wssmet_invin_w.in_date IS '入库日期'; COMMENT ON COLUMN wssmet_invin_w.in_stock_attr_code IS '入库库存属性编号，字典类型，目录码METER_IN_STOCK_ATTR'; COMMENT ON COLUMN wssmet_invin_w.ref_table_name IS '关联表'; COMMENT ON COLUMN wssmet_invin_w.ref_table_id IS 'ref_tableID，关联（待补充）表的id字段'; COMMENT ON COLUMN wssmet_invin_w.ref_biz_code IS '关联业务编号'; COMMENT ON COLUMN wssmet_invin_w.registrant_id IS '登记人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_invin_w.registrant_name IS '登记人'; COMMENT ON COLUMN wssmet_invin_w.status_code IS '状态，枚举类型，CommonStatusEnum'; COMMENT ON COLUMN wssmet_invin_w.remark IS '备注'; COMMENT ON COLUMN wssmet_invin_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_invin_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_invin_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_invin_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_invin_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_invin_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_invin_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_invin_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_invin_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_invin_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_invin_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_invin_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_invin_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_invin_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.33 wssmet_invinmeter_w — 入库水表明细 ```sql CREATE TABLE wssmet_invinmeter_w ( id NUMBER(19) NOT NULL, in_id NUMBER(19) , meter_id NUMBER(19) , meter_code VARCHAR2(64) , caliber_code VARCHAR2(64) , meter_type_code VARCHAR2(64) , qty NUMBER(10), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_invinmeter_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_invinmeter_w IS '入库水表明细'; COMMENT ON COLUMN wssmet_invinmeter_w.id IS '主键'; COMMENT ON COLUMN wssmet_invinmeter_w.in_id IS '入库主单ID，关联wssmet_invin_w表的id字段'; COMMENT ON COLUMN wssmet_invinmeter_w.meter_id IS '水表ID，关联wssmet_meter_w表的id字段'; COMMENT ON COLUMN wssmet_invinmeter_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_invinmeter_w.caliber_code IS '口径编号，字典类型，目录码METER_DIAMETER'; COMMENT ON COLUMN wssmet_invinmeter_w.meter_type_code IS '水表类型编号，字典类型，目录码METER_TYPE'; COMMENT ON COLUMN wssmet_invinmeter_w.qty IS '数量'; COMMENT ON COLUMN wssmet_invinmeter_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_invinmeter_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_invinmeter_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_invinmeter_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_invinmeter_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_invinmeter_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_invinmeter_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_invinmeter_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_invinmeter_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_invinmeter_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_invinmeter_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_invinmeter_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_invinmeter_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_invinmeter_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.34 wssmet_invout_w — 出库主单 ```sql CREATE TABLE wssmet_invout_w ( id NUMBER(19) NOT NULL, out_code VARCHAR2(64) , warehouse_id NUMBER(19) , out_type_code VARCHAR2(64) , out_date DATE , ref_table_name VARCHAR2(64) , ref_table_id NUMBER(19) , ref_biz_code VARCHAR2(64) , registrant_id NUMBER(19) , registrant_name VARCHAR2(100) , status_code VARCHAR2(32) , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_invout_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_invout_w IS '出库主表'; COMMENT ON COLUMN wssmet_invout_w.id IS '主键'; COMMENT ON COLUMN wssmet_invout_w.out_code IS '出库编号'; COMMENT ON COLUMN wssmet_invout_w.warehouse_id IS '仓库ID，关联wssmet_warehouse_w表的id字段'; COMMENT ON COLUMN wssmet_invout_w.out_type_code IS '出库类型，枚举类型，OutboundTypeEnum'; COMMENT ON COLUMN wssmet_invout_w.out_date IS '出库日期'; COMMENT ON COLUMN wssmet_invout_w.ref_table_name IS '关联表'; COMMENT ON COLUMN wssmet_invout_w.ref_table_id IS 'ref_tableID，关联（待补充）表的id字段'; COMMENT ON COLUMN wssmet_invout_w.ref_biz_code IS '关联业务编号'; COMMENT ON COLUMN wssmet_invout_w.registrant_id IS '登记人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_invout_w.registrant_name IS '登记人'; COMMENT ON COLUMN wssmet_invout_w.status_code IS '状态，枚举类型，CommonStatusEnum'; COMMENT ON COLUMN wssmet_invout_w.remark IS '备注'; COMMENT ON COLUMN wssmet_invout_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_invout_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_invout_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_invout_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_invout_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_invout_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_invout_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_invout_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_invout_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_invout_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_invout_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_invout_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_invout_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_invout_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.35 wssmet_invoutmeter_w — 出库水表明细 ```sql CREATE TABLE wssmet_invoutmeter_w ( id NUMBER(19) NOT NULL, out_id NUMBER(19) , meter_id NUMBER(19) , meter_code VARCHAR2(64) , caliber_code VARCHAR2(64) , meter_type_code VARCHAR2(64) , qty NUMBER(10), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_invoutmeter_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_invoutmeter_w IS '出库水表明细'; COMMENT ON COLUMN wssmet_invoutmeter_w.id IS '主键'; COMMENT ON COLUMN wssmet_invoutmeter_w.out_id IS '出库主单ID，关联wssmet_invout_w表的id字段'; COMMENT ON COLUMN wssmet_invoutmeter_w.meter_id IS '水表ID，关联wssmet_meter_w表的id字段'; COMMENT ON COLUMN wssmet_invoutmeter_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_invoutmeter_w.caliber_code IS '口径编号，字典类型，目录码METER_DIAMETER'; COMMENT ON COLUMN wssmet_invoutmeter_w.meter_type_code IS '水表类型编号，字典类型，目录码METER_TYPE'; COMMENT ON COLUMN wssmet_invoutmeter_w.qty IS '数量'; COMMENT ON COLUMN wssmet_invoutmeter_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_invoutmeter_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_invoutmeter_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_invoutmeter_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_invoutmeter_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_invoutmeter_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_invoutmeter_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_invoutmeter_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_invoutmeter_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_invoutmeter_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_invoutmeter_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_invoutmeter_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_invoutmeter_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_invoutmeter_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.36 wssmet_invconfirm_w — 总仓入库确认（退返接收） ```sql CREATE TABLE wssmet_invconfirm_w ( id NUMBER(19) NOT NULL, confirm_code VARCHAR2(64) , source_org_id NUMBER(19) , ref_table_name VARCHAR2(64) , ref_table_id NUMBER(19) , meter_qty NUMBER(10) , delivery_time TIMESTAMP , confirm_status_code VARCHAR2(32) , confirm_user_id NUMBER(19) , confirm_user_name VARCHAR2(100) , confirm_time TIMESTAMP, create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_invconfirm_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_invconfirm_w IS '总仓入库确认'; COMMENT ON COLUMN wssmet_invconfirm_w.id IS '主键'; COMMENT ON COLUMN wssmet_invconfirm_w.confirm_code IS '确认编号'; COMMENT ON COLUMN wssmet_invconfirm_w.source_org_id IS '来源组织ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_invconfirm_w.ref_table_name IS '关联表'; COMMENT ON COLUMN wssmet_invconfirm_w.ref_table_id IS 'ref_tableID，关联（待补充）表的id字段'; COMMENT ON COLUMN wssmet_invconfirm_w.meter_qty IS '水表数量'; COMMENT ON COLUMN wssmet_invconfirm_w.delivery_time IS '送达时间'; COMMENT ON COLUMN wssmet_invconfirm_w.confirm_status_code IS '确认状态，枚举类型，ConfirmStatusEnum'; COMMENT ON COLUMN wssmet_invconfirm_w.confirm_user_id IS '确认用户ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_invconfirm_w.confirm_user_name IS '确认用户'; COMMENT ON COLUMN wssmet_invconfirm_w.confirm_time IS '确认时间'; COMMENT ON COLUMN wssmet_invconfirm_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_invconfirm_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_invconfirm_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_invconfirm_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_invconfirm_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_invconfirm_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_invconfirm_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_invconfirm_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_invconfirm_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_invconfirm_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_invconfirm_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_invconfirm_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_invconfirm_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_invconfirm_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.37 wssmet_stnreturnin_w — 营业所退库入库登记 ```sql CREATE TABLE wssmet_stnreturnin_w ( id NUMBER(19) NOT NULL, register_code VARCHAR2(64) , return_apply_id NUMBER(19) , warehouse_id NUMBER(19) , return_hq_tag_code VARCHAR2(32) , registrant_id NUMBER(19) , registrant_name VARCHAR2(100) , register_date DATE , status_code VARCHAR2(32), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_stnreturnin_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_stnreturnin_w IS '营业所退库入库登记'; COMMENT ON COLUMN wssmet_stnreturnin_w.id IS '主键'; COMMENT ON COLUMN wssmet_stnreturnin_w.register_code IS '登记编号'; COMMENT ON COLUMN wssmet_stnreturnin_w.return_apply_id IS '营业所退库申请ID，关联wssmet_retstnapply_w表的id字段'; COMMENT ON COLUMN wssmet_stnreturnin_w.warehouse_id IS '仓库ID，关联wssmet_warehouse_w表的id字段'; COMMENT ON COLUMN wssmet_stnreturnin_w.return_hq_tag_code IS '退回总仓标签编号，字典类型，目录码METER_RETURN_HQ_TAG'; COMMENT ON COLUMN wssmet_stnreturnin_w.registrant_id IS '登记人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_stnreturnin_w.registrant_name IS '登记人'; COMMENT ON COLUMN wssmet_stnreturnin_w.register_date IS '登记日期'; COMMENT ON COLUMN wssmet_stnreturnin_w.status_code IS '状态，枚举类型，CommonStatusEnum'; COMMENT ON COLUMN wssmet_stnreturnin_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_stnreturnin_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_stnreturnin_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_stnreturnin_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_stnreturnin_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_stnreturnin_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_stnreturnin_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_stnreturnin_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_stnreturnin_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_stnreturnin_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_stnreturnin_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_stnreturnin_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_stnreturnin_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_stnreturnin_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.38 wssmet_retstnapply_w — 营业所退库申请 ```sql CREATE TABLE wssmet_retstnapply_w ( id NUMBER(19) NOT NULL, apply_code VARCHAR2(64) , return_reason_code VARCHAR2(64) , project_name VARCHAR2(100) , process_instance_id VARCHAR2(64) , work_order_code VARCHAR2(64) , approve_status VARCHAR2(32) , inbound_status_code VARCHAR2(32) , inbound_id NUMBER(19) , remark VARCHAR2(500), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_retstnapply_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_retstnapply_w IS '营业所退库申请'; COMMENT ON COLUMN wssmet_retstnapply_w.id IS '主键'; COMMENT ON COLUMN wssmet_retstnapply_w.apply_code IS '申请编号'; COMMENT ON COLUMN wssmet_retstnapply_w.return_reason_code IS '退回原因编号，字典类型，目录码METER_RETURN_REASON'; COMMENT ON COLUMN wssmet_retstnapply_w.project_name IS '项目'; COMMENT ON COLUMN wssmet_retstnapply_w.inbound_status_code IS '入库状态，枚举类型，InboundStatusEnum'; COMMENT ON COLUMN wssmet_retstnapply_w.inbound_id IS '入库主单ID，关联wssmet_invin_w表的id字段'; COMMENT ON COLUMN wssmet_retstnapply_w.remark IS '备注'; COMMENT ON COLUMN wssmet_retstnapply_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_retstnapply_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_retstnapply_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_retstnapply_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_retstnapply_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_retstnapply_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_retstnapply_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_retstnapply_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_retstnapply_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_retstnapply_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_retstnapply_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_retstnapply_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_retstnapply_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_retstnapply_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_retstnapply_w.process_instance_id IS 'workflow 流程实例ID（工单中心外挂，不落本地工单表）'; COMMENT ON COLUMN wssmet_retstnapply_w.work_order_code IS '工单编号（展示/台账查询）'; COMMENT ON COLUMN wssmet_retstnapply_w.approve_status IS '审批状态：draft/pending/approved/rejected/cancelled 等，枚举类型，ApproveStatusEnum'; ``` ### 4.39 wssmet_retstnapplymeter_w — 营业所退库申请明细 ```sql CREATE TABLE wssmet_retstnapplymeter_w ( id NUMBER(19) NOT NULL, apply_id NUMBER(19) , meter_id NUMBER(19) , meter_code VARCHAR2(64) , caliber_code VARCHAR2(64) , meter_type_code VARCHAR2(64) , qty NUMBER(10), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_retstnapplymeter_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_retstnapplymeter_w IS '营业所退库申请明细'; COMMENT ON COLUMN wssmet_retstnapplymeter_w.id IS '主键'; COMMENT ON COLUMN wssmet_retstnapplymeter_w.apply_id IS '营业所退库申请ID，关联wssmet_retstnapply_w表的id字段'; COMMENT ON COLUMN wssmet_retstnapplymeter_w.meter_id IS '水表ID，关联wssmet_meter_w表的id字段'; COMMENT ON COLUMN wssmet_retstnapplymeter_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_retstnapplymeter_w.caliber_code IS '口径编号，字典类型，目录码METER_DIAMETER'; COMMENT ON COLUMN wssmet_retstnapplymeter_w.meter_type_code IS '水表类型编号，字典类型，目录码METER_TYPE'; COMMENT ON COLUMN wssmet_retstnapplymeter_w.qty IS '数量'; COMMENT ON COLUMN wssmet_retstnapplymeter_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_retstnapplymeter_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_retstnapplymeter_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_retstnapplymeter_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_retstnapplymeter_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_retstnapplymeter_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_retstnapplymeter_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_retstnapplymeter_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_retstnapplymeter_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_retstnapplymeter_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_retstnapplymeter_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_retstnapplymeter_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_retstnapplymeter_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_retstnapplymeter_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.40 wssmet_rethqapply_w — 分公司旧表退回总仓申请 ```sql CREATE TABLE wssmet_rethqapply_w ( id NUMBER(19) NOT NULL, apply_code VARCHAR2(64) , tag_filter VARCHAR2(256) , return_reason_code VARCHAR2(64) , process_instance_id VARCHAR2(64) , work_order_code VARCHAR2(64) , approve_status VARCHAR2(32) , out_status_code VARCHAR2(32) , hq_in_status_code VARCHAR2(32) , out_id NUMBER(19) , confirm_id NUMBER(19) , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_rethqapply_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_rethqapply_w IS '退回总仓申请'; COMMENT ON COLUMN wssmet_rethqapply_w.id IS '主键'; COMMENT ON COLUMN wssmet_rethqapply_w.apply_code IS '申请编号'; COMMENT ON COLUMN wssmet_rethqapply_w.tag_filter IS '标签筛选'; COMMENT ON COLUMN wssmet_rethqapply_w.return_reason_code IS '退回原因编号，字典类型，目录码METER_RETURN_REASON'; COMMENT ON COLUMN wssmet_rethqapply_w.out_status_code IS '出库状态，枚举类型，OutboundStatusEnum'; COMMENT ON COLUMN wssmet_rethqapply_w.hq_in_status_code IS '总仓入库状态，枚举类型，HqInboundStatusEnum'; COMMENT ON COLUMN wssmet_rethqapply_w.out_id IS '出库主单ID，关联wssmet_invout_w表的id字段'; COMMENT ON COLUMN wssmet_rethqapply_w.confirm_id IS '总仓入库确认ID，关联wssmet_invconfirm_w表的id字段'; COMMENT ON COLUMN wssmet_rethqapply_w.remark IS '备注'; COMMENT ON COLUMN wssmet_rethqapply_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_rethqapply_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_rethqapply_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_rethqapply_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_rethqapply_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_rethqapply_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_rethqapply_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_rethqapply_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_rethqapply_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_rethqapply_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_rethqapply_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_rethqapply_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_rethqapply_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_rethqapply_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_rethqapply_w.process_instance_id IS 'workflow 流程实例ID（工单中心外挂，不落本地工单表）'; COMMENT ON COLUMN wssmet_rethqapply_w.work_order_code IS '工单编号（展示/台账查询）'; COMMENT ON COLUMN wssmet_rethqapply_w.approve_status IS '审批状态：draft/pending/approved/rejected/cancelled 等，枚举类型，ApproveStatusEnum'; ``` ### 4.41 wssmet_rethqapplymeter_w — 退回总仓申请明细 ```sql CREATE TABLE wssmet_rethqapplymeter_w ( id NUMBER(19) NOT NULL, apply_id NUMBER(19) , meter_id NUMBER(19) , meter_code VARCHAR2(64) , caliber_code VARCHAR2(64) , meter_type_code VARCHAR2(64) , qty NUMBER(10) , tag VARCHAR2(64), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_rethqapplymeter_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_rethqapplymeter_w IS '退回总仓申请明细'; COMMENT ON COLUMN wssmet_rethqapplymeter_w.id IS '主键'; COMMENT ON COLUMN wssmet_rethqapplymeter_w.apply_id IS '退回总仓申请ID，关联wssmet_rethqapply_w表的id字段'; COMMENT ON COLUMN wssmet_rethqapplymeter_w.meter_id IS '水表ID，关联wssmet_meter_w表的id字段'; COMMENT ON COLUMN wssmet_rethqapplymeter_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_rethqapplymeter_w.caliber_code IS '口径编号，字典类型，目录码METER_DIAMETER'; COMMENT ON COLUMN wssmet_rethqapplymeter_w.meter_type_code IS '水表类型编号，字典类型，目录码METER_TYPE'; COMMENT ON COLUMN wssmet_rethqapplymeter_w.qty IS '数量'; COMMENT ON COLUMN wssmet_rethqapplymeter_w.tag IS '标签'; COMMENT ON COLUMN wssmet_rethqapplymeter_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_rethqapplymeter_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_rethqapplymeter_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_rethqapplymeter_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_rethqapplymeter_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_rethqapplymeter_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_rethqapplymeter_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_rethqapplymeter_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_rethqapplymeter_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_rethqapplymeter_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_rethqapplymeter_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_rethqapplymeter_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_rethqapplymeter_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_rethqapplymeter_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.42 wssmet_installtask_w — 新装安装任务 ```sql CREATE TABLE wssmet_installtask_w ( id NUMBER(19) NOT NULL, task_code VARCHAR2(64) , task_source_code VARCHAR2(64) , contract_no VARCHAR2(64) , meter_id NUMBER(19) , meter_code VARCHAR2(64) , plan_user_no VARCHAR2(64) , install_address VARCHAR2(512) , executor_id NUMBER(19) , task_status_code VARCHAR2(32) , out_record_id NUMBER(19) , apply_id NUMBER(19) , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_installtask_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_installtask_w IS '安装任务'; COMMENT ON COLUMN wssmet_installtask_w.id IS '主键'; COMMENT ON COLUMN wssmet_installtask_w.task_code IS '任务编号'; COMMENT ON COLUMN wssmet_installtask_w.task_source_code IS '任务来源，枚举类型，TaskSourceEnum'; COMMENT ON COLUMN wssmet_installtask_w.contract_no IS '合同'; COMMENT ON COLUMN wssmet_installtask_w.meter_id IS '水表ID，关联wssmet_meter_w表的id字段'; COMMENT ON COLUMN wssmet_installtask_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_installtask_w.plan_user_no IS '计划用户'; COMMENT ON COLUMN wssmet_installtask_w.install_address IS '安装地址'; COMMENT ON COLUMN wssmet_installtask_w.executor_id IS '执行人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_installtask_w.task_status_code IS '任务状态，枚举类型，TaskStatusEnum'; COMMENT ON COLUMN wssmet_installtask_w.out_record_id IS '出库主单ID，关联wssmet_invout_w表的id字段'; COMMENT ON COLUMN wssmet_installtask_w.apply_id IS '领用申请ID，关联wssmet_claimapply_w表的id字段'; COMMENT ON COLUMN wssmet_installtask_w.remark IS '备注'; COMMENT ON COLUMN wssmet_installtask_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_installtask_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_installtask_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_installtask_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_installtask_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_installtask_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_installtask_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_installtask_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_installtask_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_installtask_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_installtask_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_installtask_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_installtask_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_installtask_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.43 wssmet_installrec_w — 新装现场记录（App） ```sql CREATE TABLE wssmet_installrec_w ( id NUMBER(19) NOT NULL, task_id NUMBER(19) , actual_user_no VARCHAR2(64) , install_info VARCHAR2(512) , install_time TIMESTAMP , mismatch_reason VARCHAR2(512) , gps_lat NUMBER(18,8) , gps_lng NUMBER(18,8) , create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_installrec_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_installrec_w IS '安装现场记录(App)'; COMMENT ON COLUMN wssmet_installrec_w.id IS '主键'; COMMENT ON COLUMN wssmet_installrec_w.task_id IS '新装安装任务ID，关联wssmet_installtask_w表的id字段'; COMMENT ON COLUMN wssmet_installrec_w.actual_user_no IS '实际用户'; COMMENT ON COLUMN wssmet_installrec_w.install_info IS '安装'; COMMENT ON COLUMN wssmet_installrec_w.install_time IS '安装时间'; COMMENT ON COLUMN wssmet_installrec_w.mismatch_reason IS '不匹配原因'; COMMENT ON COLUMN wssmet_installrec_w.gps_lat IS 'GPS纬度'; COMMENT ON COLUMN wssmet_installrec_w.gps_lng IS 'GPS经度'; COMMENT ON COLUMN wssmet_installrec_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_installrec_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_installrec_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_installrec_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_installrec_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_installrec_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_installrec_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_installrec_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_installrec_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_installrec_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_installrec_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_installrec_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_installrec_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_installrec_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.44 wssmet_installaccept_w — 新装安装验收 ```sql CREATE TABLE wssmet_installaccept_w ( id NUMBER(19) NOT NULL, task_id NUMBER(19) , accept_result_code VARCHAR2(32) , accept_remark VARCHAR2(512) , acceptor_id NUMBER(19) , acceptor_name VARCHAR2(100) , accept_time TIMESTAMP, create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_installaccept_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_installaccept_w IS '安装验收'; COMMENT ON COLUMN wssmet_installaccept_w.id IS '主键'; COMMENT ON COLUMN wssmet_installaccept_w.task_id IS '新装安装任务ID，关联wssmet_installtask_w表的id字段'; COMMENT ON COLUMN wssmet_installaccept_w.accept_result_code IS '验收，枚举类型，AcceptResultEnum'; COMMENT ON COLUMN wssmet_installaccept_w.accept_remark IS '验收备注'; COMMENT ON COLUMN wssmet_installaccept_w.acceptor_id IS '验收人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_installaccept_w.acceptor_name IS '验收人'; COMMENT ON COLUMN wssmet_installaccept_w.accept_time IS '验收时间'; COMMENT ON COLUMN wssmet_installaccept_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_installaccept_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_installaccept_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_installaccept_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_installaccept_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_installaccept_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_installaccept_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_installaccept_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_installaccept_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_installaccept_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_installaccept_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_installaccept_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_installaccept_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_installaccept_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.45 wssmet_replaceapply_w — 换表申请 ```sql CREATE TABLE wssmet_replaceapply_w ( id NUMBER(19) NOT NULL, apply_code VARCHAR2(64) , replace_type_code VARCHAR2(32) , replace_reason_code VARCHAR2(64) , project_name VARCHAR2(128) , process_instance_id VARCHAR2(64) , work_order_code VARCHAR2(64) , approve_status VARCHAR2(32) , task_id NUMBER(19) , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_replaceapply_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_replaceapply_w IS '换表申请'; COMMENT ON COLUMN wssmet_replaceapply_w.id IS '主键'; COMMENT ON COLUMN wssmet_replaceapply_w.apply_code IS '申请编号'; COMMENT ON COLUMN wssmet_replaceapply_w.replace_type_code IS '换表类型，枚举类型，ReplaceTypeEnum'; COMMENT ON COLUMN wssmet_replaceapply_w.replace_reason_code IS '换表原因编号，字典类型，目录码METER_REPLACE_REASON'; COMMENT ON COLUMN wssmet_replaceapply_w.project_name IS '项目'; COMMENT ON COLUMN wssmet_replaceapply_w.task_id IS '换表任务ID，关联wssmet_replacetask_w表的id字段'; COMMENT ON COLUMN wssmet_replaceapply_w.remark IS '备注'; COMMENT ON COLUMN wssmet_replaceapply_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_replaceapply_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_replaceapply_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_replaceapply_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_replaceapply_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_replaceapply_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_replaceapply_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_replaceapply_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_replaceapply_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_replaceapply_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_replaceapply_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_replaceapply_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_replaceapply_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_replaceapply_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_replaceapply_w.process_instance_id IS 'workflow 流程实例ID（工单中心外挂，不落本地工单表）'; COMMENT ON COLUMN wssmet_replaceapply_w.work_order_code IS '工单编号（展示/台账查询）'; COMMENT ON COLUMN wssmet_replaceapply_w.approve_status IS '审批状态：draft/pending/approved/rejected/cancelled 等，枚举类型，ApproveStatusEnum'; ``` ### 4.46 wssmet_replaceapplylist_w — 换表申请明细 ```sql CREATE TABLE wssmet_replaceapplylist_w ( id NUMBER(19) NOT NULL, apply_id NUMBER(19) , user_no VARCHAR2(64) , user_name VARCHAR2(128) , old_meter_code VARCHAR2(64) , address VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_replaceapplylist_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_replaceapplylist_w IS '换表申请明细'; COMMENT ON COLUMN wssmet_replaceapplylist_w.id IS '主键'; COMMENT ON COLUMN wssmet_replaceapplylist_w.apply_id IS '换表申请ID，关联wssmet_replaceapply_w表的id字段'; COMMENT ON COLUMN wssmet_replaceapplylist_w.user_no IS '用户'; COMMENT ON COLUMN wssmet_replaceapplylist_w.user_name IS '用户'; COMMENT ON COLUMN wssmet_replaceapplylist_w.old_meter_code IS '旧水表编号'; COMMENT ON COLUMN wssmet_replaceapplylist_w.address IS '地址'; COMMENT ON COLUMN wssmet_replaceapplylist_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_replaceapplylist_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_replaceapplylist_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_replaceapplylist_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_replaceapplylist_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_replaceapplylist_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_replaceapplylist_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_replaceapplylist_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_replaceapplylist_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_replaceapplylist_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_replaceapplylist_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_replaceapplylist_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_replaceapplylist_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_replaceapplylist_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.47 wssmet_replacetask_w — 换表任务 ```sql CREATE TABLE wssmet_replacetask_w ( id NUMBER(19) NOT NULL, task_code VARCHAR2(64) , apply_id NUMBER(19) , replace_type_code VARCHAR2(32) , plan_user_no VARCHAR2(64) , executor_id NUMBER(19) , task_status_code VARCHAR2(32) , out_record_id NUMBER(19) , old_meter_collect_status_code VARCHAR2(32), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_replacetask_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_replacetask_w IS '换表任务'; COMMENT ON COLUMN wssmet_replacetask_w.id IS '主键'; COMMENT ON COLUMN wssmet_replacetask_w.task_code IS '任务编号'; COMMENT ON COLUMN wssmet_replacetask_w.apply_id IS '换表申请ID，关联wssmet_replaceapply_w表的id字段'; COMMENT ON COLUMN wssmet_replacetask_w.replace_type_code IS '换表类型，枚举类型，ReplaceTypeEnum'; COMMENT ON COLUMN wssmet_replacetask_w.plan_user_no IS '计划用户'; COMMENT ON COLUMN wssmet_replacetask_w.executor_id IS '执行人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_replacetask_w.task_status_code IS '任务状态，枚举类型，TaskStatusEnum'; COMMENT ON COLUMN wssmet_replacetask_w.out_record_id IS '出库主单ID，关联wssmet_invout_w表的id字段'; COMMENT ON COLUMN wssmet_replacetask_w.old_meter_collect_status_code IS '旧水表归集状态，枚举类型，CollectStatusEnum'; COMMENT ON COLUMN wssmet_replacetask_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_replacetask_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_replacetask_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_replacetask_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_replacetask_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_replacetask_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_replacetask_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_replacetask_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_replacetask_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_replacetask_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_replacetask_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_replacetask_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_replacetask_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_replacetask_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.48 wssmet_replacerec_w — 换表现场记录（App） ```sql CREATE TABLE wssmet_replacerec_w ( id NUMBER(19) NOT NULL, task_id NUMBER(19) , old_meter_code VARCHAR2(64) , new_meter_code VARCHAR2(64) , actual_user_no VARCHAR2(64) , actual_installer VARCHAR2(100) , work_time TIMESTAMP , mismatch_reason VARCHAR2(512) , install_info VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_replacerec_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_replacerec_w IS '换表现场记录(App)'; COMMENT ON COLUMN wssmet_replacerec_w.id IS '主键'; COMMENT ON COLUMN wssmet_replacerec_w.task_id IS '换表任务ID，关联wssmet_replacetask_w表的id字段'; COMMENT ON COLUMN wssmet_replacerec_w.old_meter_code IS '旧水表编号'; COMMENT ON COLUMN wssmet_replacerec_w.new_meter_code IS '新水表编号'; COMMENT ON COLUMN wssmet_replacerec_w.actual_user_no IS '实际用户'; COMMENT ON COLUMN wssmet_replacerec_w.actual_installer IS '实际'; COMMENT ON COLUMN wssmet_replacerec_w.work_time IS '工单时间'; COMMENT ON COLUMN wssmet_replacerec_w.mismatch_reason IS '不匹配原因'; COMMENT ON COLUMN wssmet_replacerec_w.install_info IS '安装'; COMMENT ON COLUMN wssmet_replacerec_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_replacerec_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_replacerec_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_replacerec_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_replacerec_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_replacerec_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_replacerec_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_replacerec_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_replacerec_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_replacerec_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_replacerec_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_replacerec_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_replacerec_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_replacerec_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.49 wssmet_relocateapply_w — 迁表申请 ```sql CREATE TABLE wssmet_relocateapply_w ( id NUMBER(19) NOT NULL, apply_code VARCHAR2(64) , relocate_reason_code VARCHAR2(64) , user_no VARCHAR2(64) , user_name VARCHAR2(128) , old_address VARCHAR2(512) , old_position VARCHAR2(256) , new_address VARCHAR2(512) , new_position VARCHAR2(256) , meter_id NUMBER(19) , meter_code VARCHAR2(64) , process_instance_id VARCHAR2(64) , work_order_code VARCHAR2(64) , approve_status VARCHAR2(32) , task_id NUMBER(19) , remark VARCHAR2(500), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_relocateapply_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_relocateapply_w IS '迁表申请'; COMMENT ON COLUMN wssmet_relocateapply_w.id IS '主键'; COMMENT ON COLUMN wssmet_relocateapply_w.apply_code IS '申请编号'; COMMENT ON COLUMN wssmet_relocateapply_w.relocate_reason_code IS '迁表原因编号，字典类型，目录码METER_RELOCATE_REASON'; COMMENT ON COLUMN wssmet_relocateapply_w.user_no IS '用户'; COMMENT ON COLUMN wssmet_relocateapply_w.user_name IS '用户'; COMMENT ON COLUMN wssmet_relocateapply_w.old_address IS '旧地址'; COMMENT ON COLUMN wssmet_relocateapply_w.old_position IS '旧表位'; COMMENT ON COLUMN wssmet_relocateapply_w.new_address IS '新地址'; COMMENT ON COLUMN wssmet_relocateapply_w.new_position IS '新表位'; COMMENT ON COLUMN wssmet_relocateapply_w.meter_id IS '水表ID，关联wssmet_meter_w表的id字段'; COMMENT ON COLUMN wssmet_relocateapply_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_relocateapply_w.task_id IS '迁表任务ID，关联wssmet_relocatetask_w表的id字段'; COMMENT ON COLUMN wssmet_relocateapply_w.remark IS '备注'; COMMENT ON COLUMN wssmet_relocateapply_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_relocateapply_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_relocateapply_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_relocateapply_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_relocateapply_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_relocateapply_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_relocateapply_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_relocateapply_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_relocateapply_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_relocateapply_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_relocateapply_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_relocateapply_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_relocateapply_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_relocateapply_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_relocateapply_w.process_instance_id IS 'workflow 流程实例ID（工单中心外挂，不落本地工单表）'; COMMENT ON COLUMN wssmet_relocateapply_w.work_order_code IS '工单编号（展示/台账查询）'; COMMENT ON COLUMN wssmet_relocateapply_w.approve_status IS '审批状态：draft/pending/approved/rejected/cancelled 等，枚举类型，ApproveStatusEnum'; ``` ### 4.50 wssmet_relocatetask_w — 迁表任务 ```sql CREATE TABLE wssmet_relocatetask_w ( id NUMBER(19) NOT NULL, task_code VARCHAR2(64) , task_source_code VARCHAR2(64) , apply_id NUMBER(19) , user_no VARCHAR2(64) , user_name VARCHAR2(128) , meter_code VARCHAR2(64) , relocate_reason_code VARCHAR2(64) , new_address VARCHAR2(512) , new_position VARCHAR2(256) , org_id NUMBER(19) , executor_id NUMBER(19) , plan_finish_date DATE , actual_finish_date DATE , task_status_code VARCHAR2(32) , task_desc VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_relocatetask_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_relocatetask_w IS '迁表任务'; COMMENT ON COLUMN wssmet_relocatetask_w.id IS '主键'; COMMENT ON COLUMN wssmet_relocatetask_w.task_code IS '任务编号'; COMMENT ON COLUMN wssmet_relocatetask_w.task_source_code IS '任务来源，枚举类型，TaskSourceEnum'; COMMENT ON COLUMN wssmet_relocatetask_w.apply_id IS '迁表申请ID，关联wssmet_relocateapply_w表的id字段'; COMMENT ON COLUMN wssmet_relocatetask_w.user_no IS '用户'; COMMENT ON COLUMN wssmet_relocatetask_w.user_name IS '用户'; COMMENT ON COLUMN wssmet_relocatetask_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_relocatetask_w.relocate_reason_code IS '迁表原因编号，字典类型，目录码METER_RELOCATE_REASON'; COMMENT ON COLUMN wssmet_relocatetask_w.new_address IS '新地址'; COMMENT ON COLUMN wssmet_relocatetask_w.new_position IS '新表位'; COMMENT ON COLUMN wssmet_relocatetask_w.org_id IS '组织ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_relocatetask_w.executor_id IS '执行人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_relocatetask_w.plan_finish_date IS '计划完成日期'; COMMENT ON COLUMN wssmet_relocatetask_w.actual_finish_date IS '实际完成日期'; COMMENT ON COLUMN wssmet_relocatetask_w.task_status_code IS '任务状态，枚举类型，TaskStatusEnum'; COMMENT ON COLUMN wssmet_relocatetask_w.task_desc IS '任务'; COMMENT ON COLUMN wssmet_relocatetask_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_relocatetask_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_relocatetask_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_relocatetask_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_relocatetask_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_relocatetask_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_relocatetask_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_relocatetask_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_relocatetask_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_relocatetask_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_relocatetask_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_relocatetask_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_relocatetask_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_relocatetask_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.51 wssmet_relocaterec_w — 迁表现场记录（App） ```sql CREATE TABLE wssmet_relocaterec_w ( id NUMBER(19) NOT NULL, task_id NUMBER(19) , reading_value NUMBER(18,3) , new_position_confirm VARCHAR2(256) , new_address_confirm VARCHAR2(512) , gps_lat NUMBER(18,8) , gps_lng NUMBER(18,8) , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_relocaterec_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_relocaterec_w IS '迁表现场记录(App)'; COMMENT ON COLUMN wssmet_relocaterec_w.id IS '主键'; COMMENT ON COLUMN wssmet_relocaterec_w.task_id IS '迁表任务ID，关联wssmet_relocatetask_w表的id字段'; COMMENT ON COLUMN wssmet_relocaterec_w.reading_value IS '读数'; COMMENT ON COLUMN wssmet_relocaterec_w.new_position_confirm IS '新表位确认'; COMMENT ON COLUMN wssmet_relocaterec_w.new_address_confirm IS '新地址确认'; COMMENT ON COLUMN wssmet_relocaterec_w.gps_lat IS 'GPS纬度'; COMMENT ON COLUMN wssmet_relocaterec_w.gps_lng IS 'GPS经度'; COMMENT ON COLUMN wssmet_relocaterec_w.remark IS '备注'; COMMENT ON COLUMN wssmet_relocaterec_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_relocaterec_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_relocaterec_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_relocaterec_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_relocaterec_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_relocaterec_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_relocaterec_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_relocaterec_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_relocaterec_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_relocaterec_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_relocaterec_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_relocaterec_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_relocaterec_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_relocaterec_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.52 wssmet_removeapply_w — 拆表申请 ```sql CREATE TABLE wssmet_removeapply_w ( id NUMBER(19) NOT NULL, apply_code VARCHAR2(64) , remove_reason_code VARCHAR2(64) , user_no VARCHAR2(64) , user_name VARCHAR2(128) , meter_id NUMBER(19) , meter_code VARCHAR2(64) , process_instance_id VARCHAR2(64) , work_order_code VARCHAR2(64) , approve_status VARCHAR2(32) , task_id NUMBER(19) , return_status_code VARCHAR2(32) , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_removeapply_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_removeapply_w IS '拆表申请'; COMMENT ON COLUMN wssmet_removeapply_w.id IS '主键'; COMMENT ON COLUMN wssmet_removeapply_w.apply_code IS '申请编号'; COMMENT ON COLUMN wssmet_removeapply_w.remove_reason_code IS '拆表原因编号，字典类型，目录码METER_REMOVE_REASON'; COMMENT ON COLUMN wssmet_removeapply_w.user_no IS '用户'; COMMENT ON COLUMN wssmet_removeapply_w.user_name IS '用户'; COMMENT ON COLUMN wssmet_removeapply_w.meter_id IS '水表ID，关联wssmet_meter_w表的id字段'; COMMENT ON COLUMN wssmet_removeapply_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_removeapply_w.task_id IS '拆表任务ID，关联wssmet_removetask_w表的id字段'; COMMENT ON COLUMN wssmet_removeapply_w.return_status_code IS '退回状态，枚举类型，ReturnStatusEnum'; COMMENT ON COLUMN wssmet_removeapply_w.remark IS '备注'; COMMENT ON COLUMN wssmet_removeapply_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_removeapply_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_removeapply_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_removeapply_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_removeapply_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_removeapply_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_removeapply_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_removeapply_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_removeapply_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_removeapply_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_removeapply_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_removeapply_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_removeapply_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_removeapply_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_removeapply_w.process_instance_id IS 'workflow 流程实例ID（工单中心外挂，不落本地工单表）'; COMMENT ON COLUMN wssmet_removeapply_w.work_order_code IS '工单编号（展示/台账查询）'; COMMENT ON COLUMN wssmet_removeapply_w.approve_status IS '审批状态：draft/pending/approved/rejected/cancelled 等，枚举类型，ApproveStatusEnum'; ``` ### 4.53 wssmet_removetask_w — 拆表任务 ```sql CREATE TABLE wssmet_removetask_w ( id NUMBER(19) NOT NULL, task_code VARCHAR2(64) , task_source_code VARCHAR2(64) , apply_id NUMBER(19) , user_no VARCHAR2(64) , meter_code VARCHAR2(64) , remove_reason_code VARCHAR2(64) , executor_id NUMBER(19) , plan_finish_date DATE , task_status_code VARCHAR2(32) , final_reading NUMBER(18,3) , old_meter_collect_status_code VARCHAR2(32), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_removetask_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_removetask_w IS '拆表任务'; COMMENT ON COLUMN wssmet_removetask_w.id IS '主键'; COMMENT ON COLUMN wssmet_removetask_w.task_code IS '任务编号'; COMMENT ON COLUMN wssmet_removetask_w.task_source_code IS '任务来源，枚举类型，TaskSourceEnum'; COMMENT ON COLUMN wssmet_removetask_w.apply_id IS '拆表申请ID，关联wssmet_removeapply_w表的id字段'; COMMENT ON COLUMN wssmet_removetask_w.user_no IS '用户'; COMMENT ON COLUMN wssmet_removetask_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_removetask_w.remove_reason_code IS '拆表原因编号，字典类型，目录码METER_REMOVE_REASON'; COMMENT ON COLUMN wssmet_removetask_w.executor_id IS '执行人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_removetask_w.plan_finish_date IS '计划完成日期'; COMMENT ON COLUMN wssmet_removetask_w.task_status_code IS '任务状态，枚举类型，TaskStatusEnum'; COMMENT ON COLUMN wssmet_removetask_w.final_reading IS '最终读数'; COMMENT ON COLUMN wssmet_removetask_w.old_meter_collect_status_code IS '旧水表归集状态，枚举类型，CollectStatusEnum'; COMMENT ON COLUMN wssmet_removetask_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_removetask_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_removetask_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_removetask_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_removetask_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_removetask_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_removetask_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_removetask_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_removetask_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_removetask_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_removetask_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_removetask_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_removetask_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_removetask_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.54 wssmet_removerec_w — 拆表现场记录（App） ```sql CREATE TABLE wssmet_removerec_w ( id NUMBER(19) NOT NULL, task_id NUMBER(19) , meter_code VARCHAR2(64) , final_reading NUMBER(18,3) , collect_status_code VARCHAR2(32) , gps_lat NUMBER(18,8) , gps_lng NUMBER(18,8) , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_removerec_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_removerec_w IS '拆表现场记录(App)'; COMMENT ON COLUMN wssmet_removerec_w.id IS '主键'; COMMENT ON COLUMN wssmet_removerec_w.task_id IS '拆表任务ID，关联wssmet_removetask_w表的id字段'; COMMENT ON COLUMN wssmet_removerec_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_removerec_w.final_reading IS '最终读数'; COMMENT ON COLUMN wssmet_removerec_w.collect_status_code IS '归集状态，枚举类型，CollectStatusEnum'; COMMENT ON COLUMN wssmet_removerec_w.gps_lat IS 'GPS纬度'; COMMENT ON COLUMN wssmet_removerec_w.gps_lng IS 'GPS经度'; COMMENT ON COLUMN wssmet_removerec_w.remark IS '备注'; COMMENT ON COLUMN wssmet_removerec_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_removerec_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_removerec_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_removerec_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_removerec_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_removerec_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_removerec_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_removerec_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_removerec_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_removerec_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_removerec_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_removerec_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_removerec_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_removerec_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.55 wssmet_rotatetask_w — 到期轮换任务 ```sql CREATE TABLE wssmet_rotatetask_w ( id NUMBER(19) NOT NULL, task_code VARCHAR2(64) , task_name VARCHAR2(128) , org_id NUMBER(19) , executor_id NUMBER(19) , plan_finish_date DATE , meter_qty NUMBER(10) , finished_qty NUMBER(10) , task_status_code VARCHAR2(32) , task_desc VARCHAR2(512) , creator_id NUMBER(19) , creator_name VARCHAR2(100) , dispatch_time TIMESTAMP, create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_rotatetask_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_rotatetask_w IS '轮换任务'; COMMENT ON COLUMN wssmet_rotatetask_w.id IS '主键'; COMMENT ON COLUMN wssmet_rotatetask_w.task_code IS '任务编号'; COMMENT ON COLUMN wssmet_rotatetask_w.task_name IS '任务'; COMMENT ON COLUMN wssmet_rotatetask_w.org_id IS '组织ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_rotatetask_w.executor_id IS '执行人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_rotatetask_w.plan_finish_date IS '计划完成日期'; COMMENT ON COLUMN wssmet_rotatetask_w.meter_qty IS '水表数量'; COMMENT ON COLUMN wssmet_rotatetask_w.finished_qty IS '数量'; COMMENT ON COLUMN wssmet_rotatetask_w.task_status_code IS '任务状态，枚举类型，TaskStatusEnum'; COMMENT ON COLUMN wssmet_rotatetask_w.task_desc IS '任务'; COMMENT ON COLUMN wssmet_rotatetask_w.creator_id IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_rotatetask_w.creator_name IS '创建人'; COMMENT ON COLUMN wssmet_rotatetask_w.dispatch_time IS '分派时间'; COMMENT ON COLUMN wssmet_rotatetask_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_rotatetask_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_rotatetask_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_rotatetask_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_rotatetask_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_rotatetask_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_rotatetask_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_rotatetask_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_rotatetask_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_rotatetask_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_rotatetask_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_rotatetask_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_rotatetask_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_rotatetask_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.56 wssmet_rotatetaskmeter_w — 到期轮换任务水表明细 ```sql CREATE TABLE wssmet_rotatetaskmeter_w ( id NUMBER(19) NOT NULL, task_id NUMBER(19) , meter_id NUMBER(19) , user_no VARCHAR2(64) , user_name VARCHAR2(128) , meter_code VARCHAR2(64) , caliber_code VARCHAR2(64) , meter_type_code VARCHAR2(64) , rotate_status_code VARCHAR2(32), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_rotatetaskmeter_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_rotatetaskmeter_w IS '轮换任务水表明细'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.id IS '主键'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.task_id IS '到期轮换任务ID，关联wssmet_rotatetask_w表的id字段'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.meter_id IS '水表ID，关联wssmet_meter_w表的id字段'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.user_no IS '用户'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.user_name IS '用户'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.caliber_code IS '口径编号，字典类型，目录码METER_DIAMETER'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.meter_type_code IS '水表类型编号，字典类型，目录码METER_TYPE'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.rotate_status_code IS '轮换状态，枚举类型，RotateStatusEnum'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_rotatetaskmeter_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.57 wssmet_rotaterec_w — 轮换现场记录（App） ```sql CREATE TABLE wssmet_rotaterec_w ( id NUMBER(19) NOT NULL, task_meter_id NUMBER(19) , old_meter_code VARCHAR2(64) , old_final_reading NUMBER(18,3) , new_meter_code VARCHAR2(64) , new_install_reading NUMBER(18,3) , old_collect_status_code VARCHAR2(32), gps_lat NUMBER(18,8) , gps_lng NUMBER(18,8) , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_rotaterec_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_rotaterec_w IS '轮换现场记录(App)'; COMMENT ON COLUMN wssmet_rotaterec_w.id IS '主键'; COMMENT ON COLUMN wssmet_rotaterec_w.task_meter_id IS '轮换任务水表明细ID，关联wssmet_rotatetaskmeter_w表的id字段'; COMMENT ON COLUMN wssmet_rotaterec_w.old_meter_code IS '旧水表编号'; COMMENT ON COLUMN wssmet_rotaterec_w.old_final_reading IS '旧最终读数'; COMMENT ON COLUMN wssmet_rotaterec_w.new_meter_code IS '新水表编号'; COMMENT ON COLUMN wssmet_rotaterec_w.new_install_reading IS '新安装读数'; COMMENT ON COLUMN wssmet_rotaterec_w.old_collect_status_code IS '旧归集状态，枚举类型，CollectStatusEnum'; COMMENT ON COLUMN wssmet_rotaterec_w.gps_lat IS 'GPS纬度'; COMMENT ON COLUMN wssmet_rotaterec_w.gps_lng IS 'GPS经度'; COMMENT ON COLUMN wssmet_rotaterec_w.remark IS '备注'; COMMENT ON COLUMN wssmet_rotaterec_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_rotaterec_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_rotaterec_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_rotaterec_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_rotaterec_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_rotaterec_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_rotaterec_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_rotaterec_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_rotaterec_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_rotaterec_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_rotaterec_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_rotaterec_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_rotaterec_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_rotaterec_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.58 wssmet_inspectcfg_w — 周期检查规则配置 ```sql CREATE TABLE wssmet_inspectcfg_w ( id NUMBER(19) NOT NULL, config_name VARCHAR2(100) , sample_ratio NUMBER(5,2) , plan_cycle_months NUMBER(10) , task_deadline_days NUMBER(10) , check_items VARCHAR2(512) , remind_days_before NUMBER(10) , status_code VARCHAR2(32), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_inspectcfg_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_inspectcfg_w IS '周期检查配置'; COMMENT ON COLUMN wssmet_inspectcfg_w.id IS '主键'; COMMENT ON COLUMN wssmet_inspectcfg_w.config_name IS '配置'; COMMENT ON COLUMN wssmet_inspectcfg_w.sample_ratio IS '抽检比例'; COMMENT ON COLUMN wssmet_inspectcfg_w.plan_cycle_months IS '计划周期'; COMMENT ON COLUMN wssmet_inspectcfg_w.task_deadline_days IS '任务'; COMMENT ON COLUMN wssmet_inspectcfg_w.check_items IS '项'; COMMENT ON COLUMN wssmet_inspectcfg_w.remind_days_before IS '提醒'; COMMENT ON COLUMN wssmet_inspectcfg_w.status_code IS '状态，枚举类型，CommonStatusEnum'; COMMENT ON COLUMN wssmet_inspectcfg_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_inspectcfg_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_inspectcfg_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_inspectcfg_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_inspectcfg_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_inspectcfg_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_inspectcfg_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_inspectcfg_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_inspectcfg_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_inspectcfg_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_inspectcfg_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_inspectcfg_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_inspectcfg_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_inspectcfg_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.59 wssmet_inspecttask_w — 周期检查任务 ```sql CREATE TABLE wssmet_inspecttask_w ( id NUMBER(19) NOT NULL, task_code VARCHAR2(64) , task_name VARCHAR2(128) , org_id NUMBER(19) , plan_start_date DATE , plan_end_date DATE , inspector_id NUMBER(19) , inspector_name VARCHAR2(100) , meter_qty NUMBER(10) , finished_qty NUMBER(10) , completion_rate NUMBER(5,1) , task_status_code VARCHAR2(32) , sample_mode_code VARCHAR2(32) , sample_ratio NUMBER(5,2) , task_desc VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_inspecttask_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_inspecttask_w IS '周期检查任务'; COMMENT ON COLUMN wssmet_inspecttask_w.id IS '主键'; COMMENT ON COLUMN wssmet_inspecttask_w.task_code IS '任务编号'; COMMENT ON COLUMN wssmet_inspecttask_w.task_name IS '任务'; COMMENT ON COLUMN wssmet_inspecttask_w.org_id IS '组织ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_inspecttask_w.plan_start_date IS '计划日期'; COMMENT ON COLUMN wssmet_inspecttask_w.plan_end_date IS '计划日期'; COMMENT ON COLUMN wssmet_inspecttask_w.inspector_id IS '检查人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_inspecttask_w.inspector_name IS '检查人'; COMMENT ON COLUMN wssmet_inspecttask_w.meter_qty IS '水表数量'; COMMENT ON COLUMN wssmet_inspecttask_w.finished_qty IS '数量'; COMMENT ON COLUMN wssmet_inspecttask_w.completion_rate IS '完成'; COMMENT ON COLUMN wssmet_inspecttask_w.task_status_code IS '任务状态，枚举类型，TaskStatusEnum'; COMMENT ON COLUMN wssmet_inspecttask_w.sample_mode_code IS '抽检方式编号，字典类型，目录码METER_SAMPLE_MODE'; COMMENT ON COLUMN wssmet_inspecttask_w.sample_ratio IS '抽检比例'; COMMENT ON COLUMN wssmet_inspecttask_w.task_desc IS '任务'; COMMENT ON COLUMN wssmet_inspecttask_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_inspecttask_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_inspecttask_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_inspecttask_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_inspecttask_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_inspecttask_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_inspecttask_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_inspecttask_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_inspecttask_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_inspecttask_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_inspecttask_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_inspecttask_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_inspecttask_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_inspecttask_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.60 wssmet_inspecttaskmeter_w — 周期检查任务水表明细 ```sql CREATE TABLE wssmet_inspecttaskmeter_w ( id NUMBER(19) NOT NULL, task_id NUMBER(19) , meter_id NUMBER(19) , meter_code VARCHAR2(64) , user_no VARCHAR2(64) , inspect_status_code VARCHAR2(32), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_inspecttaskmeter_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_inspecttaskmeter_w IS '周期检查任务水表明细'; COMMENT ON COLUMN wssmet_inspecttaskmeter_w.id IS '主键'; COMMENT ON COLUMN wssmet_inspecttaskmeter_w.task_id IS '周期检查任务ID，关联wssmet_inspecttask_w表的id字段'; COMMENT ON COLUMN wssmet_inspecttaskmeter_w.meter_id IS '水表ID，关联wssmet_meter_w表的id字段'; COMMENT ON COLUMN wssmet_inspecttaskmeter_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_inspecttaskmeter_w.user_no IS '用户'; COMMENT ON COLUMN wssmet_inspecttaskmeter_w.inspect_status_code IS '检查状态，枚举类型，InspectStatusEnum'; COMMENT ON COLUMN wssmet_inspecttaskmeter_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_inspecttaskmeter_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_inspecttaskmeter_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_inspecttaskmeter_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_inspecttaskmeter_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_inspecttaskmeter_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_inspecttaskmeter_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_inspecttaskmeter_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_inspecttaskmeter_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_inspecttaskmeter_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_inspecttaskmeter_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_inspecttaskmeter_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_inspecttaskmeter_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_inspecttaskmeter_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.61 wssmet_inspectrec_w — 周期检查现场记录（App） ```sql CREATE TABLE wssmet_inspectrec_w ( id NUMBER(19) NOT NULL, task_meter_id NUMBER(19) , run_status_code VARCHAR2(32) , body_status_code VARCHAR2(32) , seal_status_code VARCHAR2(32) , leak_status_code VARCHAR2(32) , illegal_use_code VARCHAR2(32) , reading_value NUMBER(18,3) , reading_compare_code VARCHAR2(32) , ext_items CLOB , gps_lat NUMBER(18,8) , gps_lng NUMBER(18,8) , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_inspectrec_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_inspectrec_w IS '周期检查记录(App)'; COMMENT ON COLUMN wssmet_inspectrec_w.id IS '主键'; COMMENT ON COLUMN wssmet_inspectrec_w.task_meter_id IS '周期检查任务水表明细ID，关联wssmet_inspecttaskmeter_w表的id字段'; COMMENT ON COLUMN wssmet_inspectrec_w.run_status_code IS '运行状态，枚举类型，RunStatusEnum'; COMMENT ON COLUMN wssmet_inspectrec_w.body_status_code IS '表体状态，枚举类型，BodyStatusEnum'; COMMENT ON COLUMN wssmet_inspectrec_w.seal_status_code IS '铅封状态，枚举类型，SealStatusEnum'; COMMENT ON COLUMN wssmet_inspectrec_w.leak_status_code IS '漏水状态，枚举类型，LeakStatusEnum'; COMMENT ON COLUMN wssmet_inspectrec_w.illegal_use_code IS '违规编号，字典类型，目录码METER_ILLEGAL_USE'; COMMENT ON COLUMN wssmet_inspectrec_w.reading_value IS '读数'; COMMENT ON COLUMN wssmet_inspectrec_w.reading_compare_code IS '读数比对编号，字典类型，目录码METER_READING_COMPARE'; COMMENT ON COLUMN wssmet_inspectrec_w.ext_items IS '扩展项'; COMMENT ON COLUMN wssmet_inspectrec_w.gps_lat IS 'GPS纬度'; COMMENT ON COLUMN wssmet_inspectrec_w.gps_lng IS 'GPS经度'; COMMENT ON COLUMN wssmet_inspectrec_w.remark IS '备注'; COMMENT ON COLUMN wssmet_inspectrec_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_inspectrec_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_inspectrec_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_inspectrec_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_inspectrec_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_inspectrec_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_inspectrec_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_inspectrec_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_inspectrec_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_inspectrec_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_inspectrec_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_inspectrec_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_inspectrec_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_inspectrec_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.62 wssmet_scrapapply_w — 报废申请 ```sql CREATE TABLE wssmet_scrapapply_w ( id NUMBER(19) NOT NULL, apply_code VARCHAR2(64) , scrap_reason_code VARCHAR2(64) , project_name VARCHAR2(100) , total_qty NUMBER(10) , process_instance_id VARCHAR2(64) , work_order_code VARCHAR2(64) , approve_status VARCHAR2(32) , register_id NUMBER(19) , register_status_code VARCHAR2(32) , remark VARCHAR2(500), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_scrapapply_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_scrapapply_w IS '报废申请'; COMMENT ON COLUMN wssmet_scrapapply_w.id IS '主键'; COMMENT ON COLUMN wssmet_scrapapply_w.apply_code IS '申请编号'; COMMENT ON COLUMN wssmet_scrapapply_w.scrap_reason_code IS '报废原因编号，字典类型，目录码METER_SCRAP_REASON'; COMMENT ON COLUMN wssmet_scrapapply_w.project_name IS '项目'; COMMENT ON COLUMN wssmet_scrapapply_w.total_qty IS '总数量'; COMMENT ON COLUMN wssmet_scrapapply_w.register_id IS '报废登记ID，关联wssmet_scrapreg_w表的id字段'; COMMENT ON COLUMN wssmet_scrapapply_w.register_status_code IS '登记状态，枚举类型，RegisterStatusEnum'; COMMENT ON COLUMN wssmet_scrapapply_w.remark IS '备注'; COMMENT ON COLUMN wssmet_scrapapply_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_scrapapply_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_scrapapply_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_scrapapply_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_scrapapply_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_scrapapply_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_scrapapply_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_scrapapply_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_scrapapply_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_scrapapply_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_scrapapply_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_scrapapply_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_scrapapply_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_scrapapply_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_scrapapply_w.process_instance_id IS 'workflow 流程实例ID（工单中心外挂，不落本地工单表）'; COMMENT ON COLUMN wssmet_scrapapply_w.work_order_code IS '工单编号（展示/台账查询）'; COMMENT ON COLUMN wssmet_scrapapply_w.approve_status IS '审批状态：draft/pending/approved/rejected/cancelled 等，枚举类型，ApproveStatusEnum'; ``` ### 4.63 wssmet_scrapapplylist_w — 报废申请明细 ```sql CREATE TABLE wssmet_scrapapplylist_w ( id NUMBER(19) NOT NULL, apply_id NUMBER(19) , meter_id NUMBER(19) , meter_code VARCHAR2(64) , caliber_code VARCHAR2(64) , meter_type_code VARCHAR2(64) , qty NUMBER(10) , remark VARCHAR2(256), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_scrapapplylist_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_scrapapplylist_w IS '报废申请明细'; COMMENT ON COLUMN wssmet_scrapapplylist_w.id IS '主键'; COMMENT ON COLUMN wssmet_scrapapplylist_w.apply_id IS '报废申请ID，关联wssmet_scrapapply_w表的id字段'; COMMENT ON COLUMN wssmet_scrapapplylist_w.meter_id IS '水表ID，关联wssmet_meter_w表的id字段'; COMMENT ON COLUMN wssmet_scrapapplylist_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_scrapapplylist_w.caliber_code IS '口径编号，字典类型，目录码METER_DIAMETER'; COMMENT ON COLUMN wssmet_scrapapplylist_w.meter_type_code IS '水表类型编号，字典类型，目录码METER_TYPE'; COMMENT ON COLUMN wssmet_scrapapplylist_w.qty IS '数量'; COMMENT ON COLUMN wssmet_scrapapplylist_w.remark IS '备注'; COMMENT ON COLUMN wssmet_scrapapplylist_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_scrapapplylist_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_scrapapplylist_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_scrapapplylist_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_scrapapplylist_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_scrapapplylist_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_scrapapplylist_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_scrapapplylist_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_scrapapplylist_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_scrapapplylist_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_scrapapplylist_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_scrapapplylist_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_scrapapplylist_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_scrapapplylist_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ### 4.64 wssmet_scrapreg_w — 报废登记 ```sql CREATE TABLE wssmet_scrapreg_w ( id NUMBER(19) NOT NULL, register_code VARCHAR2(64) , apply_id NUMBER(19) , process_instance_id VARCHAR2(64) , work_order_code VARCHAR2(64) , approve_status VARCHAR2(32) , scrap_reason_code VARCHAR2(64) , register_status_code VARCHAR2(32) , seal_time TIMESTAMP , seal_user_id NUMBER(19) , seal_user_name VARCHAR2(100) , out_record_id NUMBER(19) , dispose_status_code VARCHAR2(32) , remark VARCHAR2(512), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_scrapreg_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_scrapreg_w IS '报废登记'; COMMENT ON COLUMN wssmet_scrapreg_w.id IS '主键'; COMMENT ON COLUMN wssmet_scrapreg_w.register_code IS '登记编号'; COMMENT ON COLUMN wssmet_scrapreg_w.apply_id IS 'applyID，关联（待补充）表的id字段'; COMMENT ON COLUMN wssmet_scrapreg_w.scrap_reason_code IS '报废原因编号，字典类型，目录码METER_SCRAP_REASON'; COMMENT ON COLUMN wssmet_scrapreg_w.register_status_code IS '登记状态，枚举类型，RegisterStatusEnum'; COMMENT ON COLUMN wssmet_scrapreg_w.seal_time IS '铅封时间'; COMMENT ON COLUMN wssmet_scrapreg_w.seal_user_id IS '封签人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_scrapreg_w.seal_user_name IS '铅封用户'; COMMENT ON COLUMN wssmet_scrapreg_w.out_record_id IS 'out_recordID，关联（待补充）表的id字段'; COMMENT ON COLUMN wssmet_scrapreg_w.dispose_status_code IS '处置状态，枚举类型，DisposeStatusEnum'; COMMENT ON COLUMN wssmet_scrapreg_w.remark IS '备注'; COMMENT ON COLUMN wssmet_scrapreg_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_scrapreg_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_scrapreg_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_scrapreg_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_scrapreg_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_scrapreg_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_scrapreg_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_scrapreg_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_scrapreg_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_scrapreg_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_scrapreg_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_scrapreg_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_scrapreg_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_scrapreg_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_scrapreg_w.process_instance_id IS 'workflow 流程实例ID（工单中心外挂，不落本地工单表）'; COMMENT ON COLUMN wssmet_scrapreg_w.work_order_code IS '工单编号（展示/台账查询）'; COMMENT ON COLUMN wssmet_scrapreg_w.approve_status IS '审批状态：draft/pending/approved/rejected/cancelled 等，枚举类型，ApproveStatusEnum'; ``` ### 4.65 wssmet_scrapreglist_w — 报废登记明细 ```sql CREATE TABLE wssmet_scrapreglist_w ( id NUMBER(19) NOT NULL, register_id NUMBER(19) , meter_id NUMBER(19) , meter_code VARCHAR2(64) , caliber_code VARCHAR2(64) , meter_type_code VARCHAR2(64) , qty NUMBER(10), create_user NUMBER(19), create_time TIMESTAMP, update_user NUMBER(19), update_time TIMESTAMP, deleted NUMBER(1) DEFAULT 0 NOT NULL, create_company_id NUMBER(19), create_company_name VARCHAR2(200), create_dept_id NUMBER(19), create_dept_name VARCHAR2(200), create_post_id NUMBER(19), create_post_name VARCHAR2(200), create_user_name VARCHAR2(100), cur_company_id NUMBER(19), cur_dept_id NUMBER(19), CONSTRAINT PK_wssmet_scrapreglist_w PRIMARY KEY (id) ); COMMENT ON TABLE wssmet_scrapreglist_w IS '报废登记明细'; COMMENT ON COLUMN wssmet_scrapreglist_w.id IS '主键'; COMMENT ON COLUMN wssmet_scrapreglist_w.register_id IS 'registerID，关联（待补充）表的id字段'; COMMENT ON COLUMN wssmet_scrapreglist_w.meter_id IS '水表ID，关联wssmet_meter_w表的id字段'; COMMENT ON COLUMN wssmet_scrapreglist_w.meter_code IS '水表表号'; COMMENT ON COLUMN wssmet_scrapreglist_w.caliber_code IS '口径编号，字典类型，目录码METER_DIAMETER'; COMMENT ON COLUMN wssmet_scrapreglist_w.meter_type_code IS '水表类型编号，字典类型，目录码METER_TYPE'; COMMENT ON COLUMN wssmet_scrapreglist_w.qty IS '数量'; COMMENT ON COLUMN wssmet_scrapreglist_w.create_user IS '创建人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_scrapreglist_w.create_time IS '创建时间'; COMMENT ON COLUMN wssmet_scrapreglist_w.update_user IS '更新人ID，关联tf_user表的id字段'; COMMENT ON COLUMN wssmet_scrapreglist_w.update_time IS '更新时间'; COMMENT ON COLUMN wssmet_scrapreglist_w.deleted IS '删除状态：0未删除 1已删除'; COMMENT ON COLUMN wssmet_scrapreglist_w.create_company_id IS '创建公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_scrapreglist_w.create_company_name IS '创建公司名称'; COMMENT ON COLUMN wssmet_scrapreglist_w.create_dept_id IS '创建部门ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_scrapreglist_w.create_dept_name IS '创建部门名称'; COMMENT ON COLUMN wssmet_scrapreglist_w.create_post_id IS '创建岗位ID，关联tf_post表的id字段'; COMMENT ON COLUMN wssmet_scrapreglist_w.create_post_name IS '创建岗位名称'; COMMENT ON COLUMN wssmet_scrapreglist_w.create_user_name IS '创建用户名称'; COMMENT ON COLUMN wssmet_scrapreglist_w.cur_company_id IS '当前公司ID，关联tf_org表的id字段'; COMMENT ON COLUMN wssmet_scrapreglist_w.cur_dept_id IS '当前部门ID，关联tf_org表的id字段'; ``` ## 5. 索引建议（逻辑名） - 各表 `id` 主键；查询默认 `deleted = 0`。 - `wssmet_meter_w(factory_code)` 唯一（出厂编码全局唯一，PRD-01）。 - `wssmet_meter_w(meter_code)` 业务表号索引/唯一策略按 PRD 表号变更规则实施。 - 申请类：`process_instance_id`、`work_order_code`、`approve_status`。 - 高频外键：`meter_id`、`warehouse_id` 等，索引名 `idx_{x2}_{字段}`（x2 为表名中段）。 ## 6. 与工单中心关系（PRD-04-01） - 工单列表、待办、已办、流程配置由 **workflow 引擎** 提供，本库**不重复建表**。 - 申请类主表保存流程实例与审批状态；终审通过后按 PRD 驱动计划/任务/出入库。