87 lines
5.5 KiB
Plaintext
87 lines
5.5 KiB
Plaintext
-- 创建菜单语句
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('7020', '安全设施核查管理', '', '70', '7020', '006.svg', '安全设施核查管理');
|
|
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_CHECK_FACILITY(
|
|
ID NUMBER NOT NULL,
|
|
FACILITYNAME VARCHAR2(270) NULL,
|
|
AMOUNT NUMBER NULL,
|
|
FACILITYLOCATION VARCHAR2(270) NULL,
|
|
VALIDITY VARCHAR2(270) NULL,
|
|
CHECKTIME DATE NULL,
|
|
EXECPTIONHANDLE VARCHAR2(270) NULL,
|
|
CHECKUSER VARCHAR2(270) NULL,
|
|
CHECKUSERID VARCHAR2(36) 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_FACILITY IS '安全设施核查记录表';
|
|
COMMENT ON COLUMN T_LIMS_CHECK_FACILITY.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_CHECK_FACILITY.FACILITYNAME IS '安全设施名称';
|
|
COMMENT ON COLUMN T_LIMS_CHECK_FACILITY.AMOUNT IS '数量';
|
|
COMMENT ON COLUMN T_LIMS_CHECK_FACILITY.FACILITYLOCATION IS '设施位置';
|
|
COMMENT ON COLUMN T_LIMS_CHECK_FACILITY.VALIDITY IS '有效性检查';
|
|
COMMENT ON COLUMN T_LIMS_CHECK_FACILITY.CHECKTIME IS '检查时间';
|
|
COMMENT ON COLUMN T_LIMS_CHECK_FACILITY.EXECPTIONHANDLE IS '异常处理';
|
|
COMMENT ON COLUMN T_LIMS_CHECK_FACILITY.CHECKUSER IS '检查人';
|
|
COMMENT ON COLUMN T_LIMS_CHECK_FACILITY.CHECKUSERID IS '检查人ID';
|
|
COMMENT ON COLUMN T_LIMS_CHECK_FACILITY.REMARKS IS '备注';
|
|
COMMENT ON COLUMN T_LIMS_CHECK_FACILITY.ORGID IS '组ID';
|
|
COMMENT ON COLUMN T_LIMS_CHECK_FACILITY.ORGNAME IS '组名称';
|
|
COMMENT ON COLUMN T_LIMS_CHECK_FACILITY.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_CHECK_FACILITY.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_CHECK_FACILITY.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_CHECK_FACILITY.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_CHECK_FACILITY.CREATEDBYORGNAME IS '制单人单位名称';
|
|
|
|
ALTER TABLE T_LIMS_CHECK_FACILITY ADD CONSTRAINT PK_LIMS_CHECK_FACILITY PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_CHECK_FACILITY.SERVICE_NAME', '安全设施核查记录表', '安全设施核查记录表', 'zh-CN', '安全设施核查记录表');
|
|
CALL INSERTI18N('T_LIMS_CHECK_FACILITY.ID', '安全设施核查记录表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_CHECK_FACILITY.FACILITYNAME', '安全设施核查记录表的安全设施名称', '安全设施名称', 'zh-CN', '安全设施名称');
|
|
CALL INSERTI18N('T_LIMS_CHECK_FACILITY.AMOUNT', '安全设施核查记录表的数量', '数量', 'zh-CN', '数量');
|
|
CALL INSERTI18N('T_LIMS_CHECK_FACILITY.FACILITYLOCATION', '安全设施核查记录表的设施位置', '设施位置', 'zh-CN', '设施位置');
|
|
CALL INSERTI18N('T_LIMS_CHECK_FACILITY.VALIDITY', '安全设施核查记录表的有效性检查', '有效性检查', 'zh-CN', '有效性检查');
|
|
CALL INSERTI18N('T_LIMS_CHECK_FACILITY.CHECKTIME', '安全设施核查记录表的检查时间', '检查时间', 'zh-CN', '检查时间');
|
|
CALL INSERTI18N('T_LIMS_CHECK_FACILITY.EXECPTIONHANDLE', '安全设施核查记录表的异常处理', '异常处理', 'zh-CN', '异常处理');
|
|
CALL INSERTI18N('T_LIMS_CHECK_FACILITY.CHECKUSER', '安全设施核查记录表的检查人', '检查人', 'zh-CN', '检查人');
|
|
CALL INSERTI18N('T_LIMS_CHECK_FACILITY.CHECKUSERID', '安全设施核查记录表的检查人ID', '检查人ID', 'zh-CN', '检查人ID');
|
|
CALL INSERTI18N('T_LIMS_CHECK_FACILITY.REMARKS', '安全设施核查记录表的备注', '备注', 'zh-CN', '备注');
|
|
CALL INSERTI18N('T_LIMS_CHECK_FACILITY.ORGID', '安全设施核查记录表的组ID', '组ID', 'zh-CN', '组ID');
|
|
CALL INSERTI18N('T_LIMS_CHECK_FACILITY.ORGNAME', '安全设施核查记录表的组名称', '组名称', 'zh-CN', '组名称');
|
|
CALL INSERTI18N('T_LIMS_CHECK_FACILITY.CREATEDBYID', '安全设施核查记录表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_CHECK_FACILITY.CREATEDBYNAME', '安全设施核查记录表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_CHECK_FACILITY.CREATEDTIME', '安全设施核查记录表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_CHECK_FACILITY.CREATEDBYORGID', '安全设施核查记录表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_CHECK_FACILITY.CREATEDBYORGNAME', '安全设施核查记录表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('BASEMODULE.QMS.SAFETYFACILITIESS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.QMS.SAFETYFACILITIESS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.QMS.SAFETYFACILITIESS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.QMS.SAFETYFACILITIESS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.QMS.SAFETYFACILITIESS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
-- 创建菜单语句
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('702001', '安全设施核查记录', '/secure/basemodule/qms/check-facilitys/page/edit-list', '7020', '702001', '063.svg', '安全设施核查记录');
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_CHECK_FACILITY', '0', '0');
|
|
|
|
COMMIT;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|