project_plg_recipient


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
plg_id BIGINT 19 null
project_plg.id FK_project_plg_recipient_project_plg R
role_id INT 10 √ null
sys_roles.role_id FK_project_plg_recipient_role R
user_id INT 10 √ null
sys_users.user_id FK_project_plg_recipient_user R
contact_id INT 10 √ null
contact.contact_id FK_project_plg_recipient_contact R
email VARCHAR 256 √ null
round_id BIGINT 19 √ null
project_plg_round.id FK_project_plg_recipient_round R
system_added BIT 11 √ null
is_removable BIT 1 √ null
role_name VARCHAR 256 √ null
user_name VARCHAR 256 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_project_plg_recipient_contact Performance Asc contact_id
FK_project_plg_recipient_project_plg_idx Performance Asc plg_id
FK_project_plg_recipient_role Performance Asc role_id
FK_project_plg_recipient_round_idx Performance Asc round_id
FK_project_plg_recipient_user Performance Asc user_id

Relationships

Close relationships within degrees of separation