-
Notifications
You must be signed in to change notification settings - Fork 0
/
CreateOracle.sql
184 lines (155 loc) · 4 KB
/
CreateOracle.sql
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
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
---
--- Table: AT010
---
CREATE TABLE AT010
( CDBUMON CHAR(5) DEFAULT '' NOT NULL,
TXBUMON NVARCHAR2(30) DEFAULT '' NOT NULL,
NRKANRISYA CHAR(5) DEFAULT '' NOT NULL,
TXTEKIYO NVARCHAR2(300) DEFAULT '',
UPDCOUNTER NUMBER(9,0) DEFAULT 0
) ;
---
--- Table: AT011
---
CREATE TABLE AT011
( CDBUMON CHAR(5) DEFAULT '' NOT NULL,
DTHAKKOUNENGETSU CHAR(6) DEFAULT '' NOT NULL,
CDJYOUIBUMON CHAR(5) DEFAULT '' NOT NULL,
DTSIKKOUNENGETSU CHAR(6) DEFAULT '' NOT NULL,
UPDCOUNTER NUMBER(9,0) DEFAULT 0
) ;
---
--- Table: AT020
---
CREATE TABLE AT020
( NRJYUGYOIN CHAR(5) DEFAULT '' NOT NULL,
TXKANA CHAR(30) DEFAULT '' NOT NULL,
TXKANJI NVARCHAR2(30) DEFAULT '' NOT NULL,
KBKOYOU CHAR(5) DEFAULT '' NOT NULL,
DTNYUSYA DATE NOT NULL,
DTTAISYA DATE,
UPDCOUNTER NUMBER(9,0) DEFAULT 0
) ;
---
--- Table: AT021
---
CREATE TABLE AT021
( NRJYUGYOIN CHAR(5) DEFAULT '' NOT NULL,
DTSYOZOKUNENGETSU CHAR(6) DEFAULT '' NOT NULL,
CDBUMON CHAR(5) DEFAULT '' NOT NULL,
UPDCOUNTER NUMBER(9,0) DEFAULT 0
) ;
---
--- Table: ZT010
---
CREATE TABLE ZT010
( IDVARIANT CHAR(20) DEFAULT '' NOT NULL,
TXNAME NVARCHAR2(10) DEFAULT '' NOT NULL,
TXTYPE CHAR(10) DEFAULT '' NOT NULL,
TXVALUE NVARCHAR2(100) DEFAULT '' NOT NULL,
TXREMARKS VARCHAR2(500) DEFAULT '',
UPDCOUNTER NUMBER(9,0) DEFAULT 0
) ;
---
--- Table: ZT020
---
CREATE TABLE ZT020
( IDUSER CHAR(5) DEFAULT '' NOT NULL,
TXMENUS CHAR(30) DEFAULT '' NOT NULL,
DTVALID DATE NOT NULL,
DTEXPIRE DATE NOT NULL,
TXNAME NVARCHAR2(30) DEFAULT '' NOT NULL,
NREMPLOYEE CHAR(5) DEFAULT '',
TXPASSWORD CHAR(32) DEFAULT '' NOT NULL,
TXEMAIL CHAR(40) DEFAULT '',
UPDCOUNTER NUMBER(9,0) DEFAULT 0
) ;
---
--- Table: ZT030
---
CREATE TABLE ZT030
( IDNUMBER CHAR(20) DEFAULT '' NOT NULL,
TXPREFIX CHAR(4) DEFAULT '',
NRNUMDIGIT NUMBER(2,0) DEFAULT 0.0 NOT NULL,
NRCURRENT NUMBER(9,0) DEFAULT 0 NOT NULL,
FGWITHCD CHAR(1) DEFAULT '' NOT NULL,
UPDCOUNTER NUMBER(9,0) DEFAULT 0
) ;
---
--- Table: ZT040
---
CREATE TABLE ZT040
( IDUSERKUBUN CHAR(20) DEFAULT '' NOT NULL,
KBUSERKUBUN CHAR(5) DEFAULT '' NOT NULL,
TXUSERKUBUN NVARCHAR2(20) DEFAULT '' NOT NULL,
SQLIST CHAR(2) DEFAULT '' NOT NULL,
UPDCOUNTER NUMBER(9,0) DEFAULT 0
) ;
---
--- Table: ZT050
---
CREATE TABLE ZT050
( NRSESSION CHAR(7) DEFAULT '' NOT NULL,
DTLOGIN TIMESTAMP (6) NOT NULL,
DTLOGOUT TIMESTAMP (6),
IDUSER CHAR(5) DEFAULT '' NOT NULL,
TXIPADDRESS CHAR(20) DEFAULT '' NOT NULL,
KBSESSIONSTATUS CHAR(3) DEFAULT '' NOT NULL,
VLVERSION CHAR(10) DEFAULT '' NOT NULL,
UPDCOUNTER NUMBER(9,0) DEFAULT 0
) ;
---
--- Table: ZT051
---
CREATE TABLE ZT051
( NRSESSION CHAR(7) DEFAULT '' NOT NULL,
SQPROGRAM NUMBER(4,0) DEFAULT 0 NOT NULL,
IDMENU CHAR(2) DEFAULT '' NOT NULL,
IDPROGRAM CHAR(10) DEFAULT '' NOT NULL,
TXPROGRAM NVARCHAR2(30) DEFAULT '' NOT NULL,
DTSTART TIMESTAMP (6) NOT NULL,
DTEND TIMESTAMP (6),
KBPROGRAMSTATUS CHAR(2) DEFAULT '',
TXERRORLOG NVARCHAR2(2000) DEFAULT '',
UPDCOUNTER NUMBER(9,0) DEFAULT 0
) ;
---
--- Table: ZT060
---
CREATE TABLE ZT060
( DTSTART DATE NOT NULL,
VLTAXRATE NUMBER(3,2) DEFAULT 0.0 NOT NULL,
UPDCOUNTER NUMBER(9,0) DEFAULT 0
) ;
---
--- Table: ZT070
---
CREATE TABLE ZT070
( KBCALENDAR CHAR(2) NOT NULL,
DTOFF DATE NOT NULL,
TXOFF NVARCHAR2(20),
UPDCOUNTER NUMBER(9,0) DEFAULT 0
) ;
---
--- Table: ZT080
---
CREATE TABLE ZT080
( KBCURRENCY CHAR(5) DEFAULT '' NOT NULL,
DTNEND NUMBER(4,0) DEFAULT 0 NOT NULL,
VLRATEB NUMBER(10,3) DEFAULT 0.0 NOT NULL,
VLRATEM NUMBER(10,3) DEFAULT 0.0 NOT NULL,
VLRATES NUMBER(10,3) DEFAULT 0.0 NOT NULL,
UPDCOUNTER NUMBER(9,0) DEFAULT 0
) ;
---
--- Table: ZT081
---
CREATE TABLE ZT081
( KBCURRENCY CHAR(5) DEFAULT '' NOT NULL,
DTNEND NUMBER(4,0) DEFAULT 0 NOT NULL,
DTMSEQ NUMBER(2,0) DEFAULT 0 NOT NULL,
VLRATEB NUMBER(10,3) DEFAULT 0.0 NOT NULL,
VLRATEM NUMBER(10,3) DEFAULT 0.0 NOT NULL,
VLRATES NUMBER(10,3) DEFAULT 0.0 NOT NULL,
UPDCOUNTER NUMBER(9,0) DEFAULT 0
) ;