By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id | user_id | verify_date | verify_type | verify_state | work_code |
---|---|---|---|---|---|
1 | 14 | 2019-11-13 07:46:00 | 1 | 0 | 0 |
2 | 14 | 2019-11-12 14:49:00 | 1 | 0 | 0 |
3 | 14 | 2019-11-12 14:05:00 | 1 | 0 | 0 |
4 | 14 | 2019-11-12 13:39:00 | 1 | 0 | 0 |
5 | 14 | 2019-11-12 07:38:00 | 1 | 0 | 0 |
6 | 14 | 2019-11-11 20:05:00 | 1 | 1 | 0 |
7 | 14 | 2019-11-11 19:57:00 | 1 | 1 | 0 |
8 | 14 | 2019-11-11 16:09:00 | 1 | 0 | 0 |
9 | 14 | 2019-11-11 14:13:00 | 1 | 0 | 0 |
10 | 14 | 2019-11-11 13:30:00 | 1 | 0 | 0 |
11 | 14 | 2019-11-11 09:26:00 | 1 | 0 | 0 |
12 | 14 | 2019-11-11 07:20:00 | 1 | 0 | 0 |
13 | 14 | 2019-11-11 07:20:00 | 1 | 1 | 0 |
14 | 14 | 2019-11-08 17:38:00 | 1 | 1 | 0 |
15 | 14 | 2019-11-08 07:18:00 | 1 | 0 | 0 |
16 | 14 | 2019-11-07 20:09:00 | 1 | 1 | 0 |
17 | 14 | 2019-11-07 07:25:00 | 1 | 0 | 0 |
18 | 14 | 2019-11-07 07:25:00 | 1 | 0 | 0 |
19 | 14 | 2019-11-06 19:32:00 | 1 | 0 | 0 |
20 | 14 | 2019-11-06 07:23:00 | 1 | 0 | 0 |
21 | 14 | 2019-11-05 20:00:00 | 1 | 1 | 0 |
22 | 14 | 2019-11-05 07:23:00 | 1 | 0 | 0 |
23 | 15 | 2019-11-12 20:05:00 | 1 | 0 | 0 |
24 | 15 | 2019-11-12 19:57:00 | 1 | 0 | 0 |
25 | 15 | 2019-11-12 20:09:00 | 1 | 1 | 0 |
26 | 15 | 2019-11-12 20:13:00 | 1 | 1 | 0 |
27 | 15 | 2019-11-12 20:30:00 | 1 | 0 | 0 |
28 | 15 | 2019-11-13 06:26:00 | 1 | 0 | 0 |
29 | 15 | 2019-11-13 07:20:00 | 1 | 0 | 0 |
30 | 15 | 2019-11-13 07:20:00 | 1 | 1 | 0 |
id | user_id | verify_date | verify_type | verify_state | work_code | prev_state | next_state | next_date |
---|---|---|---|---|---|---|---|---|
22 | 14 | 2019-11-05 07:23:00 | 1 | 0 | 0 | 1 | 1 | 2019-11-05 20:00:00 |
20 | 14 | 2019-11-06 07:23:00 | 1 | 0 | 0 | 1 | 0 | 2019-11-07 20:09:00 |
15 | 14 | 2019-11-08 07:18:00 | 1 | 0 | 0 | 1 | 1 | 2019-11-08 17:38:00 |
12 | 14 | 2019-11-11 07:20:00 | 1 | 0 | 0 | 1 | 1 | 2019-11-11 07:20:00 |
11 | 14 | 2019-11-11 09:26:00 | 1 | 0 | 0 | 1 | 0 | 2019-11-12 07:38:00 |
24 | 15 | 2019-11-12 19:57:00 | 1 | 0 | 0 | 1 | 0 | 2019-11-12 20:30:00 |
27 | 15 | 2019-11-12 20:30:00 | 1 | 0 | 0 | 1 | 0 | 2019-11-13 07:20:00 |