art: 设备台账-查询需要做技术状态鉴定的设备列表

zhangherong

5 天以前 bcd90314646203b32f73c89c1c2f89eaa96e2c9f

 db/ZHR/create_table_zhr.sql

@@ -1,416 +1,1295 @@
-- HF编码维护
IF EXISTS (SELECT *
           FROM sys.objects
           FROM sys.all_objects
           WHERE object_id = OBJECT_ID(N'[dbo].[eam_base_hf_code]')
             AND type in (N'U'))
    DROP TABLE [dbo].[eam_base_hf_code];
             AND type IN ('U'))
    DROP TABLE [dbo].[eam_base_hf_code]
GO

CREATE TABLE [dbo].[eam_base_hf_code]
(
    id          NVARCHAR(32) NOT NULL,
    create_by   NVARCHAR(50),
    create_time DATETIME2,
    update_by   NVARCHAR(50),
    update_time DATETIME2,
    del_flag    INT,
    hf_code     NVARCHAR(100),
    hf_name     NVARCHAR(255),
    hf_category NVARCHAR(64),
    hf_status   NVARCHAR(64),
    hf_version  NVARCHAR(50),
    PRIMARY KEY (id)
);
    [id]          nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
    [create_by]   nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [create_time] datetime2(7)                            NULL,
    [update_by]   nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [update_time] datetime2(7)                            NULL,
    [del_flag]    int                                     NULL,
    [hf_code]     nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
    [hf_name]     nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [hf_category] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [hf_status]   nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [hf_version]  nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

EXEC sp_addextendedproperty 'MS_Description', '报表HFCode维护', 'SCHEMA', dbo, 'table', eam_base_hf_code, null, null;
EXEC sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', id;
EXEC sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', create_by;
EXEC sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column',
     create_time;
EXEC sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', update_by;
EXEC sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column',
     update_time;
EXEC sp_addextendedproperty 'MS_Description', '删除标记', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', del_flag;
EXEC sp_addextendedproperty 'MS_Description', 'HF编码', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', hf_code;
EXEC sp_addextendedproperty 'MS_Description', '模板名称', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', hf_name;
EXEC sp_addextendedproperty 'MS_Description', '模板分类', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column',
     hf_category;
EXEC sp_addextendedproperty 'MS_Description', '状态;启用、禁用', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column',
     hf_status;
EXEC sp_addextendedproperty 'MS_Description', '版本;V1，V2+', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column',
     hf_version;
ALTER TABLE [dbo].[eam_base_hf_code]
    SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
     'MS_Description', N'主键',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_base_hf_code',
     'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'创建人',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_base_hf_code',
     'COLUMN', N'create_by'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'创建时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_base_hf_code',
     'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'更新人',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_base_hf_code',
     'COLUMN', N'update_by'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'更新时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_base_hf_code',
     'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'删除标记',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_base_hf_code',
     'COLUMN', N'del_flag'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'HF编码',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_base_hf_code',
     'COLUMN', N'hf_code'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'模板名称',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_base_hf_code',
     'COLUMN', N'hf_name'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'模板分类',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_base_hf_code',
     'COLUMN', N'hf_category'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'状态;启用、禁用',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_base_hf_code',
     'COLUMN', N'hf_status'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'版本;V1，V2+',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_base_hf_code',
     'COLUMN', N'hf_version'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'报表HFCode维护',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_base_hf_code'
GO
ALTER TABLE [dbo].[eam_base_hf_code]
    ADD CONSTRAINT [PK__eam_base__3213E83F80327B31] PRIMARY KEY CLUSTERED ([id])
        WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
        ON [PRIMARY]
GO

--技术鉴定规范
IF EXISTS (SELECT *
           FROM sys.objects
           FROM sys.all_objects
           WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_evaluation_standard]')
             AND type in (N'U'))
    DROP TABLE [dbo].[eam_technical_status_evaluation_standard];
             AND type IN ('U'))
    DROP TABLE [dbo].[eam_technical_status_evaluation_standard]
GO

CREATE TABLE [dbo].[eam_technical_status_evaluation_standard]
(
    id                         NVARCHAR(32) NOT NULL,
    create_by                  NVARCHAR(50),
    create_time                DATETIME2,
    update_by                  NVARCHAR(50),
    update_time                DATETIME2,
    del_flag                   INT,
    standard_name              NVARCHAR(255),
    standard_code              NVARCHAR(50),
    evaluation_period          INT,
    equipment_id               NVARCHAR(32),
    standard_status            NVARCHAR(64),
    has_safety_equipment_check NVARCHAR(64),
    has_precision_check        NVARCHAR(64),
    has_other_check            NVARCHAR(64),
    standard_version           NVARCHAR(50),
    remark                     NVARCHAR(255),
    PRIMARY KEY (id)
);
    [id]                         nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
    [create_by]                  nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [create_time]                datetime2(7)                            NULL,
    [update_by]                  nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [update_time]                datetime2(7)                            NULL,
    [del_flag]                   int                                     NULL,
    [standard_name]              nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [standard_code]              nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [evaluation_period]          int                                     NULL,
    [equipment_id]               nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
    [standard_status]            nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [has_safety_equipment_check] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [has_precision_check]        nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [has_other_check]            nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [standard_version]           nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [remark]                     nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL
)
GO

