質問編集履歴
1
CREATE TABLEをキャプチャーからコードに修正しました。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -222,7 +222,49 @@
|
|
|
222
222
|
|
|
223
223
|
### 対象テーブル
|
|
224
224
|
|
|
225
|
+
```ここに言語を入力
|
|
226
|
+
|
|
227
|
+
CREATE TABLE "STUDYUSER"."TODO_LIST_USER"
|
|
228
|
+
|
|
229
|
+
( "ID" VARCHAR2(20 BYTE) NOT NULL ENABLE,
|
|
230
|
+
|
|
231
|
+
"NAME" VARCHAR2(20 BYTE),
|
|
232
|
+
|
|
233
|
+
"MAILADDRESS" VARCHAR2(20 BYTE),
|
|
234
|
+
|
|
235
|
+
"MAILADDRESSVERIFIED" NUMBER(*,0),
|
|
236
|
+
|
|
237
|
+
"PASSWORD" VARCHAR2(1000 BYTE),
|
|
238
|
+
|
|
239
|
+
"ENABLED" NUMBER(*,0),
|
|
240
|
+
|
|
241
|
+
CONSTRAINT "TODO_LIST_USER_PK" PRIMARY KEY ("ID")
|
|
242
|
+
|
|
243
|
+
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
|
|
244
|
+
|
|
245
|
+
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
|
|
246
|
+
|
|
247
|
+
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
|
|
248
|
+
|
|
249
|
+
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
|
|
250
|
+
|
|
251
|
+
TABLESPACE "USERS" ENABLE
|
|
252
|
+
|
|
253
|
+
) SEGMENT CREATION IMMEDIATE
|
|
254
|
+
|
|
225
|
-
|
|
255
|
+
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
|
|
256
|
+
|
|
257
|
+
NOCOMPRESS LOGGING
|
|
258
|
+
|
|
259
|
+
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
|
|
260
|
+
|
|
261
|
+
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
|
|
262
|
+
|
|
263
|
+
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
|
|
264
|
+
|
|
265
|
+
TABLESPACE "USERS" ;
|
|
266
|
+
|
|
267
|
+
```
|
|
226
268
|
|
|
227
269
|
### sequence
|
|
228
270
|
|