Table d47civi_0z3xa.civicrm_print_label 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  √ 
title varchar 255  √  null User title for for this label layout
name varchar 255  √  null variable name/programmatic handle for this field.
description text 65535  √  null Description of this label layout
label_format_name varchar 255  √  null This refers to name column of civicrm_option_value row in name_badge option group
label_type_id int unsigned 10  √  null Implicit FK to civicrm_option_value row in NEW label_type option group
data longtext 2147483647  √  null contains json encode configurations options
is_default tinyint 3  √  1 Is this default?
is_active tinyint 3  √  1 Is this option active?
is_reserved tinyint 3  √  1 Is this reserved label?
created_id int unsigned 10  √  null
civicrm_contact.id FK_civicrm_print_label_created_id N
FK to civicrm_contact, who created this label layout

Table contained 0 rows at mer. avr. 13 16:52 EDT 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
created_id Performance Asc FK_civicrm_print_label_created_id

Close relationships  within of separation: