0 rows


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

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


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