usr_standing_penalty

98 rows


Description

User standing penalties

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('actor.usr_message_id_seq'::regclass)
org_unit int4 10 null
org_unit.id usr_standing_penalty_org_unit_fkey C
usr int4 10 null
usr.id usr_standing_penalty_usr_fkey C
standing_penalty int4 10 null
standing_penalty.id usr_standing_penalty_standing_penalty_fkey C
staff int4 10 √ null
usr.id usr_standing_penalty_staff_fkey N
set_date timestamptz 35,6 √ now()
stop_date timestamptz 35,6 √ null
usr_message int8 19 √ null
usr_message.id usr_standing_penalty_usr_message_fkey R

Indexes

Constraint Name Type Sort Column(s)
usr_standing_penalty_pkey Primary key Asc id
actor_usr_standing_penalty_staff_idx Performance Asc staff
actor_usr_standing_penalty_usr_idx Performance Asc usr
usr_standing_penalty_usr_message_idx Performance Asc usr_message

Relationships

Close relationships within degrees of separation