Facetoface Session Roles Table Schema (facetoface_session_roles)


Description

Users with a trainer-like role in a seminar event

facetoface_session_roles table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null

id of the table
sessionid BIGINT 19 null
facetoface_sessions.id facesessrole_ses2_fk R
roleid BIGINT 19 null
role.id Implied Constraint R
userid BIGINT 19 null
user.id facesessrole_use2_fk R

Table contained -1 rows

facetoface_session_roles table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
facesessrole_ses_ix Performance Asc sessionid
facesessrole_use_ix Performance Asc userid

facetoface_session_roles table relationships

Close relationships within degrees of separation