EXEC sp_addextendedproperty 'MS_Description', '技术状态鉴定规范', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard, null, null;
EXEC sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_standard,
     'column', id;
EXEC sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard, 'column', create_by;
EXEC sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard, 'column', create_time;
EXEC sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard, 'column', update_by;
EXEC sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard, 'column', update_time;
EXEC sp_addextendedproperty 'MS_Description', '删除标记', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard, 'column', del_flag;
EXEC sp_addextendedproperty 'MS_Description', '规范名称', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard, 'column', standard_name;
EXEC sp_addextendedproperty 'MS_Description', '规范编码', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard, 'column', standard_code;
EXEC sp_addextendedproperty 'MS_Description', '鉴定周期', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard, 'column', evaluation_period;
EXEC sp_addextendedproperty 'MS_Description', '设备ID', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard, 'column', equipment_id;
EXEC sp_addextendedproperty 'MS_Description', '规范状态;待提交、启用、作废', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard, 'column', standard_status;
EXEC sp_addextendedproperty 'MS_Description', '是否有安全装置检查;是否', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard, 'column', has_safety_equipment_check;
EXEC sp_addextendedproperty 'MS_Description', '是否有设备精度检查;是否', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard, 'column', has_precision_check;
EXEC sp_addextendedproperty 'MS_Description', '是否有其他检查;是否', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard, 'column', has_other_check;
EXEC sp_addextendedproperty 'MS_Description', '版本;V1,V2+', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard, 'column', standard_version;
EXEC sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_standard,
     'column', remark;
ALTER TABLE [dbo].[eam_technical_status_evaluation_standard]
    SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
     'MS_Description', N'主键',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard',
     'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'创建人',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard',
     'COLUMN', N'create_by'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'创建时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard',
     'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'更新人',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard',
     'COLUMN', N'update_by'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'更新时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard',
     'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'删除标记',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard',
     'COLUMN', N'del_flag'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'规范名称',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard',
     'COLUMN', N'standard_name'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'规范编码',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard',
     'COLUMN', N'standard_code'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'鉴定周期',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard',
     'COLUMN', N'evaluation_period'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'设备ID',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard',
     'COLUMN', N'equipment_id'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'规范状态;待提交、启用、作废',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard',
     'COLUMN', N'standard_status'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'是否有安全装置检查;是否',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard',
     'COLUMN', N'has_safety_equipment_check'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'是否有设备精度检查;是否',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard',
     'COLUMN', N'has_precision_check'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'是否有其他检查;是否',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard',
     'COLUMN', N'has_other_check'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'版本;V1,V2+',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard',
     'COLUMN', N'standard_version'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'备注',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard',
     'COLUMN', N'remark'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'技术状态鉴定规范',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard'
GO
ALTER TABLE [dbo].[eam_technical_status_evaluation_standard]
    ADD CONSTRAINT [PK__eam_tech__3213E83FB7E202C0] PRIMARY KEY CLUSTERED ([id])
        WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
        ON [PRIMARY]
GO
--技术状态鉴定规范明细
IF EXISTS (SELECT *
           FROM sys.objects
           FROM sys.all_objects
           WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_evaluation_standard_detail]')
             AND type in (N'U'))
    DROP TABLE [dbo].[eam_technical_status_evaluation_standard_detail];
             AND type IN ('U'))
    DROP TABLE [dbo].[eam_technical_status_evaluation_standard_detail]
GO

CREATE TABLE [dbo].[eam_technical_status_evaluation_standard_detail]
(
    id              NVARCHAR(32) NOT NULL,
    create_by       NVARCHAR(50),
    create_time     DATETIME2,
    update_by       NVARCHAR(50),
    update_time     DATETIME2,
    standard_id     NVARCHAR(32),
    check_category  NVARCHAR(64),
    item_code       INT,
    item_name       NVARCHAR(255),
    tolerance_value NVARCHAR(100),
    sub_item_name   NVARCHAR(255),
    PRIMARY KEY (id)
);
    [id]              nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
    [create_by]       nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [create_time]     datetime2(7)                            NULL,
    [update_by]       nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [update_time]     datetime2(7)                            NULL,
    [standard_id]     nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
    [check_category]  nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [item_code]       int                                     NULL,
    [item_name]       nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [tolerance_value] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
    [sub_item_name]   nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL
)
GO

