By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version() |
---|
8.0.27 |
id | status_from | status_to | logtime | refno |
---|---|---|---|---|
1 | N | A | 2021-06-01 00:00:00 | LP01 |
2 | A | D | 2021-10-01 00:00:00 | LP01 |
3 | D | Y | 2021-10-02 00:00:00 | LP01 |
4 | A | N | 2021-10-06 00:00:00 | LP06 |
id | status | added_date | updated_date | refno | logstat | stat20211001 |
---|---|---|---|---|---|---|
3 | Y | 2021-05-02 00:00:00 | 2021-10-02 00:00:00 | LP01 | A | A |
4 | A | 2021-05-01 00:00:00 | 2021-05-01 00:00:00 | LP02 | null | A |
5 | S | 2020-10-01 00:00:00 | 2020-10-01 00:00:00 | LP03 | null | S |
6 | N | 2021-05-01 00:00:00 | 2021-10-06 00:00:00 | LP06 | A | A |
11 | D | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | LP04 | null | D |
text | c |
---|---|
Draft | 2 |
Action | 2 |
Publish | 0 |
Sold | 1 |
Let | 0 |