By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version() |
---|
8.0.26 |
refno | logtime | status_from | status_to |
---|---|---|---|
LP01 | 2021-10-02 00:00:00 | Draft | Publish |
LP01 | 2021-06-01 00:00:00 | Let | Action |
LP01 | 2021-10-01 00:00:00 | Action | Draft |
LP06 | 2021-10-06 00:00:00 | Action | Let |
status_l | c |
---|---|
Publish | 1 |
Action | 1 |
Sold | 1 |
Let | 1 |
Draft | 2 |
id | status_from | status_to | logtime | refno |
---|---|---|---|---|
1 | Let | Action | 2021-06-01 00:00:00 | LP01 |
2 | Action | Draft | 2021-10-01 00:00:00 | LP01 |
3 | Draft | Publish | 2021-10-02 00:00:00 | LP01 |
4 | Action | Let | 2021-10-06 00:00:00 | LP06 |
status_logs | to_add |
---|---|
Publish | -1 |
Let | -1 |
Draft | 1 |
Action | 1 |
status | counts_at_2021_10_01 |
---|---|
Publish | 0 |
Action | 2 |
Sold | 1 |
Let | 0 |
Draft | 3 |