ylsw-bw/business/water-meter/doc/design/数据库设计-V1.0.md

仪陇表务管理系统 — 数据库设计 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

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。

示例（表 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 — 水表主数据（资产档案）

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 — 水表生命周期事件

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 — 仓库（总仓/分仓）

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 — 水表厂家

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 — 水表型号

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 — 检定/轮换/报废周期规则

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 — 库存预警规则

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 — 采购申请

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 — 采购申请明细

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 — 采购计划

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 — 采购到货批次

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 — 采购到货水表明细

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 — 落地检登记

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 — 不合格返厂登记

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 — 领用申请

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 — 领用申请明细

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 — 领取登记

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 — 领取登记水表明细

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 — 调拨申请

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 — 调拨出库登记

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 — 调拨出库水表明细

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 — 调拨入库确认

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 — 调拨入库水表明细

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 — 到期检定任务

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 — 到期检定任务水表明细

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）

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 — 争议检定申请

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 — 争议检定任务

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）

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 — 其他检定登记

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 — 检定记录（测量系统对接）

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 — 入库主单

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 — 入库水表明细

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 — 出库主单

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 — 出库水表明细

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 — 总仓入库确认（退返接收）

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 — 营业所退库入库登记

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 — 营业所退库申请

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 — 营业所退库申请明细

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 — 分公司旧表退回总仓申请

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 — 退回总仓申请明细

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 — 新装安装任务

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）

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 — 新装安装验收

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 — 换表申请

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 — 换表申请明细

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 — 换表任务

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）

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 — 迁表申请

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 — 迁表任务

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）

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 — 拆表申请

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 — 拆表任务

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）

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 — 到期轮换任务

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 — 到期轮换任务水表明细

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）

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 — 周期检查规则配置

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 — 周期检查任务

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 — 周期检查任务水表明细

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）

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 — 报废申请

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 — 报废申请明细

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 — 报废登记

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 — 报废登记明细

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 驱动计划/任务/出入库。