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