Table d45civi_b72v5.civicrm_case_type 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  √ 
civicrm_case.case_type_id FK_civicrm_case_case_type_id N
Autoincremented type id
name varchar 64 Machine name for Case Type
title varchar 64 Natural language name for Case Type
description varchar 255  √  null Description of the 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

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

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

Close relationships  within of separation: