-
Notifications
You must be signed in to change notification settings - Fork 1.5k
Description
sub2api=# SELECT
sub2api-# k.id,
sub2api-# k.name,
sub2api-# k.status,
sub2api-# k.user_id,
sub2api-# u.email,
sub2api-# u.deleted_at AS user_deleted_at,
sub2api-# k.deleted_at AS key_deleted_at
sub2api-# FROM api_keys k
sub2api-# LEFT JOIN users u ON u.id = k.user_id
sub2api-# WHERE k.deleted_at IS NULL
sub2api-# ORDER BY k.id;
id | name | status | user_id | email | user_deleted_at | key_deleted_at
----+---------+--------+---------+-------------------------+-------------------------------+----------------
1 | codex | active | 1 | 11@gmail.com | |
3 | api | active | 2 | 22@gmail.com | 2026-03-25 23:39:20.196802+08 |
6 | 羊 | active | 1 | 11@gmail.com | |
9 | do | active | 1 | 11@gmail.com | |
(4 rows)