EXEC sp_addextendedproperty 'MS_Description', '技术状态鉴定规范明细', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard_detail, null, null;
EXEC sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard_detail, 'column', id;
EXEC sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard_detail, 'column', create_by;
EXEC sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard_detail, 'column', create_time;
EXEC sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard_detail, 'column', update_by;
EXEC sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard_detail, 'column', update_time;
EXEC sp_addextendedproperty 'MS_Description', '规范ID', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard_detail, 'column', standard_id;
EXEC sp_addextendedproperty 'MS_Description', '检查分类;精度检查、安全装置检查、其他检查', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard_detail, 'column', check_category;
EXEC sp_addextendedproperty 'MS_Description', '项目序号', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard_detail, 'column', item_code;
EXEC sp_addextendedproperty 'MS_Description', '检查项目', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard_detail, 'column', item_name;
EXEC sp_addextendedproperty 'MS_Description', '允差值;精度检查展示', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard_detail, 'column', tolerance_value;
EXEC sp_addextendedproperty 'MS_Description', '检查子项目;精度检查展示，可以为空', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_standard_detail, 'column', sub_item_name;
ALTER TABLE [dbo].[eam_technical_status_evaluation_standard_detail]
    SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
     'MS_Description', N'主键',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard_detail',
     'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'创建人',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard_detail',
     'COLUMN', N'create_by'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'创建时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard_detail',
     'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'更新人',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard_detail',
     'COLUMN', N'update_by'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'更新时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard_detail',
     'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'规范ID',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard_detail',
     'COLUMN', N'standard_id'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'检查分类;精度检查、安全装置检查、其他检查',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard_detail',
     'COLUMN', N'check_category'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'项目序号',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard_detail',
     'COLUMN', N'item_code'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'检查项目',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard_detail',
     'COLUMN', N'item_name'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'允差值;精度检查展示',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard_detail',
     'COLUMN', N'tolerance_value'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'检查子项目;精度检查展示，可以为空',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard_detail',
     'COLUMN', N'sub_item_name'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'技术状态鉴定规范明细',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_standard_detail'
GO

ALTER TABLE [dbo].[eam_technical_status_evaluation_standard_detail]
    ADD CONSTRAINT [PK__eam_tech__3213E83F6C420333] PRIMARY KEY CLUSTERED ([id])
        WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
        ON [PRIMARY]
GO

--技术状态鉴定工单
IF EXISTS (SELECT *
           FROM sys.objects
           FROM sys.all_objects
           WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_evaluation_order]')
             AND type in (N'U'))
    DROP TABLE [dbo].[eam_technical_status_evaluation_order];
             AND type IN ('U'))
    DROP TABLE [dbo].[eam_technical_status_evaluation_order]
GO

CREATE TABLE [dbo].[eam_technical_status_evaluation_order]
(
    id                                NVARCHAR(32) NOT NULL,
    create_by                         NVARCHAR(50),
    create_time                       DATETIME2,
    update_by                         NVARCHAR(50),
    update_time                       DATETIME2,
    del_flag                          INT,
    order_num                         NVARCHAR(50),
    equipment_id                      NVARCHAR(32),
    standard_id                       NVARCHAR(32),
    evaluation_date                   DATETIME2,
    freeze_order_date                 DATETIME2,
    order_expiration_date             DATETIME2,
    actual_start_time                 DATETIME2,
    actual_end_time                   DATETIME2,
    evaluator                         NVARCHAR(50),
    evaluation_status                 NVARCHAR(64),
    creation_method                   NVARCHAR(64),
    safety_equipment_check_result     NVARCHAR(64),
    precision_check_result            NVARCHAR(64),
    functional_check_result           NVARCHAR(64),
    other_check_result                NVARCHAR(64),
    repair_manager_signature          NVARCHAR(50),
    repair_manager_signature_time_1   DATETIME2,
    sample_check_result               NVARCHAR(64),
    process_technician_signature      NVARCHAR(50),
    process_technician_signature_time DATETIME2,
    evaluation_result                 NVARCHAR(64),
    evaluation_reason                 NVARCHAR(64),
    inspector_signature               NVARCHAR(50),
    inspector_signature_time          DATETIME2,
    hf_code_a                         NVARCHAR(100),
    hf_code_b                         NVARCHAR(100),
    hf_code_c                         NVARCHAR(100),
    hf_code_d                         NVARCHAR(100),
    remark                            NVARCHAR(255),
    PRIMARY KEY (id)
);
    [id]                                       nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
    [create_by]                                nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [create_time]                              datetime2(7)                            NULL,
    [update_by]                                nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [update_time]                              datetime2(7)                            NULL,
    [del_flag]                                 int                                     NULL,
    [order_num]                                nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [equipment_id]                             nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
    [standard_id]                              nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
    [evaluation_date]                          datetime2(7)                            NULL,
    [freeze_order_date]                        datetime2(7)                            NULL,
    [order_expiration_date]                    datetime2(7)                            NULL,
    [actual_start_time]                        datetime2(7)                            NULL,
    [actual_end_time]                          datetime2(7)                            NULL,
    [evaluator]                                nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [evaluation_status]                        nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [creation_method]                          nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [safety_check_completed]                   nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [precision_check_completed]                nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [other_check_completed]                    nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [safety_check_confirm]                     nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [safety_check_confirm_time]                datetime2(7)                            NULL,
    [safety_check_result]                      nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [safety_check_comment]                     nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [precision_check_confirm]                  nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [precision_check_confirm_time]             datetime2(7)                            NULL,
    [precision_check_confirm_result]           nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [precision_check_confirm_comment]          nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [other_check_confirm]                      nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [other_check_confirm_time]                 datetime2(7)                            NULL,
    [other_check_confirm_result]               nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [other_check_confirm_comment]              nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [safety_equipment_check_result]            nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [precision_check_result]                   nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [functional_check_result]                  nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [other_check_result]                       nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [repairer_signature]                       nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [repairer_signature_time]                  datetime2(7)                            NULL,
    [repair_manager_signature]                 nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [repair_manager_signature_time]            datetime2(7)                            NULL,
    [repair_manager_signature_result]          nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [repair_manager_comment]                   nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [sample_check_result]                      nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [process_technician_signature]             nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [process_technician_signature_time]        datetime2(7)                            NULL,
    [process_technician_comment]               nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [depart_technical_leader_signature]        nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [depart_technical_leader_signature_time]   nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [depart_technical_leader_signature_result] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [depart_technical_leader_comment]          nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [evaluation_result]                        nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [evaluation_reason]                        nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [inspector_signature]                      nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [inspector_signature_time]                 datetime2(7)                            NULL,
    [inspector_comment]                        nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [hf_code_a]                                nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
    [hf_code_b]                                nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
    [hf_code_c]                                nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
    [hf_code_d]                                nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
    [remark]                                   nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    CONSTRAINT [PK__eam_tech__3213E83F3B4971F7] PRIMARY KEY CLUSTERED ([id])
        WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
        ON [PRIMARY]
)
    ON [PRIMARY]
