entities


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
entities.parent_id entities_fk_2 C
entity_entity_grants.recipient_id entity_entity_grants_fk_1 C
entity_entity_grants.target_id entity_entity_grants_fk_2 C
entity_user_grants.entities_id entity_user_grants_fk_1 C
scim_external_id_groups.entities_id scim_external_id_groups_fk_1 R
scim_external_id_users.entities_id scim_external_id_users_fk_1 R
client_id varchar 191 null
external_identifiers.id Implied Constraint R
client_secret varchar 255 null
data text 2147483647 √ null
entity_types_id uuid 2147483647 null
entity_types.id entities_fk_1 C
insert_instant int8 19 null
last_update_instant int8 19 null
name varchar 255 null
parent_id uuid 2147483647 √ null
entities.id entities_fk_2 C
tenants_id uuid 2147483647 null
tenants.id entities_fk_3 C

Indexes

Constraint Name Type Sort Column(s)
entities_pkey Primary key Asc id
entities_uk_1 Must be unique Asc client_id

Relationships

Close relationships within degrees of separation