質問編集履歴
1
使用テーブルの概要追記
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -89,6 +89,58 @@
|
|
|
89
89
|
|
|
90
90
|
```
|
|
91
91
|
|
|
92
|
+
以下が使用テーブルの概要です
|
|
93
|
+
|
|
94
|
+
```SQL
|
|
95
|
+
CREATE TABLE EMPLOYEE_INFO(
|
|
96
|
+
ID INT AUTO_INCREMENT NOT NULL PRIMARY KEY COMMENT "ID",
|
|
97
|
+
NAME VARCHAR(10) NOT NULL COMMENT "名前",
|
|
98
|
+
AGE INT NOT NULL COMMENT "年齢",
|
|
99
|
+
BIRTH DATE NOT NULL COMMENT "生年月日",
|
|
100
|
+
GENDER INT NOT NULL COMMENT "性別"
|
|
101
|
+
|
|
102
|
+
|
|
103
|
+
);
|
|
104
|
+
|
|
105
|
+
CREATE TABLE EMPLOYEE_CAREER(
|
|
106
|
+
ID INT NOT NULL PRIMARY KEY,
|
|
107
|
+
STARTING_DATE DATE NOT NULL COMMENT "入社日",
|
|
108
|
+
DIVISION_ID INT NOT NULL COMMENT "所属部署",
|
|
109
|
+
RETIRERING_DATE DATE COMMENT "退社日",
|
|
110
|
+
BRANCH_ID INT NOT NULL COMMENT "所属支店"
|
|
111
|
+
);
|
|
112
|
+
|
|
113
|
+
CREATE TABLE DIVISION(
|
|
114
|
+
|
|
115
|
+
ID INT NOT NULL PRIMARY KEY,
|
|
116
|
+
DIVISION_NAME VARCHAR(10) NOT NULL COMMENT "部署"
|
|
117
|
+
|
|
118
|
+
);
|
|
119
|
+
|
|
120
|
+
CREATE TABLE BRANCH(
|
|
121
|
+
|
|
122
|
+
ID INT NOT NULL PRIMARY KEY,
|
|
123
|
+
BRANCH_NAME VARCHAR(10) NOT NULL COMMENT "支店"
|
|
124
|
+
|
|
125
|
+
);
|
|
126
|
+
|
|
127
|
+
CREATE TABLE EMPLOYEE_PASS(
|
|
128
|
+
ID INT NOT NULL PRIMARY KEY,
|
|
129
|
+
PASSWORD VARCHAR(30) NOT NULL COMMENT "パスワード");
|
|
130
|
+
|
|
131
|
+
INSERT INTO EMPLOYEE_INFO(
|
|
132
|
+
NAME, AGE, BIRTH, GENDER
|
|
133
|
+
)VALUES(
|
|
134
|
+
"MONA", 25, "1997-05-12", 2
|
|
135
|
+
)
|
|
136
|
+
|
|
137
|
+
INSERT INTO EMPLOYEE_CAREER(
|
|
138
|
+
ID, STARTING_DATE, DIVISION_ID, BRANCH_ID
|
|
139
|
+
)VALUES(
|
|
140
|
+
1, "2020-11-04", 1, 3
|
|
141
|
+
);
|
|
142
|
+
```
|
|
143
|
+
|
|
92
144
|
### 試したこと
|
|
93
145
|
|
|
94
146
|
・引数のidに数値がちゃんと入力されているかを確認。
|