art: 数据库脚本、流程整理

zhangherong

5 天以前 a2380956b02019058445c71a8707efbf4b3d5e10

 db/ZHR/create_table_zhr.sql

@@ -1049,89 +1049,247 @@


--技术状态鉴定工单变更
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 *
@@ -1141,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'


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