app_messages

0 rows


Description

Stores all messages

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_messages_id_seq'::regclass)
app_message_user_actions.messageid Defined in XML R
useridfrom int8 19 null
app_user.id Defined in XML R
conversationid int8 19 null
app_message_conversations.id Defined in XML R
subject text 2147483647 null
fullmessage text 2147483647 null
fullmessageformat int2 5 0
fullmessagehtml text 2147483647 null
smallmessage text 2147483647 null
timecreated int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_mess_id2_pk Primary key Asc id
app_mess_con_ix Performance Asc conversationid
app_mess_contim_ix Performance Asc/Asc conversationid + timecreated
app_mess_use_ix Performance Asc useridfrom

Relationships