GO

EXEC sp_addextendedproperty 'MS_Description', '技术状态鉴定工单', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order, null, null;
EXEC sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
     'column', id;
EXEC sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
     'column', create_by;
EXEC sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
     'column', create_time;
EXEC sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
     'column', update_by;
EXEC sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
     'column', update_time;
EXEC sp_addextendedproperty 'MS_Description', '删除标记', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
     'column', del_flag;
EXEC sp_addextendedproperty 'MS_Description', '工单号', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
     'column', order_num;
EXEC sp_addextendedproperty 'MS_Description', '设备ID', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
     'column', equipment_id;
EXEC sp_addextendedproperty 'MS_Description', '规范ID', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
     'column', standard_id;
EXEC sp_addextendedproperty 'MS_Description', '计划鉴定日期;提前70天生成工单', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order, 'column', evaluation_date;
EXEC sp_addextendedproperty 'MS_Description', '锁定工单日期;提前55天锁定工单', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order, 'column', freeze_order_date;
EXEC sp_addextendedproperty 'MS_Description', '工单过期日期;到期未做直接过期，并修改设备技术状态为禁用', 'SCHEMA', dbo,
     'table', eam_technical_status_evaluation_order, 'column', order_expiration_date;
EXEC sp_addextendedproperty 'MS_Description', '实际开始时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order, 'column', actual_start_time;
EXEC sp_addextendedproperty 'MS_Description', '实际结束时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order, 'column', actual_end_time;
EXEC sp_addextendedproperty 'MS_Description', '鉴定人', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
     'column', evaluator;
EXEC sp_addextendedproperty 'MS_Description',
     '鉴定状态;待鉴定、鉴定中、维修室主任签字、工艺人员签字、技术主管签字、设备检验员签字、已完成、已锁定、变更中、已过期',
     'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order, 'column', evaluation_status;
EXEC sp_addextendedproperty 'MS_Description', '创建方式', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
     'column', creation_method;
EXEC sp_addextendedproperty 'MS_Description', '安全装置检查结果;是、否', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order, 'column', safety_equipment_check_result;
EXEC sp_addextendedproperty 'MS_Description', '精度参数检查结果;是、否、无', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order, 'column', precision_check_result;
EXEC sp_addextendedproperty 'MS_Description', '功能状态检查结果;是、否', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order, 'column', functional_check_result;
EXEC sp_addextendedproperty 'MS_Description', '其他检查结果;是、否、无', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order, 'column', other_check_result;
EXEC sp_addextendedproperty 'MS_Description', '维修室主任签字', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order, 'column', repair_manager_signature;
EXEC sp_addextendedproperty 'MS_Description', '维修室主任签字时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order, 'column', repair_manager_signature_time_1;
EXEC sp_addextendedproperty 'MS_Description', '试件检查结果;合格、不合格', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order, 'column', sample_check_result;
EXEC sp_addextendedproperty 'MS_Description', '工艺员签字', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order, 'column', process_technician_signature;
EXEC sp_addextendedproperty 'MS_Description', '工艺员签字时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order, 'column', process_technician_signature_time;
EXEC sp_addextendedproperty 'MS_Description', '鉴定结果;合格、限用、禁用', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order, 'column', evaluation_result;
EXEC sp_addextendedproperty 'MS_Description', '限\禁用原因(多选);安全装置、设备功能、精度、试件、其他', 'SCHEMA', dbo,
     'table', eam_technical_status_evaluation_order, 'column', evaluation_reason;
EXEC sp_addextendedproperty 'MS_Description', '设备检查人签字', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order, 'column', inspector_signature;
EXEC sp_addextendedproperty 'MS_Description', '设备检查人签字时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order, 'column', inspector_signature_time;
EXEC sp_addextendedproperty 'MS_Description', '附录A HF编码', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order, 'column', hf_code_a;
EXEC sp_addextendedproperty 'MS_Description', '附录B HF编码', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order, 'column', hf_code_b;
EXEC sp_addextendedproperty 'MS_Description', '附录C HF编码', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order, 'column', hf_code_c;
EXEC sp_addextendedproperty 'MS_Description', '附录D HF编码', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order, 'column', hf_code_d;
EXEC sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
     'column', remark;
