質問編集履歴
1
create分とデータの追加
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -171,3 +171,55 @@
|
|
|
171
171
|
|
|
172
172
|
|
|
173
173
|
```
|
|
174
|
+
|
|
175
|
+
|
|
176
|
+
|
|
177
|
+
追加
|
|
178
|
+
|
|
179
|
+
CREATE TABLE user_auth
|
|
180
|
+
|
|
181
|
+
(
|
|
182
|
+
|
|
183
|
+
user_id character varying(30) NOT NULL,
|
|
184
|
+
|
|
185
|
+
rireki_number integer NOT NULL DEFAULT 1,
|
|
186
|
+
|
|
187
|
+
CONSTRAINT pk_user_auth PRIMARY KEY (user_id, rireki_number)
|
|
188
|
+
|
|
189
|
+
)
|
|
190
|
+
|
|
191
|
+
|
|
192
|
+
|
|
193
|
+
CREATE TABLE user_name
|
|
194
|
+
|
|
195
|
+
(
|
|
196
|
+
|
|
197
|
+
user_id character varying(30) NOT NULL,
|
|
198
|
+
|
|
199
|
+
rireki_number integer NOT NULL DEFAULT 1,
|
|
200
|
+
|
|
201
|
+
user_name_kanji character varying(205),
|
|
202
|
+
|
|
203
|
+
user_name_kana character varying(205),
|
|
204
|
+
|
|
205
|
+
CONSTRAINT pk_user_name PRIMARY KEY (user_id, rireki_number)
|
|
206
|
+
|
|
207
|
+
)
|
|
208
|
+
|
|
209
|
+
|
|
210
|
+
|
|
211
|
+
|
|
212
|
+
|
|
213
|
+
〇USER_AUTH
|
|
214
|
+
|
|
215
|
+
INSERT INTO user_auth (user_id, rireki_number) VALUES ('TESTGY01', 1);
|
|
216
|
+
|
|
217
|
+
INSERT INTO user_auth (user_id, rireki_number) VALUES ('TESTGY02', 2);
|
|
218
|
+
|
|
219
|
+
|
|
220
|
+
|
|
221
|
+
〇USER_NAME
|
|
222
|
+
|
|
223
|
+
INSERT INTO user_name (user_id, rireki_number,user_name_kanji,user_name_kana) VALUES ('TESTGY01', 1,"業務宛名担当者（管理者）_old",ギョウムタントウシャ（カンリシャ）オールド);
|
|
224
|
+
|
|
225
|
+
INSERT INTO user_name (user_id, rireki_number,user_name_kanji,user_name_kana) VALUES ('TESTGY01', 2,"業務宛名担当者（管理者）",ギョウムタントウシャ（カンリシャ）);
|