404 lines
49 KiB
Plaintext
404 lines
49 KiB
Plaintext
-- ----------------------------- 2022-08-30 add by lijiaxing@sunwayworld.com--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABlE DBO.T_LIMS_STAFF(
|
|
ID BIGINT NOT NULL,
|
|
CREATEDBYID VARCHAR(36) NULL ,
|
|
CREATEDBYNAME VARCHAR(60) NULL ,
|
|
CREATEDTIME DATETIME NULL ,
|
|
CREATEDBYORGID VARCHAR(36) NULL ,
|
|
CREATEDBYORGNAME VARCHAR(270) NULL ,
|
|
USERID VARCHAR(36) NULL ,
|
|
USERNAME VARCHAR(36) NULL ,
|
|
USERNO VARCHAR(36) NULL ,
|
|
SEX VARCHAR(12) NULL ,
|
|
BRITHDAY DATETIME NULL ,
|
|
IDNO VARCHAR(18) NULL ,
|
|
NATIVEPLACE VARCHAR(120) NULL ,
|
|
ADDRESS VARCHAR(120) NULL ,
|
|
ENTRYDATE DATETIME NULL ,
|
|
POST VARCHAR(36) NULL ,
|
|
PROFESSIONALTITLE VARCHAR(36) NULL ,
|
|
GRADUATION DATETIME NULL ,
|
|
MAJOR VARCHAR(36) NULL ,
|
|
EDUDEGREE VARCHAR(36) NULL ,
|
|
REMARKS VARCHAR(360) NULL ,
|
|
CONSTRAINT PK_LIMS_STAFF PRIMARY KEY(ID));
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员档案表' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF', @level2type=N'COLUMN',@level2name=N'ID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF', @level2type=N'COLUMN',@level2name=N'CREATEDBYID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF', @level2type=N'COLUMN',@level2name=N'CREATEDBYNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF', @level2type=N'COLUMN',@level2name=N'CREATEDTIME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF', @level2type=N'COLUMN',@level2name=N'USERID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员姓名' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF', @level2type=N'COLUMN',@level2name=N'USERNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员工号' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF', @level2type=N'COLUMN',@level2name=N'USERNO';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF', @level2type=N'COLUMN',@level2name=N'SEX';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出生日期' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF', @level2type=N'COLUMN',@level2name=N'BRITHDAY';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'身份证号' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF', @level2type=N'COLUMN',@level2name=N'IDNO';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'籍贯' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF', @level2type=N'COLUMN',@level2name=N'NATIVEPLACE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'现住地址' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF', @level2type=N'COLUMN',@level2name=N'ADDRESS';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入职日期' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF', @level2type=N'COLUMN',@level2name=N'ENTRYDATE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'岗位' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF', @level2type=N'COLUMN',@level2name=N'POST';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF', @level2type=N'COLUMN',@level2name=N'PROFESSIONALTITLE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'毕业时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF', @level2type=N'COLUMN',@level2name=N'GRADUATION';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所学专业' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF', @level2type=N'COLUMN',@level2name=N'MAJOR';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文化程度' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF', @level2type=N'COLUMN',@level2name=N'EDUDEGREE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF', @level2type=N'COLUMN',@level2name=N'REMARKS';
|
|
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF.SERVICE_NAME', N'人员档案表', N'人员档案表', N'zh-CN',N'人员档案表';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF.ID', N'人员档案表的主键', N'主键', N'zh-CN',N'主键';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF.CREATEDBYID', N'人员档案表的制单人编码', N'制单人编码', N'zh-CN',N'制单人编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF.CREATEDBYNAME', N'人员档案表的制单人名称', N'制单人名称', N'zh-CN',N'制单人名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF.CREATEDTIME', N'人员档案表的制单时间', N'制单时间', N'zh-CN',N'制单时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF.CREATEDBYORGID', N'人员档案表的制单人单位编码', N'制单人单位编码', N'zh-CN',N'制单人单位编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF.CREATEDBYORGNAME', N'人员档案表的制单人单位名称', N'制单人单位名称', N'zh-CN',N'制单人单位名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF.USERID', N'人员档案表的人员编码', N'人员编码', N'zh-CN',N'人员编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF.USERNAME', N'人员档案表的人员姓名', N'人员姓名', N'zh-CN',N'人员姓名';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF.USERNO', N'人员档案表的人员工号', N'人员工号', N'zh-CN',N'人员工号';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF.SEX', N'人员档案表的性别', N'性别', N'zh-CN',N'性别';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF.BRITHDAY', N'人员档案表的出生日期', N'出生日期', N'zh-CN',N'出生日期';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF.IDNO', N'人员档案表的身份证号', N'身份证号', N'zh-CN',N'身份证号';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF.NATIVEPLACE', N'人员档案表的籍贯', N'籍贯', N'zh-CN',N'籍贯';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF.ADDRESS', N'人员档案表的现住地址', N'现住地址', N'zh-CN',N'现住地址';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF.ENTRYDATE', N'人员档案表的入职日期', N'入职日期', N'zh-CN',N'入职日期';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF.POST', N'人员档案表的岗位', N'岗位', N'zh-CN',N'岗位';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF.PROFESSIONALTITLE', N'人员档案表的职称', N'职称', N'zh-CN',N'职称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF.GRADUATION', N'人员档案表的毕业时间', N'毕业时间', N'zh-CN',N'毕业时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF.MAJOR', N'人员档案表的所学专业', N'所学专业', N'zh-CN',N'所学专业';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF.EDUDEGREE', N'人员档案表的文化程度', N'文化程度', N'zh-CN',N'文化程度';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF.REMARKS', N'人员档案表的备注', N'备注', N'zh-CN',N'备注';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.STAFFS.MODAL.ADD', N'新增', N'新增', N'zh-CN',N'新增';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.STAFFS.TAB.BASE_INFO', N'基本信息', N'基本信息', N'zh-CN',N'基本信息';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.STAFFS.BUTTON.BUTTON', N'按钮', N'按钮', N'zh-CN',N'按钮';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.STAFFS.TIP.TIP', N'提示框', N'提示框', N'zh-CN',N'提示框';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.STAFFS.MODAL.MODAL', N'对话框', N'对话框', N'zh-CN',N'对话框';
|
|
|
|
-- 创建菜单语句
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('9101', '人员管理', '', '91', '9101', '008.svg', '人员管理');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('910101', '人员信息', '/secure/basemodule/basedata/staff/staffs/page/edit-list', '9101', '910101', '008.svg', '人员信息');
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_STAFF', '0', '0');
|
|
|
|
-- 建表语句
|
|
CREATE TABlE DBO.T_LIMS_STAFF_TEST_GRANT(
|
|
ID BIGINT NOT NULL,
|
|
CREATEDBYID VARCHAR(36) NULL ,
|
|
CREATEDBYNAME VARCHAR(60) NULL ,
|
|
CREATEDTIME DATETIME NULL ,
|
|
CREATEDBYORGID VARCHAR(36) NULL ,
|
|
CREATEDBYORGNAME VARCHAR(270) NULL ,
|
|
PROCESSSTATUS VARCHAR(36) NULL ,
|
|
STAFFID BIGINT NULL ,
|
|
STAFFNAME VARCHAR(60) NULL ,
|
|
TESTID BIGINT NULL ,
|
|
REMARKS VARCHAR(360) NULL ,
|
|
CONSTRAINT PK_LIMS_STAFF_TEST_GRANT PRIMARY KEY(ID));
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员检测项目授权表' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_TEST_GRANT';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_TEST_GRANT', @level2type=N'COLUMN',@level2name=N'ID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_TEST_GRANT', @level2type=N'COLUMN',@level2name=N'CREATEDBYID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_TEST_GRANT', @level2type=N'COLUMN',@level2name=N'CREATEDBYNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_TEST_GRANT', @level2type=N'COLUMN',@level2name=N'CREATEDTIME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_TEST_GRANT', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_TEST_GRANT', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流程状态' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_TEST_GRANT', @level2type=N'COLUMN',@level2name=N'PROCESSSTATUS';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_TEST_GRANT', @level2type=N'COLUMN',@level2name=N'STAFFID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_TEST_GRANT', @level2type=N'COLUMN',@level2name=N'STAFFNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'检测项目ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_TEST_GRANT', @level2type=N'COLUMN',@level2name=N'TESTID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_TEST_GRANT', @level2type=N'COLUMN',@level2name=N'REMARKS';
|
|
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_TEST_GRANT.SERVICE_NAME', N'人员检测项目授权表', N'人员检测项目授权表', N'zh-CN',N'人员检测项目授权表';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_TEST_GRANT.ID', N'人员检测项目授权表的主键', N'主键', N'zh-CN',N'主键';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_TEST_GRANT.CREATEDBYID', N'人员检测项目授权表的制单人编码', N'制单人编码', N'zh-CN',N'制单人编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_TEST_GRANT.CREATEDBYNAME', N'人员检测项目授权表的制单人名称', N'制单人名称', N'zh-CN',N'制单人名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_TEST_GRANT.CREATEDTIME', N'人员检测项目授权表的制单时间', N'制单时间', N'zh-CN',N'制单时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_TEST_GRANT.CREATEDBYORGID', N'人员检测项目授权表的制单人单位编码', N'制单人单位编码', N'zh-CN',N'制单人单位编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_TEST_GRANT.CREATEDBYORGNAME', N'人员检测项目授权表的制单人单位名称', N'制单人单位名称', N'zh-CN',N'制单人单位名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_TEST_GRANT.PROCESSSTATUS', N'人员检测项目授权表的流程状态', N'流程状态', N'zh-CN',N'流程状态';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_TEST_GRANT.STAFFID', N'人员检测项目授权表的人员ID', N'人员ID', N'zh-CN',N'人员ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_TEST_GRANT.STAFFNAME', N'人员检测项目授权表的人员名称', N'人员名称', N'zh-CN',N'人员名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_TEST_GRANT.TESTID', N'人员检测项目授权表的检测项目ID', N'检测项目ID', N'zh-CN',N'检测项目ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_TEST_GRANT.REMARKS', N'人员检测项目授权表的备注', N'备注', N'zh-CN',N'备注';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.TESTGRANTS.MODAL.ADD', N'新增', N'新增', N'zh-CN',N'新增';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.TESTGRANTS.TAB.BASE_INFO', N'基本信息', N'基本信息', N'zh-CN',N'基本信息';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.TESTGRANTS.BUTTON.BUTTON', N'按钮', N'按钮', N'zh-CN',N'按钮';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.TESTGRANTS.TIP.TIP', N'提示框', N'提示框', N'zh-CN',N'提示框';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.TESTGRANTS.MODAL.MODAL', N'对话框', N'对话框', N'zh-CN',N'对话框';
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_STAFF_TEST_GRANT', '1', '0');
|
|
|
|
INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
|
|
VALUES ('910102', '检测项目授权', 'T_LIMS_STAFF_TEST_GRANT', 'audit_def', '1');
|
|
|
|
|
|
-- 建表语句
|
|
CREATE TABlE DBO.T_LIMS_STAFF_EQUIPT_GRANT(
|
|
ID BIGINT NOT NULL,
|
|
CREATEDBYID VARCHAR(36) NULL ,
|
|
CREATEDBYNAME VARCHAR(60) NULL ,
|
|
CREATEDTIME DATETIME NULL ,
|
|
CREATEDBYORGID VARCHAR(36) NULL ,
|
|
CREATEDBYORGNAME VARCHAR(270) NULL ,
|
|
PROCESSSTATUS VARCHAR(36) NULL ,
|
|
STAFFID BIGINT NULL ,
|
|
STAFFNAME VARCHAR(60) NULL ,
|
|
EQUIPTID BIGINT NULL ,
|
|
REMARKS VARCHAR(360) NULL ,
|
|
CONSTRAINT PK_LIMS_STAFF_EQUIPT_GRANT PRIMARY KEY(ID));
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'仪器设备授权表' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EQUIPT_GRANT';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EQUIPT_GRANT', @level2type=N'COLUMN',@level2name=N'ID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EQUIPT_GRANT', @level2type=N'COLUMN',@level2name=N'CREATEDBYID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EQUIPT_GRANT', @level2type=N'COLUMN',@level2name=N'CREATEDBYNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EQUIPT_GRANT', @level2type=N'COLUMN',@level2name=N'CREATEDTIME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EQUIPT_GRANT', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EQUIPT_GRANT', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流程状态' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EQUIPT_GRANT', @level2type=N'COLUMN',@level2name=N'PROCESSSTATUS';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EQUIPT_GRANT', @level2type=N'COLUMN',@level2name=N'STAFFID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EQUIPT_GRANT', @level2type=N'COLUMN',@level2name=N'STAFFNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EQUIPT_GRANT', @level2type=N'COLUMN',@level2name=N'EQUIPTID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EQUIPT_GRANT', @level2type=N'COLUMN',@level2name=N'REMARKS';
|
|
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EQUIPT_GRANT.SERVICE_NAME', N'仪器设备授权表', N'仪器设备授权表', N'zh-CN',N'仪器设备授权表';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EQUIPT_GRANT.ID', N'仪器设备授权表的主键', N'主键', N'zh-CN',N'主键';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EQUIPT_GRANT.CREATEDBYID', N'仪器设备授权表的制单人编码', N'制单人编码', N'zh-CN',N'制单人编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EQUIPT_GRANT.CREATEDBYNAME', N'仪器设备授权表的制单人名称', N'制单人名称', N'zh-CN',N'制单人名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EQUIPT_GRANT.CREATEDTIME', N'仪器设备授权表的制单时间', N'制单时间', N'zh-CN',N'制单时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EQUIPT_GRANT.CREATEDBYORGID', N'仪器设备授权表的制单人单位编码', N'制单人单位编码', N'zh-CN',N'制单人单位编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EQUIPT_GRANT.CREATEDBYORGNAME', N'仪器设备授权表的制单人单位名称', N'制单人单位名称', N'zh-CN',N'制单人单位名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EQUIPT_GRANT.PROCESSSTATUS', N'仪器设备授权表的流程状态', N'流程状态', N'zh-CN',N'流程状态';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EQUIPT_GRANT.STAFFID', N'仪器设备授权表的人员ID', N'人员ID', N'zh-CN',N'人员ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EQUIPT_GRANT.STAFFNAME', N'仪器设备授权表的人员名称', N'人员名称', N'zh-CN',N'人员名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EQUIPT_GRANT.EQUIPTID', N'仪器设备授权表的设备ID', N'设备ID', N'zh-CN',N'设备ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EQUIPT_GRANT.REMARKS', N'仪器设备授权表的备注', N'备注', N'zh-CN',N'备注';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.EQUIPTGRANTS.MODAL.ADD', N'新增', N'新增', N'zh-CN',N'新增';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.EQUIPTGRANTS.TAB.BASE_INFO', N'基本信息', N'基本信息', N'zh-CN',N'基本信息';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.EQUIPTGRANTS.BUTTON.BUTTON', N'按钮', N'按钮', N'zh-CN',N'按钮';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.EQUIPTGRANTS.TIP.TIP', N'提示框', N'提示框', N'zh-CN',N'提示框';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.EQUIPTGRANTS.MODAL.MODAL', N'对话框', N'对话框', N'zh-CN',N'对话框';
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_STAFF_EQUIPT_GRANT', '1', '0');
|
|
|
|
INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
|
|
VALUES ('910103', '仪器设备授权', 'T_LIMS_STAFF_EQUIPT_GRANT', 'audit_def', '1');
|
|
|
|
-- 建表语句
|
|
CREATE TABlE DBO.T_LIMS_STAFF_CERTIFICATE(
|
|
ID BIGINT NOT NULL,
|
|
CREATEDBYID VARCHAR(36) NULL ,
|
|
CREATEDBYNAME VARCHAR(60) NULL ,
|
|
CREATEDTIME DATETIME NULL ,
|
|
CREATEDBYORGID VARCHAR(36) NULL ,
|
|
CREATEDBYORGNAME VARCHAR(270) NULL ,
|
|
STAFFID BIGINT NULL ,
|
|
CERTIFICATECODE VARCHAR(36) NULL ,
|
|
CERTIFICATENAME VARCHAR(120) NULL ,
|
|
ISSUEUNIT VARCHAR(120) NULL ,
|
|
ISSUEDATE DATETIME NULL ,
|
|
EFFECTIVETIME DATETIME NULL ,
|
|
CERTIFICATEDESC VARCHAR(360) NULL ,
|
|
REMARKS VARCHAR(360) NULL ,
|
|
CONSTRAINT PK_LIMS_STAFF_CERTIFICATE PRIMARY KEY(ID));
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员资格证书表' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_CERTIFICATE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_CERTIFICATE', @level2type=N'COLUMN',@level2name=N'ID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_CERTIFICATE', @level2type=N'COLUMN',@level2name=N'CREATEDBYID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_CERTIFICATE', @level2type=N'COLUMN',@level2name=N'CREATEDBYNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_CERTIFICATE', @level2type=N'COLUMN',@level2name=N'CREATEDTIME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_CERTIFICATE', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_CERTIFICATE', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_CERTIFICATE', @level2type=N'COLUMN',@level2name=N'STAFFID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'证书编号' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_CERTIFICATE', @level2type=N'COLUMN',@level2name=N'CERTIFICATECODE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'证书名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_CERTIFICATE', @level2type=N'COLUMN',@level2name=N'CERTIFICATENAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发证单位' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_CERTIFICATE', @level2type=N'COLUMN',@level2name=N'ISSUEUNIT';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发证日期' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_CERTIFICATE', @level2type=N'COLUMN',@level2name=N'ISSUEDATE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'证书有效期' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_CERTIFICATE', @level2type=N'COLUMN',@level2name=N'EFFECTIVETIME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'证书描述' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_CERTIFICATE', @level2type=N'COLUMN',@level2name=N'CERTIFICATEDESC';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_CERTIFICATE', @level2type=N'COLUMN',@level2name=N'REMARKS';
|
|
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_CERTIFICATE.SERVICE_NAME', N'人员资格证书表', N'人员资格证书表', N'zh-CN',N'人员资格证书表';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_CERTIFICATE.ID', N'人员资格证书表的主键', N'主键', N'zh-CN',N'主键';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_CERTIFICATE.CREATEDBYID', N'人员资格证书表的制单人编码', N'制单人编码', N'zh-CN',N'制单人编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_CERTIFICATE.CREATEDBYNAME', N'人员资格证书表的制单人名称', N'制单人名称', N'zh-CN',N'制单人名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_CERTIFICATE.CREATEDTIME', N'人员资格证书表的制单时间', N'制单时间', N'zh-CN',N'制单时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_CERTIFICATE.CREATEDBYORGID', N'人员资格证书表的制单人单位编码', N'制单人单位编码', N'zh-CN',N'制单人单位编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_CERTIFICATE.CREATEDBYORGNAME', N'人员资格证书表的制单人单位名称', N'制单人单位名称', N'zh-CN',N'制单人单位名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_CERTIFICATE.STAFFID', N'人员资格证书表的人员ID', N'人员ID', N'zh-CN',N'人员ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_CERTIFICATE.CERTIFICATECODE', N'人员资格证书表的证书编号', N'证书编号', N'zh-CN',N'证书编号';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_CERTIFICATE.CERTIFICATENAME', N'人员资格证书表的证书名称', N'证书名称', N'zh-CN',N'证书名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_CERTIFICATE.ISSUEUNIT', N'人员资格证书表的发证单位', N'发证单位', N'zh-CN',N'发证单位';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_CERTIFICATE.ISSUEDATE', N'人员资格证书表的发证日期', N'发证日期', N'zh-CN',N'发证日期';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_CERTIFICATE.EFFECTIVETIME', N'人员资格证书表的证书有效期', N'证书有效期', N'zh-CN',N'证书有效期';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_CERTIFICATE.CERTIFICATEDESC', N'人员资格证书表的证书描述', N'证书描述', N'zh-CN',N'证书描述';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_CERTIFICATE.REMARKS', N'人员资格证书表的备注', N'备注', N'zh-CN',N'备注';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.CERTIFICATES.MODAL.ADD', N'新增', N'新增', N'zh-CN',N'新增';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.CERTIFICATES.TAB.BASE_INFO', N'基本信息', N'基本信息', N'zh-CN',N'基本信息';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.CERTIFICATES.BUTTON.BUTTON', N'按钮', N'按钮', N'zh-CN',N'按钮';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.CERTIFICATES.TIP.TIP', N'提示框', N'提示框', N'zh-CN',N'提示框';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.CERTIFICATES.MODAL.MODAL', N'对话框', N'对话框', N'zh-CN',N'对话框';
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_STAFF_CERTIFICATE', '0', '0');
|
|
|
|
-- 建表语句
|
|
CREATE TABlE DBO.T_LIMS_STAFF_WORK_EXPERIENCE(
|
|
ID BIGINT NOT NULL,
|
|
CREATEDBYID VARCHAR(36) NULL ,
|
|
CREATEDBYNAME VARCHAR(60) NULL ,
|
|
CREATEDTIME DATETIME NULL ,
|
|
CREATEDBYORGID VARCHAR(36) NULL ,
|
|
CREATEDBYORGNAME VARCHAR(270) NULL ,
|
|
STAFFID BIGINT NULL ,
|
|
STARTTIME DATETIME NULL ,
|
|
ENDTIME DATETIME NULL ,
|
|
WORKUNIT VARCHAR(120) NULL ,
|
|
POSITION VARCHAR(36) NULL ,
|
|
MAJORJOB VARCHAR(360) NULL ,
|
|
REMARKS VARCHAR(360) NULL ,
|
|
CONSTRAINT PK_LIMS_STAFF_WORK_EXPERIENCE PRIMARY KEY(ID));
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员工作经历表' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_WORK_EXPERIENCE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_WORK_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'ID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_WORK_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'CREATEDBYID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_WORK_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'CREATEDBYNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_WORK_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'CREATEDTIME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_WORK_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_WORK_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_WORK_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'STAFFID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'开始时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_WORK_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'STARTTIME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'结束时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_WORK_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'ENDTIME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工作单位' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_WORK_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'WORKUNIT';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职位' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_WORK_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'POSITION';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主要工作内容' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_WORK_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'MAJORJOB';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_WORK_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'REMARKS';
|
|
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_WORK_EXPERIENCE.SERVICE_NAME', N'人员工作经历表', N'人员工作经历表', N'zh-CN',N'人员工作经历表';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_WORK_EXPERIENCE.ID', N'人员工作经历表的主键', N'主键', N'zh-CN',N'主键';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_WORK_EXPERIENCE.CREATEDBYID', N'人员工作经历表的制单人编码', N'制单人编码', N'zh-CN',N'制单人编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_WORK_EXPERIENCE.CREATEDBYNAME', N'人员工作经历表的制单人名称', N'制单人名称', N'zh-CN',N'制单人名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_WORK_EXPERIENCE.CREATEDTIME', N'人员工作经历表的制单时间', N'制单时间', N'zh-CN',N'制单时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_WORK_EXPERIENCE.CREATEDBYORGID', N'人员工作经历表的制单人单位编码', N'制单人单位编码', N'zh-CN',N'制单人单位编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_WORK_EXPERIENCE.CREATEDBYORGNAME', N'人员工作经历表的制单人单位名称', N'制单人单位名称', N'zh-CN',N'制单人单位名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_WORK_EXPERIENCE.STAFFID', N'人员工作经历表的人员ID', N'人员ID', N'zh-CN',N'人员ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_WORK_EXPERIENCE.STARTTIME', N'人员工作经历表的开始时间', N'开始时间', N'zh-CN',N'开始时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_WORK_EXPERIENCE.ENDTIME', N'人员工作经历表的结束时间', N'结束时间', N'zh-CN',N'结束时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_WORK_EXPERIENCE.WORKUNIT', N'人员工作经历表的工作单位', N'工作单位', N'zh-CN',N'工作单位';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_WORK_EXPERIENCE.POSITION', N'人员工作经历表的职位', N'职位', N'zh-CN',N'职位';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_WORK_EXPERIENCE.MAJORJOB', N'人员工作经历表的主要工作内容', N'主要工作内容', N'zh-CN',N'主要工作内容';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_WORK_EXPERIENCE.REMARKS', N'人员工作经历表的备注', N'备注', N'zh-CN',N'备注';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.WORKEXPERIENCES.MODAL.ADD', N'新增', N'新增', N'zh-CN',N'新增';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.WORKEXPERIENCES.TAB.BASE_INFO', N'基本信息', N'基本信息', N'zh-CN',N'基本信息';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.WORKEXPERIENCES.BUTTON.BUTTON', N'按钮', N'按钮', N'zh-CN',N'按钮';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.WORKEXPERIENCES.TIP.TIP', N'提示框', N'提示框', N'zh-CN',N'提示框';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.WORKEXPERIENCES.MODAL.MODAL', N'对话框', N'对话框', N'zh-CN',N'对话框';
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_STAFF_WORK_EXPERIENCE', '0', '0');
|
|
|
|
|
|
-- 建表语句
|
|
CREATE TABlE DBO.T_LIMS_STAFF_EDU_EXPERIENCE(
|
|
ID BIGINT NOT NULL,
|
|
CREATEDBYID VARCHAR(36) NULL ,
|
|
CREATEDBYNAME VARCHAR(60) NULL ,
|
|
CREATEDTIME DATETIME NULL ,
|
|
CREATEDBYORGID VARCHAR(36) NULL ,
|
|
CREATEDBYORGNAME VARCHAR(270) NULL ,
|
|
STAFFID BIGINT NULL ,
|
|
STARTTIME DATETIME NULL ,
|
|
ENDTIME DATETIME NULL ,
|
|
SCHOOL VARCHAR(120) NULL ,
|
|
ADDRESS VARCHAR(360) NULL ,
|
|
MAJOR VARCHAR(36) NULL ,
|
|
REMARKS VARCHAR(360) NULL ,
|
|
CONSTRAINT PK_LIMS_STAFF_EDU_EXPERIENCE PRIMARY KEY(ID));
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员教育经历表' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EDU_EXPERIENCE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EDU_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'ID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EDU_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'CREATEDBYID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EDU_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'CREATEDBYNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EDU_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'CREATEDTIME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EDU_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EDU_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EDU_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'STAFFID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'开始时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EDU_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'STARTTIME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'结束时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EDU_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'ENDTIME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学校' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EDU_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'SCHOOL';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学校地址' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EDU_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'ADDRESS';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所学专业' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EDU_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'MAJOR';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_STAFF_EDU_EXPERIENCE', @level2type=N'COLUMN',@level2name=N'REMARKS';
|
|
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EDU_EXPERIENCE.SERVICE_NAME', N'人员教育经历表', N'人员教育经历表', N'zh-CN',N'人员教育经历表';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EDU_EXPERIENCE.ID', N'人员教育经历表的主键', N'主键', N'zh-CN',N'主键';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EDU_EXPERIENCE.CREATEDBYID', N'人员教育经历表的制单人编码', N'制单人编码', N'zh-CN',N'制单人编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EDU_EXPERIENCE.CREATEDBYNAME', N'人员教育经历表的制单人名称', N'制单人名称', N'zh-CN',N'制单人名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EDU_EXPERIENCE.CREATEDTIME', N'人员教育经历表的制单时间', N'制单时间', N'zh-CN',N'制单时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EDU_EXPERIENCE.CREATEDBYORGID', N'人员教育经历表的制单人单位编码', N'制单人单位编码', N'zh-CN',N'制单人单位编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EDU_EXPERIENCE.CREATEDBYORGNAME', N'人员教育经历表的制单人单位名称', N'制单人单位名称', N'zh-CN',N'制单人单位名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EDU_EXPERIENCE.STAFFID', N'人员教育经历表的人员ID', N'人员ID', N'zh-CN',N'人员ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EDU_EXPERIENCE.STARTTIME', N'人员教育经历表的开始时间', N'开始时间', N'zh-CN',N'开始时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EDU_EXPERIENCE.ENDTIME', N'人员教育经历表的结束时间', N'结束时间', N'zh-CN',N'结束时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EDU_EXPERIENCE.SCHOOL', N'人员教育经历表的学校', N'学校', N'zh-CN',N'学校';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EDU_EXPERIENCE.ADDRESS', N'人员教育经历表的学校地址', N'学校地址', N'zh-CN',N'学校地址';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EDU_EXPERIENCE.MAJOR', N'人员教育经历表的所学专业', N'所学专业', N'zh-CN',N'所学专业';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EDU_EXPERIENCE.REMARKS', N'人员教育经历表的备注', N'备注', N'zh-CN',N'备注';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.EDUEXPERIENCES.MODAL.ADD', N'新增', N'新增', N'zh-CN',N'新增';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.EDUEXPERIENCES.TAB.BASE_INFO', N'基本信息', N'基本信息', N'zh-CN',N'基本信息';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.EDUEXPERIENCES.BUTTON.BUTTON', N'按钮', N'按钮', N'zh-CN',N'按钮';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.EDUEXPERIENCES.TIP.TIP', N'提示框', N'提示框', N'zh-CN',N'提示框';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.EDUEXPERIENCES.MODAL.MODAL', N'对话框', N'对话框', N'zh-CN',N'对话框';
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_STAFF_EDU_EXPERIENCE', '0', '0');
|
|
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.STAFFS.STAFF', '基本信息', '基本信息', 'zh-CN', '基本信息';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.STAFFS.CERTIFICATE', '资格证书', '资格证书', 'zh-CN', '资格证书';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.STAFFS.WORKEXPERIENCE', '工作经历', '工作经历', 'zh-CN', '工作经历';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.STAFFS.EDUEXPERIENCE', '教育经历', '教育经历', 'zh-CN', '教育经历';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.STAFFS.TESTGRANT', '检测项目授权', '检测项目授权', 'zh-CN', '检测项目授权';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.STAFFS.EQUIPTGRANT', '仪器设备授权', '仪器设备授权', 'zh-CN', '仪器设备授权';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.BASEDATA.STAFF.STAFFS.EMPTY.TOAST', '未选中人员', '未选中人员', 'zh-CN', '未选中人员';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EQUIPT_GRANT.EXT.EQUIPTNAME', '设备名称', '未选中人员', 'zh-CN', '设备名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_EQUIPT_GRANT.EXT.EQUIPTCODE', '设备编号', '未选中人员', 'zh-CN', '设备编号';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_TEST_GRANT.EXT.TESTCODE', '检测项目编码', '未选中人员', 'zh-CN', '检测项目编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_STAFF_TEST_GRANT.EXT.TESTNAME', '检测项目名称', '未选中人员', 'zh-CN', '检测项目名称';
|
|
|
|
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID)
|
|
VALUES ('eduDegree', '文化程度', 'sys');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202208301501, '初中', '1', 1, 'eduDegree', 0, 'admin', '系统管理员', '0');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202208301502, '高中', '2', 2, 'eduDegree', 0, 'admin', '系统管理员', '0');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202208301503, '大学', '3', 3, 'eduDegree', 0, 'admin', '系统管理员', '0');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202208301504, '研究生', '4', 4, 'eduDegree', 0, 'admin', '系统管理员', '0');
|
|
|
|
|
|
-- ----------------------------- 2022-08-30 add by lijiaxing@sunwayworld.com------------end
|
|
-- 创建菜单语句
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('910102', '检测项目授权管理', '', '9101', '2', '008.svg', '人员信息');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91010201', '检测项目授权申请', '/secure/basemodule/basedata/staff/staff-test-grants/page/edit-list', '910102', '1', '008.svg', '检测项目授权申请');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91010202', '检测项目授权审核', '/secure/basemodule/basedata/staff/staff-test-grants/page/audit-list', '910102', '2', '008.svg', '检测项目授权审核');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91010203', '检测项目授权查询', '/secure/basemodule/basedata/staff/staff-test-grants/page/search-list', '910102', '3', '008.svg', '检测项目授权查询');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('910103', '设备授权管理', '', '9101', '3', '008.svg', '设备授权管理');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91010301', '设备授权申请', '/secure/basemodule/basedata/staff/staff-equipt-grants/page/edit-list', '910103', '1', '008.svg', '设备授权申请');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91010302', '设备授权审核', '/secure/basemodule/basedata/staff/staff-equipt-grants/page/audit-list', '910103', '2', '008.svg', '设备授权审核');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91010303', '设备授权查询', '/secure/basemodule/basedata/staff/staff-equipt-grants/page/search-list', '910103', '3', '008.svg', '设备授权查询');
|
|
|
|
INSERT INTO T_CORE_ADMIN_CHOOSE_CONFIG (ID,NAME,TITLE,CATEGORY,URL,WIDTH) VALUES
|
|
(202209051514,'人员','人员','staffChoose','/secure/basemodule/basedata/staff/staffs/page/choose-list','80%');
|
|
INSERT INTO T_CORE_ADMIN_CHOOSE_CONFIG (ID,NAME,TITLE,CATEGORY,URL,WIDTH) VALUES
|
|
(2022082616372,'检测项目','检测项目','testChoose','/secure/basemodule/coredata/tests/page/choose-list','80%');
|