ALTER TABLE [dbo].[eam_technical_status_evaluation_order]
    SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
     'MS_Description', N'主键',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'创建人',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'create_by'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'创建时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'更新人',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'update_by'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'更新时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'删除标记',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'del_flag'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'工单号',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'order_num'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'设备ID',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'equipment_id'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'规范ID',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'standard_id'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'计划鉴定日期;提前70天生成工单',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'evaluation_date'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'锁定工单日期;提前55天锁定工单',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'freeze_order_date'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'工单过期日期;到期未做直接过期，并修改设备技术状态为禁用',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'order_expiration_date'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'实际开始时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'actual_start_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'实际结束时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'actual_end_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'鉴定人',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'evaluator'
GO

EXEC sp_addextendedproperty
     'MS_Description',
     N'鉴定状态;待鉴定、鉴定中、维修室主任签字、工艺人员签字、使用单位技术主管签字、设备检验员签字、已完成、已锁定、变更中、已过期',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'evaluation_status'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'创建方式',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'creation_method'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'安全装置检查是否完成;是否',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'safety_check_completed'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'设备精度检查是否完成;是否',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'precision_check_completed'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'其他检查是否完成;是否',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'other_check_completed'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'安全装置检查确认人',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'safety_check_confirm'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'安全装置检查确认时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'safety_check_confirm_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'安全装置检查确认结果',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'safety_check_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'安全装置检查确认意见',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'safety_check_comment'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'设备精度检查确认人',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'precision_check_confirm'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'设备精度检查确认时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'precision_check_confirm_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'设备精度检查确认结果',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'precision_check_confirm_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'设备精度检查确认意见',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'precision_check_confirm_comment'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'其他检查确认人',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'other_check_confirm'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'其他检查确认时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'other_check_confirm_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'其他检查确认结果',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'other_check_confirm_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'其他检查确认意见',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'other_check_confirm_comment'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'安全装置检查结果;是、否',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'safety_equipment_check_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'精度参数检查结果;是、否、无',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'precision_check_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'功能状态检查结果;是、否',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'functional_check_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'其他检查结果;是、否、无',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'other_check_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'维修人签字',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'repairer_signature'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'维修人签字时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'repairer_signature_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'维修室主任签字',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'repair_manager_signature'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'维修室主任签字时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'repair_manager_signature_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'维修室主任签字结果',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'repair_manager_signature_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'维修室主任意见',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'repair_manager_comment'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'试件检查结果;合格、不合格',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'sample_check_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'工艺员签字',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'process_technician_signature'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'工艺员签字时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'process_technician_signature_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'工艺员意见',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'process_technician_comment'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'使用单位技术主管签字',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'depart_technical_leader_signature'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'使用单位技术主管签字时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'depart_technical_leader_signature_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'使用单位技术主管签字结果',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'depart_technical_leader_signature_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'使用单位技术主管意见',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'depart_technical_leader_comment'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'鉴定结果;合格、限用、禁用',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'evaluation_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'限/禁用原因(多选);安全装置、设备功能、精度、试件、其他',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'evaluation_reason'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'设备检查人签字',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'inspector_signature'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'设备检查人签字时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'inspector_signature_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'设备检查人意见',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'inspector_comment'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'附录A HF编码',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'hf_code_a'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'附录B HF编码',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'hf_code_b'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'附录C HF编码',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'hf_code_c'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'附录D HF编码',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'hf_code_d'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'备注',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order',
     'COLUMN', N'remark'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'技术状态鉴定工单',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order'

--技术状态鉴定工单明细
IF EXISTS (SELECT *
           FROM sys.objects
           FROM sys.all_objects
           WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_evaluation_order_detail]')
             AND type in (N'U'))
    DROP TABLE [dbo].[eam_technical_status_evaluation_order_detail];
             AND type IN ('U'))
    DROP TABLE [dbo].[eam_technical_status_evaluation_order_detail]
GO

CREATE TABLE [dbo].[eam_technical_status_evaluation_order_detail]
(
    id                            NVARCHAR(32) NOT NULL,
    create_by                     NVARCHAR(50),
    create_time                   DATETIME2,
    update_by                     NVARCHAR(50),
    update_time                   DATETIME2,
    item_code                     INT,
    check_category                NVARCHAR(64),
    item_name                     NVARCHAR(255),
    tolerance_value               NVARCHAR(100),
    sub_item_name                 NVARCHAR(255),
    safety_equipment_check_result NVARCHAR(64),
    other_check_result            NVARCHAR(255),
    precision_check_result        NUMERIC(24, 4),
    repairman_signature           NVARCHAR(50),
    repairman_signature_time      DATETIME2,
    PRIMARY KEY (id)
);
    [id]                            nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
    [create_by]                     nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [create_time]                   datetime2(7)                            NULL,
    [update_by]                     nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [update_time]                   datetime2(7)                            NULL,
    [order_id]                      nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
    [item_code]                     int                                     NULL,
    [check_category]                nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [item_name]                     nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [tolerance_value]               nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
    [sub_item_name]                 nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [safety_equipment_check_result] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [other_check_result]            nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [precision_check_result]        numeric(24, 4)                          NULL,
    [repairman_signature]           nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [repairman_signature_time]      datetime2(7)                            NULL,
    CONSTRAINT [PK__eam_tech__3213E83F680090BC] PRIMARY KEY CLUSTERED ([id])
        WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
        ON [PRIMARY]
)
    ON [PRIMARY]
