HB_RTGK
/
DY_lims
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
DY_lims/sql/oracle/资源管理/标准溶液/标准溶液（ICP）.txt

201 lines
15 KiB
Plaintext
Raw Permalink Normal View History

【PM20230814001】【60430695】 代码初始化 【】
2024-11-22 11:28:16 +08:00
-- 建表语句
CREATE TABLE T_LIMS_LIQUOR_ICP(
ID NUMBER NOT NULL,
LIQUORCODE VARCHAR2(270) NULL,
LIQUORSTATUS VARCHAR2(36) NULL,
CONFIGTIME DATE NULL,
VALIDITYTIME DATE NULL,
CONFIGELEMENT VARCHAR2(270) NULL,
CONFIGCONCENTRATION VARCHAR2(270) NULL,
MARKERCODE VARCHAR2(270) NULL,
MARKERDOSAGE VARCHAR2(270) NULL,
CONSTANTVOLUME VARCHAR2(270) NULL,
CONFIGUSER VARCHAR2(270) NULL,
CONFIGUSERID VARCHAR2(270) NULL,
REMARKS VARCHAR2(270) NULL,
AUDITUSER VARCHAR2(270) NULL,
AUDITUSERID VARCHAR2(270) NULL,
PROCESSSTATUS VARCHAR2(36) NULL,
GROUPNAME VARCHAR2(36) NULL,
ORGID VARCHAR2(60) NULL,
ORGNAME VARCHAR2(60) NULL,
CREATEDBYID VARCHAR2(36) NULL,
CREATEDBYNAME VARCHAR2(60) NULL,
CREATEDTIME DATE NULL,
CREATEDBYORGID VARCHAR2(36) NULL,
CREATEDBYORGNAME VARCHAR2(270) NULL
);
COMMENT ON TABLE T_LIMS_LIQUOR_ICP IS '标准溶液ICP表';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.ID IS '主键';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.LIQUORCODE IS '标准溶液编号';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.LIQUORSTATUS IS '标液状态';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.CONFIGTIME IS '配制日期';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.VALIDITYTIME IS '有效日期';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.CONFIGELEMENT IS '配置元素';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.CONFIGCONCENTRATION IS '配置浓度';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.MARKERCODE IS '标物编号';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.MARKERDOSAGE IS '标物用量';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.CONSTANTVOLUME IS '定容体积';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.CONFIGUSER IS '配置人';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.CONFIGUSERID IS '配置人ID';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.REMARKS IS '备注';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.AUDITUSER IS '审核人';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.AUDITUSERID IS '审核人ID';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.PROCESSSTATUS IS '流程状态';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.GROUPNAME IS '所属分组';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.ORGID IS '组ID';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.ORGNAME IS '组名称';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP.CREATEDBYORGNAME IS '制单人单位名称';
ALTER TABLE T_LIMS_LIQUOR_ICP ADD CONSTRAINT PK_LIMS_LIQUOR_ICP PRIMARY KEY (ID);
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.SERVICE_NAME', '标准溶液ICP表', '标准溶液ICP表', 'zh-CN', '标准溶液ICP表');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.ID', '标准溶液ICP表的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.LIQUORCODE', '标准溶液ICP表的标准溶液编号', '标准溶液编号', 'zh-CN', '标准溶液编号');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.LIQUORSTATUS', '标准溶液ICP表的标液状态', '标液状态', 'zh-CN', '标液状态');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.CONFIGTIME', '标准溶液ICP表的配制日期', '配制日期', 'zh-CN', '配制日期');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.VALIDITYTIME', '标准溶液ICP表的有效日期', '有效日期', 'zh-CN', '有效日期');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.CONFIGELEMENT', '标准溶液ICP表的配置元素', '配置元素', 'zh-CN', '配置元素');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.CONFIGCONCENTRATION', '标准溶液ICP表的配置浓度', '配置浓度', 'zh-CN', '配置浓度');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.MARKERCODE', '标准溶液ICP表的标物编号', '标物编号', 'zh-CN', '标物编号');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.MARKERDOSAGE', '标准溶液ICP表的标物用量', '标物用量', 'zh-CN', '标物用量');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.CONSTANTVOLUME', '标准溶液ICP表的定容体积', '定容体积', 'zh-CN', '定容体积');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.CONFIGUSER', '标准溶液ICP表的配置人', '配置人', 'zh-CN', '配置人');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.CONFIGUSERID', '标准溶液ICP表的配置人ID', '配置人ID', 'zh-CN', '配置人ID');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.REMARKS', '标准溶液ICP表的备注', '备注', 'zh-CN', '备注');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.AUDITUSER', '标准溶液ICP表的审核人', '审核人', 'zh-CN', '审核人');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.AUDITUSERID', '标准溶液ICP表的审核人ID', '审核人ID', 'zh-CN', '审核人ID');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.PROCESSSTATUS', '标准溶液ICP表的流程状态', '流程状态', 'zh-CN', '流程状态');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.GROUPNAME', '标准溶液ICP表的所属分组', '所属分组', 'zh-CN', '所属分组');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.ORGID', '标准溶液ICP表的组ID', '组ID', 'zh-CN', '组ID');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.ORGNAME', '标准溶液ICP表的组名称', '组名称', 'zh-CN', '组名称');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.CREATEDBYID', '标准溶液ICP表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.CREATEDBYNAME', '标准溶液ICP表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.CREATEDTIME', '标准溶液ICP表的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.CREATEDBYORGID', '标准溶液ICP表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP.CREATEDBYORGNAME', '标准溶液ICP表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('BASEMODULE.TRM.STANDARDLIQUOR.ICPS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.TRM.STANDARDLIQUOR.ICPS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.TRM.STANDARDLIQUOR.ICPS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.TRM.STANDARDLIQUOR.ICPS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.TRM.STANDARDLIQUOR.ICPS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
-- 创建菜单语句
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('910804', '标准溶液管理（ICP）', '/secure/basemodule/trm/standardliquor/liquor-icps/page/edit-list', '9108', '910804', '052.svg', '标准溶液管理（ICP）');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('910805', '标准溶液管理（ICP）审核', '/secure/basemodule/trm/standardliquor/liquor-icps/page/audit-list', '9108', '910805', '052.svg', '标准溶液管理（ICP）审核');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('910806', '标准溶液管理（ICP）查询', '/secure/basemodule/trm/standardliquor/liquor-icps/page/search-list', '9108', '910806', '052.svg', '标准溶液管理（ICP）查询');
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_LIMS_LIQUOR_ICP', '1', '0');
INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
VALUES ('910804', '标准溶液管理（ICP）', 'T_LIMS_LIQUOR_ICP', 'audit_def', '1');
COMMIT;
-- 建表语句
CREATE TABLE T_LIMS_LIQUOR_ICP_VALID(
ID NUMBER NOT NULL,
LIQUORID NUMBER NULL,
LIQUORCODE VARCHAR2(270) NULL,
VERIFYTIME DATE NULL,
MARKLIQUORCONCENTRATION NUMBER(16,5) NULL,
CURVECOEFFICIENT NUMBER(16,3) NULL,
TESTCONCENTRATION NUMBER(16,5) NULL,
LASTMARKLIQUORCONCENTRATION NUMBER(16,5) NULL,
AVG NUMBER(16,4) NULL,
DEVIATION1 NUMBER(16,2) NULL,
DEVIATION2 NUMBER(16,2) NULL,
ISPASS VARCHAR2(36) NULL,
TESTUSER VARCHAR2(270) NULL,
TESTUSERID VARCHAR2(270) NULL,
REMARK VARCHAR2(270) NULL,
AUDITUSER VARCHAR2(270) NULL,
AUDITUSERID VARCHAR2(270) NULL,
ORGID VARCHAR2(60) NULL,
ORGNAME VARCHAR2(60) NULL,
CREATEDBYID VARCHAR2(36) NULL,
CREATEDBYNAME VARCHAR2(60) NULL,
CREATEDTIME DATE NULL,
CREATEDBYORGID VARCHAR2(36) NULL,
CREATEDBYORGNAME VARCHAR2(270) NULL
);
COMMENT ON TABLE T_LIMS_LIQUOR_ICP_VALID IS '标准溶液ICP验证表';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.ID IS '主键';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.LIQUORID IS '标准溶液ID';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.LIQUORCODE IS '标准溶液编号';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.VERIFYTIME IS '验证日期';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.MARKLIQUORCONCENTRATION IS '标液浓度（%）';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.CURVECOEFFICIENT IS '曲线相关系数';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.TESTCONCENTRATION IS '测试浓度';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.LASTMARKLIQUORCONCENTRATION IS '上一批次标液浓度（%）';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.AVG IS '平均值（%）';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.DEVIATION1 IS '相对偏差1（%）';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.DEVIATION2 IS '相对偏差2（%）';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.ISPASS IS '是否合格';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.TESTUSER IS '测试人';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.TESTUSERID IS '测试人ID';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.REMARK IS '备注';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.AUDITUSER IS '审核人';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.AUDITUSERID IS '审核人ID';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.ORGID IS '组ID';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.ORGNAME IS '组名称';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_LIQUOR_ICP_VALID.CREATEDBYORGNAME IS '制单人单位名称';
ALTER TABLE T_LIMS_LIQUOR_ICP_VALID ADD CONSTRAINT PK_LIMS_LIQUOR_ICP_VALID PRIMARY KEY (ID);
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.SERVICE_NAME', '标准溶液ICP验证表', '标准溶液ICP验证表', 'zh-CN', '标准溶液ICP验证表');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.ID', '标准溶液ICP验证表的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.LIQUORID', '标准溶液ICP验证表的标准溶液ID', '标准溶液ID', 'zh-CN', '标准溶液ID');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.LIQUORCODE', '标准溶液ICP验证表的标准溶液编号', '标准溶液编号', 'zh-CN', '标准溶液编号');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.VERIFYTIME', '标准溶液ICP验证表的验证日期', '验证日期', 'zh-CN', '验证日期');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.MARKLIQUORCONCENTRATION', '标准溶液ICP验证表的标液浓度（%）', '标液浓度（%）', 'zh-CN', '标液浓度（%）');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.CURVECOEFFICIENT', '标准溶液ICP验证表的曲线相关系数', '曲线相关系数', 'zh-CN', '曲线相关系数');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.TESTCONCENTRATION', '标准溶液ICP验证表的测试浓度', '测试浓度', 'zh-CN', '测试浓度');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.LASTMARKLIQUORCONCENTRATION', '标准溶液ICP验证表的上一批次标液浓度（%）', '上一批次标液浓度（%）', 'zh-CN', '上一批次标液浓度（%）');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.AVG', '标准溶液ICP验证表的平均值（%）', '平均值（%）', 'zh-CN', '平均值（%）');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.DEVIATION1', '标准溶液ICP验证表的相对偏差1（%）', '相对偏差1（%）', 'zh-CN', '相对偏差1（%）');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.DEVIATION2', '标准溶液ICP验证表的相对偏差2（%）', '相对偏差2（%）', 'zh-CN', '相对偏差2（%）');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.ISPASS', '标准溶液ICP验证表的是否合格', '是否合格', 'zh-CN', '是否合格');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.TESTUSER', '标准溶液ICP验证表的测试人', '测试人', 'zh-CN', '测试人');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.TESTUSERID', '标准溶液ICP验证表的测试人ID', '测试人ID', 'zh-CN', '测试人ID');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.REMARK', '标准溶液ICP验证表的备注', '备注', 'zh-CN', '备注');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.AUDITUSER', '标准溶液ICP验证表的审核人', '审核人', 'zh-CN', '审核人');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.AUDITUSERID', '标准溶液ICP验证表的审核人ID', '审核人ID', 'zh-CN', '审核人ID');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.ORGID', '标准溶液ICP验证表的组ID', '组ID', 'zh-CN', '组ID');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.ORGNAME', '标准溶液ICP验证表的组名称', '组名称', 'zh-CN', '组名称');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.CREATEDBYID', '标准溶液ICP验证表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.CREATEDBYNAME', '标准溶液ICP验证表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.CREATEDTIME', '标准溶液ICP验证表的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.CREATEDBYORGID', '标准溶液ICP验证表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_LIQUOR_ICP_VALID.CREATEDBYORGNAME', '标准溶液ICP验证表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('BASEMODULE.TRM.STANDARDLIQUOR.ICPVALIDATES.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.TRM.STANDARDLIQUOR.ICPVALIDATES.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.TRM.STANDARDLIQUOR.ICPVALIDATES.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.TRM.STANDARDLIQUOR.ICPVALIDATES.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.TRM.STANDARDLIQUOR.ICPVALIDATES.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_LIMS_LIQUOR_ICP_VALID', '0', '0');
COMMIT;
CALL UPDATEI18N('T_LIMS_LIQUOR_ICP_VALID.MARKLIQUORCONCENTRATION', 'zh-CN', '标液浓度');
CALL UPDATEI18N('T_LIMS_LIQUOR_ICP_VALID.LASTMARKLIQUORCONCENTRATION', 'zh-CN', '上一批次标液浓度');