app_chat_messages

0 rows

Description

Stores all the actual chat messages

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

bigserial

19

√

nextval('app_chat_messages_id_seq'::regclass)

chatid

int8

19

0

Defined in XMLR

userid

int8

19

0

groupid

int8

19

0

system

int2

5

0

message

text

2147483647

null

timestamp

int8

19

0

Showing 1 to 7 of 7 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
app_chatmess_id_pk	Primary key	Asc	id
app_chatmess_cha_ix	Performance	Asc	chatid
app_chatmess_gro_ix	Performance	Asc	groupid
app_chatmess_timcha_ix	Performance	Asc/Asc	timestamp + chatid
app_chatmess_use_ix	Performance	Asc	userid

Showing 1 to 5 of 5 entries

Relationships

Close relationships within degrees of separation

One
Two degrees