team_memberships

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

CHAR

36

null

team_id

CHAR

36

√

null

Defined in XMLR

user_id

CHAR

36

√

null

Defined in XMLR

explicit_assign

BIT

1

√

0

implicit_assign

BIT

1

√

0

date_modified

DATETIME

19

√

null

deleted

BIT

1

√

0

Showing 1 to 7 of 7 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
idx_del_team_user	Performance	Asc/Asc/Asc	deleted + team_id + user_id
idx_team_membership	Performance	Asc/Asc	user_id + team_id
idx_teammemb_team_user	Performance	Asc/Asc	team_id + user_id

Showing 1 to 4 of 4 entries

Relationships

Close relationships within degrees of separation

One
Two degrees