質問編集履歴
2
テーブルを追記しました。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -362,13 +362,13 @@
|
|
|
362
362
|
|
|
363
363
|
+--------+----------+--------------------------------------------------------------+------------+-----------------+--------------------+--------+------------------+-------+-------+----------+-------------+--------------------------------------------------------------+---------------------+---------------------+
|
|
364
364
|
|
|
365
|
-
| number | id | password | name | email | image | gender | user_description |
|
|
365
|
+
| number | id | password | name | email | image | gender | user_description | reqruitment | entry | favorite | delete_flag | remember_token | created_at | updated_at |
|
|
366
366
|
|
|
367
367
|
+--------+----------+--------------------------------------------------------------+------------+-----------------+--------------------+--------+------------------+-------+-------+----------+-------------+--------------------------------------------------------------+---------------------+---------------------+
|
|
368
368
|
|
|
369
|
-
| 1 | hogetest | $2y$10$D5LFZBlp1McEYS2fNrDiVOXVM4xtOkvpWB.AkjI6BzG/ZM4NhbjLu | uooooooooo | test@test.com | defaultUserImg.jpg | NULL | ほげ | NULL | NULL | NULL | 1 | NULL | 2021-06-02 08:04:18 | 2021-06-02 08:04:18 |
|
|
370
|
-
|
|
371
|
-
| 2 | testhoge | $2y$10$snhNp4fl4Ax47HDF.uVZyuhgrwnCVc56XNF6HBURfAnpbOGowI8fm | test | test@test.co.jp | defaultUserImg.jpg | NULL | ほげほげ | NULL | NULL | NULL | 1 | 1eJnSmPSNrMLsFYx67QoEGafpVsgUh1NjPJcZfB6nYhyfeGmcSQiUtTR7Q0C | 2021-06-02 08:04:45 | 2021-06-02 08:04:45 |
|
|
369
|
+
| 1 | hogetest | $2y$10$D5LFZBlp1McEYS2fNrDiVOXVM4xtOkvpWB.AkjI6BzG/ZM4NhbjLu | uooooooooo | test@test.com | defaultUserImg.jpg | NULL | ほげ | NULL | NULL | NULL | 1 | NULL | 2021-06-02 08:04:18 | 2021-06-02 08:04:18 |
|
|
370
|
+
|
|
371
|
+
| 2 | testhoge | $2y$10$snhNp4fl4Ax47HDF.uVZyuhgrwnCVc56XNF6HBURfAnpbOGowI8fm | test | test@test.co.jp | defaultUserImg.jpg | NULL | ほげほげ | NULL | NULL | NULL | 1 | 1eJnSmPSNrMLsFYx67QoEGafpVsgUh1NjPJcZfB6nYhyfeGmcSQiUtTR7Q0C | 2021-06-02 08:04:45 | 2021-06-02 08:04:45 |
|
|
372
372
|
|
|
373
373
|
+--------+----------+--------------------------------------------------------------+------------+-----------------+--------------------+--------+------------------+-------+-------+----------+-------------+--------------------------------------------------------------+---------------------+---------------------
|
|
374
374
|
|
1
テーブルを追記しました。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -318,6 +318,64 @@
|
|
|
318
318
|
|
|
319
319
|
```
|
|
320
320
|
|
|
321
|
+
```table
|
|
322
|
+
|
|
323
|
+
+------------------+---------------+------+-----+---------+----------------+
|
|
324
|
+
|
|
325
|
+
| Field | Type | Null | Key | Default | Extra |
|
|
326
|
+
|
|
327
|
+
+------------------+---------------+------+-----+---------+----------------+
|
|
328
|
+
|
|
329
|
+
| number | int(11) | NO | PRI | NULL | auto_increment |
|
|
330
|
+
|
|
331
|
+
| id | varchar(16) | NO | | NULL | |
|
|
332
|
+
|
|
333
|
+
| password | varchar(255) | NO | | NULL | |
|
|
334
|
+
|
|
335
|
+
| name | varchar(12) | NO | | NULL | |
|
|
336
|
+
|
|
337
|
+
| email | varchar(255) | NO | | NULL | |
|
|
338
|
+
|
|
339
|
+
| image | varchar(255) | NO | | NULL | |
|
|
340
|
+
|
|
341
|
+
| gender | int(11) | YES | | NULL | |
|
|
342
|
+
|
|
343
|
+
| user_description | varchar(1000) | NO | | NULL | |
|
|
344
|
+
|
|
345
|
+
| reqruitment | int(11) | YES | | NULL | |
|
|
346
|
+
|
|
347
|
+
| entry | int(11) | YES | | NULL | |
|
|
348
|
+
|
|
349
|
+
| favorite | int(11) | YES | | NULL | |
|
|
350
|
+
|
|
351
|
+
| delete_flag | int(11) | NO | | 1 | |
|
|
352
|
+
|
|
353
|
+
| remember_token | varchar(100) | YES | | NULL | |
|
|
354
|
+
|
|
355
|
+
| created_at | timestamp | YES | | NULL | |
|
|
356
|
+
|
|
357
|
+
| updated_at | timestamp | YES | | NULL | |
|
|
358
|
+
|
|
359
|
+
+------------------+---------------+------+-----+---------+----------------+
|
|
360
|
+
|
|
361
|
+
|
|
362
|
+
|
|
363
|
+
+--------+----------+--------------------------------------------------------------+------------+-----------------+--------------------+--------+------------------+-------+-------+----------+-------------+--------------------------------------------------------------+---------------------+---------------------+
|
|
364
|
+
|
|
365
|
+
| number | id | password | name | email | image | gender | user_description | bosyu | entry | favorite | delete_flag | remember_token | created_at | updated_at |
|
|
366
|
+
|
|
367
|
+
+--------+----------+--------------------------------------------------------------+------------+-----------------+--------------------+--------+------------------+-------+-------+----------+-------------+--------------------------------------------------------------+---------------------+---------------------+
|
|
368
|
+
|
|
369
|
+
| 1 | hogetest | $2y$10$D5LFZBlp1McEYS2fNrDiVOXVM4xtOkvpWB.AkjI6BzG/ZM4NhbjLu | uooooooooo | test@test.com | defaultUserImg.jpg | NULL | ほげ | NULL | NULL | NULL | 1 | NULL | 2021-06-02 08:04:18 | 2021-06-02 08:04:18 |
|
|
370
|
+
|
|
371
|
+
| 2 | testhoge | $2y$10$snhNp4fl4Ax47HDF.uVZyuhgrwnCVc56XNF6HBURfAnpbOGowI8fm | test | test@test.co.jp | defaultUserImg.jpg | NULL | ほげほげ | NULL | NULL | NULL | 1 | 1eJnSmPSNrMLsFYx67QoEGafpVsgUh1NjPJcZfB6nYhyfeGmcSQiUtTR7Q0C | 2021-06-02 08:04:45 | 2021-06-02 08:04:45 |
|
|
372
|
+
|
|
373
|
+
+--------+----------+--------------------------------------------------------------+------------+-----------------+--------------------+--------+------------------+-------+-------+----------+-------------+--------------------------------------------------------------+---------------------+---------------------
|
|
374
|
+
|
|
375
|
+
```
|
|
376
|
+
|
|
377
|
+
|
|
378
|
+
|
|
321
379
|
|
|
322
380
|
|
|
323
381
|
### 試したこと
|