-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathTD_API_DATABASE_TRACE.sql
More file actions
84 lines (83 loc) · 2.57 KB
/
Copy pathTD_API_DATABASE_TRACE.sql
File metadata and controls
84 lines (83 loc) · 2.57 KB
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
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
CREATE TABLE [dbo].[TD_API_DATABASE_TRACE](
[DBT_ID] [int] IDENTITY(1,1) NOT NULL,
[DBT_CORRELATION_ID] varchar(256) NULL,
[DBT_PROCEDURE_NAME] VARCHAR(1024) NULL,
[DBT_PARAMS] VARCHAR(MAX) NULL,
[DBT_START_TIME] datetime,
[DBT_DURATION] decimal(10,3) NULL,
[DBT_ACTION] varchar(2048) NULL,
[DBT_SUCCESS] bit,
PRIMARY KEY CLUSTERED ([DBT_ID] ASC)
)
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
@value = N'PRIMARY KEY',
@level0type = N'SCHEMA',
@level0name = N'dbo',
@level1type = N'TABLE',
@level1name = N'TD_API_DATABASE_TRACE',
@level2type = N'COLUMN',
@level2name = N'DBT_ID'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
@value = N'request correlation id',
@level0type = N'SCHEMA',
@level0name = N'dbo',
@level1type = N'TABLE',
@level1name = N'TD_API_DATABASE_TRACE',
@level2type = N'COLUMN',
@level2name = N'DBT_CORRELATION_ID'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
@value = N'name of the stored procedure',
@level0type = N'SCHEMA',
@level0name = N'dbo',
@level1type = N'TABLE',
@level1name = N'TD_API_DATABASE_TRACE',
@level2type = N'COLUMN',
@level2name = N'DBT_PROCEDURE_NAME'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
@value = N'input parameters',
@level0type = N'SCHEMA',
@level0name = N'dbo',
@level1type = N'TABLE',
@level1name = N'TD_API_DATABASE_TRACE',
@level2type = N'COLUMN',
@level2name = N'DBT_PARAMS'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
@value = N'start time of operation',
@level0type = N'SCHEMA',
@level0name = N'dbo',
@level1type = N'TABLE',
@level1name = N'TD_API_DATABASE_TRACE',
@level2type = N'COLUMN',
@level2name = N'DBT_START_TIME'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
@value = N'duration',
@level0type = N'SCHEMA',
@level0name = N'dbo',
@level1type = N'TABLE',
@level1name = N'TD_API_DATABASE_TRACE',
@level2type = N'COLUMN',
@level2name = N'DBT_DURATION'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
@value = N'what type of event ',
@level0type = N'SCHEMA',
@level0name = N'dbo',
@level1type = N'TABLE',
@level1name = N'TD_API_DATABASE_TRACE',
@level2type = N'COLUMN',
@level2name = N'DBT_ACTION'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
@value = N'action successful',
@level0type = N'SCHEMA',
@level0name = N'dbo',
@level1type = N'TABLE',
@level1name = N'TD_API_DATABASE_TRACE',
@level2type = N'COLUMN',
@level2name = N'DBT_SUCCESS'