Table d45civi_b72v5.civicrm_uf_join Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √  Unique table ID
is_active tinyint 3  √  1 Is this join currently active?
module varchar 64 Module which owns this uf_join instance, e.g. User Registration, CiviDonate, etc.
entity_table varchar 64  √  null Name of table where item being referenced is stored. Modules which only need a single collection of uf_join instances may choose not to populate entity_table and entity_id.
entity_id int unsigned 10  √  null Foreign key to the referenced item.
weight int 10 1 Controls display order when multiple user framework groups are setup for concurrent display.
uf_group_id int unsigned 10
civicrm_uf_group.id FK_civicrm_uf_join_uf_group_id R
Which form does this field belong to.
module_data longtext 2147483647  √  null Json serialized array of data used by the ufjoin.module

Table contained 11 rows at Wed Nov 11 17:12 EST 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
uf_group_id Performance Asc FK_civicrm_uf_join_uf_group_id
entity_table + entity_id Performance Asc/Asc index_entity

Close relationships  within of separation: