crm_team_member

-1 rows


Description

Sales Team Member

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('crm_team_member_id_seq'::regclass)
crm_team_id int4 10 null
crm_team.id crm_team_member_crm_team_id_fkey C

Sales Team
user_id int4 10 null
res_users.id crm_team_member_user_id_fkey C

Salesperson
create_uid int4 10 √ null
res_users.id crm_team_member_create_uid_fkey N

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

Last Updated by
active bool 1 √ null

Active
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
crm_team_member_pkey Primary key Asc id
crm_team_member__crm_team_id_index Performance Asc crm_team_id
crm_team_member__user_id_index Performance Asc user_id

Relationships

Close relationships within degrees of separation