alter table NGWL_TEST_OMS.BUSINESS_DOCUMENT_ORDER add PUSH_STATUS TINYINT default 1; comment on column NGWL_TEST_OMS.BUSINESS_DOCUMENT_ORDER.PUSH_STATUS is '推送状态：1-未推送 2-推送中 3-推送成功 4-推送失败'; alter table NGWL_TEST_OMS.BUSINESS_DOCUMENT_ORDER add PUSH_TIME timestamp; comment on column NGWL_TEST_OMS.BUSINESS_DOCUMENT_ORDER.PUSH_TIME is '推送时间'; alter table NGWL_TEST_OMS.BUSINESS_DOCUMENT_ORDER add PUSH_BY varchar(32); comment on column NGWL_TEST_OMS.BUSINESS_DOCUMENT_ORDER.PUSH_BY is '推送人'; alter table NGWL_TEST_OMS.BUSINESS_DOCUMENT_ORDER add PUSH_BY_NAME varchar(100); comment on column NGWL_TEST_OMS.BUSINESS_DOCUMENT_ORDER.PUSH_BY_NAME is '推送人姓名'; alter table NGWL_TEST_USER.USER_SHIPPER add PUSH_BY_NAME varchar(100); comment on column NGWL_TEST_USER.USER_SHIPPER.PUSH_BY_NAME is '推送人姓名'; alter table NGWL_TEST_OMS.BUSINESS_DOCUMENT_CARGO_MULTI add MATERIAL_BASE_INFO_ID BIGINT; comment on column NGWL_TEST_OMS.BUSINESS_DOCUMENT_CARGO_MULTI.MATERIAL_BASE_INFO_ID is '物料id'; alter table NGWL_TEST_OMS.BUSINESS_DOCUMENT_CARGO_MULTI add PRODUCT_TYPE BIGINT; comment on column NGWL_TEST_OMS.BUSINESS_DOCUMENT_CARGO_MULTI.PRODUCT_TYPE is '商品类型/货物类型（0料件，1半成品，2成品）'; alter table NGWL_TEST_WMS.MATERIAL_BASE_INFO add PUSH_BY_NAME varchar(100); comment on column NGWL_TEST_WMS.MATERIAL_BASE_INFO.PUSH_BY_NAME is '推送人名称'; USE NGWL_TEST_OMS; CREATE TABLE GW_LOG ( LOG_ID BIGINT PRIMARY KEY AUTO_INCREMENT COMMENT '日志ID', TYPE VARCHAR(50) COMMENT '类型', BUSINESS_ID BIGINT COMMENT '业务ID', REQUEST_BODY TEXT COMMENT '请求体', RESPONSE_BODY TEXT COMMENT '响应体', STATUS INT DEFAULT 1 COMMENT '状态：1-初始，2-成功，3-失败', ERROR_MSG VARCHAR(500) COMMENT '错误信息', SEND_TIME DATETIME COMMENT '发送时间', ORGANIZATION_ID BIGINT COMMENT '组织ID', TOP_ORGANIZATION_ID BIGINT COMMENT '顶级组织ID', ORGANIZATION_NAME VARCHAR(200) COMMENT '组织名称', CREATE_BY BIGINT COMMENT '创建人', CREATE_TIME DATETIME COMMENT '创建时间', DEL_FLAG INT DEFAULT 1 COMMENT '删除标记：1-正常，0-删除' ); alter table NGWL_TEST_OMS.GW_LOG add PUSH_BY_NAME varchar(100); comment on column NGWL_TEST_OMS.GW_LOG.PUSH_BY_NAME is '推送人姓名'; CREATE TABLE ERP_ENTERPRISE_UNIT ( ID BIGINT PRIMARY KEY AUTO_INCREMENT COMMENT '主键ID', ERP_CODE VARCHAR(100) COMMENT 'ERP单位编码', ERP_NAME VARCHAR(200) COMMENT 'ERP单位名称', PUSH_STATUS INT DEFAULT 1 COMMENT '推送状态：1-未推送，2-推送中，3-推送成功，4-推送失败', PUSH_TIME DATETIME COMMENT '推送时间', PUSH_BY BIGINT COMMENT '推送人', ORGANIZATION_ID BIGINT COMMENT '所属组织ID', TOP_ORGANIZATION_ID BIGINT COMMENT '一级组织ID', ORGANIZATION_NAME VARCHAR(200) COMMENT '所属组织名称', CREATE_BY BIGINT COMMENT '创建人', CREATE_BY_NAME VARCHAR(64) COMMENT '创建人姓名', CREATE_TIME DATETIME COMMENT '创建时间', UPDATE_BY BIGINT COMMENT '更新人', UPDATE_TIME DATETIME COMMENT '更新时间', DEL_FLAG INT DEFAULT 1 COMMENT '删除标记：1-正常，0-删除' ); COMMENT ON TABLE ERP_ENTERPRISE_UNIT IS '企业单位表'; alter table NGWL_TEST_OMS.ERP_ENTERPRISE_UNIT add PUSH_BY_NAME VARCHAR(100); comment on column NGWL_TEST_OMS.ERP_ENTERPRISE_UNIT.PUSH_BY_NAME is '推送人姓名'; CREATE TABLE ERP_COUNTRY ( ID BIGINT PRIMARY KEY AUTO_INCREMENT COMMENT '主键ID', ERP_COUNTRY_CODE VARCHAR(100) COMMENT 'ERP国别编码', ERP_COUNTRY_NAME VARCHAR(200) COMMENT 'ERP国别名称', PUSH_STATUS INT DEFAULT 1 COMMENT '推送状态：1-未推送，2-推送中，3-推送成功，4-推送失败', PUSH_TIME DATETIME COMMENT '推送时间', PUSH_BY BIGINT COMMENT '推送人', ORGANIZATION_ID BIGINT COMMENT '所属组织ID', TOP_ORGANIZATION_ID BIGINT COMMENT '一级组织ID', ORGANIZATION_NAME VARCHAR(100) COMMENT '所属组织名称', CREATE_BY BIGINT COMMENT '创建人', CREATE_TIME DATETIME COMMENT '创建时间', UPDATE_BY BIGINT COMMENT '更新人', UPDATE_TIME DATETIME COMMENT '更新时间', DEL_FLAG INT DEFAULT 1 COMMENT '删除标记：1-正常，0-删除' ); COMMENT ON TABLE ERP_COUNTRY IS '企业国别表'; alter table NGWL_TEST_OMS.ERP_COUNTRY add PUSH_BY_NAME varchar(100); comment on column NGWL_TEST_OMS.ERP_COUNTRY.PUSH_BY_NAME is '托送人姓名'; alter table NGWL_TEST_OMS.BUSINESS_DOCUMENT_ORDER add REVISE_APPLY_TYPE int; comment on column NGWL_TEST_OMS.BUSINESS_DOCUMENT_ORDER.REVISE_APPLY_TYPE is '删改单申请类型：0-改单 1-删除 2-作废'; alter table NGWL_TEST_OMS.BUSINESS_DOCUMENT_ORDER add REVISE_APPLY_STATUS int default 0; comment on column NGWL_TEST_OMS.BUSINESS_DOCUMENT_ORDER.REVISE_APPLY_STATUS is '删改单申请状态：0-未申请 1-申请成功 2-申请失败'; alter table NGWL_TEST_OMS.BUSINESS_DOCUMENT_ORDER add REVISE_APPLY_REASON varchar(255); comment on column NGWL_TEST_OMS.BUSINESS_DOCUMENT_ORDER.REVISE_APPLY_REASON is '删改单申请原因'; alter table NGWL_TEST_OMS.BUSINESS_DOCUMENT_ORDER add REVISE_APPLY_BY varchar(50); comment on column NGWL_TEST_OMS.BUSINESS_DOCUMENT_ORDER.REVISE_APPLY_BY is '删改单申请人'; alter table NGWL_TEST_OMS.BUSINESS_DOCUMENT_ORDER add REVISE_APPLY_BY_NAME varchar(100); comment on column NGWL_TEST_OMS.BUSINESS_DOCUMENT_ORDER.REVISE_APPLY_BY_NAME is '删改单申请人姓名'; alter table NGWL_TEST_OMS.BUSINESS_DOCUMENT_ORDER add REVISE_APPLY_TIME timestamp; comment on column NGWL_TEST_OMS.BUSINESS_DOCUMENT_ORDER.REVISE_APPLY_TIME is '删改单申请时间'; -- 物料推送记录表 CREATE TABLE NGWL_TEST_OMS.MATERIAL_PUSH_RECORD ( ID BIGINT IDENTITY(1,1) NOT NULL, MATERIAL_BASE_INFO_ID BIGINT, MATERIAL_CODE VARCHAR(100), MATERIAL_NAME VARCHAR(255), SPECIFICATION_MODEL VARCHAR(255), DECLARATION_UNIT VARCHAR(100), CARGO_NUM DECIMAL(20,4), CURRENCY VARCHAR(10), UNIT_PRICE DECIMAL(20,4), NET_WEIGHT DECIMAL(20,4), GROSS_WEIGHT DECIMAL(20,4), GOODS_TYPE INT, PUSH_TIME DATETIME, DEL_FLAG INT DEFAULT 1, CREATE_BY VARCHAR(100), CREATE_TIME DATETIME, UPDATE_BY VARCHAR(100), UPDATE_TIME DATETIME, PRIMARY KEY (ID) ); COMMENT ON TABLE NGWL_TEST_OMS.MATERIAL_PUSH_RECORD IS '物料推送记录表'; COMMENT ON COLUMN NGWL_TEST_OMS.MATERIAL_PUSH_RECORD.MATERIAL_BASE_INFO_ID IS '物料ID'; COMMENT ON COLUMN NGWL_TEST_OMS.MATERIAL_PUSH_RECORD.MATERIAL_CODE IS '物料编码'; COMMENT ON COLUMN NGWL_TEST_OMS.MATERIAL_PUSH_RECORD.MATERIAL_NAME IS '物料名称'; COMMENT ON COLUMN NGWL_TEST_OMS.MATERIAL_PUSH_RECORD.SPECIFICATION_MODEL IS '规格型号'; COMMENT ON COLUMN NGWL_TEST_OMS.MATERIAL_PUSH_RECORD.DECLARATION_UNIT IS '申报单位'; COMMENT ON COLUMN NGWL_TEST_OMS.MATERIAL_PUSH_RECORD.CARGO_NUM IS '数量'; COMMENT ON COLUMN NGWL_TEST_OMS.MATERIAL_PUSH_RECORD.CURRENCY IS '币制'; COMMENT ON COLUMN NGWL_TEST_OMS.MATERIAL_PUSH_RECORD.UNIT_PRICE IS '单价'; COMMENT ON COLUMN NGWL_TEST_OMS.MATERIAL_PUSH_RECORD.NET_WEIGHT IS '净重(kg)'; COMMENT ON COLUMN NGWL_TEST_OMS.MATERIAL_PUSH_RECORD.GROSS_WEIGHT IS '毛重(kg)'; COMMENT ON COLUMN NGWL_TEST_OMS.MATERIAL_PUSH_RECORD.GOODS_TYPE IS '商品类型(0物料，1半成品，2成品)'; COMMENT ON COLUMN NGWL_TEST_OMS.MATERIAL_PUSH_RECORD.PUSH_TIME IS '推送时间'; COMMENT ON COLUMN NGWL_TEST_OMS.MATERIAL_PUSH_RECORD.DEL_FLAG IS '删除标志(1-正常，2-删除)'; COMMENT ON COLUMN NGWL_TEST_OMS.MATERIAL_PUSH_RECORD.CREATE_BY IS '创建人'; COMMENT ON COLUMN NGWL_TEST_OMS.MATERIAL_PUSH_RECORD.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN NGWL_TEST_OMS.MATERIAL_PUSH_RECORD.UPDATE_BY IS '更新人'; COMMENT ON COLUMN NGWL_TEST_OMS.MATERIAL_PUSH_RECORD.UPDATE_TIME IS '更新时间'; CREATE TABLE NGWL_TEST_OMS.DOCUMENT_PUSH_MATERIAL_RECORD ( ID BIGINT IDENTITY(1,1) NOT NULL, ORDER_ID BIGINT, MATERIAL_BASE_INFO_ID BIGINT, MATERIAL_CODE VARCHAR(100), MATERIAL_NAME VARCHAR(255), SPECIFICATION_MODEL VARCHAR(255), DECLARATION_UNIT VARCHAR(100), CARGO_NUM DECIMAL(20,4), CURRENCY VARCHAR(10), UNIT_PRICE DECIMAL(20,4), NET_WEIGHT DECIMAL(20,4), GROSS_WEIGHT DECIMAL(20,4), GOODS_TYPE INT, PUSH_TIME DATETIME, DEL_FLAG INT DEFAULT 1, CREATE_BY VARCHAR(100), CREATE_TIME DATETIME, UPDATE_BY VARCHAR(100), UPDATE_TIME DATETIME, PRIMARY KEY (ID) ); COMMENT ON TABLE NGWL_TEST_OMS.DOCUMENT_PUSH_MATERIAL_RECORD IS '单证推送物料记录表'; COMMENT ON COLUMN NGWL_TEST_OMS.DOCUMENT_PUSH_MATERIAL_RECORD.ORDER_ID IS '单证ID'; COMMENT ON COLUMN NGWL_TEST_OMS.DOCUMENT_PUSH_MATERIAL_RECORD.MATERIAL_BASE_INFO_ID IS '物料ID'; COMMENT ON COLUMN NGWL_TEST_OMS.DOCUMENT_PUSH_MATERIAL_RECORD.MATERIAL_CODE IS '物料编码'; COMMENT ON COLUMN NGWL_TEST_OMS.DOCUMENT_PUSH_MATERIAL_RECORD.MATERIAL_NAME IS '物料名称'; COMMENT ON COLUMN NGWL_TEST_OMS.DOCUMENT_PUSH_MATERIAL_RECORD.SPECIFICATION_MODEL IS '规格型号'; COMMENT ON COLUMN NGWL_TEST_OMS.DOCUMENT_PUSH_MATERIAL_RECORD.DECLARATION_UNIT IS '申报单位'; COMMENT ON COLUMN NGWL_TEST_OMS.DOCUMENT_PUSH_MATERIAL_RECORD.CARGO_NUM IS '数量'; COMMENT ON COLUMN NGWL_TEST_OMS.DOCUMENT_PUSH_MATERIAL_RECORD.CURRENCY IS '币制'; COMMENT ON COLUMN NGWL_TEST_OMS.DOCUMENT_PUSH_MATERIAL_RECORD.UNIT_PRICE IS '单价'; COMMENT ON COLUMN NGWL_TEST_OMS.DOCUMENT_PUSH_MATERIAL_RECORD.NET_WEIGHT IS '净重(kg)'; COMMENT ON COLUMN NGWL_TEST_OMS.DOCUMENT_PUSH_MATERIAL_RECORD.GROSS_WEIGHT IS '毛重(kg)'; COMMENT ON COLUMN NGWL_TEST_OMS.DOCUMENT_PUSH_MATERIAL_RECORD.GOODS_TYPE IS '商品类型(0物料，1半成品，2成品)'; COMMENT ON COLUMN NGWL_TEST_OMS.DOCUMENT_PUSH_MATERIAL_RECORD.PUSH_TIME IS '推送时间'; COMMENT ON COLUMN NGWL_TEST_OMS.DOCUMENT_PUSH_MATERIAL_RECORD.DEL_FLAG IS '删除标志(1-正常，2-删除)'; COMMENT ON COLUMN NGWL_TEST_OMS.DOCUMENT_PUSH_MATERIAL_RECORD.CREATE_BY IS '创建人'; COMMENT ON COLUMN NGWL_TEST_OMS.DOCUMENT_PUSH_MATERIAL_RECORD.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN NGWL_TEST_OMS.DOCUMENT_PUSH_MATERIAL_RECORD.UPDATE_BY IS '更新人'; COMMENT ON COLUMN NGWL_TEST_OMS.DOCUMENT_PUSH_MATERIAL_RECORD.UPDATE_TIME IS '更新时间';