GO

EXEC sp_addextendedproperty 'MS_Description', '技术状态鉴定工单明细', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_detail, null, null;
EXEC sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_detail, 'column', id;
EXEC sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_detail, 'column', create_by;
EXEC sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_detail, 'column', create_time;
EXEC sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_detail, 'column', update_by;
EXEC sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_detail, 'column', update_time;
EXEC sp_addextendedproperty 'MS_Description', '序号', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_detail, 'column', item_code;
EXEC sp_addextendedproperty 'MS_Description', '检查分类;精度检查、安全装置检查、其他检查', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_detail, 'column', check_category;
EXEC sp_addextendedproperty 'MS_Description', '检查项目', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_detail, 'column', item_name;
EXEC sp_addextendedproperty 'MS_Description', '允差值;精度检查展示', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_detail, 'column', tolerance_value;
EXEC sp_addextendedproperty 'MS_Description', '检查子项目;精度检查展示，可以为空', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_detail, 'column', sub_item_name;
EXEC sp_addextendedproperty 'MS_Description', '安全装置检查结果;是、否、无', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_detail, 'column', safety_equipment_check_result;
EXEC sp_addextendedproperty 'MS_Description', '其他检查结果', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_detail, 'column', other_check_result;
EXEC sp_addextendedproperty 'MS_Description', '精度检验结果', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_detail, 'column', precision_check_result;
EXEC sp_addextendedproperty 'MS_Description', '维修人/精度检查者签字', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_detail, 'column', repairman_signature;
EXEC sp_addextendedproperty 'MS_Description', '维修人/精度检查者签字时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_detail, 'column', repairman_signature_time;
ALTER TABLE [dbo].[eam_technical_status_evaluation_order_detail]
    SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
     'MS_Description', N'主键',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_detail',
     'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'创建人',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_detail',
     'COLUMN', N'create_by'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'创建时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_detail',
     'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'更新人',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_detail',
     'COLUMN', N'update_by'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'更新时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_detail',
     'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'工单ID',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_detail',
     'COLUMN', N'order_id'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'序号',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_detail',
     'COLUMN', N'item_code'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'检查分类;精度检查、安全装置检查、其他检查',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_detail',
     'COLUMN', N'check_category'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'检查项目',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_detail',
     'COLUMN', N'item_name'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'允差值;精度检查展示',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_detail',
     'COLUMN', N'tolerance_value'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'检查子项目;精度检查展示，可以为空',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_detail',
     'COLUMN', N'sub_item_name'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'安全装置检查结果;是、否、无',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_detail',
     'COLUMN', N'safety_equipment_check_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'其他检查结果',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_detail',
     'COLUMN', N'other_check_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'精度检验结果',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_detail',
     'COLUMN', N'precision_check_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'维修人/精度检查者签字',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_detail',
     'COLUMN', N'repairman_signature'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'维修人/精度检查者签字时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_detail',
     'COLUMN', N'repairman_signature_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'技术状态鉴定工单明细',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_detail'


--技术状态鉴定工单变更
IF EXISTS (SELECT *
           FROM sys.objects
           WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_evaluation_order_change]')
             AND type in (N'U'))
    DROP TABLE [dbo].[eam_technical_status_evaluation_order_change];
CREATE TABLE [dbo].[eam_technical_status_evaluation_order_change]
(
    id                                NVARCHAR(32) NOT NULL,
    create_by                         NVARCHAR(50),
    create_time                       DATETIME2,
    update_by                         NVARCHAR(50),
    update_time                       DATETIME2,
    del_flag                          INT,
    order_id                          NVARCHAR(32),
    change_order_num                  NVARCHAR(100),
    applicant                         NVARCHAR(50),
    factory_org_code                  NVARCHAR(100),
    apply_date                        DATETIME2,
    change_status                     NVARCHAR(64),
    apply_reason                      NVARCHAR(64),
    deferred_maintenance_date         DATETIME2,
    equipment_manager_signature       NVARCHAR(50),
    equipment_manager_signature_time  DATETIME2,
    depart_manager_signature          NVARCHAR(50),
    depart_manager_signature_time     DATETIME2,
    depart_manager_comment            NVARCHAR(255),
    production_support_signature      NVARCHAR(50),
    production_support_signature_time DATETIME2,
    production_support_comment        NVARCHAR(255),
    hf_code                           NVARCHAR(100),
    PRIMARY KEY (id)
);
    [id]                                  nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
    [create_by]                           nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [create_time]                         datetime2(7)                            NULL,
    [update_by]                           nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [update_time]                         datetime2(7)                            NULL,
    [del_flag]                            int                                     NULL,
    [order_id]                            nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
    [equipment_id]                        nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
    [change_order_num]                    nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
    [applicant]                           nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [factory_org_code]                    nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
    [apply_date]                          datetime2(7)                            NULL,
    [change_status]                       nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [apply_reason]                        nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [deferred_evaluation_date]            datetime2(7)                            NULL,
    [equipment_manager_signature]         nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [equipment_manager_signature_time]    datetime2(7)                            NULL,
    [equipment_manager_signature_result]  nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [equipment_manager_comment]           nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [depart_manager_signature]            nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [depart_manager_signature_time]       datetime2(7)                            NULL,
    [depart_manager_signature_result]     nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [depart_manager_comment]              nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [production_support_signature]        nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [production_support_signature_time]   datetime2(7)                            NULL,
    [production_support_signature_result] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [production_support_comment]          nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [hf_code]                             nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
    CONSTRAINT [PK__eam_tech__3213E83FFE6D6178] PRIMARY KEY CLUSTERED ([id])
        WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
        ON [PRIMARY]
)
    ON [PRIMARY]
