config.usr_activity_type

↑ config schema

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default
id PK	`integer`	No	nextval('config.usr_activity_type_id_seq'::regclass)
ewho	`text`	Yes
ewhat	`text`	Yes
ehow	`text`	Yes
label	`text`	No
egroup	`config.usr_activity_group`	No
enabled	`boolean`	No	true
transient	`boolean`	No	true

id PK

integer

nextval('config.usr_activity_type_id_seq'::regclass)

ewho

text

Yes

ewhat

text

Yes

ehow

text

Yes

label

text

egroup

config.usr_activity_group

enabled

boolean

true

transient

boolean

true

Primary Key

(id)

Check Constraints

one_of_wwh: CHECK COALESCE(ewho, ewhat, ehow) IS NOT NULL

Indexes

Index Method Definition

Index	Method	Definition
`usr_activity_type_pkey` PK	btree	`CREATE UNIQUE INDEX usr_activity_type_pkey ON config.usr_activity_type USING btree (id)`
`unique_wwh` UNIQUE	btree	`CREATE UNIQUE INDEX unique_wwh ON config.usr_activity_type USING btree (COALESCE(ewho, ''::text), COALESCE(ewhat, ''::text), COALESCE(ehow, ''::text))`

usr_activity_type_pkey PK

btree

CREATE UNIQUE INDEX usr_activity_type_pkey ON config.usr_activity_type USING btree (id)

unique_wwh UNIQUE

btree

CREATE UNIQUE INDEX unique_wwh ON config.usr_activity_type USING btree (COALESCE(ewho, ''::text), COALESCE(ewhat, ''::text), COALESCE(ehow, ''::text))

Referenced By

The following tables have foreign keys pointing to config.usr_activity_type (2 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

Table	Referencing Column(s)	Referenced Column(s)	Constraint
actor.usr_activity	`etype`	`id`	`usr_activity_etype_fkey`
config.remoteauth_profile	`usr_activity_type`	`id`	`remoteauth_profile_usr_activity_type_fkey`

actor.usr_activity

etype

id

usr_activity_etype_fkey

config.remoteauth_profile

usr_activity_type

id

remoteauth_profile_usr_activity_type_fkey