service_token

24 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
prop_id int4 10 null
property.id fk_service_token_prop_id C
service_id int4 10 null
service.id fk_service_token_service_id C
token text 2147483647 √ null
token_expire date 13 √ null
active bool 1 √ true
create_time timestamptz 35,6 √ CURRENT_TIMESTAMP
jti uuid 2147483647 √ null
allowed_functions _text 2147483647 √ null
name text 2147483647 √ null
payload text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_service_token Primary key Asc id
idx_service_token_jti Performance Asc jti
idx_service_token_prop_id Performance Asc prop_id
idx_service_token_service_id Performance Asc service_id

Relationships

Close relationships within degrees of separation