project_plg_signature


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
signature_id BIGINT 19 null
project_plg_required_signature.id FK_project_plg_signature_signature R
role_id INT 10 √ null
sys_roles.role_id FK_project_plg_signature_role R
date_signed DATETIME 19 √ null
user_id INT 10 √ null
sys_users.user_id FK_project_plg_signature_user R
user_name VARCHAR 256 √ null
image_id BIGINT 19 √ null
project_file.id FK_project_plg_signature_image R
email VARCHAR 256 √ null
company_id INT 10 √ null
company_name TEXT 65535 √ null
contact_id INT 10 √ null
contact.contact_id FX_project_plg_signature_contact R
is_upload_file BIT 1 √ b'0'
role_name VARCHAR 256 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_project_plg_signature_image Performance Asc image_id
FK_project_plg_signature_role Performance Asc role_id
FK_project_plg_signature_signature_idx Performance Asc signature_id
FK_project_plg_signature_user Performance Asc user_id
FX_project_plg_signature_company_idx Performance Asc company_id
FX_project_plg_signature_contact_idx Performance Asc contact_id

Relationships

Close relationships within degrees of separation