-- Fetch all the Users belonging to the Okta account
-- of a particular user.
SELECT *
FROM fiber.okta_user
WHERE account_id = '{user.okta_id}'
-- Fetch all the Users belonging to the Okta account
-- of a particular user.
SELECT *
FROM fiber.okta_user
WHERE account_id = '{user.okta_id}'
Code
CREATE TABLE fiber.okta_user (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
id TEXT,
status TEXT,
created TEXT,
activated TEXT,
status_changed TEXT,
last_login TEXT,
last_updated TEXT,
password_changed TEXT,
profile JSONB,
credentials JSONB
)
CREATE TABLE fiber.okta_user (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
id TEXT,
status TEXT,
created TEXT,
activated TEXT,
status_changed TEXT,
last_login TEXT,
last_updated TEXT,
password_changed TEXT,
profile JSONB,
credentials JSONB
)
Model definition
