crm_team

-1 rows


Description

Sales Team

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('crm_team_id_seq'::regclass)
account_move.team_id account_move_team_id_fkey N
crm_team_member.crm_team_id crm_team_member_crm_team_id_fkey C
res_partner.team_id res_partner_team_id_fkey N
res_users.sale_team_id res_users_sale_team_id_fkey N
sale_order.team_id sale_order_team_id_fkey N
team_favorite_user_rel.team_id team_favorite_user_rel_team_id_fkey C
sequence int4 10 √ null

Sequence
company_id int4 10 √ null
res_company.id crm_team_company_id_fkey N

Company
user_id int4 10 √ null
res_users.id crm_team_user_id_fkey N

Team Leader
color int4 10 √ null

Color Index
create_uid int4 10 √ null
res_users.id crm_team_create_uid_fkey N

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

Last Updated by
name jsonb 2147483647 null

Sales Team
active bool 1 √ null

Active
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
invoiced_target float8 17,17 √ null

Invoicing Target

Indexes

Constraint Name Type Sort Column(s)
crm_team_pkey Primary key Asc id
crm_team__company_id_index Performance Asc company_id

Relationships

Close relationships within degrees of separation