-- 建表语句
CREATE TABLE T_LIMS_CHECK_BOTTLE(
    ID NUMBER NOT NULL,
    CHECKPROJECT VARCHAR2(270)  NULL,
    CHECKCONTENT VARCHAR2(270)  NULL,
    CHECKCONDITION VARCHAR2(270)  NULL,
    REFORMUSER VARCHAR2(270)  NULL,
    REFORMUSERID VARCHAR2(36)  NULL,
    LIMITTIME DATE NULL,
    FINISHTIME DATE NULL,
    REMARKS 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_CHECK_BOTTLE IS '气瓶专项核查表';
COMMENT ON COLUMN T_LIMS_CHECK_BOTTLE.ID IS '主键';
COMMENT ON COLUMN T_LIMS_CHECK_BOTTLE.CHECKPROJECT IS '检查项目';
COMMENT ON COLUMN T_LIMS_CHECK_BOTTLE.CHECKCONTENT IS '检查内容';
COMMENT ON COLUMN T_LIMS_CHECK_BOTTLE.CHECKCONDITION IS '检查情况';
COMMENT ON COLUMN T_LIMS_CHECK_BOTTLE.REFORMUSER IS '整改负责人';
COMMENT ON COLUMN T_LIMS_CHECK_BOTTLE.REFORMUSERID IS '整改负责人ID';
COMMENT ON COLUMN T_LIMS_CHECK_BOTTLE.LIMITTIME IS '整改时限';
COMMENT ON COLUMN T_LIMS_CHECK_BOTTLE.FINISHTIME IS '整改完成时间';
COMMENT ON COLUMN T_LIMS_CHECK_BOTTLE.REMARKS IS '备注';
COMMENT ON COLUMN T_LIMS_CHECK_BOTTLE.ORGID IS '组ID';
COMMENT ON COLUMN T_LIMS_CHECK_BOTTLE.ORGNAME IS '组名称';
COMMENT ON COLUMN T_LIMS_CHECK_BOTTLE.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_CHECK_BOTTLE.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_CHECK_BOTTLE.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_CHECK_BOTTLE.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_CHECK_BOTTLE.CREATEDBYORGNAME IS '制单人单位名称';

ALTER TABLE T_LIMS_CHECK_BOTTLE ADD CONSTRAINT PK_LIMS_CHECK_BOTTLE PRIMARY KEY (ID);

CALL INSERTI18N('T_LIMS_CHECK_BOTTLE.SERVICE_NAME', '气瓶专项核查表', '气瓶专项核查表', 'zh-CN', '气瓶专项核查表');
CALL INSERTI18N('T_LIMS_CHECK_BOTTLE.ID', '气瓶专项核查表的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_CHECK_BOTTLE.CHECKPROJECT', '气瓶专项核查表的检查项目', '检查项目', 'zh-CN', '检查项目');
CALL INSERTI18N('T_LIMS_CHECK_BOTTLE.CHECKCONTENT', '气瓶专项核查表的检查内容', '检查内容', 'zh-CN', '检查内容');
CALL INSERTI18N('T_LIMS_CHECK_BOTTLE.CHECKCONDITION', '气瓶专项核查表的检查情况', '检查情况', 'zh-CN', '检查情况');
CALL INSERTI18N('T_LIMS_CHECK_BOTTLE.REFORMUSER', '气瓶专项核查表的整改负责人', '整改负责人', 'zh-CN', '整改负责人');
CALL INSERTI18N('T_LIMS_CHECK_BOTTLE.REFORMUSERID', '气瓶专项核查表的整改负责人ID', '整改负责人ID', 'zh-CN', '整改负责人ID');
CALL INSERTI18N('T_LIMS_CHECK_BOTTLE.LIMITTIME', '气瓶专项核查表的整改时限', '整改时限', 'zh-CN', '整改时限');
CALL INSERTI18N('T_LIMS_CHECK_BOTTLE.FINISHTIME', '气瓶专项核查表的整改完成时间', '整改完成时间', 'zh-CN', '整改完成时间');
CALL INSERTI18N('T_LIMS_CHECK_BOTTLE.REMARKS', '气瓶专项核查表的备注', '备注', 'zh-CN', '备注');
CALL INSERTI18N('T_LIMS_CHECK_BOTTLE.ORGID', '气瓶专项核查表的组ID', '组ID', 'zh-CN', '组ID');
CALL INSERTI18N('T_LIMS_CHECK_BOTTLE.ORGNAME', '气瓶专项核查表的组名称', '组名称', 'zh-CN', '组名称');
CALL INSERTI18N('T_LIMS_CHECK_BOTTLE.CREATEDBYID', '气瓶专项核查表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_CHECK_BOTTLE.CREATEDBYNAME', '气瓶专项核查表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_CHECK_BOTTLE.CREATEDTIME', '气瓶专项核查表的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_CHECK_BOTTLE.CREATEDBYORGID', '气瓶专项核查表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_CHECK_BOTTLE.CREATEDBYORGNAME', '气瓶专项核查表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('BASEMODULE.QMS.CHECKBOTTLES.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.QMS.CHECKBOTTLES.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.QMS.CHECKBOTTLES.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.QMS.CHECKBOTTLES.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.QMS.CHECKBOTTLES.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');

-- 创建菜单语句
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('702002', '气瓶专项核查记录', '/secure/basemodule/qms/check-bottles/page/edit-list', '7020', '702002', '021.svg', '气瓶专项核查记录');

INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_LIMS_CHECK_BOTTLE', '0', '0');


COMMIT;