R
R
Rocket-API
Search…
oracle
1
CREATE TABLE "API_EXAMPLE" (
2
"ID" VARCHAR2(45 BYTE),
3
"API_INFO_ID" VARCHAR2(45 BYTE),
4
"METHOD" VARCHAR2(45 BYTE),
5
"URL" CLOB,
6
"REQUEST_HEADER" CLOB,
7
"REQUEST_BODY" CLOB,
8
"RESPONSE_HEADER" CLOB,
9
"RESPONSE_BODY" CLOB,
10
"STATUS" VARCHAR2(10 BYTE),
11
"OPTIONS" CLOB,
12
"EDITOR" VARCHAR2(45 BYTE),
13
"CREATE_TIME" VARCHAR2(45 BYTE),
14
"ELAPSED_TIME" NUMBER
15
)
16
17
CREATE TABLE "API_INFO" (
18
"ID" VARCHAR2(45 BYTE),
19
"METHOD" VARCHAR2(45 BYTE),
20
"PATH" VARCHAR2(100 BYTE),
21
"TYPE" VARCHAR2(5 BYTE),
22
"SERVICE" VARCHAR2(45 BYTE),
23
"GROUP_NAME" VARCHAR2(45 BYTE),
24
"EDITOR" VARCHAR2(45 BYTE),
25
"NAME" VARCHAR2(200 BYTE),
26
"DATASOURCE" VARCHAR2(45 BYTE),
27
"SCRIPT" CLOB,
28
"OPTIONS" CLOB,
29
"CREATE_TIME" VARCHAR2(45 BYTE),
30
"UPDATE_TIME" VARCHAR2(45 BYTE)
31
)
32
33
CREATE TABLE "API_INFO_HISTORY"
34
( "ID" VARCHAR2(45),
35
"API_INFO_ID" VARCHAR2(45),
36
"METHOD" VARCHAR2(45),
37
"PATH" VARCHAR2(100),
38
"TYPE" VARCHAR2(5),
39
"SERVICE" VARCHAR2(45),
40
"GROUP_NAME" VARCHAR2(45),
41
"EDITOR" VARCHAR2(45),
42
"NAME" VARCHAR2(200),
43
"DATASOURCE" VARCHAR2(45),
44
"SCRIPT" CLOB,
45
"OPTIONS" CLOB,
46
"CREATE_TIME" VARCHAR2(45)
47
)
48
49
//在开启了spring.rocket-api.config-enabled=true才需要此表
50
CREATE TABLE "API_CONFIG" (
51
"ID" VARCHAR2(45),
52
"SERVICE" VARCHAR2(45),
53
"CONFIG_CONTEXT" CLOB
54
)
55
56
57
CREATE TABLE "API_DIRECTORY" (
58
"ID" VARCHAR2(45),
59
"SERVICE" VARCHAR2(45),
60
"NAME" VARCHAR2(45),
61
"PATH" VARCHAR2(200),
62
"PARENT_ID" VARCHAR2(45)
63
)
Copied!
Last modified 7mo ago
Copy link