/*
 Navicat Premium Dump SQL

 Source Server         : localhost-sqlserver
 Source Server Type    : SQL Server
 Source Server Version : 11003000 (11.00.3000)
 Source Host           : localhost:1433
 Source Catalog        : LXZN_TEST_430_NEW
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 11003000 (11.00.3000)
 File Encoding         : 65001

 Date: 11/07/2025 10:50:26
*/


-- ----------------------------
-- Table structure for eam_inspection_order
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[eam_inspection_order]') AND type IN ('U'))
	DROP TABLE [dbo].[eam_inspection_order]
GO

CREATE TABLE [dbo].[eam_inspection_order] (
  [id] nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT 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,
  [inspection_date] datetime2(7)  NULL,
  [operate_time] datetime2(7)  NULL,
  [operator] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [expiration_time] datetime2(7)  NULL,
  [creation_method] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [inspection_status] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [confirm_user] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [confirm_deal_type] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [confirm_comment] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [confirm_time] datetime2(7)  NULL,
  [remark] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [del_flag] int  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,
  [hf_code] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[eam_inspection_order] SET (LOCK_ESCALATION = TABLE)
GO

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

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

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

EXEC sp_addextendedproperty
'MS_Description', N'标准ID',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'standard_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'点检日期',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'inspection_date'
GO

EXEC sp_addextendedproperty
'MS_Description', N'点检时间',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'operate_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'点检人',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'operator'
GO

EXEC sp_addextendedproperty
'MS_Description', N'点检过期时间',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'expiration_time'
GO

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

EXEC sp_addextendedproperty
'MS_Description', N'点检状态',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'inspection_status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'维修工确认人',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'confirm_user'
GO

EXEC sp_addextendedproperty
'MS_Description', N'确认类型',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'confirm_deal_type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'确认意见',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'confirm_comment'
GO

EXEC sp_addextendedproperty
'MS_Description', N'确认时间',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order',
'COLUMN', N'confirm_time'
GO

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

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

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

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

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

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

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

EXEC sp_addextendedproperty
'MS_Description', N'点检工单',
'SCHEMA', N'dbo',
'TABLE', N'eam_inspection_order'
GO


-- ----------------------------
-- Primary Key structure for table eam_inspection_order
-- ----------------------------
ALTER TABLE [dbo].[eam_inspection_order] ADD CONSTRAINT [PK__eam_insp__3213E83F513910DD] 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

