table_defs

text/plain

Download

                                            Table "z8z6px927zu6qzzbnb5ntgghxg.access_grants"
      Column       |            Type             |                                       Modifiers                                       
-------------------+-----------------------------+---------------------------------------------------------------------------------------
 id                | bigint                      | not null default nextval('z8z6px927zu6qzzbnb5ntgghxg.access_grants_id_seq'::regclass)
 client_id         | bigint                      | not null
 entity_name       | character varying(40)       | not null
 entity_id         | bigint                      | not null
 originally_issued | timestamp without time zone | not null default timezone('UTC'::text, now())
 last_issued       | timestamp without time zone | not null default timezone('UTC'::text, now())
Indexes:
    "access_grants_pkey" PRIMARY KEY, btree (id)
    "access_grants_client_id_entity_name_entity_id_key" UNIQUE CONSTRAINT, btree (client_id, entity_name, entity_id)
    "access_grants_client_id_idx" btree (client_id)
Foreign-key constraints:
    "access_grants_client_id_fkey" FOREIGN KEY (client_id) REFERENCES z8z6px927zu6qzzbnb5ntgghxg.oauth_clients(id) ON DELETE CASCADE
Referenced by:
    TABLE "z8z6px927zu6qzzbnb5ntgghxg.access_tokens" CONSTRAINT "access_tokens_access_id_fkey" FOREIGN KEY (access_id) REFERENCES z8z6px927zu6qzzbnb5ntgghxg.access_grants(id) ON DELETE CASCADE
    TABLE "z8z6px927zu6qzzbnb5ntgghxg.authorization_codes" CONSTRAINT "authorization_codes_access_id_fkey" FOREIGN KEY (access_id) REFERENCES z8z6px927zu6qzzbnb5ntgghxg.access_grants(id) ON DELETE CASCADE
    TABLE "z8z6px927zu6qzzbnb5ntgghxg.refresh_tokens" CONSTRAINT "refresh_tokens_access_id_fkey" FOREIGN KEY (access_id) REFERENCES z8z6px927zu6qzzbnb5ntgghxg.access_grants(id) ON DELETE CASCADE

                                   Table "z8z6px927zu6qzzbnb5ntgghxg.oauth_clients"
    Column     |     Type      |                                       Modifiers                                       
---------------+---------------+---------------------------------------------------------------------------------------
 id            | bigint        | not null default nextval('z8z6px927zu6qzzbnb5ntgghxg.oauth_clients_id_seq'::regclass)
 client_id     | character(32) | not null
 client_secret | character(32) | not null
 description   | text          | not null
Indexes:
    "oauth_clients_pkey" PRIMARY KEY, btree (id)
    "oauth_clients_client_id_key" UNIQUE CONSTRAINT, btree (client_id)
    "oauth_clients_client_secret_key" UNIQUE CONSTRAINT, btree (client_secret)
Referenced by:
    TABLE "z8z6px927zu6qzzbnb5ntgghxg.access_grants" CONSTRAINT "access_grants_client_id_fkey" FOREIGN KEY (client_id) REFERENCES z8z6px927zu6qzzbnb5ntgghxg.oauth_clients(id) ON DELETE CASCADE
    TABLE "z8z6px927zu6qzzbnb5ntgghxg.access_schemas" CONSTRAINT "access_schemas_client_id_fkey" FOREIGN KEY (client_id) REFERENCES z8z6px927zu6qzzbnb5ntgghxg.oauth_clients(id) ON DELETE CASCADE
    TABLE "z8z6px927zu6qzzbnb5ntgghxg.client_features" CONSTRAINT "client_features_client_id_fkey" FOREIGN KEY (client_id) REFERENCES z8z6px927zu6qzzbnb5ntgghxg.oauth_clients(id) ON DELETE CASCADE
    TABLE "z8z6px927zu6qzzbnb5ntgghxg.client_settings" CONSTRAINT "client_settings_client_id_fkey" FOREIGN KEY (client_id) REFERENCES z8z6px927zu6qzzbnb5ntgghxg.oauth_clients(id) ON DELETE CASCADE
    TABLE "z8z6px927zu6qzzbnb5ntgghxg.client_whitelists" CONSTRAINT "client_whitelists_client_id_fkey" FOREIGN KEY (client_id) REFERENCES z8z6px927zu6qzzbnb5ntgghxg.oauth_clients(id) ON DELETE CASCADE
    TABLE "z8z6px927zu6qzzbnb5ntgghxg.creation_tokens" CONSTRAINT "creation_tokens_client_id_fkey" FOREIGN KEY (client_id) REFERENCES z8z6px927zu6qzzbnb5ntgghxg.oauth_clients(id) ON DELETE CASCADE
    TABLE "z8z6px927zu6qzzbnb5ntgghxg.expired_secrets" CONSTRAINT "expired_secrets_client_id_fkey" FOREIGN KEY (client_id) REFERENCES z8z6px927zu6qzzbnb5ntgghxg.oauth_clients(id) ON DELETE CASCADE
    TABLE "z8z6px927zu6qzzbnb5ntgghxg.verification_codes" CONSTRAINT "verification_codes_client_id_fkey" FOREIGN KEY (client_id) REFERENCES z8z6px927zu6qzzbnb5ntgghxg.oauth_clients(id) ON DELETE CASCADE