GO

EXEC sp_addextendedproperty 'MS_Description', '技术状态鉴定工单变更', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, null, null;
EXEC sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', id;
EXEC sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', create_by;
EXEC sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', create_time;
EXEC sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', update_by;
EXEC sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', update_time;
EXEC sp_addextendedproperty 'MS_Description', '删除标记', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', del_flag;
EXEC sp_addextendedproperty 'MS_Description', '工单ID', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', order_id;
EXEC sp_addextendedproperty 'MS_Description', '变更单号', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', change_order_num;
EXEC sp_addextendedproperty 'MS_Description', '申请人', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', applicant;
EXEC sp_addextendedproperty 'MS_Description', '申请部门', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', factory_org_code;
EXEC sp_addextendedproperty 'MS_Description', '申请日期', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', apply_date;
EXEC sp_addextendedproperty 'MS_Description', '变更状态;待提交、待主管审核、待部门确认、待保障部确认、已作废、已完成',
     'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order_change, 'column', change_status;
EXEC sp_addextendedproperty 'MS_Description',
     '变更原因;生产任务急无法停机、设备故障正处于维修状态、设备已报废、设备大修、搬迁、改造', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', apply_reason;
EXEC sp_addextendedproperty 'MS_Description', '变更鉴定日期', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', deferred_maintenance_date;
EXEC sp_addextendedproperty 'MS_Description', '主管领导签字', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', equipment_manager_signature;
EXEC sp_addextendedproperty 'MS_Description', '主管领导签字时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', equipment_manager_signature_time;
EXEC sp_addextendedproperty 'MS_Description', '部门领导签字;根据变更原因类型区分不同的人审批', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', depart_manager_signature;
EXEC sp_addextendedproperty 'MS_Description', '部门领导签字时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', depart_manager_signature_time;
EXEC sp_addextendedproperty 'MS_Description', '部门领导意见', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', depart_manager_comment;
EXEC sp_addextendedproperty 'MS_Description', '生产保障部领导签字', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', production_support_signature;
EXEC sp_addextendedproperty 'MS_Description', '生产保障部领导签字时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', production_support_signature_time;
EXEC sp_addextendedproperty 'MS_Description', '生产保障部领导意见', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', production_support_comment;
EXEC sp_addextendedproperty 'MS_Description', 'HF编码', 'SCHEMA', dbo, 'table',
     eam_technical_status_evaluation_order_change, 'column', hf_code;
ALTER TABLE [dbo].[eam_technical_status_evaluation_order_change]
    SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
     'MS_Description', N'主键',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'创建人',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'create_by'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'创建时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'更新人',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'update_by'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'更新时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'删除标记',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'del_flag'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'工单ID',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'order_id'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'设备ID',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'equipment_id'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'变更单号',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'change_order_num'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'申请人',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'applicant'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'申请部门',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'factory_org_code'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'申请日期',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'apply_date'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'变更状态;待提交、待主管审核、待部门确认、待保障部确认、已作废、已完成',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'change_status'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'变更原因;生产任务急无法停机、设备故障正处于维修状态、设备已报废、设备大修、搬迁、改造',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'apply_reason'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'变更鉴定日期',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'deferred_evaluation_date'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'主管领导签字',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'equipment_manager_signature'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'主管领导签字时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'equipment_manager_signature_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'主管领导签字结果',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'equipment_manager_signature_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'主管领导意见',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'equipment_manager_comment'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'部门领导签字;根据变更原因类型区分不同的人审批',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'depart_manager_signature'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'部门领导签字时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'depart_manager_signature_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'部门领导签字结果',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'depart_manager_signature_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'部门领导意见',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'depart_manager_comment'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'生产保障部领导签字',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'production_support_signature'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'生产保障部领导签字时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'production_support_signature_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'生产保障部领导签字结果',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'production_support_signature_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'生产保障部领导意见',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'production_support_comment'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'HF编码',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change',
     'COLUMN', N'hf_code'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'技术状态鉴定工单变更',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_evaluation_order_change'

