質問編集履歴
1
create分とデータの追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -84,4 +84,30 @@
|
|
|
84
84
|
)
|
|
85
85
|
AND UA.USER_ID = 'TESTGY01'
|
|
86
86
|
|
|
87
|
-
```
|
|
87
|
+
```
|
|
88
|
+
|
|
89
|
+
追加
|
|
90
|
+
CREATE TABLE user_auth
|
|
91
|
+
(
|
|
92
|
+
user_id character varying(30) NOT NULL,
|
|
93
|
+
rireki_number integer NOT NULL DEFAULT 1,
|
|
94
|
+
CONSTRAINT pk_user_auth PRIMARY KEY (user_id, rireki_number)
|
|
95
|
+
)
|
|
96
|
+
|
|
97
|
+
CREATE TABLE user_name
|
|
98
|
+
(
|
|
99
|
+
user_id character varying(30) NOT NULL,
|
|
100
|
+
rireki_number integer NOT NULL DEFAULT 1,
|
|
101
|
+
user_name_kanji character varying(205),
|
|
102
|
+
user_name_kana character varying(205),
|
|
103
|
+
CONSTRAINT pk_user_name PRIMARY KEY (user_id, rireki_number)
|
|
104
|
+
)
|
|
105
|
+
|
|
106
|
+
|
|
107
|
+
〇USER_AUTH
|
|
108
|
+
INSERT INTO user_auth (user_id, rireki_number) VALUES ('TESTGY01', 1);
|
|
109
|
+
INSERT INTO user_auth (user_id, rireki_number) VALUES ('TESTGY02', 2);
|
|
110
|
+
|
|
111
|
+
〇USER_NAME
|
|
112
|
+
INSERT INTO user_name (user_id, rireki_number,user_name_kanji,user_name_kana) VALUES ('TESTGY01', 1,"業務宛名担当者（管理者）_old",ギョウムタントウシャ（カンリシャ）オールド);
|
|
113
|
+
INSERT INTO user_name (user_id, rireki_number,user_name_kanji,user_name_kana) VALUES ('TESTGY01', 2,"業務宛名担当者（管理者）",ギョウムタントウシャ（カンリシャ）);
|