usr_message

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('actor.usr_message_id_seq'::regclass)
usr_standing_penalty.usr_message usr_standing_penalty_usr_message_fkey R
usr int4 10 null
usr.id usr_message_usr_fkey R
title text 2147483647 √ null
message text 2147483647 null
create_date timestamptz 35,6 now()
deleted bool 1 false
read_date timestamptz 35,6 √ null
sending_lib int4 10 null
org_unit.id usr_message_sending_lib_fkey R
pub bool 1 false
stop_date timestamptz 35,6 √ null
editor int8 19 √ null
usr.id usr_message_editor_fkey R
edit_date timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
usr_message_pkey Primary key Asc id
aum_editor Performance Asc editor
aum_usr Performance Asc usr

Relationships

Close relationships within degrees of separation