projectgroups


Columns

Column Type Size Nulls Auto Default Children Parents Comments
project_id INT 10 null
projects.id projectgroups_ibfk_2 C
group_id INT 10 null
groups.id projectgroups_ibfk_1 C
created_on DATETIME 19 CURRENT_TIMESTAMP
updated_on TIMESTAMP 19 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc project_id + group_id
group_id Performance Asc group_id

Relationships

Close relationships within degrees of separation