civicrm_case_type


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_case.case_type_id FK_civicrm_case_case_type_id R

Autoincremented type id

name VARCHAR 64 null

Machine name for Case Type

is_active TINYINT 3 null

Is this entry active?

is_reserved TINYINT 3 null

Is this case type a predefined system type?

weight INT 10 1

Ordering of the case types

definition BLOB 65535 null

xml definition of case type

title_en_US VARCHAR 64 null
description_en_US VARCHAR 255 null
title_fr_CA VARCHAR 64 null
description_fr_CA VARCHAR 255 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
case_type_name Must be unique Asc name

Relationships