#

18516761980

2022-07-22 b743b62c7d57c84d16422841b0b51e85fe53a891

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
USE [klsasrs]
GO
 
/****** Object:  Table [dbo].[sap_request_log]    Script Date: 2021/6/25 11:01:40 ******/
SET ANSI_NULLS ON
GO
 
SET QUOTED_IDENTIFIER ON
GO
 
SET ANSI_PADDING ON
GO
 
CREATE TABLE [dbo].[sap_request_log](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [matnr] [varchar](250) NULL,
    [request] [varchar](max) NULL,
    [response] [varchar](max) NULL,
    [create_time] [datetime] NULL,
    [remark] [varchar](max) NULL,
    [type] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
 
GO
 
SET ANSI_PADDING OFF
GO
 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sap_request_log', @level2type=N'COLUMN',@level2name=N'matnr'
GO
 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'请求入参' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sap_request_log', @level2type=N'COLUMN',@level2name=N'request'
GO
 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'请求回参' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sap_request_log', @level2type=N'COLUMN',@level2name=N'response'
GO
 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sap_request_log', @level2type=N'COLUMN',@level2name=N'create_time'
GO
 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类型 (1.请求成功,2.请求失败)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sap_request_log', @level2type=N'COLUMN',@level2name=N'type'
GO