bus_presence

-1 rows


Description

User Presence

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('bus_presence_id_seq'::regclass)
user_id int4 10 √ null
res_users.id bus_presence_user_id_fkey C

Users
status varchar 2147483647 √ null

IM Status
last_poll timestamp 29,6 √ null

Last Poll
last_presence timestamp 29,6 √ null

Last Presence
guest_id int4 10 √ null
mail_guest.id bus_presence_guest_id_fkey C

Guest

Indexes

Constraint Name Type Sort Column(s)
bus_presence_pkey Primary key Asc id
bus_presence_guest_unique Must be unique Asc guest_id
bus_presence_user_unique Must be unique Asc user_id

Check Constraints

Constraint Name Constraint
bus_presence_partner_or_guest_exists ((((user_id IS NOT NULL) AND (guest_id IS NULL)) OR ((user_id IS NULL) AND (guest_id IS NOT NULL))))

Relationships

Close relationships within degrees of separation