--技术状态变更申请
IF EXISTS (SELECT *
@@ -420,61 +1299,189 @@
    DROP TABLE [dbo].[eam_technical_status_change];
CREATE TABLE [dbo].[eam_technical_status_change]
(
    id                              NVARCHAR(32) NOT NULL,
    create_by                       NVARCHAR(50),
    create_time                     DATETIME2,
    update_by                       NVARCHAR(50),
    update_time                     DATETIME2,
    del_flag                        INT,
    change_order_num                NVARCHAR(100),
    change_status                   NVARCHAR(64),
    designer                        NVARCHAR(50),
    designer_time                   DATETIME2,
    depart_header_signature         NVARCHAR(50),
    depart_header_signature_time    DATETIME2,
    depart_header_signature_comment NVARCHAR(255),
    depart_leader_signature         NVARCHAR(50),
    depart_leader_signature_time    DATETIME2,
    depart_leader_signature_comment NVARCHAR(255),
    hf_code                         NVARCHAR(100),
    PRIMARY KEY (id)
);
    [id]                             nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
    [create_by]                      nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [create_time]                    datetime2(7)                            NULL,
    [update_by]                      nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [update_time]                    datetime2(7)                            NULL,
    [del_flag]                       int                                     NULL,
    [change_order_num]               nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
    [change_status]                  nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [factory_org_code]               nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
    [designer]                       nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [designer_time]                  datetime2(7)                            NULL,
    [depart_header_signature]        nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [depart_header_signature_time]   datetime2(7)                            NULL,
    [depart_header_signature_result] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [depart_header_comment]          nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [depart_leader_signature]        nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
    [depart_leader_signature_time]   datetime2(7)                            NULL,
    [depart_leader_signature_result] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
    [depart_leader_comment]          nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    [hf_code]                        nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
    [remark]                         nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
    CONSTRAINT [PK__eam_tech__3213E83F5B1204F4] PRIMARY KEY CLUSTERED ([id])
        WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
        ON [PRIMARY]
)
    ON [PRIMARY]
GO

EXEC sp_addextendedproperty 'MS_Description', '技术状态变更申请', 'SCHEMA', dbo, 'table', eam_technical_status_change,
     null, null;
EXEC sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', id;
EXEC sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
     create_by;
EXEC sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
     create_time;
EXEC sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
     update_by;
EXEC sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
     update_time;
EXEC sp_addextendedproperty 'MS_Description', '删除标记', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
     del_flag;
EXEC sp_addextendedproperty 'MS_Description', '变更单号', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
     change_order_num;
EXEC sp_addextendedproperty 'MS_Description', '变更单状态', 'SCHEMA', dbo, 'table', eam_technical_status_change,
     'column', change_status;
EXEC sp_addextendedproperty 'MS_Description', '编制人', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
     designer;
EXEC sp_addextendedproperty 'MS_Description', '编制时间', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
     designer_time;
EXEC sp_addextendedproperty 'MS_Description', '使用单位室主管签字', 'SCHEMA', dbo, 'table', eam_technical_status_change,
     'column', depart_header_signature;
EXEC sp_addextendedproperty 'MS_Description', '使用单位室主管签字时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_change, 'column', depart_header_signature_time;
EXEC sp_addextendedproperty 'MS_Description', '使用单位室主管意见', 'SCHEMA', dbo, 'table', eam_technical_status_change,
     'column', depart_header_signature_comment;
EXEC sp_addextendedproperty 'MS_Description', '使用单位部主管签字', 'SCHEMA', dbo, 'table', eam_technical_status_change,
     'column', depart_leader_signature;
EXEC sp_addextendedproperty 'MS_Description', '使用单位部主管签字时间', 'SCHEMA', dbo, 'table',
     eam_technical_status_change, 'column', depart_leader_signature_time;
EXEC sp_addextendedproperty 'MS_Description', '使用单位部主管签字', 'SCHEMA', dbo, 'table', eam_technical_status_change,
     'column', depart_leader_signature_comment;
EXEC sp_addextendedproperty 'MS_Description', 'HF编码', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
     hf_code;
ALTER TABLE [dbo].[eam_technical_status_change]
    SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
     'MS_Description', N'主键',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'创建人',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'create_by'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'创建时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'更新人',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'update_by'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'更新时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'删除标记',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'del_flag'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'变更单号',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'change_order_num'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'变更单状态',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'change_status'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'申请单位',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'factory_org_code'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'编制人',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'designer'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'编制时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'designer_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'使用单位室级主管签字',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'depart_header_signature'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'使用单位室级主管签字时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'depart_header_signature_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'使用单位室级主管签字结果',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'depart_header_signature_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'使用单位室级主管意见',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'depart_header_comment'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'使用单位部级主管签字',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'depart_leader_signature'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'使用单位部级主管签字时间',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'depart_leader_signature_time'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'使用单位部级主管签字结果',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'depart_leader_signature_result'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'使用单位部级主管签字',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'depart_leader_comment'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'HF编码',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'hf_code'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'备注',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change',
     'COLUMN', N'remark'
GO

EXEC sp_addextendedproperty
     'MS_Description', N'技术状态变更申请',
     'SCHEMA', N'dbo',
     'TABLE', N'eam_technical_status_change'


--技术状态变更申请明细