civicrm_print_label


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
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

Indexes

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

Relationships