res_users_settings_volumes

-1 rows


Description

User Settings Volumes

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('res_users_settings_volumes_id_seq'::regclass)
user_setting_id int4 10 null
res_users_settings.id res_users_settings_volumes_user_setting_id_fkey C

User Setting
partner_id int4 10 √ null
res_partner.id res_users_settings_volumes_partner_id_fkey C

Partner
guest_id int4 10 √ null
res_partner.id res_users_settings_volumes_guest_id_fkey C

Guest
create_uid int4 10 √ null
res_users.id res_users_settings_volumes_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id res_users_settings_volumes_write_uid_fkey N

Last Updated by
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
volume float8 17,17 √ null

Volume

Indexes

Constraint Name Type Sort Column(s)
res_users_settings_volumes_pkey Primary key Asc id
res_users_settings_volumes__guest_id_index Performance Asc guest_id
res_users_settings_volumes__partner_id_index Performance Asc partner_id
res_users_settings_volumes__user_setting_id_index Performance Asc user_setting_id
res_users_settings_volumes_guest_unique Must be unique Asc/Asc user_setting_id + guest_id
res_users_settings_volumes_partner_unique Must be unique Asc/Asc user_setting_id + partner_id

Check Constraints

Constraint Name Constraint
res_users_settings_volumes_partner_or_guest_exists ((((partner_id IS NOT NULL) AND (guest_id IS NULL)) OR ((partner_id IS NULL) AND (guest_id IS NOT NULL))))

Relationships

Close relationships within degrees of separation